jdbc-helper

Designed as simple alternative to Spring JDBCTemplate, must be run under JDK 11 or above. It was created so that I could move some projects from Spring Boot to Quarkus.

It will work with any JDBC Driver and uses a DataSource.

Example Code, based off the Unit Test:

JdbcDataSource ds;

ds = new JdbcDataSource();
ds.setUrl("jdbc:h2:./test_db");
new JDBCHelper(ds).update("CREATE TABLE IF NOT EXISTS names (id BIGINT NOT NULL PRIMARY KEY, name VARCHAR(20), seq INT)");
new JDBCHelper(ds).update("DELETE FROM names");
new JDBCHelper(ds).update("INSERT INTO names (id, name, seq) VALUES (1, 'Name 1', 100)");
new JDBCHelper(ds).update("INSERT INTO names (id, name, seq) VALUES (2, 'Name 2', 200)");
new JDBCHelper(ds).update("INSERT INTO names (id, name, seq) VALUES (3, 'Name 3', 300)");
new JDBCHelper(ds).update("INSERT INTO names (id, name, seq) VALUES (4, 'Name 4', 400)");
new JDBCHelper(ds).update("INSERT INTO names (id, name, seq) VALUES (5, 'Name 5', 500)");

var lst = new JDBCHelper(ds).query("SELECT * FROM names ORDER by id",
        (rs, idx) -> Name.builder().id(rs.getLong("id")).name(rs.getString("name")).seq(rs.getInt("seq")).build());
for (int i = 0; i < 5; i++) {
    var j = i + 1;
    assertEquals(j, lst.get(i).getId());
    assertEquals("Name " + j, lst.get(i).getName());
    assertEquals(j * 100, lst.get(i).getSeq());
}

var opt = new JDBCHelper(ds).queryObject("SELECT * FROM names WHERE id = 3",
            (rs, idx) -> Name.builder().id(rs.getLong("id")).name(rs.getString("name")).seq(rs.getInt("seq")).build());
    assertTrue(opt.isPresent());
    assertEquals(3, opt.get().getId());
    assertEquals("Name 3", opt.get().getName());
    assertEquals(300, opt.get().getSeq());
}

new JDBCHelper(ds).execute("SELECT * FROM names WHERE id = 4", (rs) -> {
    assertEquals(4, rs.getLong("id"));
    assertEquals("Name 4", rs.getString("name"));
    assertEquals(400, rs.getInt("seq"));
});

new JDBCHelper(ds).update("UPDATE names SET seq = 1000 WHERE id = 5");
new JDBCHelper(ds).queryObject("SELECT * FROM names WHERE id = 5",
        (rs, idx) -> Name.builder().id(rs.getLong("id")).name(rs.getString("name")).seq(rs.getInt("seq")).build())
        .ifPresent(n -> {
            assertEquals(5, n.getId());
            assertEquals("Name 5", n.getName());
            assertEquals(1000, n.getSeq());
        });

Copyright Anameg Consulting Ltd 2020