JDBC链接的其他方式

最新推荐文章于 2023-01-13 15:08:13 发布

开快车的小吕

最新推荐文章于 2023-01-13 15:08:13 发布

阅读量146

点赞数

分类专栏： java 文章标签：数据库 mysql java jdbc

本文链接：https://blog.csdn.net/weixin_45673116/article/details/115442740

版权

java 专栏收录该内容

32 篇文章 0 订阅

订阅专栏

本文详细介绍了五种方式连接MySQL数据库：反射创建Driver实例、DriverManager注册、配置文件加载Driver、静态代码块注册及使用DriverManager连接。展示了从代码层面到实践的最佳实践和安全性考虑。

摘要由CSDN通过智能技术生成

@Test
    //方式2，利用反射来调用Driver 并获取实例
    public void test2() throws Exception{
        Class<?> aClass = Class.forName("com.mysql.cj.jdbc.Driver");
        Object o = aClass.newInstance();
        Driver driver = (Driver) o;

        String url = "jdbc:mysql://localhost:3306/test?useSSL=false&serverTimezone=GMT%2B8";
        //实例化配置
        Properties info=new Properties();
        //设置配置中的账号和密码
        info.setProperty("user","xxxxx");
        info.setProperty("password","xxxxx");
        //建立连接
        Connection connection=driver.connect(url,info);
        System.out.println(connection);

    }
    @Test
    //方式3-利用 DriverManager替换Driver
    public void test3() throws Exception {
        Class<?> aClass = Class.forName("com.mysql.cj.jdbc.Driver");
        Object o = aClass.newInstance();
        Driver driver = (Driver) o;

        //使用 DriverManager进行Driver注册
        DriverManager.registerDriver(driver);

        String url = "jdbc:mysql://localhost:3306/test?useSSL=false&serverTimezone=GMT%2B8";
        String user="xxxxx";
        String password="xxxxx";

        //建立链接
        Connection connection = DriverManager.getConnection(url, user, password);

        System.out.println(connection);
    }
    @Test
    //方式4
    public void test4() throws Exception {
        String url = "jdbc:mysql://localhost:3306/test?useSSL=false&serverTimezone=GMT%2B8";
        String user="xxxxx";
        String password="xxxxx";

        /**
         * static {
         *      try {
         *               DriverManager.registerDriver(new Driver());
         *          } catch (SQLException var1) {
         *      throw new RuntimeException("Can't register driver!");
         *      }
         */
        //加载Driver类-其中Driver中包含静态代码块，随着类的加载而加载
        // 因此不需要类的实例化和注册
        //类的加载
        Class.forName("com.mysql.cj.jdbc.Driver");
        /*Object o = aClass.newInstance();
        Driver driver = (Driver) o;

        //使用 DriverManager进行Driver注册
        DriverManager.registerDriver(driver);*/

        //建立链接
        Connection connection = DriverManager.getConnection(url, user, password);

        System.out.println(connection);
    }
    @Test
    //方式5通过配置文件链接数据库，不会将用户名和密码暴露出来，实现数据和代码的分离，解耦
    public void test5() throws Exception {
        //读取配置文件
        /**方式1
         * Properties properties=new Properties();
         * FileInputStream fileInputStream=new FileInputStream("jdbc.properties");
         *
         * //加载对应流文件
         * properties.load(fileInputStream);
         * String name = properties.getProperty("name");
         * String password = properties.getProperty("password");
         *
         * System.out.println(name+password);
         */
        //方式2通过类加载器加载配置文件-类加载器要确保properties在src文件下
        //FileInputStream resource FileInputStream("jdbc.properties");
        InputStream resource = ConnectionTest.class.getClassLoader().getResourceAsStream("jdbc.properties");

        Properties pt=new Properties();
        pt.load(resource);


        String user = pt.getProperty("user");
        String password = pt.getProperty("password");
        String url = pt.getProperty("url");
        String driverClass = pt.getProperty("driverClass");


        Class.forName(driverClass);

        //建立链接
        Connection connection = DriverManager.getConnection(url, user, password);

        System.out.println(connection);
    }

#properties中的配置信息
url=jdbc:mysql://localhost:3306/test?useSSL=false&serverTimezone=GMT%2B8
user=xxxx
password=xxxx
driverClass=com.mysql.cj.jdbc.Driver