Database Table Navigation Based On Form : Database « JSP « Java Tutorial






  1. Java Tutorial
  2. JSP
  3. Database
<%@ page import="java.sql.*" %>
<% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ; %>

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

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

        <% 
            int current = 0;
            if(request.getParameter("hidden") != null) {
                current = Integer.parseInt(request.getParameter("hidden"));
            }

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

            Statement statement = connection.createStatement();
            ResultSet resultset = 
                statement.executeQuery("select * from Publishers"); 

            for(int i = 0; i <= current; i++){
                resultset.next();
            }
        %>

        <TABLE BORDER="1">
            <TR>
               <TH>ID</TH>
               <TH>Name</TH>
               <TH>City</TH>
               <TH>State</TH>
               <TH>Country</TH>
            </TR>
            <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>
        <BR>
        <INPUT TYPE="HIDDEN" NAME="hidden" VALUE="<%= current %>">
        <INPUT TYPE="BUTTON" VALUE="Next Record" ONCLICK="moveNext()">
    </FORM>

    <SCRIPT LANGUAGE="JavaScript">
        <!--
            function moveNext()
            {
                var counter = 0
                counter = parseInt(document.form1.hidden.value) + 1
                document.form1.hidden.value = counter
                form1.submit()
            }    
        // --> 
    </SCRIPT>
</HTML>
  Download:  DatabaseTableNavigationBaseOnForm.zip( 2 k)




23.52.Database
23.52.1.Make Database connection
23.52.2.Accessing the Database Table
23.52.3.Retrieve data in Database based on form input
23.52.4.Output ResultSet
23.52.5.Joining Tables
23.52.6.Creating a Table
23.52.7.Insert data to a table
23.52.8.Navigate Database Table With Javascript and JSP
23.52.9.Database Table Navigation Based On Form
23.52.10.Connect to Database in Servlet
23.52.11.Using Table Metadata
23.52.12.Output data in database as XML