123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225 |
- package me.yoqi.mobile.db;
- 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;
- import me.yoqi.mobile.info.Call_Forbid_Info;
- import me.yoqi.mobile.info.Call_Record_Info;
- import me.yoqi.mobile.info.Message_Forbid_Info;
- import me.yoqi.mobile.info.Message_Rubbish_Info;
- public class DbAdapter {
- private static final String TAG = "DbAdapter";
- private DatabaseHelper mDatabaseHelper;
- private SQLiteDatabase mSQLiteDatabase;
- private Context mContext;
- private static final String DB = "db.db";
- private static final int DB_VERSION = 1;
- // 5个表:短信黑名单表,短信垃圾箱表,来电黑名单表,来电拦截记录表
- public static final String MESSAGE_FORBID_TABLE_NAME = "message_forbid_table";
- public final static String MESSAGE_RUBBISH_TABLE_NAME = "message_rubbish_table";
- public final static String CALL_FORBID_TABLE_NAME = "call_forbid_table";
- public final static String CALL_RECORD_TABLE_NAME = "call_record_table";
- // 公用id字段
- public static final String TABLE_ID = "_id";
- // 短信黑名单表字段:来电号码
- public final static String MESSAGE_FORBID_PHONE = "message_forbid_phone";
- // 短信垃圾箱表字段:垃圾短信号码,收件时间,短信内容
- public static final String MESSAGE_RUBBISH_PHONE = "message_rubbish_phone";
- public static final String MESSAGE_RUBBISH_TIME = "message_rubbish_time";
- public final static String MESSAGE_RUBBISH_CONTENT = "message_rubbish_content";
- // 来电黑名单表字段:黑名单号码
- public static final String CALL_FORBID_PHONE = "call_forbid_phone";
- // 来电拦截记录表字段:黑名单号码:来电时间,来电归属地
- public static final String CALL_RECORD_PHONE = "call_record_phone";
- public static final String CALL_RECORD_TIME = "call_record_time";
- public static final String CALL_RECORD_AREA = "call_record_area";
- public DbAdapter(Context mCtx) {
- Log.d(TAG, "mCtxmTab");
- mContext = mCtx;
- }
- public void close() {
- Log.d(TAG, "close");
- mDatabaseHelper.close();
- }
- public DbAdapter open() {
- Log.d(TAG, "open");
- mDatabaseHelper = new DatabaseHelper(mContext);
- mSQLiteDatabase = mDatabaseHelper.getWritableDatabase();
- return this;
- }
- public Cursor getAll(String table) {
- Log.d(TAG, "getAll");
- return mSQLiteDatabase.rawQuery("select * from " + table, null);
- }
- public Cursor getPhone(String phone, int i) {
- Cursor mReturn = null;
- switch (i) {
- case 1:
- mReturn = mSQLiteDatabase.rawQuery("select * from " + MESSAGE_RUBBISH_TABLE_NAME + " where " + MESSAGE_RUBBISH_PHONE + "=" + "\'" + phone + "\'", null);
- break;
- case 2:
- mReturn = mSQLiteDatabase.rawQuery("select * from " + MESSAGE_FORBID_TABLE_NAME + " where " + MESSAGE_FORBID_PHONE + "=" + "\'" + phone + "\'", null);
- break;
- case 3:
- mReturn = mSQLiteDatabase.rawQuery("select * from " + CALL_RECORD_TABLE_NAME + " where " + CALL_RECORD_PHONE + "=" + "\'" + phone + "\'", null);
- break;
- case 4:
- mReturn = mSQLiteDatabase.rawQuery("select * from " + CALL_FORBID_TABLE_NAME + " where " + CALL_FORBID_PHONE + "=" + "\'" + phone + "\'", null);
- break;
- }
- return mReturn;
- }
- public Cursor getTime(String tableName, String columnName, String recordTime) {
- return mSQLiteDatabase.rawQuery("select * from " + tableName + " where " + columnName + " = " + "\'" + recordTime + "\'", null);
- }
- public Cursor getId(long id, String tableName) {
- return mSQLiteDatabase.rawQuery("select * from " + tableName + " where " + TABLE_ID + " = " + id, null);
- }
- public Long getAdd(Message_Rubbish_Info mInfo) {
- ContentValues mValues = new ContentValues();
- mValues.put(MESSAGE_RUBBISH_CONTENT, mInfo.getMessage_rubbish_content());
- mValues.put(MESSAGE_RUBBISH_PHONE, mInfo.getMessage_rubbish_phone());
- mValues.put(MESSAGE_RUBBISH_TIME, mInfo.getMessage_rubbish_time());
- long rowId = mSQLiteDatabase.insert(MESSAGE_RUBBISH_TABLE_NAME, null, mValues);
- return rowId;
- }
- public Long getAdd(Message_Forbid_Info mInfo) {
- ContentValues mValues = new ContentValues();
- mValues.put(MESSAGE_FORBID_PHONE, mInfo.getMessage_forbid_phone());
- long rowId = mSQLiteDatabase.insert(MESSAGE_FORBID_TABLE_NAME, null, mValues);
- return rowId;
- }
- public Long getAdd(Call_Forbid_Info mInfo) {
- ContentValues mValues = new ContentValues();
- mValues.put(CALL_FORBID_PHONE, mInfo.getCall_forbid_phone());
- long rowId = mSQLiteDatabase.insert(CALL_FORBID_TABLE_NAME, null, mValues);
- return rowId;
- }
- public Long getAdd(Call_Record_Info mInfo) {
- ContentValues mValues = new ContentValues();
- mValues.put(CALL_RECORD_AREA, mInfo.getCall_record_area());
- mValues.put(CALL_RECORD_PHONE, mInfo.getCall_record_phone());
- mValues.put(CALL_RECORD_TIME, mInfo.getCall_record_time());
- long rowId = mSQLiteDatabase.insert(CALL_RECORD_TABLE_NAME, null, mValues);
- return rowId;
- }
- public boolean getDel(long rowId, String table) {
- return mSQLiteDatabase.delete(table, TABLE_ID + "=" + rowId, null) > 0;
- }
- public boolean getDel(String table, String column, String phone) {
- return mSQLiteDatabase.delete(table, column + "=?", new String[]{phone}) > 0;
- }
- public void deleteTable(String tableName) {
- mSQLiteDatabase.execSQL("delete from " + tableName);
- }
- private static class DatabaseHelper extends SQLiteOpenHelper {
- StringBuilder mStringBuilder_1;
- StringBuilder mStringBuilder_2;
- StringBuilder mStringBuilder_3;
- StringBuilder mStringBuilder_4;
- public DatabaseHelper(Context context) {
- super(context, DB, null, DB_VERSION);
- }
- public void initCreateSQL() {
- mStringBuilder_1 = new StringBuilder();
- mStringBuilder_1.delete(0, mStringBuilder_1.length());
- Log.d(TAG, "initCreateSQL");
- mStringBuilder_1.append("create table ");
- mStringBuilder_1.append(MESSAGE_RUBBISH_TABLE_NAME);
- mStringBuilder_1.append("(");
- mStringBuilder_1.append(TABLE_ID);
- mStringBuilder_1.append(" integer primary key AUTOINCREMENT,");
- mStringBuilder_1.append(MESSAGE_RUBBISH_PHONE);
- mStringBuilder_1.append(" text ,");
- mStringBuilder_1.append(MESSAGE_RUBBISH_TIME);
- mStringBuilder_1.append(" text ,");
- mStringBuilder_1.append(MESSAGE_RUBBISH_CONTENT);
- mStringBuilder_1.append(" text ");
- mStringBuilder_1.append(" );");
- Log.d(TAG, "MESSAGE_RUBBISH_TABLE_NAME");
- mStringBuilder_2 = new StringBuilder();
- mStringBuilder_2.append("create table ");
- mStringBuilder_2.append(MESSAGE_FORBID_TABLE_NAME);
- mStringBuilder_2.append("( ");
- mStringBuilder_2.append(TABLE_ID);
- mStringBuilder_2.append(" integer primary key AUTOINCREMENT,");
- mStringBuilder_2.append(MESSAGE_FORBID_PHONE);
- mStringBuilder_2.append(" text");
- mStringBuilder_2.append(" );");
- Log.d(TAG, "MESSAGE_FORBID_TABLE_NAME");
- mStringBuilder_3 = new StringBuilder();
- mStringBuilder_3.append("create table ");
- mStringBuilder_3.append(CALL_RECORD_TABLE_NAME);
- mStringBuilder_3.append("( ");
- mStringBuilder_3.append(TABLE_ID);
- mStringBuilder_3.append(" integer primary key AUTOINCREMENT,");
- mStringBuilder_3.append(CALL_RECORD_PHONE);
- mStringBuilder_3.append(" text,");
- mStringBuilder_3.append(CALL_RECORD_TIME);
- mStringBuilder_3.append(" text,");
- mStringBuilder_3.append(CALL_RECORD_AREA);
- mStringBuilder_3.append(" text ");
- mStringBuilder_3.append(" );");
- Log.d(TAG, "CALL_RECORD_TABLE_NAME");
- mStringBuilder_4 = new StringBuilder();
- mStringBuilder_4.append("create table ");
- mStringBuilder_4.append(CALL_FORBID_TABLE_NAME);
- mStringBuilder_4.append("( ");
- mStringBuilder_4.append(TABLE_ID);
- mStringBuilder_4.append(" integer primary key AUTOINCREMENT,");
- mStringBuilder_4.append(CALL_FORBID_PHONE);
- mStringBuilder_4.append(" text");
- mStringBuilder_4.append(" );");
- Log.d(TAG, "CALL_FORBID_TABLE_NAME");
- }
- @Override
- public void onCreate(SQLiteDatabase db) {
- Log.d(TAG, "onCreate");
- Log.d(TAG, "mStringBuilder");
- initCreateSQL();
- db.execSQL(mStringBuilder_1.toString());
- Log.d(TAG, mStringBuilder_1.toString());
- db.execSQL(mStringBuilder_2.toString());
- Log.d(TAG, mStringBuilder_2.toString());
- db.execSQL(mStringBuilder_3.toString());
- Log.d(TAG, mStringBuilder_3.toString());
- db.execSQL(mStringBuilder_4.toString());
- Log.d(TAG, mStringBuilder_4.toString());
- }
- @Override
- public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
- db.execSQL("drop table if exists" + MESSAGE_RUBBISH_TABLE_NAME, null);
- Log.d(TAG, "onUpgrade");
- }
- }
- }
|