//目录结构
//编写Bean类
- package sn.len.transandlistview.domain;
- public class PersonBean
- {
- private Integer id;
- private String name;
- private String amount;
- public Integer getId() {
- return id;
- }
- public void setId(Integer id) {
- this.id = id;
- }
- public String getName() {
- return name;
- }
- public void setName(String name) {
- this.name = name;
- }
- public String getAmount() {
- return amount;
- }
- public void setAmount(String amount) {
- this.amount = amount;
- }
- @Override
- public String toString() {
- return "PersonBean [id=" + id + ", name=" + name + ", amount=" + amount
- + "]";
- }
- public PersonBean(Integer id, String name)
- {
- this.id = id;
- this.name = name;
- }
- public PersonBean() {
- }
- }
//编写DB类
DBOpenHelper.java 创建表,以及数据库
- package sn.len.transandlistview;
- import Android.content.Context;
- import android.database.sqlite.SQLiteDatabase;
- import android.database.sqlite.SQLiteOpenHelper;
- import android.util.Log;
- public class DBOpenHelper extends SQLiteOpenHelper
- {
- private static final String TAG="testinfo";
- private static final String DBNAME="transdb.db";
- private static final int DBVERSION=1;
- public DBOpenHelper(Context context)
- {
- super(context,DBNAME,null,DBVERSION);
- Log.i(TAG,"come in there");
- }
- @Override
- public void onCreate(SQLiteDatabase db)
- {
- db.execSQL("create table PersonBean(id integer primary key autoincrement,name varchar(20),amount varchar(20))");
- }
- @Override
- public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)
- {
- }
- }
- package sn.len.transandlistview.service;
- import java.util.ArrayList;
- import java.util.List;
- import sn.len.transandlistview.DBOpenHelper;
- import sn.len.transandlistview.domain.PersonBean;
- import android.content.Context;
- import android.database.Cursor;
- import android.database.sqlite.SQLiteDatabase;
- import android.util.Log;
- public class TransListviewService
- {
- private DBOpenHelper dbopen;
- public TransListviewService(Context context)
- {
- this.dbopen=new DBOpenHelper(context);
- this.dbopen.getWritableDatabase();
- }
- //添加数据
- public void save(PersonBean person)
- {
- SQLiteDatabase sqld=dbopen.getWritableDatabase();
- Log.i("name", person.getName());
- Log.i("amount", person.getAmount());
- sqld.execSQL("insert into PersonBean(name,amount) values(?,?)",new Object[]{person.getName(),person.getAmount()});
- }
- //事务处理
- public void trans()
- {
- SQLiteDatabase sqld=dbopen.getWritableDatabase();
- sqld.beginTransaction();
- sqld.execSQL("update PersonBean set name=? where id=?",new Object[]{"admin",1});
- sqld.execSQL("update PersonBean set name=? where id=?",new Object[]{"administrator",2});
- sqld.setTransactionSuccessful();
- sqld.endTransaction();
- }
- //查询分页
- public List<PersonBean> selectGroup(Integer offset,Integer maxRow)
- {
- SQLiteDatabase sqld=dbopen.getWritableDatabase();
- List<PersonBean> listPb=new ArrayList<PersonBean>();
- Cursor cursor=sqld.rawQuery("select * from PersonBean limit ?,?",new String[]{offset.toString(),maxRow.toString()});
- while(cursor.moveToNext())
- {
- PersonBean pb=new PersonBean();
- pb.setId(cursor.getInt(cursor.getColumnIndex("id")));
- pb.setName(cursor.getString(cursor.getColumnIndex("name")));
- pb.setAmount(cursor.getString(cursor.getColumnIndex("amount")));
- listPb.add(pb);
- }
- return listPb;
- }
- //通过返回邮标来得到显示的数据
- public Cursor getCursor(Integer offset,Integer maxRow)
- {
- SQLiteDatabase sqld=dbopen.getWritableDatabase();
- //如果使用邮标那么ID必需设置尖_id才行。
- Cursor cursor=sqld.rawQuery("select id as _id,name,amount from PersonBean limit ?,?",new String[]{offset.toString(),maxRow.toString()});
- return cursor;
- }
- }