数据库操作类

来源：互联网发布：linux下perl开发工具编辑：程序博客网时间：2024/05/18 16:14
public class DBUtil {private static DBUtil mInstance;private Context mContext;private SQLHelper mSQLHelp;private SQLiteDatabase mSQLiteDatabase;private DBUtil(Context context) {mContext = context;mSQLHelp = new SQLHelper(context);mSQLiteDatabase = mSQLHelp.getWritableDatabase();}/** * 初始化数据库操作DBUtil类 */public static DBUtil getInstance(Context context) {if (mInstance == null) {mInstance = new DBUtil(context);}return mInstance;}/** * 关闭数据库 */public void close() {mSQLHelp.close();mSQLHelp = null;mSQLiteDatabase.close();mSQLiteDatabase = null;mInstance = null;}/** * 添加数据 */public void insertData(ContentValues values) {mSQLiteDatabase.insert(SQLHelper.TABLE_CHANNEL, null, values);}/** * 更新数据 *  * @param values * @param whereClause * @param whereArgs */public void updateData(ContentValues values, String whereClause,String[] whereArgs) {mSQLiteDatabase.update(SQLHelper.TABLE_CHANNEL, values, whereClause,whereArgs);}/** * 删除数据 *  * @param whereClause * @param whereArgs */public void deleteData(String whereClause, String[] whereArgs) {mSQLiteDatabase.delete(SQLHelper.TABLE_CHANNEL, whereClause, whereArgs);}/** * 查询数据 *  * @param columns * @param selection * @param selectionArgs * @param groupBy * @param having * @param orderBy * @return */public Cursor selectData(String[] columns, String selection,String[] selectionArgs, String groupBy, String having,String orderBy) {Cursor cursor = mSQLiteDatabase.query(SQLHelper.TABLE_CHANNEL,columns, selection, selectionArgs, groupBy, having, orderBy);return cursor;}}
0 0