mapper 如下：

使用<selectkey>实现 也可以使用oracle的row 级触发器trigger实现；

 

<?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.hxb.wide.demo.mapper.CCustInfoMapper">

<resultMap id="BaseResultMap" type="com.hxb.wide.demo.entity.CCustInfo">

<result column="CUST_NO" property="custNo" jdbcType="VARCHAR" />

<result column="CUST_NAME" property="custName" jdbcType="VARCHAR" />

<result column="GENDER" property="gender" jdbcType="VARCHAR" />

<result column="ID_TYPE" property="idType" jdbcType="VARCHAR" />

<result column="ID_NO" property="idNo" jdbcType="VARCHAR" />

<result column="MAIL_ADDR" property="mailAddr" jdbcType="VARCHAR" />

<result column="MOBILE" property="mobile" jdbcType="VARCHAR" />

<result column="LOGIN_PWD" property="loginPwd" jdbcType="VARCHAR" />

<result column="ADDRESS" property="address" jdbcType="VARCHAR" />

<result column="STATUS" property="status" jdbcType="VARCHAR" />

<result column="LAST_UP_DATE" property="lastUpDate" jdbcType="VARCHAR" />

<result column="LAST_LOGIN_DATE" property="lastLoginDate" jdbcType="VARCHAR" />

</resultMap>

<sql id="Example_Where_Clause">

<where>

<foreach collection="oredCriteria" item="criteria" separator="or">

<if test="criteria.valid">

<trim prefix="(" suffix=")" prefixOverrides="and">

<foreach collection="criteria.criteria" item="criterion">

<choose>

<when test="criterion.noValue">and ${criterion.condition}</when>

<when test="criterion.singleValue">and ${criterion.condition} #{criterion.value}</when>

<when test="criterion.betweenValue">and ${criterion.condition} #{criterion.value} and #{criterion.secondValue}</when>

<when test="criterion.listValue">

and ${criterion.condition}

<foreach collection="criterion.value" item="listItem" open="(" close=")" separator=",">#{listItem}</foreach>

</when>

</choose>

</foreach>

</trim>

</if>

</foreach>

</where>

</sql>

<sql id="Update_By_Example_Where_Clause">

<where>

<foreach collection="example.oredCriteria" item="criteria" separator="or">

<if test="criteria.valid">

<trim prefix="(" suffix=")" prefixOverrides="and">

<foreach collection="criteria.criteria" item="criterion">

<choose>

<when test="criterion.noValue">and ${criterion.condition}</when>

<when test="criterion.singleValue">and ${criterion.condition} #{criterion.value}</when>

<when test="criterion.betweenValue">and ${criterion.condition} #{criterion.value} and #{criterion.secondValue}</when>

<when test="criterion.listValue">

and ${criterion.condition}

<foreach collection="criterion.value" item="listItem" open="(" close=")" separator=",">#{listItem}</foreach>

</when>

</choose>

</foreach>

</trim>

</if>

</foreach>

</where>

</sql>

<sql id="Base_Column_List">CUST_NO, CUST_NAME, GENDER, ID_TYPE, ID_NO, MAIL_ADDR, MOBILE, LOGIN_PWD, ADDRESS,

STATUS, LAST_UP_DATE, LAST_LOGIN_DATE</sql>

<select id="selectByExample" resultMap="BaseResultMap" parameterType="com.hxb.wide.demo.mapper.example.CCustInfoExample">

select

<if test="distinct">distinct</if>

<include refid="Base_Column_List" />

from C_CUST_INFO

<if test="_parameter != null">

<include refid="Example_Where_Clause" />

</if>

<if test="orderByClause != null">order by ${orderByClause}</if>

</select>

<delete id="deleteByExample" parameterType="com.hxb.wide.demo.mapper.example.CCustInfoExample">

delete from C_CUST_INFO

<if test="_parameter != null">

<include refid="Example_Where_Clause" />

</if>

</delete>

<insert id="insert" parameterType="com.hxb.wide.demo.entity.CCustInfo">insert into C_CUST_INFO (CUST_NO, CUST_NAME, GENDER,

ID_TYPE, ID_NO, MAIL_ADDR,

MOBILE, LOGIN_PWD, ADDRESS,

STATUS, LAST_UP_DATE, LAST_LOGIN_DATE

)

values (#{custNo,jdbcType=VARCHAR}, #{custName,jdbcType=VARCHAR}, #{gender,jdbcType=VARCHAR},

#{idType,jdbcType=VARCHAR}, #{idNo,jdbcType=VARCHAR}, #{mailAddr,jdbcType=VARCHAR},

#{mobile,jdbcType=VARCHAR}, #{loginPwd,jdbcType=VARCHAR}, #{address,jdbcType=VARCHAR},

#{status,jdbcType=VARCHAR}, #{lastUpDate,jdbcType=VARCHAR}, #{lastLoginDate,jdbcType=VARCHAR}

)</insert>

<insert id="insertSelective" parameterType="com.hxb.wide.demo.entity.CCustInfo">

<selectKey resultType="java.lang.String" order="BEFORE" keyProperty="custNo">SELECT seq_cust_id.nextval AS custNo FROM dual</selectKey>

insert into C_CUST_INFO

<trim prefix="(" suffix=")" suffixOverrides=",">

<if test="custNo!=null ">CUST_NO,</if>

<if test="custName != null">CUST_NAME,</if>

<if test="gender != null">GENDER,</if>

<if test="idType != null">ID_TYPE,</if>

<if test="idNo != null">ID_NO,</if>

<if test="mailAddr != null">MAIL_ADDR,</if>

<if test="mobile != null">MOBILE,</if>

<if test="loginPwd != null">LOGIN_PWD,</if>

<if test="address != null">ADDRESS,</if>

<if test="status != null">STATUS,</if>

<if test="lastUpDate != null">LAST_UP_DATE,</if>

<if test="lastLoginDate != null">LAST_LOGIN_DATE,</if>

</trim>

<trim prefix="values (" suffix=")" suffixOverrides=",">

<if test="custNo!=null">#{custNo,jdbcType=VARCHAR},</if>

<if test="custName != null">#{custName,jdbcType=VARCHAR},</if>

<if test="gender != null">#{gender,jdbcType=VARCHAR},</if>

<if test="idType != null">#{idType,jdbcType=VARCHAR},</if>

<if test="idNo != null">#{idNo,jdbcType=VARCHAR},</if>

<if test="mailAddr != null">#{mailAddr,jdbcType=VARCHAR},</if>

<if test="mobile != null">#{mobile,jdbcType=VARCHAR},</if>

<if test="loginPwd != null">#{loginPwd,jdbcType=VARCHAR},</if>

<if test="address != null">#{address,jdbcType=VARCHAR},</if>

<if test="status != null">#{status,jdbcType=VARCHAR},</if>

<if test="lastUpDate != null">#{lastUpDate,jdbcType=VARCHAR},</if>

<if test="lastLoginDate != null">#{lastLoginDate,jdbcType=VARCHAR},</if>

</trim>

</insert>

<select id="countByExample" parameterType="com.hxb.wide.demo.mapper.example.CCustInfoExample" resultType="java.lang.Integer">

select count(*) from C_CUST_INFO

<if test="_parameter != null">

<include refid="Example_Where_Clause" />

</if>

</select>

<update id="updateByExampleSelective" parameterType="map">

update C_CUST_INFO

<set>

<if test="record.custNo != null">CUST_NO = #{record.custNo,jdbcType=VARCHAR},</if>

<if test="record.custName != null">CUST_NAME = #{record.custName,jdbcType=VARCHAR},</if>

<if test="record.gender != null">GENDER = #{record.gender,jdbcType=VARCHAR},</if>

<if test="record.idType != null">ID_TYPE = #{record.idType,jdbcType=VARCHAR},</if>

<if test="record.idNo != null">ID_NO = #{record.idNo,jdbcType=VARCHAR},</if>

<if test="record.mailAddr != null">MAIL_ADDR = #{record.mailAddr,jdbcType=VARCHAR},</if>

<if test="record.mobile != null">MOBILE = #{record.mobile,jdbcType=VARCHAR},</if>

<if test="record.loginPwd != null">LOGIN_PWD = #{record.loginPwd,jdbcType=VARCHAR},</if>

<if test="record.address != null">ADDRESS = #{record.address,jdbcType=VARCHAR},</if>

<if test="record.status != null">STATUS = #{record.status,jdbcType=VARCHAR},</if>

<if test="record.lastUpDate != null">LAST_UP_DATE = #{record.lastUpDate,jdbcType=VARCHAR},</if>

<if test="record.lastLoginDate != null">LAST_LOGIN_DATE = #{record.lastLoginDate,jdbcType=VARCHAR},</if>

</set>

<if test="_parameter != null">

<include refid="Update_By_Example_Where_Clause" />

</if>

</update>

<update id="updateByExample" parameterType="map">

update C_CUST_INFO

set CUST_NO = #{record.custNo,jdbcType=VARCHAR},

CUST_NAME = #{record.custName,jdbcType=VARCHAR},

GENDER = #{record.gender,jdbcType=VARCHAR},

ID_TYPE = #{record.idType,jdbcType=VARCHAR},

ID_NO = #{record.idNo,jdbcType=VARCHAR},

MAIL_ADDR = #{record.mailAddr,jdbcType=VARCHAR},

MOBILE = #{record.mobile,jdbcType=VARCHAR},

LOGIN_PWD = #{record.loginPwd,jdbcType=VARCHAR},

ADDRESS = #{record.address,jdbcType=VARCHAR},

STATUS = #{record.status,jdbcType=VARCHAR},

LAST_UP_DATE = #{record.lastUpDate,jdbcType=VARCHAR},

LAST_LOGIN_DATE = #{record.lastLoginDate,jdbcType=VARCHAR}

<if test="_parameter != null">

<include refid="Update_By_Example_Where_Clause" />

</if>

</update>

<select id="selectByExampleWithRowbounds" resultMap="BaseResultMap" parameterType="com.hxb.wide.demo.mapper.example.CCustInfoExample" resultType="com.hxb.wide.demo.entity.CCustInfo">

select

<if test="distinct">distinct</if>

<include refid="Base_Column_List" />

from C_CUST_INFO

<if test="_parameter != null">

<include refid="Example_Where_Clause" />

</if>

<if test="orderByClause != null">order by ${orderByClause}</if>

</select>

<select id="selectByPrimaryKey" />

<delete id="deleteByPrimaryKey" />

<update id="updateByPrimaryKeySelective" />

<update id="updateByPrimaryKey" />

<delete id="deleteByCustName" parameterType="com.hxb.wide.demo.entity.CCustInfo">delete from C_CUST_INFO where CUST_NAME = #{custName,jdbcType=VARCHAR}</delete>

<delete id="deleteByCustNo">delete from C_CUST_INFO where CUST_NO = #{custNo,jdbcType=VARCHAR}</delete>

<select id="queryByCustNo" parameterType="java.lang.String" resultMap="BaseResultMap" >select * from C_CUST_INFO where CUST_NO = #{custNo,jdbcType=VARCHAR}</select>

</mapper>