Accessing the Database Table : Database « JSP « Java Tutorial

<%@ page import="java.sql.*" %>
<% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ; %>

<HTML>
    <HEAD>
        <TITLE>Accessing the Publishers Database Table</TITLE>
    </HEAD>

    <BODY>
        <H1>Accessing the Publishers Database Table</H1>

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

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

        <TABLE BORDER="1">
            <TR>
                <TH>Name</TH>
            </TR>
            <% while(resultset.next()){ %>
                <TR>
                    <TD> 
                        <%= resultset.getString(1)%>  
                    </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