Using Table Metadata : Database « JSP « Java Tutorial

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

        <TITLE>Using Table Metadata</TITLE>

        <H1>Using Table Metadata</H1>

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

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

        <TABLE BORDER="1">
                <TH><%= resultset.getMetaData().getColumnName(1)%></TH>
                <TH><%= resultset.getMetaData().getColumnName(2)%></TH>
                <TH><%= resultset.getMetaData().getColumnName(3)%></TH>
                <TH><%= resultset.getMetaData().getColumnName(4)%></TH>
                <TH><%= resultset.getMetaData().getColumnName(5)%></TH>
            <% while({ %>
                <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>
            <% } %>

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