SQLiteDatabase db=this.openOrCreateDatabase("mapTest.db", MODE_PRIVATE, null);//打开已经存在的数据库
2 //数据库这边有问题
3 try
4 {
5 String CREATE_TABLE = "CREATE TABLE table1 (_id INTEGER PRIMARY KEY, name TEXT ,phone TEXT,site TEXT)";
6 Toast.makeText(MainActivity.this, "cursor1", Toast.LENGTH_SHORT).show();
7 db.execSQL(CREATE_TABLE);//在数据库db中,创建表
8 Toast.makeText(MainActivity.this, "cursor1_end", Toast.LENGTH_SHORT).show();
9 for(int i=0;i<16;i++){
10 String INSERT_DATA = "INSERT INTO table1 (name,phone,site) values ('insertName'+ i, 'insertPhone'+ i, 'insertSite'+ i)" ;
11 db.execSQL(INSERT_DATA);
12 }
13 db.close();//使用SQLiteDatabase数据库要及时关闭(close), 否则可能会抛出SQLiteException异常。!!!!!!!!!!!!!!!!!!!!!!
14 }
15 catch(Exception ex)
16 {
17 Toast.makeText(MainActivity.this, "Create Table error,table exists.", Toast.LENGTH_SHORT).show();
18 }
大家看下上面的代码哪里错了?感觉没问题啊!!toast显示:先“cursor1”,然后就。。挂了“Create table error”。cursor1_end居然没有出现。蛋疼有木有
Android
2 //数据库这边有问题
3 try
4 {
5 String CREATE_TABLE = "CREATE TABLE table1 (_id INTEGER PRIMARY KEY, name TEXT ,phone TEXT,site TEXT)";
6 Toast.makeText(MainActivity.this, "cursor1", Toast.LENGTH_SHORT).show();
7 db.execSQL(CREATE_TABLE);//在数据库db中,创建表
8 Toast.makeText(MainActivity.this, "cursor1_end", Toast.LENGTH_SHORT).show();
9 for(int i=0;i<16;i++){
10 String INSERT_DATA = "INSERT INTO table1 (name,phone,site) values ('insertName'+ i, 'insertPhone'+ i, 'insertSite'+ i)" ;
11 db.execSQL(INSERT_DATA);
12 }
13 db.close();//使用SQLiteDatabase数据库要及时关闭(close), 否则可能会抛出SQLiteException异常。!!!!!!!!!!!!!!!!!!!!!!
14 }
15 catch(Exception ex)
16 {
17 Toast.makeText(MainActivity.this, "Create Table error,table exists.", Toast.LENGTH_SHORT).show();
18 }
大家看下上面的代码哪里错了?感觉没问题啊!!toast显示:先“cursor1”,然后就。。挂了“Create table error”。cursor1_end居然没有出现。蛋疼有木有
Android
CREATE TABLE table1 (_id INTEGER PRIMARY KEY, name TEXT ,phone TEXT,site TEXT);"