Make Database connection : Database « JSP « Java Tutorial

<%@ page import="java.sql.*" %>

<% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); %>

<HTML>
    <HEAD>
        <TITLE>The Publishers Database Table </TITLE>
    </HEAD>

    <BODY>
        <H1>The Publishers Database Table </H1>

        <% 
            Connection connection = DriverManager.getConnection(
                "jdbc:odbc:data", "userName", "password");

            Statement statement = connection.createStatement() ;
            ResultSet resultset = statement.executeQuery("select * from Publishers") ; 
        %>

        <TABLE BORDER="1">
            <TR>
                <TH>ID</TH>
                <TH>Name</TH>
                <TH>City</TH>
                <TH>State</TH>
                <TH>Country</TH>
            </TR>
            <% while(resultset.next()){ %>
            <TR>
                <TD> <%= resultset.getString(1) %></td>
                <TD> <%= resultset.getString(2) %></TD>
                <TD> <%= resultset.getString(3) %></TD>
                <TD> <%= resultset.getString(4) %></TD>
                <TD> <%= resultset.getString(5) %></TD>
            </TR>
            <% } %>
        </TABLE>
    </BODY>
</HTML>

23.52.Database
	23.52.1.	Make Database connection
	23.52.2.	Accessing the Database Table
	23.52.3.	Retrieve data in Database based on form input
	23.52.4.	Output ResultSet
	23.52.5.	Joining Tables
	23.52.6.	Creating a Table
	23.52.7.	Insert data to a table
	23.52.8.	Navigate Database Table With Javascript and JSP
	23.52.9.	Database Table Navigation Based On Form
	23.52.10.	Connect to Database in Servlet
	23.52.11.	Using Table Metadata
	23.52.12.	Output data in database as XML