Breaking News: Grepper is joining You.com. Read the official announcement!

make a table of data from db in jsp

Prashin More answered on February 20, 2022 Popularity 3/10 Helpfulness 3/10

answer make a table of data from db in jsp

make a table of data from db in jsp

Comment

<%@ 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>

Popularity 3/10 Helpfulness 3/10 Language javascript

Source: Grepper

Tags: javascript jsp

Link to this answer
Share Copy Link

Contributed on Feb 20 2022

Prashin More

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

make a table of data from db in jsp

Contents

More Related Answers

make a table of data from db in jsp

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.