Android 操作SQLite用法（简易版）

//1.定义一个类继承SQLiteOpenHelper 

 public class Fg57 extends SQLiteOpenHelper {

        public Fg57(Context context) {
            super(context, "BJfg57", null, 1);
        }

        @Override
        public void onCreate(SQLiteDatabase sqLiteDatabase) {
            sqLiteDatabase.execSQL("create table fg57(_id Integer primary key autoincrement,mPm not null," +
                    "mCo2 not null,mTemp not null,mHum not null,mLight not null)");
        }

        @Override
        public void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int i1) {

        }
    }

//2.然后

public class BJDBFg57 {

    private Fg57 fg57;
    private final SQLiteDatabase db;
    private static BJDBFg57 bjdbFg57;

    public BJDBFg57(Context context) {
        fg57 = new Fg57(context);
        db = fg57.getWritableDatabase();
    }
//单例模式
    public static BJDBFg57 getliving(Context context){
        if (bjdbFg57==null){
            bjdbFg57 = new BJDBFg57(context);
        }
        return bjdbFg57;
    }

    public long insert(int pm, int temp, int light, int co2, int hum) {
        ContentValues values = new ContentValues();
        values.put("mPm", pm);
        values.put("mTemp", temp);
        values.put("mLight", light);
        values.put("mCo2", co2);
        values.put("mHum", hum);
        long insert = db.insert("fg57", null, values);
        return insert;
    }

    public List<Fg57Bean> qurey() {
        List<Fg57Bean> list = new ArrayList<>();
        Cursor cursor = db.query("fg57", null, null, null, null, null, null);
        if (cursor.getCount() > 0) {
            cursor.moveToFirst();
            do {
                Fg57Bean bean = new Fg57Bean(cursor.getInt(1), cursor.getInt(2), cursor.getInt(3), cursor.getInt(4), cursor.getInt(5));
                list.add(bean);
            } while (cursor.moveToNext());
        }
        Log.e("list", list.toString());
        return list;
    }

    public int getPmMax() {
        Cursor cursor = db.rawQuery("select max(mPm) from fg57", null);
        cursor.moveToFirst();
        return (int) cursor.getLong(0);
    }

    public int getPmMin() {
        Cursor cursor = db.rawQuery("select min(mPm) from fg57", null);
        cursor.moveToFirst();
        return (int) cursor.getLong(0);
    }

    public int getPmAvg() {
        Cursor cursor = db.rawQuery("select avg(mPm) from fg57", null);
        cursor.moveToFirst();
        return (int) cursor.getLong(0);
    }
}