Created
October 22, 2019 06:47
-
-
Save mohosyny/14805bf8220e6e252c431cc65609b94c to your computer and use it in GitHub Desktop.
DataBase Class with common method
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
public class MyDatabase extends SQLiteOpenHelper { | |
private static final String DB_NAME="mohosyny"; | |
private static final int DB_VERSION=1; | |
private static final String TBL_NAME="news"; | |
private static final String COL_ID="id"; | |
private static final String COL_TITLE="title"; | |
private static final String COL_DESC="description"; | |
private static final String COL_IMG="image"; | |
private static final String COL_DATE="date"; | |
private static final String QUERY="CREATE TABLE IF NOT EXISTS "+TBL_NAME+"("+ | |
COL_ID+" INTEGER PRIMARY KEY AUTOINCREMENT, "+ | |
COL_TITLE+" TEXT,"+ | |
COL_DESC+" TEXT,"+ | |
COL_IMG+" TEXT,"+ | |
COL_DATE+" TEXT);"; | |
private Context context; | |
public MyDatabase(Context context) { | |
super(context, DB_NAME, null, DB_VERSION); | |
this.context=context; | |
} | |
@Override | |
public void onCreate(SQLiteDatabase db) { | |
try{ | |
db.execSQL(QUERY); | |
}catch (SQLException e){ | |
e.printStackTrace(); | |
} | |
} | |
@Override | |
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { | |
} | |
public long addInfo(String title, String desc,String img, String date){ | |
ContentValues contentValues=new ContentValues(); | |
contentValues.put(COL_TITLE,title); | |
contentValues.put(COL_DESC,desc); | |
contentValues.put(COL_IMG,img); | |
contentValues.put(COL_DATE,date); | |
SQLiteDatabase sqLiteDatabase=this.getWritableDatabase(); | |
return sqLiteDatabase.insert(TBL_NAME,null,contentValues); | |
/* if(result>0){ | |
return result; | |
}else{ | |
return result; | |
}*/ | |
} | |
public Cursor getInfos(){ | |
String query="SELECT * FROM "+TBL_NAME; | |
SQLiteDatabase sqLiteDatabase=this.getReadableDatabase(); | |
return sqLiteDatabase.rawQuery(query,null); | |
} | |
public Cursor getSomeData(){ | |
String name="mahla"; | |
String query="SELECT * FROM "+TBL_NAME+" WHERE "+COL_ID+" = ?"; | |
SQLiteDatabase sqLiteDatabase=this.getReadableDatabase(); | |
return sqLiteDatabase.rawQuery(query,new String[]{String.valueOf(name)}); | |
} | |
public void updateRow(){ | |
int age=222; | |
SQLiteDatabase sqLiteDatabase=this.getWritableDatabase(); | |
ContentValues contentValues=new ContentValues(); | |
contentValues.put(COL_DATE,age); | |
sqLiteDatabase.update(TBL_NAME,contentValues,COL_DATE+" = ?",new String[]{String.valueOf(12)}); | |
} | |
public void deleteRow(){ | |
SQLiteDatabase sqLiteDatabase=this.getWritableDatabase(); | |
sqLiteDatabase.delete(TBL_NAME,COL_DATE+" = ?",new String[]{String.valueOf(20)}); | |
} | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment