JSP页面上数据导成EXCEL！急，跟普通的不太一样请认真看！

ysgzlcx_Main.htm---- <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Frameset//EN" "http://www.w3.org/TR/html4/frameset.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title> </title>
</head>
<frameset rows="60,*" frameborder="0" border="0" framespacing="0">
   <frame src="../../zhcx/ysgzlcx/ysgzlcx_Top.jsp" name="topFrame" scrolling="NO" noresize >
   <frame src="../../zhcx/ysgzlcx/ysgzlcx_Bottom.jsp" name="middleFrame">
   <noframes>
   <body>
</body>
   </noframes>
</frameset>
<frameset>
</frameset>
</frameset>
</html>

解决方案 »

免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货

ysgzlcx_Top.jsp--    <%@ page contentType="text/html; charset=GBK" %>
<%
DBOperate db=new DBOperate();
CachedRowSet brlx=null;
brlx=db.getCachedRowSet("select distinct patitypename,patitypecode from dictpatitype");
  UserInfoBean UserInfoB=(UserInfoBean)session.getAttribute("user");
Log log=new Log();
if(UserInfoB!=null) log.log(Log.ERROR,"UserInfoB is not null ");
String id = request.getParameter("id");
int nextRS = 1;
if (id != null)
   nextRS = Integer.parseInt(id) + 1;
TyCalendar date=new TyCalendar();
log.log(Log.ERROR,date.getDate());
int i=0;
%>
<html>

<head>
<script type="text/javascript" src="../../js/function.js"> </script>
<script language="javascript"> function saveasExcel(){

     //parent.middleFrame.location="Report_Excel.jsp";
     window.open("Save_Excel.jsp");
} //日历控件
function Calendar(date) {
  var sReturn=window.showModalDialog("../../calendar/calendar.html",'null','dialogHeight:210px;dialogWidth:250px;status:no;help:no;');
  if(sReturn!="") {
    document.all[date].value=sReturn;
  }
} function display(){
if(window.dividtest!=null){
window.dividtest.style.display="";
}
} function diagnosisCount() {
     form1.target="middleFrame"
  form1.action="../../zhcx/ysgzlcx/YsgzlcxAction.do";
  form1.submit();
  //alert("aaaaa");
// window.dividtest.style.display="none";
  //alert("bbbbb");
}
var helpKey     =32;
function getFileCreatedTime(filespec){
   var fso, f, s ,t="",ForReading=1,ss="",sp;
   fso = new ActiveXObject("Scripting.FileSystemObject");
   if(fso.FileExists(filespec)){
    f = fso.GetFile(filespec);
    s = f.DateLastModified;
    var a=Date.parse(s);
        return(a);
   }else {
        return ('0');
   }
}
function splitStr(priceItem){
  var priceArray;
  priceArray=priceItem.split(";");
  return priceArray;
}
function openZd(){
  //if(event.keyCode==helpKey ){
   //document.form1.param2.value=getFileCreatedTime('C:\\diagnosis_dict.txt');
   var url="../../xtwh/diagnosis/SearchDiagnosis-Index.jsp";//'codingServlet_zd?param1=2&param2='+document.form1.param2.value;
   //返回选定的项
  var sReturn=window.showModalDialog(url,"","dialogHeight:600px;dialogWidth:800px;center:yes;help:no;scroll:no;resizable:yes;status:no");
  // var sReturn = window.open(url);
   //把返回的字符串转为数组
   if(sReturn!=null&&sReturn!=""){
       var aa=splitStr(sReturn);
       if(aa!=null){
          document.form1.DIAGNOSIS.value=javatrim(aa[1]);//名称
          document.form1.diagnosisname.value=aa[0];
          //alert(document.form1.DIAGNOSIS.value);
      }
   }
  //}
}
</script> <link href="../../css/xin.css" rel="stylesheet" type="text/css"> <meta http-equiv="Content-Type" content="text/html; charset=GBK">
<title> 十分上 </title>
<link href="../../css/cb2.css" rel="stylesheet" type="text/css">
</head> <body leftmargin="0" topmargin="2" onselectstart="return false" ondragstart="return false" oncontextmenu="return false">

<form name="form1" method="post" action="../../zhcx/ysgzlcx/Ysgzlcx_Action" target="middleFrame">
   <input type="hidden" name="param2" value="">
   <input type="hidden" name="diagnosisname">
<table width="100%"  border="0" align="center" cellpadding="0" cellspacing="0">
   <tr>
     <td> <table width="100%"  border="0" align="center" cellpadding="0" cellspacing="0">
         <tr>
           <td> <table width="100%"  border="0" cellspacing="0" cellpadding="0">
             <tr>
               <td width="9%" valign="baseline"> <img src="../../images/xin_an_jq_1.gif" name="Image2" width="83" height="23" border="0" id="Image2"> </td>
               <td width="13%" valign="baseline"> </td>
               <td width="78%" valign="baseline"> <table width="50%"  border="0" align="right" cellpadding="0" cellspacing="0">
                 <tr>
                   <td width="4%"> <div align="center"> <img src="../../images/xin_ico_cx.gif" width="20" height="20"> </div> </td>
                   <td width="10%" nowrap onClick="return diagnosisCount();"  style="CURSOR: hand;"> <span class="maintext2"> 查询 </span> </td>

                   <td width="4%"> <div align="center"> <img src="../../images/xin_ico_dc.gif" width="20" height="20"> </div> </td>
                   <td width="15%" nowrap onClick="saveasExcel();"  style="CURSOR: hand;"> <span class="maintext2"> 导出Excel </span> </td>
                 </tr>
               </table> </td>
             </tr>
           </table> </td>
         </tr>
         <tr>
           <td> <table width="100%"  border="0" cellpadding="0" cellspacing="0" bgcolor="666666">
             <tr>
               <td width="70%" height="30" nowrap bgcolor="#FFFFFF" class="TDtwo"> <table width="100%"  border="0" cellspacing="0" cellpadding="0">
                 <tr>
                         <td width="4%">       </td>
                         <td width="10%">

                        <div align="left">
                        <select name="Selcxfw">
                          <option value="0"> 123 </option>
                          <option value="1"> 456 </option>
                          <option value="2"> 789 </option>
                          </select>
                           </div> </td>
                 <td width="14%">

                        <div align="left">
                       <select name="Selbrlx">
                         <option value="0"> 所有类型 </option>
                         <%
                      if(brlx!=null){
                        while(brlx.next()){
                     %>
                         <option value= <%="'"+Integer.toString(brlx.getInt("patitypecode"))+"'"%> > <%=brlx.getString("patitypename")%> </option>
                         <%

                        }
    brlx.close();
                      }
                      %>
                          </select>
                           </div> </td>


                 <td width="14%">
                 <select name="selksxm">
                 <option value="1"> 按二级所属科室 </option>
                 <option value="2"> 按二级核算科室 </option>
                 <option value="3"> 按三级所属科室 </option>
                 <option value="4"> 按三级核算科室 </option>
                 </select>                  </td>                  <td width="5%"> 日期: </td>
             <td width="12%">
               <input name="startdate" type="text" size="10" maxlength="10">
               <img src="../../images/xin_ico_3.gif" width="16" height="15" style="cursor: hand;" onClick="Calendar('startdate');return false;">              </td>
            <td width="2%"> 至 </td>
            <td width="15%">
               <div align="left">
                 <input name="enddate" type="text" size="10" maxlength="10">
                 <img src="../../images/xin_ico_3.gif" width="16" height="15" style="cursor: hand;" onClick="Calendar('enddate');return false;"> </div> </td>
                 </tr>
               </table> </td>
             </tr>
           </table> </td>
         </tr>
     </table> </td>
   </tr>
</table>
</form>
</body>
</html>
<script type="text/javascript" src="../../js/date.js"> </script>
<script  language="JavaScript">
  document.form1.startdate.value=getMonthBeginDate();
  document.form1.enddate.value=getCurrDate();
</script>
ysgzlcx_Bottom.jsp--
<%@ page contentType="text/html; charset=GBK" %>
<%@ page import="sun.jdbc.rowset.CachedRowSet,java.util.Date,java.text.*"%>
<%@ page import="hzyl.util.com.*"%>
<jsp:useBean id="sqlDateFormat" scope="page" class="hzyl.util.com.SqlDateFormat" />
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title> 按时发生 </title>
</head> <%
UserInfoBean UIB=(UserInfoBean)session.getAttribute("user");
String operator = UIB.getUserName().toString();
String dept = new AreaConvert().HospitalCodeToChar(UIB.getUniCode().toString());
session.setAttribute("operator",operator);
session.setAttribute("dept",dept);
if(operator==null){
System.out.println("------------operator");}
if(dept==null){
System.out.println("------------dept");}
DecimalFormat df=(DecimalFormat)DecimalFormat.getInstance();
df.applyPattern("###0.000");
//java.sql.Date d=sqlDateFormat.format(new Date());
CachedRowSet crs=(CachedRowSet)request.getAttribute("QYCX");
System.out.println("------------1");
CachedRowSet xmmc=(CachedRowSet)request.getAttribute("XMMX");
session.setAttribute("QYCX",crs);
session.setAttribute("XMMX",xmmc);
if(xmmc==null){
System.out.println("------------2");}
if(crs==null){
System.out.println("------------22");}
String flag="Excel";
if(crs==null){
  flag="";
  operator="____________";
}

int t=0;
int l=0;
int x=0;
double[] ll_hz=null;
  double[] ll_hz2=null;
    double ll_xjhz=0.00;
  double ll_xj=0.000;
  double ll_xjhz2=0.00;
String xx=null;
DecimalFormat ddf = new DecimalFormat("0.000");
ddf.applyPattern("###0.000");
System.out.println("------------3");
%> <script type="text/javascript" src="../../js/date.js"> </script>
<body bgcolor="#ffffff" leftmargin="0" topmargin="0">
<form name="qysrcxbottom" method="get">
<table width="100%" border="0" cellpadding="0" cellspacing="0" bordercolor="#ff0000">
   <tr>
     <th colspan="2" nowrap="true" align="left" class="STYLE1" id=bt> <P align="center"> <%=dept%> 医生工作量统计表 </P> </th>
   </tr>
   <tr>
     <td> 统计日期： <script language="javascript"> document.write(" "+getCurrDate()); </script> </td>
     <td> 统计人： <%=operator%> </td>
   </tr>
   <tr>
     <td colspan="2">
<table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#669999">

<tr>
<th nowrap="true">
<P align="center"> 科室   </P> </th>
                                     <th nowrap="true" align="center"> 医师 </th>
<%if(xmmc!=null){

                        while(xmmc.next()){
                        t++;
                          //  System.out.println("TTTTTTTTT:"+t);
                        %> <th width="60" nowrap="true" align="center">
<%=xmmc.getString(1)%> </th> <%
                        }
                         ll_hz= new double[t];
                          //    System.out.println("ll_hz------------:"+ll_hz[8]);
    }
                      %>
<th width="60" nowrap="true" align="center">
小计
</th> </tr> <%if(crs!=null){
            while(crs.next()){

            //System.out.println("x---------:"+x);
           //System.out.println("crs.getString(1):---:"+crs.getString(1));
           //System.out.println("xx________:"+xx);
           //System.out.println("再开始一次：");
         //   if(xx!=crs
          //  .getString(1).trim()&&xx!=null)
         //   {

            %>             
              <%
               //    for(int i=1;i <t+3;i++){
            //            if(i==1){%>

<%//}else if(i==2){%>
                        
<%
                        //   }else{
                     //      int y=0;
                       //    ll_hz2[y]=ll_hz2[y] + crs.getDouble(i);
        // y=y+1;

                        %>

<%//ll_xjhz2 =ll_xjhz2+ll_hz2[i-3];%>
<%
                                 //       }
                                //    }
                                 %>

    <%
                   //    ll_xj=0.000;
             //          xx=crs.getString(1).trim();
                       //x=0;
                       %>

             <%
            //}else{             %>
             
<tr>
<%
                   for(int i=1;i <t+3;i++){
                       if(i==1){
                       %>
                        <th width="100" nowrap="true" align="center"> <%=crs.getString(1)%> </th>
<%
}
                        else if(i==2){

                        %> <th width="100" nowrap="true" align="center"> <%=crs.getString(2)%> </th>

<%
                            }else{
                        ll_hz[l]=ll_hz[l] + crs.getDouble(i);
         l=l+1;
         ll_xj=ll_xj+crs.getDouble(i);
                        %> <td nowrap="true" align="center"> <%=crs.getDouble(i)%> </td>
<%

                                }

                           }
                        l=0;
                        %>
<td nowrap="true" width="60" align="center"> <%=ddf.format(ll_xj)%> </td>
</tr>     <%
                       ll_xj=0.000;
                       xx=crs.getString(1).trim();

                       x++;
                                //}
                               }
    }

                      %>

            
<tr>
<%
                   for(int i=1;i <t+2;i++){
                        if(i==1){%>
<th width="100" nowrap="true" align=center>
合计：
</th>
                                 <th width="100" nowrap="true" align="center"> 合计： </th>
<%
                                    }else{
                                 %> <td nowrap="true" align="center">
<%=ddf.format(ll_hz[i-2])%> </td>
<%ll_xjhz =ll_xjhz+ll_hz[i-2];%>
<%
                                        }
                                    }
                                    %>
<td align="left">
<%=ll_xjhz%> </td>
</tr>
</table> </td>
   </tr>

</table>
</form>
</BODY>
</HTML>
xml配置---- <action path="/zhcx/ysgzlcx/YsgzlcxAction" scope="request" type="zhcx.ysgzlcx.YsgzlcxAction" validate="true">
<forward name="bottom" path="/zhcx/ysgzlcx/ysgzlcx_Bottom.jsp" /> <forward name="error" path="/error/exception.jsp" />
</action>