报错信息
Exception in thread "main" java.sql.SQLException: Cannot create
com.hsp.chapter25.Apache.Actor: class org.apache.commons.dbutils.BeanProcessor cannot
access a member of class com.hsp.chapter25.Apache.Actor with modifiers "public" Query:
select * from stu where id > ? Parameters: [1]
源代码
在queryRunner.query中给 模板类时报错
可以看到我是将Actor.class放在一起的,根据提示,应该是分开写用pulic修饰
package com.hsp.chapter25.Apache;
import com.hsp.chapter25.Druid.JDBCByDruid;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.ResultSetHandler;
import org.apache.commons.dbutils.handlers.BeanListHandler;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;
public class Apache {
public static void main(String[] args) throws SQLException {
Connection connection = JDBCByDruid.getConnection();
QueryRunner queryRunner = new QueryRunner();
String sql = "select * from stu where id > ?";
List<Actor> query = queryRunner.query(connection, sql, new BeanListHandler<>(Actor.class), 1);
for (Actor actor : query) {
System.out.println(actor);
}
JDBCByDruid.close(null, null, connection);
}
}
class Actor {
private Integer id;
private String name;
public Actor() {//一定要给一个无参构造器[反射需要]
}
public Actor(Integer id, String name) {
this.id = id;
this.name = name;
}
@Override
public String toString() {
return "Actor{" +
"id=" + id +
", name='" + name + '\'' +
'}';
}
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
}
修改
分开写
1、Apache.class
package com.hsp.chapter25.Apache;
import com.hsp.chapter25.Druid.JDBCByDruid;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.ResultSetHandler;
import org.apache.commons.dbutils.handlers.BeanListHandler;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;
public class Apache {
public static void main(String[] args) throws SQLException {
Connection connection = JDBCByDruid.getConnection();
QueryRunner queryRunner = new QueryRunner();
String sql = "select * from stu where id > ?";
List<Actor> query = queryRunner.query(connection, sql, new BeanListHandler<>(Actor.class), 1);
for (Actor actor : query) {
System.out.println(actor);
}
JDBCByDruid.close(null, null, connection);
}
}
2、Actor.java
一定要设置设置属性和对应的get,set方法
如果设置了有参构造器,对应的无参构造器也要写,否则报错
默认不写构造器也是可以的
写有参构造器,无参构造器也要写
package com.hsp.chapter25.Apache;
public class Actor {
private Integer id;
private String name;
public Actor() {
}
public Actor(Integer id, String name) {
this.id = id;
this.name = name;
}
@Override
public String toString() {
return "Actor{" +
"id=" + id +
", name='" + name + '\'' +
'}';
}
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
}
不写构造器,也是OK的
package com.hsp.chapter25.Apache;
public class Actor {
private Integer id;
private String name;
@Override
public String toString() {
return "Actor{" +
"id=" + id +
", name='" + name + '\'' +
'}';
}
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
}