Maven + spring + mybatis + mysql + 事务管理

<?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="ctp.demo.dao.db.mybatis.mapper.CtpPartnerinfoMapper" > <resultMap id="BaseResultMap" type="ctp.demo.entity.CtpPartnerinfo" > <id column="id" property="id" jdbcType="INTEGER" /> <result column="PARTNER_ID" property="partnerId" jdbcType="VARCHAR" /> <result column="PARTNER_DESC" property="partnerDesc" jdbcType="VARCHAR" /> <result column="PARTNER_PLANT_ID" property="partnerPlantId" jdbcType="VARCHAR" /> <result column="PARTNER_PLANT_KEY" property="partnerPlantKey" jdbcType="VARCHAR" /> <result column="NOTIFY_URL" property="notifyUrl" jdbcType="VARCHAR" /> <result column="IS_NEED_REFUND" property="isNeedRefund" jdbcType="BIT" /> <result column="IP_LIMIT" property="ipLimit" jdbcType="VARCHAR" /> <result column="LAST_DATE" property="lastDate" jdbcType="TIMESTAMP" /> <result column="HF_ORDER_SOURCE" property="hfOrderSource" jdbcType="INTEGER" /> <result column="HF_VERIFY_KEY" property="hfVerifyKey" jdbcType="VARCHAR" /> <result column="IS_CHECK_PROD" property="isCheckProd" jdbcType="BIT" /> <result column="PARTNER_STATUS" property="partnerStatus" jdbcType="BIT" /> <result column="CHECK_SALESAMOUNT_TYPE" property="checkSalesamountType" jdbcType="BIT" /> <result column="PARTNER_ADDTION" property="partnerAddtion" jdbcType="VARCHAR" /> <result column="IS_NEED_NOTIFY" property="isNeedNotify" jdbcType="BIT" /> <result column="BATCH_ALLOW_PARTSUCC" property="batchAllowPartsucc" jdbcType="BIT" /> <result column="LAST_GET_DATE" property="lastGetDate" jdbcType="VARCHAR" /> <result column="PUBLIC_KEY" property="publicKey" jdbcType="VARCHAR" /> <result column="PRIVATE_KEY" property="privateKey" jdbcType="VARCHAR" /> <result column="IS_NEED_RESEND" property="isNeedResend" jdbcType="BIT" /> <result column="QUERY_LIMIT_TIME" property="queryLimitTime" jdbcType="INTEGER" /> <result column="QUERY_LIMIT_NUMBER" property="queryLimitNumber" jdbcType="INTEGER" /> <result column="SUBMIT_LIMIT_TIME" property="submitLimitTime" jdbcType="INTEGER" /> <result column="SUBMIT_LIMIT_NUMBER" property="submitLimitNumber" jdbcType="INTEGER" /> <result column="DB_INDEX" property="dbIndex" jdbcType="VARCHAR" /> <result column="IS_NEED_ONOFF" property="isNeedOnoff" jdbcType="BIT" /> <result column="ONOFF_URL" property="onoffUrl" jdbcType="VARCHAR" /> <result column="OLD_DB_INDEX" property="oldDbIndex" jdbcType="VARCHAR" /> <result column="CONVER_URL" property="converUrl" jdbcType="VARCHAR" /> </resultMap> <sql id="Base_Column_List" > id, PARTNER_ID, PARTNER_DESC, PARTNER_PLANT_ID, PARTNER_PLANT_KEY, NOTIFY_URL, IS_NEED_REFUND, IP_LIMIT, LAST_DATE, HF_ORDER_SOURCE, HF_VERIFY_KEY, IS_CHECK_PROD, PARTNER_STATUS, CHECK_SALESAMOUNT_TYPE, PARTNER_ADDTION, IS_NEED_NOTIFY, BATCH_ALLOW_PARTSUCC, LAST_GET_DATE, PUBLIC_KEY, PRIVATE_KEY, IS_NEED_RESEND, QUERY_LIMIT_TIME, QUERY_LIMIT_NUMBER, SUBMIT_LIMIT_TIME, SUBMIT_LIMIT_NUMBER, DB_INDEX, IS_NEED_ONOFF, ONOFF_URL, OLD_DB_INDEX, CONVER_URL </sql> <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Integer" > select <include refid="Base_Column_List" /> from ctp_partnerinfo where id = #{id,jdbcType=INTEGER} </select> <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer" > delete from ctp_partnerinfo where id = #{id,jdbcType=INTEGER} </delete> <insert id="insert" parameterType="ctp.demo.entity.CtpPartnerinfo" > insert into ctp_partnerinfo (id, PARTNER_ID, PARTNER_DESC, PARTNER_PLANT_ID, PARTNER_PLANT_KEY, NOTIFY_URL, IS_NEED_REFUND, IP_LIMIT, LAST_DATE, HF_ORDER_SOURCE, HF_VERIFY_KEY, IS_CHECK_PROD, PARTNER_STATUS, CHECK_SALESAMOUNT_TYPE, PARTNER_ADDTION, IS_NEED_NOTIFY, BATCH_ALLOW_PARTSUCC, LAST_GET_DATE, PUBLIC_KEY, PRIVATE_KEY, IS_NEED_RESEND, QUERY_LIMIT_TIME, QUERY_LIMIT_NUMBER, SUBMIT_LIMIT_TIME, SUBMIT_LIMIT_NUMBER, DB_INDEX, IS_NEED_ONOFF, ONOFF_URL, OLD_DB_INDEX, CONVER_URL ) values (#{id,jdbcType=INTEGER}, #{partnerId,jdbcType=VARCHAR}, #{partnerDesc,jdbcType=VARCHAR}, #{partnerPlantId,jdbcType=VARCHAR}, #{partnerPlantKey,jdbcType=VARCHAR}, #{notifyUrl,jdbcType=VARCHAR}, #{isNeedRefund,jdbcType=BIT}, #{ipLimit,jdbcType=VARCHAR}, #{lastDate,jdbcType=TIMESTAMP}, #{hfOrderSource,jdbcType=INTEGER}, #{hfVerifyKey,jdbcType=VARCHAR}, #{isCheckProd,jdbcType=BIT}, #{partnerStatus,jdbcType=BIT}, #{checkSalesamountType,jdbcType=BIT}, #{partnerAddtion,jdbcType=VARCHAR}, #{isNeedNotify,jdbcType=BIT}, #{batchAllowPartsucc,jdbcType=BIT}, #{lastGetDate,jdbcType=VARCHAR}, #{publicKey,jdbcType=VARCHAR}, #{privateKey,jdbcType=VARCHAR}, #{isNeedResend,jdbcType=BIT}, #{queryLimitTime,jdbcType=INTEGER}, #{queryLimitNumber,jdbcType=INTEGER}, #{submitLimitTime,jdbcType=INTEGER}, #{submitLimitNumber,jdbcType=INTEGER}, #{dbIndex,jdbcType=VARCHAR}, #{isNeedOnoff,jdbcType=BIT}, #{onoffUrl,jdbcType=VARCHAR}, #{oldDbIndex,jdbcType=VARCHAR}, #{converUrl,jdbcType=VARCHAR} ) </insert> <insert id="insertSelective" parameterType="ctp.demo.entity.CtpPartnerinfo" > insert into ctp_partnerinfo <trim prefix="(" suffix=")" suffixOverrides="," > <if test="id != null" > id, </if> <if test="partnerId != null" > PARTNER_ID, </if> <if test="partnerDesc != null" > PARTNER_DESC, </if> <if test="partnerPlantId != null" > PARTNER_PLANT_ID, </if> <if test="partnerPlantKey != null" > PARTNER_PLANT_KEY, </if> <if test="notifyUrl != null" > NOTIFY_URL, </if> <if test="isNeedRefund != null" > IS_NEED_REFUND, </if> <if test="ipLimit != null" > IP_LIMIT, </if> <if test="lastDate != null" > LAST_DATE, </if> <if test="hfOrderSource != null" > HF_ORDER_SOURCE, </if> <if test="hfVerifyKey != null" > HF_VERIFY_KEY, </if> <if test="isCheckProd != null" > IS_CHECK_PROD, </if> <if test="partnerStatus != null" > PARTNER_STATUS, </if> <if test="checkSalesamountType != null" > CHECK_SALESAMOUNT_TYPE, </if> <if test="partnerAddtion != null" > PARTNER_ADDTION, </if> <if test="isNeedNotify != null" > IS_NEED_NOTIFY, </if> <if test="batchAllowPartsucc != null" > BATCH_ALLOW_PARTSUCC, </if> <if test="lastGetDate != null" > LAST_GET_DATE, </if> <if test="publicKey != null" > PUBLIC_KEY, </if> <if test="privateKey != null" > PRIVATE_KEY, </if> <if test="isNeedResend != null" > IS_NEED_RESEND, </if> <if test="queryLimitTime != null" > QUERY_LIMIT_TIME, </if> <if test="queryLimitNumber != null" > QUERY_LIMIT_NUMBER, </if> <if test="submitLimitTime != null" > SUBMIT_LIMIT_TIME, </if> <if test="submitLimitNumber != null" > SUBMIT_LIMIT_NUMBER, </if> <if test="dbIndex != null" > DB_INDEX, </if> <if test="isNeedOnoff != null" > IS_NEED_ONOFF, </if> <if test="onoffUrl != null" > ONOFF_URL, </if> <if test="oldDbIndex != null" > OLD_DB_INDEX, </if> <if test="converUrl != null" > CONVER_URL, </if> </trim> <trim prefix="values (" suffix=")" suffixOverrides="," > <if test="id != null" > #{id,jdbcType=INTEG