java通过配置文件连接数据库

1.项目结构：

2.配置文件内容：

DRIVER_CLASS=com.mysql.cj.jdbc.Driver

CONNECTION_URL=

CONNECTION_USERNAME=

CONNECTION_PASSWORD=

3.maven依赖

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>6.0.6</version>
</dependency>

4.connectFactory读取配置文件，连接数据库

public Connection getConnection() throws Exception{
    properties=new Properties();
    properties.load(new FileInputStream("config/config.properties"));
    String url=properties.getProperty("CONNECTION_URL");
    String userName=properties.getProperty("CONNECTION_USERNAME");
    String password=properties.getProperty("CONNECTION_PASSWORD");
    connection= DriverManager.getConnection(url,userName,password);
    return connection;
}

5.主函数获取数据库连接，执行sql语句

try {
    connectFactory c=new connectFactory();
    Connection connection=c.getConnection();
    String sql="drop table  wzz ";
    Statement stmt=connection.createStatement();
    int res=stmt.executeUpdate(sql);
    System.out.println(res);
}catch (Exception e){
    e.printStackTrace();
}