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_dwwlzj_ye,sum(cz_dwqtsr_ncs) cz_dwqtsr_ncs,sum(cz_dwqtsr_ljsr) cz_dwqtsr_ljsr,sum(cz_dwqtsr_ljzc) cz_dwqtsr_ljzc,sum(cz_dwqtsr_ye) cz_dwqtsr_ye,sum(cz_dg_lnjy_ye)+sum(cz_dwwlzj_ye)+sum(cz_dwqtsr_ye) cz_dgzj_yehj"+ " from ("+  //预算内支出本月  " select gbdm, sum(ncye) + sum(fs) as cz_ysnzjzc_by, 0 cz_ysnzjzc_lj, 0 cz_xzsyxsr_by, 0 cz_xzsyxsr_bn, 0 cz_xzsyxsr_lj, 0 cz_wlzj_ye, 0 cz_dg_lnjy_ncs, 0 cz_dg_lnjy_lj, 0 cz_dg_lnjy_ye, 0 cz_dwwlzj_ncs, 0 cz_dwwlzj_ljsr, 0 cz_dwwlzj_ljzc, 0 cz_dwwlzj_ye, 0 cz_dwqtsr_ncs, 0 cz_dwqtsr_ljsr, 0 cz_dwqtsr_ljzc, 0 cz_dwqtsr_ye  from (Select bmry as gbdm,   0 as ncye,   (sum(nvl(j, 0)) - sum(nvl(d, 0))) as fs From "+db+".v_zw_pzhz   where 5 || bmry = '50101'  and pzrq >= TO_DATE('"+date1+"', 'yyyy-MM-dd')  and pzrq <= TO_DATE('"+date2+"', 'yyyy-MM-dd')   group by bmry) aa group by gbdm"+  " union all"+  //预算内支出累计  " select gbdm, 0 cz_ysnzjzc_by, sum(ncye) + sum(fs) as cz_wlzj_jy, 0 cz_xzsyxsr_by, 0 cz_xzsyxsr_bn, 0 cz_xzsyxsr_lj, 0 cz_wlzj_ye, 0 cz_dg_lnjy_ncs, 0 cz_dg_lnjy_lj, 0 cz_dg_lnjy_ye, 0 cz_dwwlzj_ncs, 0 cz_dwwlzj_ljsr, 0 cz_dwwlzj_ljzc, 0 cz_dwwlzj_ye, 0 cz_dwqtsr_ncs, 0 cz_dwqtsr_ljsr, 0 cz_dwqtsr_ljzc, 0 cz_dwqtsr_ye  from (Select bmry as gbdm,   0 as ncye,   (sum(nvl(j, 0)) - sum(nvl(d, 0))) as fs From "+db+".v_zw_pzhz   where 5 || bmry = '50101'  and pzrq <= TO_DATE('"+date2+"', 'yyyy-MM-dd')   group by bmry) aa group by gbdm"+  " union all"+  //非税收入本  " select gbdm, 0 cz_ysnzjzc_by, 0 cz_ysnzjzc_lj, sum(ncye) + sum(fs) as cz_xzsyxsr_by, 0 cz_xzsyxsr_bn, 0 cz_xzsyxsr_lj, 0 cz_wlzj_ye, 0 cz_dg_lnjy_ncs, 0 cz_dg_lnjy_lj, 0 cz_dg_lnjy_ye, 0 cz_dwwlzj_ncs, 0 cz_dwwlzj_ljsr, 0 cz_dwwlzj_ljzc, 0 cz_dwwlzj_ye, 0 cz_dwqtsr_ncs, 0 cz_dwqtsr_ljsr, 0 cz_dwqtsr_ljzc, 0 cz_dwqtsr_ye  from (Select bmry as gbdm,   0 as ncye,   (sum(nvl(d, 0)) - sum(nvl(j, 0))) as fs From "+db2+".v_zw_pzhz   where kmdm = '2015019913'  and bmry = '50109'  and pzrq >= TO_DATE('"+date1+"', 'yyyy-MM-dd')  and pzrq <= TO_DATE('"+date2+"', 'yyyy-MM-dd')   group by bmry) aa group by gbdm"+  " union all"+  //非税收入本年  " select gbdm, 0 cz_ysnzjzc_by, 0 cz_ysnzjzc_lj, 0 cz_xzsyxsr_by, sum(ncye) + sum(fs) as cz_xzsyxsr_bn, 0 cz_xzsyxsr_lj, 0 cz_wlzj_ye, 0 cz_dg_lnjy_ncs, 0 cz_dg_lnjy_lj, 0 cz_dg_lnjy_ye, 0 cz_dwwlzj_ncs, 0 cz_dwwlzj_ljsr, 0 cz_dwwlzj_ljzc, 0 cz_dwwlzj_ye, 0 cz_dwqtsr_ncs, 0 cz_dwqtsr_ljsr, 0 cz_dwqtsr_ljzc, 0 cz_dwqtsr_ye  from (Select bmry as gbdm,   0 as ncye,   (sum(nvl(d, 0)) - sum(nvl(j, 0))) as fs From "+db2+".v_zw_pzhz   where kmdm = '2015019913'  and bmry = '50109'  and pzrq <= TO_DATE('"+date2+"', 'yyyy-MM-dd')   group by bmry) aa group by gbdm"+  " union all"+  //非税收入累计  " select gbdm, 0 cz_ysnzjzc_by, 0 cz_ysnzjzc_lj, 0 cz_xzsyxsr_by, 0 cz_xzsyxsr_bn, sum(ncye) + sum(fs) as cz_xzsyxsr_lj, 0 cz_wlzj_ye, 0 cz_dg_lnjy_ncs, 0 cz_dg_lnjy_lj, 0 cz_dg_lnjy_ye, 0 cz_dwwlzj_ncs, 0 cz_dwwlzj_ljsr, 0 cz_dwwlzj_ljzc, 0 cz_dwwlzj_ye, 0 cz_dwqtsr_ncs, 0 cz_dwqtsr_ljsr, 0 cz_dwqtsr_ljzc, 0 cz_dwqtsr_ye  from (Select dm as gbdm, nvl(ncye, 0) as ncye, 0 as fs From "+db2+".bmhz   where kmdm = '2015019913'  and dm = '50109'  union all  Select bmry as gbdm,   0 as ncye,   (sum(nvl(d, 0)) - sum(nvl(j, 0))) as fs From "+db2+".v_zw_pzhz   where kmdm = '2015019913'  and bmry = '50109'  and pzrq <= To_Date('"+date2+"', 'yyyy-MM-dd')   group by bmry) aa group by gbdm"+  " union all"+  //-往来资金年初余额  " Select dm as gbdm, 0 cz_ysnzjzc_by, 0 cz_ysnzjzc_lj, 0 cz_xzsyxsr_by, 0 cz_xzsyxsr_bn, 0 cz_xzsyxsr_lj, 0 cz_wlzj_ye, nvl(ncye, 0) as cz_dg_lnjy_ncs, 0 cz_dg_lnjy_lj, 0 cz_dg_lnjy_ye, 0 cz_dwwlzj_ncs, 0 cz_dwwlzj_ljsr, 0 cz_dwwlzj_ljzc, 0 cz_dwwlzj_ye, 0 cz_dwqtsr_ncs, 0 cz_dwqtsr_ljsr, 0 cz_dwqtsr_ljzc, 0 cz_dwqtsr_ye  From "+db2+".bmhz where kmdm = '20150402'   and dm = '50109'"+  " union all"+  //-10往来资金累计收入  " Select bmry as gbdm, 0 cz_ysnzjzc_by, 0 cz_ysnzjzc_lj, 0 cz_xzsyxsr_by, 0 cz_xzsyxsr_bn, 0 cz_xzsyxsr_lj, 0 cz_wlzj_ye, 0 cz_dg_lnjy_ncs, sum(nvl(d, 0)) as cz_dg_lnjy_lj, 0 cz_dg_lnjy_ye, 0 cz_dwwlzj_ncs, 0 cz_dwwlzj_ljsr, 0 cz_dwwlzj_ljzc, 0 cz_dwwlzj_ye, 0 cz_dwqtsr_ncs, 0 cz_dwqtsr_ljsr, 0 cz_dwqtsr_ljzc, 0 cz_dwqtsr_ye  From "+db2+".v_zw_pzhz where kmdm = '20150402'   and bmry = '50109'   and pzrq <= TO_DATE('"+date2+"', 'yyyy-MM-dd') group by bmry"+  " union all"+  //-11往来资金累计支出  " Select bmry as gbdm, 0 cz_ysnzjzc_by, 0 cz_ysnzjzc_lj, 0 cz_xzsyxsr_by, 0 cz_xzsyxsr_bn, 0 cz_xzsyxsr_lj, 0 cz_wlzj_ye, 0 cz_dg_lnjy_ncs, 0 cz_dg_lnjy_lj, sum(nvl(j, 0)) as cz_dg_lnjy_ye, 0 cz_dwwlzj_ncs, 0 cz_dwwlzj_ljsr, 0 cz_dwwlzj_ljzc, 0 cz_dwwlzj_ye, 0 cz_dwqtsr_ncs, 0 cz_dwqtsr_ljsr, 0 cz_dwqtsr_ljzc, 0 cz_dwqtsr_ye  From "+db2+".v_zw_pzhz where kmdm = '20150402'   and bmry = '50109'   and pzrq <= TO_DATE('"+date2+"', 'yyyy-MM-dd') group by bmry"+  " union all"+  //-12往来资金期末余额  " select gbdm, 0 cz_ysnzjzc_by, 0 cz_ysnzjzc_lj, 0 cz_xzsyxsr_by, 0 cz_xzsyxsr_bn, 0 cz_xzsyxsr_lj, 0 cz_wlzj_ye, 0 cz_dg_lnjy_ncs, 0 cz_dg_lnjy_lj, 0 cz_dg_lnjy_ye, 0 cz_dwwlzj_ncs, 0 cz_dwwlzj_ljsr, 0 cz_dwwlzj_ljzc, sum(ncye)+sum(fs) as cz_dwwlzj_ye, 0 cz_dwqtsr_ncs, 0 cz_dwqtsr_ljsr, 0 cz_dwqtsr_ljzc, 0 cz_dwqtsr_ye  from (Select dm as gbdm, nvl(ncye, 0) as ncye, 0 as fs From "+db2+".bmhz   where kmdm = '20150402'  and dm = '50109'  union all  Select bmry as gbdm,   0 as ncye,   (sum(nvl(d, 0)) - sum(nvl(j, 0))) as fs From "+db2+".v_zw_pzhz   where kmdm = '20150402'  and bmry = '50109'  and pzrq <= TO_DATE('"+date2+"', 'yyyy-MM-dd')   group by bmry) aa group by gbdm"+  " union all"+  //-13其他收入年初余额  " Select dm as gbdm, 0 cz_ysnzjzc_by, 0 cz_ysnzjzc_lj, 0 cz_xzsyxsr_by, 0 cz_xzsyxsr_bn, 0 cz_xzsyxsr_lj, 0 cz_wlzj_ye, 0 cz_dg_lnjy_ncs, 0 cz_dg_lnjy_lj, 0 cz_dg_lnjy_ye, 0 cz_dwwlzj_ncs, 0 cz_dwwlzj_ljsr, 0 cz_dwwlzj_ljzc, 0 cz_dwwlzj_ye, nvl(ncye, 0) as cz_dwqtsr_ncs, 0 cz_dwqtsr_ljsr, 0 cz_dwqtsr_ljzc, 0 cz_dwqtsr_ye  From "+db2+".bmhz where kmdm = '20150409'   and dm = '50109'"+  " union all"+  //-14其他收入累计收入  " Select bmry as gbdm, 0 cz_ysnzjzc_by, 0 cz_ysnzjzc_lj, 0 cz_xzsyxsr_by, 0 cz_xzsyxsr_bn, 0 cz_xzsyxsr_lj, 0 cz_wlzj_ye, 0 cz_dg_lnjy_ncs, 0 cz_dg_lnjy_lj, 0 cz_dg_lnjy_ye, 0 cz_dwwlzj_ncs, 0 cz_dwwlzj_ljsr, 0 cz_dwwlzj_ljzc, 0 cz_dwwlzj_ye, 0 cz_dwqtsr_ncs, sum(nvl(d, 0)) as cz_dwqtsr_ljsr, 0 cz_dwqtsr_ljzc, 0 cz_dwqtsr_ye  From "+db2+".v_zw_pzhz where kmdm = '20150409'   and bmry = '50109'   and pzrq <= TO_DATE('"+date2+"', 'yyyy-MM-dd') group by bmry"+  " union all"+  //-15其他收入累计支出  " Select bmry as gbdm, 0 cz_ysnzjzc_by, 0 cz_ysnzjzc_lj, 0 cz_xzsyxsr_by, 0 cz_xzsyxsr_bn, 0 cz_xzsyxsr_lj, 0 cz_wlzj_ye, 0 cz_dg_lnjy_ncs, 0 cz_dg_lnjy_lj, 0 cz_dg_lnjy_ye, 0 cz_dwwlzj_ncs, 0 cz_dwwlzj_ljsr, 0 cz_dwwlzj_ljzc, 0 cz_dwwlzj_ye, 0 cz_dwqtsr_ncs, 0 cz_dwqtsr_ljsr, sum(nvl(j, 0)) as cz_dwqtsr_ljzc, 0 cz_dwqtsr_ye  From "+db2+".v_zw_pzhz where kmdm = '20150409'   and bmry = '50109'   and pzrq <= TO_DATE('"+date2+"', 'yyyy-MM-dd') group by bmry"+  " union all"+  //-16其他收入期末余额  " select gbdm, 0 cz_ysnzjzc_by, 0 cz_ysnzjzc_lj, 0 cz_xzsyxsr_by, 0 cz_xzsyxsr_bn, 0 cz_xzsyxsr_lj, 0 cz_wlzj_ye, 0 cz_dg_lnjy_ncs, 0 cz_dg_lnjy_lj, 0 cz_dg_lnjy_ye, 0 cz_dwwlzj_ncs, 0 cz_dwwlzj_ljsr, 0 cz_dwwlzj_ljzc, 0 cz_dwwlzj_ye, 0 cz_dwqtsr_ncs, 0 cz_dwqtsr_ljsr, 0 cz_dwqtsr_ljzc, sum(ncye) + sum(fs) as cz_dwqtsr_ye  from (Select dm as gbdm, nvl(ncye, 0) as ncye, 0 as fs From "+db2+".bmhz   where kmdm = '20150409'  and dm = '50109'  union all  Select bmry as gbdm,   0 as ncye,   (sum(nvl(d, 0)) - sum(nvl(j, 0))) as fs From "+db2+".v_zw_pzhz   where kmdm = '20150409'  and bmry = '50109'  and pzrq <= TO_DATE('"+date2+"', 'yyyy-MM-dd')   group by bmry) aa group by gbdm"+  " union all"+  //-17往来资金余额  " select gbdm, 0 cz_ysnzjzc_by, 0 cz_ysnzjzc_lj, 0 cz_xzsyxsr_by, 0 cz_xzsyxsr_bn, 0 cz_xzsyxsr_lj, sum(ncye) + sum(fs) as cz_wlzj_ye, 0 cz_dg_lnjy_ncs, 0 cz_dg_lnjy_lj, 0 cz_dg_lnjy_ye, 0 cz_dwwlzj_ncs, 0 cz_dwwlzj_ljsr, 0 cz_dwwlzj_ljzc, 0 cz_dwwlzj_ye, 0 cz_dwqtsr_ncs, 0 cz_dwqtsr_ljsr, 0 cz_dwqtsr_ljzc, 0 cz_dwqtsr_ye  from (Select dm as gbdm, nvl(ncye, 0) as ncye, 0 as fs From "+db2+".bmhz   where kmdm = '20150302'  and dm = '50109'  union all  Select bmry as gbdm,   0 as ncye,   (sum(nvl(d, 0)) - sum(nvl(j, 0))) as fs From "+db2+".v_zw_pzhz   where kmdm = '20150302'  and bmry = '50109'  and pzrq <= TO_DATE('"+date2+"', 'yyyy-MM-dd')   group by bmry) aa group by gbdm"+" ) a " ; }    odbcrs = odbcstmt.executeQuery(sql);    strBuffer.append("CZ_YSNZJZC_BY").append("\t")             .append("CZ_YSNZJZC_LJ").append("\t")             .append("CZ_XZSYXSR_BY").append("\t")             .append("CZ_XZSYXSR_BN").append("\t")             .append("CZ_XZSYXSR_LJ").append("\t")             .append("CZ_WLZJ_YE").append("\t")             .append("CZ_DG_LNJY_NCS").append("\t")             .append("CZ_DG_LNJY_LJ").append("\t")             .append("CZ_DG_LNJY_YE").append("\t")             .append("CZ_DWWLZJ_NCS").append("\t")             .append("CZ_DWWLZJ_LJSR").append("\t")             .append("CZ_DWWLZJ_LJZC").append("\t")             .append("CZ_DWWLZJ_YE").append("\t")             .append("CZ_DWQTSR_NCS").append("\t")             .append("CZ_DWQTSR_LJSR").append("\t")             .append("CZ_DWQTSR_LJZC").append("\t")             .append("CZ_DWQTSR_YE").append("\t")             .append("CZ_DGZJ_YEHJ").append("\t")                          .append("DW_CZBZSR_BY").append("\t")             .append("DW_CZBZSR_LJ").append("\t")             .append("DW_XZSYXSR_BY").append("\t")             .append("DW_XZSYXSR_BN").append("\t")             .append("DW_XZSYXSR_LJ").append("\t")             .append("DW_WLZJ_YE").append("\t")             .append("DW_DNLJKPJE").append("\t")             .append("DW_ZM_LNJY_NCS").append("\t")             .append("DW_ZM_LNJY_LJ").append("\t")             .append("DW_ZM_LNJY_YE").append("\t")             .append("DW_ZM_WLZJ_NCS").append("\t")             .append("DW_ZM_WLZJ_LJSR").append("\t")             .append("DW_ZM_WLZJ_LJZC").append("\t")             .append("DW_ZM_WLZJ_YE").append("\t")             .append("DW_ZM_QTSR_NCS").append("\t")             .append("DW_ZM_QTSR_LJSR").append("\t")             .append("DW_ZM_QTSR_LJZC").append("\t")             .append("DW_ZM_QTSR_YE").append("\t")             .append("DW_DGZJ_YEHJ").append("\n");    while (odbcrs.next()){          strBuffer.append(odbcrs.getString("CZ_YSNZJZC_BY")).append("\t")                   .append(odbcrs.getString("CZ_YSNZJZC_LJ")).append("\t")                   .append(odbcrs.getString("CZ_XZSYXSR_BY")).append("\t")                   .append(odbcrs.getString("CZ_XZSYXSR_BN")).append("\t")                   .append(odbcrs.getString("CZ_XZSYXSR_LJ")).append("\t")                   .append(odbcrs.getString("CZ_WLZJ_YE")).append("\t")                   .append(odbcrs.getString("CZ_DG_LNJY_NCS")).append("\t")                   .append(odbcrs.getString("CZ_DG_LNJY_LJ")).append("\t")                   .append(odbcrs.getString("CZ_DG_LNJY_YE")).append("\t")                   .append(odbcrs.getString("CZ_DWWLZJ_NCS")).append("\t")                   .append(odbcrs.getString("CZ_DWWLZJ_LJSR")).append("\t")                   .append(odbcrs.getString("CZ_DWWLZJ_LJZC")).append("\t")                   .append(odbcrs.getString("CZ_DWWLZJ_YE")).append("\t")                   .append(odbcrs.getString("CZ_DWQTSR_NCS")).append("\t")                   .append(odbcrs.getString("CZ_DWQTSR_LJSR")).append("\t")                   .append(odbcrs.getString("CZ_DWQTSR_LJZC")).append("\t")                   .append(odbcrs.getString("CZ_DWQTSR_YE")).append("\t")                   .append(odbcrs.getString("CZ_DGZJ_YEHJ")).append("\t")                                      .append(odbcrs.getString("DW_CZBZSR_BY")).append("\t")                   .append(odbcrs.getString("DW_CZBZSR_LJ")).append("\t")                   .append(odbcrs.getString("DW_XZSYXSR_BY")).append("\t")                   .append(odbcrs.getString("DW_XZSYXSR_BN")).append("\t")                   .append(odbcrs.getString("DW_XZSYXSR_LJ")).append("\t")                   .append(odbcrs.getString("DW_WLZJ_YE")).append("\t")                   .append(odbcrs.getString("DW_DNLJKPJE")).append("\t")                   .append(odbcrs.getString("DW_ZM_LNJY_NCS")).append("\t")                   .append(odbcrs.getString("DW_ZM_LNJY_LJ")).append("\t")                   .append(odbcrs.getString("DW_ZM_LNJY_YE")).append("\t")                   .append(odbcrs.getString("DW_ZM_WLZJ_NCS")).append("\t")                   .append(odbcrs.getString("DW_ZM_WLZJ_LJSR")).append("\t")                   .append(odbcrs.getString("DW_ZM_WLZJ_LJZC")).append("\t")                   .append(odbcrs.getString("DW_ZM_WLZJ_YE")).append("\t")                   .append(odbcrs.getString("DW_ZM_QTSR_NCS")).append("\t")                   .append(odbcrs.getString("DW_ZM_QTSR_LJSR")).append("\t")                   .append(odbcrs.getString("DW_ZM_QTSR_LJZC")).append("\t")                   .append(odbcrs.getString("DW_ZM_QTSR_YE")).append("\t")                   .append(odbcrs.getString("DW_DGZJ_YEHJ")).append("\n");    }    out.print(strBuffer.toString());    odbcrs.close();     odbcstmt.close();    odbcconn.close();}catch (SQLException e){    System.out.println (e);}%>

最后还要安装软件，名字叫做：ChinaExcel develop studio

tab/dzMgr_print.tab