论坛 › Mybatis › mybatis in

remington_young 发表于 2016-11-24 07:27:23

mybatis in

　　<select id="selectAccountByPKeysAndOtherCondition" resultType="AccountEntity"     resultMap="accountResultMap"> 
        select 'false' as QUERYID,
        <include refid="Base_Column_List" />
        from points_account
        where status=#{status}
        and id in
         <foreach item="item"  collection="ids"  open="(" separator="," close=")"> 
         #{item}  
         </foreach>
         </select>

查看完整版本: mybatis in