sql笔记

最新推荐文章于 2024-03-03 21:31:31 发布

TOT苏打

最新推荐文章于 2024-03-03 21:31:31 发布

阅读量202

点赞数 1

本文链接：https://blog.csdn.net/qq_38853322/article/details/89637354

版权

当前时间与某个时间相差在某个区间结果取int值
DATEDIFF(CURDATE(),**_time)BETWEEN #{开始区间} AND #{reqVo.FinishOverdueDay}

sql在xml文件中遍历集合

List<PerfectNotCreditCloudSellerRespVo> cloudSellerNoCreditFromAccount(@Param("reqVo")  List<PerfectNoCreditCloudSellerRespVo> reqVo);

public class PerfectNoCreditCloudSellerRespVo extends BaseVo {

    /**
     * 用户id
     */
    private String userId;

    /**
     * 云商账号ID
     */
    private String perfectAccoundId;

SELECT * from st_perfect_account where 1 = 1
<if test="reqVo.size()>0 " >
    AND user_id in
    <foreach collection="reqVo" index="index" item="item" open="(" separator="," close=")">
        #{item.userId}
    </foreach>
    AND id in
    <foreach collection="reqVo" index="index" item="item" open="(" separator="," close=")">
        #{item.perfectAccoundId}
    </foreach>
</if>