The SQL Database Adapter provides simple methods for selecting, inserting, deleting, and updating data in your SQL database.
The default provider is the T-DataBaseAPI library but you can create your own implementation of this adapter.
T-DataBaseAPI -
SQLDatabaseAdapter methods
void executeUpdateAsync(String sql); //Executes update async
ResultSet executeQueryAsync(String query); //Executes query async
void insert(String tableName, Object... data); //Inserts data to database
//Deletes all from table when the where condition is pass, this is not truncate action
void deleteAllWhere(String tableName, String whereCondition);
//Updates some fields provided in map when the where condition is pass
void updateWhere(String tableName, Map<String, Object> data, String whereCondition);
ResultSet selectAll(String tableName); //Selects all data from table
//Selects all data from table when the where condition is pass
ResultSet selectWhere(String tableName, String whereCondition, String... columnNames);
How to create your own implemantion of this adapter?
public class MySQLDatabaseAdapter implements SQLDatabaseAdapter {
@Override
public void executeUpdateAsync(String query) {
}
@Override
public ResultSet executeQueryAsync(String query) {
return null;
}
@Override
public void insert(String tableName, Object... data) {
}
@Override
public void deleteAllWhere(String tableName, String whereCondition) {
}
@Override
public void updateWhere(String tableName, Map<String, Object> data, String whereCondition) {
}
@Override
public ResultSet selectAll(String tableName) {
}
@Override
public ResultSet selectWhere(String tableName, String whereCondition, String... columnNames) {
}
}