下载文件代码

 

         if(request.getParameter("table")!=null&&request.getParameter("where")!=null)
         {
             String t_table=request.getParameter("table");
             String t_where=request.getParameter("where");
             System.out.println(t_where);
            Result count_rs=db.sqlQuery("SELECT BLOB_CONTENT,MIME_TYPE FROM " + t_table + " where " + t_where);
            if(count_rs.next())
            {
                if(count_rs.getBytes("BLOB_CONTENT")!=null)
                {
                    ServletOutputStream ou=response.getOutputStream();
                    response.reset();    
                    response.setContentType(count_rs.getString("MIME_TYPE"));
                    byte[]  b  =  new  byte[1024];    
                    ou.write(count_rs.getBytes("BLOB_CONTENT"));  
                    ou.close();
                }
                else
                {
                    out.print("对不起!没有您所需要的资料!");   
                }
            }
            else
            {
                out.print("对不起!没有您所需要的资料!");
            }
        }