<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.zrx.datacenter.presource.api.preLibrary.mapper.PreLibraryMapper">
<insert id="addPreLibrary" parameterType="java.util.HashMap" useGeneratedKeys="true" keyProperty="id">
<selectKey keyProperty="id" resultType="java.lang.String" order="BEFORE">
select replace(uuid(),'-','') from dual
</selectKey>
insert into data_center_pre_library
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="id!=null">id,
</if>
<if test="libraryName!=null">library_name,
</if>
<if test="preMachineId!=null">pre_machine_id,
</if>
<if test="affiliation!=null">affiliation,
</if>
<if test="businessPlatform!=null">business_platform,
</if>
<if test="preLibraryType!=null">pre_library_type,
</if>
<if test="ipAddress!=null">ip_address,
</if>
<if test="port!=null">port,
</if>
<if test="userName!=null">user_name,
</if>
<if test="password!=null">password
</if>
</trim>
<trim prefix="values (" suffix=")" suffixOverrides=",">
<if test="id!=null">#{id},
</if>
<if test="libraryName!=null">#{libraryName},
</if>
<if test="preMachineId!=null">#{preMachineId},
</if>
<if test="affiliation!=null">#{affiliation},
</if>
<if test="businessPlatform!=null">#{businessPlatform},
</if>
<if test="preLibraryType!=null">#{preLibraryType},
</if>
<if test="ipAddress!=null">#{ipAddress},
</if>
<if test="port!=null">#{port},
</if>
<if test="userName!=null">#{userName},
</if>
<if test="password!=null">#{password}
</if>
</trim>
</insert>
</mapper>
mybatis的xml中新增语句,设置id为UUID
最新推荐文章于 2022-09-30 15:23:57 发布