chinaexcel报表的使用

function print(){
	      print_select();
	      var row = grid.getSelected();
	      if(row.DETAILSID==""){
	          return ;
	      }
	      var obChinaExcel=document.getElementById('ChinaExcel');
	      obChinaExcel.OnFilePrintPreview();
  	}
  	function print_select(){
	     var date=mini.get("date").getFormValue();
	     var row = grid.getSelected();
     	 if(row.DETAILSID=="") {
      		mini.alert("对账情况未完成，请重新选择!");
      		return ;
     	 }
	      var nd=(row.DATE2).substring(0,4);
	      var row = grid.getSelected();
	      if(row.DZZT == '3'){
	      	ChinaExcel.ReadHttpTabFile("tab/dzMgr_print.tab");
	      }else{
		    ChinaExcel.ReadHttpTabFile("tab/dzMgr_print_no_stamp.tab");
	      }
	      var param ="dzMgr_printData.jsp?id="+row.ID+"&rwh="+row.RWH+"&detailsId="+row.DETAILSID+"&dwdm="+row.DWDM+"&date1="+row.DATE1+"&date2="+row.DATE2+"&dwmc="+row.DWMC;
	      ChinaExcel.SetOnlyShowTipMessage(true);
	      ChinaExcel.RestoreAfterCalculate();
	      ChinaExcel.SetStatFetchDataMode(param,1,1);
	      ChinaExcel.DesignMode = false;
	      ChinaExcel.SetShowPopupMenu(false);
	      ChinaExcel.FormProtect=true;
	      ChinaExcel.SetCellVal(3,1,"单位名称："+row.DWMC);
	      ChinaExcel.SetCellVal(4,1,row.DATE2+"止，你单位财政资金情况");
	      ChinaExcel.ReCalculate();
	      ChinaExcel.SetOnlyShowTipMessage(false);
    }

/kfqG6/WebRoot/jsp/sfdz/dzMgr_printData.jsp

<%@page import="java.sql.*"
import ="java.util.*"
import ="java.io.*"
import="java.text.*"
import="com.yeyoo.core.*"
import="com.yeyoo.bean.*"
contentType="text/html; charset=gbk"
buffer="20kb"
%>
<%@page import="com.yeyoo.core.ConnectionUtil,com.yeyoo.bean.ConstantBean"%>
<%
	StringBuffer strBuffer = new StringBuffer("");
	String sql;
	Connection odbcconn;
	Statement odbcstmt;
	ResultSet odbcrs;
	
	
	String nd = request.getParameter("nd");
	if(StringUtil.isEmpty(nd)){
		nd=DateUtil.getYear();
	}
	String zt2= ConstantBean.dbPrefix+ConstantBean.dbStr_dznr2;
	String db2=ConnectionUtil.getDBStr(nd,zt2);
    String zt= ConstantBean.dbPrefix+ConstantBean.dbStr_ys;
    String db=ConnectionUtil.getDBStr(nd,zt);
    String dzmxId = request.getParameter("id");
    String rwh = request.getParameter("rwh");
    String dwdm = request.getParameter("dwdm");
    String dwmc = request.getParameter("dwmc");
    String date1 = request.getParameter("date1");
    String date2 = request.getParameter("date2");
    String detailsId = request.getParameter("detailsId");

try
{
    odbcconn =  ConnectionUtil.getConnection();
    odbcstmt = odbcconn.createStatement();
    if(detailsId!=null && detailsId !=""){
    	sql = " select * from jcpt_sfdz_details ";
		if(!StringUtil.isEmpty(detailsId)){
			sql+=" where id ='"+detailsId+"' ";
		}
	 }else{
			//这个是拷贝来自action里面的代码---查对账单左边的内容
			sql=" select "+
				" '"+dwdm+"' dwdm, "+
				" sum(cz_ysnzjzc_by) cz_ysnzjzc_by,sum(cz_ysnzjzc_lj) cz_ysnzjzc_lj,sum(cz_xzsyxsr_by) cz_xzsyxsr_by,sum(cz_xzsyxsr_bn) cz_xzsyxsr_bn,sum(cz_xzsyxsr_lj) cz_xzsyxsr_lj,sum(cz_wlzj_ye) cz_wlzj_ye,sum(cz_dg_lnjy_ncs) cz_dg_lnjy_ncs,sum(cz_dg_lnjy_lj) cz_dg_lnjy_lj,sum(cz_dg_lnjy_ye) cz_dg_lnjy_ye,"+
				" sum(cz_dwwlzj_ncs) cz_dwwlzj_ncs,sum(cz_dwwlzj_ljsr) cz_dwwlzj_ljsr,sum(cz_dwwlzj_ljzc) cz_dwwlzj_ljzc,sum(cz_dwwlzj_ye) cz