csSEqrHs

1private class SQLiteHelper extends SQLiteOpenHelper {
2    private static final String TAG = "SQLiteHelper";
3    private String DATABASE_CREATE = "CREATE TABLE IF NOT EXISTS "
4            + helper.getTableName() + "(" + helper.getTableColumns() + ");";
5
6
7    public SQLiteHelper(Context context) {
8        super(context, helper.getDatabaseName(), null, helper
9                .getDatabaseVersion());
10    }
11
12    @Override
13    public void onCreate(SQLiteDatabase db) {
14        db.execSQL(DATABASE_CREATE);
15        Log.d(TAG, "database created");
16
17    }
18
19    @Override
20    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
21        Log.w(TAG, "Upgrading database from version " + oldVersion + " to "
22                + newVersion + ", which will destroy all old data");
23        db.execSQL("DROP TABLE IF EXISTS " + helper.getTableName());
24        onCreate(db);
25    }
26
27}
28	
29public ProductDB(Context context, IDatabaseHelper helper) {
30    this.context = context;
31    this.helper = helper;
32}
33	
34SQLiteDatabase db;
35 SQLiteHelper dbHelper = new SQLiteHelper(context);
36 db = dbHelper.getWritableDatabase();
37
38        db.execSQL("CREATE TABLE IF NOT EXISTS "
39            + helper.getTableName() + "(" + helper.getTableColumns() + ")");