Android(安卓)SQLiteDatabase的使用

package com.shawn.test;import android.content.ContentValues;import android.content.Context;import android.database.Cursor;import android.database.sqlite.SQLiteDatabase;import android.database.sqlite.SQLiteOpenHelper;import android.util.Log;public class DatabaseAdapter{private static final String DB_NAME = "Test.db";//数据库名private static final int DB_VERSION = 1;//数据库版本private static final String DB_TABLE = "my_order";//表名private static final String KEY_ID = "_id";//idprivate static final String KEY_ORDER_ID = "order_id";//订单号private static final String KEY_TYPE = "_type";//订单类型private static final String KEY_STATE = "_state";//订单状态private Context context;private DatabaseHelper mDatabaseHelper;private SQLiteDatabase mSQLiteDatabase;private static class DatabaseHelper extends SQLiteOpenHelper{//创建数据库语句private static final String DB_CREAT = "CREATE TABLE "+ DB_TABLE+ " (" + KEY_ID + " INTEGER PRIMARY KEY,"+ KEY_ORDER_ID + " TEXT,"+ KEY_TYPE + " INTEGER,"+ KEY_STATE + " INTEGER)";public DatabaseHelper(Context context) {super(context, DB_NAME,  null , DB_VERSION);}@Overridepublic void onCreate(SQLiteDatabase db) {// TODO Auto-generated method stubdb.execSQL(DB_CREAT);}@Overridepublic void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {// TODO Auto-generated method stubdb.execSQL("DROP TABLE IF EXISTS "+DB_TABLE);onCreate(db);}}public DatabaseAdapter(Context context) {this.context = context;}//开启public void open() {mDatabaseHelper = new DatabaseHelper(context);          mSQLiteDatabase = mDatabaseHelper.getWritableDatabase();}//关闭public void close() { mSQLiteDatabase.close();mDatabaseHelper.close();}//增public long insertData(String orderId, int type) {  ContentValues values = new  ContentValues();   values.put(KEY_ORDER_ID, orderId); values.put(KEY_TYPE, type);values.put(KEY_STATE, Config.STATE_APPLY); long id = mSQLiteDatabase.insert(DB_TABLE, KEY_ID, values); return id;}//删public boolean deleteData(Context context, long id) {boolean delete = mSQLiteDatabase.delete(DB_TABLE, KEY_ID + "=" +id, null)>0;return delete;}//改public boolean updateData(long id, int state) {ContentValues values = new  ContentValues();  values.put(KEY_STATE, ""+state); boolean update = mSQLiteDatabase.update(DB_TABLE, values, KEY_ID + "=" +id, null)>0;return update;}//查public Cursor fetchData(String selection) {Cursor mCursor = mSQLiteDatabase.query(DB_TABLE, new String[]{KEY_ID, KEY_ORDER_ID, KEY_TYPE, KEY_STATE}, selection, null, null, null, null);if(mCursor != null)mCursor.moveToFirst();return mCursor;}}
更多相关文章

随机推荐
