Mega Code Archive
Categories
/
Java Tutorial
/
JSP
Database Table Navigation Based On Form
<%@ page import="java.sql.*" %> <% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ; %>
Navigating in a Database Table
Navigating in a Database Table
<% 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(); } %>
ID
Name
City
State
Country
<%= resultset.getString(1) %>
<%= resultset.getString(2) %>
<%= resultset.getString(3) %>
<%= resultset.getString(4) %>
<%= resultset.getString(5) %>
">