import java.net.*;
import java.sql.*;
import java.util.*;

/**
 * Description:
 * <br/>Copyright (C), 2008-2010, Yeeku.H.Lee
 * <br/>This program is protected by copyright laws.
 * <br/>Program Name:
 * <br/>Date:
 * @author  Yeeku.H.Lee kongyeeku@163.com
 * @version  1.0
 */
public class URLClassLoaderTest
{
	private static Connection conn;
	//定義一個獲取數據庫連接方法
	public static Connection getConn(String url , 
		String user , String pass)throws Exception
	{
		if (conn == null)
		{
			//創建一個URL數組
			URL[] urls = {new URL("file:mysql-connector-java-3.1.10-bin.jar")};
			//以默認的ClassLoader作為父ClassLoader，創建URLClassLoader
			URLClassLoader myClassLoader = new URLClassLoader(urls);
			//加載MySQL的JDBC驅動，并創建默認實例
			Driver driver = (Driver)myClassLoader.
				loadClass("com.mysql.jdbc.Driver").newInstance();
			//創建一個設置JDBC連接屬性的Properties對象
			Properties props = new Properties();
			//至少需要為該對象傳入user和password兩個屬性
			props.setProperty("user" , user);
			props.setProperty("password" , pass);
			//調用Driver對象的connect方法來取得數據庫連接
			conn = driver.connect("jdbc:mysql://localhost:3306/mysql" , props);
		}
		return conn;
	}
	public static void main(String[] args)throws Exception
	{
		System.out.println(getConn(
			"jdbc:mysql///mysql"
			, "root" , "32147"));
	}
}