1、需要导入jar包,这个网上一大堆。
2、在运行java程序(链接数据库)的时候要求select java Application,这个的原因是找不到工程的main函数。解决方法如下:在run configuration--Java application中新建一个configuration。在右侧Main标签下,project对应工程名字,Main class中填入包含main函数的类(包名+类名),点击apply,然后run即可。不过可以先将工程名和main函数类名设为一样试试。
3、出现如下问题: WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
解决办法:将数据库连接地址定义如下:
//定义数据库的链接地址
public static final String DBURL = "jdbc:mysql://localhost:3306/myoa?serverTimezone=UTC&useSSL=false";
serverTimezone=UTC设置时区。