java code for Presenting database content

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

Address List

<%
Connection conn = null;
ResultSet result = null;
Statement stmt = null;
ResultSetMetaData rsmd = null;

try {
Class c = Class.forName("com.mysql.jdbc.Driver");
}
catch (Exception e) {
System.out.println("Error occurred " + e);
}
try {
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/ADDRESS");
}
catch (SQLException e) {
System.out.println("Error occurred " + e);
}
try {
stmt = conn.createStatement();
result = stmt.executeQuery("SELECT * FROM AddressList");
}
catch (SQLException e) {
System.out.println("Error occurred " + e);
}

int columns=0;
try {
rsmd = result.getMetaData();
columns = rsmd.getColumnCount();
}
catch (SQLException e) {
System.out.println("Error occurred " + e);
}
%>


<% // write out the header cells containing the column labels
try {
for (int i=1; i<=columns; i++) {
out.write("");
}
%>



<% // now write out one row for each entry in the database table
while (result.next()) {
out.write("");
for (int i=1; i<=columns; i++) {
out.write("");
}
out.write("");
}

// close the connection and the statement
stmt.close();
conn.close();
} // end of the try block
catch (SQLException e) {
System.out.println("Error " + e);
}
// ensure everything is closed
finally {
try {
if (stmt != null)
stmt.close();
} catch (SQLException e) {}
try {
if (conn != null)
conn.close();
} catch (SQLException e) {}
}

%>

" + rsmd.getColumnLabel(i) + "
" + result.getString(i) + "