XML的mybatis

一时失言乱红尘 2022-08-08 13:57 141阅读 0赞

<?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="命名空间">  
  
  
      
    <select id="toGet" parameterType="ActionValues" resultType="ResultValues">  
        select \* from 表名  where upper(id)=upper(\#\{id\})  
    </select>  
  
      
    <select id="toQuery" parameterType="ActionValues" resultType="ResultValues">  
        select id,name,sex,mobile,address from 表名  
        <trim prefix="where" prefixOverrides="and|or">  
           <if test="null!=id">upper(id) like upper('%$\{id\}%')</if>  
           <if test="null!=name"> and upper(name) like upper('%$\{name\}%') </if>  
           <if test="null!=sex"> and upper(sex) like upper('%$\{sex\}%') </if>  
           <if test="null!=mobile"> and upper(mobile) like upper('%$\{mobile\}%') </if>  
           <if test="null!=address"> and upper(address) like upper('%$\{address\}%') </if>  
       </trim>  
   </select>

<insert id="toInsert" parameterType="ActionValues">  
      insert into 表名(  
          <if test="null!=id">id</if>  
          <if test="null!=name">,name</if>  
          <if test="null!=sex">,sex</if>  
          <if test="null!=mobile">,mobile</if>  
          <if test="null!=address">,address</if>  
      )values(  
          <if test="null!=id">upper(\#\{id,jdbcType=VARCHAR\})</if>  
          <if test="null!=name">,upper(\#\{name,jdbcType=VARCHAR\})</if>  
          <if test="null!=sex">,upper(\#\{sex,jdbcType=VARCHAR\})</if>  
          <if test="null!=mobile">,upper(\#\{mobile,jdbcType=VARCHAR\})</if>  
          <if test="null!=address">,upper(\#\{address,jdbcType=VARCHAR\})</if>  
        )  
    </insert>

<update id="toUpdate" parameterType="ActionValues">  
     <if test="null!=id">  
        update 表明  
             <trim prefix="SET" suffixOverrides=",">  
                  <if test="null != id">upper(id=\#\{id\})</if>  
                  <if test="null != name">,upper(name=\#\{name\})</if>  
                  <if test="null != sex">,upper(sex=\#\{sex\})</if>  
                  <if test="null != mobile">,upper(mobile=\#\{mobile\})</if>  
                  <if test="null != address">,upper(address=\#\{address\})</if>  
            </trim>  
            where upper(id)=upper(\#\{id\})  
        </if>  
    </update>

<delete id="toDelete" parameterType="ActionValues">  
        <if test="null!=id">  
             delete from 表名 where upper(id)=upper(\#\{id\})  
        </if>  
    </delete>  
  
</mapper>