<insert id="save" parameterType="User">
<selectKey keyProperty="id" resultType="java.lang.Integer" order="BEFORE">
select user.nextval from dual
</selectKey>
insert into userinfo
<trim prefix="(" suffix=")" suffixOverrides=",">
id,
name
</trim>
<trim prefix="values(" suffix=")" suffixOverrides=",">
#{id},
#{name}
</trim>
</insert>