import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.ResultSetmetaData;
import?java.sql.SQLException;
import?java.sql.Statement;

import?java.io.*;
import?java.io.File;
import?java.util.ArrayList;
import?java.util.List;

import?jxl.Cell;
import?jxl.Sheet;
import?jxl.Workbook;
import?jxl.write.Label;
import?jxl.write.WritableSheet;
import?jxl.write.WritableWorkbook;

public?class?ToExcel?{
	private?static?Connection?conn=null;
	private?static?Statement?stat=null;
	private?static?ResultSet?rs=null;
	private?PreparedStatement?prep=null;
	
	private?String?driver=“com.mysql.jdbc.Driver“;
	private?static?String?url=““;
	private?String?user=“test“;
	private?String?password=“test369“;
	
	private?WritableWorkbook?workbook;
??private?WritableSheet?sheet;??
??
	public?ToExcel（）{
	}
	/*	?*?建立數據庫連接資源
	?*/
	public?void?Connect（）{
		try?{
			Class.forName（driver）;
			conn=DriverManager.getConnection（url?user?password）;
			stat=conn.createStatement（）;
			System.out.println（“數據庫連接成功。“）;
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}
	}
	/*	?*?關閉數據庫連接資源
	?*?close（）
	?*/
	public?void?close（）{		
		try?{
			if（rs!=null）?{
				rs.close（）;
				rs=null;
			}
			if（stat!=null）?{
				stat.close（）;
				stat=null;
			}
			if（prep!=null）{?
				prep.close（）;
				prep=null;
			}
			if（conn!=null）?{
				conn.close（）;
				conn=null;
			}
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
	}
	
	//*workbook?????*?生成Excel文件??????*?@param?path?????????文件路徑?
??public?void?createExcelFile（String?path）{
???????try{??
???????????OutputStream?os=new?FileOutputStream（path）;???
???????????workbook=Workbook.createWorkbook（os）;???
???????}catch（Exception?e）{??
???????????e.printStackTrace（）;??
???????	}??
??}??
??//*sheet*?????*?生成sheet表?????*?@param?intsheet?????工作表次序??????*?@param?sheetName????工作表名稱
??public?void?createSheetName（int?intsheetString?sheetName）{
???????try{??
???????????sheet?=?workbook.createSheet（sheetName?intsheet）;?//添加工作表??
???????}catch（Exception?e）{??
???????????e.printStackTrace（）;??
???????	}??
??}??
??//			保存Excel文件
??public?void?WorkBookWrite（）{
???????try{??
???????????workbook.write（）;???
???????????workbook.close（）;??
???????}catch（Exception?e）{??
???????????e.printStackTrace（）;??
???????}??
??}?
??
??//			寫
??public?void?write?（Listject[]>?listData）{
??	/*
??	System.out.println（“list?=?“?+?listData.size（）?+?“?->?column?=?“?+?listData.get（0）.length）;
		for（object[]?obj:listData）{
			for（int?i=0;i				System.out.print（obj[i]+“->“）;
			}
			System.out.println（“\n“）;
		}
??	*/
??	Label?label?=?null;
		object[]?obj?=?null;?
		
??	for?（int?i=0;i					obj?=?listData.get（i）;
					//?列
					for?（int?j=0;j						//?Label構造器中有三個參數，第一個為列，第二個為行，第三個則為單元格填充的內容
						label?=?new?Label（j?i?（obj[j]==

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????914??2006-10-20?00:17??test\com\mysql\jdbc\AssertionFailedException.class

?????文件???????3604??2006-10-20?00:17??test\com\mysql\jdbc\Blob.class

?????文件???????2116??2006-10-20?00:17??test\com\mysql\jdbc\BlobFromLocator$LocatorInputStream.class

?????文件???????8472??2006-10-20?00:17??test\com\mysql\jdbc\BlobFromLocator.class

?????文件??????11778??2006-10-20?00:17??test\com\mysql\jdbc\Buffer.class

?????文件???????1366??2006-10-20?00:17??test\com\mysql\jdbc\CallableStatement$CallableStatementParam.class

?????文件???????6435??2006-10-20?00:17??test\com\mysql\jdbc\CallableStatement$CallableStatementParamInfo.class

?????文件???????1129??2006-10-20?00:17??test\com\mysql\jdbc\CallableStatement$CallableStatementParamInfoJDBC3.class

?????文件??????29764??2006-10-20?00:17??test\com\mysql\jdbc\CallableStatement.class

?????文件??????11950??2006-10-20?00:17??test\com\mysql\jdbc\CharsetMapping.class

?????文件???????2477??2006-10-20?00:16??test\com\mysql\jdbc\Charsets.properties

?????文件???????5148??2006-10-20?00:17??test\com\mysql\jdbc\Clob.class

?????文件???????3552??2006-10-20?00:17??test\com\mysql\jdbc\CommunicationsException.class

?????文件???????4684??2006-10-20?00:17??test\com\mysql\jdbc\CompressedInputStream.class

?????文件????????413??2006-10-20?00:16??test\com\mysql\jdbc\configs\3-0-Compat.properties

?????文件????????100??2006-10-20?00:16??test\com\mysql\jdbc\configs\clusterbase.properties

?????文件????????146??2006-10-20?00:16??test\com\mysql\jdbc\configs\fullDebug.properties

?????文件????????775??2006-10-20?00:16??test\com\mysql\jdbc\configs\maxPerformance.properties

?????文件????????248??2006-10-20?00:16??test\com\mysql\jdbc\configs\solarisMaxPerformance.properties

?????文件???????1135??2006-10-20?00:17??test\com\mysql\jdbc\Connection$1.class

?????文件???????1326??2006-10-20?00:17??test\com\mysql\jdbc\Connection$CompoundCacheKey.class

?????文件??????20359??2006-10-20?00:17??test\com\mysql\jdbc\Connection$UltraDevWorkAround.class

?????文件??????67031??2006-10-20?00:17??test\com\mysql\jdbc\Connection.class

?????文件????????830??2006-10-20?00:17??test\com\mysql\jdbc\ConnectionFeatureNotAvailableException.class

?????文件????????372??2006-10-20?00:17??test\com\mysql\jdbc\ConnectionProperties$1.class

?????文件???????2243??2006-10-20?00:17??test\com\mysql\jdbc\ConnectionProperties$BooleanConnectionProperty.class

?????文件???????5207??2006-10-20?00:17??test\com\mysql\jdbc\ConnectionProperties$ConnectionProperty.class

?????文件???????3334??2006-10-20?00:17??test\com\mysql\jdbc\ConnectionProperties$IntegerConnectionProperty.class

?????文件???????2133??2006-10-20?00:17??test\com\mysql\jdbc\ConnectionProperties$MemorySizeConnectionProperty.class

?????文件???????2341??2006-10-20?00:17??test\com\mysql\jdbc\ConnectionProperties$StringConnectionProperty.class

............此處省略680個文件信息