السلام عليكم ..
كيف اقدر احسب الtotal price للproducts الموجوده في الcart ؟؟
هذا الكود ل cart :
<%--
Document : myCart
Created on : May 10, 2011, 4:34:44 PM
Author : 200610***
--%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<%@page import="java.lang.String"%>
<%@ page import="java.sql.*" %>
<%! Date today;%>
<%@ page session="true"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
<h1>your Cart</h1>
<%@ page import="java.sql.*" %>
<%! int sum = 0; %>
<%
try {
Connection con = null;
String databaseURL = "jdbc:mysql://localhost:3306/fashion";
String driverName = "com.mysql.jdbc.Driver";
String user = "root";
String password = "root";
String Cust_ID = (String) session.getAttribute("Cust_ID");
Class.forName(driverName).newInstance();
con = DriverManager.getConnection(databaseURL, user, password);
if (!con.isClosed()) {
System.out.println("Successfully connected to the DataBase Server...");
}
Statement statement;
statement = con.createStatement();
String selectQuery = "SELECT * FROM Cart where Cust_ID= '" + Cust_ID + "'";
ResultSet resultSet = null;
resultSet = statement.executeQuery(selectQuery);
if (resultSet != null) // Succes
{
while (resultSet.next()) {
Integer Pro_ID = (Integer) resultSet.getObject("Pro_ID");
Integer price = (Integer) resultSet.getObject("Pro_Price");
Integer Quantity = (Integer) resultSet.getObject("Cart_Quantity");
Integer size = (Integer) resultSet.getObject("size");
java.util.Date date = new java.util.Date();
long t = date.getTime();
java.sql.Date sqlDate = new java.sql.Date(t);
java.util.Date dt = new java.util.Date();
java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat("yyyy-MM-dd");
String currentTime = sdf.format(dt);
%>
<form name = "form " action="addtoOrder" method = "POST" >
<input type="hidden" value="<%=Cust_ID%>" name="Cust_ID">
<input type="hidden" value="<%=Pro_ID%>" name="productID">
<input type="hidden" value="<%=price%>" name="price">
<input type="hidden" value="<%=Quantity%>" name="Quantity">
<input type="hidden" value="<%=size%>" name="size">
<input type="hidden" value="<%=currentTime%>" name="date">
<%
out.println("product No:" + Pro_ID);
out.println("size:" + size);
out.println("Quantity" + Quantity);
out.println("price" + price + "<br/>");%>
<form name = "form1" action="delete" method = "POST" >
<input type="hidden" value="<%=Cust_ID%>" name="Cust_ID">
<input type="hidden" value="<%=Pro_ID%>" name="productID">
<input type="hidden" value="<%=size%>" name="size">
<input type="submit" value="delete" name="submit" />
</form>
<% }%>
<input type="submit" value="Checkout" name="submit" />
</form>
<%
resultSet.close();
}
statement.close();
if (con != null) {
con.close();
}
} catch (Exception e) {
System.err.println("Exception: " + e.getMessage());
}
%>
<a href="index.jsp">Home</a> <br><br>
</body>
</html>ابا احسب الtotal price للكل الproducts الموجوده في االcart
