target/classes/mapper/DormitoryAdminMapper.xml

（完整代码） 1KB 

<?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.frankioxo.dormitory.mapper.DormitoryAdminMapper">

    <select id="list" resultType="DormitoryAdmin">
        select *
        from dormitory_admin
    </select>

    <select id="searchByUsername" resultType="DormitoryAdmin">
        select *
        from dormitory_admin
        where username like concat('%', #{value}, '%')
    </select>

    <select id="searchByName" resultType="DormitoryAdmin">
        select *
        from dormitory_admin
        where name like concat('%', #{value}, '%')
    </select>

    <select id="searchByTelephone" resultType="DormitoryAdmin">
        select *
        from dormitory_admin
        where telephone like concat('%', #{value}, '%')
    </select>

    <insert id="save">
        insert into dormitory_admin(username, password, name, gender, telephone)
        values (#{username}, #{password}, #{name}, #{gender}, #{telephone})
    </insert>

    <delete id="delete">
        delete
        from dormitory_admin
        where id = #{id}
    </delete>

    <update id="update">
        update dormitory_admin
        set username  = #{username},
            password  = #{password},
            name      = #{name},
            gender    = #{gender},
            telephone = #{telephone}
        where id = #{id}
    </update>

    <select id="findByUserName" resultType="DormitoryAdmin">
        select *
        from dormitory_admin
        where username = #{username}
    </select>

</mapper>

24 小时内免费解锁 3 个项目，之后 1 积分/个。 规则说明

AI 解读

登录后可用，每次 10 积分，解读结果公开显示在下面。

还没有人解读过这个文件。