Source Code : Presenting database content

Java Is Open Source Programming Language You Can Download From Java and Java Libraries From http://www.oracle.com. Click Here to download
We provide this code related to title for you to solve your developing problem easily. Libraries which is import in this program you can download from http://www.oracle.com. Click Here or search from google with Libraries Name you get jar file related it

Presenting database content


<%@page import="java.sql.*"%>
<html>
<head>
<title>Presenting database content</title>
</head>
<body>
<h1>Address List</h1>
<%
    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);
     }
%>
<table width="90%" border="1">
  <tr>
  <% // write out the header cells containing the column labels
     try {
        for (int i=1; i<=columns; i++) {
             out.write("<th>" + rsmd.getColumnLabel(i) + "</th>");
        }
  %>
  </tr>


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

        // 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) {}
   }

   %>
</table>
</body>
</html>

Thank with us