Connection connection = DriverManager.getConnection(url, username, password);
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery("SELECT * FROM table_name");
connection.setAutoCommit(false);
try {
// ...
connection.commit();
} catch (SQLException e) {
connection.rollback();
} finally {
connection.setAutoCommit(true);
}
groovy
dependencies {
implementation "com.squareup.sqldelight:sqlite-driver:<version>"
implementation "com.squareup.sqldelight:jdbc-driver:<version>"
}
