this my databasehelper
我databasehelper
public class DBHelper extends SQLiteOpenHelper {
private static final int DATABASE_VERSION = 4;
private static final String DATABASE_NAME = "organizer.db";
public DBHelper(Context context){
super(context, DATABASE_NAME, null, DATABASE_VERSION);
}
@Override
public void onCreate(SQLiteDatabase db){
**String CREATE_TABLE_PROJECT = "CREATE TABLE" + Project.TABLE + "("
+ Project.KEY_ID + "INTEGER PRIMARY KEY AUTOINCREMENT,"
+ Project.KEY_title + "TEXT,"
+ Project.KEY_type + "TEXT,"
+ Project.KEY_priority + "INTEGER,"
+ Project.KEY_timeframe + "TEXT,"
+ Project.KEY_start + "TEXT,"
+ Project.KEY_end + "TEXT,"
+ Project.KEY_cost + "INTEGER,"
+ Project.KEY_status + "TEXT" +");";
db.execSQL(CREATE_TABLE_PROJECT);**
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion){
db.execSQL("DROP TABLE IF EXIST" + Project.TABLE);
onCreate(db);
}
}
publ