//主键新增时使用
<insert id="saveParam" parameterType="com.making.vo.param.CraftParamVO">
<selectKey keyProperty="paramId" resultType="String" order="BEFORE">
select IFNULL(max(CONVERT(PARAM_ID, UNSIGNED INTEGER)+1),'100') from CRAFT_PARAM WHERE PARENT_ID='0'
</selectKey>
INSERT INTO craft_param (PARAM_ID,PARAM_NAME,PARAM_TYPE,PARAM_UNIT,REMARK,CREATE_TIME,CREATE_USER,PARENT_ID)
values(#{paramId},#{paramName},#{paramType},#{paramUnit},#{remark},now(),#{createUser},#{parentId})
</insert>
mysql中使用CONVERT将varchar类型转换integer
最新推荐文章于 2021-07-27 21:58:30 发布