ConnectionSource connectionSource = new JdbcConnectionSource(databaseUrl, username, password);
try {
DatabaseConnection connection = connectionSource.getReadWriteConnection();
connection.setAutoCommit(false);
try {
Dao<User, Integer> userDao = DaoManager.createDao(connectionSource, User.class);
userDao.create(user1);
userDao.create(user2);
connection.commit();
} catch (SQLException e) {
connection.rollback();
e.printStackTrace();
} finally {
connection.close();
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
connectionSource.close();
}
