You need to be a premium member to use this feature. To access it, you'll have to upgrade your membership.
Become a sharper developer and jumpstart your career.
$0
$
. 00
monthly
For Basic members:
$10
For Premium members:
In this article, I am describing how to fetch data from a table in JSP.
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. 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).
Step 3: Make DSN In this step we make DSN by follow the following process. First we select the control panel option from start. Then click on the administrative tools.
Select Data Sources option. Then select Microsoft Access Driver (*.mdb,*.accdb), and click on the finish button. Then select database from the computer and give it a specific name. Now the DSN is created. Step 4: Create a New Project In this step we select New Project option from file menu. Step 5: Choose Project In this step we select web application from Java web option and then click on the next button. 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.
Step 7: Server and Setting We select a specific server for this application and click on the next button.
Step 8:Select Framework There is no need to select any framework for this application; just click on the finish button. Step 9: Create jsp file We create one jsp file for this application. 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.jspResources related to this article
Pro WPF: Windows Presentation Foundation in .NET 3.0