mybatis的动态运用

旧城等待， 2022-06-02 12:14 223阅读 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="com.yanshu.lcsysetting.service.LcsySettingPrivilegeService" >  
   
<update id="updateLcsySetPrivilege" parameterType="java.util.Map">    
        update lcsy\_SettingPrivilege  
        <set>  
        <if test="status!=null and status!='' ">  
         status=\#\{status\},  
        </if>  
        <if test="mtype!=null and mtype!='' ">  
        mtype=\#\{mtype\},  
        </if>  
        <if test="modName!=null and modName!='' ">  
        modName=\#\{modName\},  
        </if>  
        <if test="picture!=null and picture!='' ">  
        picture=\#\{picture\},  
        </if>  
        <if test="minipicture!=null and minipicture!='' ">  
        minipicture=\#\{minipicture\},  
        </if>  
        <if test="described!=null and described!='' ">  
        described=\#\{described\},  
        </if>  
         <if test="PType!=null and PType!='' ">  
        PType=\#\{PType\},  
        </if>  
        </set>  
        <where>  
        <if test="SellerId!=null and SellerId!='' and pid!=null and pid!=''  ">  
        SellerId=\#\{SellerId\} and pid=\#\{pid\}  
        </if>  
        </where>  
  </update>   
  
  
  <select id="findByPrsid"  parameterType="Map" resultType="com.yanshu.lcsysetting.pojo.LcsySettingPrivilege">  
  select \* from lcsy\_SettingPrivilege   
    <where>  
    <if test="SellerId!=null and SellerId!='' ">  
        SellerId=\#\{SellerId\}  
        </if>  
    </where>   
  </select>   
    
   
 </mapper>