参数拼接方式实现SQLite数据库的增删改查
发布时间:2020-12-12 20:09:02 所属栏目:百科 来源:网络整理
导读:public class OtherPersonService {private DBOpenHelper dbOpenHelper;public OtherPersonService(Context context){dbOpenHelper = new DBOpenHelper(context);}public void save(Person person){SQLiteDatabase db = dbOpenHelper.getWritableDatabase();
public class OtherPersonService { private DBOpenHelper dbOpenHelper; public OtherPersonService(Context context){ dbOpenHelper = new DBOpenHelper(context); } public void save(Person person){ SQLiteDatabase db = dbOpenHelper.getWritableDatabase(); ContentValues values = new ContentValues(); values.put("name",person.getName()); values.put("phone",person.getPhone()); values.put("amount",person.getAmount()); db.insert("person",null,values);//insert into person(personid) values(NULL) } public void update(Person person){ SQLiteDatabase db = dbOpenHelper.getWritableDatabase(); ContentValues values = new ContentValues(); values.put("name",person.getAmount()); db.update("person",values,"personid=?",new String[]{person.getId().toString()}); } public Person find(Integer id){ SQLiteDatabase db = dbOpenHelper.getReadableDatabase(); Cursor cursor = db.query("person",new String[]{id.toString()},null); if(cursor.moveToFirst()){ int personid = cursor.getInt(cursor.getColumnIndex("personid")); int amount = cursor.getInt(cursor.getColumnIndex("amount")); String name = cursor.getString(cursor.getColumnIndex("name")); String phone = cursor.getString(cursor.getColumnIndex("phone")); cursor.close(); return new Person(personid,name,phone,amount); } return null; } public void delete(Integer id){ SQLiteDatabase db = dbOpenHelper.getWritableDatabase(); db.delete("person",new String[]{id.toString()}); } public List<Person> getScrollData(int offset,int maxResult){ List<Person> persons = new ArrayList<Person>(); SQLiteDatabase db = dbOpenHelper.getReadableDatabase(); Cursor cursor = db.query("person","personid asc",offset+","+ maxResult); while(cursor.moveToNext()){ int personid = cursor.getInt(cursor.getColumnIndex("personid")); int amount = cursor.getInt(cursor.getColumnIndex("amount")); String name = cursor.getString(cursor.getColumnIndex("name")); String phone = cursor.getString(cursor.getColumnIndex("phone")); persons.add(new Person(personid,amount)); } cursor.close(); return persons; } public long getCount(){ SQLiteDatabase db = dbOpenHelper.getReadableDatabase(); Cursor cursor = db.query("person",new String[]{"count(*)"},null); cursor.moveToFirst(); return cursor.getLong(0); } } (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |