Java Script

hi,
im having a problem in updating the cart. below is the code for that.
what i want is i need to enter the how much quantity by entering in the textbox and when i click on the update cart i need to display the total amout (i.e multiply the quantity with the amount) at the palce of lable.
plz help me..

thanx in advance.

<%@ page language="java" import="java.sql.*,java.io.*"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE> Gallery Page </TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">

<script language="javascript">
window.onload=function ()
{
var now=new Date();

document.forms[document.forms.length-1].rcf_date.value = now;//.toGMTString();
}
function call_1(id)
{

window.location.replace("./DcartServlet?id="+id);

}

function Value(amount) {
var d = document;
var val = d.getElementById('text1');//quantity

//alert(n);
var lab = d.getElementById('amt');
//var b=Integer.parseInt(amount);
var a=amount*val.value;
//alert(a);
lab.innerHTML = a;
}
</script>

</HEAD>

<form name="f1">
<BODY>
<table border=0>
<tr><td><img src="./images/Untitled-30.jpg" width="680" height="170"></td>
<td><table border=0>
<tr><td align="right"><a href="user_login.html" style="text-decoration: none; border-bottom: 1px solid #FFFFFF">Login</a></td></tr>
<tr><td><img src="./images/cooltext75055321.gif" width="300" height="65"></td></tr>
<tr><td><img src="./images/images6.jpg" width="300" height="75"></td></tr></table>
</table>
<img src="./images/5.jpg" width="990" height="5"><br>
<table align="center" border=0>
<tr><td><a href="home.html" style="color: #FFFFFF"><img src="./images/home.png" height=40></a></td>
<td><a href="admin_login.html" style="color: #FFFFFF"><img src="./images/admin.png" height=40></td>
<td><a href="gallery.jsp" style="color: #FFFFFF"><img src="./images/gallery.png" height=40></td>
<td><a href="sitemap.html" style="color: #FFFFFF"><img src="./images/sitemap.png" height=40></td>
<td><a href="aboutus.html" style="color: #FFFFFF"><img src="./images/about us.png" height=40></td>
<td><a href="contactus.html" style="color: #FFFFFF"><img src="./images/contact us.png" height=40></td></tr>
</table >
<img src="./images/5.jpg" width="990" height="5"><br>
<table border=1>
<tr><td align="left">Wel-Come <B><I><font color="Orange">Guest                                                                                                                                                                </font></b></i></td>
<td>
<input type=text size="33" name="rcf_date">
<label name="new_date"></label>
</td><tr>
</table>
<table border=1>
<tr>
<td><table><tr> <td span=2 align="center"><b><font color="orange">Papular Category</font></b></td></tr><tr><td><img src="./images/flralfancy.jpg" width=75 height=50><img src="./images/Womens1.jpg" width=75 height=50></td><td> </td></tr>
<tr><td><img src="./images/trousers.jpg" width=75 height=50><img src="./images/SWeekend-Assortment.jpg" width=75 height=50></td><td></td></tr>
<tr><td span=2 align="right">More....</td></tr></table>
<table><tr> <td span=2 align="center"><b><font color="orange">Papular Brands</font></b></td></tr><tr><td><img src="./images/Nike_Shoes_Nz.jpg" width=75 height=50><img src="./images/nokia_n98.jpg" width=75 height=50></td><td> </td></tr>
<tr><td><img src="./images/Raymond.gif" width=75 height=50><img src="./images/Mayur.gif" width=75 height=50></td><td></td></tr>
<tr><td span=2 align="right">More....</td></tr></table>
<table><tr><td><img src="./images/verticalimg.gif"></td></tr></table>
</td>
<td>

<table border=1 width=658>
<tbody>
<td bgColor="#008080" width="47" align="center" height="19"><font color="#ffffff"><b>Sr No</b></font></td>
<td align="center" bgColor="#008080" width="107" height="19"><font color="#ffffff"><b>Product</b></font></td>
<td align="center" bgColor="#008080" width="224" height="19"><font color="#ffffff"><b>Price</b></font></td>
<td align="center" bgColor="#008080" width="270" height="19"><font color="#ffffff"><b>Quantity</b></font></td>
<td align="center" bgColor="#008080" width="270" height="19"><font color="#ffffff"><b>Amount</b></font></td>

<td align="center" bgColor="#008080" width="270" height="19"><font color="#ffffff"><b>Delete</b></font></td>

<%
Class.forName("com.mysql.jdbc.Driver").newInstance();

int i=1;
Connection con=null;
ResultSet rst=null;
Statement stmt=null;
PrintWriter pw=response.getWriter();
String id=request.getParameter("id");
try
{
con=DriverManager.getConnection("jdbc:mysql://localhost:3306/shopping","root","password");
stmt=con.createStatement();
rst=stmt.executeQuery("select * from product where id='"+id+"'");
while(rst.next())
{
String m1=rst.getString(1);
String m2=rst.getString(2);
String m3=rst.getString(3);
String m4=rst.getString(4);
String m5=rst.getString(5);
String m6=rst.getString(6);
String m7=rst.getString(7);
String m8=rst.getString(8);
String m9=rst.getString(9);
int a=stmt.executeUpdate("insert into cart values('"+m1+"','"+m2+"','"+m3+"','"+m4+"','"+m5+"','"+m6+"','"+m7+"','"+m8+"','"+m9+"')");
}
rst=stmt.executeQuery("select * from cart");
while(rst.next())
{

if (i==(i/2)*2){
%>
<tr>
<td align="center" bgColor="#ffff98"><%=i%></td>
<td align="center" bgColor="#ffff98"><img src="./images/<%=rst.getString(9)%>" width="100" height="100"></td>
<td align="center" bgColor="#ffff98">$<%=rst.getString(7)%></td>
<td align="center" bgColor="#ffff98"><input id="text1" type="text" name="quan" value="1"> </td>
<td align="center" bgColor="#ffff98">$<label id="amt"><%=rst.getString(7)%></label> </td>

<td align="center" bgColor="#ffff98"><img src="./images/PNG-Symbol-Delete.png" width="25" height="25" onclick='call_1(<%=rst.getString(1)%>);'></td>   

</tr>
<%
}
else{
%>
<tr>
<td align="center" bgColor="#ffcc68"><%=i%></td>
<td align="center" bgColor="#ffcc68"><img src="./images/<%=rst.getString(9)%>" width="100" height="100"></td>
<td align="center" bgColor="#ffcc68">$<%=rst.getString(7)%></td>
<td align="center" bgColor="#ffcc68"><input id="text1" type="text" name="quan" value="1"> </td>
<td align="center" bgColor="#ffcc68">$<label id="amt"><%=rst.getString(7)%></label> </td>

<td align="center" bgColor="#ffcc68"><img src="./images/PNG-Symbol-Delete.png" width="25" height="25" onclick='call_1(<%=rst.getString(1)%>);'></td>   </tr>

<% }
i++;
}
rst.close();
stmt.close();
con.close();
}
catch(Exception e)
{
System.out.println(e.getMessage());
}
%>

</table>
<table align="center">
<tr>
<td align="center"colspan=2><input type="button" value="      Update Cart      "></td>
<td align="center"colspan=2><input type="button" value="      Check Out       "></td>
<td align="center"colspan=2><a href="./home.html" style="color:#ffffff"><input type="button" value="      Continue shopping       "></a></td>
</tr>
</table>
</td>
<td align="right"><img src="./images/verticalad.gif">
</td>
</tr>
</tbody>
</table>
</BODY>
</form>
</HTML>

View Answers

June 16, 2010 at 12:13 PM

Hi Friend,

1)Do modifications in your function Value(). Here it is:

function Value() {
var d = document;
var amount=document.getElementById('am');
var val = d.getElementById('text1');
var lab = d.getElementById('amt');
var a=Number(amount.value)*Number(val.value);
lab.innerHTML = a;
val.innerHTML=a;
}

2)Changed your table cell that consist of <label id="amt">.

<td align="center" bgColor="#ffcc68">$<input type="hidden" id="am" value="<%=rst.getString(7)%>"><label id="amt"><%=rst.getString(7)%></label> </td>

3)Call function Value() from the "Update Cart" button.

Thanks