import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class JDBCTest {

	public static void main(String args[]) {
		try {
			// (1) データベースとの接続の確立
			Class.forName("org.hsqldb.jdbcDriver");
			String url = "jdbc:hsqldb:hsql://localhost";
			Connection con = DriverManager.getConnection(url, "sa", "");

			// (2) SQLの実行
			String selectStatement =
				"select title " +
				"from books where title like ?";
			PreparedStatement prepStmt =
				con.prepareStatement(selectStatement);
			prepStmt.setString(1, "%Java%");
			ResultSet rs = prepStmt.executeQuery();

			// (3) SQLの実行結果の処理
			while (rs.next()) {
				String title = rs.getString("title");
				System.out.println(title);
			}

			// (4) 後始末
			rs.close();
			prepStmt.close();
			con.close();

		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
}