<selectid="getXXXBeanList"parameterType="java.lang.String"resultType="XXBean">
select t.* from tableName t where t.id= #{id}
</select>
二、多个参数
2.1 java层代码
public List<XXXBean>getXXXBeanList(@Param("id") String xxId,@Param("name") String xxCode);
2.2 xml层代码
<selectid="getXXXBeanList"resultType="XXBean">
select t.* from tableName where id = #{0} and name = #{1}
</select>
三、Map封装多参数
3.1 java层代码
public List<XXXBean>getXXXBeanList(HashMap map);
3.2 xml层代码
<selectid="getXXXBeanList"parameterType="hashmap"resultType="XXBean">
select * from XXX where id=#{xxId} code = #{xxCode}
</select>
四、List封装in
4.1 java层代码
public List<XXXBean>getXXXBeanList(List<String> list);
4.2 xml层代码
<selectid="getXXXBeanList"resultType="XXBean">
select * from XXX where id in
<foreachitem="item"index="index"collection="list"open="("separator=","close=")">
#{item}
</foreach></select>
public List<SysWeb>getSysInfo(Map<String, Object> map){returngetSqlSession().selectList("sysweb.getSysInfo", map);}
4.3 xml层代码
<selectid="getSysInfo"parameterType="java.util.Map"resultType="SysWeb">
SELECT
t.sysSiteId,
t.siteName,
t1.mzNum AS siteTagNum,
t1.mzName AS siteTag,
t.url,
t.iconPath
FROM
TD_WEB_SYSSITE t
LEFT JOIN TD_MZ_MZDY t1 ON t1.mzNum = t.siteTag
AND t1.mzType = 10
WHERE
t.siteTag = #{siteTag }
AND t.sysSiteId NOT IN
<foreachcollection="list"item="item"index="index"open="("close=")"separator=",">
#{item}
</foreach></select>