private static final String TAG = "DatabaseHelper";
private DatabaseHelper dbOpenHelper=null;
public DatabaseHelper(Context context) {
super(context, "test.db", null, 1);
}
@Override
public void onCreate(SQLiteDatabase db) {
//1.创建第一个数据表
db.execSQL("create table tiku(id integer primary key," +
"imgsrc varchar(70)," +
"key varchar(30)," +
"keynum integer," +
"preparekey varchar(200)," +
"achievement varchar(500));");
//创建第二个数据表
db.execSQL("CREATE TABLE userinfo (userid integer primary key," +
"checkpoints integer," +
"jinbi integer," +
"buyjinbi integer);");
}
第一个数据表可以创建成功,并且可以在onCreate()方法中初始化数据,可是第二个表就创建不了?求大神指教
没用啊
追答有LOG贴出来看一下?
sql指令串不能出现一点错误,很可能就是一个符号是在中文输入法下输入的导致执行失败