Obtaining a Connection in JSP : Database « JSP « Java

Obtaining a Connection in JSP

<%@page import="java.sql.*"%>
<title>Obtaining a Connection</title>
<h1>This Page Obtains a Connection to a Database and executes a query</h1>
The query is based upon a PreparedStatement
    Connection conn = null;
    ResultSet result = null;
    PreparedStatement 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.prepareStatement("SELECT * FROM AddressList WHERE name= ?");
        stmt.setString(1, "Alex");
        result = stmt.executeQuery();
     catch (SQLException e) {
         System.out.println("Error occurred " + e);
      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.Presenting database content
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