clientlistaction.java

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

package Client;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.util.*;
import java.util.ArrayList;
import Common.DBConnectBean;
public class clientListAction extends HttpServlet{
	public void doGet(HttpServletRequest request,HttpServletResponse response)throws IOException,ServletException{
		ServletContext application=getServletConfig().getServletContext(); 
		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);
/*-------------先解决人气排行*/
		list=dbConnectBean.getWantedRecord("select * from commodity order by concern desc",5);
		String card="",num="",model="",photo="",net="",price="",special="",picture="",describe="",restNum="";
		int id=0;
		//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 str="";	
				card=table.get("card".toUpperCase()).toString();str=str+""+card;
				num=table.get("num".toUpperCase()).toString();str=str+""+num;
				
				id=Integer.parseInt(table.get("id".toUpperCase()).toString());
				table.put("showString".toUpperCase(),str);
				//System.out.println("str是"+str);
				//System.out.println("id是"+id);
				table.put("id".toUpperCase(),id);
				table.put("concern".toUpperCase(),table.get("concern".toUpperCase()).toString());
				temp.add(table);
			}
		}
		//System.out.println("temp有这么大"+temp.size());
		//这个是所有用户共同拥有的，所以用application来保存
		application.setAttribute("concernPhone".toUpperCase(),temp);
/*-------------先解决人气排行*/

/*-------------解决发货通知*/
		temp=new ArrayList();
		list=dbConnectBean.getAllRecord("SELECT * FROM userOrders WHERE consignment<>'还未发货' and receipt='未收到'  order by consignment desc");
		//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("sentOrders".toUpperCase(),temp);
/*-------------解决发货通知*/


		
	//	application.getRequestDispatcher("/administrator/adList.jsp").forward(request,response);
		HttpSession session=request.getSession();
		list=dbConnectBean.getAllRecord("select * from commodity order by addDay desc");
		session.setAttribute("searchResultSize".toUpperCase(),list.size());
		
		int pageNumber=1;
		int pageSize=5;
		int pages=list.size()%pageSize==0?list.size()/pageSize:list.size()/pageSize+1;
		
		if(request.getParameter("pageNumber")!=null){
			pageNumber =  Integer.parseInt((request.getParameter("pageNumber")).trim());
			if(pageNumber>pages) 
				pageNumber=pages;
		}
		list=null;	
		temp=dbConnectBean.getPageRecord("select * from commodity order by addDay desc",pageSize,pageNumber);	
		//	//System.out.print(temp.size());
		
		//这个是用户私人拥有的，所以用session来保存
		session=request.getSession();
		session.setAttribute("pages".toUpperCase(),pages);
		session.setAttribute("pageNumber".toUpperCase(),pageNumber);
		session.setAttribute("list".toUpperCase(),temp);
		//administrator
		//client or guest	
		application.getRequestDispatcher("/client/clientList.jsp").forward(request,response);
	}
	public void doPost(HttpServletRequest request,HttpServletResponse response)
	   throws IOException,ServletException
	   {
	   	doGet(request,response);
	   }
}