Joining Tables : Database « JSP « Java

Joining Tables

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

        <TITLE>Joining Tables</TITLE>

        <H1>Joining Tables</H1>

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

            Statement statement = connection.createStatement();
            String query = "SELECT a.fname, a.lname, " +
              "FROM authors JOIN titleauthor ON =";

            ResultSet resultset = 
                statement.executeQuery(query) ; 

        <TABLE BORDER="1">
                <TH>First Name</TH>
                <TH>Last Name</TH>
                <TH>Book ID</TH>
            <% while({ %>
                <TD> <%= resultset.getString(1) %></TD>
                <TD> <%= resultset.getString(2) %></TD>
                <TD> <%= resultset.getString(3) %></TD>
            <% } %>

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.Filling a Table
6.Display table in Database
7.Selecting records with condition From a Database
8.Navigating in a Database Table 2
9.Using Table Metadata
10.Creating a Table
11.Accessing the table field in Database
12.Fetching Data From a Database
13.JSTL: Transaction with a JSP
14.Using a Result object
15.Calling a Stored procedure within a JSP
16.Presenting database content using tags
17.Obtaining a Connection in JSP
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