mybatis 大于等于小于等于

 >  这个是  >=

&lt;   这个是  <=

 

参数是一个list：
<if test="joinInformation.departIds != null and joinInformation.departIds.size() >0 ">
    and depart_id in
    <foreach collection="joinInformation.departIds" close=")" open="(" separator="," item="departId">
        #{joinInformation.departId}
    </foreach>
</if>

分页的limit

<if test="joinInformation.startRow != null and joinInformation.limit != null">
    limit #{joinInformation.startRow},#{joinInformation.limit}
</if>

 

in条件

select id from tb_staff_base where user_name= #{userName} and phone= #{phone} and work_status in ('ALREADY_ENTRY','IMMINENT_ENTRY')

 

 

模糊匹配

<select id="selectByName" parameterType="java.lang.String" resultMap="BaseResultMap">
    select
    <include refid="Base_Column_List"/>
    from tb_staff_base
    where user_name like #{userName}"%"
</select>

 

插入时候返回插入那条数据的id

<insert id="insertSelective" parameterType="com.bee.hrm.entity.staff.StaffEntity" useGeneratedKeys="true"
        keyProperty="id">