Scroll To Top
Reader Level:
Article
JSP

Select a Specific Data From a Database in JSP

By Vikas Mishra on Jan 11, 2012
This is the next article in the series of database applications in JSP. In this article, I am going to describe how to select specific data from a database.

This is the next article in the series of database applications in JSP. In this article, I am going to describe how to select specific data from a database. First we construct a database and a DSN then generate a JSP application which selects specific data from a database. For constructing the database and DSN you may follow the first application of database ( working with database application in JSP). For developing this application we 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 given 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 just click on the finish button.

selectframework.jpg

Step 6 : Create jsp file.

We create one jsp file for this application.

create new jsp file.jpg

selectdata.jsp

<%@ page import="java.sql.*" %>
<% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); %>
<HTML>
       <HEAD>
       <TITLE>
Select Data From a Database</TITLE>
       </HEAD>
       <BODY BGCOLOR="cyan">
            <H1>Select Data From a Database</H1>
            <%
                Connection connection = DriverManager.getConnection(
                "jdbc:odbc:data2");
                Statement statement = connection.createStatement() ;
                ResultSet resultset =
                statement.executeQuery("select * from table1 where City = 'Meerut'") ;
            %>
                <TABLE BORDER="1">
           <TR>
                 <TH>ID</TH>
                 <TH>Name</TH>
                 <TH>City</TH>
                 <TH>State</TH>
                 <TH>Country</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>


Step 7 :
Compile and Run the application.

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

Output

selectdata.jsp

index.jsp.jpg

Resources related to this article