設計&程式

java excel

public void testwrite(){
try{
pool.getConnectionPool("WMS");
pool.getResult("select * from tbllocation"); // resultset
StringBuffer contenu = new StringBuffer("");

pool.md = pool.rst.getMetaData();
for(int i = 1; i<=pool.md.getColumnCount(); i++){
contenu.append(pool.md.getColumnLabel(i)+"\t");
}
contenu.append("\n");
pool.rst.beforeFirst();
while(pool.rst.next()){
for(int i = 1; i<=pool.md.getColumnCount(); i++){
contenu.append(pool.rst.getString(i)+"\t");
}
contenu.append("\n");
} //end while

FileWriter excelFile = new FileWriter("myResultSet.xls");
excelFile.write(new String(contenu));
excelFile.close();
}catch(IOException e){
System.out.println(e.toString());
}catch(Exception e){
System.out.println(e.toString());
}
}