Jo_Andy的专栏

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}%

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) ...