JSP页面
<%@ page import="com.hnpi.domain.Tianjia" %> <%@ page import="java.util.List" %> <%@ page import="java.util.ArrayList" %><%-- Created by IntelliJ IDEA. User: Lenovo Date: 2019/10/31 Time: 21:16 To change this template use File | Settings | File Templates. --%> <%@ page contentType="text/html;charset=UTF-8" language="java" %> <html> <head> <title>展示页面</title> <script src="js/jquery-3.1.1.min.js"></script> </head> <body> <center> <table> <tr> <td>ID</td> <td>number</td> <td>pwd</td> <td>bumen</td> <td>juse</td> </tr> <% List<Tianjia> list = (ArrayList)session.getAttribute("list"); for(Tianjia tianjia : list){ %> <tr> <td><%=tianjia.getId()%></td> <td><%=tianjia.getNumber()%></td> <td><%=tianjia.getPwd()%></td> <td><%=tianjia.getBumen()%></td> <td><%=tianjia.getJuse()%></td> </tr> <% } %> </table> </center> </body> </html>Servlet页面
package com.hnpi.servlet; import com.hnpi.domain.Tianjia; import com.hnpi.util.DBUtil; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import java.io.IOException; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.ArrayList; import java.util.List; @WebServlet(value = "/ListServlet") public class ListServlet extends HttpServlet { protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("utf-8"); HttpSession session = request.getSession(); Connection conn = DBUtil.getConn(); PreparedStatement ps = null; ResultSet rs = null; String sql = "select * from Tianjia"; List<Tianjia> tianjiaList = new ArrayList<Tianjia>(); try { ps = conn.prepareStatement(sql); rs = ps.executeQuery(); while(rs.next()){ Tianjia tianjia = new Tianjia(rs.getInt(1),rs.getInt(2),rs.getString(3),rs.getString(4),rs.getString(5),rs.getString(6)); tianjiaList.add(tianjia); } }catch (Exception e){ e.printStackTrace(); }finally { DBUtil.close(conn,ps,rs); } session.setAttribute("list",tianjiaList); request.getRequestDispatcher("list.jsp").forward(request,response); } protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { this.doPost(request,response); } }好，这个查询页面就这么多代码，是不是很简单
