1 public class DbUtilsExample() {
   2   public static void main(String[] args) {
   3     // (주의) load함수는 실행할때마다 파일을 읽습니다.
   4     HashMap map = QueryLoader.getInstance().load("sql");
   5 
   6     String driver = "com.mysql.jdbc.Driver";
   7     String jdbcURI = "jdbc:mysql://localhost/mysql";
   8     String user = "root";
   9     String password = "";
  10     Connection conn = null;
  11 
  12     if (!DbUtils.loadDriver(driver)) {
  13       System.out.println("Failed Loading JDBC Driver!");
  14       System.exit(0);
  15     }
  16     try {
  17       conn = DriverManager.getConnection(jdbcURI, user, password);
  18 
  19       ArrayList params = new ArrayList();
  20       params.add(args[0]);
  21 
  22       ResultSetHandler rsh = new BeanListHandler(BoardVO.class);
  23       QueryRunner qr = new QueryRunner();
  24       List list = qr.query(conn, (String)map.get("select"), params.toArray(), rsh);
  25 
  26       for (int i = 0; i < list.size(); i++) {
  27         BoardVO board = (BoardVO)list.get(i);
  28         System.out.println(board.getTitle());
  29         System.out.println(board.getContent());
  30         System.out.println(board.getWriter());
  31       }
  32     }
  33     catch (Exception e) {
  34       System.out.println(e);
  35     }
  36     finally {
  37       DbUtils.closeQuietly(conn);
  38     }
  39   }
  40 }