无法在SQLite Android中创建列

Question

我有这样一个问题：

/SQLITELOG:(1)表ds_sinhvien没有名为id的列

我不知道如何修复这个，这是我的dbhelper：

public class StudentDbHelper extends SQLiteOpenHelper {
    private static final int DATABASE_VERSION = 2;
    private static final String DATABASE_NAME = "dbStudent";
    private static final String TB_STUDENT = "ds_sinhvien";
    private static final String KEY_ID = "id";
    private static final String KEY_NAME = "name";
    private static final String KEY_CLASS = "class";
    public StudentDbHelper(Context context)
    {
        super(context, DATABASE_NAME, null, DATABASE_VERSION);
    }
    @Override
    public void onCreate(SQLiteDatabase db)
    {
// TODO Auto-generated method stub
// tạo table
        String SQL_String = String.format("CREATE TABLE %s(%sINTEGER PRIMARY KEY, %s TEXT, %s TEXT)", TB_STUDENT,KEY_ID, KEY_NAME, KEY_CLASS);
        db.execSQL(SQL_String);
    }
    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)
    {
        // TODO Auto-generated method stub
        db.execSQL("DROP TABLE IF EXISTS " + TB_STUDENT);
// Create tables again
        onCreate(db);
    }
    public void insertStudent(Student student)
    {
        SQLiteDatabase db = this.getWritableDatabase();
        String nullColumnHack = null; // Allow null value
        ContentValues values = new ContentValues();
        if (student.getId() != -1)
        {
            values.put(KEY_ID, student.getId());
            values.put(KEY_NAME, student.getName());
            values.put(KEY_CLASS, student.getClassName());
            db.insert(TB_STUDENT, null, values);
        }
        db.close();
    }

谢谢你帮我，我已经修了很长时间了。

Answer 1

%sINTEGER

这使得列名为idinteger。添加名称和类型之间缺少的空格。然后，您可以卸载应用程序以删除具有该不正确列名的旧数据库，并使oncreate()再次执行。