问题:
mybatis的mapper接口方法的参数是一个普通的java对象,但是java对象中包含有list类型的属性,例如我的查询参数模型是
CompanyRecordQueryModel .java
public class CompanyRecordQueryModel extends PaginationViewModel {
private String recordTime;
private String companyType;
private String companyRecordCode;
private String customsCode;
private List<String> customsCodeList;
.....
}
List<String> customsCodeList是要在mybatis的mapper xml 的select中使用的参数。
mapper接口如下:
CebPreCompanyInfoZsMapperExt.java
@SimpleDao
public interface CebPreCompanyInfoZsMapperExt extends CebPreCompanyInfoZsMapper {
List<CompanyRecordResultModel> selectCompanyInfoByPage(CompanyRecordQueryModel companyRecordQueryModel);
}
mapper对应的xml,使用if foreach表达式代码片段如下:
CebPreCompanyInfoZsMapperExt.xml
<select id="selectCompanyInfoByPage" parameterType="com.development.bsws.module.risk.dto.CompanyRecordQueryModel"
resultType="com.development.bsws.module.risk.dto.CompanyRecordResultModel">
select to_char(v.DEC_TIME, 'yyyy-mm-dd') DEC_TIME_STRING,
v.COMPANY_NAME,
v.COMPANY_TYPE,
v.COMPANY_CODE,
......
<if test="recordTime != null and recordTime != ''">
and v.DEC_TIME = to_date(#{recordTime,jdbcType=VARCHAR}, 'yyyy-mm-dd')
</if>
<if test="companyType != null and companyType != ''">
and v.COMPANY_TYPE like '%'||#{companyType,jdbcType=VARCHAR}||'%'
</if>
<if test="companyRecordCode != null and companyRecordCode != ''">
and v.COMPANY_CODE like '%'||#{companyRecordCode,jdbcType=VARCHAR}||'%'
</if>
<if test="customsCodeList != null and customsCodeList.size() > 0">
and v.CUSTOMS_CODE in
<foreach item="item" index="index" collection="customsCodeList" open="(" separator="," close=")">
#{item}
</foreach>
</if>
order by v.DEC_TIME desc
</select>
这种写法不行,运行后会报异常,list类型的参数没有被正确解析。
解决方法一:
这个博客的解决方法,将
#{item}
改成
#{customsCodeList[${index}],jdbcType=VARCHAR},
可以正常运行。
在此感谢你的解决办法。
解决方法二:
1. 修改mapper接口方法的参数,增加注解
@Param("companyRecordQueryModel"),
名字
companyRecordQueryModel
随便起
List<CompanyRecordResultModel> selectCompanyInfoByPage(@Param("companyRecordQueryModel") CompanyRecordQueryModel companyRecordQueryModel);
2. 修改if表达式语句,都加上名字
companyRecordQueryModel,
重点是collection改成companyRecordQueryModel.customsCodeList
<if test="companyRecordQueryModel.customsCodeList != null and companyRecordQueryModel.customsCodeList.size() > 0">
and v.CUSTOMS_CODE in
<foreach item="item" index="index" collection="companyRecordQueryModel.customsCodeList" open="(" separator="," close=")">
#{item}
</foreach>
</if>
这样也可以正常运行。