DbUtils.loadDriver("oracle.jdbc.driver.OracleDriver"); try{ String sql = "select id,name,phone from guestbook"; Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:zhuhesid", "scott", "tiger"); QueryRunner qr = new QueryRunner(); List list = (List)qr.query(conn, sql, new MapListHandler()); DbUtils.close(conn); Iterator<Map> iter = list.iterator(); Map map = null; while(iter.hasNext()){ map = iter.next(); System.out.print("id=" + map.get("id")+" "); System.out.print("name=" + map.get("name")+" "); System.out.print("phone=" + map.get("phone")+" "); System.out.println(); } }catch(SQLException e){ } DbUtils类 加载驱动,关闭连接 MapListHandler 结果放在List中,List中放map对象 BeanListHandler,记录封装到javabean中,javabean对象放入List 关键代码 import java.sql.*; import java.util.Iterator; import java.util.List; import org.apache.commons.dbutils.*; import org.apache.commons.dbutils.handlers.BeanListHandler; DbUtils.loadDriver("oracle.jdbc.driver.OracleDriver"); try { String sql = "select id,name,phone from guestbook"; String url = "jdbc:oracle:thin:@localhost:1521:zhuhesid"; Connection conn = DriverManager.getConnection(url, "scott", "tiger"); QueryRunner qr = new QueryRunner(); List<GuestBookBean> list = (List<GuestBookBean>) qr.query(conn,sql, new BeanListHandler(GuestBookBean.class)); DbUtils.close(conn); Iterator<GuestBookBean> iter = list.iterator(); GuestBookBean gb = null; while (iter.hasNext()) { gb = iter.next(); System.out.print("id=" + gb.getId()); System.out.print(" name=" + gb.getName()); System.out.println(" phone=" + gb.getPhone()); } } catch (SQLException e) { }