Java h2database 接続 [ commons-dbutils ]

メモ

Java MySQL 接続 [ commons-dbutils ] を h2 用に変更 （マアカワラナイ）

import java.sql.SQLException;

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.MapHandler;
import org.h2.jdbcx.JdbcDataSource;

public class Main {

	public static final String URL = "jdbc:h2:file:test";
	public static final String DBNAME = "test";
	public static final String USER = "sa";
	public static final String PASS = "";

	public static void main(String[] args) throws SQLException {

		MapHandler mapHandler = new MapHandler();

		JdbcDataSource dataSource = new JdbcDataSource();
		
		dataSource.setURL(URL);
		dataSource.setUser(USER);
		dataSource.setPassword(PASS);

		QueryRunner runner = new QueryRunner(dataSource);

		for (int i = 0, j = 10; i < 10; i++, j = j << 2) {
			System.out.println(runner.query("SELECT ? + ? AS ANS", mapHandler,
					i, j).get("ANS"));
		}
	}

}