DbUtils使用

概念:

DbUtils类:用于启动,加载驱动等

ResultSetHandler接口:将ResultSet包装(转换)为其他类型,如何转换则定义在ResultSetHandler接口中.

MapListhandler类与BeanListHandler类都实现了ResultSetHandler接口,其中

MapListHandler将ResultSet包装为List<Map<String, Object>> 类型,

BeanListHandler将ReslutSet包装为List<Object>类型,Object为javaBean.

QueryRunner:执行SQL语句,获取结果.

例子:

1/使用MapListHandler类;

/** * @param args */ public static void main(String[] args) { String driver = "org.apache.derby.jdbc.EmbeddedDriver"; String url = "jdbc:derby://localhost:1527/myeclipse"; String username = "gudong2945"; String password = "31415926"; String sql = "select * from guestbook"; DbUtils.loadDriver(driver);//装载驱动类 try { //获取Connection对象 Connection conn = DriverManager.getConnection(url,username,password); //获取QueryRunner对象 QueryRunner qr = new QueryRunner(); //获取结果 //qr.query(Connection对象,sql语句,MapListHandler对象)返回List<Map<String, Object>>后,强制转换为List类型; List result = (List)qr.query(conn, sql, new MapListHandler()); //关闭Connection DbUtils.close(conn); //读取每条记录 Map map = null; for(int i = 0 ; i < result.size(); i++){ map = (Map)result.get(i); System.out.println("id"+map.get("id")+"/t"); System.out.println("name"+map.get("name")+"/t"); System.out.println("email"+map.get("email")+"/t"); System.out.println("title"+map.get("title")+"/t"); System.out.println("content"+map.get("content")+"/t"); } } catch (SQLException e) { e.printStackTrace(); } 

2/使用BeanListHandler类;

public static void main(String[] args) { String driver = "org.apache.derby.jdbc.EmbeddedDriver"; String url = "jdbc:derby://localhost:1527/myeclipse"; String username = "gudong2945"; String password = "31415926"; String sql = "select * from guestbook"; DbUtils.loadDriver(driver);//装载驱动类 try { Connection conn = DriverManager.getConnection(url, username, password);//获取Connection,不使用数据源 QueryRunner qr = new QueryRunner();//获取QueryRunner对象 //qr.query(Connection对象,sql语句,BeanListHandler对象)返回List<Object>>后,强制转换为List类型; List result = (List) qr.query(conn, sql, new BeanListHandler(Guestbook.class)); //关闭Connection对象 DbUtils.close(conn); //GuestBook为javaBean Guestbook gb = null; for (int i = 0; i < result.size(); i++) { gb = (Guestbook) result.get(i); System.out.println("id" + gb.getId() + "/t"); System.out.println("name" + gb.getName() + "/t"); System.out.println("email" + gb.getPhone() + "/t"); System.out.println("title" + gb.getTitle() + "/t"); System.out.println("content" + gb.getContent() + "/t"); } } catch (SQLException e) { e.printStackTrace(); }

 3/使用数据源及DbUtils(注意对sql占位符号的使用,而且可以不出现Connection对象,也不需要关闭它)

//数据源已在Tomcat中配置好 String sql = "insert into guestbook(id,name,email,phone,title,content,time)" + "values(DEFAULT,?,?,?,?,?,CURRENT DATE)"; Context context = new InitialContext(); DataSource ds = (DataSource) context.lookup("java:/comp/env/jdbc/myderby"); QueryRunner qr = new QueryRunner(ds); String param[] = { request.getParameter("name"), request.getParameter("email"), request.getParameter("phone"), request.getParameter("title"), request.getParameter("content") }; qr.update(sql, param);