总是提示sql语法错误

总是提示sql语法错误

报错信息：

D:\Java\jdk1.8.0_162\bin\java.exe "-javaagent:D:\Program Files\JetBrains\IntelliJ IDEA 2020.2.4\lib\idea_rt.jar=7532:D:\Program Files\JetBrains\IntelliJ IDEA 2020.2.4\bin" -Dfile.encoding=UTF-8 -classpath D:\Java\jdk1.8.0_162\jre\lib\charsets.jar;D:\Java\jdk1.8.0_162\jre\lib\deploy.jar;D:\Java\jdk1.8.0_162\jre\lib\ext\access-bridge-64.jar;D:\Java\jdk1.8.0_162\jre\lib\ext\cldrdata.jar;D:\Java\jdk1.8.0_162\jre\lib\ext\dnsns.jar;D:\Java\jdk1.8.0_162\jre\lib\ext\jaccess.jar;D:\Java\jdk1.8.0_162\jre\lib\ext\jfxrt.jar;D:\Java\jdk1.8.0_162\jre\lib\ext\localedata.jar;D:\Java\jdk1.8.0_162\jre\lib\ext\nashorn.jar;D:\Java\jdk1.8.0_162\jre\lib\ext\sunec.jar;D:\Java\jdk1.8.0_162\jre\lib\ext\sunjce_provider.jar;D:\Java\jdk1.8.0_162\jre\lib\ext\sunmscapi.jar;D:\Java\jdk1.8.0_162\jre\lib\ext\sunpkcs11.jar;D:\Java\jdk1.8.0_162\jre\lib\ext\zipfs.jar;D:\Java\jdk1.8.0_162\jre\lib\javaws.jar;D:\Java\jdk1.8.0_162\jre\lib\jce.jar;D:\Java\jdk1.8.0_162\jre\lib\jfr.jar;D:\Java\jdk1.8.0_162\jre\lib\jfxswt.jar;D:\Java\jdk1.8.0_162\jre\lib\jsse.jar;D:\Java\jdk1.8.0_162\jre\lib\management-agent.jar;D:\Java\jdk1.8.0_162\jre\lib\plugin.jar;D:\Java\jdk1.8.0_162\jre\lib\resources.jar;D:\Java\jdk1.8.0_162\jre\lib\rt.jar;D:\Java\jdk1.8.0_162\src.zip;D:\Java\jdk1.8.0_162\lib\tools.jar;E:\workspace\idea\源代码\商城项目\mall_springcloud\cloud_mall-advertisement\target\classes;C:\Users\JPF\.m2\repository\org\springframework\boot\spring-boot-starter-web\2.1.12.RELEASE\spring-boot-starter-web-2.1.12.RELEASE.jar;C:\Users\JPF\.m2\repository\org\springframework\boot\spring-boot-starter-json\2.1.12.RELEASE\spring-boot-starter-json-2.1.12.RELEASE.jar;C:\Users\JPF\.m2\repository\com\fasterxml\jackson\core\jackson-databind\2.9.10.2\jackson-databind-2.9.10.2.jar;C:\Users\JPF\.m2\repository\com\fasterxml\jackson\datatype\jackson-datatype-jdk8\2.9.10\jackson-datatype-jdk8-2.9.10.jar;C:\Users\JPF\.m2\repository\com\fasterxml\jackson\datatype\jackson-datatype-jsr310\2.9.10\jackson-datatype-jsr310-2.9.10.jar;C:\Users\JPF\.m2\repository\com\fasterxml\jackson\module\jackson-module-parameter-names\2.9.10\jackson-module-parameter-names-2.9.10.jar;C:\Users\JPF\.m2\repository\org\springframework\boot\spring-boot-starter-tomcat\2.1.12.RELEASE\spring-boot-starter-tomcat-2.1.12.RELEASE.jar;C:\Users\JPF\.m2\repository\org\apache\tomcat\embed\tomcat-embed-core\9.0.30\tomcat-embed-core-9.0.30.jar;C:\Users\JPF\.m2\repository\org\apache\tomcat\embed\tomcat-embed-el\9.0.30\tomcat-embed-el-9.0.30.jar;C:\Users\JPF\.m2\repository\org\apache\tomcat\embed\tomcat-embed-websocket\9.0.30\tomcat-embed-websocket-9.0.30.jar;C:\Users\JPF\.m2\repository\org\hibernate\validator\hibernate-validator\6.0.18.Final\hibernate-validator-6.0.18.Final.jar;C:\Users\JPF\.m2\repository\javax\validation\validation-api\2.0.1.Final\validation-api-2.0.1.Final.jar;C:\Users\JPF\.m2\repository\org\jboss\logging\jboss-logging\3.3.3.Final\jboss-logging-3.3.3.Final.jar;C:\Users\JPF\.m2\repository\org\springframework\spring-web\5.1.13.RELEASE\spring-web-5.1.13.RELEASE.jar;C:\Users\JPF\.m2\repository\org\springframework\spring-beans\5.1.13.RELEASE\spring-beans-5.1.13.RELEASE.jar;C:\Users\JPF\.m2\repository\org\springframework\spring-webmvc\5.1.13.RELEASE\spring-webmvc-5.1.13.RELEASE.jar;C:\Users\JPF\.m2\repository\org\springframework\spring-aop\5.1.13.RELEASE\spring-aop-5.1.13.RELEASE.jar;C:\Users\JPF\.m2\repository\org\springframework\spring-context\5.1.13.RELEASE\spring-context-5.1.13.RELEASE.jar;C:\Users\JPF\.m2\repository\org\springframework\spring-expression\5.1.13.RELEASE\spring-expression-5.1.13.RELEASE.jar;C:\Users\JPF\.m2\repository\mysql\mysql-connector-java\8.0.19\mysql-connector-java-8.0.19.jar;C:\Users\JPF\.m2\repository\org\mybatis\spring\boot\mybatis-spring-boot-starter\2.1.1\mybatis-spring-boot-starter-2.1.1.jar;C:\Users\JPF\.m2\repository\org\springframework\boot\spring-boot-starter-jdbc\2.1.12.RELEASE\spring-boot-starter-jdbc-2.1.12.RELEASE.jar;C:\Users\JPF\.m2\repository\com\zaxxer\HikariCP\3.2.0\HikariCP-3.2.0.jar;C:\Users\JPF\.m2\repository\org\springframework\spring-jdbc\5.1.13.RELEASE\spring-jdbc-5.1.13.RELEASE.jar;C:\Users\JPF\.m2\repository\org\mybatis\spring\boot\mybatis-spring-boot-autoconfigure\2.1.1\mybatis-spring-boot-autoconfigure-2.1.1.jar;C:\Users\JPF\.m2\repository\org\mybatis\mybatis\3.5.3\mybatis-3.5.3.jar;C:\Users\JPF\.m2\repository\org\mybatis\mybatis-spring\2.0.3\mybatis-spring-2.0.3.jar;C:\Users\JPF\.m2\repository\org\springframework\cloud\spring-cloud-starter-netflix-eureka-client\2.1.5.RELEASE\spring-cloud-starter-netflix-eureka-client-2.1.5.RELEASE.jar;C:\Users\JPF\.m2\repository\org\springframework\cloud\spring-cloud-starter\2.1.5.RELEASE\spring-cloud-starter-2.1.5.RELEASE.jar;C:\Users\JPF\.m2\repository\org\springframework\cloud\spring-cloud-context\2.1.5.RELEASE\spring-cloud-context-2.1.5.RELEASE.jar;C:\Users\JPF\.m2\repository\org\springframework\security\spring-security-rsa\1.0.9.RELEASE\spring-security-rsa-1.0.9.RELEASE.jar;C:\Users\JPF\.m2\repository\org\bouncycastle\bcpkix-jdk15on\1.64\bcpkix-jdk15on-1.64.jar;C:\Users\JPF\.m2\repository\org\bouncycastle\bcprov-jdk15on\1.64\bcprov-jdk15on-1.64.jar;C:\Users\JPF\.m2\repository\org\springframework\cloud\spring-cloud-netflix-hystrix\2.1.5.RELEASE\spring-cloud-netflix-hystrix-2.1.5.RELEASE.jar;C:\Users\JPF\.m2\repository\org\springframework\boot\spring-boot-starter-aop\2.1.12.RELEASE\spring-boot-starter-aop-2.1.12.RELEASE.jar;C:\Users\JPF\.m2\repository\org\aspectj\aspectjweaver\1.9.5\aspectjweaver-1.9.5.jar;C:\Users\JPF\.m2\repository\org\springframework\cloud\spring-cloud-netflix-eureka-client\2.1.5.RELEASE\spring-cloud-netflix-eureka-client-2.1.5.RELEASE.jar;C:\Users\JPF\.m2\repository\com\netflix\eureka\eureka-client\1.9.13\eureka-client-1.9.13.jar;C:\Users\JPF\.m2\repository\org\codehaus\jettison\jettison\1.3.7\jettison-1.3.7.jar;C:\Users\JPF\.m2\repository\stax\stax-api\1.0.1\stax-api-1.0.1.jar;C:\Users\JPF\.m2\repository\com\netflix\netflix-commons\netflix-eventbus\0.3.0\netflix-eventbus-0.3.0.jar;C:\Users\JPF\.m2\repository\com\netflix\netflix-commons\netflix-infix\0.3.0\netflix-infix-0.3.0.jar;C:\Users\JPF\.m2\repository\commons-jxpath\commons-jxpath\1.3\commons-jxpath-1.3.jar;C:\Users\JPF\.m2\repository\joda-time\joda-time\2.10.5\joda-time-2.10.5.jar;C:\Users\JPF\.m2\repository\org\antlr\antlr-runtime\3.4\antlr-runtime-3.4.jar;C:\Users\JPF\.m2\repository\org\antlr\stringtemplate\3.2.1\stringtemplate-3.2.1.jar;C:\Users\JPF\.m2\repository\antlr\antlr\2.7.7\antlr-2.7.7.jar;C:\Users\JPF\.m2\repository\com\google\code\gson\gson\2.8.6\gson-2.8.6.jar;C:\Users\JPF\.m2\repository\org\apache\commons\commons-math\2.2\commons-math-2.2.jar;C:\Users\JPF\.m2\repository\com\netflix\archaius\archaius-core\0.7.6\archaius-core-0.7.6.jar;C:\Users\JPF\.m2\repository\javax\ws\rs\jsr311-api\1.1.1\jsr311-api-1.1.1.jar;C:\Users\JPF\.m2\repository\com\netflix\servo\servo-core\0.12.21\servo-core-0.12.21.jar;C:\Users\JPF\.m2\repository\com\sun\jersey\jersey-core\1.19.1\jersey-core-1.19.1.jar;C:\Users\JPF\.m2\repository\com\sun\jersey\jersey-client\1.19.1\jersey-client-1.19.1.jar;C:\Users\JPF\.m2\repository\com\sun\jersey\contribs\jersey-apache-client4\1.19.1\jersey-apache-client4-1.19.1.jar;C:\Users\JPF\.m2\repository\org\apache\httpcomponents\httpclient\4.5.10\httpclient-4.5.10.jar;C:\Users\JPF\.m2\repository\org\apache\httpcomponents\httpcore\4.4.13\httpcore-4.4.13.jar;C:\Users\JPF\.m2\repository\commons-codec\commons-codec\1.11\commons-codec-1.11.jar;C:\Users\JPF\.m2\repository\com\google\inject\guice\4.1.0\guice-4.1.0.jar;C:\Users\JPF\.m2\repository\javax\inject\javax.inject\1\javax.inject-1.jar;C:\Users\JPF\.m2\repository\aopalliance\aopalliance\1.0\aopalliance-1.0.jar;C:\Users\JPF\.m2\repository\com\fasterxml\jackson\core\jackson-annotations\2.9.10\jackson-annotations-2.9.10.jar;C:\Users\JPF\.m2\repository\com\fasterxml\jackson\core\jackson-core\2.9.10\jackson-core-2.9.10.jar;C:\Users\JPF\.m2\repository\com\netflix\eureka\eureka-core\1.9.13\eureka-core-1.9.13.jar;C:\Users\JPF\.m2\repository\com\fasterxml\woodstox\woodstox-core\5.0.3\woodstox-core-5.0.3.jar;C:\Users\JPF\.m2\repository\org\codehaus\woodstox\stax2-api\3.1.4\stax2-api-3.1.4.jar;C:\Users\JPF\.m2\repository\org\springframework\cloud\spring-cloud-starter-netflix-archaius\2.1.5.RELEASE\spring-cloud-starter-netflix-archaius-2.1.5.RELEASE.jar;C:\Users\JPF\.m2\repository\org\springframework\cloud\spring-cloud-netflix-ribbon\2.1.5.RELEASE\spring-cloud-netflix-ribbon-2.1.5.RELEASE.jar;C:\Users\JPF\.m2\repository\org\springframework\cloud\spring-cloud-netflix-archaius\2.1.5.RELEASE\spring-cloud-netflix-archaius-2.1.5.RELEASE.jar;C:\Users\JPF\.m2\repository\commons-configuration\commons-configuration\1.8\commons-configuration-1.8.jar;C:\Users\JPF\.m2\repository\commons-lang\commons-lang\2.6\commons-lang-2.6.jar;C:\Users\JPF\.m2\repository\org\springframework\cloud\spring-cloud-starter-netflix-ribbon\2.1.5.RELEASE\spring-cloud-starter-netflix-ribbon-2.1.5.RELEASE.jar;C:\Users\JPF\.m2\repository\com\netflix\ribbon\ribbon\2.3.0\ribbon-2.3.0.jar;C:\Users\JPF\.m2\repository\com\netflix\ribbon\ribbon-transport\2.3.0\ribbon-transport-2.3.0.jar;C:\Users\JPF\.m2\repository\io\reactivex\rxnetty-contexts\0.4.9\rxnetty-contexts-0.4.9.jar;C:\Users\JPF\.m2\repository\io\reactivex\rxnetty-servo\0.4.9\rxnetty-servo-0.4.9.jar;C:\Users\JPF\.m2\repository\io\reactivex\rxnetty\0.4.9\rxnetty-0.4.9.jar;C:\Users\JPF\.m2\repository\com\netflix\ribbon\ribbon-core\2.3.0\ribbon-core-2.3.0.jar;C:\Users\JPF\.m2\repository\com\netflix\ribbon\ribbon-httpclient\2.3.0\ribbon-httpclient-2.3.0.jar;C:\Users\JPF\.m2\repository\commons-collections\commons-collections\3.2.2\commons-collections-3.2.2.jar;C:\Users\JPF\.m2\repository\com\netflix\netflix-commons\netflix-commons-util\0.3.0\netflix-commons-util-0.3.0.jar;C:\Users\JPF\.m2\repository\com\netflix\ribbon\ribbon-loadbalancer\2.3.0\ribbon-loadbalancer-2.3.0.jar;C:\Users\JPF\.m2\repository\com\netflix\netflix-commons\netflix-statistics\0.1.1\netflix-statistics-0.1.1.jar;C:\Users\JPF\.m2\repository\io\reactivex\rxjava\1.3.8\rxjava-1.3.8.jar;C:\Users\JPF\.m2\repository\com\netflix\ribbon\ribbon-eureka\2.3.0\ribbon-eureka-2.3.0.jar;C:\Users\JPF\.m2\repository\com\thoughtworks\xstream\xstream\1.4.11.1\xstream-1.4.11.1.jar;C:\Users\JPF\.m2\repository\xmlpull\xmlpull\1.1.3.1\xmlpull-1.1.3.1.jar;C:\Users\JPF\.m2\repository\xpp3\xpp3_min\1.1.4c\xpp3_min-1.1.4c.jar;C:\Users\JPF\.m2\repository\org\springframework\boot\spring-boot-starter-data-redis\2.1.12.RELEASE\spring-boot-starter-data-redis-2.1.12.RELEASE.jar;C:\Users\JPF\.m2\repository\org\springframework\data\spring-data-redis\2.1.15.RELEASE\spring-data-redis-2.1.15.RELEASE.jar;C:\Users\JPF\.m2\repository\org\springframework\data\spring-data-keyvalue\2.1.15.RELEASE\spring-data-keyvalue-2.1.15.RELEASE.jar;C:\Users\JPF\.m2\repository\org\springframework\data\spring-data-commons\2.1.15.RELEASE\spring-data-commons-2.1.15.RELEASE.jar;C:\Users\JPF\.m2\repository\org\springframework\spring-tx\5.1.13.RELEASE\spring-tx-5.1.13.RELEASE.jar;C:\Users\JPF\.m2\repository\org\springframework\spring-oxm\5.1.13.RELEASE\spring-oxm-5.1.13.RELEASE.jar;C:\Users\JPF\.m2\repository\org\springframework\spring-context-support\5.1.13.RELEASE\spring-context-support-5.1.13.RELEASE.jar;C:\Users\JPF\.m2\repository\io\lettuce\lettuce-core\5.1.8.RELEASE\lettuce-core-5.1.8.RELEASE.jar;C:\Users\JPF\.m2\repository\io\netty\netty-common\4.1.45.Final\netty-common-4.1.45.Final.jar;C:\Users\JPF\.m2\repository\io\netty\netty-handler\4.1.45.Final\netty-handler-4.1.45.Final.jar;C:\Users\JPF\.m2\repository\io\netty\netty-buffer\4.1.45.Final\netty-buffer-4.1.45.Final.jar;C:\Users\JPF\.m2\repository\io\netty\netty-codec\4.1.45.Final\netty-codec-4.1.45.Final.jar;C:\Users\JPF\.m2\repository\io\netty\netty-transport\4.1.45.Final\netty-transport-4.1.45.Final.jar;C:\Users\JPF\.m2\repository\io\netty\netty-resolver\4.1.45.Final\netty-resolver-4.1.45.Final.jar;C:\Users\JPF\.m2\repository\io\projectreactor\reactor-core\3.2.14.RELEASE\reactor-core-3.2.14.RELEASE.jar;C:\Users\JPF\.m2\repository\org\reactivestreams\reactive-streams\1.0.3\reactive-streams-1.0.3.jar;C:\Users\JPF\.m2\repository\org\springframework\session\spring-session-data-redis\2.1.9.RELEASE\spring-session-data-redis-2.1.9.RELEASE.jar;C:\Users\JPF\.m2\repository\org\springframework\session\spring-session-core\2.1.9.RELEASE\spring-session-core-2.1.9.RELEASE.jar;C:\Users\JPF\.m2\repository\org\springframework\spring-jcl\5.1.13.RELEASE\spring-jcl-5.1.13.RELEASE.jar;C:\Users\JPF\.m2\repository\org\springframework\cloud\spring-cloud-starter-openfeign\2.1.5.RELEASE\spring-cloud-starter-openfeign-2.1.5.RELEASE.jar;C:\Users\JPF\.m2\repository\org\springframework\cloud\spring-cloud-openfeign-core\2.1.5.RELEASE\spring-cloud-openfeign-core-2.1.5.RELEASE.jar;C:\Users\JPF\.m2\repository\io\github\openfeign\form\feign-form-spring\3.8.0\feign-form-spring-3.8.0.jar;C:\Users\JPF\.m2\repository\io\github\openfeign\form\feign-form\3.8.0\feign-form-3.8.0.jar;C:\Users\JPF\.m2\repository\commons-fileupload\commons-fileupload\1.4\commons-fileupload-1.4.jar;C:\Users\JPF\.m2\repository\commons-io\commons-io\2.2\commons-io-2.2.jar;C:\Users\JPF\.m2\repository\org\springframework\cloud\spring-cloud-commons\2.1.5.RELEASE\spring-cloud-commons-2.1.5.RELEASE.jar;C:\Users\JPF\.m2\repository\org\springframework\security\spring-security-crypto\5.1.7.RELEASE\spring-security-crypto-5.1.7.RELEASE.jar;C:\Users\JPF\.m2\repository\io\github\openfeign\feign-core\10.4.0\feign-core-10.4.0.jar;C:\Users\JPF\.m2\repository\io\github\openfeign\feign-slf4j\10.4.0\feign-slf4j-10.4.0.jar;C:\Users\JPF\.m2\repository\io\github\openfeign\feign-hystrix\10.4.0\feign-hystrix-10.4.0.jar;C:\Users\JPF\.m2\repository\com\netflix\hystrix\hystrix-core\1.5.18\hystrix-core-1.5.18.jar;C:\Users\JPF\.m2\repository\org\hdrhistogram\HdrHistogram\2.1.9\HdrHistogram-2.1.9.jar;E:\workspace\idea\源代码\商城项目\mall_springcloud\cloud_mall-user\target\classes;E:\workspace\idea\源代码\商城项目\mall_springcloud\cloud_mall-common\target\classes;C:\Users\JPF\.m2\repository\com\google\zxing\core\3.3.3\core-3.3.3.jar;C:\Users\JPF\.m2\repository\com\google\zxing\javase\3.3.3\javase-3.3.3.jar;C:\Users\JPF\.m2\repository\com\beust\jcommander\1.72\jcommander-1.72.jar;C:\Users\JPF\.m2\repository\com\github\jai-imageio\jai-imageio-core\1.4.0\jai-imageio-core-1.4.0.jar;C:\Users\JPF\.m2\repository\org\springframework\boot\spring-boot-starter\2.1.12.RELEASE\spring-boot-starter-2.1.12.RELEASE.jar;C:\Users\JPF\.m2\repository\org\springframework\boot\spring-boot\2.1.12.RELEASE\spring-boot-2.1.12.RELEASE.jar;C:\Users\JPF\.m2\repository\org\springframework\boot\spring-boot-autoconfigure\2.1.12.RELEASE\spring-boot-autoconfigure-2.1.12.RELEASE.jar;C:\Users\JPF\.m2\repository\org\springframework\boot\spring-boot-starter-logging\2.1.12.RELEASE\spring-boot-starter-logging-2.1.12.RELEASE.jar;C:\Users\JPF\.m2\repository\ch\qos\logback\logback-classic\1.2.3\logback-classic-1.2.3.jar;C:\Users\JPF\.m2\repository\ch\qos\logback\logback-core\1.2.3\logback-core-1.2.3.jar;C:\Users\JPF\.m2\repository\org\apache\logging\log4j\log4j-to-slf4j\2.11.2\log4j-to-slf4j-2.11.2.jar;C:\Users\JPF\.m2\repository\org\apache\logging\log4j\log4j-api\2.11.2\log4j-api-2.11.2.jar;C:\Users\JPF\.m2\repository\org\slf4j\jul-to-slf4j\1.7.30\jul-to-slf4j-1.7.30.jar;C:\Users\JPF\.m2\repository\javax\annotation\javax.annotation-api\1.3.2\javax.annotation-api-1.3.2.jar;C:\Users\JPF\.m2\repository\org\springframework\spring-core\5.1.13.RELEASE\spring-core-5.1.13.RELEASE.jar;C:\Users\JPF\.m2\repository\org\yaml\snakeyaml\1.23\snakeyaml-1.23.jar;C:\Users\JPF\.m2\repository\net\bytebuddy\byte-buddy\1.9.16\byte-buddy-1.9.16.jar;C:\Users\JPF\.m2\repository\io\springfox\springfox-swagger2\2.9.2\springfox-swagger2-2.9.2.jar;C:\Users\JPF\.m2\repository\io\swagger\swagger-annotations\1.5.20\swagger-annotations-1.5.20.jar;C:\Users\JPF\.m2\repository\io\swagger\swagger-models\1.5.20\swagger-models-1.5.20.jar;C:\Users\JPF\.m2\repository\io\springfox\springfox-spi\2.9.2\springfox-spi-2.9.2.jar;C:\Users\JPF\.m2\repository\io\springfox\springfox-core\2.9.2\springfox-core-2.9.2.jar;C:\Users\JPF\.m2\repository\io\springfox\springfox-schema\2.9.2\springfox-schema-2.9.2.jar;C:\Users\JPF\.m2\repository\io\springfox\springfox-swagger-common\2.9.2\springfox-swagger-common-2.9.2.jar;C:\Users\JPF\.m2\repository\io\springfox\springfox-spring-web\2.9.2\springfox-spring-web-2.9.2.jar;C:\Users\JPF\.m2\repository\com\google\guava\guava\20.0\guava-20.0.jar;C:\Users\JPF\.m2\repository\com\fasterxml\classmate\1.4.0\classmate-1.4.0.jar;C:\Users\JPF\.m2\repository\org\slf4j\slf4j-api\1.7.30\slf4j-api-1.7.30.jar;C:\Users\JPF\.m2\repository\org\springframework\plugin\spring-plugin-core\1.2.0.RELEASE\spring-plugin-core-1.2.0.RELEASE.jar;C:\Users\JPF\.m2\repository\org\springframework\plugin\spring-plugin-metadata\1.2.0.RELEASE\spring-plugin-metadata-1.2.0.RELEASE.jar;C:\Users\JPF\.m2\repository\org\mapstruct\mapstruct\1.2.0.Final\mapstruct-1.2.0.Final.jar;C:\Users\JPF\.m2\repository\io\springfox\springfox-swagger-ui\2.9.2\springfox-swagger-ui-2.9.2.jar com.bo.mall.springcloud.advertisement.AdvertisementApplication

  .   ____          _            __ _ _
 /\\ / ___'_ __ _ _(_)_ __  __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
 \\/  ___)| |_)| | | | | || (_| |  ) ) ) )
  '  |____| .__|_| |_|_| |_\__, | / / / /
 =========|_|==============|___/=/_/_/_/
 :: Spring Boot ::       (v2.1.12.RELEASE)

18:38:23.631 - INFO 1400 --- [           main] c.b.m.s.a.AdvertisementApplication       : No active profile set, falling back to default profiles: default
18:38:24.527 - INFO 1400 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Multiple Spring Data modules found, entering strict repository configuration mode!
18:38:24.531 - INFO 1400 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data Redis repositories in DEFAULT mode.
18:38:24.573 - INFO 1400 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 23ms. Found 0 Redis repository interfaces.
18:38:25.120 - INFO 1400 --- [           main] o.s.cloud.context.scope.GenericScope     : BeanFactory id=a809c9bd-62b4-37d9-bac3-9f58ff0faf84
18:38:25.303 - INFO 1400 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration' of type [org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration$$EnhancerBySpringCGLIB$$2709a18b] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
18:38:26.759 - INFO 1400 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat initialized with port(s): 8084 (http)
18:38:26.794 - INFO 1400 --- [           main] o.apache.catalina.core.StandardService   : Starting service [Tomcat]
18:38:26.795 - INFO 1400 --- [           main] org.apache.catalina.core.StandardEngine  : Starting Servlet engine: [Apache Tomcat/9.0.30]
18:38:27.078 - INFO 1400 --- [           main] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring embedded WebApplicationContext
18:38:27.078 - INFO 1400 --- [           main] o.s.web.context.ContextLoader            : Root WebApplicationContext: initialization completed in 3421 ms
18:38:28.375 - INFO 1400 --- [           main] io.lettuce.core.EpollProvider            : Starting without optional epoll library
18:38:28.377 - INFO 1400 --- [           main] io.lettuce.core.KqueueProvider           : Starting without optional kqueue library
18:38:29.931 - WARN 1400 --- [           main] c.n.c.sources.URLConfigurationSource     : No URLs will be polled as dynamic configuration sources.
18:38:29.931 - INFO 1400 --- [           main] c.n.c.sources.URLConfigurationSource     : To enable URLs as dynamic configuration sources, define System property archaius.configurationSource.additionalUrls or make config.properties available on classpath.
18:38:29.940 - WARN 1400 --- [           main] c.n.c.sources.URLConfigurationSource     : No URLs will be polled as dynamic configuration sources.
18:38:29.940 - INFO 1400 --- [           main] c.n.c.sources.URLConfigurationSource     : To enable URLs as dynamic configuration sources, define System property archaius.configurationSource.additionalUrls or make config.properties available on classpath.
18:38:30.267 - INFO 1400 --- [           main] o.s.s.concurrent.ThreadPoolTaskExecutor  : Initializing ExecutorService 'applicationTaskExecutor'
18:38:34.238 - INFO 1400 --- [           main] o.s.c.n.eureka.InstanceInfoFactory       : Setting initial instance status as: STARTING
18:38:34.302 - INFO 1400 --- [           main] com.netflix.discovery.DiscoveryClient    : Initializing Eureka in region us-east-1
18:38:35.589 - INFO 1400 --- [           main] c.n.d.provider.DiscoveryJerseyProvider   : Using JSON encoding codec LegacyJacksonJson
18:38:35.590 - INFO 1400 --- [           main] c.n.d.provider.DiscoveryJerseyProvider   : Using JSON decoding codec LegacyJacksonJson
18:38:36.082 - INFO 1400 --- [           main] c.n.d.provider.DiscoveryJerseyProvider   : Using XML encoding codec XStreamXml
18:38:36.082 - INFO 1400 --- [           main] c.n.d.provider.DiscoveryJerseyProvider   : Using XML decoding codec XStreamXml
18:38:36.323 - INFO 1400 --- [           main] c.n.d.s.r.aws.ConfigClusterResolver      : Resolving eureka endpoints via configuration
18:38:37.072 - INFO 1400 --- [           main] com.netflix.discovery.DiscoveryClient    : Disable delta property : false
18:38:37.072 - INFO 1400 --- [           main] com.netflix.discovery.DiscoveryClient    : Single vip registry refresh property : null
18:38:37.072 - INFO 1400 --- [           main] com.netflix.discovery.DiscoveryClient    : Force full registry fetch : false
18:38:37.072 - INFO 1400 --- [           main] com.netflix.discovery.DiscoveryClient    : Application is null : false
18:38:37.072 - INFO 1400 --- [           main] com.netflix.discovery.DiscoveryClient    : Registered Applications size is zero : true
18:38:37.072 - INFO 1400 --- [           main] com.netflix.discovery.DiscoveryClient    : Application version is -1: true
18:38:37.072 - INFO 1400 --- [           main] com.netflix.discovery.DiscoveryClient    : Getting all instance registry info from the eureka server
18:38:37.298 - INFO 1400 --- [           main] com.netflix.discovery.DiscoveryClient    : The response status is 200
18:38:37.301 - INFO 1400 --- [           main] com.netflix.discovery.DiscoveryClient    : Starting heartbeat executor: renew interval is: 30
18:38:37.305 - INFO 1400 --- [           main] c.n.discovery.InstanceInfoReplicator     : InstanceInfoReplicator onDemand update allowed rate per min is 4
18:38:37.309 - INFO 1400 --- [           main] com.netflix.discovery.DiscoveryClient    : Discovery Client initialized at timestamp 1624876717307 with initial instances count: 3
18:38:37.311 - INFO 1400 --- [           main] o.s.c.n.e.s.EurekaServiceRegistry        : Registering application CLOUD-MALL-ADVERTISEMENT with eureka with status UP
18:38:37.311 - INFO 1400 --- [           main] com.netflix.discovery.DiscoveryClient    : Saw local status change event StatusChangeEvent [timestamp=1624876717311, current=UP, previous=STARTING]
18:38:37.314 - INFO 1400 --- [nfoReplicator-0] com.netflix.discovery.DiscoveryClient    : DiscoveryClient_CLOUD-MALL-ADVERTISEMENT/bobo:cloud-mall-advertisement:8084: registering service...
18:38:37.378 - INFO 1400 --- [nfoReplicator-0] com.netflix.discovery.DiscoveryClient    : DiscoveryClient_CLOUD-MALL-ADVERTISEMENT/bobo:cloud-mall-advertisement:8084 - registration status: 204
18:38:37.859 - INFO 1400 --- [           main] s.a.ScheduledAnnotationBeanPostProcessor : No TaskScheduler/ScheduledExecutorService bean found for scheduled processing
18:38:37.882 - INFO 1400 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat started on port(s): 8084 (http) with context path ''
18:38:37.882 - INFO 1400 --- [           main] .s.c.n.e.s.EurekaAutoServiceRegistration : Updating port to 8084
18:38:39.088 - INFO 1400 --- [           main] c.b.m.s.a.AdvertisementApplication       : Started AdvertisementApplication in 19.653 seconds (JVM running for 20.727)
18:38:46.037 - INFO 1400 --- [nio-8084-exec-1] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring DispatcherServlet 'dispatcherServlet'
18:38:46.037 - INFO 1400 --- [nio-8084-exec-1] o.s.web.servlet.DispatcherServlet        : Initializing Servlet 'dispatcherServlet'
18:38:46.045 - INFO 1400 --- [nio-8084-exec-1] o.s.web.servlet.DispatcherServlet        : Completed initialization in 7 ms
18:38:46.149 - INFO 1400 --- [nio-8084-exec-1] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...
18:38:46.532 - INFO 1400 --- [nio-8084-exec-1] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Start completed.
18:38:46.785 -ERROR 1400 --- [nio-8084-exec-1] o.a.c.c.C.[.[.[/].[dispatcherServlet]    : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException: 
### Error updating database.  Cause: java.sql.SQLSyntaxErrorException: 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 '' at line 1
### The error may exist in file [E:\workspace\idea\源代码\商城项目\mall_springcloud\cloud_mall-advertisement\target\classes\mappers\AdvertisementMapper.xml]
### The error may involve com.bo.mall.springcloud.advertisement.model.dao.AdvertisementMapper.insertSelective-Inline
### The error occurred while setting parameters
### SQL: insert into imooc_mall_advertisement
### Cause: java.sql.SQLSyntaxErrorException: 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 '' at line 1
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: 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 '' at line 1] with root cause

java.sql.SQLSyntaxErrorException: 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 '' at line 1
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) ~[mysql-connector-java-8.0.19.jar:8.0.19]
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.19.jar:8.0.19]
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.19.jar:8.0.19]
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953) ~[mysql-connector-java-8.0.19.jar:8.0.19]
	at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:370) ~[mysql-connector-java-8.0.19.jar:8.0.19]
	at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44) ~[HikariCP-3.2.0.jar:na]
	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java) ~[HikariCP-3.2.0.jar:na]
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:47) ~[mybatis-3.5.3.jar:3.5.3]
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74) ~[mybatis-3.5.3.jar:3.5.3]
	at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50) ~[mybatis-3.5.3.jar:3.5.3]
	at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117) ~[mybatis-3.5.3.jar:3.5.3]
	at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76) ~[mybatis-3.5.3.jar:3.5.3]
	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:197) ~[mybatis-3.5.3.jar:3.5.3]
	at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:184) ~[mybatis-3.5.3.jar:3.5.3]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_162]
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_162]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_162]
	at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_162]
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426) ~[mybatis-spring-2.0.3.jar:2.0.3]
	at com.sun.proxy.$Proxy88.insert(Unknown Source) ~[na:na]
	at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:271) ~[mybatis-spring-2.0.3.jar:2.0.3]
	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:62) ~[mybatis-3.5.3.jar:3.5.3]
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:93) ~[mybatis-3.5.3.jar:3.5.3]
	at com.sun.proxy.$Proxy89.insertSelective(Unknown Source) ~[na:na]
	at com.bo.mall.springcloud.advertisement.service.impl.AdvertisementServiceImpl.addAdvertisement(AdvertisementServiceImpl.java:27) ~[classes/:na]
	at com.bo.mall.springcloud.advertisement.controller.AdvertisementController.addAdvertisement(AdvertisementController.java:20) ~[classes/:na]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_162]
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_162]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_162]
	at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_162]
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190) ~[spring-web-5.1.13.RELEASE.jar:5.1.13.RELEASE]
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138) ~[spring-web-5.1.13.RELEASE.jar:5.1.13.RELEASE]
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105) ~[spring-webmvc-5.1.13.RELEASE.jar:5.1.13.RELEASE]
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:893) ~[spring-webmvc-5.1.13.RELEASE.jar:5.1.13.RELEASE]
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:798) ~[spring-webmvc-5.1.13.RELEASE.jar:5.1.13.RELEASE]
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) ~[spring-webmvc-5.1.13.RELEASE.jar:5.1.13.RELEASE]
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040) ~[spring-webmvc-5.1.13.RELEASE.jar:5.1.13.RELEASE]
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943) ~[spring-webmvc-5.1.13.RELEASE.jar:5.1.13.RELEASE]
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) ~[spring-webmvc-5.1.13.RELEASE.jar:5.1.13.RELEASE]
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909) ~[spring-webmvc-5.1.13.RELEASE.jar:5.1.13.RELEASE]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:660) ~[tomcat-embed-core-9.0.30.jar:9.0.30]
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) ~[spring-webmvc-5.1.13.RELEASE.jar:5.1.13.RELEASE]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) ~[tomcat-embed-core-9.0.30.jar:9.0.30]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) ~[tomcat-embed-core-9.0.30.jar:9.0.30]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.30.jar:9.0.30]
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) ~[tomcat-embed-websocket-9.0.30.jar:9.0.30]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.30.jar:9.0.30]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.30.jar:9.0.30]
	at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100) ~[spring-web-5.1.13.RELEASE.jar:5.1.13.RELEASE]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.1.13.RELEASE.jar:5.1.13.RELEASE]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.30.jar:9.0.30]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.30.jar:9.0.30]
	at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93) ~[spring-web-5.1.13.RELEASE.jar:5.1.13.RELEASE]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.1.13.RELEASE.jar:5.1.13.RELEASE]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.30.jar:9.0.30]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.30.jar:9.0.30]
	at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:94) ~[spring-web-5.1.13.RELEASE.jar:5.1.13.RELEASE]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.1.13.RELEASE.jar:5.1.13.RELEASE]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.30.jar:9.0.30]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.30.jar:9.0.30]
	at org.springframework.session.web.http.SessionRepositoryFilter.doFilterInternal(SessionRepositoryFilter.java:151) ~[spring-session-core-2.1.9.RELEASE.jar:2.1.9.RELEASE]
	at org.springframework.session.web.http.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:86) ~[spring-session-core-2.1.9.RELEASE.jar:2.1.9.RELEASE]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.30.jar:9.0.30]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.30.jar:9.0.30]
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) ~[spring-web-5.1.13.RELEASE.jar:5.1.13.RELEASE]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.1.13.RELEASE.jar:5.1.13.RELEASE]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.30.jar:9.0.30]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.30.jar:9.0.30]
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) ~[tomcat-embed-core-9.0.30.jar:9.0.30]
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-embed-core-9.0.30.jar:9.0.30]
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) [tomcat-embed-core-9.0.30.jar:9.0.30]
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [tomcat-embed-core-9.0.30.jar:9.0.30]
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-embed-core-9.0.30.jar:9.0.30]
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [tomcat-embed-core-9.0.30.jar:9.0.30]
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [tomcat-embed-core-9.0.30.jar:9.0.30]
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:367) [tomcat-embed-core-9.0.30.jar:9.0.30]
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-embed-core-9.0.30.jar:9.0.30]
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:860) [tomcat-embed-core-9.0.30.jar:9.0.30]
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1598) [tomcat-embed-core-9.0.30.jar:9.0.30]
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-embed-core-9.0.30.jar:9.0.30]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [na:1.8.0_162]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [na:1.8.0_162]
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-embed-core-9.0.30.jar:9.0.30]
	at java.lang.Thread.run(Thread.java:748) [na:1.8.0_162]


相关代码：

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.bo.mall.springcloud.advertisement.model.dao.AdvertisementMapper">
  <resultMap id="BaseResultMap" type="com.bo.mall.springcloud.advertisement.model.pojo.Advertisement">
    <id column="id" jdbcType="INTEGER" property="id" />
    <result column="ad_name" jdbcType="VARCHAR" property="adName" />
    <result column="ad_image" jdbcType="VARCHAR" property="adImage" />
    <result column="ad_detail" jdbcType="VARCHAR" property="adDetail" />
  </resultMap>
  <sql id="Base_Column_List">
    `id`,`ad_name`,`ad_image`,`ad_detail`
  </sql>
  <select id="selectByPrimaryKey" parameterType="java.lang.Integer" resultMap="BaseResultMap">
    select 
    <include refid="Base_Column_List" />
    from imooc_mall_advertisement
    where id = #{id,jdbcType=INTEGER}
  </select>
  <select id="selectByName" parameterType="String" resultMap="BaseResultMap">
    select
    <include refid="Base_Column_List" />
    from imooc_mall_advertisement
    where `ad_name` = #{adName,jdbcType=VARCHAR}
  </select>
  <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer">
    delete from imooc_mall_advertisement
    where id = #{id,jdbcType=INTEGER}
  </delete>
  <insert id="insert" parameterType="com.bo.mall.springcloud.advertisement.model.pojo.Advertisement">
    insert into imooc_mall_advertisement (`id`, `ad_name`, `ad_image`,`ad_detail`)
    values (#{id,jdbcType=INTEGER}, #{adName,jdbcType=VARCHAR}, #{adImage,jdbcType=VARCHAR},#{adDetail,jdbcType=VARCHAR})
  </insert>
  <insert id="insertSelective" parameterType="com.bo.mall.springcloud.advertisement.model.pojo.Advertisement">
    insert into imooc_mall_advertisement
    <trim prefix="(" suffix=")" suffixOverrides=",">
      <if test="id != null">
        id,
      </if>
      <if test="adName != null">
        ad_name,
      </if>
      <if test="adImage != null">
        `ad_image`,
      </if>
      <if test="adDetail != null">
        ad_detail,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides=",">
      <if test="id != null">
        #{id,jdbcType=INTEGER},
      </if>
      <if test="adName != null">
        #{adName,jdbcType=VARCHAR},
      </if>
      <if test="adImage != null">
        #{adImage,jdbcType=VARCHAR},
      </if>
      <if test="adDetail != null">
        #{adDetail,jdbcType=VARCHAR},
      </if>
    </trim>
  </insert>
  <update id="updateByPrimaryKeySelective" parameterType="com.bo.mall.springcloud.advertisement.model.pojo.Advertisement">
    update imooc_mall_advertisement
    <set>
      <if test="adName != null">
        `ad_name` = #{adName,jdbcType=VARCHAR},
      </if>
      <if test="adImage != null">
        `ad_image` = #{adImage,jdbcType=VARCHAR},
      </if>
      <if test="adDetail != null">
        `ad_detail` = #{adDetail,jdbcType=VARCHAR},
      </if>
    </set>
    where id = #{id,jdbcType=INTEGER}
  </update>
  <update id="updateByPrimaryKey" parameterType="com.bo.mall.springcloud.advertisement.model.pojo.Advertisement">
    update imooc_mall_advertisement
    set `ad_name` = #{adName,jdbcType=VARCHAR},
      `ad_image` = #{adImage,jdbcType=VARCHAR},
        ad_detail = #{adDetail,jdbcType=VARCHAR}
    where id = #{id,jdbcType=INTEGER}
  </update>
</mapper>
张小毛 2021-06-28
源自：Spring Cloud实现电商项目   8-3 项目作业
6
收起

正在回答 回答被采纳积分+1

登陆购买课程后可参与讨论，去登陆吧

1回答
好帮手慕小尤 2021-06-28 19:04:47

同学你好，根据异常信息，如下所示：可能是insert操作出现了语法错误，则建议同学删除相关sql，然后测试代码试一下，查看是否是insert操作的问题。如果是，则建议同学与课程源码进行对比，查看是否存在语法错误。

http://img1.sycdn.imooc.com//climg/60d9ac7a0945f86009240460.jpg

祝学习愉快！

0
收起回答
问题已解决，确定采纳
还有疑问，暂不采纳

恭喜解决一个难题，获得1积分~

来为老师/同学的回答评分吧

0 星

相似问题

总是显示语法错误
0 0 5
总提示语法错误
23 0 4
老师，我这个sql语句哪里错了呢
13 0 4
sql语句报错？
0 0 10
老师如何把我的ATOM设置成有mysql编辑且显示错误的效果呢?
34 0 5

登录后可查看更多问答，登录/注册

java工程师2020版
  • 参与学习           人
  • 提交作业       9393    份
  • 解答问题       16556    个

综合就业常年第一，编程排行常年霸榜，无需脱产即可学习，北上广深月薪过万 无论你是未就业的学生还是想转行的在职人员，不需要基础，只要你有梦想，想高薪

了解课程

本课精华内容

问答 作业

安装了MySQL 之后有时候自己会跳出来个黑窗口是为什么呢？

79 1

什么时候用List中的ArrayList呢，什么时候用HashSet，什么时候应该用HashMap

81 1

创建字符串的过程理解

62 1

如何干净的卸载数据库

134 1

请教一下没太懂

48 3

查看更多本课问答
请稍等 ...
意见反馈 帮助中心 APP下载
官方微信

在线咨询

领取优惠

免费试听

领取大纲

扫描二维码，添加
你的专属老师