Apache组件commons的DbUtils的用法实例

1 代码要连接数据库是可以跑通的，可是本人真心表示这个封装的太垃圾，远不及自己写的顺手，不建议再学一套db连接的方法，这个感觉写的还有点复杂，不好用，不推荐

package com.commons.dbutils;import java.util.*;import java.util.logging.*;import java.sql.*;import org.apache.commons.dbutils.*;import org.apache.commons.dbutils.handlers.*;public class DbUtilsTest {public static void main(String[] args) throws Exception {DbUtilsTest test = new DbUtilsTest();for (int i = 0; i < 1; i++) {test.testQuery1();test.testQuery2();test.testUpdate();}}public void testQuery1() {try {QueryRunner qr = new QueryRunner();ResultSetHandler rsh = new ArrayListHandler();String strsql = "select * from test1";ArrayList result = (ArrayList) qr.query(getConnection(), strsql,rsh);// System.out.print("");} catch (Exception ex) {ex.printStackTrace(System.out);}}public void testQuery2() {try {QueryRunner qr = new QueryRunner();ResultSetHandler rsh = new MapListHandler();String strsql = "select * from test1";ArrayList result = (ArrayList) qr.query(getConnection(), strsql,rsh);for (int i = 0; i < result.size(); i++) {Map map = (Map) result.get(i);// System.out.println(map);}// System.out.print("");} catch (Exception ex) {ex.printStackTrace(System.out);}}public void testUpdate() {try {QueryRunner qr = new QueryRunner();ResultSetHandler rsh = new ArrayListHandler();String strsql = "insert test1(page ,writable ,content)values('ttt','ttt','faskldfjklasdjklfjasdklj')";qr.update(getConnection(), strsql);// System.out.print("");} catch (Exception ex) {ex.printStackTrace(System.out);}}private Connection getConnection() throws InstantiationException,IllegalAccessException, ClassNotFoundException, SQLException {String strDriver = "com.mysql.jdbc.Driver";String strUrl = "jdbc:mysql://localhost:3306/test";String strUser = "root";String strPass = "root";Class.forName(strDriver).newInstance();return DriverManager.getConnection(strUrl, strUser, strPass);}}