failure2action.java

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

package com.caigou.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.DAO.StockDAO;
import com.bean.DTO.AppbuyDTO;
import com.bean.DTO.PageDTO;
import com.bean.DTO.StockDTO;
import com.database.DataSourceFactory;
import com.servlet.AbstractAction;

public class Failure2Action extends AbstractAction {
	String forward = "";
	public String process(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		Connection con;
		try {
			request.setCharacterEncoding("utf-8");
			con = DataSourceFactory.getDataSource().getConnection();
			StockDAO dao = new StockDAO(con);
			String page = request.getParameter("curpage");
			String product = request.getParameter("productID");
			String project = request.getParameter("projectID");
			int productID = Integer.parseInt(product);
			int projectID = Integer.parseInt(project);
			dao.update3(projectID,productID);
			int curpage=1;
			if(page!=null) curpage=Integer.parseInt(page);
			int totalpage = dao.getTotalPage();
			if(curpage>totalpage) curpage = totalpage;
			if(curpage<1) curpage= 1;
			List<StockDTO> plist = dao.getAll(curpage);
			con.close();
			request.setAttribute("list", plist);
			PageDTO urlpage = new PageDTO();
			urlpage.setCurpage(curpage);
			urlpage.setTotalpage(totalpage);
			request.setAttribute("urlPage", urlpage);
			forward = "checkbuy.do";
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		return forward;
	}

}