把这句: db.execSQL("DROP TABLE IF EXISTS" + TABLE_NAME + ";"); 修改成 db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME + ";");
谢谢各位,这个问题解决了,可是还有个问题,android.database.sqlite.SQLiteException: no such column: asd (code 1): , while compiling: SELECT * FROM users WHERE name=asd 说是下面这个方法错误 public int findUserByName(String name) { System.out.println("findUserByName~~name=" + name); int result = 0; Cursor mCursor = mDatabase.query(TABLE_NAME, null, NAME + "=" + name, null, null, null, null); if (mCursor != null) { result = mCursor.getCount(); mCursor.close(); System.out.println("findUserByName~~result=" + result); } return result; }
Cursor mCursor = mDatabase.query(TABLE_NAME, null, NAME + "=" + name, null, null, null, null); 改成 Cursor mCursor = mDatabase.query(TABLE_NAME, null, NAME + "=?", new String[]{name}, null, null, null);
db.execSQL("DROP TABLE IF EXISTS" + TABLE_NAME + ";");
修改成
db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME + ";");
说是下面这个方法错误
public int findUserByName(String name) {
System.out.println("findUserByName~~name=" + name);
int result = 0;
Cursor mCursor = mDatabase.query(TABLE_NAME, null, NAME + "=" + name,
null, null, null, null);
if (mCursor != null) {
result = mCursor.getCount();
mCursor.close();
System.out.println("findUserByName~~result=" + result);
}
return result;
}
null, null, null, null);
改成
Cursor mCursor = mDatabase.query(TABLE_NAME, null, NAME + "=?",
new String[]{name}, null, null, null);