⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 order.jsp

📁 这是我们做的一个网上购物系统,包手用户和管理员两大功能模块,采用jsp+servlet+java bean技术.
💻 JSP
字号:
🔍 
<%@ page language="java" import="java.util.*" pageEncoding="gbk"%>
<%@ page import="com.qyg.shop.product.*" %>
<%@ page import="com.qyg.shop.user.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="com.qyg.shop.sales.*" %>

<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>My JSP 'consume.jsp' starting page</title>
    
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0">    
	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
	<meta http-equiv="description" content="This is my page">
	<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	-->
	
	<link rel="stylesheet" href="css/common.css" type="text/css"></link>
  </head>
  
  <body bgcolor="D9EAFC">
     <p align=center>&nbsp; 
     这里是所有的订单信息: 
  <%
      
  	ArrayList<Sales> v=null;

  	SalesDAO sdao = new SalesManageDAO();
  	
    v = sdao.getSalesByState(0,false);
    out.print("  共<font color=color>"+v.size()+"</font>条<br><br>");
  	
   %>
   
   
  <table align=center  width=98% border="1"  class="datalist">
			<tbody>
				<tr>
					<th>用户ID </th>
					<th>地址 </th>
					<th>电话</th>
					<th>产品id</th>
					<th >产品名称	</th>
					<th >产品价格	</th>
					<th>购买数量</th>
					<th>金额</th>
					<th>购买时间</th>
					<th>操作</th>
				</tr>
   <%
      
       		for(int i=0;i<v.size();i++){
           		out.print("<tr>");
           		UserDAO udao = new UserManageDAO();
           		
           		ProductDAO pdao = new ProductManageDAO();
           		Product p = pdao.getProductById(v.get(i).getSales_productId());
           		out.print("<td>" + v.get(i).getSales_userId() + "</td>");
				User user = udao.getUserById(v.get(i).getSales_userId());
				System.out.println(user);
           		out.print("<td>"+user.getAddr() +"</td>");
				out.print("<td>"+user.getPhone() +"</td>");
		   		out.print("<td>" + p.getProduct_id() + "</td>");
		   		out.print("<td>" + p.getProduct_name() + "</td>");
		   		out.print("<td>" + p.getProduct_price() + "</td>");						
		   		out.print("<td>" + v.get(i).getSales_productNum() + "</td>");
		   		out.print("<td>" + p.getProduct_price()*v.get(i).getSales_productNum()+"</td>");
		   		out.print("<td>" + v.get(i).getSales_date() + "</td>");
				
				String overActionStr = "<a href='servlet/AdminServlet?action=orderOver&salesid="
						+ v.get(i).getSales_id() + "' >完成订单</a>";
				out.print("<td>" + overActionStr + "</td>");
								
		   		out.print("</tr>");
         
       }  
   %>
  </body>
  

  <script language="javascript">                      
	var rows = document.getElementsByTagName('tr');
	for (var i=0;i<rows.length;i++){
		rows[i].onmouseover = function(){		//鼠标在行上面的时候
			this.className += 'altrow';
		}
		rows[i].onmouseout = function(){		//鼠标离开时
			this.className = this.className.replace('altrow','');
		}
	}
</script>

</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -