java - 在android上使用SQLITE出现列约束错误

Question

我正在尝试设置一个数据库并分别命名列，但我在第 16 行收到错误，其中 PRIMARY KEY 为“')' 或逗号预期为 '_title'

public class MyDBHandler extends SQLiteOpenHelper{
    private static final int DATABASE_VERSION=1;
    private static final String DATABASE_NAME="movies.db";
    public static final String TABLE_PRODUCTS="_movies";
    public static final String COLUMN_ID="_id";
    public static final String COLUMN_TITLE="_title";
    public static final String COLUMN_DATERELEASED="_dateReleased";
    public static final String COLUMN_FILENAME="_fileName";
    public MyDBHandler(Context context, String name, SQLiteDatabase.CursorFactory factory, int version) {
        super(context, name, factory, version);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        //INFORMATION ABOUT EACH COLUMN FOR THE TABLE
        String query="CREATE TABLE "+TABLE_PRODUCTS+"("+
                COLUMN_ID+" INTEGER PRIMARY KEY AUTOINCREMENT "+
                COLUMN_TITLE+" TEXT "+
                COLUMN_DATERELEASED+"TEXT "+
                COLUMN_FILENAME+" TEXT "
                +" ); ";
        db.execSQL(query);
    } 

Answer 1

您的查询错误，您忘记设置逗号。您的查询是这样的

@Override
    public void onCreate(SQLiteDatabase db) {
        //INFORMATION ABOUT EACH COLUMN FOR THE TABLE
        String query="CREATE TABLE "+TABLE_PRODUCTS+"("+
                COLUMN_ID+" INTEGER PRIMARY KEY AUTOINCREMENT, "+
                COLUMN_TITLE+" TEXT, "+
                COLUMN_DATERELEASED+"TEXT, "+
                COLUMN_FILENAME+" TEXT "
                +" ); ";
        db.execSQL(query);
    }