Android Sqlite的使用，纯代码

SQLiteOpenHelper

/***
 * 作者 ： 于德海
 * 时间 ： 2019/8/27 0027 11:28
 * 描述 ：
 */
public class SQLiteDbHelper extends SQLiteOpenHelper {
    public static final String DB_NAME = "cyber_database";
    public static final int DB_VERSION = 1;



    public SQLiteDbHelper(@Nullable Context context) {
        super(context, DB_NAME, null, DB_VERSION);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL(CollectionDbManager.TABLE_COLLECTION_CREATE_SQL);
        db.execSQL(HistoryDbManager.TABLE_HISTORY_CREATE_SQL);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

    }
}

DB Bean

/***
 * 作者 ： 于德海
 * 时间 ： 2019/8/27 0027 11:40
 * 描述 ： 收藏数据库类
 */
public class CollectionDbBean {
    private String contentCode;
    private int startTimes;
    private String contentName;
    private  String posterUrl;
    private String lastUsedTime;
    private String startCMD;
    private int runMode;
    private int isVip;
    private int isYearVip;
    private int ischecked;
    private boolean isdelete;

    public String getContentCode() {
        return contentCode;
    }

    public void setContentCode(String contentCode) {
        this.contentCode = contentCode;
    }

    public int getStartTimes() {
        return startTimes;
    }

    public void setStartTimes(int startTimes) {
        this.startTimes = startTimes;
    }

    public String getContentName() {
        return contentName;
    }

    public void setContentName(String contentName) {
        this.contentName = contentName;
    }

    public String getPosterUrl() {
        return posterUrl;
    }

    public void setPosterUrl(String posterUrl) {
        this.posterUrl = posterUrl;
    }

    public String getLastUsedTime() {
        return lastUsedTime;
    }

    public void setLastUsedTime(String lastUsedTime) {
        this.lastUsedTime = lastUsedTime;
    }

    public String getStartCMD() {
        return startCMD;
    }

    public void setStartCMD(String startCMD) {
        this.startCMD = startCMD;
    }

    public int getRunMode() {
        return runMode;
    }

    public void setRunMode(int runMode) {
        this.runMode = runMode;
    }

    public int getIsVip() {
        return isVip;
    }

    public void setIsVip(int isVip) {
        this.isVip = isVip;
    }

    public int getIsYearVip() {
        return isYearVip;
    }

    public void setIsYearVip(int isYearVip) {
        this.isYearVip = isYearVip;
    }

    public int getIschecked() {
        return ischecked;
    }

    public void setIschecked(int ischecked) {
        this.ischecked = ischecked;
    }

    public boolean isIsdelete() {
        return isdelete;
    }

    public void setIsdelete(boolean isdelete) {
        this.isdelete = isdelete;
    }
}

public class HistoryDbBean {
    /**
     * contentCode : 70001008
     * contentName : 全民潜艇
     * posterUrl : null
     * startCMD : apk:com.xxz.QianTing
     * runMode : 0
     * androidAPKInfo : null
     * startTimes : 24
     * onlineTime : 2019-03-20 16:14:38
     */

    private int isSelected;
    private String contentCode;
    private String contentName;
    private String posterUrl;
    private String startCMD;
    private String lastUsedTime;
    private int runMode;
    private Object androidAPKInfo;
    private int startTimes;
    private String onlineTime;
    private int isVip;
    private int isYearVip;

    public int getIsYearVip() {
        return isYearVip;
    }

    public void setIsYearVip(int isYearVip) {
        this.isYearVip = isYearVip;
    }

    public int getIsVip() {
        return isVip;
    }

    public void setIsVip(int isVip) {
        this.isVip = isVip;
    }

    public int getIsSelected() {
        return isSelected;
    }

    public void setIsSelected(int isSelected) {
        this.isSelected = isSelected;
    }

    public String getLastUsedTime() {
        return lastUsedTime;
    }

    public void setLastUsedTime(String lastUsedTime) {
        this.lastUsedTime = lastUsedTime;
    }

    public String getContentCode() {
        return contentCode;
    }

    public void setContentCode(String contentCode) {
        this.contentCode = contentCode;
    }

    public String getContentName() {
        return contentName;
    }

    public void setContentName(String contentName) {
        this.contentName = contentName;
    }

    public String getPosterUrl() {
        return posterUrl;
    }

    public void setPosterUrl(String posterUrl) {
        this.posterUrl = posterUrl;
    }

    public String getStartCMD() {
        return startCMD;
    }

    public void setStartCMD(String startCMD) {
        this.startCMD = startCMD;
    }

    public int getRunMode() {
        return runMode;
    }

    public void setRunMode(int runMode) {
        this.runMode = runMode;
    }

    public Object getAndroidAPKInfo() {
        return androidAPKInfo;
    }

    public void setAndroidAPKInfo(Object androidAPKInfo) {
        this.androidAPKInfo = androidAPKInfo;
    }

    public int getStartTimes() {
        return startTimes;
    }

    public void setStartTimes(int startTimes) {
        this.startTimes = startTimes;
    }

    public String getOnlineTime() {
        return onlineTime;
    }

    public void setOnlineTime(String onlineTime) {
        this.onlineTime = onlineTime;
    }
}

CollectionDbManager

/***
 * 作者 ： 于德海
 * 时间 ： 2019/8/27 0027 11:41
 * 描述 ： 收藏数据库管理类
 */
public class CollectionDbManager {
    public static final String TABLE_COLLECTION = "collection";
    public static final String TABLE_COLLECTION_CREATE_SQL = "create table "+TABLE_COLLECTION+
            " (_id integer primary key autoincrement,"+
            " app_id integer,"+
            " user_id text,"+
            " app_name text,"+
            " img_url text,"
            +" use_people integer,"+
            " is_vip integer,"+
            " is_year_vip integer);";

    private SQLiteDatabase mSQLiteDatabase;
    public CollectionDbManager(Context context) {
        SQLiteDbHelper helper = new SQLiteDbHelper(context.getApplicationContext());
        mSQLiteDatabase = helper.getWritableDatabase();
    }




    public void insertValue(List<CollectionDbBean> list){
        if(list == null)
            return;
        for (CollectionDbBean bean : list)
            insertValue(bean);
    }

    public void insertValue(CollectionDbBean bean){
        ContentValues contentValues = new ContentValues();
        contentValues.put("app_id",bean.getContentCode());
        contentValues.put("user_id",AppConfig.UserID);
        contentValues.put("app_name",bean.getContentName());
        contentValues.put("img_url",bean.getPosterUrl());
        contentValues.put("use_people",bean.getStartTimes());
        contentValues.put("is_vip",bean.getIsVip());
        contentValues.put("is_year_vip",bean.getIsYearVip());
        mSQLiteDatabase.insert(TABLE_COLLECTION,null,contentValues);
    }


    public List<CollectionDbBean> queryCollection(){
        List<CollectionDbBean> list = new ArrayList<>();
        Cursor cursor = mSQLiteDatabase.query(TABLE_COLLECTION,null,"user_id=?",new String[]{AppConfig.UserID},null,null,null);
        while (cursor.moveToNext()){
            CollectionDbBean bean = new CollectionDbBean();
            bean.setContentCode(cursor.getString(cursor.getColumnIndex("app_id")));
            bean.setContentName(cursor.getString(cursor.getColumnIndex("app_name")));
            bean.setPosterUrl(cursor.getString(cursor.getColumnIndex("img_url")));
            bean.setStartTimes(cursor.getInt(cursor.getColumnIndex("use_people")));
            bean.setIsVip(cursor.getInt(cursor.getColumnIndex("is_vip")));
            bean.setIsYearVip(cursor.getInt(cursor.getColumnIndex("is_year_vip")));
            list.add(bean);
        }
        cursor.close();
        return list;
    }

    public CollectionDbBean queryCollection(String contentCode){
        Cursor cursor = mSQLiteDatabase.query(TABLE_COLLECTION,null,"user_id = ? and app_id = ?",new String[]{AppConfig.UserID,contentCode},null,null,null);
        while (cursor.moveToNext()){
            CollectionDbBean bean = new CollectionDbBean();
            bean.setContentCode(cursor.getString(cursor.getColumnIndex("app_id")));
            bean.setContentName(cursor.getString(cursor.getColumnIndex("app_name")));
            bean.setPosterUrl(cursor.getString(cursor.getColumnIndex("img_url")));
            bean.setStartTimes(cursor.getInt(cursor.getColumnIndex("use_people")));
            bean.setIsVip(cursor.getInt(cursor.getColumnIndex("is_vip")));
            bean.setIsYearVip(cursor.getInt(cursor.getColumnIndex("is_year_vip")));
            cursor.close();
            return bean;
        }
        cursor.close();
        return null;
    }

    public void delete(String contentCode){
        if(TextUtils.isEmpty(AppConfig.UserID))
            return;
        mSQLiteDatabase.delete(TABLE_COLLECTION,"user_id = ? and app_id = ?",new String[]{AppConfig.UserID,contentCode});
    }



}

HistoryDbManager

/***
 * 作者 ： 于德海
 * 时间 ： 2019/8/27 0027 11:41
 * 描述 ： 历史记录数据库管理类
 */
public class HistoryDbManager {
    private static final String TABLE_HISTORY = "history";
    public static final String TABLE_HISTORY_CREATE_SQL = "create table "+TABLE_HISTORY+
            " (_id integer primary key autoincrement,"+
            " app_id integer,"+
            " user_id text,"+
            " app_name text,"+
            " use_time text,"+
            " img_url text,"+
            " use_people integer,"+
            " is_vip integer,"+
            " is_year_vip integer);";

    private SQLiteDatabase mSQLiteDatabase;
    public HistoryDbManager(Context context) {
        SQLiteDbHelper helper = new SQLiteDbHelper(context.getApplicationContext());
        mSQLiteDatabase = helper.getWritableDatabase();
    }




    public void insertValue(List<HistoryDbBean> list){
        if(list == null)
            return;
        for (HistoryDbBean bean : list)
            insertValue(bean);
    }

    public void insertValue(HistoryDbBean bean){
        ContentValues contentValues = new ContentValues();
        contentValues.put("app_id",bean.getContentCode());
        contentValues.put("user_id",AppConfig.UserID);
        contentValues.put("app_name",bean.getContentName());
        contentValues.put("img_url",bean.getPosterUrl());
        contentValues.put("use_time",bean.getLastUsedTime());
        contentValues.put("use_people",bean.getStartTimes());
        contentValues.put("is_vip",bean.getIsVip());
        contentValues.put("is_year_vip",bean.getIsYearVip());
        mSQLiteDatabase.insert(TABLE_HISTORY,null,contentValues);
    }


    public List<HistoryDbBean> queryHistory(){
        List<HistoryDbBean> list = new ArrayList<>();
        Cursor cursor = mSQLiteDatabase.query(TABLE_HISTORY,null,"user_id=?",new String[]{AppConfig.UserID},null,null,null);
        while (cursor.moveToNext()){
            HistoryDbBean bean = new HistoryDbBean();
            bean.setContentCode(cursor.getString(cursor.getColumnIndex("app_id")));
            bean.setContentName(cursor.getString(cursor.getColumnIndex("app_name")));
            bean.setPosterUrl(cursor.getString(cursor.getColumnIndex("img_url")));
            bean.setStartTimes(cursor.getInt(cursor.getColumnIndex("use_people")));
            bean.setLastUsedTime(cursor.getString(cursor.getColumnIndex("use_time")));
            bean.setIsVip(cursor.getInt(cursor.getColumnIndex("is_vip")));
            bean.setIsYearVip(cursor.getInt(cursor.getColumnIndex("is_year_vip")));
            list.add(bean);
        }
        cursor.close();
        return list;
    }

    public HistoryDbBean queryHistory(String contentCode){
        Cursor cursor = mSQLiteDatabase.query(TABLE_HISTORY,null,"user_id = ? and app_id = ?",new String[]{AppConfig.UserID,contentCode},null,null,null);
        while (cursor.moveToNext()){
            HistoryDbBean bean = new HistoryDbBean();
            bean.setContentCode(cursor.getString(cursor.getColumnIndex("app_id")));
            bean.setContentName(cursor.getString(cursor.getColumnIndex("app_name")));
            bean.setLastUsedTime(cursor.getString(cursor.getColumnIndex("use_time")));
            bean.setPosterUrl(cursor.getString(cursor.getColumnIndex("img_url")));
            bean.setStartTimes(cursor.getInt(cursor.getColumnIndex("use_people")));
            bean.setIsVip(cursor.getInt(cursor.getColumnIndex("is_vip")));
            bean.setIsYearVip(cursor.getInt(cursor.getColumnIndex("is_year_vip")));
            cursor.close();
            return bean;
        }
        cursor.close();
        return null;
    }

    public void delete(String contentCode){
        if(TextUtils.isEmpty(AppConfig.UserID))
            return;
        mSQLiteDatabase.delete(TABLE_HISTORY,"user_id = ? and app_id = ?",new String[]{AppConfig.UserID,contentCode});
    }

    public void updateHistory(String contentCode,String time){
        ContentValues contentValues = new ContentValues();
        contentValues.put("use_time",time);
        mSQLiteDatabase.update(TABLE_HISTORY,contentValues,"user_id = ? and app_id = ?",new String[]{AppConfig.UserID,contentCode});

    }


}