Last active
March 20, 2018 09:17
-
-
Save sharifulislam52/6e8897343f888b2df82b4bc03f5e9da2 to your computer and use it in GitHub Desktop.
This file contains 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 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 |
This file contains 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
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