【文件属性】:
文件名称:表格的增删改查
文件大小:47KB
文件格式:RAR
更新时间:2016-12-09 13:41:50
增删改查
case R.id.btn_add:
String msg_add = ed_msg.getText().toString();
User user_add = new User(msg_add, null);
UserDao userDao_add = new UserDao(user_add, act);
if (userDao_add.add() > 0) {
Toast.makeText(act.getApplicationContext(), "添加成功",
Toast.LENGTH_LONG).show();
}
break;
case R.id.btn_check:
User user_check = new User(null, null);
UserDao userDao_check = new UserDao(user_check, act);
Cursor cursor = userDao_check.select();
String str = "";
if (cursor.moveToFirst()) {
do {
int d = cursor.getColumnIndex(MyDatabase.KEY_ID);
String id = cursor.getString(d);
int columnIndex = cursor
.getColumnIndex(MyDatabase.KEY_NAME);
String s = cursor.getString(columnIndex);
str = str + id + "\t" + s + "\n";
} while (cursor.moveToNext());
tv_msg.setText(str);
}
break;
case R.id.btn_amend:
String msg_update = ed_msg.getText().toString();
String id = ed_id.getText().toString();
if (msg_update.equals("")) {
Toast.makeText(act, "ID不能为空", Toast.LENGTH_LONG).show();
return;
}
User user_update = new User(msg_update, id);
// int id_update = Integer.parseInt(id);
UserDao userDao_update = new UserDao(user_update, act);
if (userDao_update.updata() > 0) {
Toast.makeText(act.getApplicationContext(), "修改成功",
Toast.LENGTH_LONG).show();
}
break;
case R.id.btn_delete:
String id_delete = ed_id.getText().toString();
User user_delete = new User(null, id_delete);
if (id_delete.equals("")) {
Toast.makeText(act, "ID不能为空", Toast.LENGTH_LONG).show();
return;
}
UserDao userDao_delete = new UserDao(user_delete, act);
if (userDao_delete.delete() > 0) {
Toast.makeText(act.getApplicationContext(), "删除成功",
Toast.LENGTH_LONG).show();
}
;
【文件预览】:
增删改查
----.project(840B)
----project.properties(563B)
----src()
--------cn()
----AndroidManifest.xml(724B)
----res()
--------drawable-ldpi()
--------drawable-hdpi()
--------drawable-mdpi()
--------layout()
--------drawable-xhdpi()
--------values()
----assets()
----gen()
--------cn()
----.classpath(364B)
----proguard-project.txt(781B)
----bin()
--------classes()
--------AndroidManifest.xml(724B)
--------res()