jdbc mysql配置文件_JDBC（mysql8.0版本）配置文件和工具类

配置文件

driver=com.mysql.cj.jdbc.Driver

url=jdbc:mysql://localhost:3306/jdbcstudy?useUnicode=true&characterEncoding=utf8&useSSL=true&serverTimezone=UTC

username=root

password=123456 //设置的密码

工具类

import java.io.IOException;

import java.io.InputStream;

import java.sql.*;

import java.util.Properties;

public class JdbcUtils {

private static String driver=null;

private static String url=null;

private static String username=null;

private static String password=null;

static{

try{

InputStream in = JdbcUtils.class.getClassLoader().getResourceAsStream("db.properties");//db.properties"为配置文件名

Properties properties = new Properties();

properties.load(in);

driver=properties.getProperty("driver");

url=properties.getProperty("url");

username=properties.getProperty("username");

password=properties.getProperty("password");

//驱动加载

Class.forName(driver);

} catch (IOException | ClassNotFoundException e) {

e.printStackTrace();

}

}

// 获取连接

public static Connection getConnection() throws SQLException {

return DriverManager.getConnection(url, username, password);

}

//释放资源

public static void release(Connection conn, Statement st, ResultSet rs) throws SQLException {

if(rs!=null){

rs.close();

}

if(st!=null){

st.close();

}

if(conn!=null){

conn.close();

}

}

}

标签：username,password,JDBC,配置文件,driver,static,mysql8.0,null,properties

来源： https://blog.csdn.net/weixin_44010678/article/details/112058868