administratorlistaction.java

来自「电子商务网站使用MVC模式B/S结构功能不是很全适合初学者看」· Java 代码 · 共 88 行

package Administrator;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.util.*;
import java.util.ArrayList;
import Common.DBConnectBean;
public class administratorListAction extends HttpServlet{
	public void doGet(HttpServletRequest request,HttpServletResponse response)throws IOException,ServletException{
		ServletContext application=getServletConfig().getServletContext(); 
		request.setCharacterEncoding("gb2312");
		HttpSession session=request.getSession();
		DBConnectBean dbConnectBean=new DBConnectBean("sun.jdbc.odbc.JdbcOdbcDriver","jdbc:odbc:shopping","","");
		ArrayList list=new ArrayList();
		ArrayList temp=new ArrayList();
	
		list=dbConnectBean.getAllRecord("SELECT DISTINCT card FROM commodity");
		application.setAttribute("card".toUpperCase(),list);
		String card="",num="",model="",photo="",net="",price="",special="",picture="",describe="",key="";

		int id=0;
	
		//System.out.println("temp有这么大"+temp.size());
		//这个是所有用户共同拥有的，所以用application来保存
/*-------------先解决人气排行*/



/*-------------解决发货通知*/
		temp=new ArrayList();
		list=dbConnectBean.getAllRecord("SELECT * FROM userOrders WHERE consignment='还未发货'");
		//System.out.println("list有这么大"+list.size());
		if(list!=null){	
			Hashtable table=new Hashtable();
			for(int i=0;i<list.size();i++){
				table=(Hashtable)list.get(i);
				String username="",orderID="",addDay="",totalPrice="",consignment="";	
				username=table.get("username".toUpperCase()).toString();
				orderID=table.get("orderID".toUpperCase()).toString();
				addDay=table.get("addDay".toUpperCase()).toString();
				totalPrice=table.get("totalPrice".toUpperCase()).toString();
				consignment=table.get("consignment".toUpperCase()).toString();

				table.put("username".toUpperCase(),username);
				table.put("orderID".toUpperCase(),orderID);
				table.put("addDay".toUpperCase(),addDay);
				table.put("totalPrice".toUpperCase(),totalPrice);
				table.put("consignment".toUpperCase(),consignment);
				temp.add(table);
			}
		}
		//System.out.println("temp有这么大"+temp.size());
		//这个是所有用户共同拥有的，所以用application来保存
		application.setAttribute("newOrders".toUpperCase(),temp);
/*-------------解决发货通知*/
		
	//	application.getRequestDispatcher("/administrator/adList.jsp").forward(request,response);
		
		list=dbConnectBean.getAllRecord("select * from commodity order by addDay desc");
		session.setAttribute("searchResultSize".toUpperCase(),list.size());
		int pageNumber=1;
		int pageSize=6;
		int pages=list.size()%pageSize==0?list.size()/pageSize:list.size()/pageSize+1;
		
		if(request.getParameter("pageNumber")!=null){
			System.out.println("page "+request.getParameter("pageNumber"));
			pageNumber =  Integer.parseInt((request.getParameter("pageNumber")));
			if(pageNumber>pages) 
				pageNumber=pages;
		}
		System.out.println("pageNumber="+pageNumber+"   pages="+pages);
		list=null;	
		temp=dbConnectBean.getPageRecord("select * from commodity order by addDay desc",pageSize,pageNumber);	
		//	//System.out.print(temp.size());
		application.setAttribute("adList".toUpperCase(),temp);
		
		//这个是用户私人拥有的，所以用session来保存
		session.setAttribute("pages".toUpperCase(),pages);
		session.setAttribute("pageNumber".toUpperCase(),pageNumber);
		session.setAttribute("list".toUpperCase(),temp);
		//administrator
		application.getRequestDispatcher("/administrator/administratorList.jsp").forward(request,response);

	   }
	public void doPost(HttpServletRequest request,HttpServletResponse response)throws IOException,ServletException{
	   	doGet(request,response);
	}
}