target/WMS-1.0-SNAPSHOT/WEB-INF/classes/com/ken/wms/dao/UserInfoMapper.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.UserInfoMapper">

    <resultMap id="user" type="com.ken.wms.domain.UserInfoDO">
        <result property="userID" column="USER_ID"/>
        <result property="userName" column="USER_USERNAME"/>
        <result property="password" column="USER_PASSWORD"/>
        <result property="firstLogin" column="USER_FIRST_LOGIN"/>
    </resultMap>

    <select id="selectByUserID" resultMap="user">
        select
            u.USER_ID,
            u.USER_USERNAME,
            u.USER_PASSWORD,
            u.USER_FIRST_LOGIN
        from
            wms_user u
        where
            u.USER_ID = #{userID}
    </select>

    <select id="selectByName" resultMap="user">
        select
            s.USER_ID,
            s.USER_USERNAME,
            s.USER_PASSWORD,
            s.USER_FIRST_LOGIN
        from
            wms_user s
        where
            s.USER_USERNAME = #{userName}
    </select>

    <select id="selectAll" resultMap="user">
        select
            s.USER_ID,
            s.USER_USERNAME,
            s.USER_PASSWORD,
            s.USER_FIRST_LOGIN
        from
            wms_user s
    </select>

    <insert id="insert" useGeneratedKeys="true">
        insert into wms_user(USER_ID,USER_USERNAME,USER_PASSWORD, USER_FIRST_LOGIN)
        values (#{userID},#{userName},#{password}, #{firstLogin})
    </insert>

    <update id="update">
        update wms_user set
            USER_USERNAME = #{userName},
            USER_PASSWORD = #{password},
            USER_FIRST_LOGIN = #{firstLogin}
        where
            USER_ID = #{userID}