<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>
安卓中sqlite数据库的增删改查操作的工具类
最新推荐文章于 2024-06-27 16:09:35 发布