android sqlite 中文乱码。。麻烦详细点

package cn.reciteWord.operation;import android.content.ContentValues;import android.content.Context;import android.database.Cursor;import android.database.SQLException;import android.database.sqlite.SQLiteDatabase;import android.database.sqlite.SQLiteOpenHelper;/* *  创建数据库 */public class MyDataBaseAdapter {public static String DB_NAME = "vocabulary.db";public static String ID = "_id";public static String CHA = "chinese";public static String ENG = "english";private static String tableName = "vocabulary";private static int version = 1;private static final String DB_CREATE = "CREATE TABLE IF NOT EXISTS " + tableName + " (" + ID + " INTEGER PRIMARY KEY," + CHA + " TEXT," + ENG + " TEXT)";private Context mContext = null;private SQLiteDatabase mSqLiteDatabase = null;//保存返回的数据库对象private DataBaseHelper mDataBaseHelper = null;private static class DataBaseHelper extends SQLiteOpenHelper {public DataBaseHelper(Context context) {super(context, DB_NAME, null, version );// TODO Auto-generated constructor stub}@Overridepublic void onCreate(SQLiteDatabase db) {// TODO Auto-generated method stubdb.execSQL(DB_CREATE);}@Overridepublic void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {// TODO Auto-generated method stub// 删除以前的旧表，创建一张新的空表          db.execSQL("DROP TABLE IF EXISTS " + DB_NAME);          onCreate(db);          }}public MyDataBaseAdapter(Context context) {// TODO Auto-generated constructor stubmContext = context;}//打开数据库, 返回数据库对象public void open() throws SQLException{mDataBaseHelper = new DataBaseHelper(mContext);}//关闭数据库public void close() {mDataBaseHelper.close();}public long insertData(String en, String ch) {// 插入数据mSqLiteDatabase = mDataBaseHelper.getWritableDatabase();ContentValues mContentValues = new ContentValues();mContentValues.put(ENG, en);mContentValues.put(CHA, ch);return mSqLiteDatabase.insert(tableName, ID, mContentValues);}public boolean deleteData(long rowID) {// 删除一条数据mSqLiteDatabase = mDataBaseHelper.getWritableDatabase();return mSqLiteDatabase.delete(tableName, ID + "=" + rowID, null) > 0;}public Cursor fetchAllData() {//查询所有数据mSqLiteDatabase = mDataBaseHelper.getWritableDatabase();return mSqLiteDatabase.query(tableName, new String[] {ID, ENG, CHA}, null, null, null, null, null);}public Cursor fetchData(long rowID)throws SQLException {mSqLiteDatabase = mDataBaseHelper.getWritableDatabase();Cursor cursor = mSqLiteDatabase.query(true, tableName, new String[] {ID, ENG, CHA}, ID + "=" + rowID, null, null, null, null, null);if(cursor != null) {cursor.moveToFirst();}return cursor;}public boolean updateData(long rowId, String en, String ch) {//更新一条数据mSqLiteDatabase = mDataBaseHelper.getWritableDatabase();ContentValues mContentValues = new ContentValues();mContentValues.put(ENG, en);mContentValues.put(CHA, ch);return mSqLiteDatabase.update(tableName, mContentValues, ID + "=" + rowId, null) > 0;}}
更多相关文章

随机推荐
