数据库连接

数据库连接

package com.wy;

import org.junit.Test;

import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;

/**
 * @author HelloWorld
 * @create 2021-05-24-21:57
 * @email 154803771@qq.com
 */
public class MySqlConnect {
	
    // 方法一
    @Test
    public void getConnection1() throws ClassNotFoundException, SQLException {

        // 1.提供连接信息
        String url = "jdbc:mysql://localhost:3306/test";
        String userName = "root";
        String password = "****";

        Properties info = new Properties();
        info.setProperty("user", userName);
        info.setProperty("password", password);


        // 2.获取数据库连接
        Driver driver = new com.mysql.jdbc.Driver();
        Connection connection = driver.connect(url, info);

        System.out.println(connection);

    }
	
	// 方法二
    @Test
    public void getConnection2() throws ClassNotFoundException, SQLException {
        // 1.加载驱动
        Class.forName("com.mysql.jdbc.Driver");
        // 2.提供连接信息
        String url = "jdbc:mysql://localhost:3306/test";
        String userName = "root";
        String password = "****";
        // 3.获取数据库连接
        Connection connection = DriverManager.getConnection(url, userName, password);

        System.out.println(connection);
    }

	// 方法三
    @Test
    public void getConnection() throws IOException, ClassNotFoundException, SQLException {
        // 1.读取配置文件内容
        InputStream resourceAsStream = MySqlConnect.class.getClassLoader().getResourceAsStream("root1949.properties");

        // 2.数据解析
        Properties properties = new Properties();
        properties.load(resourceAsStream);

        // 3.获取连接信息
        String url = properties.getProperty("url");
        String user = properties.getProperty("user");
        String password = properties.getProperty("password");
        String driver = properties.getProperty("driver");

        // 4.加载驱动
        Class.forName(driver);

        // 5.连接数据库
        Connection connection = DriverManager.getConnection(url, user, password);

        System.out.println(connection);


    }

}