android 操作sqllite 数据库
16lz
2021-01-23
package com.b509.activity.patient.mydoctors.service;public class Person {private Integer id;private String time;private String describe;private String illness;private byte[] pic;public Integer getId() {return id;}public void setId(Integer id) {this.id = id;}public String getTime() {return time;}public void setTime(String time) {this.time = time;}public String getDeccribe() {return describe;}public void setDeccribe(String deccribe) {this.describe = deccribe;}public String getIllness() {return illness;}public void setIllness(String illness) {this.illness = illness;}public byte[] getPic() {return pic;}public void setPic(byte[] pic) {this.pic = pic;}public Person(){}public Person(Integer id, String time,String describe,String illness,byte[] pic) {this.id = id;this.time = time;this.describe=describe;this.illness=illness;this.pic = pic;}public Person( String time,String describe,String illness) {this.time = time;this.describe=describe;this.illness=illness;}} package com.b509.activity.patient.mydoctors.service;import java.util.ArrayList;import java.util.List;import android.content.ContentValues;import android.content.Context;import android.database.Cursor;import android.database.sqlite.SQLiteDatabase;public class OtherPersonService {private DBOpenHelper dbOpenHelper;public OtherPersonService(Context context) {this.dbOpenHelper = new DBOpenHelper(context);}// ILLid time describe illnesspublic void save(Person person) {SQLiteDatabase db = dbOpenHelper.getWritableDatabase();ContentValues values = new ContentValues();values.put("ILLid", person.getId());values.put("time", person.getTime());values.put("describe", person.getDeccribe());values.put("illness", person.getIllness());db.insert("ILLNESS", null, values);db.close();}// SQLiteDatabase db = dbOpenHelper.getWritableDatabase();public void update(Person person) {// update person set name =? where personid =?SQLiteDatabase db = dbOpenHelper.getWritableDatabase();ContentValues values = new ContentValues();values.put("time", person.getTime());values.put("describe", person.getDeccribe());values.put("illness", person.getIllness());System.out.println(person.getDeccribe());System.out.println(person.getIllness());System.out.println(person.getTime());System.out.println(person.getId());Integer i = person.getId();String id_str = String.valueOf(i);System.out.println(id_str + "把id转化为一个字符串");db.update("ILLNESS", values, "ILLid=?", new String[] { id_str });db.close();}public void delete(Integer id) {SQLiteDatabase db = dbOpenHelper.getWritableDatabase();db.delete("ILLNESS", "ILLid=?", new String[] { id.toString() });db.close();}public List<Person> find2() {// 如果只对数据进行读取，建议使用此方法SQLiteDatabase db = dbOpenHelper.getReadableDatabase();Cursor cursor = db.query("ILLNESS", new String[] { "time", "illness" },null, null, null, null, "time");List<Person> persons = new ArrayList<Person>();// select personid,name from person where personid=? order by ... limit// 3,5if (cursor.moveToFirst()) {String timeill = cursor.getString(cursor.getColumnIndex("time"));String kindsill = cursor.getString(cursor.getColumnIndex("illness"));System.out.println(timeill);System.out.println(kindsill);Person person = new Person();person.setTime(timeill);person.setIllness(kindsill);persons.add(person);db.close();return persons;}return null;}public Person find3(int id) {// 如果只对数据进行读取，建议使用此方法String str_id = id + "";SQLiteDatabase db = dbOpenHelper.getReadableDatabase();Cursor cursor = db.query("ILLNESS", new String[] { "time", "illness"," describe" }, str_id, null, null, null, "time");Person person = null;if (cursor.moveToFirst()) {String timeill = cursor.getString(cursor.getColumnIndex("time"));String kindsill = cursor.getString(cursor.getColumnIndex("illness"));String disill = cursor.getString(cursor.getColumnIndex("describe"));System.out.println(timeill);System.out.println(kindsill);person = new Person();person.setTime(timeill);person.setIllness(kindsill);person.setDeccribe(disill);return person;}db.close();return null;}public List<Person> find() {// 如果只对数据进行读取，建议使用此方法SQLiteDatabase db = dbOpenHelper.getReadableDatabase();Cursor cursor = db.query("ILLNESS", new String[] { "ILLid", "time","illness" }, null, null, null, null, "time");List<Person> persons = new ArrayList<Person>();// select personid,name from person where personid=? order by ... limit// 3,5if (cursor.moveToFirst()) {Person person = new Person();System.out.println("---------------");String timeill = cursor.getString(cursor.getColumnIndex("time"));Integer idill = cursor.getInt(cursor.getColumnIndex("ILLid"));String kindsill = cursor.getString(cursor.getColumnIndex("illness"));System.out.println(timeill);System.out.println(idill);System.out.println(kindsill);person.setTime(timeill);person.setIllness(kindsill);persons.add(person);db.close();return persons;}return null;}public List<Person> getScrollData(Integer offset, Integer maxResult) {List<Person> persons = new ArrayList<Person>();SQLiteDatabase db = dbOpenHelper.getReadableDatabase();Cursor cursor = db.query("ILLNESS", new String[] { "ILLid", "time","illness" }, null, null, null, null, "time", offset + ","+ maxResult);while (cursor.moveToNext()) {int personid = cursor.getInt(cursor.getColumnIndex("ILLid"));String time_ill = cursor.getString(cursor.getColumnIndex("time"));String ill = cursor.getString(cursor.getColumnIndex("illness"));Person p = new Person();p.setId(personid);p.setIllness(ill);p.setTime(time_ill);persons.add(p);}cursor.close();db.close();return persons;}public long getCount() {// select count(*) from personSQLiteDatabase db = dbOpenHelper.getReadableDatabase();/* * Cursor cursor = db.query("ILLNESS", new String[] { "count(*)" }, * null, null, null, null, null); */Cursor cursor = db.query("ILLNESS", new String[] { "Illid" }, null,null, null, null, null);db.close();return cursor.getCount();}}