// Chapter 05, sample 59
// JDBCODBCBridge.java
// Connect database with JDBC-ODBC bridge
package javadatabase;
import java.sql.*;
public class JDBCODBCBridge
{
	private String dbURL;			//數據庫標識名
	private String user;				//數據庫用戶
	private String password;		//數據庫用戶密碼
	public static void main(String args[])
	{
		try
		{
			JDBCODBCBridge bridge=new JDBCODBCBridge();
			bridge.setURL("jdbc:odbc:sample");
			bridge.setUser("");
			bridge.setPassword("");
			Connection con=bridge.getConnection();	//得到數據庫連接
			System.out.println(con.getCatalog());		//打印當前數據庫目錄名稱
			con.close();
		}
		catch(Exception e)
		{
			System.out.println(e.toString());
		}
	}
	public Connection getConnection()
	{
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");	//裝載數據庫驅動
			return DriverManager.getConnection(dbURL,user,password);			
		}
		catch (Exception e)
		{
			System.out.println(e.toString());
		}
		return null;
	}
	public void setURL(String dbURL)
	{
		this.dbURL=dbURL;		//設置數據庫標識
	}
	public void setUser(String user)
	{
		this.user=user;			//設置當前用戶
	}
	public void setPassword(String password)
	{
		this.password=password;	//設置用戶密碼
	}
}