Navigating in a Database Table : Database « JSP « Java

Navigating in a Database Table

<%@ page import="java.sql.*" %>
<% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); %>

        <TITLE>Navigating in a Database Table </TITLE>

        <H1>Navigating in a Database Table </H1>
        <FORM NAME="form1" ACTION="self.jsp" METHOD="POST">

            int current = 1;
            if(request.getParameter("hidden") != null) {
                current = Integer.parseInt(request.getParameter("hidden"));

            Connection connection = DriverManager.getConnection(
                "jdbc:odbc:data", "userName", "password");

            Statement statement = connection.createStatement(

            ResultSet resultset = 
                statement.executeQuery("select * from tableName"); 

            if(current < 1){
                current = 1;

            int rows = resultset.getRow();
            if(current <= rows){

            <TABLE BORDER="1">
                    <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>
            <INPUT TYPE="HIDDEN" NAME="hidden" VALUE="<%= current %>">
            <INPUT TYPE="BUTTON" VALUE="Next Record" ONCLICK="moveNext()">
            <INPUT TYPE="BUTTON" VALUE="Previous Record" ONCLICK="movePrevious()">

        <SCRIPT LANGUAGE="JavaScript">
            function moveNext()
                var counter = 0
                counter = parseInt(document.form1.hidden.value) + 1
                document.form1.hidden.value = counter
            function movePrevious()
                var counter = 0
                counter = parseInt(document.form1.hidden.value) - 1
                document.form1.hidden.value = counter
            // --> 


Related examples in the same category

1.JSP Database Demo
2.JSP Database Query
3.A First JSP Database
4.Joining Tables
5.Filling a Table
6.Display table in Database
7.Selecting records with condition From a Database
8.Navigating in a Database Table 2
9.Using Table Metadata
10.Creating a Table
11.Accessing the table field in Database
12.Fetching Data From a Database
13.JSTL: Transaction with a JSP
14.Using a Result object
15.Calling a Stored procedure within a JSP
16.Presenting database content using tags
17.Obtaining a Connection in JSP
18.Presenting database content
19.Using a DataSource
20.Using Transactions
21.Updating a database using the sql:update tag
22.Using a Preconfigured DataSource
23.Using the SortedMap
24.New Address Creation using executeUpdate
25.Obtaining a database Connection
26.JSP Access to Databases