Reader Level:

How to Work With Metadata in JSP

By Vikas Mishra on Jan 11, 2012
This is the next article in the series of database applications for JSP. In this article, I am going to describe the metadata in JSP.

This is the next article in the series of database applications in JSP. In this article, I am going to describe the metadata in JSP. First we construct a database and then make the DSN generate a JSP application that uses the metadata concept. To construct a database and DSN you may follow the first application of database ( working with database application in JSP).

For this application you may follow the following steps.

Step 1 :
Create a New Project

In this step we select New Project option from file menu.

create new project.jpg

Step 2 : Choose Project

In this step we select web application from Java web option and then click on the next button.

select new web application.jpg

Step 3 : Name and Location

In this step we give it a specific name and set a specific location and click on the next button.

name and location.jpg

Step 4 : Server and Setting

We select a specific server for this application and click on the next button.

server and setting.jpg

Step 5 : Select Framework

There is no need to select any framework for this application, so just click on the finish button.


Step 6 : Create jsp file

We create one jsp file for this application.

create new jsp file.jpg


<%@ page import="java.sql.*" %>
<% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); %>
Using Metadata In Table</TITLE>
         <BODY BGCOLOR="green">
             <H1>Using Metadata In Table</H1>
                 Connection connection = DriverManager.getConnection(
                 Statement statement = connection.createStatement() ;
                 ResultSet resultset =
                 statement.executeQuery("select * from table1") ;
                 <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>
           <% } %>

Step 7 :
Compile and Run the application

Now we compile the application and then run it on the server and find the following output.




Resources related to this article

Vikas Mishra
Vikas Mishra

B.Tech graduate in CSE, having 3+ years of experience in java related Technologies.   My interests are Coding, Writing complex Queries [like d most], reading [technical stuff,G.K books] and listening to music,... Read more



Spire.Doc - Free .NET Word API
Use Spire.Doc to create, read, write, print, and convert word documents to OpenXML, RTF, TXT, XPS, EPUB, EMF, HTML, Image and PDF.

Trending up