仅仅为笔记

mybatis批量查询
<select id="busiUserLoginGraphicByOracle" resultType="com.infosec.audit.bean.log.UseraccessLog">
SELECT
uids,
to_char(
createDate,
'yyyy-MM-dd'
) createTime,
COUNT(1) AS id
FROM
audit_log_user_access
where
createDate &gt;=to_date(#{fromRegDate}, 'yyyy-MM-dd')
and createDate &lt;=to_date(#{endRegDate}, 'yyyy-MM-dd')
<if test="appName != ''">
and appName=#{appName}
</if>
<if test="uidList !=null and uidList.size > 0">
and uids in
<foreach item="item" collection="uidList" open="(" separator="," close=")">
#{item.uids}
</foreach>
</if>
<if test="deptdn != null">
and deptDn like concat('%',concat(#{deptdn},'%'))
</if>
GROUP BY uids,createTime
ORDER BY uids
</select>

另外,配置是否打印日志的包扫描路径位:
logging.level.com.infosec = debug
posted @ 2021-03-09 17:14  oc-long  阅读(70)  评论(0编辑  收藏  举报