try{         getdbconnection();         pstmt = conn.preparestatement(strsql);         ret = pstmt.executequery();         file tempfile=new file(filename);         try{         writableworkbook workbook = workbook.createworkbook(tempfile);         writablesheet sheet = workbook.createsheet("sheet1", 0);         label l=null;         jxl.write.number n=null;         jxl.write.datetime d=null;         writablefont headerfont = new writablefont(writablefont.arial,12,writablefont.bold,false, underlinestyle.no_underline,jxl.format.colour.blue);         writablecellformat headerformat = new writablecellformat (headerfont);

         writablefont titlefont = new writablefont(writablefont.arial,10,writablefont.no_bold,false, underlinestyle.no_underline,jxl.format.colour.red);         writablecellformat titleformat = new writablecellformat (titlefont);

         writablefont detfont = new writablefont(writablefont.arial,10,writablefont.no_bold,false, underlinestyle.no_underline,jxl.format.colour.black);         writablecellformat detformat = new writablecellformat (detfont);

         numberformat nf=new numberformat("0.00000");         writablecellformat priceformat = new writablecellformat (detfont, nf);

         dateformat df=new dateformat("yyyy-mm-dd");         writablecellformat dateformat = new writablecellformat (detfont, df);

         l=new label(2,0,"",headerformat);         sheet.addcell(l);         int inttitle = title.length;         for (int i=0;i<inttitle;i++)         {           l=new label(i,2,title[i], titleformat);           sheet.addcell(l);         }        int k = 0;        while(ret.next())                {                  k++;                  for (int j=1;j<inttitle;j++)                        {              l=new label(j-1,k+3,ret.getstring(j),detformat);              sheet.addcell(l);                          //sheet.setcolumnview(j,30);                        }                }         workbook.write();         workbook.close();         } catch(exception e){}    }   catch(sqlexception ae) {        throw new applicationexception("创建excel时查询数据库操作失败! " +             "错误信息:" +strsql + ",异常信息为 :/n" + ae.getmessage());     } finally {                closeresultset(ret);                closestatement(pstmt);                closeconnection();                   }}