Using a DataSource : Database « JSP « Java

Using a DataSource

<%@page import="java.sql.*, javax.sql.*, javax.naming.*"%>
<title>Using a DataSource</title>
<h1>Using a DataSource</h1>
    DataSource ds = null;
    Connection conn = null;
    ResultSet result = null;
    Statement stmt = null;
    ResultSetMetaData rsmd = null;
      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">
   <% // write out the header cells containing the column labels
      try {
         for (int i=1; i<=columns; i++) {
              out.write("<th>" + rsmd.getColumnLabel(i) + "</th>");
   <% // now write out one row for each entry in the database table
         while ( {
            for (int i=1; i<=columns; i++) {
              out.write("<td>" + result.getString(i) + "</td>");
         // close the connection, resultset, and the statement
      } // end of the try block
      catch (SQLException e) {
         System.out.println("Error " + e);
      // ensure everything is closed
    finally {
     try {
       if (stmt != null)
       }  catch (SQLException e) {}
       try {
        if (conn != null)
        } catch (SQLException e) {}


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