| |
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(); }}
|
|