public class c3p0_connection {
public static void main(String[] args) throws Exception {
ComboPooledDataSource source = new ComboPooledDataSource();//创建对象
String sql="select * from root";
QueryRunner runner = new QueryRunner(source);
List<Root> list = runner.query(sql,new BeanListHandler<Root>(Root.class));
for (Root root : list) {
System.out.println(root.getPassword());
System.out.println(root.getUsername());
}
}
Exception in thread "main" java.sql.SQLException: Cannot create JavaBean.Root: JavaBean.Root Query: select * from root Parameters: []
at org.apache.commons.dbutils.AbstractQueryRunner.rethrow(AbstractQueryRunner.java:527)
at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:391)
at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:347)
at JavaBean.c3p0_connection.main(c3p0_connection.java:14)
一直报错:connot create bean 。 原因是Root类中没有无参构造,补充一个无参函数即可解决问题