如何在JSP页面中显示数据库表(How to display a database table in the JSP page)

我正试图将我的用户表显示在我的JSP页面的表中。但是当我运行JSP页面时数据不会显示。

我有一个名为“eyetracker”的mySQL模式和一个名为“user”的表。感谢您的帮助..如果可能，我想通过使用servlet检索mySQL数据并将其显示在JSP页面中...

<%@ page import="java.sql.ResultSet" %> <%@ page import="java.sql.Statement" %> <%@ page import="java.sql.Connection" %> <%@ page import="java.sql.DriverManager" %> <form method="post"> <table border="2"> <tr> <td>user ID</td> <td>Birthday</td> <td>Gender</td> <td>First Name</td> <td>Last Name</td> </tr> <% try { Class.forName("com.mysql.jdbc.Driver"); String url="jdbc:mysql://localhost:3306/eyetracker"; String username="root"; String password="root"; String query="select * from eyetracker"; Connection conn=DriverManager.getConnection(url, username, password); Statement stmt=conn.createStatement(); ResultSet rs=stmt.executeQuery(query); while(rs.next()) { %> <tr><td><%rs.getInt("userID"); %></td></tr> <tr><td><%rs.getDate("dob"); %></td></tr> <tr><td><%rs.getString("gender"); %></td></tr> <tr><td><%rs.getString("firstName"); %></td></tr> <tr><td><%rs.getString("lastName"); %></td></tr> <% } %> </table> <% rs.close(); stmt.close(); conn.close(); } catch(Exception e) { e.printStackTrace(); } %> </form>`

I am trying to display my user table on to a table in my JSP page. But the data is not shown when I run the JSP page.

I have a mySQL schema called "eyetracker" and a table called "user". Appreciate your help.. If possible , I want to retrieve mySQL data by using servlet and display it in a JSP page...

<%@ page import="java.sql.ResultSet" %> <%@ page import="java.sql.Statement" %> <%@ page import="java.sql.Connection" %> <%@ page import="java.sql.DriverManager" %> <form method="post"> <table border="2"> <tr> <td>user ID</td> <td>Birthday</td> <td>Gender</td> <td>First Name</td> <td>Last Name</td> </tr> <% try { Class.forName("com.mysql.jdbc.Driver"); String url="jdbc:mysql://localhost:3306/eyetracker"; String username="root"; String password="root"; String query="select * from eyetracker"; Connection conn=DriverManager.getConnection(url, username, password); Statement stmt=conn.createStatement(); ResultSet rs=stmt.executeQuery(query); while(rs.next()) { %> <tr><td><%rs.getInt("userID"); %></td></tr> <tr><td><%rs.getDate("dob"); %></td></tr> <tr><td><%rs.getString("gender"); %></td></tr> <tr><td><%rs.getString("firstName"); %></td></tr> <tr><td><%rs.getString("lastName"); %></td></tr> <% } %> </table> <% rs.close(); stmt.close(); conn.close(); } catch(Exception e) { e.printStackTrace(); } %> </form>`