java 对excel 文件操作的程序

package JExcelTest.standard; import java.io.File; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; import jxl.Workbook; import jxl.write.Label; import jxl.write.WritableSheet; import jxl.write.WritableWorkbook; public class WriteIntoXLS { /** * @param args */ public static void main(String[] args) { // TODO Auto-generated method stub try { Class.forName("oracle.jdbc.driver.OracleDriver").newInstance(); String url="jdbc:oracle:thin:@211.155.225.41:1521:oradb"; // orcl为数据库的SID String user="homeschool"; String password="ab7982oramygod"; Connection conn= DriverManager.getConnection(url,user,password); Statement stmt =conn.createStatement(); String sql1 ="select tss.ocode,tor.oname,tor.xocode,tss.xxtnum,tss.xxtnum||'|'||tss.mobilenum1||'|'||tss.mobilenum1||'|2|0' from homeschool060.tsstudent tss inner join homeschool060.torganize tor on tss.ocode=tor.ocode where tss.ocode||tss.clscode||tss.mobilenum1 in(select ocode||clscode||mobnum from AREADB.TB_DIRECT_ORDER where isdeal='0' and areadb.ismobilenumyd(mobnum)='1')and tss.ocode||tss.clscode in (select ocode||clscode from homeschool060.tsclass where iffinish='0' and to_number(to_char(entrtime,'yyyy'))+to_number(term)>2008) and tss.ifopen1 not in ('1','2')order by ocode,xxtnum"; //String sql2 ="select tss.ocode,tor.oname,tor.xocode,tss.xxtnum,tss.xxtnum||'|'||tss.mobilenum2||'|'||tss.mobilenum2||'|2|0' from homeschool060.tsstudent tss inner join homeschool060.torganize tor on tss.ocode=tor.ocode where tss.ocode||tss.clscode||tss.mobilenum2 in(select ocode||clscode||mobnum from AREADB.TB_DIRECT_ORDER where isdeal='0' and areadb.ismobilenumyd(mobnum)='1')and tss.ocode||tss.clscode in (select ocode||clscode from homeschool060.tsclass where iffinish='0' and to_number(to_char(entrtime,'yyyy'))+to_number(term)>2008) and tss.ifopen2 not in ('1','2')order by ocode,xxtnum"; ResultSet rs1 = stmt.executeQuery(sql1); WritableWorkbook book = Workbook.createWorkbook(new File("e:/Test2.xls")); WritableSheet sheet = book.createSheet("Sheet_1", 0); int p=0; int i=0; int j=0; for (int k = 0; k < rs1.getMetaData().getColumnCount(); k++) { sheet.addCell(new Label(k,0,rs1.getMetaData().getColumnName(k+1))); } while(rs1.next()) { System.out.println(rs1.getMetaData().getColumnCount()); p++; for (int k = 0; k < rs1.getMetaData().getColumnCount(); k++) { sheet.addCell(new Label(k,j+i+1,rs1.getString(k+1))); } i++; } //------------------------------------------- String sql2 ="select tss.ocode,tor.oname,tor.xocode,tss.xxtnum,tss.xxtnum||'|'||tss.mobilenum2||'|'||tss.mobilenum2||'|2|0' from homeschool060.tsstudent tss inner join homeschool060.torganize tor on tss.ocode=tor.ocode where tss.ocode||tss.clscode||tss.mobilenum2 in(select ocode||clscode||mobnum from AREADB.TB_DIRECT_ORDER where isdeal='0' and areadb.ismobilenumyd(mobnum)='1')and tss.ocode||tss.clscode in (select ocode||clscode from homeschool060.tsclass where iffinish='0' and to_number(to_char(entrtime,'yyyy'))+to_number(term)>2008) and tss.ifopen2 not in ('1','2')order by ocode,xxtnum"; ResultSet rs2 = stmt.executeQuery(sql2); int m=0; int n=0; for (int k = 0; k < rs2.getMetaData().getColumnCount(); k++) { while (rs1.next()) { sheet.addCell(new Label(k,m+n+p,rs2.getMetaData().getColumnName(k+1))); } } while(rs2.next()) { System.out.println(rs2.getMetaData().getColumnCount()); for (int k = 0; k < rs2.getMetaData().getColumnCount(); k++) { sheet.addCell(new Label(k,m+n+p,rs2.getString(k+1))); } m++; } //------------------------------------------- book.write(); book.close(); rs1.close(); rs2.close(); conn.close(); } catch(Exception e) { e.printStackTrace(); } } }