例如:
QueryRunner queryRunner = new QueryRunner(JDBCUtils.getDataSource());
String sql="select * from category";
List<Category> query = queryRunner.query(sql, new BeanListHandler<Category>(Category.class));
这时的Category对象中的属性需要set、get方法,否则查询不到数据。如下:
public class Category {
private String cid;
private String cname;
public String getCid() {
return cid;
}
public void setCid(String cid) {
this.cid = cid;
}
public String getCname() {
return cname;
}
public void setCname(String cname) {
this.cname = cname;
}
}