Android Sqlite 自定义工具类（记录，非教程）

 

public class DBHelper extends SQLiteOpenHelper {

    private static final String DATABASE_NAME = "PersonInfo.db";  //数据库名
    private static final int DATABASE_VERSION = 1;               //数据库版本号


    public DBHelper(Context context) {
        super(context, DATABASE_NAME, null, DATABASE_VERSION);
    }

    public DBHelper(Context context, String name, SQLiteDatabase.CursorFactory factory, int version) {
        super(context, name, factory, version);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        String InfoSQL = "CREATE TABLE peopleInfo(id varchar(10) primary key , " +
                "name test ," +
                "phoneNumber test ," +
                "wxNumber test ," +
                "wbName test," +
                "money test)";
        db.execSQL(InfoSQL);


    }

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

    }
}

public class DBUtils {
    private DBHelper dbHelper;
    private SQLiteDatabase db;
    private static final String TABLE_NAME = "peopleInfo";

    public DBUtils(Context context) {
        dbHelper = new DBHelper(context);
        db = dbHelper.getWritableDatabase();
    }

    /**
     * 添加数据
     */
    /*
    例如
     dbUtils.addData(new String[]{"name", "phoneNumber", "wxNumber", "wbName", "money"}
                    , new String[]{"b3", "手机号", "微信号", "啊啊啊", "300"});
     */
    public void addData(String[] key, String[] values) {
        ContentValues contentValues = new ContentValues();
        for (int i = 0; i < key.length; i++) {
            contentValues.put(key[i], values[i]);
        }
        db.insert(TABLE_NAME, null, contentValues);
        contentValues.clear();
    }

    /**
     * 删除数据
     */
    //例如 ： dbUtils.delData("userName=?",new String[]{user.getName()})
    public int delData(String where, String[] values) {
        int del_data;

        del_data = db.delete(TABLE_NAME, where, values);
        return del_data;
    }

    /**
     * 修改数据
     */
    /*
      String set = "phoneNumber=? ,wxNumber=?,wbName=?,money=?";
      String where = "name=? ";
      String[] values = {phoneEt.getText().toString().trim()
                ,wxNumberEt.getText().toString().trim()
                ,wbNameEt.getText().toString().trim()
                ,baojiaEt.getText().toString().trim()
                ,nameTv.getText().toString()};
     dbUtils.update(set,where,values);
     */
    public void update(String set, String where, String[] values) {
        db.execSQL("update " + TABLE_NAME + " set " + set + " where " + where, values);
    }

    /**
     * 查询数据
     */
    public List<JVBean> queryData() {
        List<JVBean> list = new ArrayList<>();
        Cursor cursor = db.rawQuery("select name,phoneNumber,wxNumber,money,wbName" +
                " from " + TABLE_NAME, null);
        while (cursor.moveToNext()) {
            String name = cursor.getString(0);
            String phoneNumber = cursor.getString(1);
            String wxNumber = cursor.getString(2);
            String money = cursor.getString(3);
            String wbName = cursor.getString(4);
            JVBean user = new JVBean();
            user.setName(name);
            user.setPhoneNumber(phoneNumber);
            user.setWxNumber(wxNumber);
            user.setMoney(money);
            user.setWBName(wbName);
            list.add(user);
        }

        return list;
    }

    /**
     * 关闭数据库连接
     */
    public void setClose() {
        if (db != null) {
            db.close();
        }
    }


}