package db;
import java.sql.*;
import javax.sql.* ;

public class AccessDAO
{
	private String driverName = "sun.jdbc.odbc.JdbcOdbcDriver" ;
	private String url = "jdbc:odbc:testdata" ;
	private String dbname = "testdata" ;

	public AccessDAO(String dbname)
	{
		this.dbname = dbname ;
	}
	public Connection getConnection() throws Exception
	{
		System.out.println("使用驅動程序："+driverName) ;
		Class.forName(driverName) ;
		
		String url = "jdbc:odbc:" +dbname ;
                System.out.println("使用URL:"+url) ;
		Connection conn = 
                	DriverManager.getConnection(url) ;
		return conn ;
	}
}