URLClassLoader入门使用

public class URLClassLoaderTest {
	private static Connection conn;
	public static Connection getConn(String url,String user,String pass) throws Exception{
		if(conn ==null){
			URL[] urls = {new URL("file:D:\\mysql-connector-java-5.1.8.jar")};
			//  以默认的ClassLoader作为父ClassLoader，创建URLClassLoader
			URLClassLoader myClassloader = new URLClassLoader(urls);
			Driver driver = (Driver)myClassloader.loadClass("com.mysql.jdbc.Driver").newInstance();
			// 创建一个设置JDBC连接属性的 Properties对象
			Properties properties = new Properties();
			properties.setProperty("user", user);
			properties.setProperty("password", pass);
			// 调用Driver对象的connect方法来取得数据库连接
			conn = driver.connect(url, properties);
		}
		return conn;
	}
	public static void main(String[] args) throws Exception {
		Connection mysqlConn = getConn("jdbc:mysql://localhost:3306/mysql", "root", "admin123");
		System.out.println(mysqlConn);
		Statement createStatement = mysqlConn.createStatement();
		ResultSet resultSet = createStatement.executeQuery("select * from user");
		while(resultSet.next()){
			String name = resultSet.getString("User");
			System.out.println(name);
		}
		mysqlConn.close();
	}
}