<?xml version=1.0 encoding=UTF-8 ?> <!DOCTYPE mapper PUBLIC -//mybatis.org//DTD Mapper 3.0//EN http://mybatis.org/dtd/mybatis-3-mapper.dtd> <mapper namespace=com.ruoyi.project.monitor.mapper.SysLogininforMapper> <resultMap type=SysLogininfor id=SysLogininforResult> <id property=infoId column=info_id /> <result property=userName column=user_name /> <result property=status column=status /> <result property=ipaddr column=ipaddr /> <result property=loginLocation column=login_location /> <result property=browser column=browser /> <result property=os column=os /> <result property=msg column=msg /> <result property=loginTime column=login_time /> </resultMap> <insert id=insertLogininfor parameterType=SysLogininfor> insert into sys_logininfor (user_name, status, ipaddr, login_location, browser, os, msg, login_time) values (#{userName}, #{status}, #{ipaddr}, #{loginLocation}, #{browser}, #{os}, #{msg}, GETDATE()) </insert> <select id=selectLogininforList parameterType=SysLogininfor resultMap=SysLogininforResult> select info_id, user_name, ipaddr, login_location, browser, os, status, msg, login_time from sys_logininfor <where> <if test=ipaddr != null and ipaddr != ''> AND ipaddr like '%' + #{ipaddr} + '%' </if> <if test=status != null and status != ''> AND status = #{status} </if> <if test=userName != null and userName != ''> AND user_name like '%' + #{userName} + '%' </if> <if test=beginTime != null and beginTime != ''><!-- 开始时间检索 --> and date_format(login_time,'%y%m%d') >= date_format(#{beginTime},'%y%m%d') </if> <if test=endTime != null and endTime != ''><!-- 结束时间检索 --> and date_format(login_time,'%y%m%d') <= date_format(#{endTime},'%y%m%d') </if> </where> order by info_id desc </select> <delete id=deleteLogininforByIds parameterType=Long> delete from sys_logininfor where info_id in <foreach collection=array item=infoId open=( separator=, close=)> #{infoId} </foreach> </delete> <update id=cleanLogininfor> truncate table sys_logininfor </update> </mapper>