<insert id="insertMysql" parameterType="User" useGeneratedKeys="true" keyProperty="id">
insert into t_user
(login_name,nickname,password,role,email,login_date,create_date,status)
values
(#{username},#{nickname},#{password},#{role},#{email},#{loginDate},#{createDate},#{flag})
</insert>
<insert id="insertOracle" parameterType="User" >
<selectKey keyProperty="id" order="AFTER" resultType="integer" >
select user_seq.currval from dual
</selectKey>
insert into t_user
(id,login_name,nickname,password,role,email,login_date,create_date,status)
values
(user_seq.nextval,#{username},#{nickname},#{password},#{role},#{email},#{loginDate,jdbcType=DATE},#{createDate},#{flag})
</insert>
<insert id="insertOracle2" parameterType="User" >
<selectKey keyProperty="id" order="BEFORE" resultType="integer" >
select user_seq.nextval from dual
</selectKey>
insert into t_user
(id,login_name,nickname,password,role,email,login_date,create_date,status)
values
(#{id},#{username},#{nickname},#{password},#{role},#{email},#{loginDate,jdbcType=DATE},#{createDate},#{flag})
</insert>
sql的不同insert实现
最新推荐文章于 2023-02-27 00:01:43 发布