Joining Tables : Database « JSP « Java
Joining Tables
<%@ page import="java.sql.*" %>
<% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); %>
<HTML>
<HEAD>
<TITLE>Joining Tables</TITLE>
</HEAD>
<BODY>
<H1>Joining Tables</H1>
<%
Connection connection = DriverManager.getConnection(
"jdbc:odbc:data", "Steve", "password");
Statement statement = connection.createStatement();
String query = "SELECT a.fname, a.lname, titleauthor.id " +
"FROM authors JOIN titleauthor ON authors.id = titleauthor.id";
ResultSet resultset =
statement.executeQuery(query) ;
%>
<TABLE BORDER="1">
<TR>
<TH>First Name</TH>
<TH>Last Name</TH>
<TH>Book ID</TH>
</TR>
<% while(resultset.next()){ %>
<TR>
<TD> <%= resultset.getString(1) %></TD>
<TD> <%= resultset.getString(2) %></TD>
<TD> <%= resultset.getString(3) %></TD>
</TR>
<% } %>
</TABLE>
</BODY>
</HTML>
