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();//自己搞个变量赋值,然后从变量中去取数据
....
}