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
Insert Data Into Table Through JSP
Using Image Control in JSP