Mybatis的sql映射文件的顶级元素使用实例(超级详细)

<mapper namespace="com.bdqn.jiankang.mapper.UserDao">

 <select id="query" resultType="User">
    select * from user
  </select>

 <resultMap type="RegRum" id="reg">
        <id property="patientid" column="patientid" />
        <result property="patientname" column="patientname"></result>
        <result property="sex" column="sex" />
        <result property="cardtype" column="cardtype" />
        <result property="cardid" column="cardid" />
        <result property="socalnum" column="socalnum" />
        <result property="phone" column="phone" />
        <result property="age" column="age" />
        <result property="position" column="position" />
        <result property="status" column="status" />
        <result property="remark" column="remark" />
        <result property="date" column="date" />
        <association javaType="Doctor" property="doctor" resultMap="doctor">
        </association>
  </resultMap>

    <resultMap id="doctor" type="Doctor">
        <id property="doctorid" column="doctorid"></id>
        <result property="dname" column="dname"></result>
        <result property="subroomname" column="subroomname"></result>
    </resultMap>

    <resultMap type="User" id="querybyname1">
        <id property="uid" column="uid" />
        <result property="uname" column="uname"></result>
        <result property="upwd" column="upwd" />
        <collection property="roles" ofType="Role">
            <id property="rid" column="rid"></id>
            <result column="rname" property="rname"></result>
            <collection property="permissions" ofType="Permission">
                <id property="pid" column="pid"></id>
                <result column="pname" property="pname"></result>
            </collection>
        </collection>
    </resultMap>

 <select id="querySelect" resultMap="reg">
        select * from doctor as d left join regnum as r on r.doctorid
        = d.doctorid left join subjectroom as s on s.subroomid=d.subroomid
        <where>
            <if test="patientid!=null and patientid!=''">
                and patientid=#{patientid}
            </if>
            <if test="dname != null and dname!=''">
                and dname like '%${dname}%'
            </if>
            <if test="subjectroom != null and subjectroom!=''">
                and s.subroomname like '%${subjectroom}%'
            </if>
            <if test="starttime != null and starttime!=''">
                <!-- and date &gt; #{starttime} -->
                and date <![CDATA[ <=]]> #{starttime}
            </if>
            <if test="endtime != null and endtime!=''">
                <!-- and date &lt; #{endtime} -->
                and date >= #{endtime}
            </if>
        </where>
 
    </select>

 <select id="querySelect2" resultMap="reg">
        select * from doctor as d left join regnum as r on r.doctorid
        = d.doctorid left join subjectroom as s on s.subroomid=d.subroomid
        <trim prefix="where" prefixOverrides="and|or">
            <if test="patientid!=null and patientid!=''">
                and patientid=#{patientid},
            </if>
            <if test="dname != null and dname!=''">
                and dname like '%${dname}%',
            </if>
            <if test="subjectroom != null and subjectroom!=''">
                and s.subroomname like '%${subjectroom}%',
            </if>
            <if test="starttime != null and starttime!=''">
                <!-- and date &gt; #{starttime} -->
                and date <![CDATA[ <=]]> #{starttime},
            </if>
            <if test="endtime != null and endtime!=''">
                <!-- and date &lt; #{endtime} -->
                and date >= #{endtime},
            </if>
        </trim>

<insert id="addRum" parameterType="RegRum"> 
     insert into regnum(patientname,cardtype,cardid,socalnum,phone,sex,
     age,position,firstdiagnose,doctorid,status,remark,date) 
     VALUES(#{regnum.patientname},#{regnum.cardtype},#{regnum.cardid}
</insert>

<update id="updateregnum">
        update regnum
        <set >
            <if test="phone!=null and phone!=''">
                phone=#{phone},
            </if>
            <if test="position!=null and position!=''">
                position=#{position},
            </if>
            <if test="firstdiagnose!=null and firstdiagnose!=''">
                firstdiagnose=#{firstdiagnose},
            </if>
            <if test="doctorid!=0">
                doctorid=#{doctorid},
            </if>
            <if test="remark!=null and remark!=''">
                remark=#{remark},
            </if>
            <if test="date!=null and date!=''">
                date=#{date},
            </if>
            <if test="age!=0">
                age=#{age},
            </if>
            <if test="status!=null and status !=''">
                status=#{status},
            </if>
            <if test="sex==0 or sex==1">
                sex=#{sex},
            </if>
        </set>
        where patientid=#{patientid}
    </update>

  <update id="updateregnum">
        update regnum
        <trim prefix="set" suffixOverrides="," suffix=" where patientid=#{patientid}">
            <if test="phone!=null and phone!=''">
                phone=#{phone},
            </if>
            <if test="position!=null and position!=''">
                position=#{position},
            </if>
            <if test="firstdiagnose!=null and firstdiagnose!=''">
                firstdiagnose=#{firstdiagnose},
            </if>
            <if test="doctorid!=0">
                doctorid=#{doctorid},
            </if>
            <if test="remark!=null and remark!=''">
                remark=#{remark},
            </if>
            <if test="date!=null and date!=''">
                date=#{date},
            </if>
            <if test="age!=0">
                age=#{age},
            </if>
            <if test="status!=null and status !=''">
                status=#{status},
            </if>
            <if test="sex!=0">
                sex=#{sex},
            </if>
        </trim>
    </update>

   <delete id="delversion" parameterType="Integer">
       delete from app_version where appid=#{appid};
   </delete>

<select id="findByids2" resultType="User">
        select * from user where userid in
        <foreach collection="ids" index="index" item="item" open="(" separator="," close=")">
            #{item}
        </foreach>
</select>

  public Collection<User> findbymap(Map<String,Object> map);

 <select id="findbymap" resultType="User">
        select * from user where userid in
        <foreach collection="idslist" index="index" item="id" open="(" separator="," close=")">
            #{id}
        </foreach>
 
        and phone=#{phone};
  </select>

public Collection<User> findByids3(@Param("ids")int [] ids,@Param("phone") String phone);