pjffreportdatesource.java

文件的上传和下载的实现,用JAva编写,非常简单

package edu.whut.cwts.pg.fafang;


import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Timestamp;
import java.util.ArrayList;
import java.util.Calendar;

import edu.whut.cwts.pg.db.ConnectDB;
import net.sf.jasperreports.engine.JRDataSource;
import net.sf.jasperreports.engine.JRException;
import net.sf.jasperreports.engine.JasperReport;
import net.sf.jasperreports.engine.data.JRAbstractBeanDataSourceProvider;
import net.sf.jasperreports.engine.data.JRBeanCollectionDataSource;

public class pjffReportDateSource extends JRAbstractBeanDataSourceProvider{

	/**
	 * @param args
	 */
	private String pjffString;
	
    public String getPjffString() {
		return pjffString;
	}
	  
	public void setPjffString(String pjffString) {
		this.pjffString = pjffString;
	}
	
	public pjffReportDateSource(){
		super(pjffReport.class);
	}
	
	//传递的票据种类
	public JRDataSource create(JasperReport report) throws JRException {
		   ArrayList list=new ArrayList();
		   String lpdw="";
		   String tbdw="";
	       String pjffString = this.pjffString;
	       System.out.println(pjffString);
	       //传递的参数s组成顺序为pzmc,deptSecondZddm,deptFistZddm,+pzqh+pzzh
	       String[] result=pjffString.split(";");
	       System.out.println(result.length);
	       String pzmc=result[0];
	       String deptSecond=result[1];
	       String deptFirst=result[2];
	       String sql1="Select zdmc from zdxxb where zddm='"+deptSecond+"'";
	       String sql2="Select zdmc from zdxxb where zddm='"+deptFirst+"'";
	       ConnectDB conn=new ConnectDB();
	       ResultSet rst=conn.executeQuery(sql1);
	          try{
	          while(rst.next())
	          {
	        	lpdw=rst.getString("zdmc");
	          }
	          }
	          catch(SQLException e)
	          {
	        	  e.printStackTrace();
	          }
	          System.out.println(lpdw);
	          conn.close();
	          ConnectDB conn1=new ConnectDB();
	          ResultSet rst1=conn1.executeQuery(sql2);
	          try{
	          while(rst1.next())
	          {
	            tbdw=rst1.getString("zdmc");
	          }
	          }
	          catch(SQLException e)
	          {
	        	  e.printStackTrace();
	          }
	          System.out.println(tbdw);
	          conn1.close();
	         //获得时间
	        Timestamp ts=new Timestamp(System.currentTimeMillis()); 
	  	    String date=ts.toString();
	    	Calendar c = Calendar.getInstance();
	        int nyear=c.get(Calendar.YEAR); 
	    	int nmonth=c.get(Calendar.MONTH)+1;
	    	int nday=c.get(Calendar.DATE);
	    	
	  	    int j=1;
	         for(int i=3;i<result.length;)
	         {
	        	pjffReport singledate=new pjffReport();
	        	singledate.setPzmc(pzmc);
	        	singledate.setTjsj(date);
	        	singledate.setId(""+j);
	        	j++;
	        	int k=Integer.valueOf(result[i]).intValue();
	        	int p=Integer.valueOf(result[i+1]).intValue();
	        	int pjfs=p-k;
	        	singledate.setPdqh(result[i]);
	        	singledate.setPdzh(result[i+1]);
	        	singledate.setPjfs(String.valueOf(pjfs));
	        	singledate.setLpdw(lpdw);
	        	singledate.setTbdw(tbdw);
	        	singledate.setNyear(""+nyear);
	        	singledate.setNmonth(""+nmonth);
	        	singledate.setNday(""+nday);
	        	list.add(singledate);
	        	i=i+2;
	         }
	       return new JRBeanCollectionDataSource(list);
	}


	public void dispose(JRDataSource dataSource) throws JRException {
          // nothing to dispose
  }

}