URLClassLoader入门使用

来源：互联网发布：程序员笔记本大小编辑：程序博客网时间：2024/05/22 11:33

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，创建URLClassLoaderURLClassLoader 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();}}

0 0