searchgood.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.database.DataSourceFactory;
import com.servlet.AbstractAction;
import com.system.action.popedomCheck;

public class searchgood extends AbstractAction {

	public String process(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {
		String url="storeManage/gm/goodsortSearch.jsp";
		UserinforDTO udt=(UserinforDTO)request.getSession().getAttribute("userinfor");
		popedomCheck pc=new popedomCheck(udt);
		if(pc.storeCheck2()){
		ProductDAO pd=new ProductDAO();
		ProductsortDAO psd=new ProductsortDAO();
		request.setCharacterEncoding("UTF-8");
		String sort=request.getParameter("sort");
		List<ProductDTO> plist=null;
		Connection con;
		try {
			con = DataSourceFactory.getDataSource().getConnection();
			List<ProductsortDTO> pslist=psd.getAll(con);
			if(sort.length()>0){
				plist=pd.getAll(Integer.parseInt(sort),con);
			}
			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;
	}

}