Java hsqldb 接続 [ commons-dbutils ]

メモ

Java MySQL 接続 [ commons-dbutils ] を hsqldb 用に変更 （マアカワラナイ）
SELECT * FROM DUAL 的な書き方がちょっと特殊

import java.sql.SQLException;

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.MapHandler;
import org.hsqldb.jdbc.JDBCDataSource;

public class Main {

    public static final String URL = "jdbc:hsqldb: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.setDatabaseName(DBNAME);
        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 FROM (VALUES(0))", mapHandler, i, j)
                    .get("ANS"));
        }
    }

}