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;
/** * Created by HasanJawaid on 10/20/2017. */
public class DatabaseHandler extends SQLiteOpenHelper {
SQLiteDatabase sqLiteDatabase=getWritableDatabase();
private static final String dbname="sampledb";
private static final int dbver=1;
public DatabaseHandler(Context context) {
super(context, dbname, null, dbver);
}
@Override
public void onCreate(SQLiteDatabase db) {
String CreateTableQry="Create Table if not exists UBAG(" +
"id integer primary key autoincrement not null, " +
"uname text , " +
"pword text , " +
"fname text , " +
"lname text , " +
"age integer, " +
"email text , " +
"gender text )";
db.execSQL(CreateTableQry);
Log.e("","UBAG Table Created...");
CreateTableQry = "Create Table if not exists USHIS(" +
"id integer, " +
"ldate Date, " +
"timein integer, " +
"timeout integer ) ";
db.execSQL(CreateTableQry);
Log.e("","USHIS Table Created...");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
db.execSQL("Drop table if exists UBAG");
db.execSQL("Drop table if exists USHIS");
onCreate(db);
}
public long insert(ContentValues values,String TableName){
return (long) sqLiteDatabase.insert(TableName,null,values);
}
public long update(ContentValues values,String TableName,String criteria){
return sqLiteDatabase.update(TableName,values,criteria,null);
}
public long delete(String TableName,String criteria){
return sqLiteDatabase.delete(TableName,criteria,null);
}
public Cursor getData(String query){
Cursor cursor=null;
try {
cursor = sqLiteDatabase.rawQuery(query, null);
}catch (Exception e){
Log.e("GD","DB Helper Found Error " + query);
}
cursor.moveToFirst();
return cursor;
}
}
No comments:
Post a Comment