mybatis
假期的学习
这个作者很懒,什么都没留下…
展开
-
thymeleaf.TemplateEngineException processing template “main“: An error happened during template pars
前言这个项目是springboot 项目使用thymeleaf模板的,主要错误是前端HTML页面使用thymeleaf获取后台传过来的值有问题(获取不到,或者为空null)错误信息1、第一个错误:转发的用成了重定向 redirect:/main2021-11-18 21:02:01.321 ERROR 9272 — [nio-8082-exec-4] org.thymeleaf.TemplateEngine : [THYMELEAF][http-nio-8082-exec-4原创 2021-11-18 23:04:22 · 2713 阅读 · 0 评论 -
idea中spring boot项目,使用MyBatisPlus分页配置导致# SQL: SELECT id,username,password FROM user LIMIT ? LIMIT ?
1、错误出现的Java文件:mybatis-plus配置类/** * https://mp.baomidou.com/guide/page.html * MyBatisPlus分页插件配置类 */@Configurationpublic class MybatisPlusConfig { // 旧版 /*@Bean public PaginationInterceptor paginationInterceptor() { PaginationInterc原创 2021-11-14 23:03:14 · 446 阅读 · 0 评论 -
java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corres
0、前言,本次错误是spring boot项目中使用mybatis 根据id值查询数据库中一条数据报错1、错误信息2021-11-14 15:37:38.168 ERROR 9936 --- [nio-8086-exec-7] o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Reques原创 2021-11-14 16:22:37 · 2013 阅读 · 0 评论 -
MissingServletRequestParameterException: Required request parameter ‘id‘ for method parameter type I
1、报错信息1.1idea中报错信息Resolved [org.springframework.web.bind.MissingServletRequestParameterException: Required request parameter 'id' for method parameter type Integer is not present]1.2网页报错信息Whitelabel Error PageThis application has no explicit mapping原创 2021-11-14 16:16:41 · 11888 阅读 · 1 评论 -
no Result Maps were found for the Mapped Statement ‘com.feng.mybatis.mapper.
1、错误信息MissingServletRequestParameterExceptionno Result Maps were found for the Mapped Statement 'com.feng.mybatis.mapper.2、对错mapper.xml文件对比<mapper namespace="com.feng.mybatis.mapper.BookMapper"> <!--错误的配置:parameterType--> <!--<原创 2021-11-14 16:07:02 · 394 阅读 · 0 评论 -
Description: Field bookMapper in com.feng.mybatis.service.BookService required a bean of type ‘com.
1、错误Description:Field bookMapper in com.feng.mybatis.service.BookService required a bean of type 'com.feng.mybatis.mapper.BookMapper' that could not be found.The injection point has the following annotations: - @org.springframework.beans.factory.anno原创 2021-11-14 15:33:12 · 653 阅读 · 0 评论 -
Cannot resolve reference to bean ‘sqlSessionFactory‘ while setting constructor argument; nested exce
1.报错信息Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'employeeMapper' defined in file [D:\eclipse\eclipse_new_new\struct\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\ssmTest1_2原创 2021-03-01 15:55:46 · 9263 阅读 · 0 评论 -
Result Maps collection already contains value for com.feng.crud.dao.EmployeeMapper.mapper_resultMap[
1、错误的一些信息:Caused by: org.springframework.core.NestedIOException: Failed to parse mapping resource: 'file [D:\eclipse\eclipse_new_new\maven\ssm-crud3\target\classes\mapper\EmployeeMapper.xml]'; nested exception is org.apache.ibatis.builder.BuilderException原创 2020-12-27 19:54:50 · 333 阅读 · 0 评论 -
Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL synt
下面的第一个代码片段是具体的错误地方和解决方法:(少了一个On) <select id="selectByExampleWithDept" resultMap="WithDeptResultMap"> select <if test="distinct"> distinct </if> <include refid="WithDept_Column_List" /> <!-- from原创 2020-11-15 17:41:00 · 3837 阅读 · 0 评论 -
mybatis-idea-maven项目当mybatis执行insert语句的时候,插入了两条相同的语句解决办法(包括id值为unique时会导致插入报错)2020/10/27
**mybatis用idea创建maven项目学习的时候插入数据错误问题:mybatis执行insert语句的时候,插入了两条相同的语句解决办法(包括id值为unique时会导致插入报错)原创 2020-10-27 08:06:58 · 1003 阅读 · 2 评论