java使用数据库驱动连接指定数据库

 

public class MysqlTest {
    @Test  
    //写死的方式连接mysql数据库
    public void mysqltest(){
        Driver driver=null;
        try {
           driver = new com.mysql.jdbc.Driver();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        String url="jdbc:mysql://127.0.0.1:3306/test";
        Properties info = new Properties();
        info.put("user","####");         //数据库的用户名
        info.put("password","******");   //数据库密码
        try {
            assert driver != null;
            driver.connect(url,info);
            Thread.sleep(20000);
        } catch (SQLException | InterruptedException e) {
            e.printStackTrace();
        }
    }

    @Test
    //使用反射实现动态连接数据库，根据配置文件的参数进行不同类型的数据库的连接
    public void SQLtest() throws Exception{
        String driverClass =null;
        String url = null;
        String user = null;
        String password = null;

        FileInputStream fileInputStream = new FileInputStream(new File("jdbc.properties"));
        Properties properties = new Properties();
        properties.load(fileInputStream);
        driverClass = properties.getProperty("driverclass");
        url = properties.getProperty("url");
        user = properties.getProperty("user");
        password = properties.getProperty("password");

        Driver driver = (Driver) Class.forName(driverClass).newInstance();

        Properties info = new Properties();
        info.put("user",user);
        info.put("password",password);
        Connection connection = driver.connect(url,info);
    }
    
      @Test
    //使用DriverManager的getConnection()方法连接数据库
    public void testDrivermanager() throws Exception {
        String driverClass =null;
        String url = null;
        String user = null;
        String password = null;
        //第一步：准备连接数据库的4个参数：驱动名、jdbcUrl,user,password
        //1.读取配置盘文件
        FileInputStream fileInputStream = new FileInputStream(new File("jdbc.properties"));
        Properties properties = new Properties();
        properties.load(fileInputStream);
        fileInputStream.close();
        //2.从配置文件中获取读取的参数值
        driverClass = properties.getProperty("driverclass");
        url = properties.getProperty("url");
        user = properties.getProperty("user");
        password = properties.getProperty("password");
        //第二步：加载驱动
        Class.forName(driverClass);
        //第三步：通过DriverManager的getconnection方法获取数据连接
        Connection connection = DriverManager.getConnection(url,user,password);

    }
}

代码中有些地方还要处理，不过已经能实现功能了~（流的处理等） 

配置文件是：