JDBC基本操作2

1.第二种连接数据库的方法

新建一个java类

private static String driver;
private static String url;
private static String username;
private static String password;

static{
    Properties prop = new Properties();
    InputStream inputStream = BaseDao.class.getClassLoader()
            .getResourceAsStream("database.properties");
    try {
        prop.load(inputStream);
    } catch (IOException e) {
        e.printStackTrace();
    }
    driver = prop.getProperty("driver");
    url = prop.getProperty("url");
    username = prop.getProperty("user");
    password = prop.getProperty("password");

public Connection getConnection(){
    Connection connection =null;
    try {
        Class.forName(driver);
        connection= DriverManager.getConnection(url, username, password);
    } catch (ClassNotFoundException e) {
        throw new RuntimeException(e);
    } catch (SQLException e) {
        throw new RuntimeException(e);
    }
    return connection;
}

}

在项目底层新建一个名为resoures文件夹，在该文件夹新建一个file名为（databaseproperties）.

在该文件中配置：

driver=com.mysql.cj.jdbc.Driver
url=jdbc:mysql://192.168.153.149:3306/pet
user=root
password=root