mybatis-plus @Select select in 查询实现

mybatis-plus @Select select in 查询实现
强烈推介IDEA2021.1.3破解激活,IntelliJ IDEA 注册码,2021.1.3IDEA 激活码 

大家好,我是架构君,一个会写代码吟诗的架构师。今天说一说mybatis-plus @Select select in 查询实现,希望能够帮助大家进步!!!

<select id="querySortiePlanNumber" resultMap="sortiePlanNumberMap">	select sp.flightplan_id,count(sp.id) sp_count from t_flightplan_set fs join t_sortie_plan sp on fs.id=sp.flightplan_id	and fs.del_flag='0' and sp.del_flag='0'	<if test="null != ids and ids.size > 0">	and sp.flightplan_id in	<foreach item="item" index="index" collection="ids" open="(" separator="," close=")">	#{item}	</foreach>	</if>	group by sp.flightplan_id	</select>

 

本文来源huayang183,由架构君转载发布,观点不代表Java架构师必看的立场,转载请标明来源出处:https://javajgs.com/archives/18230

发表评论