多选时用mybatis in 查询 对应模型里面的 控制层 和业务层该怎么写

Question

项目使用的框架spring+ springmvc+ mybatis
数据库：mysql

网上搜的sql是

我的数据层
控制层
业务层

该怎么改呀

最上面的代码可以作为参考 控制层和业务层怎么写

Answer 1

<select id="findEA" resultType="java.util.Map">
    select DISTINCT
    t2.x,t2.y,t2.num,t2.name,t2.en_name,t2.international_code,t2.location,t2.area
    from dt_ear_acupoint_system AS t1
    LEFT JOIN
    dt_ear_acupoint AS t2 ON
    t2.num=t1.acupoint_num
    LEFT JOIN
    dt_ear_disease AS t3 ON
    t3.system_id=t1.system_id
    WHERE t1.system_id IN
    <foreach item="item" index="index" collection="num" open="("
        separator="," close=")">
        #{item}
    </foreach>
    AND
    t3.min_age&lt;=#{min_age} AND max_age &gt;=#{max_age}
    ORDER BY t2.id
    ASC

</select>