jdbc java位置,java – 如何从任意位置使用JDBC驱动程序

从文章

Pick your JDBC driver at runtime;我只是在这里发贴代码供参考。

这个想法是让驾驶员经理认为驱动程序是从系统类加载器加载的。为此，我们使用这个类：

public class DelegatingDriver implements Driver

{

private final Driver driver;

public DelegatingDriver(Driver driver)

{

if (driver == null)

{

throw new IllegalArgumentException("Driver must not be null.");

}

this.driver = driver;

}

public Connection connect(String url, Properties info) throws SQLException

{

return driver.connect(url, info);

}

public boolean acceptsURL(String url) throws SQLException

{

return driver.acceptsURL(url);

}

public DriverPropertyInfo[] getPropertyInfo(String url, Properties info) throws SQLException

{

return driver.getPropertyInfo(url, info);

}

public int getMajorVersion()

{

return driver.getMajorVersion();

}

public int getMinorVersion()

{

return driver.getMinorVersion();

}

public boolean jdbcCompliant()

{

return driver.jdbcCompliant();

}

}

这样，您注册的驱动程序的类型为DelegatingDriver，它加载了系统类加载器。你现在只需要加载你真正想要使用的驱动程序，使用任何你想要的类加载器。例如：

URLClassLoader classLoader = new URLClassLoader(new URL[]{"path to my jdbc driver jar"}, this.getClass().getClassLoader());

Driver driver = (Driver) Class.forName("org.postgresql.Driver", true, classLoader).newInstance();

DriverManager.registerDriver(new DelegatingDriver(driver)); // register using the Delegating Driver

DriverManager.getDriver("jdbc:postgresql://host/db"); // checks that the driver is found