安卓增删改查用sql语句号码_Android SQL语句实现数据库的增删改查

packagecom.wuyudong.db.dao;importjava.util.ArrayList;importjava.util.List;importandroid.content.Context;importandroid.database.Cursor;importandroid.database.sqlite.SQLiteDatabase;importcom.wuyudong.db.PersonSQLiteOpenHelper;importcom.wuyudong.db.domain.Person;public classPersonDao {privatePersonSQLiteOpenHelper helper;publicPersonDao(Context context) {

helper= newPersonSQLiteOpenHelper(context);

}/*** 添加一条记录到数据库

*

*@paramname

* 姓名

*@paramnumber

* 电话*/

public voidadd(String name, String number) {

SQLiteDatabase db=helper.getWritableDatabase();

db.execSQL("insert into person (name,number) values (?,?)",newObject[] { name, number });

db.close();

}/*** 查询记录是否存在

*

*@paramname

* 姓名 return true存在， false不存在*/

public booleanfind(String name) {

SQLiteDatabase db=helper.getReadableDatabase();

Cursor cursor= db.rawQuery("select * from person where name=?",newString[] { name });boolean result =cursor.moveToNext();

cursor.close();

db.close();returnresult;

}/***

*@paramname

* 要修改的人的姓名

*@paramnewnumber

* 新的号码*/

public voidupdate(String name, String newnumber) {

SQLiteDatabase db=helper.getReadableDatabase();

db.execSQL("update person set number=? where name=?", newObject[]{newnumber,name});

db.close();

}/*** 删除一条记录

*@paramname*/

public voiddelete(String name) {

SQLiteDatabase db=helper.getReadableDatabase();

db.execSQL("delete from person where name=?", newObject[]{name});

db.close();

}/*** 返回全部的数据库信息

*@return

*/

public ListfindAll() {

List persons = new ArrayList();

SQLiteDatabase db=helper.getReadableDatabase();

Cursor cursor= db.rawQuery("select * from person", null);while(cursor.moveToNext()){int id = cursor.getInt(cursor.getColumnIndex("id"));

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

String number= cursor.getString(cursor.getColumnIndex("number"));

Person person= newPerson(id, name, number);

persons.add(person);

}

cursor.close();

db.close();returnpersons;

}

}