ws.rar_spring app_spring mybatis

<?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="cn.la.finance.ws.dao.BaffleConfDoMapper"> <resultMap id="BaseResultMap" type="cn.la.finance.ws.dao.model.BaffleConfDo"> <id column="id" jdbcType="BIGINT" property="id" /> <result column="baffle_trans_code" jdbcType="VARCHAR" property="baffleTransCode" /> <result column="scene" jdbcType="VARCHAR" property="scene" /> <result column="acct_no" jdbcType="VARCHAR" property="acctNo" /> <result column="status" jdbcType="CHAR" property="status" /> <result column="remark" jdbcType="VARCHAR" property="remark" /> <result column="creator" jdbcType="VARCHAR" property="creator" /> <result column="updator" jdbcType="VARCHAR" property="updator" /> <result column="create_time" jdbcType="TIMESTAMP" property="createTime" /> <result column="update_time" jdbcType="TIMESTAMP" property="updateTime" /> </resultMap> <sql id="Base_Column_List"> id, baffle_trans_code, scene, acct_no, status, remark, creator, updator, create_time, update_time </sql> <select id="selectByPrimaryKey" parameterType="java.lang.Long" resultMap="BaseResultMap"> select <include refid="Base_Column_List" /> from baffle_conf where id = #{id,jdbcType=BIGINT} </select> <delete id="deleteByPrimaryKey" parameterType="java.lang.Long"> delete from baffle_conf where id = #{id,jdbcType=BIGINT} </delete> <insert id="insert" parameterType="cn.la.finance.ws.dao.model.BaffleConfDo"> <selectKey keyProperty="id" order="AFTER" resultType="java.lang.Long"> SELECT LAST_INSERT_ID() </selectKey> insert into baffle_conf (baffle_trans_code, scene, acct_no, status, remark, creator, updator, create_time, update_time ) values (#{baffleTransCode,jdbcType=VARCHAR}, #{scene,jdbcType=VARCHAR}, #{acctNo,jdbcType=VARCHAR}, #{status,jdbcType=CHAR}, #{remark,jdbcType=VARCHAR}, #{creator,jdbcType=VARCHAR}, #{updator,jdbcType=VARCHAR}, #{createTime,jdbcType=TIMESTAMP}, #{updateTime,jdbcType=TIMESTAMP} ) </insert> <insert id="insertSelective" parameterType="cn.la.finance.ws.dao.model.BaffleConfDo"> <selectKey keyProperty="id" order="AFTER" resultType="java.lang.Long"> SELECT LAST_INSERT_ID() </selectKey> insert into baffle_conf <trim prefix="(" suffix=")" suffixOverrides=","> <if test="baffleTransCode != null"> baffle_trans_code, </if> <if test="scene != null"> scene, </if> <if test="acctNo != null"> acct_no, </if> <if test="status != null"> status, </if> <if test="remark != null"> remark, </if> <if test="creator != null"> creator, </if> <if test="updator != null"> updator, </if> <if test="createTime != null"> create_time, </if> <if test="updateTime != null"> update_time, </if> </trim> <trim prefix="values (" suffix=")" suffixOverrides=","> <if test="baffleTransCode != null"> #{baffleTransCode,jdbcType=VARCHAR}, </if> <if test="scene != null"> #{scene,jdbcType=VARCHAR}, </if> <if test="acctNo != null"> #{acctNo,jdbcType=VARCHAR}, </if> <if test="status != null"> #{status,jdbcType=CHAR}, </if> <if test="remark != null"> #{remark,jdbcType=VARCHAR}, </if> <if test="creator != null"> #{creator,jdbcType=VARCHAR}, </if> <if test="updator != null"> #{updator,jdbcType=VARCHAR}, </if> <if test="createTime != null"> #{createTime,jdbcType=TIMESTAMP}, </if> <if test="updateTime != null"> #{updateTime,jdbcType=TIMESTAMP}, </if> </trim> </insert> <update id="updateByPrimaryKeySelective" parameterType="cn.la.finance.ws.dao.model.BaffleConfDo"> update baffle_conf <set> <if test="baffleTransCode != null"> baffle_trans_code = #{baffleTransCode,jdbcType=VARCHAR}, </if> <if test="scene != null"> scene = #{scene,jdbcType=VARCHAR}, </if> <if test="acctNo != null"> acct_no = #{acctNo,jdbcType=VARCHAR}, </if> <if test="status != null"> status = #{status,jdbcType=CHAR}, </if> <if test="remark != null"> remark = #{remark,jdbcType=VARCHAR}, </if> <if test="creator != null"> creator = #{creator,jdbcType=VARCHAR}, </if> <if test="updator != null"> updator = #{updator,jdbcType=VARCHAR}, </if> <if test="createTime != null"> create_time = #{createTime,jdbcType=TIMESTAMP}, </if> <if test="updateTime != null"> update_time = #{updateTime,jdbcType=TIMESTAMP}, </if> </set> where id = #{id,jdbcType=BIGINT} </update> <update id="updateByPrimaryKey" parameterType="cn.la.finance.ws.dao.model.BaffleConfDo"> update baffle_conf set baffle_trans_code = #{baffleTransCode,jdbcType=VARCHAR}, scene = #{scene,jdbcType=VARCHAR}, acct_no = #{acctNo,jdbcType=VARCHAR}, status = #{status,jdbcType=CHAR}, remark = #{remark,jdbcType=VARCHAR}, creator = #{creator,jdbcType=VARCHAR}, updator = #{updator,jdbcType=VARCHAR}, create_time = #{createTime,jdbcType=TIMESTAMP}, update_time = #{updateTime,jdbcType=TIMESTAMP} where id = #{id,jdbcType=BIGINT} </update> </mapper>