Servlet-JSP population

Hi

I have a login page which accepts inputs and take to a servlet, servlet makes a jdbc connection to oracle server to validate the login and password.
I have got all this right. once he gets logged in I redirect to a JSP page which populates a list of items available at that time in the data base. I'm getting redirected to the jsp page but my list is not being populated, my code is as shown below I have included all the jars. Do i need to close the connection? the connection is made and the validation of username and password is working fine. my table cartlist has rows in it.I checked it.

Servlet Code:
----------------------------------------------
package com.servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Date;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
* Servlet implementation class Myservlet
*/
public class My extends HttpServlet {
private static final long serialVersionUID = 1L;

/**
* @see HttpServlet#HttpServlet()
*/
public My() {
super();
// TODO Auto-generated constructor stub
}

/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
}

/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
//PrintWriter pw = response.getWriter();
//response.setContentType("text/HTML");
//Date today = new Date();
//pw.println("<b>"+today+"</b>");
String s = request.getParameter("username").toString();
String p = request.getParameter("pwpassword").toString();
Connection connection;

try {
Class.forName("oracle.jdbc.driver.OracleDriver");

String serverName = "127.0.0.1";
String portNumber = "1521";
String sid = "orcl";
String url = "jdbc:oracle:thin:@" + serverName + ":" + portNumber + ":" + sid;
String username = "scott"; String password = "tiger";
connection = DriverManager.getConnection(url, username, password);

Statement statement = connection.createStatement() ;
ResultSet rs = statement.executeQuery("select * from Login");

while (rs.next()){
String a = rs.getString(1);
String b = rs.getString(2);
if (s.equals(a)&& p.equals(b)){

RequestDispatcher rd;
rd = request.getRequestDispatcher("/cartupdate.jsp");
rd.forward(request,response);} }

}catch (Exception ex){
ex.printStackTrace();
}
}

}
JSP CODE:
----------------------------------------------------------------
<html>
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<head>
<title>cartupdate</title>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
</head>
<body>
<%@ include file="header.jsp"%>
<%@ include file="left.jsp"%>

<style>
div.form {
float: center;
width: 30%;
height:50%;
margin-right: auto;
}

</style>
<form method="post" action="updateCart">

<%
Class.forName("oracle.jdbc.driver.OracleDriver");

String serverName = "127.0.0.1";
String portNumber = "1521";
String sid = "orcl";
String url = "jdbc:oracle:thin:@" + serverName + ":" + portNumber + ":" + sid;
String username = "scott"; String password = "tiger";
Connection connection = DriverManager.getConnection(url, username, password);

Statement statement = connection.createStatement() ;
ResultSet rs = statement.executeQuery("select * from cartlist");
int i=1;%>
<TABLE cellpadding="5" border="1">
<tr>
<td>&nbsp</td>
<td>Item</td>
<td>Price</td>
<td>Units</td>
</tr><%
while (rs.next()){ %>
<tr><td><input type="checkbox" name="box<%=i%>"/></td>
<td><input type="text" name="itemname<%=i%>" value="<%=rs.getString(1)%>"/></td>
<td><input type="text" name="itemname<%=i%>" value="<%=rs.getString(2)%>"/></td>
<td><input type="text" name="number<%=i%>"/></td>
</tr>
<%}%>

</table>
<p><input type="submit" name="direction" value="Add2Cart">
<input type="submit" name="direction" value="checkout1"><b>Click checkout once you Add2Cart</b> </p>
<p><br></p>
<p></p>
</form>

</body>

</html>

View Answers