用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(); } }