import java.awt.event.*;
import java.sql.*;
import java.util.Vector;
import sun.jdbc.odbc.JdbcOdbcDriver;
public class DataRetriever{
	//加載 JDBC 驅動
	static String jdbcDriver="sun.jdbc.odbc.JdbcOdbcDriver";
	static String dbName="Contacts";
	static String urlRoot="jdbc:odbc:";
	private ActionListener exceptionListener=null;
	public DataRetriever(){
		registerDriver();    //注冊驅動
	}
	public void setDatabaseName(String dbName){   //設置DB名
		this.dbName=dbName;
	}
	public void registerDriver{  //加載驅動
		try{
			Class.forName(jdbcDriver);
			DriverManager.registerDriver(new JdbcOdbcDriver());
		}catch(ClassNotFoundException e){
			reportException(e.getMessage());
		}
		catch(SQLException e){
			reportException(e.getMessage());
		}
	}
	public String[][] executeQuery(String SQLQuery){    //執行SQL查詢
		Vector dataset=new Vector();
		String url=urlRoot+dbName;
		try{
			//連接數據庫
			Connection con=DriverManager.getConnection(url);
			Statement stmt=con.createStatement();
			ResultSet rs=stmt.executeQuery(SQLQuery);    //把查詢結果放入結果集
			ResultSetMetaData md=rs.getMetaData();
			int nColumns=md.getColumnCount();
			//簡單地在ResultSet中循環
			while(rs.next()){
				String[] rowData=new String[nColumns];
				for(int i=0;i<nColumns;i++){
					rowData[i]=rs.getObject(i+1).toString();
				}
				dataset.addElement(rowData);     //加入dataset
			}
			con.close();    //關閉連接
		}
		catch(SQLException e){
			reportException(e.getMessage());
		}
		String[][] records=new String[dataset.size()][];    //返回值放入records二維數組
		for(int i=0;i<records.length;i++){
			records[i]=(String[])dataset.elementAt(i);
		}
		return records;
	}
	public void setExceptionListenner(ActionListerner exceptionListener){
		this.exceptionListerner=exceptionListerner;
	}
	private void reportException(String exception){ //處理異常
		if(exceptionListener!=null){
			ActionEvent evt=new ActionEvent(this,0,exception);
			exceptionListener.actionPerformed(evt);
		}
		else{
			System.err.println(exception);
		}
	}
	public static void main(String args[]){
		DataRetriever retriever=new DataRetriever();
		retriever.setDatabaseName("Contacts");  //設置DB名
		//執行SQL語句并把返回值放入records二維數組
		String[][] records=retriever.executeQuery("SELECT * FROM Contact_Info");
		for(int i=0;i<records.length;i++){     //從records中逐條取出并打印結果
			String[] record=records[i];
			for(int j=0;j<record.length;j++){
				if(j>0) System.out.print("\t");
				System.out.print(record[j]);
			}
			System.out.println();
		}
	}
}