public class DBOpenHelper {
private static final String DATABASE_NAME = "Device_List.db";
private static final int DATABASE_VERSION = 1;
public static final String CREATE_HISTORY_TABLE_QUERY = "Create Table Device_List(id integer primary key autoincrement, SSID TEXT, " +
"BSSID TEXT);";
public static final String DRP_HISTORY_QUERY = "Drop Table IF Exits Device_List";
public static final String Table_Name = "Device_List";
public static SQLiteDatabase mDB;
private DatabaseHelper mDBHelper;
private Context mCtx;
private class DatabaseHelper extends SQLiteOpenHelper {
public DatabaseHelper(Context context, String name, SQLiteDatabase.CursorFactory factory, int version) {
super(context, name, factory, version);
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL(CREATE_HISTORY_TABLE_QUERY);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
db.execSQL(DRP_HISTORY_QUERY);
onCreate(db);
}
}
public DBOpenHelper(Context context) {
this.mCtx = context;
}
public DBOpenHelper open() throws SQLException {
mDBHelper = new DatabaseHelper(mCtx, DATABASE_NAME, null, DATABASE_VERSION);
mDB = mDBHelper.getWritableDatabase();
return this;
}
public void close(){
mDB.close();
}
public long insertColumn(String SSID, String BSSID){
ContentValues values = new ContentValues();
values.put("SSID", SSID);
values.put("BSSID", BSSID);
return mDB.insert(Table_Name, null, values);
}
public void UpdateColumn(String SSID, String BSSID, String id){
ContentValues values = new ContentValues();
values.put("SSID", SSID);
values.put("BSSID", BSSID);
mDB.update(Table_Name, values, "id = ?", new String[]{id} );
}
public Cursor getAllColumns(){
String query = "select * from Device_List;";
Cursor result = mDB.rawQuery(query, null);
return result;
}
public Cursor selectData(){
String query = "select * from Device_List";
Cursor result = mDB.rawQuery(query, null);
return result;
}
public void DeleteData(String id){
mDB.delete(Table_Name,"id=?", new String[]{id});
}
public void DeleteAll(){
mDB.delete(Table_Name, null, null);
}
}