commons dbutils 使用方法

Common Dbutils是操作数据库的组件，对传统操作数据库的类进行二次封装，可以把结果集转化成List。
组件包含的主要类和接口：

DbUtils类：启动类

ResultSetHandler接口：转换类型接口

MapListHandler类：实现类，把记录转化成List

BeanListHandler类：实现类，把记录转化成List，使记录为JavaBean类型的对象

Qrery Runner类：执行SQL语句的类

例子：Guestbook.JAVA

public class Guestbook {
 private Integer id;
 private String name;

 public Integer getId() {
  return id;
 }

 public void setId(Integer id) {
  this.id = id;
 }

 public String getName() {
  return name;
 }

 public void setName(String name) {
  this.name = name;
 }
}

 

BeanListExample.JAVA

import org.apache.commons.dbutils.DbUtils;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanListHandler;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.List;

public class BeanListExample {
 public static void main(String[] args) {
  Connection conn = null;
  String url = "jdbc:oracle:thin:@192.168.1.20:1521:ora9";
  String jdbcDriver = "oracle.jdbc.driver.OracleDriver";
  String user = "scott";
  String password = "tiger";

  DbUtils.loadDriver(jdbcDriver);
  try {
   conn = DriverManager.getConnection(url, user, password);
   QueryRunner qr = new QueryRunner();
   List results = (List) qr.query(conn, "select id,name from guestbook", new BeanListHandler(Guestbook.class));
   for (int i = 0; i < results.size(); i++) {
    Guestbook gb = (Guestbook) results.get(i);
    System.out.println("id:" + gb.getId() + ",name:" + gb.getName());
   }
  } catch (SQLException e) {
   e.printStackTrace();
  } finally {
   DbUtils.closeQuietly(conn);
  }
 }
}