阅读背景:

引起的:android.database.sqlite。SQLiteException:临近“TABLEProject”:语法错误(代码1):,编译时:

来源:互联网 

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



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: