예제 #1
0
 private SQLite create()
 {
     if (textFile.Text == "")
     {
         MessageBox.Show("请选择文件");
         return null;
     }            
     try
     {
         SQLite r = new SQLite();
         r.open(textFile.Text);
         if (textKey.Text != "")
         {
             r.key(textKey.Text);
         }
         string sql;
         sql = "create table if not exists files(path TEXT PRIMARY KEY, content BLOB, time INTEGER);";
         r.doExec(sql);
         sql = "create table if not exists dirs(path TEXT PRIMARY KEY, orderkey INTEGER);";
         r.doExec(sql);
         return r;
     }
     catch (Exception e)
     {
         MessageBox.Show("打开错误:" + e.Message);
         return null;
     }
 }