Index

dbutils

hello world
PGSimpleDataSource ds = new PGSimpleDataSource();
ds.setServerName("localhost");
ds.setDatabaseName("test");
ds.setUser("postgres");
ds.setPassword("Ch@ng3m3");

QueryRunner runner = new QueryRunner(ds);
runner.update("create table if not exists deleteme (text varchar(255) not null)");
runner.update("insert into deleteme (text) values ('hello world')");
String result = runner.query("select * from deleteme", new ScalarHandler<String>());
System.out.println(result);
runner.update("drop table deleteme");
batch update example
runner.update("create table if not exists deleteme (id integer, text varchar(255))");

String insert = "insert into deleteme (id, text) values (?, ?)";
runner.batch(insert, new Object[][] { { 1, "batch 1" }, { 2, "batch 2" } });

List<Object[]> result = runner.query("select * from deleteme", new ArrayListHandler());
for (Object[] line : result) {
	System.out.println(Arrays.asList(line));
}