android 操作数据库使用系统方法完成增删改查
private NoteSQLiteOpenHelper helper;
public void NoteDao2(Context context){
helper = new NoteSQLiteOpenHelper(context);
}
public boolean add(String name , float money){
SQLiteDatabase db = helper.getWritableDatabase();
ContentValues values = new ContentValues();
values.put("name", name);
values.put("money",money);
long rawid = db.insert("account", null, values);
db.close();
if(rawid>0){
return true;
}else{
return false;
}
}
public boolean delete(int id){
SQLiteDatabase db = helper.getWritableDatabase();
int result = db.delete("account", "id= ?", new String[]{id+""});
db.close();
if(result > 0){
return true;
}else{
return false;
}
}
public boolean update(int id , float newmoney){
SQLiteDatabase db = helper.getWritableDatabase();
ContentValues values = new ContentValues();
values.put("id", id);
values.put("money", newmoney);
int result = db.update("account", values, "id = ?", new String[]{id + ""});
db.close();
if(result > 0){
return true;
}else{
return false;
}
}
public List<NoteBean> findAll(){
SQLiteDatabase db = helper.getWritableDatabase();
List<NoteBean> noteBeans = new ArrayList<NoteBean>();
Cursor cursor = db.query("account", new String[]{"id","name","money"}, null, null, null, null, null);
while(cursor.moveToNext()){
int id = cursor.getInt(0);
String name = cursor.getString(1);
float money = cursor.getFloat(2);
NoteBean bean = new NoteBean(id,money,name);
noteBeans.add(bean);
bean = null;
}
db.close();
return noteBeans;
}
}