Java sql 没有为参数号 1 设置值。
public void personfind(person person) throws SQLException{
person p = null;
Connection conn = sjk2.getConnection();
String sql ="select Eno,Cno,En,Sex,Etitle,Eage,Esal from zhigong where Eno= ?";
PreparedStatement ps = conn.prepareStatement(sql);
ResultSet rs = ps.executeQuery();
while(rs.next()){//如果对象中有数据,就会循环打印出来
p = new person();
p.setEno(rs.getString("Eno"));
p.setCno(rs.getString("Cno"));
p.setEn(rs.getString("En"));
p.setSex(rs.getString("Sex"));
p.setEtitle(rs.getString("Etitle"));
p.setEage(rs.getInt("Eage"));
p.setEsal(rs.getInt("Esal"));
}
public static void main(String[] args) throws SQLException {
// TODO Auto-generated method stub
sjk3 p = new sjk3();
//search
person person1 = new person();
p.personfind(person1);
person1.setEno("152501");
}
请大神看一下我这个代码 如何给变量赋值 哪里需要修改
错误提示:没有为参数号 1 设置值。