DBUtils

来源：互联网发布：viove录屏软件编辑：程序博客网时间：2024/05/29 15:49
/** * 测试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;            }}
0 0