Skip to content

Instantly share code, notes, and snippets.

@sharifulislam52
Last active March 20, 2018 09:17
Show Gist options
  • Save sharifulislam52/6e8897343f888b2df82b4bc03f5e9da2 to your computer and use it in GitHub Desktop.
Save sharifulislam52/6e8897343f888b2df82b4bc03f5e9da2 to your computer and use it in GitHub Desktop.
public class Database extends SQLiteOpenHelper {
public Database(Context context) {
super(context, "database_name", null, 1);
}
@Override
public void onCreate(SQLiteDatabase sqLiteDatabase) {
sqLiteDatabase.execSQL("CREATE TABLE table_name (table_id INTEGER PRIMARY KEY AUTOINCREMENT," +
"column_1 TEXT, column_2 TEXT)");
}
@Override
public void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int i1) {
sqLiteDatabase.execSQL("DROP TABLE IF EXISTS table_name");
onCreate(sqLiteDatabase);
}
/**
* insert Data into table
*/
public void insert_data(String c1_text, String c2_text){
SQLiteDatabase sqLiteDatabase = this.getWritableDatabase();
ContentValues table_values = new ContentValues();
table_values.put("column_1", c1_text);
table_values.put("column_2", c2_text);
// Inserting Row
sqLiteDatabase.insert("table_name",null,table_values); //tableName, nullColumnHack, CotentValues
sqLiteDatabase.close();
}
/**
* get All data from table
*/
public Cursor get_data(){
SQLiteDatabase sqLiteDatabase = this.getWritableDatabase();
Cursor table_cursor = sqLiteDatabase.rawQuery("SELECT * FROM table_name", null);
return table_cursor;
}
// update area ----->
/**
* update single column
*/
public boolean updateSingleColumn(String c_name, String update_string, String where_c_name, String identifier_string){
SQLiteDatabase sqLiteDatabase = this.getWritableDatabase();
ContentValues table_values = new ContentValues();
table_values.put(c_name,update_string);
sqLiteDatabase.update("table_name", table_values, where_c_name + "= ?", new String[]{identifier_string});
return true;
}
/**
* update a row by id
*/
public boolean updateAllDataById(String c1_text, String c2_text, String where_id){
SQLiteDatabase sqLiteDatabase = this.getWritableDatabase();
ContentValues table_values = new ContentValues();
table_values.put("column_1", c1_text);
table_values.put("column_2", c2_text);
sqLiteDatabase.update("table_name",table_values,"id= ?", new String[]{where_id});
return true;
}
// <----- update area
/**
* delete a row
*/
public Integer delete_forever(String where_c, String match_string){
SQLiteDatabase sqLiteDatabase = this.getWritableDatabase();
return sqLiteDatabase.delete("table_name", where_c+" = ?", new String[]{match_string});
}
}
// database_name, table_name, table_id, column_1, column_2
Database database = new Database(this);
public void get_sqlite_data(){
Cursor table_cursor = database.get_data();
if (table_cursor.getCount() == 0){}
while(table_cursor.moveToNext()){
StringBuffer id = new StringBuffer();
id.append(table_cursor.getString(0));
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment