package?com.exp;

import?java.io.File;
import?java.io.FileOutputStream;
import?java.io.PrintStream;
import?java.sql.Connection;
import?java.sql.DatabasemetaData;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.ResultSetmetaData;
import?java.sql.SQLException;
import?java.util.ArrayList;
import?java.util.List;

public?class?OutFileData?{
	?static?Connection?conn?=null;
	?static??PreparedStatement?ps=null;
	?static?ResultSet?rst=null;
	public?static?Connection?getConnection（）{
		try?{
			Class.forName（“oracle.jdbc.driver.OracleDriver“）;
			String?url=“jdbc:oracle:thin:@127.0.0.1:1521/orcl“;
			conn=DriverManager.getConnection（url“yuansen““yuansen“）;
		}?catch?（Exception?e）?{
			System.out.println（“數據庫連接失敗!“）;
		}
		
		return?conn;
	}
	
	//查詢所有的表
	public?static?List?getTableNameList（）?throws?SQLException?{
		getConnection（）;
		DatabasemetaData?dbmd?=?conn.getmetaData（）;
//		ResultSet?rs?=?dbmd.getTables（“hc“?“YUANSEN“?“%“?new?String[]?{?“TABLE“?}）;
		ResultSet?rs=dbmd.getTables（“HC“?“YUANSEN“?null?null）;
		List?tableNameList?=?new?ArrayList（）;
		while?（rs.next（））?{
		tableNameList.add（rs.getString（“TABLE_NAME“）