android - 双引号未正确关闭字符串文字

Question

大家好 ;)我有以下代码:

private void onCreateDBAndDBTables(){
 myDB = this.openOrCreateDatabase("Projects", MODE_PRIVATE, null);
 myDB.execSQL("CREATE TABLE IF NOT EXISTS " + MY_DB_TABLE 
   + "( _id integer primary key autoincrement
     name varchar (16),
     comment varchar (128),
     customer_project boolean,
     booking_details varchar (225),
     editable boolean )"  
       +";");
}

它显示了标题中提到的错误。我希望你能在这里帮助我，因为我不知道出了什么问题......~山姆~

Answer 1

您需要连接的字符串中的每一行:

private void onCreateDBAndDBTables(){
 myDB = this.openOrCreateDatabase("Projects", MODE_PRIVATE, null);
 myDB.execSQL("CREATE TABLE IF NOT EXISTS " + MY_DB_TABLE +
              "( _id integer primary key," +
              "name varchar (16)," +
              "comment varchar (128)," +
              "customer_project boolean," +
              "booking_details varchar (225)," +
              "editable boolean )" +  
              ";");
}

* 更新 *

我还注意到您使用的是 SQLite3，所以我稍微更新了 SQL - 删除了 autoincrement。

查看这篇关于 SQLite3 中自动增量如何工作的文章:

http://www.sqlite.org/faq.html#q1