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.Step 2 : Choose Project.In this step we select web application from java web option and then click on the next button.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.
Step 4 : Server and Setting.We select a specific server for this application and click on the next button.
Step 5 : Select Framework.There is no need to select any framework; for this application just click on the finish button.Step 6 : Create jsp file.We create one jsp file for this application.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.Outputselectdata.jspResources related to this article
Select a Specific Data From a Database in JSP
Insert Data Into Table Through JSP