📄 administratorshoworderaction.java
字号:
package Administrator;
import java.io.*;
import java.text.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.util.*;
import Common.DBConnectBean;
public class administratorShowOrderAction extends HttpServlet{
public void doGet(HttpServletRequest request,HttpServletResponse response)throws IOException,ServletException{
ServletContext application=getServletConfig().getServletContext();
request.setCharacterEncoding("gb2312");
HttpSession session=request.getSession();
String identify=(String)session.getAttribute("identify".toUpperCase());
////////////////////System.out.println("这个没打印");
if(identify==null||!(identify.equals("administrator"))){
application.getRequestDispatcher("/client/clientList.jsp?logged=false").forward(request,response);
}
ArrayList userOrder=new ArrayList();
//获取现在客户的购物车里的所有商品的信息及数量
DBConnectBean dbBean=new DBConnectBean("sun.jdbc.odbc.JdbcOdbcDriver","jdbc:odbc:shopping","","");
ArrayList order=dbBean.getAllRecord("select * from userOrders order by addDay desc");
//如果客户已经买了该商品,则添加商品数量
if(order!=null)
for(int i=0;i<order.size();i++){
Hashtable table=(Hashtable)order.get(i);
String orderID="",username="",addDay="",totalPrice="",consignment="",receipt="";
Hashtable orderedCommodity=new Hashtable();
orderID=table.get("orderID".toUpperCase()).toString();
System.out.println("orderID"+orderID);
username=table.get("username".toUpperCase()).toString();
addDay=table.get("addDay".toUpperCase()).toString();
totalPrice=table.get("totalPrice".toUpperCase()).toString();
consignment=table.get("consignment".toUpperCase()).toString();
receipt=table.get("receipt".toUpperCase()).toString();
orderedCommodity.put("orderID".toUpperCase(),orderID);
orderedCommodity.put("username".toUpperCase(),username);
orderedCommodity.put("addDay".toUpperCase(),addDay);
orderedCommodity.put("totalPrice".toUpperCase(),totalPrice);
orderedCommodity.put("consignment".toUpperCase(),consignment);
orderedCommodity.put("receipt".toUpperCase(),receipt);
userOrder.add(orderedCommodity);
}
System.out.println("userOrder"+userOrder.size());
//如果可户还未买该商品,则添加新商品
session.setAttribute("userOrder".toUpperCase(),userOrder);
application.getRequestDispatcher("/administrator/administratorShowOrder.jsp").forward(request,response);
}
public void doPost(HttpServletRequest request,HttpServletResponse response)throws IOException,ServletException{
doGet(request,response);
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -