mysql - 不显示表格行

Question

您好我正在尝试执行此搜索代码，但它只显示列名而不是行。

@WebServlet("/SearchEmployee")
public class SearchEmployee extends HttpServlet {
 protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
   response.setContentType("text/html");
   PrintWriter out = response.getWriter();
   String fname = request.getParameter("fullname");
   String desg = request.getParameter("designation");
   String email = request.getParameter("email");
   String uname = request.getParameter("username");
   String password = request.getParameter("password");

   try {
    Class.forName("com.mysql.jdbc.Driver");
    Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/employee", "root", "root");

    PreparedStatement ps = con.prepareStatement("select * from reg where  fname=? or desg=? or email=? or uname=? or pass=?");

    ps.setString(1, fname);
    ps.setString(2, desg);
    ps.setString(3, email);
    ps.setString(4, uname);
    ps.setString(5, password);


    request.getRequestDispatcher("./Home.jsp").include(request, response);
    out.println("<table id=\"mytable\">");

    ResultSet rs = ps.executeQuery();
    ResultSetMetaData rsmd = rs.getMetaData();
    int total = rsmd.getColumnCount();
    out.print("<tr>");
    for (int i = 1; i <= total; i++) {
     out.print("<th>" + rsmd.getColumnName(i) + "</th>");
    }

    out.print("</tr>");

    while (rs.next()) {


     out.print("<tr><td>" + rs.getString(1) + "</td><td>" + rs.getString(2) + "</td><td>" + rs.getString(3) + "</td><td>" + rs.getString(4) + "</td><td>" + rs.getString(5) + "</td></tr>");


    }

    out.print("</table>");

   } catch (Exception e2) {
    e2.printStackTrace();
   }

标签： mysqljspservlets