• MyBatis中参数为List


    mapper中写接口,必须加上 @Param("partyOrganId"),否则会出错。
    List<EChartsDO> getMemberByAge(@Param("partyOrganId") List<Long> partyOrganId);

    xml映射中:
    <sql id="WhereClause">
        where isdel='N'
    <if test="partyOrganId!= null">
    AND party_organ_id in
    <foreach collection="partyOrganId" index="index" item="item" open="(" separator="," close=")">
    #{item}
    </foreach>
    </if>
    </sql>
     <select id="getMemberByAge" resultMap="ExtResultMap" parameterType="java.util.List">
    select text,count(id) count,total,ROUND(count(id)/total*100,1) percent from
    (select case when TIMESTAMPDIFF(YEAR, birthday, CURDATE()) BETWEEN 18 AND 29 then '18-29岁'
    when TIMESTAMPDIFF(YEAR, birthday, CURDATE()) BETWEEN 30 AND 39 then '30-39岁'
    when TIMESTAMPDIFF(YEAR, birthday, CURDATE()) BETWEEN 40 AND 49 then '40-49岁'
    when TIMESTAMPDIFF(YEAR, birthday, CURDATE()) BETWEEN 50 AND 59 then '50-59岁'
    when TIMESTAMPDIFF(YEAR, birthday, CURDATE()) BETWEEN 60 AND 69 then '60-69岁'
    when TIMESTAMPDIFF(YEAR, birthday, CURDATE()) BETWEEN 70 AND 79 then '70-79岁'
    when TIMESTAMPDIFF(YEAR, birthday, CURDATE()) > 80 then '80岁以上' end as text,id,
    (select count(id) from common_party_member <include refid="WhereClause" />) total
    from common_party_member <include refid="WhereClause" />
    )t GROUP BY text
    </select>
  • 相关阅读:
    [转]C# 文本框只能输入数字
    [转]C# dataGridview 报“索引-1没有值”的解决办法
    配置<authorization>节(配置文件)
    [转]javascript的urlencode
    SSM框架搭建问题
    web server
    mysql 系列
    UI 框架、ORM、权限系统
    一个基于 .NET Core 2.0 开发的简单易用的快速开发框架
    DotNetty 版 mqtt 开源客户端 (MqttFx)
  • 原文地址:https://www.cnblogs.com/yyjspace/p/11605968.html
Copyright © 2020-2023  润新知