数据库查询不到结果集

用servlet查找数据库的一条记录，但是总是查找到为null，竟然花了我将近一个小时的时间，程序员就是总给自己挖坑

这次原因查找到rs没有执行while(rs.next())！！！然后总是不能给student赋值

数据库连接一定要好好记住！！

 

Student student = new Student();
PreparedStatement ps = null;
ResultSet rs = null;
Connection conn = Connect.getConnection();
String sql = "select id,name,score from student where id = ?";
try {
    ps = conn.prepareStatement(sql);
    ps.setInt(1, id);
    rs = ps.executeQuery();
    while (rs.next()) {
        student.setId(rs.getInt(1));
        student.setName(rs.getString(2));
        student.setScore(rs.getInt(3));
    }
} catch (SQLException e) {
    e.printStackTrace();
} finally {
    try {
        rs.close();
    } catch (SQLException e) {
        e.printStackTrace();
    }
    try {
        ps.close();
    } catch (SQLException e) {
        e.printStackTrace();
    }
    try {
        conn.close();
    } catch (SQLException e) {
        e.printStackTrace();
    }
}