JDBC连接的五种方式

获取数据库连接的五种方式

方式一

//方式一
    @Test
    public void test01() throws Exception {
        //注册驱动
        Driver driver = new Driver();
        //得到连接
        String url="jdbc:mysql://127.0.0.1:3306/jdbc";
        //获取对象
        Properties properties = new Properties();
        properties.setProperty("user","root");
        properties.setProperty("password","111111");
        Connection connect = driver.connect(url, properties);
        System.out.println(connect);
    }

方式二

    //方式二
    @Test
    public void test02() throws Exception {
        //反射加载 Driver类,动态加载,更加的灵活，
        Class<?> aClass = Class.forName("com.mysql.jdbc.Driver");
        Driver driver = (Driver)aClass.newInstance();
        //得到连接
        String url="jdbc:mysql://localhost:3306/jdbc";
        //获取对象
        Properties properties = new Properties();
        properties.setProperty("user","root");
        properties.setProperty("password","123456");
        Connection connect = driver.connect(url, properties);
        System.out.println(connect);
    }

方式三

   @Test
    public void test03() throws Exception {
        //使用DriverManager替代driver进行统一管理
        //注册驱动
        Class<?> aClass = Class.forName("com.mysql.jdbc.Driver");
        Driver driver = (Driver)aClass.newInstance();
        DriverManager.registerDriver(driver);

        //获取连接
        String url="jdbc:mysql://localhost:3306/jdbc";
        String user="root";
        String password="123456";
        Connection conn = DriverManager.getConnection(url, user, password);
        System.out.println(conn);

    }

方式四

//方式四
    @Test
    public void test04() throws Exception {
        //通过反射加载了Driver类
       Class.forName("com.mysql.jdbc.Driver");

       /* 源码:
         1.静态代码块，在类的加载时，会执行一次
         2.DriverManager.registerDriver(new Driver());
       static {
        try {
            DriverManager.registerDriver(new Driver());
        } catch (SQLException var1) {
            throw new RuntimeException("Can't register driver!");
        }
    }
       * */
        //创建url和user和password
        String url="jdbc:mysql://localhost:3306/jdbc";
        String user="root";
        String password="123456";
        Connection conn = DriverManager.getConnection(url, user, password);
        System.out.println(conn);
    }

方式五

 //方式五 增加配置文件，让连接mysql更加灵活
    @Test
    public void test05() throws Exception {
        //通过Properties对象获取配置文件信息
        Properties properties = new Properties();
        properties.load(new FileInputStream("src\\mysql.properties"));
        //获取相关值
        String user = properties.getProperty("user");
        String password = properties.getProperty("password");
        String driver = properties.getProperty("driver");
        String url = properties.getProperty("url");

        Class.forName(driver);//建议写上

        Connection conn = DriverManager.getConnection(url, user, password);
        System.out.println(conn);
    }
}