backupaction.java

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

package com.caigou.action;

import java.io.File;
import java.io.IOException;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
import jxl.write.biff.RowsExceededException;

import com.bean.DAO.StockDAO;
import com.bean.DTO.StockDTO;
import com.bean.DTO.TimeDTO;
import com.database.DataSourceFactory;
import com.servlet.AbstractAction;

public class BackupAction extends AbstractAction {

	private String forward="";
	public String process(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {
		request.setCharacterEncoding("utf-8");
		String begin = request.getParameter("begin");
		String end = request.getParameter("end");
		TimeDTO time = new TimeDTO();
		time.setBegin(begin);
		time.setEnd(end);
		request.setAttribute("time", time);
		request.setAttribute("success", "导出成功！");
		File file = new File("e:/data/stock.xls");
		WritableWorkbook workbook = Workbook.createWorkbook(file);
		WritableSheet sheet = workbook.createSheet("第一页", 0);
		for(int i=0;i<5;i++){
			sheet.setColumnView(i, 10);
		}
		try {
			Label l1 = new Label(0,0,"采购项目ID");
			sheet.addCell(l1);
			Label l2 = new Label(1,0,"货物ID");
			sheet.addCell(l2);
			Label l3 = new Label(2,0,"价格");
			sheet.addCell(l3);
			Label l4 = new Label(3,0,"数量");
			sheet.addCell(l4);
			Label l5 = new Label(4,0,"供货商");
			sheet.addCell(l5);
			Label l6 = new Label(5,0,"采购时间");
			sheet.addCell(l6);
			Label l7 = new Label(6,0,"负责人ID");
			sheet.addCell(l7);
			Label l8 = new Label(7,0,"部门主管ID");
			sheet.addCell(l8);
			Label l9 = new Label(8,0,"审批状态");
			sheet.addCell(l9);
			Connection con = DataSourceFactory.getDataSource().getConnection();
			StockDAO dao = new StockDAO(con);
			List<StockDTO> list = new ArrayList();
			if(begin.trim().equals("0000-00-00")&&end.trim().equals("0000-00-00")){
				list = dao.getAll1();
			}
			else{
				list = dao.getAll5(begin,end);
			}
			request.setAttribute("list", list);
			forward = "caigouxitong/backupstock.jsp";
			con.close();
			int i=1;
			for(int j=0;j<list.size();j++){
				StockDTO dto = new StockDTO();
				dto=list.get(j);
				sheet.addCell(new Label(0,i,new Integer(dto.getProjectID()).toString()));
				sheet.addCell(new Label(1,i,new Integer(dto.getProductID()).toString()));
				sheet.addCell(new Label(2,i,new Float(dto.getRealprice()).toString()));
				sheet.addCell(new Label(3,i,new Float(dto.getRealamount()).toString()));
				sheet.addCell(new Label(4,i,dto.getProvider()));
				sheet.addCell(new Label(5,i,dto.getBuytime()));
				sheet.addCell(new Label(6,i,new Integer(dto.getCheckerID()).toString()));
				sheet.addCell(new Label(7,i,new Integer(dto.getDirectorID()).toString()));
				sheet.addCell(new Label(8,i,new Integer(dto.getStateID()).toString()));
				i++;
			}
			workbook.write();
			workbook.close();
		} catch (RowsExceededException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (WriteException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return forward;
	}

}