Retrieve data from the database using JSP

<%@ page import="java.sql.*" %> 

<table border="1">

<tr><th>Name</th><th>Address</th></tr>

<%

try {

Class.forName("com.mysql.jdbc.Driver").newInstance();



Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root");

Statement st= conn.createStatement();

ResultSet rs = st.executeQuery("select * from data");



while(rs.next())

{

%>

<tr><td><%=rs.getString("name")%></td><td><%=rs.getString("address")%></td></tr>

<%

}

}

catch (Exception e) {

e.printStackTrace();

}

%> 

</table>