approveapp.java

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

package com.produce.action;

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

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

import com.bean.DAO.AppbuyDAO;
import com.bean.DAO.ApplicationDAO;
import com.bean.DTO.AppbuyDTO;
import com.bean.DTO.ApplicationDTO;
import com.bean.DTO.PageDTO;
import com.bean.DTO.UserinforDTO;
import com.database.DataSourceFactory;
import com.servlet.AbstractAction;

public class ApproveApp 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 directorID=((UserinforDTO)request.getSession().getAttribute("userinfor")).getUserID();
		String apptime=request.getParameter("apptime");
		String productID=request.getParameter("productID");
		
		
		
		try {
			Connection con=DataSourceFactory.getDataSource().getConnection();
			ApplicationDTO dto=new ApplicationDTO();
			
			dto.setDirectorID(directorID);
			dto.setProductID(Integer.parseInt(productID));
			dto.setStateID(9);
			dto.setApptime(apptime);
			
			ApplicationDAO dao=new ApplicationDAO();
			dao.approveApp(dto, con);
			if(page!=null) curpage=Integer.parseInt(page);
			int totalpage = dao.getTotalPage(con);
			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{
			
			redirect="/producelist.do?field=2";
		}
		
		
		return redirect;
	}

}