this is my current code:
Unfortunately it is not scrolling through all of the records in the database. It is stuck on the first record. Any clues??? Any alternative ways to do this??
____________________________________________________
<%@ page import = "java.sql.*" %>
</head>
<body bgcolor="#FFFFFF" text="#000000">
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc

dbc:login");
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
ResultSet rs = stmt.executeQuery("SELECT * FROM People");
String user_id = request.getParameter("userID");
String pass_word = request.getParameter("pwd");
while( rs.next() )
{
String email = rs.getString("Email");
if (user_id.equalsIgnoreCase(email))
{
pageContext.forward("form.jsp");
session.setAttribute("LoggedIn", "true");
}
else
{
pageContext.forward("errorpage.jsp");
}
}
con.close();
%>