急，高手救命！getOutputStream() Exception （第二次发帖）

把 <html>
<head>
<title>
enabling entry fields
</title>
</head>
等信息去掉就可以了

解决方案 »

  1.   

    现在奇怪的是，这样都不行！
    <%@ page contentType="text/html; charset=GBK" language="java" import="java.sql.*,java.io.OutputStream,java.io.File,java.io.FileOutputStream" errorPage="" %>
    <jsp:useBean id="Excel" scope="session" class="college.Excel"/>
    <jsp:useBean id="EditCon" scope="session" class="college.Contracts"/>
    <%
      response.reset();
      response.setContentType("application/vnd.ms-excel");
      Excel.nqhmc(response.getOutputStream());
    %>
    ………………………………………Excel.nqhmc(OutputStream os)………………………………
        public boolean nqhmc(OutputStream os){
            ResultSet rsSql = null;
            boolean bResult = false;
            Connection myConn = this.getdbConn();
            try{
                jxl.write.WritableWorkbook wwb = Workbook.createWorkbook(os);
                jxl.write.WritableSheet ws = wwb.createSheet("人员花名册",0);
                String sSql = "SELECT * FROM table WHERE ((ID='') or (ID is null))";
                Statement stSql = myConn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
                rsSql = stSql.executeQuery(sSql);
                //获取记录总数
                rsSql.last();
                int intRowCount = rsSql.getRow();
                ResultSetMetaData rmeta = rsSql.getMetaData();
                //获得数据字段个数
                int numColumns = rmeta.getColumnCount();
                for(int i=1; i<intRowCount; i++){                for(int j=0; j+1<numColumns; j++){
                        String str = rsSql.getString(j+1);
                        jxl.write.WritableCell label = new Label(j,i,str);
                        ws.addCell(label);
                        rsSql.next();
                    }            }
                wwb.write();
                wwb.close();
                bResult = true;
            }catch(Exception e){
                this.dbException = e.toString();
                bResult = false;
            }
            return bResult;
        }
      

  2.   

    把 
    <jsp:useBean id="Excel" scope="session" class="college.Excel"/>
    <jsp:useBean id="EditCon" scope="session" class="college.Contracts"/>
    去掉
    看看下面的<%@ page contentType="text/html; charset=GBK" %>
    <%@ page import = "java.io.*"%>
    <%@ page import = "com.elink.hr.bean.*"%>
    <%@ page import = "com.elink.database.*"%>
    <%
    // from www.elingke.com 
    String downtype = request.getParameter("downtype");
        String downid = request.getParameter("downid");
        DocumentBean docs = new DocumentBean();
        CachedRowSet crs = docs.getDocument( downid );
        if( crs!=null && crs.next() )
        {
         String docuri = crs.getString( "docuri" );
         String filename = docuri;
         int p1 = filename.lastIndexOf(".");
         String file_name = filename.substring(p1);
         filename = filename.substring(0,p1);
         p1 = filename.lastIndexOf(File.separator);
         filename = filename.substring(p1);
         p1 = filename.indexOf(".");
         int p2 = filename.indexOf(".", p1+1);
         file_name = filename.substring(p1+1, p2)+file_name; response.setContentType("application/octet-stream");
    response.setHeader("Content-Disposition","attachment; filename=" + java.net.URLEncoder.encode(file_name, "UTF-8") );
    try
    {
            FileInputStream stream = new FileInputStream(docuri);
            OutputStream sout = response.getOutputStream();
    int iRead = stream.read();
    while ( iRead != -1)
    {
    sout.write( iRead );
    iRead = stream.read();
    }
    sout.flush();
    }
    catch( Exception e )
    {
    e.printStackTrace();
    }
    }
    else
    {
    response.sendRedirect( "error.bo?errno=90104" );
    }
    %>
      

  3.   

    这里把我弄晕了：
    filename = filename.substring(0,p1);
         p1 = filename.lastIndexOf(File.separator);
         filename = filename.substring(p1);
         p1 = filename.indexOf(".");
         int p2 = filename.indexOf(".", p1+1);
         file_name = filename.substring(p1+1, p2)+file_name;
    这里又是什么意思：
    response.setContentType("application/octet-stream");
    response.setHeader("Content-Disposition","attachment; filename=" + java.net.URLEncoder.encode(file_name, "UTF-8") );
    小弟刚学jsp，还请netcom19(netcom)兄不吝赐教！