balancelistaction.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.BalanceDAO;
import com.bean.DAO.RefundDAO;
import com.bean.DTO.BalanceDTO;
import com.bean.DTO.PageDTO;
import com.bean.DTO.RefundDTO;
import com.database.DataSourceFactory;
import com.servlet.AbstractAction;

public class BalancelistAction 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();
			BalanceDAO dao = new BalanceDAO(con);
			List<BalanceDTO> list = dao.getAll();
			for(int i=0;i<list.size();i++){
			  if(list.get(i).getDepID()==1)  list.get(i).setDepname("生产部门");
			  if(list.get(i).getDepID()==2)  list.get(i).setDepname("仓库部门");
			  if(list.get(i).getDepID()==3)  list.get(i).setDepname("财务部门");
			  if(list.get(i).getDepID()==4)  list.get(i).setDepname("采购部门");
			}
			con.close();
			request.setAttribute("list", list);
			forward = "caigouxitong/balancelist.jsp";
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		return forward;
	}

}