producequery.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.DTO.AppbuyDTO;
import com.bean.DTO.ApplicationDTO;
import com.database.DataSourceFactory;
import com.servlet.AbstractAction;

public class ProduceQuery extends AbstractAction {

	@Override
	public String process(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {
		String redirect=null;
		String condition=request.getParameter("app");
        
		try {
			Connection con=DataSourceFactory.getDataSource().getConnection();
			if(condition.equalsIgnoreCase("1")){
				
				ApplicationDAO dao=new ApplicationDAO();
				List<ApplicationDTO> list=dao.getAll(con);
				request.setAttribute("list",list);
			
			
				request.setAttribute("condition","1");
			}else{
				AppbuyDAO dao=new AppbuyDAO(con);
				List<AppbuyDTO> list=dao.getAll();
				request.setAttribute("list",list);
				
				request.setAttribute("condition","2");
			}
			con.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			redirect="/shengchanguanli/producequery.jsp";
		}
		
		return redirect;
	}

}