Spring boot + mybatis 日期的问题

2018-11-02 10:55:35 549 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

Spring Boot 3.x 整合 SSM 实战：5步构建RESTful API并对比传统SSH项目结构本文详细介绍了Spring Boot 3.x整合SSM框架的实战步骤，通过5个关键步骤构建RESTful API，并与传统SSH项目结构进行对比。文章展示了Spring Boot+SSM组合如何显著提升开发效率，减少配置量，并提供完整的示例项目和迁移策略。阅读详情

逆向工程生成的文件, 数据库是datetime类型的表查询,插入都会出错. mapper是 timestamp类型.

po的成员类型换过sql.date , String也尝试过 , 网上搜了好几个方法都不行.

现在的情况 , 不设置该日期字段,可以正常.

我重新建了个项目, 依赖是相同的, 但是该为注解方式, 是可以插入日期字段的.

debug信息, 看着也没问题.

2018-11-02 10:38:29.829 DEBUG 9884 --- [http-nio-8080-exec-5] com.ctu.dao.MovieMapper.insertSelective : ==> Preparing: insert into movie ( name, classify, district, logo, actor, age, status, update, con ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ? )
2018-11-02 10:38:29.831 DEBUG 9884 --- [http-nio-8080-exec-5] com.ctu.dao.MovieMapper.insertSelective : ==> Parameters: 1231(String), 2(Integer), 431(String), aaa(String), 321(String), 1234(String), 3123(String), 2018-11-02 10:38:29.826(Timestamp), 12356(String)

...全文

Spring Boot3与MyBatis-Plus整合实战与避坑指南 MyBatis-Plus作为Java生态中广泛使用的ORM框架，通过与Spring Boot的深度整合，显著提升了数据库操作效率。其核心原理基于MyBatis的SQL映射与Spring的依赖注入，通过自动装配机制实现零配置开箱即用。在技术价值层面，MyBatis-Plus提供的代码生成器、分页插件等功能，可以节省约40%的CRUD开发时间。典型应用场景包括高并发电商系统、多租户SAAS平台等需要复杂SQL优化的领域。随着Spring Boot3的发布，版本兼容性成为整合过程中的关键挑战，特别是自动装配机制变阅读详情

eacc31

Web 开发 81,108 成员 341,721 内容

+ 关注 + 加入社区

切换为时间正序

冒菜-码农 2018-11-08

打赏
举报

1。首先先确定你的日期格式到底精确到多少，我们一般都精确到年月日时分秒。 2.根据精确的后的日期进行插入数据前的格式化 3.若精确后的日期精度过高，建议将数据库表字段改为Timestamp类型，反之只需要再mybatis的xml文件中将该字段的type类型指定为datatime即可

hi-face 2018-11-05

打赏
举报

idea配置自动生成mybaits实体类和mapper.xml ~ better-mybatis-generator

eacc31 2018-11-03

打赏
举报

引用 8 楼 lvzhyt 的回复:

#2楼的是可行的。 debug信息多贴点，看看具体sql报错提示

老师帮给在看看

eacc31 2018-11-02

打赏
举报

引用 1 楼 genaro26 的回复:

我的也是通过反向工程生成的，po日期类型为java.util.Date，数据库中该字段为datetime，mapper的xml中为如下配置：
private Date updateTime;
<result column="update_time" property="updateTime" jdbcType="TIMESTAMP" />

跟你这个是一样的. 但是不行呢

雾里看花の 2018-11-02

打赏
举报

我的也是通过反向工程生成的，po日期类型为java.util.Date，数据库中该字段为datetime，mapper的xml中为如下配置：



private Date updateTime;



<result column="update_time" property="updateTime" jdbcType="TIMESTAMP" />

eacc31 2018-11-02

打赏
举报

上面的方法全都试过了.. 还是不行.



2018-11-02 22:15:48.058 DEBUG 10020 --- [nio-8080-exec-7] o.s.b.w.f.OrderedRequestContextFilter    : Cleared thread-bound request context: org.apache.catalina.connector.RequestFacade@4975ee9b

2018-11-02 22:15:48.076 DEBUG 10020 --- [nio-8080-exec-8] o.s.b.w.f.OrderedRequestContextFilter    : Bound request context to thread: org.apache.catalina.connector.RequestFacade@4975ee9b

2018-11-02 22:15:48.079 DEBUG 10020 --- [nio-8080-exec-8] o.s.b.w.f.OrderedRequestContextFilter    : Cleared thread-bound request context: org.apache.catalina.connector.RequestFacade@4975ee9b

2018-11-02 22:15:48.081 DEBUG 10020 --- [nio-8080-exec-8] o.s.b.w.f.OrderedRequestContextFilter    : Bound request context to thread: org.apache.catalina.connector.RequestFacade@4975ee9b

2018-11-02 22:15:48.085 DEBUG 10020 --- [nio-8080-exec-8] o.s.b.w.f.OrderedRequestContextFilter    : Cleared thread-bound request context: org.apache.catalina.connector.RequestFacade@4975ee9b

2018-11-02 22:15:48.091 DEBUG 10020 --- [nio-8080-exec-6] o.s.b.w.f.OrderedRequestContextFilter    : Bound request context to thread: org.apache.catalina.connector.RequestFacade@1946cdfb

2018-11-02 22:15:48.095 DEBUG 10020 --- [nio-8080-exec-6] o.s.b.w.f.OrderedRequestContextFilter    : Cleared thread-bound request context: org.apache.catalina.connector.RequestFacade@1946cdfb

2018-11-02 22:15:48.104 DEBUG 10020 --- [nio-8080-exec-8] o.s.b.w.f.OrderedRequestContextFilter    : Bound request context to thread: org.apache.catalina.connector.RequestFacade@5d222e24

2018-11-02 22:15:48.105 DEBUG 10020 --- [io-8080-exec-10] o.s.b.w.f.OrderedRequestContextFilter    : Bound request context to thread: org.apache.catalina.connector.RequestFacade@3e205cf6

2018-11-02 22:15:48.107 DEBUG 10020 --- [io-8080-exec-10] o.s.b.w.f.OrderedRequestContextFilter    : Cleared thread-bound request context: org.apache.catalina.connector.RequestFacade@3e205cf6

2018-11-02 22:15:48.109 DEBUG 10020 --- [nio-8080-exec-8] o.s.b.w.f.OrderedRequestContextFilter    : Cleared thread-bound request context: org.apache.catalina.connector.RequestFacade@5d222e24

2018-11-02 22:15:48.110 DEBUG 10020 --- [nio-8080-exec-1] o.s.b.w.f.OrderedRequestContextFilter    : Bound request context to thread: org.apache.catalina.connector.RequestFacade@11eb4fe8

2018-11-02 22:15:48.112 DEBUG 10020 --- [nio-8080-exec-1] o.s.b.w.f.OrderedRequestContextFilter    : Cleared thread-bound request context: org.apache.catalina.connector.RequestFacade@11eb4fe8

2018-11-02 22:15:48.114 DEBUG 10020 --- [nio-8080-exec-9] o.s.b.w.f.OrderedRequestContextFilter    : Bound request context to thread: org.apache.catalina.connector.RequestFacade@4975ee9b

2018-11-02 22:15:48.116 DEBUG 10020 --- [nio-8080-exec-9] o.s.b.w.f.OrderedRequestContextFilter    : Cleared thread-bound request context: org.apache.catalina.connector.RequestFacade@4975ee9b

2018-11-02 22:16:24.679 DEBUG 10020 --- [nio-8080-exec-4] o.s.b.w.f.OrderedRequestContextFilter    : Bound request context to thread: org.apache.catalina.connector.RequestFacade@4975ee9b

2018-11-02 22:16:24.772 DEBUG 10020 --- [nio-8080-exec-4] com.ctu.dao.MovieMapper.insertSelective  : ==>  Preparing: insert into movie ( name, classify, district, logo, actor, age, status, update, con ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) 

2018-11-02 22:16:24.779 DEBUG 10020 --- [nio-8080-exec-4] com.ctu.dao.MovieMapper.insertSelective  : ==> Parameters: 名称(String), 1(Integer), 测试地区(String), aaa(String), sdas(String), 3123(String), 1080(String), 2018-11-02 22:16:24.731(Timestamp), 简介(String)

2018-11-02 22:16:24.813  INFO 10020 --- [nio-8080-exec-4] o.s.b.f.xml.XmlBeanDefinitionReader      : Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]

org.springframework.jdbc.BadSqlGrammarException: 

### Error updating database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'update,

      

      

        con ) 

     values ( '名称',

      

      

     ' at line 23

### The error may involve com.ctu.dao.MovieMapper.insertSelective-Inline

### The error occurred while setting parameters

### SQL: insert into movie      ( name,                       classify,                       district,                       logo,                       actor,                       age,                       status,                       update,                       con )       values ( ?,                       ?,                       ?,                       ?,                       ?,                       ?,                       ?,                       ?,                       ? )

### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'update,

      

      

        con ) 

     values ( '名称',

      

      

     ' at line 23

; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'update,

      

      

        con ) 

     values ( '名称',

      

      

     ' at line 23

	at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:230)

	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)

	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)

	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)

	at com.sun.proxy.$Proxy59.insert(Unknown Source)

	at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:278)

	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:57)

	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)

	at com.sun.proxy.$Proxy60.insertSelective(Unknown Source)

	at com.ctu.service.impl.MovieImpl.insertSelective(MovieImpl.java:31)

	at com.ctu.controller.AddController.saveMovie(AddController.java:46)

	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

琴岛橙子 2018-11-02

打赏
举报

#2楼的是可行的。 debug信息多贴点，看看具体sql报错提示

eacc31 2018-11-02

打赏
举报

谢谢各位老师, ,这个问题纠结快一个礼拜了.

eacc31 2018-11-02

打赏
举报

不行. 日期格式化尝试过了. 该字符串总感觉心里不舒服

时光Crazy 2018-11-02

打赏
举报

在entity的日期类型属性，加上 @DateTimeFormat 注解呢

tonyzane88 2018-11-02

打赏
举报

我觉得数据库表的日期字段用字符类型最好用了。

奔跑的小鱼儿 2018-11-02

打赏
举报

实体类implements Serializable 就好了

Spring boot + mybatis 日期的问题

相关推荐