Using Table Metadata

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

<HTML>
    <HEAD>
        <TITLE>Using Table Metadata</TITLE>
    </HEAD>

    <BODY>
        <H1>Using Table Metadata</H1>

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

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

        <TABLE BORDER="1">
            <TR>
                <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>
            </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>

1.	JSP Database Demo
2.	JSP Database Query
3.	A First JSP Database
4.	Navigating in a Database Table
5.	Joining Tables
6.	Filling a Table
7.	Display table in Database
8.	Selecting records with condition From a Database
9.	Navigating in a Database Table 2
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

Using Table Metadata : Database « JSP « Java

Related examples in the same category