target/classes/mybatis/mapper/ManagerMapper.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.huawei.mapper.ManagerMapper">

    <resultMap id="managerMap" type="com.huawei.vo.Manager">
        <id property="mid" column="mid"></id>
        <result property="name" column="mname"></result>
        <result property="bid" column="bid"></result>
        <result property="tel" column="tel"></result>

        <association property="dormitory" column="bid" javaType="com.huawei.vo.Dormitory">
            <id property="did" column="did"></id>
            <result property="dName" column="dname"></result>
        </association>

    </resultMap>

    <select id="findAllManager" resultMap="managerMap">
        SELECT m.mid,m.mname,m.bid,d.dname,m.tel
        FROM manager m, dormitory d
        WHERE m.bid = d.bid
    </select>

    <insert id="addManager" parameterType="com.huawei.vo.Manager">
         INSERT INTO
        manager(mid,bid,mname,tel,password)
        VALUES
        (#{mid},#{bid},#{name},#{tel},#{password})
    </insert>

    <delete id="delManagerById" parameterType="Integer">
        DELETE FROM manager
        WHERE mid = #{mid}
    </delete>



</mapper>

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

AI 解读

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

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