Mega Code Archive
Categories
/
Java
/
JSP
Navigating in a Database Table
<%@ page import="java.sql.*" %> <% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); %>
Navigating in a Database Table
Navigating in a Database Table
<% 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.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY); ResultSet resultset = statement.executeQuery("select * from tableName"); if(current < 1){ current = 1; } resultset.last(); int rows = resultset.getRow(); if(current <= rows){ resultset.absolute(current); } %>
ID
Name
City
State
Country
<%= resultset.getString(1) %>
<%= resultset.getString(2) %>
<%= resultset.getString(3) %>
<%= resultset.getString(4) %>
<%= resultset.getString(5) %>
">