                        课程
                    
                        /移动开发
                        
                            /Android
                        
                        /Android基础-初识SQLite

我执行了插入语句可是数据库没有插入数据

public void click(View view){
switch (view.getId()){
case R.id.btn_insert:
SQLiteDatabase db=sql.getWritableDatabase();
String sql1="insert into "+ Costant.TABLE_NAME+"values(1,'张三',20) ";
Dbmanager.execSQL(db,sql1);
String sql2="insert into "+ Costant.TABLE_NAME+"values(2,'lisi',21) ";
Dbmanager.execSQL(db,sql2);
db.close();
break;
}
}

饭宝宝

2016-12-08

源自：Android基础-初识SQLite 2-3

关注问题我要回答

2531

操作

收起

2 回答

QY623873362
2017-01-02

我也是执行了插入语句，结果没有插入成功。而且跑飞了！

switch (view.getId()){
case R.id.btn_insert:
SQLiteDatabase db=mhelper.getWritableDatabase();
String sql="insert into person values(1,'zhangsan',20)";
DbManger.execSQL(db,sql);
String sql2="insert into "+
Constant_changlianglei.TABLE_NAME+
"values(2,'lisi',25)";
DbManger.execSQL(db,sql2);
db.close();
break;

报的为调用目标异常：

Caused by: java.lang.reflect.InvocationTargetException