java商城毕业设计 JavaWeb家具家居购物商城毕业设计（9）购物车

最新推荐文章于 2023-01-13 16:11:32 发布
黄菊华老师
最新推荐文章于 2023-01-13 16:11:32 发布
阅读量589
点赞数 1
文章标签： java商城毕业设计 JavaWeb家具商城毕业设计
本文链接：https://blog.csdn.net/u013818205/article/details/109155187
版权
效果图

在这里插入图片描述
代码

<%@ page contentType="text/html; charset=utf-8" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="java.net.*" %>

<%@ page import="com.mysql.jdbc.Driver" %>   
<%@ page import="java.sql.*"%>
<%@ page import="java.io.*,java.util.*" %>

<%@ include file="conn.jsp"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
<link rel="stylesheet" href="css/gouwuche.css">
<script language="javascript">
function del(url) 
{ 
	if (confirm("确定要删除该信息？删除后不可恢复!")) 
	{ 
		window.location.href=url;
	} 
} 
</script>
</head>
<body>

<% 
//读取cookie u_id  u_fzid  u_name
String u_id = "";
String u_fzid = "";
String u_name = "";
Cookie cookie = null;
Cookie[] cookies = null;
// 获取 cookies 的数据,是一个数组
cookies = request.getCookies();
if(cookies !=null){
     for (int i = 0; i < cookies.length; i++){
        cookie = cookies[i];                       
        //out.print("参数名 : " + cookie.getName());
        //out.print(" | 参数值: " + URLDecoder.decode(cookie.getValue(), "utf-8") +" <br>");
        if(cookie.getName().equals("hy_id")){ //  == 判断可能无效
       	 u_id = URLDecoder.decode(cookie.getValue(), "utf-8");
        }
        if(cookie.getName().equals("hy_fzid")){ //  == 判断可能无效
       	 u_fzid = URLDecoder.decode(cookie.getValue(), "utf-8");
        }
        if(cookie.getName().equals("hy_name")){ //  == 判断可能无效
       	 u_name = URLDecoder.decode(cookie.getValue(), "utf-8");
        }                         
        
     } 
//out.print("用户id："+u_id+ " | 用户分组id：" + u_fzid + " | 用户名："+u_name);
}
%>




<form name="form1" method="post" action="gwc_xiadan.jsp" onSubmit="return jiesuan();" >

<!--购物车-顶部导航-->
<div class="dingbu">
	<a href="index.jsp" class="dingbu_lianjie">
		<img src="img/back.png"  alt="" class="dingbu_lianjie_img" />
	</a>
	<p class="dingbu_biaoti">购物车</p>
</div>


<iframe name="frm01" width="0" height="0" frameborder="0" src=""></iframe>
<script>
var feiyong=0;
//勾选单个购物车产品，计价处理
function jijia1(cs1,cs2) //参数：购物车的id，价格
{
	//alert(cs1+"  -  " +cs2);
	//document.getElementById("feiyong").innerHTML = cs2;
	feiyong=document.getElementById("feiyong").innerHTML;
	//alert(document.getElementById("xuhao"+cs1).checked)
	if(document.getElementById("xuhao"+cs1).checked==true)
	{
		feiyong = Number(feiyong) + Number(cs2)*Number(document.getElementById("shu"+cs1).value);
	}else
	{
		feiyong = Number(feiyong) - Number(cs2)*Number(document.getElementById("shu"+cs1).value);
	}
	document.getElementById("feiyong").innerHTML = feiyong;
}
//增加数量
function jia(cs1,cs2,cs3)//参数：购物车的id，数量，价格
{
	//alert(cs1+" - " +cs2+" - " +cs3 );
	//更改数量显示
	document.getElementById("shu"+cs1).value = Number(document.getElementById("shu"+cs1).value) + Number(1);
	//alert(document.getElementById("shu"+cs1).value);
	//更改数据库中的数量
	//alert("gwc_update_shuliang.jsp?cs_gwc_id="+cs1+"&cs_cp_shuliang=" +document.getElementById("shu"+cs1).value);
	frm01.location = "gwc_update_shuliang.jsp?cs_gwc_id="+cs1+"&cs_cp_shuliang=" +document.getElementById("shu"+cs1).value;
	feiyong=document.getElementById("feiyong").innerHTML;
	if(document.getElementById("xuhao"+cs1).checked==true)
	{
		feiyong = Number(feiyong)+Number(cs3);
		document.getElementById("feiyong").innerHTML = feiyong;
	}
	
}
//减少数量
function jian(cs1,cs2,cs3)//参数：购物车的id，数量，价格
{
 	//alert(cs1+" - " +cs2+" - " +cs3 );
	shu = document.getElementById("shu"+cs1).value;
	if(shu==1)
	{
		alert("数量不能少于1");
	}
	else
	{
		document.getElementById("shu"+cs1).value = Number(document.getElementById("shu"+cs1).value)-Number(1)
		//更改数据库中的数量
		frm01.location = "gwc_update_shuliang.jsp?cs_gwc_id="+cs1+"&cs_cp_shuliang=" +document.getElementById("shu"+cs1).value
	
		feiyong=document.getElementById("feiyong").innerHTML;
		if(document.getElementById("xuhao"+cs1).checked==true)
		{
			feiyong = Number(feiyong)-Number(cs3);
			feiyong=document.getElementById("feiyong").innerHTML = feiyong;
		}
	}
}
//全选
function  qx()
{
	if(document.getElementById("quanxian").checked==true)
	{
		var objNameList=document.getElementsByName('xuhao');
		for(var i=0;i<objNameList.length;i++){  
			if(objNameList[i].checked==true)
			{}else{
				objNameList[i].checked=true;
				var blm="jijia1(" + objNameList[i].value +  ")"
				eval(blm); //jijia1(cs1,cs2) //参数：购物车的id，价格
			}
		}
	}else{
		var objNameList=document.getElementsByName('xuhao');
		for(var i=0;i<objNameList.length;i++){  
			if(objNameList[i].checked==true)
			{
				objNameList[i].checked=false;
				var blm="jijia1(" + objNameList[i].value +  ")"
				eval(blm); //jijia1(cs1,cs2) //参数：购物车的id，价格
			}else{
			}
		}
	}
}
//去结算
function jiesuan()
{
	var gouwushu = 0
	var objNameList=document.getElementsByName('xuhao');
	for(var i=0;i<objNameList.length;i++)
	{  
		if(objNameList[i].checked==true)
		{
			gouwushu = gouwushu + 1;
		}else{}
	}	
	if(gouwushu<=0)
	{
		alert("请选择产品！");
		return false;
	}
}
</script>





<% 
//读取用户购物车
Statement stmt = null;  
ResultSet rs = null;  
String sql ="select  * from gouwuche where u_id="+Integer.parseInt(u_id)+" and zt=1 order by id desc";  //查询语句
stmt = conn.createStatement();  
rs = stmt.executeQuery(sql);  

int gwc_cpid = 0;
int gwc_id = 0;
String gwc_cp_mingcheng = "";
//double gwc_jiage_shichang = 0;
//double gwc_jiage_chengjiao = 0;
int gwc_jiage_shichang = 0;
int gwc_jiage_chengjiao = 0;
int gwc_cp_shuliang = 0;
int gwc_zt = 1;
String gwc_shijian_gouwuche = "";

while (rs.next()) {  
	gwc_id = rs.getInt("id");
	gwc_cpid = rs.getInt("cp_id");
	gwc_cp_mingcheng = rs.getString("cp_mingcheng");
	//gwc_jiage_shichang = rs.getDouble("jiage_shichang");
	//gwc_jiage_chengjiao = rs.getDouble("jiage_chengjiao");
	gwc_jiage_shichang = rs.getInt("jiage_shichang");
	gwc_jiage_chengjiao = rs.getInt("jiage_chengjiao");	
	gwc_cp_shuliang = rs.getInt("cp_shuliang");
	gwc_zt =rs.getInt("zt");		
	gwc_shijian_gouwuche = rs.getString("shijian_gouwuche");
	
	//读取产品信息
	String mingcheng = "";

	int lx_id1 = 0;
	int lx_id2 = 0;
	int kucun = 0;
	int yixiaoshou = 0;
	int jiage1 = 0;
	int jiage2 = 0;
	int jiage3 = 0;

	String cp_tupian = "";
	int cp_tupian_yn = 0;
	String cp_tupian1 = "";
	String cp_tupian2 = "";
	String cp_tupian3 = "";
	String cp_tupian4 = "";

	int zhuangtai_yn = 0;
	int tuijian_yn = 0;
	int jianjie_yn = 0;

	String jianjie = "";
	String neirong = "";
	String fabu_riqi = "";
	String add_riqi = "";

	//读取要修改的信息
	Statement stmt_0 = null;  
	ResultSet rs_0 = null;  
	String sql_0 ="select * from shangpin where id="+gwc_cpid;  //查询语句
	stmt_0 = conn.createStatement();  
	rs_0 = stmt_0.executeQuery(sql_0);  
	while (rs_0.next()) {  
	    mingcheng = rs_0.getString("mingcheng");
	    
	    lx_id1 = rs_0.getInt("lx_id1");
	    lx_id2 = rs_0.getInt("lx_id2");
	    kucun = rs_0.getInt("kucun");
	    yixiaoshou = rs_0.getInt("yixiaoshou");
	    jiage1 = rs_0.getInt("jiage1");
	    jiage2 = rs_0.getInt("jiage2");
	    jiage3 = rs_0.getInt("jiage3");     
	    
	    cp_tupian = rs_0.getString("cp_tupian");
	    cp_tupian_yn = rs_0.getInt("cp_tupian_yn");   
	    cp_tupian1 = rs_0.getString("cp_tupian1");
	    cp_tupian2 = rs_0.getString("cp_tupian2");
	    cp_tupian3 = rs_0.getString("cp_tupian3");
	    cp_tupian4 = rs_0.getString("cp_tupian4");
	    
	    zhuangtai_yn = rs_0.getInt("zhuangtai_yn");
	    tuijian_yn = rs_0.getInt("tuijian_yn");
	    jianjie_yn = rs_0.getInt("jianjie_yn");
	    
	    jianjie = rs_0.getString("jianjie");
	    neirong = rs_0.getString("neirong");
	    fabu_riqi = rs_0.getString("fabu_riqi");
	    
	    //neirong = htmlspecialchars(neirong)
	}  	
%>
<!--购物车-产品列表-->
<div class="gwc_cp">
	
	<!--购物车-产品列表-单号栏-->
	<div class="dingdan_hao">
		<div class="dingdan_hao_zuo">时间：<%=gwc_shijian_gouwuche%></div>
		<a  class="dingdan_hao_you" style="cursor:hand;" onClick=del("gwc_del.jsp?cs_gwcid=<%=gwc_id%>") >
			<img src="img/del.png" alt="" class="dingdan_hao_you_img" />
		</a>
	</div>
	
	<!--购物车-产品区块制作-->
	<div class="gwc_cp_xiangmu">
		<!--购物车-产品区块制作-左侧-选择项-->
		<div class="gwc_cp_xiangmu_xuanzhhe">
			<input type="checkbox" class="gwc_cp_xiangmu_xuanzhhe_chk"  
           		 onChange="jijia1(<%=gwc_id%>,<%=gwc_jiage_chengjiao%>)" 
                 id="xuhao<%=gwc_id%>" name="xuhao" value="<%=gwc_id%>,<%=gwc_jiage_chengjiao%>"
           	 />            
		</div>
		<!--购物车-产品区块制作-中间-图片-->
		<div class="gwc_cp_xiangmu_tupian">
			<img src="<%=cp_tupian%>"  class="gwc_cp_xiangmu_tupian_img" />
		</div>
		<!--购物车-产品区块制作-右侧-产品信息-->
		<div class="gwc_cp_xiangmu_xinxi">
			<div class="gwc_cp_xiangmu_xinxi_biaoti">
				<%=mingcheng%>
			</div>
			<div class="gwc_cp_xiangmu_xinxi_shuxing">
				库存：<%=kucun%> |  已销售：<%=yixiaoshou%>
			</div>
			<!--购物车-产品区块制作-右侧-产品信息-价格-->
			<div class="gwc_cp_xiangmu_xinxi_jiage">
				<div class="gwc_cp_xiangmu_xinxi_jiage_zuo">
                	<span style="color:#999; font-size: 12px;"><strike>¥ <%=gwc_jiage_shichang%></strike></span>&nbsp;&nbsp;
                	¥ <%=gwc_jiage_chengjiao%>
                </div>
				<div class="gwc_cp_xiangmu_xinxi_jiage_you">
                    <!--减少产品数量-->
					<img src="img/jian1.png" class="gwc_cp_xiangmu_xinxi_jiage_you1" 
                    	onClick="jian(<%=gwc_id%>,<%=gwc_cp_shuliang%>,<%=gwc_jiage_chengjiao%>)"
                    />                    
					<input type="text" class="gwc_cp_xiangmu_xinxi_jiage_you2" size="2"   value="<%=gwc_cp_shuliang%>" 
                    	   id="shu<%=gwc_id%>" name="shu"
                    />                   
                    <!--增加产品数量-->
					<img src="img/jia1.png" class="gwc_cp_xiangmu_xinxi_jiage_you3" 
                    	 onClick="jia(<%=gwc_id%>,<%=gwc_cp_shuliang%>,<%=gwc_jiage_chengjiao%>)"
                    />
				</div>
			</div>
		</div>
	</div>
	
</div>
<div class="huise10"></div>



<% 
}
%>
	
	
	
<div class="dibu_jiesuan">
	<div class="dibu_jiesuan_zuo">
		<input  type="checkbox" class="dibu_jiesuan_zuo_chk" id="quanxian" name="quanxian" onChange="qx();" />
		<label for="quanxian">全选</label>        
	</div>
	<div class="dibu_jiesuan_zhong">
		合计：¥ <span id="feiyong"></span>
	</div>
	<input type="submit" value="去结算"    class="dibu_jiesuan_you" >    
</div>



</form>






</body>
</html>