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>

1.	JSP Database Demo
2.	JSP Database Query
3.	A First JSP Database
4.	Navigating in a Database Table
5.	Joining Tables
6.	Filling a Table
7.	Display table in Database
8.	Selecting records with condition From a Database
9.	Navigating in a Database Table 2
10.	Using Table Metadata
11.	Creating a Table
12.	Accessing the table field in Database
13.	Fetching Data From a Database
14.	JSTL: Transaction with a JSP
15.	Using a Result object
16.	Calling a Stored procedure within a JSP
17.	Presenting database content using tags
18.	Obtaining a Connection in JSP
19.	Using a DataSource
20.	Using Transactions
21.	Updating a database using the sql:update tag
22.	Using a Preconfigured DataSource
23.	Using the SortedMap
24.	New Address Creation using executeUpdate
25.	Obtaining a database Connection
26.	JSP Access to Databases

Presenting database content : Database « JSP « Java

Related examples in the same category