pbxls.java

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

package com.bean.xls;
import java.io.File;
import java.io.IOException;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;

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.BrokenproductDAO;
import com.bean.DTO.BrokenproductDTO;
import com.database.DataSourceFactory;
import com.dom4j.SMSConfig;
public class  PBxls{
	public void writeXLS(List<BrokenproductDTO> list,String filename){
		String path="E:/xls//"+filename+".xls";
		File file = new File(path);
		if(!file.isAbsolute())
			try {
				file.createNewFile();
			} catch (IOException e1) 
			{
				e1.printStackTrace();
			}
		try{
		WritableWorkbook workbook =Workbook.createWorkbook(file);
		WritableSheet sheet = workbook.createSheet("第一页�",0);
		for(int i=0;i<5;i++){
			sheet.setColumnView(i,10);
			}
		Label ProductID =new Label(0,0,"物品ID");
		sheet.addCell(ProductID);
		Label Productname =new Label(1,0,"物品名称");
		sheet.addCell(Productname);
		Label Brokenamount =new Label(2,0,"损坏数量");
		sheet.addCell(Brokenamount);
		Label Reason =new Label(3,0,"损坏原因");
		sheet.addCell(Reason);
		Label Breaktime =new Label(4,0,"损坏时间");
		sheet.addCell(Breaktime);
		Label CheckerID =new Label(5,0,"操作员ID");
		sheet.addCell(CheckerID);
		Label Checker=new Label(6,0,"操作员");
		sheet.addCell(Checker);
		Label directorID=new Label(7,0,"负责人ID");
		sheet.addCell(directorID);
		
		int i=1;
		for(int j=0;j<list.size();j++){
			BrokenproductDTO dto=new BrokenproductDTO();
			dto =list.get(j);
			sheet.addCell(new Label(0,i,new Integer(dto.getProductID()).toString()));
			sheet.addCell(new Label(1,i,dto.getProductname().toString()));
			sheet.addCell(new Label(2,i,new Integer(dto.getBrokenamount()).toString()));
			sheet.addCell(new Label(3,i,dto.getReason().toString()));
			sheet.addCell(new Label(4,i,dto.getBreaktime().toString()));
			sheet.addCell(new Label(5,i,new Integer(dto.getCheckerID()).toString()));
			sheet.addCell(new Label(6,i,dto.getChecker().toString()));
			sheet.addCell(new Label(7,i,new Integer(dto.getDirectorID()).toString()));
			i++;
		}
		workbook.write();
		workbook.close();
		}catch(IOException e){
			e.printStackTrace();
		}
		 catch (RowsExceededException e) {
			e.printStackTrace();
		} catch (WriteException e) {
			e.printStackTrace();
		}	
	}
public static void main(String[] args) {
	PBxls pbx=new PBxls();
	BrokenproductDAO bp=new BrokenproductDAO();
	Connection con;
	SMSConfig.getSMSConfig().readXML("WebRoot/WEB-INF/SMSConfig.xml");
	try {
		con = DataSourceFactory.getDataSource().getConnection();
		pbx.writeXLS(bp.getAlllist(1, con), "broken");
	} catch (SQLException e) {
		e.printStackTrace();
	}
	
	}

}