i405817461 2013-06-07 02:33 采纳率: 0%
浏览 2882

在更新和删除SQLite数据库时报错NullPointerException

我的Activity首先打开了数据库。

private DBAdapter dbAdepter;

dbAdepter = new DBAdapter(this);
    dbAdepter.open();

然后更新操作如下:

public class Heimingdan_Alter extends Activity {

private DBAdapter dbAdepter;

private EditText editname;
private EditText edittelephone;
private Button update1;
private Button delete;

private String name,phone,id,name0,telephone0;
//public int id;
public void onCreate(Bundle savedInstanceState){
    super.onCreate(savedInstanceState);
     //设置无标题
    requestWindowFeature(Window.FEATURE_NO_TITLE);
    setContentView(R.layout.fix_blacklist);

    dbAdepter = new DBAdapter(this);
    dbAdepter.open();


    //MyApplication.getInstance().addActivity(this);
    editname=(EditText)findViewById(R.id.hmd_name);
    edittelephone=(EditText)findViewById(R.id.hmd_num);
    update1=(Button)findViewById(R.id.ensure);
    delete=(Button)findViewById(R.id.delete);

    Intent i = getIntent();
    telephone0=i.getStringExtra("telephone");
    name0=i.getStringExtra("name");
    id=i.getStringExtra("id");

    editname.setText(i.getStringExtra("name"));
    edittelephone.setText(i.getStringExtra("telephone"));

    //更新事件
    update1.setOnClickListener(new OnClickListener() {
        public void onClick(View arg0) {
            name=editname.getText().toString();
            phone=edittelephone.getText().toString();
            if(name.equals("")||phone.equals("")){
                Toast.makeText(Heimingdan_Alter.this, "您输入的信息不完整哦~",Toast.LENGTH_LONG).show();
            }
            else {


                BlackNumber blacknumber = new BlackNumber();
                BlackNumber blacknumber2 = new BlackNumber();
                blacknumber.telephone = phone;
                blacknumber.name = name;
                Log.v("更新的黑名单值", blacknumber.telephone+blacknumber.name);

                blacknumber2.telephone = telephone0;
                blacknumber2.name = name0;
                Log.v("以前的黑名单值", blacknumber2.telephone+blacknumber2.name);


                    dbAdepter.updateblack(id,blacknumber,blacknumber2);




                onBackPressed();
                Toast.makeText(Heimingdan_Alter.this, "修改成功!", Toast.LENGTH_LONG).show();


            }
        }
    });
}

然后在DBAdapter.java中如下

public void open() throws SQLiteException {

    try {
        db = dbOpenHelper.getWritableDatabase();
        Log.v("DBAdapter_Open_getWritableDatabase",
                "DBAdapter_Open_getWritableDatabase");
    } catch (SQLiteException ex) {
        db = dbOpenHelper.getReadableDatabase();
        Log.v("DBAdapter_Open_getReadableDatabase",
                "DBAdapter_Open_getReadableDatabase");
    }
}
public int updateblack(String id,BlackNumber blacknumber, BlackNumber blacknumber2) {
    ContentValues newValues = new ContentValues();
    Log.e("updateblack",blacknumber.name + blacknumber.telephone+ "from"  + blacknumber2.telephone);
    newValues.put("name", blacknumber.name);
    newValues.put("telephone", blacknumber.telephone);

    int _id=Integer.parseInt(id);

    int colunm = db.update("blacklist", newValues, "_id" + "=" + _id , null);




    Log.e("updateblacksuccess", blacknumber.name + ":" + blacknumber.telephone
            + "from"  + blacknumber2.name);
    return colunm;

}

其中BlackNumber是一个含有两个String(name,telephone)和一个int(id)的类。

每次调试都说是
int colunm = db.update("blacklist", newValues, "_id" + "=" + _id , null);
这一行出错。
但是调试log信息表示id得到了也是对的。blacklist名字也没错。这一行我加到插入的方法里就好使,但是到这里就报错。是个什么问题?
求大神

  • 写回答

1条回答

  • kity 2013-06-07 06:19
    关注

    输出下你的 db, blacknumber, blacknumber2 三个对象,检查下是否为空

    评论

报告相同问题?

悬赏问题

  • ¥50 树莓派安卓APK系统签名
  • ¥15 maple软件,用solve求反函数出现rootof,怎么办?
  • ¥65 汇编语言除法溢出问题
  • ¥15 Visual Studio问题
  • ¥20 求一个html代码,有偿
  • ¥100 关于使用MATLAB中copularnd函数的问题
  • ¥20 在虚拟机的pycharm上
  • ¥15 jupyterthemes 设置完毕后没有效果
  • ¥15 matlab图像高斯低通滤波
  • ¥15 针对曲面部件的制孔路径规划,大家有什么思路吗