SpringBoot
Jo@mykine
码到成功
展开
-
java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0) 解决办法
mapper有时写的sql不够规范出现java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0) 可能原因:包含多余引号,比如 name like ‘%#{name}%’ 出错案例 @Select({ "SELECT * ", "FROM users", "WHERE name like '%#{name}%原创 2020-08-31 18:39:27 · 1728 阅读 · 0 评论 -
There is no getter for property named ‘xxx‘ in ‘class com.test.project.entity.
SpringBoot 项目使用mapper操作数据库时报错 There is no getter for property named 'xxx' in 'class com.test.project.entity. 可能原因:1.entity字段名写错 2.mapper.xml文件字段或属性名拼写错误(比如mysql字段写成paramStr,实体类属性写成param_str) ...原创 2020-07-14 14:29:58 · 1380 阅读 · 0 评论