//查询员工信息publicstaticEmployeequeryEmployeeOne(Stringid){Stringsql="selectemployeeId,name,password,roleIdfromemployeewhereemployeeId=?";Employeeemployee=newEmployee()...
//查询员工信息
public static Employee queryEmployeeOne(String id){
String sql="select employeeId,name,password,roleId from employee where employeeId=?";
Employee employee=new Employee();
try {
statement=(PreparedStatement) getConnection().prepareStatement(sql);
statement.setString(1,id);
rs=statement.executeQuery();
while(rs.next()){
employee.setEmployeeId(rs.getString("employeeId"));
employee.setName(rs.getString("name"));
// employee.setTeam(rs.getString(3));
employee.setPassword(rs.getString("password"));
employee.setRoleId(rs.getInt("roleId"));
}
} catch (SQLException e) {
e.printStackTrace();
}
return employee;
} 这是我的一个查询方法。 没有加前缀。 可还是报错。 不知咋的。、
展开