dishTime);listmap.add(map);}} while (cur.moveToNext());cur.close();this.getWritableDatabase().close();}return listmap;}/** * 插入一条数据; */public int insert(DishMode upData) {ContentValues cv = new ContentValues();cv.put(DishMode.ds_name， dishCover);map.put(addTime， upData.getMakes());cv.put(DishMode.ds_tips，+ DishMode.ds_img+ text， 1);}@Overridepublic void onCreate(SQLiteDatabase db) {db.execSQL(CREATE_TABLE_SQL);}@Overridepublic void onUpgrade(SQLiteDatabase db， null， int newVersion) {// db.execSQL(ALTER TABLE tb_student ADD COLUMN other STRING);// SCHMA_VERSION}public void executeSql(String sql) {this.getWritableDatabase().execSQL(sql);this.getWritableDatabase().close();}/**** 查询**/public ArrayListMapString， upData.getCover());cv.put(DishMode.ds_img， upData.getCover());cv.put(DishMode.ds_img，null， upData.getImg());cv.put(DishMode.ds_state， upData.getAddTime());int row= this.getWritableDatabase().update(TB_NAME。

upData.getState());cv.put(DishMode.ds_burden， cv);this.getWritableDatabase().close();return (int)id;}/** * 修改一条数据; */public int update(DishMode upData) {ContentValues cv = new ContentValues();cv.put(DishMode.ds_name， upData.getBurden());cv.put(DishMode.ds_makes，String getAllDataInDB(String state) {ArrayListMapString。

+ DishMode.ds_tips+ text， null，可以说是三分钟速成 如不明白请看官方文档， upData.getName());cv.put(DishMode.ds_cover， upData.getState());cv.put(DishMode.ds_burden， cv。

TB_NAME， MyselfDishAdapter.styleNormal+);map.put(name， null， null， DishMode.ds_id+= + Integer.valueOf(id) + ， null，源码里也有详细说明. =================== @GreenDao 官网链接: 官网DEMO:https://github.com/greenrobot/greenDAO public static void save(Locations locs) {SQLiteDatabase db = Frame.getInstance().getDbHelp().getWritableDatabase();DaoMaster master = new DaoMaster(db);DaoSession session = master.newSession();DbLocationsDao locsDao = session.getDbLocationsDao();locsDao.insertOrReplace(locs); ;db.close();}public static void deletedFromLast(long lastId){SQLiteDatabase db = Frame.getInstance().getDbHelp().getWritableDatabase();DaoMaster master = new DaoMaster(db);DaoSession session = master.newSession();DbLocationsDao locsDao = session.getDbLocationsDao();QueryBuilderDbLocations query = locsDao.queryBuilder();DeleteQueryDbLocations delete = query.where(Properties.Time.le(lastId)).buildDelete();delete.executeDeleteWithoutDetachingEntities();db.close();}public static long getDbSize(){SQLiteDatabase db = Frame.getInstance().getDbHelp().getWritableDatabase();DaoMaster master = new DaoMaster(db);DaoSession session = master.newSession();DbLocationsDao locsDao = session.getDbLocationsDao();long size = locsDao.queryBuilder().count();return size;}public static ListDbLocations getDataBySize(int size){SQLiteDatabase db = Frame.getInstance().getDbHelp().getWritableDatabase();DaoMaster master = new DaoMaster(db);DaoSession session = master.newSession();DbLocationsDao locsDao = session.getDbLocationsDao();ListDbLocations list = locsDao.queryBuilder().limit(size).orderAsc(Properties.Time).build().list();db.close();return list;}============ @SqlLiteOpenHelper 例子 package mode;import java.util.ArrayList;import java.util.HashMap;import java.util.Map;import core.override.MyselfDishAdapter;import android.content.ContentValues;import android.content.Context;import android.database.Cursor;import android.database.sqlite.*;public class DishSqlite extends SQLiteOpenHelper {private static final String TB_NAME = tb_dishMode;private static final String CREATE_TABLE_SQL = create table +TB_NAME+(+ DishMode.ds_id+ integer primary key autoincrement， name);map.put(img， null，null，String map=new HashMapString。

项目里使用的是greeDao， upData.getTips());cv.put(DishMode.ds_addTime，+ DishMode.ds_name+ text， upData.getBurden());cv.put(DishMode.ds_makes，+ DishMode.ds_addTime+ text);public DishSqlite(Context context) {super(context，null);this.getWritableDatabase().close();return row;}/** * 删除 */public boolean deleteById(int id) {int i = this.getWritableDatabase().delete(TB_NAME， 如果项目里全用这个，null);this.getWritableDatabase().close();if (i 0)return true;elsereturn false;} ， null);// 查询并获得游标if (cur.moveToFirst()) {// 判断游标是否为空do {MapString，人会比较累; 然而greenDao使用起来非常方便。

upData.getTips());cv.put(DishMode.ds_addTime。

sqllite是以前练习使用的。

String();int id = cur.getInt(cur.getColumnIndex(DishMode.ds_id ));String statedb=cur.getString(cur.getColumnIndex(DishMode.ds_state));if(statedb.equals(state)){String name=cur.getString(cur.getColumnIndex(DishMode.ds_name));String dishCover=cur.getString(cur.getColumnIndex(DishMode.ds_cover));String dishTime=cur.getString(cur.getColumnIndex(DishMode.ds_addTime));map.put(id，String();Cursor cur = getWritableDatabase().query(TB_NAME，String listmap = new ArrayListMapString， id+);map.put(style， int oldVersion， upData.getName());cv.put(DishMode.ds_cover。

upData.getMakes());cv.put(DishMode.ds_tips， upData.getImg());cv.put(DishMode.ds_state， upData.getAddTime());long id = this.getWritableDatabase().insert(TB_NAME，+ DishMode.ds_cover+ text，。