public class MySQLiteOpenHelper extends SQLiteOpenHelper{
static String name = "testdb.sqlite";
static CursorFactory factory = null;
static int version = 1;
public MySQLiteOpenHelper(Context context) {
super(context, name, factory, version);
// TODO Auto-generated constructor stub
}
@Override
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
String query = "CREATE TABLE myinfo ( " +
"_id INTEGER PRIMARY KEY autoincrement, " +
"name TEXT , " +
"sex TEXT , " +
"age INTEGER NOT NULL DEFAULT (0) , " +
"savetime DATETIME DEFAULT (date('now')))";
db.execSQL(query);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// TODO Auto-generated method stub
String query = "DROP TABLE IF EXISTS myinfo";
db.execSQL(query);
onCreate(db);
}
}
제가 공부중인데요
onCreate에 CREATE 쿼리가 들어가서 여기는 테이블 생성하고 onUpdate엔 DROP이 들어가서 여기는 테이블을 삭제하는 것이 맞나요?
위에
static String name = "testdb.sqlite";
static CursorFactory factory = null;
static int version = 1;
부분은 뭐 하는 부분인가요?