JDBC的连接方式

package com.bdqn.TestJDBC;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;
import java.util.Properties;
import org.junit.Test;
public class TestJDBC {
     //使用外部配置文件的形式来加载数据库连接
     @Test
     public void test4() throws Exception{
           //使用properties的形式俩导入属性
           Properties props = new Properties();
           props.load(new FileInputStream("jdbc.properties"));

           //获取连接数据库的配置信息
           String driverclassName = props.getProperty("driverclassName");
           String url = props.getProperty("url");
           String user = props.getProperty("user");
           String password = props.getProperty("password");
           //使用反射来加载驱动
           Class.forName(driverclassName);
           //使用DrivaerManager来获取数据库的连接
           Connection connection = DriverManager.getConnection(url, user, password);
           System.out.println(connection);


     }

     @Test
     public void test3() throws Exception{
           //设置连接数据库属性配置
           String className = "com.mysql.jdbc.Driver";
           String url = "jdbc:mysql://localhost:3306/test";
           String user = "root";
           String password = "root";

           //开始加载数据库驱动
           Class.forName(className);
           //获取数据库连接
           Connection connection = DriverManager.getConnection(url, user, password);
           System.out.println(connection);


     }

     @Test
     //方式二：通过 DriverManager 驱动管理类，获取与指定数据库的连接
     public void test2() throws Exception{
           //注册驱动
           String className = "com.mysql.jdbc.Driver";
           Class clazz = Class.forName(className);
           Driver driver = (Driver) clazz.newInstance();
           //registerDriver 注册驱动
           DriverManager.registerDriver(driver);

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

     }
     @Test
     //方式一：通过 MySQL 提供的驱动，利用反射获取 MySQL 的数据库连接  
     public void test1() throws Exception{
           Driver driver = null;
           //使用反射来加载数据库连接驱动
           String className = "com.mysql.jdbc.Driver";
           Class clazz = Class.forName(className);
           //实例化驱动
           driver = (Driver) clazz.newInstance();

           //获取数据库连接
           String url = "jdbc:mysql://localhost:3306/test";
           Properties props = new Properties();
           props.setProperty("user", "root");
           props.setProperty("password", "root");

           Connection conn = driver.connect(url, props);
           System.out.println(conn);

     }

}