produceapprove.java

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

package com.produce.action;

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.AppbuyDAO;
import com.bean.DTO.AppbuyDTO;
import com.bean.DTO.PageDTO;
import com.bean.DTO.UserinforDTO;
import com.database.DataSourceFactory;
import com.servlet.AbstractAction;

public class ProduceApprove extends AbstractAction {

	@Override
	public String process(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {
	
		String redirect=null;
		int curpage=1;
		String page=request.getParameter("curpage");
		int appdirctorID=((UserinforDTO)request.getSession().getAttribute("userinfor")).getUserID();;
		String apptime=request.getParameter("apptime");
		String productID=request.getParameter("productID");
		
		
		
		try {
			Connection con=DataSourceFactory.getDataSource().getConnection();
			AppbuyDTO dto=new AppbuyDTO();
			
			dto.setAppdirctorID(appdirctorID);
			dto.setProductID(Integer.parseInt(productID));
			dto.setStateID(9);
			dto.setApptime(apptime);
			
			AppbuyDAO dao=new AppbuyDAO(con);
			dao.approveAppbuy(dto);
			if(page!=null) curpage=Integer.parseInt(page);
			int totalpage = dao.getTotalPage();
			if(curpage>totalpage) curpage = totalpage;
			if(curpage<1) curpage= 1;
			
			PageDTO urlpage = new PageDTO();
			urlpage.setCurpage(curpage);
			urlpage.setTotalpage(totalpage);
			request.setAttribute("urlPage", urlpage);
			con.close();
		  
			}
			 catch (SQLException e) {
			
			e.printStackTrace();
		}finally{
			System.out.println("从审核到再次producelist的时刻");
			redirect="/producelist.do?field=1";
		}
		
		
		return redirect;
	}

}