遍历数组:
int saveOptions(@Param("items")String[] items, @Param("questionId")int questionId) throws Exception;
insert into options values(#{item},#{questionId},1)
遍历集合:参考之前文章:
20180626:嵌套list遍历
int saveOptions(@Param("list")List> list) throws Exception;
insert into options(optionsName,remark,selectOptions) values(#{item})
其中collection="list"是指遍历的集合名称是list
item="items"是指遍历的每一项别名叫items
20190319传入json:
//传参:
JSONObject jsonParam= newJSONObject();
jsonParam.put("yananId=", 1);
jsonParam.put("yananName=","张三");//接口
List> getListByWhere(@Param("jsonParam")JSONObject jsonParam);//mybatis
select yananId,yananName
from yanan${jsonKey} #{jsonValue}
打印sql:
select yananId,yananName from yanan where yananId=? and yananName =?
==> Parameters: 68(Integer), 张三(String)