producelist.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.DAO.ApplicationDAO;
import com.bean.DAO.RefundDAO;
import com.bean.DTO.AppbuyDTO;
import com.bean.DTO.ApplicationDTO;
import com.bean.DTO.PageDTO;
import com.bean.DTO.RefundDTO;
import com.database.DataSourceFactory;
import com.servlet.AbstractAction;

public class ProduceList extends AbstractAction {

	@Override
	public String process(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {
         
		String redirect=null;
		int curpage=1;
		String page=request.getParameter("curpage");
		
		String field=request.getParameter("field");
		
		try {
			Connection con=DataSourceFactory.getDataSource().getConnection();
			if(field.equals("1")){
				
			AppbuyDAO dao=new AppbuyDAO(con);
			
			if(page!=null) curpage=Integer.parseInt(page);
			int totalpage = dao.getTotalPage();
			if(curpage>totalpage) curpage = totalpage;
			if(curpage<1) curpage= 1;
			
			List<AppbuyDTO> list=dao.queryAddbuy(curpage);
			con.close();
		    request.setAttribute("list",list);
		    PageDTO urlpage = new PageDTO();
			urlpage.setCurpage(curpage);
			urlpage.setTotalpage(totalpage);
			request.setAttribute("urlPage", urlpage);
			redirect="/shengchanguanli/approve.jsp";
			}else{
				ApplicationDAO dao=new ApplicationDAO();
				
				if(page!=null) curpage=Integer.parseInt(page);
				int totalpage = dao.getTotalPage(con);
				if(curpage>totalpage) curpage = totalpage;
				if(curpage<1) curpage= 1;
				
				List<ApplicationDTO> list=dao.queryAddapp(curpage, con);
				con.close();
			    request.setAttribute("list",list);
			
			    PageDTO urlpage = new PageDTO();
				urlpage.setCurpage(curpage);
				urlpage.setTotalpage(totalpage);
				request.setAttribute("urlPage", urlpage);
				redirect="/shengchanguanli/approveapp.jsp";
				
			}
			}
			 catch (SQLException e) {
			
			e.printStackTrace();
		}
		
		
		return redirect;
	}

}