Skip to content

Instantly share code, notes, and snippets.

@bl4ckck

bl4ckck/DatabaseContract.java

Last active April 7, 2021 11:25
Show Gist options
  • Save bl4ckck/20b979ae5d11e4071c7ac676f26b8a00 to your computer and use it in GitHub Desktop.
Save bl4ckck/20b979ae5d11e4071c7ac676f26b8a00 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
DatabaseContract.java
// Define Column Table & Table Name
public final class DatabaseContract {
private DatabaseContract() {
}
public static class TbDosen implements BaseColumns {
public static final String TABLE_NAME = "dosen";
public static final String COLUMN_NAME_NAMA = "nama";
public static final String COLUMN_NAME_EMAIL = "email";
}
}
Raw
DatabaseHelper.java
// Membuat Helper untuk SQLite dengan mengextend SQLiteOpenHelper
// Mendfinisikan DB
public class DatabaseHelper extends SQLiteOpenHelper {
public DatabaseHelper(Context context, String dbName, @Nullable SQLiteDatabase.CursorFactory factory, int dbVersion) {
super(context, dbName, factory, dbVersion);
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL(SQL_CREATE_TbDOSEN);
}
@Override
public void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int i1) {
}
public void onDowngrade(SQLiteDatabase db, int oldVersion, int newVersion) {
onUpgrade(db, oldVersion, newVersion);
}
// DDL Create Table
private static final String SQL_CREATE_TbDOSEN =
"CREATE TABLE " + DatabaseContract.TbDosen.TABLE_NAME + " (" +
DatabaseContract.TbDosen._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," +
DatabaseContract.TbDosen.COLUMN_NAME_NAMA + " TEXT," +
DatabaseContract.TbDosen.COLUMN_NAME_EMAIL + " TEXT)";
}
Raw
MainActivity.java
public class MainActivity extends AppCompatActivity {
DBCrudHelper _SQLITE_crudHelper;
DatabaseHelper _dbHelper;
ArrayList<RecyclerViewList> myListData = new ArrayList<RecyclerViewList>();
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
// Create DB and Dosen Table
_dbHelper = new DatabaseHelper(this, "dbBimbingan", null, 1); // Instance SQLite Helper
_SQLITE_crudHelper = new DBCrudHelper(_dbHelper); // Instance DB Helper (Query)
_SQLITE_crudHelper.clearTable(DatabaseContract.TbDosen.TABLE_NAME);
// Declare ContentValues (A key/value store that inserts data into a row of a table.)
ContentValues Dosen1 = new ContentValues();
ContentValues Dosen2 = new ContentValues();
// Insert to ContentValues (key & value)
Dosen1.put("nama", "nama dosen 1");
Dosen1.put("email", "dosen1@ub.ac.id");
Dosen2.put("nama", "nama dosen 2");
Dosen2.put("email", "dosen2@ub.ac.id");
//Insert Data to DB
_SQLITE_crudHelper.insertDosen(Dosen1);
_SQLITE_crudHelper.insertDosen(Dosen2);
//Store data from SQLite to Array list RecyclerViewList
myListData.add(new RecyclerViewList(_SQLITE_crudHelper.getDosen(null).get(0).get("nama") + " (id: " + _SQLITE_crudHelper.getDosen(null).get(0).get("id") + ") " + _SQLITE_crudHelper.getDosen(null).get(0).get("email")));
myListData.add(new RecyclerViewList(_SQLITE_crudHelper.getDosen(null).get(1).get("nama") + " (id: " + _SQLITE_crudHelper.getDosen(null).get(1).get("id") + ") " + _SQLITE_crudHelper.getDosen(null).get(1).get("email")));
// Set Recyclerview Adapter
RecyclerView recyclerView = (RecyclerView) findViewById(R.id.rec);
MyListAdapter adapter = new MyListAdapter(myListData);
recyclerView.setHasFixedSize(true);
recyclerView.setLayoutManager(new LinearLayoutManager(this));
recyclerView.setAdapter(adapter);
}
// Close SQLite Connection
@Override
protected void onDestroy() {
_dbHelper.close();
super.onDestroy();
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment