Using a DataSource : Database « JSP « Java





Using a DataSource


<%@page import="java.sql.*, javax.sql.*, javax.naming.*"%>
<html>
<head>
<title>Using a DataSource</title>
</head>
<body>
<h1>Using a DataSource</h1>
<%
    DataSource ds = null;
    Connection conn = null;
    ResultSet result = null;
    Statement stmt = null;
    ResultSetMetaData rsmd = null;
    try{
      Context context = new InitialContext();
      Context envCtx = (Context) context.lookup("java:comp/env");
      ds =  (DataSource)envCtx.lookup("jdbc/address");
      if (ds != null) {
        conn = ds.getConnection();
        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, resultset, and the statement
         result.close();
         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>


           
       










Related examples in the same category

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.Presenting database content
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