mybatis in 查询语句如何书写

2019独角兽企业重金招聘Python工程师标准>>>

String[] arr = param.param.get("content").toString().split(",");

for(int i=0;i<arr.length;i++){

bd.append("'").append(arr[i] ).append("'").append(",");

}

bd.deleteCharAt(bd.toString().length()-1);

bd.append(")");

Map<String,Object> mp = new HashMap<String,Object>();

mp.put("numberLst",bd.toString());

Map<Object, Map<String, Object>> resMp =                          dao.selectMap("MainPageMapper.specialsalescarPushList", mp,  "id" );

sql语句标签

<select id="specialsalescarPushList" parameterType="java.util.HashMap" resultType="java.util.HashMap">

select   number as carNumber,amount as officePrice

from   special_salescar

where number in ${numberLst}

</select>

转载于:https://my.oschina.net/tinglanrmb32/blog/496440