target/WMS-1.0-SNAPSHOT/WEB-INF/classes/com/ken/wms/dao/UserOperationRecordMapper.xml

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<?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.ken.wms.dao.UserOperationRecordMapper">
    <resultMap id="userOperationRecord" type="com.ken.wms.domain.UserOperationRecordDO">
        <id property="id" column="RECORD_ID"/>
        <result property="userID" column="USER_ID"/>
        <result property="userName" column="USER_NAME"/>
        <result property="operationName" column="OPERATION_NAME"/>
        <result property="operationTime" column="OPERATION_TIME"/>
        <result property="operationResult" column="OPERATION_RESULT"/>
    </resultMap>

    <select id="selectUserOperationRecord" resultMap="userOperationRecord">
        select
            RECORD_ID,
            USER_ID,
            USER_NAME,
            OPERATION_NAME,
            OPERATION_TIME,
            OPERATION_RESULT
        from
            wms_operation_record
        <where>
            <if test="userID > 0">
                USER_ID = #{userID}
            </if>
            <if test="startDate != null">
                and OPERATION_TIME >= #{startDate}
            </if>
            <if test="endDate != null">
                <![CDATA[and OPERATION_TIME <= #{endDate}]]>
            </if>
        </where>
    </select>

    <insert id="insertUserOperationRecord">
        insert into wms_operation_record(USER_ID, USER_NAME, OPERATION_NAME, OPERATION_TIME, OPERATION_RESULT)
        values(#{userID}, #{userName}, #{operationName}, #{operationTime}, #{operationResult})
    </insert>
</mapper>