Android 数据库sqlite一次创建多个表?
我想在数据库中一次性建立多个表,可是为什么只能建立第一个,运行到第二个的时候程序就强退呢?
public class DatabaseHelper extends SQLiteOpenHelper{
public DatabaseHelper(Context context, String name, CursorFactory factory,
int version) {
//必须通过super调用父类当中的构造函数
super(context, name, factory, version);
// TODO Auto-generated constructor stub
}
@Override
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
db.execSQL("create table table1 (name varchar(20),pw varchar(20))");
db.execSQL("create table table2(id int,a long,b long,c long)");
db.execSQL("create table table3(id int,a long,b long,c long)");
db.execSQL("create table table4(id int,a long,b long,c long)");
db.execSQL("create table table5(id int,a long,b long,c long)");
db.execSQL("create table table6(id int,a long,b long,c long)");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// TODO Auto-generated method stub
}
}