SQLite AUTO_INCREMENT

Question

我的表是这样创建的：

    db.execSQL("CREATE TABLE reminder (" +
            "id INTEGER PRIMARY_KEY AUTO_INCREMENT," +
            "title VARCHAR(100)," +
            "content VARCHAR(500)," +
            "due LONG," +
            "alarm LONG," +
            "priority INT" +
            ");");

和由以下机构插入的值：

    ContentValues cv=new ContentValues();
    cv.put("title",t.title);
    cv.put("content",t.content);
    cv.put("due",t.date.getTimeInMillis());
    cv.put("alarm",(t.alarm==null?0L:t.alarm.getTimeInMillis()));
    cv.put("priority",t.severity);
    SQLiteDatabase d=getWritableDatabase();
    d.insert("reminder",null, cv);
    d.close();

但当我试图通过以下方式获得我的价值观时：

        Task task=new Task();
        task.id=c.getInt(0);
        task.title=c.getString(1);
        task.content=c.getString(2);
        Calendar due=new GregorianCalendar();
        due.setTimeInMillis(c.getLong(3));
        task.date=due;
        if(c.getLong(4)!=0){
            Calendar alert=new GregorianCalendar();
            alert.setTimeInMillis(c.getLong(4));
            task.alarm=alert;
        }
        task.severity=c.getInt(5);
        return task;

我总是得到等于零的id。知道怎么修吗？

Answer 1

下划线有点不合适。试试id INTEGER PRIMARY KEY AUTOINCREMENT。

SQLite理解的SQL -创建表

Answer 2

请试用此解决方案：

db.execSQL("CREATE TABLE reminder (" +
            "'_id' INTEGER PRIMARY_KEY AUTO_INCREMENT," +
            "title VARCHAR(100)," +
            "content VARCHAR(500)," +
            "due LONG," +
            "alarm LONG," +
            "priority INT" +
            ");");

更改了_id的id。