java对mysql数据库增删改查代码_数据库增删改查java(示例代码)

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;

}

}