There is no getter for property named 'column' in 'class java.lang.String'] with root cause

近期做项目有一个需求类似这样的:有一个city表,里面有id,name两个字段,前端需要传入选择性的查询出内容,比如传入id就要(select id from city),传入name就要(select name from city),传入id,name就要select id,name from city.

需求大体是这样,我之前写的传值方式是:

 There is no getter for property named 'column' in 'class java.lang.String'] with root cause

     sql的写法是这样的

    There is no getter for property named 'column' in 'class java.lang.String'] with root cause

在运行的时候不出意外的报错了:

 There is no getter for property named 'column' in 'class java.lang.String'] with root cause

解决方法就是:

当参数是String类型的时候,mybatis里面参数统一写成_parameter,

There is no getter for property named 'column' in 'class java.lang.String'] with root cause

问题成功解决~~~


另外这个时候一定要用${},而不是#{},一样的传递“id,name”:

${}传递,sql是这样的:select id,name from city

#{}传递,sql是这样的: select  ‘id,name’ from city