java %y-%m-%d_@TableField (condition=DATE_FORMAT(%s,'%Y-%m-%d'))中有特殊字符怎么处理呢

作者：盐析白兔 | 2024-03-01 12:03:14

踩

@tablefield 数据库特殊字符

```

@TableField(fill = FieldFill.INSERT,condition = "DATE_FORMAT(%s,'/%Y-/%m-/%d') = DATE_FORMAT(#{%s},'/%Y-/%m-/%d')")

private Date createDate;

```

Caused by: java.util.UnknownFormatConversionException: Conversion = 'Y'

at java.util.Formatter$FormatSpecifier.conversion(Formatter.java:2691)

at java.util.Formatter$FormatSpecifier.(Formatter.java:2720)

at java.util.Formatter.parse(Formatter.java:2560)

at java.util.Formatter.format(Formatter.java:2501)

at java.util.Formatter.format(Formatter.java:2455)

at java.lang.String.format(String.java:2940)

at com.baomidou.mybatisplus.mapper.AutoSqlInjector.sqlCondition(AutoSqlInjector.java:519)

at com.baomidou.mybatisplus.mapper.LogicSqlInjector.sqlWhereEntityWrapper(LogicSqlInjector.java:267)

at com.baomidou.mybatisplus.mapper.LogicSqlInjector.injectDeleteSql(LogicSqlInjector.java:77)

at com.baomidou.mybatisplus.mapper.AutoSqlInjector.injectSql(AutoSqlInjector.java:157)

at com.baomidou.mybatisplus.mapper.AutoSqlInjector.inject(AutoSqlInjector.java:117)

at com.baomidou.mybatisplus.mapper.AutoSqlInjector.inspectInject(AutoSqlInjector.java:88)

at com.baomidou.mybatisplus.MybatisMapperAnnotationBuilder.parse(MybatisMapperAnnotationBuilder.java:147)

at com.baomidou.mybatisplus.MybatisMapperRegistry.addMapper(MybatisMapperRegistry.java:86)

at com.baomidou.mybatisplus.MybatisConfiguration.addMapper(MybatisConfiguration.java:101)

at org.apache.ibatis.builder.xml.XMLMapperBuilder.bindMapperForNamespace(XMLMapperBuilder.java:413)

at org.apache.ibatis.builder.xml.XMLMapperBuilder.parse(XMLMapperBuilder.java:94)

at com.baomidou.mybatisplus.spring.MybatisSqlSessionFactoryBean.buildSqlSessionFactory(MybatisSqlSessionFactoryBean.java:583)

```

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/盐析白兔/article/detail/173822