goodslist.java

仓库管理系统,适合各种行业的仓库管理系统

package com.store.action.gm;

import java.io.IOException;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.bean.DAO.ProductDAO;
import com.bean.DAO.ProductsortDAO;
import com.bean.DTO.ProductDTO;
import com.bean.DTO.ProductsortDTO;
import com.bean.DTO.UserinforDTO;
import com.bean.DTO.dpageDTO;
import com.database.DataSourceFactory;
import com.servlet.AbstractAction;
import com.system.action.popedomCheck;

public class goodsList extends AbstractAction {

	public String process(HttpServletRequest request, HttpServletResponse response)
	throws ServletException, IOException{
		String url="storeManage/gm/goodManage.jsp";
		UserinforDTO udt=(UserinforDTO)request.getSession().getAttribute("userinfor");
		popedomCheck pc=new popedomCheck(udt);
		if(pc.storeCheck2()){
		ProductDAO pd=new ProductDAO();
		dpageDTO pad=new dpageDTO();
		int pageindex=1;
		Connection con;
		try {
			con = DataSourceFactory.getDataSource().getConnection();
			pad.setMaxpage(pd.getmaxpage(con));
			ProductsortDAO psd=new ProductsortDAO();
			String pagestr=(String) request.getParameter("pageindex");
			if(pagestr!=null){
				pageindex=Integer.parseInt(pagestr);
				pad.setPageindex(pageindex);
			}
			List<ProductDTO> plist=pd.getAlllist(pad.getPageindex(),con);
			List<ProductsortDTO> pslist=psd.getAll(con);
			request.setAttribute("pad", pad);
			request.setAttribute("plist", plist);
			request.setAttribute("pslist", pslist);
			con.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		}
		else{
			url="User/login.jsp";
		}
		return url;
	}

}