public class DBException extends Exception {
}
public class DatabaseUpdateException extends Exception {
}
try {
DBConnection dbConnection = new DBConnection("database.db");
dbConnection.open();
String sql = "SELECT * FROM users";
DBStatement statement = new DBStatement(dbConnection);
statement.query(sql);
dbConnection.beginTransaction();
String insertSql = "INSERT INTO users (name, age) VALUES ('John Doe', 25)";
statement.insert(insertSql);
String updateSql = "UPDATE users SET age = 30 WHERE name = 'John Doe'";
statement.update(updateSql);
String deleteSql = "DELETE FROM users WHERE age > 50";
statement.delete(deleteSql);
dbConnection.commitTransaction();
dbConnection.close();
} catch (DBException e) {
e.printStackTrace();
} catch (DatabaseUpdateException e) {
e.printStackTrace();
}
implementation 'com.iantz.dbtools:dbtools:1.0.0'
