复件 listaction.java

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

package Common;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.util.*;
import java.util.ArrayList;
import Common.DBConnectBean;
public class listAction 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();
		Hashtable table=new Hashtable();
		
		list=dbConnectBean.getAllRecord("select * from commodity order by addDay desc");

		int pageNumber=1;
		int pagesize=5;
		int pages=list.size()/pagesize;
		if(list.size()%pagesize!=0){
			pages=list.size()/pagesize+1;
		}	
		if(request.getParameter("pageNumber")!=null)
			pageNumber =  Integer.parseInt((request.getParameter("pageNumber")));
		if(pageNumber<pages)
			for(int i=(pageNumber-1)*pagesize;i<=pageNumber*pagesize-1;i++){
				temp.add((Hashtable)list.get(i));
			}
		else	
			for(int i=(pageNumber-1)*pagesize;i<=list.size()-1;i++){
				temp.add((Hashtable)list.get(i));
			}
		HttpSession session=request.getSession();
		session.setAttribute("pages",pages);
		session.setAttribute("list",temp);
		application.getRequestDispatcher("/administrator/list.jsp").forward(request,response);

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