MyBatis There is no getter for property named 'xxx' in 'class java.lang.String'

来源：互联网发布：js date 编辑：程序博客网时间：2024/05/17 12:23

1. Code

1.1 mapper xml

[html] view plain copy
 
<select id="getItems" parameterType="string" resultMap="itemResult">...</select>  

[html] view plain copy
 
  

1.2 mapper interface

[java] view plain copy
 
public interface OrderDao {  
    public List<Item> getItems(String orderIds);  
}  

2. Issue

[plain] view plain copy
 
There is no getter for property named 'orderIds' in 'class java.lang.String'  

3. Solution1

[java] view plain copy
 
import org.apache.ibatis.annotations.Param;  
  
public interface OrderDao {  
    public List<Item> getItems(@Param("orderIds") String orderIds);  
}  

4.Solution2

一、发现问题<select id="queryStudentByNum" resultType="student" parameterType="string">  select num,name,phone from student  <where> <if test = " num!=null and num!='' ">AND num = #{num}</if></where></select> Mybatis查询传入一个字符串传参数，报There is no getter for property named 'num' in 'class java.lang.String'。二、解决问题<select id="queryStudentByNum" resultType="student" parameterType="string">  select num,name,phone from student  <where> <if test = " _parameter!=null and_parameter!='' ">AND num = #{_parameter}</if></where></select>无论参数名，都要改成"_parameter"。三、原因分析Mybatis默认采用ONGL解析参数，所以会自动采用对象树的形式取string.num值，引起报错。也可以public List methodName(@Param(value="num") String num)的方法说明参数值参考博客：http://blog.sina.com.cn/s/blog_86e49b8f010191hw.htmlhttp://txin0814.iteye.com/blog/1533645

Reference:

[1] http://stackoverflow.com/questions/19848861/mybatis-dynamic-sql-using-longs

0 0