Mybatis XML文件详解

小灰灰 2024-03-26 22:45 80阅读 0赞

## Mybatis XML文件详解 ##

<?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.dao.UserinfoDAO">
        
        <resultMap type="com.po.UserinfoPO" id="userinfoMap">
            <result column="userid" property="userid"/>
            <result column="loginname" property="loginname"/>
            <result column="loginpass" property="loginpass"/>
            <result column="username" property="username"/>
            <result column="upower" property="upower"/>
            <result column="birthday" property="birthday"/>
            <result column="sex" property="sex"/>
        </resultMap>
        
        <sql id="zd">
            userid,loginname,loginpass,username,upower,birthday,sex
        </sql>
        
        
        <select id="login" resultMap="userinfoMap" parameterType="com.po.UserinfoPO">    
            
            select <include refid="zd"/> from userinfo
            <where>            
                    loginname=#{loginname} and loginpass=#{loginpass}
            </where>
        </select>
        
        
        <select id="userList" resultMap="userinfoMap" parameterType="com.po.UserinfoPO">
            
            select <include refid="zd"/> from userinfo
        </select>
        
        
        <select id="updateid" resultMap="userinfoMap" parameterType="com.po.UserinfoPO">
            
            select <include refid="zd"/> from userinfo
            <where>userid=#{userid}</where>
        </select>
        
        
         <update id="update" parameterType="com.po.UserinfoPO">
             update userinfo 
             set loginname=#{loginname},loginpass=#{loginpass},username=#{username},
                 upower=#{upower},birthday=#{birthday},sex=#{sex}
             where userid=#{userid}     
         </update>
         
        
        <insert id="insert" parameterType="com.po.UserinfoPO">
            insert into userinfo(<include refid="zd"/>) 
            values
            (#{userid},#{loginname},#{loginpass},#{username},#{upower},#{birthday},#{sex})
        </insert>
            
        
        <delete id="delete" parameterType="int">
            delete from userinfo where userid=#{userid}
        </delete>
        
        
        <select id="select" resultMap="userinfoMap" parameterType="java.util.Map">
            
            select <include refid="zd"/> from userinfo
            
            <where>
                <if test="username == null and username = '' and upower == -1">
                    and 1=1
                </if>
                <if test="username != null and username !=''">
                    and username LIKE '%${username}%' 
                </if>        
                <if test="upower != -1">
                    and upower=#{upower} 
                </if>            
            </where>
        </select>
    </mapper>