mybatis对数据库进行增删查改

汉字的模糊查询

<where>
   <if test="smsTitle != null">
       AND smsTitle like concat('%',#{smsTitle},'%')
   </if>
</where>

模糊查询

<where>

<if test="type != 0 and type !=null">
  AND product.`productTypeId` = #{type,jdbcType = INTEGER}
</if>

</where>

增加

<insert id="insertOneSmsConfig" parameterType="com.example.entity.HrSmsConfig" useGeneratedKeys="true" keyProperty="id">
    insert into hr_sms_config
    <trim prefix="(" suffix=")" suffixOverrides="," >
        <if test="smsTitle != null">
            smsTitle,
        </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides="," >
        <if test="smsTitle != null">
            #{smsTitle,jdbcType=VARCHAR},
        </if>
    </trim>
</insert>

删除

<delete id="delOneSmsConfigInfoById" parameterType="java.lang.Integer" >
    delete from hr_sms_config
    where id = #{smsConfigId,jdbcType=INTEGER}
</delete>

修改

<update id="updateOneSmsConfig" parameterType="com.example.entity.HrSmsConfig" >
    UPDATE hr_sms_config
    <set>
        <if test="smsTitle != null">
            smsTitle = #{smsTitle,jdbcType=VARCHAR},
        </if>
    </set>
    WHERE id = #{id,jdbcType=INTEGER}
</update>

获取id值并进行类型转化

HttpSession session = request.getSession();//获取session
HrUser loginHrUser = (HrUser) session.getAttribute("HrAdminLoginInfo");

if (null == loginHrUser) {
    result.setMessage("登录超时！");
    return result;
}

int lastOperaterId = loginHrUser.getId();
hrParameters.setLastOperaterId(lastOperaterId);