DBUtils

/**
 * 测试DbUtil工具包
 */
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Iterator;
import java.util.List;
import org.apache.commons.dbutils.DbUtils;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.ResultSetHandler;
import org.apache.commons.dbutils.handlers.BeanHandler;
import org.apache.commons.dbutils.handlers.BeanListHandler;

/**
 * @author Administrator
 *
 */
public class TestDbUtils {

            public static Connection getConnection() {
                        Connection conn = null;
                        String driver = "com.mysql.jdbc.Driver";
                        String url = "jdbc:mysql://127.0.0.1/test?useUnicode=true&characterEncoding=gbk";
                        DbUtils.loadDriver(driver);
                        try {
                                    conn = DriverManager.getConnection(url, "root", "wjb1234");
                        } catch (SQLException e) {
                                    e.printStackTrace();
                        }
                        return conn;
            }

            @SuppressWarnings({"unchecked", "deprecation"})
            public static void getBeanListData() {
                        Connection conn = getConnection();
                        QueryRunner qr = new QueryRunner();
                        try {
                                    ResultSetHandler<Test> rsh = new BeanHandler(Test.class);
                                    
                                    Test test = qr.query(conn,
                                            "SELECT * from test where id=?", rsh,
                                            "1");

                                    System.err.println(test.getId() + "\t" + test.getContent() + "\t" + test.getPid() + "\t" + test.getEtime() + "\t" + test.getCtime());

                                    List<Test> results = (List<Test>) qr.query(conn, "SELECT * from test",
                                            new BeanListHandler(Test.class));

                                    System.out.println(results.size());
                                    for (Iterator<Test> it = results.iterator(); it.hasNext();) {
                                                Test tests = it.next();
                                                System.err.println(tests.getId() + "\t" + tests.getContent() + "\t" + tests.getPid() + "\t" + tests.getEtime() + "\t" + tests.getCtime());
                                    }

                        } catch (SQLException e) {
                                    e.printStackTrace();
                        } finally {
                                    DbUtils.closeQuietly(conn);
                        }
            }

            public static void main(String[] args) {
                        getBeanListData();
            }
}
class Test {

            private java.lang.Integer id;
            private java.lang.String content;
            private java.lang.Integer pid;
            private java.sql.Time ctime;
            private java.lang.String etime;

            public java.lang.Integer getId() {
                        return id;
            }

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

            public java.lang.String getContent() {
                        return content;
            }

            public void setContent(java.lang.String content) {
                        this.content = content;
            }

            public java.lang.Integer getPid() {
                        return pid;
            }

            public void setPid(java.lang.Integer pid) {
                        this.pid = pid;
            }

            public java.sql.Time getCtime() {
                        return ctime;
            }

            public void setCtime(java.sql.Time ctime) {
                        this.ctime = ctime;
            }

            public java.lang.String getEtime() {
                        return etime;
            }

            public void setEtime(java.lang.String etime) {
                        this.etime = etime;
            }
}