packagecom.xrj.myapplication.dao;importandroid.content.Context;importandroid.database.Cursor;importandroid.database.sqlite.SQLiteDatabase;importcom.xrj.myapplication.entity.Person;importcom.xrj.myapplication.utils.PersonDBHelper;importjava.util.ArrayList;importjava.util.List;public classPersonDao {privatePersonDBHelper helper;publicPersonDao(Context context) {
helper= newPersonDBHelper(context);
}public voidadd(String name,String number) {
String addSql= "insert into person (name,number) values (?,?)";
SQLiteDatabase db=helper.getWritableDatabase();
db.execSQL(addSql,newObject[]{name,number});
db.close();
}public voiddelete(String name) {
String deleteSql= "delete from person where name = ?";
SQLiteDatabase db=helper.getWritableDatabase();
db.execSQL(deleteSql,newObject[]{name});
db.close();
}public voidupdate(String name,String number) {
String updateSql= "update person set number = ? where name = ?";
SQLiteDatabase db=helper.getWritableDatabase();
db.execSQL(updateSql,newObject[]{name,number});
db.close();
}publicPerson findone(String name) {
String sql= "select * from person where name = ?";
SQLiteDatabase db=helper.getReadableDatabase();
Cursor cursor= db.rawQuery(sql,newString[]{name});if(cursor.moveToNext()) {
String personname= cursor.getString(1);
String personnumber= cursor.getString(2);
Person person= newPerson(personname,personnumber);returnperson;
}return null;
}public ListfindAll() {
String sql= "select * from person";
SQLiteDatabase db=helper.getReadableDatabase();
Cursor cursor= db.rawQuery(sql,null);
List personList = new ArrayList();while(cursor.moveToNext()) {
String personname= cursor.getString(1);
String personnumber= cursor.getString(2);
Person person= newPerson(personname,personnumber);
personList.add(person);
}returnpersonList;
}
}