为什么while (rs.next())只出现最后一条数据,怎么改呢

public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
HttpSession session = request.getSession(true);
request.setCharacterEncoding("UTF-8");
response.setContentType("text/html;charset=UTF-8");
new StringBuffer();
commentinform inform = new commentinform();
request.setAttribute("commentinform", inform);
StringBuffer str1 = new StringBuffer();
String selectmov = request.getParameter("moviesname");
Connection con = null;
String uri = "jdbc:mysql://localhost:3306/movies";
String userName = "root";
String userPwd = " ";

    try {
        Class.forName("com.mysql.cj.jdbc.Driver");
        con = DriverManager.getConnection(uri, userName, userPwd);
        Statement sql = con.createStatement();
        ResultSet rs = sql.executeQuery(
                "SELECT movieName,contents,time,userName FROM movie,filmreview,users WHERE movie.movieNub=filmreview.moviesNub AND users.userNub=filmreview.userNub AND movieName='"
                        + selectmov + "'");
        while (rs.next()) {
            inform.setMovieName(rs.getString(1));
            inform.setContents(rs.getString(2));
            inform.setTime(rs.getString(3));
            inform.setUsername(rs.getString(4));
        }
        con.close();
    } catch (Exception var12) {
        ;
    }
    RequestDispatcher dispatcher = request.getRequestDispatcher("admin_home/onecomment.jsp");
    dispatcher.forward(request, response);
}

while(rs.next()) 意思是结果集如果还有下一个值就继续循环
要接受多个值 可以设置个集合 然后在循环里添加进去


        List<commentinform> list = new ArrayList<>();
        while (rs.next()) {
            inform = new commentinform(); 
            inform.setMovieName(rs.getString(1));
            inform.setContents(rs.getString(2));
            inform.setTime(rs.getString(3));
            inform.setUsername(rs.getString(4));
            list.add(inform)
        }

while(rs.hasNext()){
rs.next();//自己搞个变量赋值,然后从变量中去取数据
....
}