1.查询 :参数是一个集合
<select id="getTopGoodsEval" parameterType="java.util.ArrayList"
resultType="GoodsComment">
selectt.eid,ge.content,ge.goodsidasgoodsIdfrom(selectmax(ge.eid)aseidfromgoods_evaluation gewherege.goodsidin
<foreach collection="values[]"index="index" item="item"open="(" separator=","close=")">#{item}</foreach>andge.isdisplay='0'groupbyge.goodsid ) t,goods_evaluation gewherege.eid=t.eid<lect>
publicGoodsComment getTopGoodsEval(List list);
2.查询:表中所有的数据 (返回数据是一个集合 ,没有参数)
<select id="All" resultMap="BaseResultMap">
select * from 表名
</ select >