Product Details unable to add to shopping cart

[Loh Peggie]

Hey guys I am working on a shopping cart concept. Do you guys know why am i unable to add the quantity from the Product Description page into the shopping cart?


This is the page whereby will show the info of things that I add to the shopping cart.

<%
				//Retrieve the id of the product selected by the user
				//the product id is sent via the URL as a parameter
				//int UserId = -1;
				//String strUserId = request.getParameter("UserId");
				//if(strUserId != null) {
					//Convert from string to int
				//UserId = Integer.parseInt(strUserId);
				//}
				
				//Load the database driver
		       	Class.forName("com.mysql.jdbc.Driver");
				//Create a connection to our database
		       	Connection consc = DriverManager.getConnection("jdbc:mysql://localhost/feppz", "root", "");
				//create an SQL statement
		       	PreparedStatement sc = consc.prepareStatement("SELECT * FROM products p  INNER JOIN shoppingcartitems sci ON   p.ProductId = sci.ProductId INNER JOIN user u ON u.UserId = sci.UserId WHERE u.UserId= ?");
				//Execute and retrieve our result
				sc.setInt(1, user.getUserId());
				//ps.setInt(1, user.getUserId());
		       	ResultSet res = sc.executeQuery();

			%>
</p>
<%
        	//if there is a result, rs.next() will be true
        	//else it will be false
			if(res.next()) {
		%>
		<fieldset>
<legend>Product Information</legend>
				
<table border="0">
	<tr>
		<td>Product Name</td>
		<td>Quantity</td>
		<td>Price</td>
	</tr>
	<tr>
   		 <td><%=res.getString("ProdName") %></td>
		<td><%=res.getString("Quantity") %></td>
		<td><%=String.format("$%.2f",res.getDouble("UnitPrice"))+"\t" %></td>
	</tr>
	<tr>
		<td>
		</td>
	</tr>
	</table>
</fieldset>

<%
			}
			else {
				//if no record is found, simply display a no record message
		%>
No record found.
<%
			}
		 %>
<p> </p>

This is my form that allows me to insert the quantity to the shopping cart page.

<form method="post" action="./SaveSCI">

		<div align="left"><input type="hidden" value=" <%=userid %>" /></div>
		<div align="left"><input type="hidden" name ="ProductId" id ="ProductId" value=" <%=rs.getString("ProductId") %> " /></div>
		<div align="left"><input type="text" name ="Quantity" id ="Quantity" value=" 1 " /></div>
		<label>
      		<input type="submit" value="Add to Cart" />
   		</label>
   		</form>

This is the servlet that I make use of:

//Retreive the user data from the session object
		User user = (User)request.getSession().getAttribute("USER_DATA");
		if(user == null) {
			//if user == null, it means that the user did not login.
			//redirect him to the login page
			response.sendRedirect("Home.jsp");
			return;
		}
		
		//retrieve the feedback text from the form in the Feedback.jsp fill
			
			//Connect to database
		try {
			//Ensure the the driver class is loaded.
			Class.forName("com.mysql.jdbc.Driver");
			//Create a connection to our database.
			//localhost = server name
			//myshop = database name
			//root = user name, password = empty
			Connection con = DriverManager.getConnection("jdbc:mysql://localhost/feppz", "root", "");
			//create an SQL statement, ? marks denote values that we will add later
			PreparedStatement ps = con.prepareStatement("INSERT INTO shoppingcartitems VALUES(NULL, ?, ?, ?)");
			//replace first ? mark with values from the feedbackText text box
			ps.setInt(1, user.getUserId());
			ps.setString(2, request.getParameter("ProductId"));
			ps.setString(3, request.getParameter("Quantity"));
		
			
			 
			//execute to insert into the database
			
			ps.executeUpdate();
			//close connection
			con.close();
			//redirect user to FeedbackSucceed.jsp page
			response.sendRedirect("SC(in).jsp");
			
		} catch (Exception e) {
			e.printStackTrace();
			return;
		}
		
	}

}

Thanks:D

Appreciate your help:D

[Bear Bibeault]

Despite the fact that you are (foolishly, in my opinion) performing your database code in a JSP, it's still a database question. Please be sure to post these in the JDBC forum. I have moved this there for you.