jajvaavfrrrrrrrrrrrrr

最新推荐文章于 2021-05-20 20:10:35 发布

retyty

最新推荐文章于 2021-05-20 20:10:35 发布

阅读量625

点赞数

本文链接：https://blog.csdn.net/retyty/article/details/9984933

版权

public class ExportExcelAction extends BaseAction { private InputStream inputStream;

public class ExportExcelAction extends BaseAction {
	private InputStream inputStream;
	
	
      public  String  exportGraduateDetail() throws Exception{
    	  GraduateFeedbackDAO gFbDAO=new GraduateFeedbackDAO();
    	  List gFbList=gFbDAO.findAll();
    	  Iterator i_gF = gFbList.iterator();

    	 SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd"); 
  		String targetDirectory = ServletActionContext.getRequest().getRealPath(
  				"temp");
  		String filename = Math.random() + ".xls";

  		OutputStream os = new FileOutputStream(targetDirectory + "\\"
  				+ filename);
  		jxl.write.WritableWorkbook wwb = Workbook.createWorkbook(new File(
				targetDirectory + "\\" + filename));
		jxl.write.WritableSheet ws = wwb.createSheet("学生工作情况", 0);
		jxl.write.Label labelC = new jxl.write.Label(0, 0, "学生姓名");
		ws.addCell(labelC);
		labelC = new jxl.write.Label(1, 0, "班级");
		ws.addCell(labelC);
		labelC = new jxl.write.Label(2, 0, "工作时间");
		ws.addCell(labelC);
		labelC = new jxl.write.Label(3, 0, "工作单位");
		ws.addCell(labelC);
		labelC = new jxl.write.Label(4, 0, "工作岗位");
		ws.addCell(labelC);
		labelC = new jxl.write.Label(5, 0, "薪金待遇");
		ws.addCell(labelC);
		labelC = new jxl.write.Label(6, 0, "联系方式");
		ws.addCell(labelC);
		Integer i = 0;
		while (i_gF.hasNext()) {
			i++;
			GraduateFeedback gFeedback= (GraduateFeedback)i_gF.next();
			String userName=gFeedback.getGraduate().getUsers().getURealName();
			String className=gFeedback.getGraduate().getGraduateClass().getGraduateClassName();
			String companyName=gFeedback.getCompanyName();
			String companyPosition=gFeedback.getCompanyPosition();
			Long graduateSalary= gFeedback.getGraduateSalary();
			String graduateSalaryLL=String.valueOf(graduateSalary);
			String telephone=gFeedback.getTelephone();
			String writeDate=null;
			if(gFeedback.getWriteTime()!=null){
			 writeDate =sdf.format(gFeedback.getWriteTime());
			}
			labelC = new jxl.write.Label(0, i,userName );
			ws.addCell(labelC);
			labelC = new jxl.write.Label(1, i, className);
			ws.addCell(labelC);
			labelC = new jxl.write.Label(2, i, writeDate);
			ws.addCell(labelC);
			labelC = new jxl.write.Label(3, i, companyName);
			ws.addCell(labelC);
			labelC = new jxl.write.Label(4, i, companyPosition);
			ws.addCell(labelC);
			labelC = new jxl.write.Label(5, i, graduateSalaryLL);
			ws.addCell(labelC);
			labelC = new jxl.write.Label(6, i, telephone);
			ws.addCell(labelC);
		}
		wwb.write();
		wwb.close();
		inputStream = new FileInputStream(targetDirectory + "\\" + filename);
		return SUCCESS;
      }

      public String exportGraduateDetail() throws Exception{
       GraduateFeedbackDAO gFbDAO=new GraduateFeedbackDAO();
       List gFbList=gFbDAO.findAll();
       Iterator i_gF = gFbList.iterator();

    SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd");
  String targetDirectory = ServletActionContext.getRequest().getRealPath(
    "temp");
  String filename = Math.random() + ".xls";

  OutputStream os = new FileOutputStream(targetDirectory + "\\"
    + filename);
  jxl.write.WritableWorkbook wwb = Workbook.createWorkbook(new File(
    targetDirectory + "\\" + filename));
  jxl.write.WritableSheet ws = wwb.createSheet("学生工作情况", 0);
  jxl.write.Label labelC = new jxl.write.Label(0, 0, "学生姓名");
  ws.addCell(labelC);
  labelC = new jxl.write.Label(1, 0, "班级");
  ws.addCell(labelC);
  labelC = new jxl.write.Label(2, 0, "工作时间");
  ws.addCell(labelC);
  labelC = new jxl.write.Label(3, 0, "工作单位");
  ws.addCell(labelC);
  labelC = new jxl.write.Label(4, 0, "工作岗位");
  ws.addCell(labelC);
  labelC = new jxl.write.Label(5, 0, "薪金待遇");
  ws.addCell(labelC);
  labelC = new jxl.write.Label(6, 0, "联系方式");
  ws.addCell(labelC);
  Integer i = 0;
  while (i_gF.hasNext()) {
   i++;
   GraduateFeedback gFeedback= (GraduateFeedback)i_gF.next();
   String userName=gFeedback.getGraduate().getUsers().getURealName();
   String className=gFeedback.getGraduate().getGraduateClass().getGraduateClassName();
   String companyName=gFeedback.getCompanyName();
   String companyPosition=gFeedback.getCompanyPosition();
   Long graduateSalary= gFeedback.getGraduateSalary();
   String graduateSalaryLL=String.valueOf(graduateSalary);
   String telephone=gFeedback.getTelephone();
   String writeDate=null;
   if(gFeedback.getWriteTime()!=null){
    writeDate =sdf.format(gFeedback.getWriteTime());
   }
   labelC = new