安卓中sqlite数据库的增删改查操作的工具类

<span style="font-family:Microsoft YaHei;font-size:18px;">将数据库中的增删改查操作封装成一个类，使用时直接调用很方便package com.qianfeng.day14_sqliteopenhelper2.db;import android.content.ContentValues;import android.database.Cursor;import android.database.sqlite.SQLiteDatabase;public class DbManage {private MySqliteHelper helper;public DbManage(MySqliteHelper helper){this.helper = helper;}/** * 增  删   改 * @param sql */public void changeData(String sql){SQLiteDatabase db = helper.getReadableDatabase();db.execSQL(sql);db.close();}/** * 查 * @param sql * @param selectionArgs * @return */public  Cursor queryData(String sql, String[] selectionArgs){SQLiteDatabase db = helper.getReadableDatabase();Cursor cursor = db.rawQuery(sql, selectionArgs);return cursor;}/** * api  插入 */public long ApiInSertData(String table, ContentValues values){SQLiteDatabase db = helper.getReadableDatabase();long l = db.insert(table, null, values);return l;}/** * api  修改 */public int ApiUpdataData(String table, ContentValues values, String whereClause, String[] whereArgs){SQLiteDatabase db = helper.getReadableDatabase();int l = db.update(table, values, whereClause, whereArgs);return l;}/** * api  删除 */public int ApiDeleteData(String table, String whereClause, String[] whereArgs){SQLiteDatabase db = helper.getReadableDatabase();int l = db.delete(table, whereClause, whereArgs);return l;}/** * api  查询 */public Cursor ApiQueryData(String table, String[] columns, String selection, String[] selectionArgs, String groupBy, String having, String orderBy){SQLiteDatabase db = helper.getReadableDatabase();Cursor cursor = db.query(table, columns, selection, selectionArgs, groupBy, having, orderBy);return cursor;}}</span>