SpringJDBC

最新推荐文章于 2022-09-13 12:55:32 发布

星_河

最新推荐文章于 2022-09-13 12:55:32 发布

阅读量123

点赞数

分类专栏： Spring 文章标签： Spring JdbcTemplate

本文链接：https://blog.csdn.net/dylansun/article/details/102055929

版权

Spring 专栏收录该内容

12 篇文章 0 订阅

订阅专栏

mysql版本：mysql-8.0.17 jdk 1.8
先上pom
<!-- https://mvnrepository.com/artifact/org.springframework/spring-jdbc -->
<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-jdbc</artifactId>
    <version>5.2.0.RELEASE</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.springframework/spring-tx -->
<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-tx</artifactId>
    <version>5.2.0.RELEASE</version>
</dependency>
<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.17</version>
</dependency>

出现各种异常：

Caused by: java.sql.SQLException: 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.

时区，驱动问题com.mysql.cj.jdbc.Driver，

这哥们写不错，异常分析。

https://blog.csdn.net/weixin_40916641/article/details/80546040

my配置：

<bean id="dataSource"
class="org.springframework.jdbc.datasource.DriverManagerDataSource">
       <property name="driverClassName" value="com.mysql.cj.jdbc.Driver"></property>
       <property name="url"
         value="jdbc:mysql://localhost:3306/test?useUnicode=true&amp;characterEncoding=utf-8&amp;useSSL=false&amp;serverTimezone = GMT"/>
       <property name="username" value="root"/>
       <property name="password" value="123456"/>
   </bean>
   <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
       <property name="dataSource" ref="dataSource"></property>

   </bean>