大佬教程收集整理的这篇文章主要介绍了SQLite对于数据库的操作,大佬教程大佬觉得挺不错的,现在分享给大家,也给大家做个参考。
sqlite对于数据库的操作,在AndroiD中已经对于它的增、删、改、查、取得所有的数据数以及分页操作有着自定义的方法,如下:
public voID add(Person person) { sqliteDatabase db = Helper.getWritableDatabase(); ContentValues values = new ContentValues(); values.put("name",person.getname()); values.put("age",person.getAge()); values.put("phone",person.getPhone()); db.insert("person","name,age,phone",values); } public voID delete(Integer ID){ sqliteDatabase db = Helper.getWritableDatabase(); db.delete("person","ID=?",new String[]{ID.toString()}); } public voID update(Person person) { sqliteDatabase db = Helper.getWritableDatabase(); ContentValues values = new ContentValues(); values.put("name",person.getPhone()); db.update("person",values,new String[]{person.getID().toString()}); } public Person query(Integer ID){ sqliteDatabase db = Helper.getWritableDatabase(); cursor cursor = db.query("person",null,new String[]{ID.toString()},null); if (cursor.movetoFirst()) { int personID = cursor.geTint(cursor.getcolumnIndex("ID")); String name = cursor.getString(cursor.getcolumnIndex("name")); String phone = cursor.getString(cursor.getcolumnIndex("phone")); short age = cursor.getShort(cursor.getcolumnIndex("age")); if(cursor != null) cursor.close(); return new Person(personID,name,phone,agE); } return null; } public int getCount(){ sqliteDatabase db = Helper.getReadableDatabase(); cursor cursor = db.query("person",new String[]{"count(*)"},null); cursor.movetoFirst(); int count = cursor.geTint(0); if(cursor != null) cursor.close(); return count; } public List<Person> getlimitData(int offset,int maxCount) { List<Person> persons = new ArrayList<Person>(); sqliteDatabase db = Helper.getReadableDatabase(); cursor cursor = db.query("person",offset + "," + maxCount); while(cursor.movetoNext()){ int personID = cursor.geTint(cursor.getcolumnIndex("ID")); String name = cursor.getString(cursor.getcolumnIndex("name")); String phone = cursor.getString(cursor.getcolumnIndex("phone")); short age = cursor.getShort(cursor.getcolumnIndex("age")); persons.add(new Person(personID,agE)); } if(cursor != null){ cursor.close(); } return persons; }
以上是大佬教程为你收集整理的SQLite对于数据库的操作全部内容,希望文章能够帮你解决SQLite对于数据库的操作所遇到的程序开发问题。
如果觉得大佬教程网站内容还不错,欢迎将大佬教程推荐给程序员好友。
本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ:384754419,请注明来意。