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

* * @param name

*/ public void delete(String name) {

SQLiteDatabase db = dbHelper.getWritableDatabase(); db.execSQL("delete from user_table where userName = ?",

new String[] { name }); db.close();

} public int deleteAndroid(String name) {

SQLiteDatabase db = dbHelper.getWritableDatabase(); int result = db.delete(Table.USER_INFO_TB_NAME, "userName = ?",

new String[] { name });// 返回值为受影响的行数，大于0代表成功 db.close();

return result; }

/** * 返回所有的数据库信息

* * @return

*/ public List<HashMap<String, String>> findAll() {

List<HashMap<String, String>> list = null; SQLiteDatabase db = dbHelper.getReadableDatabase();

Cursor cursor = db.rawQuery("select * from user_table", null); if (cursor.getCount() > 0) {

list = new ArrayList<HashMap<String, String>>(); while (cursor.moveToNext()) {

String id = cursor.getString(cursor.getColumnIndex("userId")); String name = cursor.getString(cursor

.getColumnIndex("userName")); HashMap<String, String> map = new HashMap<String, String>();

map.put("id", id); map.put("name", name);

list.add(map); }

} cursor.close();

db.close(); return list;

} public List<HashMap<String, String>> findAllAndroid() {

List<HashMap<String, String>> list = null; SQLiteDatabase db = dbHelper.getReadableDatabase();

Cursor cursor = db.query(Table.USER_INFO_TB_NAME, new String[] { "userId", "userName" }, null, null, null, null, null);