<%@ 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", "userName", "password");
Statement statement = connection.createStatement();
ResultSet resultset =
statement.executeQuery("select * from tableName");
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) %>
">