连接资源文件mysql.properties(适用于mysql8.0 java连接器):
driver=com.mysql.cj.jdbc.Driver
url=jdbc:mysql://ip:3306/dbname?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false
user=username
password=password
代码中:
public static Connection getConnection() throws Exception {
ResourceBundle rb = ResourceBundle.getBundle("util/mysql");
String driver = rb.getString("driver");
String url = rb.getString("url");
String user = rb.getString("user");
String password = rb.getString("password");
Class.forName(driver);
return DriverManager.getConnection(url, user, password);
}