Android SQLiteOpenHelper
16lz
2021-01-23
阅读更多
使用:
package com.achilies.yuqingxitong.util;import android.content.ContentValues;import android.content.Context;import android.database.Cursor;import android.database.sqlite.SQLiteDatabase;import android.database.sqlite.SQLiteOpenHelper;public class DBHelper extends SQLiteOpenHelper {private static final String DB_NAME = "yuqing.db";private static final String WARN = "t_warn";// 创建SQL语句private static final String warnSql = " CREATE TABLE t_warn (_ID INTEGER PRIMARY KEY autoincrement,u_aid INTEGER,u_level INTEGER,u_title text,u_url text,u_site text,u_tmpost text,u_content text)";// SQLiteDatabase实例private SQLiteDatabase db;public DBHelper(Context context) {super(context, DB_NAME, null, 1);}@Overridepublic void onCreate(SQLiteDatabase db) {db.execSQL(warnSql);}// 打开数据库public void open() {db = getWritableDatabase();}@Overridepublic void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {// TODO Auto-generated method stubString sql = "DROP TABLE IF EXISTS " + WARN;db.execSQL(sql);onCreate(db);}public void dropTable(String tableName) {String sql = "DROP TABLE IF EXISTS " + WARN;db.execSQL(sql);}public void createTable(String tableName) {db.execSQL(warnSql);}// 插入方法public void insert(ContentValues values, String tableName) {db.insert(tableName, null, values);}// 查询方法public Cursor query(String tableName) {Cursor c = db.query(tableName, null, null, null, null, null, "_ID asc");return c;}// 查询方法public Cursor queryByName(String name) {Cursor c = db.query(WARN, null, "u_title=?", new String[] { name },null, null, "_ID desc");return c;}// 修改public void updata(ContentValues values, String name) {db.update(WARN, values, "u_title=?", new String[] { name });}// 删除方法public void del(String u_username) {db.delete(WARN, "u_title=?", new String[] { u_username });}// 关闭数据库public void close() {if (db != null) {db.close();}}}
使用:
DBHelper dbHelper = new DBHelper(context);dbHelper.open();dbHelper.del(dataList.get(cur).getTitle());dbHelper.close();
更多相关文章
- android SQLite数据库使用实例
- android中操纵sqlite数据库
- android 笔记 --- 自定义Android主题风格theme.xml方法
- android工程下运行main方法的配置方法
- Android Studio无法新建创建android工程解决方法
- Android Studio设置主题 和 不支持中文的问题解决方法
- Flutter下载更新App的方法示例
- android map的使用方法