- Common ways to obtain DBI
private void myMethod () {DBI d =
DataSource dataSource;new DBI(dataSource)
ConnectionFactory connectionFactory;new DBI(connectionFactory)
String url;String username;String password;new DBI(url, username, password)
- Smart code suggestions by Codota
}
@Test public void testOpenNewSpiffy() throws Exception { Spiffy spiffy = dbi.open(Spiffy.class); try { spiffy.insert(new Something(1, "Tim")); spiffy.insert(new Something(2, "Diego")); assertEquals("Diego", spiffy.findNameById(2)); } finally { dbi.close(spiffy); } assertTrue(spiffy.getHandle().getConnection().isClosed()); }
@Test public void testOpenNewSpiffy() throws Exception { Spiffy spiffy = dbi.open(Spiffy.class); try { spiffy.insert(new Something(1, "Tim")); spiffy.insert(new Something(2, "Diego")); assertEquals("Diego", spiffy.findNameById(2)); } finally { dbi.close(spiffy); } assertTrue(spiffy.getHandle().getConnection().isClosed()); }