jdbc连接mysql数据库查询语句

2020-09-21 15:42发布

3条回答

2020-09-27 11:10

连接资源文件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);

}