stockselectaction.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.StockDAO;
import com.bean.DTO.PageDTO;
import com.bean.DTO.SelectDTO;
import com.bean.DTO.StockDTO;
import com.database.DataSourceFactory;
import com.servlet.AbstractAction;

public class StockselectAction extends AbstractAction {

	private String forward="";
	public String process(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {
		Connection con;
		try {
			request.setCharacterEncoding("utf-8");
			con = DataSourceFactory.getDataSource().getConnection();
			StockDAO dao = new StockDAO(con);
			String page = request.getParameter("curpage");
			String type = request.getParameter("select");
			String number = request.getParameter("number");
			if(type==null) type = "3";
			if(number==null||number=="") {
				number="";
			}
			SelectDTO select =new SelectDTO();
			select.setSelect(type);
			select.setNumber(number);
			request.setAttribute("select", select);
			int num=0;
			if(!number.trim().equals("")){
				num = Integer.parseInt(number);
			}
			if(Integer.parseInt(type)==3){
				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> list = dao.getAll2(curpage);
				con.close();
				request.setAttribute("list", list);
				PageDTO urlpage = new PageDTO();
				urlpage.setCurpage(curpage);
				urlpage.setTotalpage(totalpage);
				request.setAttribute("urlPage", urlpage);
			}
			if(Integer.parseInt(type)==1){
				int curpage=1;
				if(page!=null) curpage=Integer.parseInt(page);
				int totalpage = dao.getTotalPage3(num);
				if(curpage>totalpage) curpage = totalpage;
				if(curpage<1) curpage= 1;
				List<StockDTO> list = dao.getAll3(curpage,num);
				con.close();
				request.setAttribute("list", list);
				PageDTO urlpage = new PageDTO();
				urlpage.setCurpage(curpage);
				urlpage.setTotalpage(totalpage);
				request.setAttribute("urlPage", urlpage);
			}
			if(Integer.parseInt(type)==2){
				int curpage=1;
				if(page!=null) curpage=Integer.parseInt(page);
				int totalpage = dao.getTotalPage4(num);
				if(curpage>totalpage) curpage = totalpage;
				if(curpage<1) curpage= 1;
				List<StockDTO> list = dao.getAll4(curpage,num);
				con.close();
				request.setAttribute("list", list);
				PageDTO urlpage = new PageDTO();
				urlpage.setCurpage(curpage);
				urlpage.setTotalpage(totalpage);
				request.setAttribute("urlPage", urlpage);
			}
			forward = "caigouxitong/buylist.jsp";
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return forward;
	}

}