Android中数据库常见操作实例分析

setContentView(R.layout.activity_main); queryOne = (Button) findViewById(R.id.queryOne);

insert = (Button) findViewById(R.id.insert); update = (Button) findViewById(R.id.update);

delete = (Button) findViewById(R.id.delete); findAll = (Button) findViewById(R.id.findAll);

queryOne.setOnClickListener(new ButtonListener()); insert.setOnClickListener(new ButtonListener());

update.setOnClickListener(new ButtonListener()); delete.setOnClickListener(new ButtonListener());

findAll.setOnClickListener(new ButtonListener()); service = new DBService(this);

} class ButtonListener implements View.OnClickListener {

@Override public void onClick(View v) {

switch (v.getId()) { case R.id.queryOne:

// service.find("loonggg"); service.findAndroid("loonggg");

break; case R.id.insert:

// service.add("1", "loonggg"); service.addAndroid("2", "heihei");

break; case R.id.update:

// service.update("1", "timmy"); service.updateAndroid("1", "haha");

break; case R.id.delete:

// service.delete("timmy"); service.deleteAndroid("heihei");

break; case R.id.findAll:

// service.findAll(); service.findAllAndroid();

break; default:

break; }

} }

}