Java MySQL 接続 [ commons-dbutils ]

メモ
ORMツールを自作する場合に便利そうだな。

import java.sql.SQLException;

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.MapHandler;

import com.mysql.jdbc.jdbc2.optional.MysqlDataSource;

public class Main {

    public static final String URL = "jdbc:mysql://localhost:3306/base1";
    public static final String USER = "base1";
    public static final String PASS = "base1";

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

        MapHandler mapHandler = new MapHandler();

        MysqlDataSource dataSource = new MysqlDataSource();
        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"));
        }
    }

}

URLの形式がわからなくても登録できるみたいなのでいじってみた。

import java.sql.SQLException;

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.MapHandler;

import com.mysql.jdbc.jdbc2.optional.MysqlDataSource;

public class Main {

    public static final String URL = "jdbc:mysql://localhost:3306/base1";
    public static final String DBNAME = "base1";
    public static final String USER = "base1";
    public static final String PASS = "base1";

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

        MapHandler mapHandler = new MapHandler();

        MysqlDataSource dataSource = new MysqlDataSource();
        // dataSource.setUrl(URL);
        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", mapHandler,
                    i, j).get("ANS"));
        }
    }

}

こっちのが楽。