java Android孤子错误

Question

01-22 21:43:23.703: E/AndroidRuntime(30859): FATAL EXCEPTION: main 01-22 21:43:23.703: E/AndroidRuntime(30859): Process: com.it.heritageireland, PID: 30859 01-22 21:43:23.703: E/AndroidRuntime(30859): java.lang.RuntimeException: Unable to start activity ComponentInfo{com.it.heritageireland/com.it.heritageireland.Favourites}: 安卓.database.sqlite.SQLiteException: near ")": syntax error (code 1): , while compiling: CREATE TABLE products(_id INTEGER PRIMARY KEY AUTOINCREMENT ,productname TEXT, ) 01-22 21:43:23.703: E/AndroidRuntime(30859): at 安卓.app.ActivityThread.performLaunchActivity(ActivityThread.java:2394) 01-22 21:43:23.703: E/AndroidRuntime(30859): at 安卓.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2452)

我在S5上加载安卓应用程序时出现上述错误，但在我的索尼T上运行良好

有什么想法吗

谢谢你的关注

public void onCreate(SQLiteDatabase db) {
    // create statement for making the table - the table is called inventory
    String DATABASE_CREATE = "CREATE TABLE " + TABLE_PRODUCTS +"("+
            COLUMN_ID +" INTEGER PRIMARY KEY AUTOINCREMENT ," +
            COLUMN_PRODUCTNAME +" TEXT " +
            ")";

    db.execSQL(DATABASE_CREATE);

}

Answer 1

在)后面加一个分号。比如最后一行的");";。 完整的查询应该是这样的：

String DATABASE_CREATE = "CREATE TABLE " + TABLE_PRODUCTS +"("+
        COLUMN_ID +" INTEGER PRIMARY KEY AUTOINCREMENT ," +
        COLUMN_PRODUCTNAME +" TEXT " +
        ");";