This is the next article in the series of
articles about database applications in JSP. In this article, I am going to develop a database
application with JSP. In this application, I am showing how to
fetch data from a table. To do that, first we design a database of student data and
then fetch it from JSP code on server.
Step 1: Create a new database
In the first step we click on the blank database option and click on the create.
![make a new database.jpg]()
Step 2: Design the database
In this step we select field name and data type for the those fields. In this
application we select five fields (id, name, city, state, country, email and interest).
![design view.jpg]()
Step 3: Make DSN
In this step we make DSN by follow the following process.
First we select the control panel option from start.
![select the control panel.jpg]()
Then click on the administrative tools.
![click on administration tools.jpg]()
Select Data Sources option.
![select data source option.jpg]()
Then select Microsoft Access Driver (*.mdb,*.accdb), and click on the finish
button.
![create new data source.jpg]()
Then select database from the computer and give it a specific name. Now the DSN
is created.
![select data base.jpg]()
Step 4: Create a New Project
In this step we select New Project option from file menu.
![create new project.jpg]()
Step 5: 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 6: 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 7: Server and Setting
We select a specific server for this application and click on the next button.
![server and setting.jpg]()
Step 8:Select Framework
There is no need to select any framework for this application; just click on the
finish button.
![selectframework.jpg]()
Step 9: Create jsp file
We create one jsp file for this application.
![create new jsp file.jpg]()
Index.jsp
<%@ page import="java.sql.*" %>
<% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); %>
<HTML>
<HEAD>
<TITLE>The View Of Database Table
</TITLE>
</HEAD>
<BODY BGCOLOR="cyan">
<H1>The View Of Database Table </H1>
<%
Connection
connection = DriverManager.getConnection(
"jdbc:odbc:data");
Statement statement
= connection.createStatement() ;
ResultSet resultset =
statement.executeQuery("select * from table1") ;
%>
<TABLE BORDER="1">
<TR>
<TH>ID</TH>
<TH>Name</TH>
<TH>City</TH>
<TH>State</TH>
<TH>Country</TH>
<TH>Email</TH>
<TH>Interest in Game</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>
<TD> <%= resultset.getString(6) %></TD>
<TD> <%= resultset.getString(7) %></TD>
</TR>
<% } %>
</TABLE>
</BODY>
</HTML>
Step 10: Compile and Run the application
Now we compile the application and then run it on the server and
find the following output.
Output
Index.jsp
![output.jpg]()
Resources related to this article