汉字的模糊查询
<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);