gioget.java

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

package com.store.action.table;

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.ProductoutputDAO;
import com.bean.DAO.ProductregisterDAO;
import com.bean.DTO.ProductoutputDTO;
import com.bean.DTO.ProductregisterDTO;
import com.bean.DTO.UserinforDTO;
import com.bean.xls.IOxls;
import com.database.DataSourceFactory;
import com.servlet.AbstractAction;
import com.system.action.popedomCheck;

public class gioGet extends AbstractAction {
	public String process(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {
		String path = "storeManage/table/IOLook.jsp";
		UserinforDTO udt = (UserinforDTO) request.getSession().getAttribute(
				"userinfor");
		popedomCheck pc = new popedomCheck(udt);
		if (pc.storeCheck2()) {
			ProductregisterDAO pid = new ProductregisterDAO();
			String time = (String) request.getParameter("time1");
			String time1 = (String) request.getParameter("time2");
			IOxls pbx = new IOxls();
			String filepath = time + "-" + time1 + "io";
			if (filepath.length() > 20) {
				Connection con;
				try {
					con = DataSourceFactory.getDataSource().getConnection();
					List<ProductregisterDTO> pilist = pid.gettimedAll(time,
							time1, con);
					ProductoutputDAO pod = new ProductoutputDAO();
					List<ProductoutputDTO> polist = pod.gettimedAll(time,
							time1, con);

					pbx.writeXLS(pilist, polist, filepath);
					request.setAttribute("pilist", pilist);
					request.setAttribute("polist", polist);
					con.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
		} else {
			path = "User/login.jsp";
		}
		return path;

	}
}