java.sql.SQLException: Column 'password' not found.

Question

    public static List<Doctor> select(Integer id,String password,String name,Integer deptId,Integer sex) {
        try {
            String sql = "select id,name,dept_id,sex from doctor";
            sql+=" where 1=1";
            if(id!=null) {
                sql+=" and id="+id;
            }
            if(password!=null) {
                sql+=" and password='"+password+"'";
            }
            if(name!=null) {
                sql+=" and name='"+name+"'";
            }
            if(deptId!=null) {
                sql+=" and dept_id="+deptId;
            }
            if(sex!=null) {
                sql+=" and sex="+sex;
            }
            sql+=";";
            System.out.println(sql);
            return fillResult(sql);
        }catch(Exception e) {
            e.printStackTrace();
            return new LinkedList<>();
        }
    }
    
    public static List<Doctor> fillResult(String sql) throws SQLException,ClassNotFoundException{
        List<Doctor> doctorList = new LinkedList<>();
        Connection conn=null;
        PreparedStatement pstmt=null;
        ResultSet rs=null;
        try {
            conn=DbUtil.getconnection();
            pstmt=conn.prepareStatement(sql);
            rs=pstmt.executeQuery();
            while(rs.next()) {
                Doctor doctor=new Doctor(rs.getInt("id"),rs.getString("name"),rs.getInt("dept_id"),rs.getInt("sex"),rs.getString("password"));
                doctorList.add(doctor);
            }
        }finally {
            DbUtil.release(rs, pstmt,conn);
        }
        return doctorList;
    }
    
}

请选择操作
1.登录
2.查看挂号记录
3.退出

---

1
*请输入账号：
1
*请输入密码：
123456
select id,name,dept_id,sex from doctor where 1=1 and id=1 and password='123456';
java.sql.SQLException: Column 'password' not found.
医生账号或密码错误，登录失败.

---

请选择操作
1.登录
2.查看挂号记录
3.退出

---

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1093)
at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5488)
at dao.DoctorDao.fillResult(DoctorDao.java:110)
at dao.DoctorDao.select(DoctorDao.java:93)
at service.DoctorService.login(DoctorService.java:36)
at exp4.test.doctorLogin(test.java:145)
at exp4.test.doctorFlow(test.java:168)
at exp4.test.main(test.java:197)

Answer 1

doctor表有password这个字段吗