Android SQLite 数据库DAO 基本方法

package com.zhongjiu.db;import java.util.ArrayList;import java.util.List;import android.content.Context;import android.database.Cursor;import android.database.sqlite.SQLiteDatabase;import android.os.SystemClock;import android.widget.Toast;import com.zhongjiu.activity.MumberActivity;import com.zhongjiu.domain.ChanPin;import com.zhongjiu.domain.DingDan;public class DingDanDao {private DingDanDBhelper helper;/** * 在构造方法中初始化helper对象 */public DingDanDao(Context context) {helper = new DingDanDBhelper(context);}/** * 增加一个订单 * * @param time * @param dingdannumber * @param zhuangtai * @param jine * @param zhifufs * @param xingming */public void add(String time, String dingdannumber, String zhuangtai,String jine, String zhifufs, String xingming, String goumaitiaoma,String goumaishuliang) {SQLiteDatabase db = helper.getWritableDatabase();db.execSQL(// 注意自己操作的是那张表"insert into ding (time,dingdannumber,zhuangtai,jine,zhifufs,xingming,goumaitiaoma,goumaishuliang) values (?,?,?,?,?,?,?,?)",new Object[] { time, dingdannumber, zhuangtai, jine, zhifufs,xingming, goumaitiaoma, goumaishuliang });db.close();// 释放资源}/** * 根据订单号删除一个订单 * * @param dingdannumber */public void delete(String dingdannumber) {// 得到一个可写的数据库SQLiteDatabase db = helper.getWritableDatabase();// SQLiteDatabase db = helper.getWritableDatabase();db.delete("ding", "dingdannumber=?", new String[] { dingdannumber });db.close();}/** * 搜索满足条件的 订单的集合 * * @param startTime * @param endTime * @param zhuangtai * @param zhifufs * @param xingming * @return */p