发表于： 2017-04-24 21:16:49
1 1349
今天完成的事情：用Mybatis的XML实现报名表的增删改查，log4j记录日志，并且JUnit测试通过。
明天打算做的事情：用Mybatis的注解的方式实现表的增删改查，争取完成任务一
遇到的问题：
1. 数据库时区问题报错：ERROR: The server time zone value '�й���ʱ��' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
解决方法：在 mysql 中执行命令：set global time_zone='+8:00'
2. SSL的问题：dentity verification is not recommended. According toMySQL5.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.
解决方法：url=jdbc:mysql://127.0.0.1:3306/framework?characterEncoding=utf8&useSSL=false这就行了
收获：对Mybatis的XML配置流程有了更加深入的理解
返回列表
评论