开发者

More than one table in SQLite database in android?

I am facing problem in creating more than one tables in sqllite database in android. Here is my code

   public class DataHelper {
   private static final String DATABASE_NAME = "example.db";
   private static final int DATABASE_VERSION = 1;
   private static final String TABLE_NAME = "table1";
   private static final String SETTING_TABLE="setting";

   private Context context;
   private SQLiteDatabase db;

   private SQLiteStatement insertStmt;
   private static final String INSERT = "insert into " + TABLE_NAME + 
       "(name) values (?)";
   private static final String INSERTSETTING = "insert into " + SETTING_TABLE +
       "(name) values (?)";

   public DataHelper(Context context) {
      this.context = context;
      OpenHelper openHelper = new OpenHelper(this.context);
      this.db = openHelper.getWritableDatabase();
      this.insertStmt = this.db.compileStatement(INSERT);
      this.insertStmt = this.db.compileStatement(INSERTSETTING);
   }

   public SQLiteDatabase getDb() {
      return this.db;
   }

   public long insert(String name) {
      this.insertStmt.bindString(1, name);
      return this.insertStmt.executeInsert();
   }   
   private static class OpenHelper extends SQLiteOpenHelper {
      OpenHelper(Context context) {
         super(context, DATABASE_NAME, null, DATABAS开发者_开发问答E_VERSION);
      }
      @Override
      public void onCreate(SQLiteDatabase db) {
         db.execSQL("CREATE TABLE " + TABLE_NAME + 
              " (id INTEGER PRIMARY KEY, name TEXT)");
         db.execSQL("CREATE TABLE " + SETTING_TABLE + 
              " (id INTEGER PRIMARY KEY, name TEXT)");
      }
      @Override
      public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)
      {
         db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME);
         onCreate(db);
      }
   }
}


Increase the value of DATABASE_VERSION, otherwise onUpgrade won't get called.

I notice you don't drop the SETTING_TABLE in onUpgade, and you're losing the first insert statement at the top of your code, as you replace INSERT with INSERTSETTING.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜