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_basewhere user_name like #{userName}"%"</select>

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

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