android 操作sqllite 数据库
来源:互联网 发布:批量部署windows 编辑:程序博客网 时间:2024/05/16 13:00
- 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 illness
- public 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,5
- if (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,5
- if (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 person
- SQLiteDatabase 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();
- }
- }
0 0
- android 操作sqllite 数据库
- Android 操作sqllite数据库
- Android复习笔记(5)-数据库操作 sqllite
- android数据库操作(一) SQLlite数据库帮助类
- android sqllite操作
- android的sqlLite数据库
- android-----sqllite小型数据库
- Android 的 SQLLite数据库
- Android SQLLite数据库
- Android数据库(SqlLite)操作和db文件查看
- Android sqlLite 数据库的增删查改操作
- Android:SQLiteOpenHelper类(SQLlite数据库操作)详细解析
- Android:SQLiteOpenHelper类(SQLlite数据库操作)详细解析
- 【原创】PHP操作SQLlite数据库
- Qt数据库SqlLite操作例程
- 【android基础】android sqllite操作
- Android SQLLite 的基础操作
- android sqllite数据库使用详解
- Android第一章
- hdu 1023 Train Problem II dp/卡特兰数
- AutoCAD数据导入ArcGIS后的投影定义与投影转换
- Hive学习笔记之--Hive 高级编程<转>
- Java Collections Framework - Java集合框架之概要
- android 操作sqllite 数据库
- windows监控网站,重启服务
- ACE_Message_Block实现浅析
- HTML实例--列表、表单
- 使用logrotate来回滚linux上的日志
- IOS开发之IAP(In-App Purchases)的Invalid Product IDs问题所在
- 江城子·密州出猎
- 从变化逻辑的封装谈设计模式
- Multiplication Table - #256 (Div. 2) D (448D) 二分