spring+mybatis+cxf webservice实现

<?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.sunday.dao.SmsOutboxMapper"> <resultMap id="BaseResultMap" type="com.sunday.entity.SmsOutbox"> <result column="SISMSID" jdbcType="VARCHAR" property="sismsid" /> <result column="EXTCODE" jdbcType="VARCHAR" property="extcode" /> <result column="DESTADDR" jdbcType="VARCHAR" property="destaddr" /> <result column="MESSAGECONTENT" jdbcType="VARCHAR" property="messagecontent" /> <result column="REQDELIVERYREPORT" jdbcType="INTEGER" property="reqdeliveryreport" /> <result column="MSGFMT" jdbcType="INTEGER" property="msgfmt" /> <result column="SENDMETHOD" jdbcType="INTEGER" property="sendmethod" /> <result column="REQUESTTIME" jdbcType="TIMESTAMP" property="requesttime" /> <result column="APPLICATIONID" jdbcType="VARCHAR" property="applicationid" /> </resultMap> <sql id="Example_Where_Clause"> <where> <foreach collection="oredCriteria" item="criteria" separator="or"> <if test="criteria.valid"> <trim prefix="(" prefixOverrides="and" suffix=")"> <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 close=")" collection="criterion.value" item="listItem" open="(" 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="(" prefixOverrides="and" suffix=")"> <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 close=")" collection="criterion.value" item="listItem" open="(" separator=","> #{listItem} </foreach> </when> </choose> </foreach> </trim> </if> </foreach> </where> </sql> <sql id="Base_Column_List"> SISMSID, EXTCODE, DESTADDR, MESSAGECONTENT, REQDELIVERYREPORT, MSGFMT, SENDMETHOD, REQUESTTIME, APPLICATIONID </sql> <select id="selectByExample" parameterType="com.sunday.entity.SmsOutboxExample" resultMap="BaseResultMap"> select <if test="distinct"> distinct </if> <include refid="Base_Column_List" /> from sms_outbox <if test="_parameter != null"> <include refid="Example_Where_Clause" /> </if> <if test="orderByClause != null"> order by ${orderByClause} </if> </select> <delete id="deleteByExample" parameterType="com.sunday.entity.SmsOutboxExample"> delete from sms_outbox <if test="_parameter != null"> <include refid="Example_Where_Clause" /> </if> </delete> <insert id="insert" parameterType="com.sunday.entity.SmsOutbox"> insert into sms_outbox (SISMSID, EXTCODE, DESTADDR, MESSAGECONTENT, REQDELIVERYREPORT, MSGFMT, SENDMETHOD, REQUESTTIME, APPLICATIONID ) values (#{sismsid,jdbcType=VARCHAR}, #{extcode,jdbcType=VARCHAR}, #{destaddr,jdbcType=VARCHAR}, #{messagecontent,jdbcType=VARCHAR}, #{reqdeliveryreport,jdbcType=INTEGER}, #{msgfmt,jdbcType=INTEGER}, #{sendmethod,jdbcType=INTEGER}, #{requesttime,jdbcType=TIMESTAMP}, #{applicationid,jdbcType=VARCHAR} ) </insert> <insert id="insertSelective" parameterType="com.sunday.entity.SmsOutbox"> insert into sms_outbox <trim prefix="(" suffix=")" suffixOverrides=","> <if test="sismsid != null"> SISMSID, </if> <if test="extcode != null"> EXTCODE, </if> <if test="destaddr != null"> DESTADDR, </if> <if test="messagecontent != null"> MESSAGECONTENT, </if> <if test="reqdeliveryreport != null"> REQDELIVERYREPORT, </if> <if test="msgfmt != null"> MSGFMT, </if> <if test="sendmethod != null"> SENDMETHOD, </if> <if test="requesttime != null"> REQUESTTIME, </if> <if test="applicationid != null"> APPLICATIONID, </if> </trim> <trim prefix="values (" suffix=")" suffixOverrides=","> <if test="sismsid != null"> #{sismsid,jdbcType=VARCHAR}, </if> <if test="extcode != null"> #{extcode,jdbcType=VARCHAR}, </if> <if test="destaddr != null"> #{destaddr,jdbcType=VARCHAR}, </if> <if test="messagecontent != null"> #{messagecontent,jdbcType=VARCHAR}, </if> <if test="reqdeliveryreport != null"> #{reqdeliveryreport,jdbcType=INTEGER}, </if> <if test="msgfmt != null"> #{msgfmt,jdbcType=INTEGER}, </if> <if test="sendmethod != null"> #{sendmethod,jdbcType=INTEGER}, </if> <if test="requesttime != null"> #{requesttime,jdbcType=TIMESTAMP}, </if> <if test="applicationid != null"> #{applicationid,jdbcType=VARCHAR}, </if> </trim> </insert> <select id="countByExample" parameterType="com.sunday.entity.SmsOutboxExample" resultType="java.lang.Long"> select count(*) from sms_outbox <if test="_parameter != null"> <include refid="Example_Where_Clause" /> </if> </select> <update id="updateByExampleSelective" parameterType="map"> update sms_outbox <set> <if test="record.sismsid != null"> SISMSID = #{record.sismsid,jdbcType=VARCHAR}, </if> <if test="record.extcode != null"> EXTCODE = #{record.extcode,jdbcType=VARCHAR}, </if> <if test="record.destaddr != null"> DESTADDR = #{record.destaddr,jdbcType=VARCHAR}, </if> <if test="record.messagecontent != null"> MESSAGECONTENT = #{record.messagecontent,jdbcType=VARCHAR}, </if> <if test="record.reqdeliveryreport != null"> REQDELIVERYREPORT = #{record.reqdeliveryreport,jdbcType=INTEGER}, </if> <if test="record.msgfmt != null"> MSGFMT = #{record.msgfmt,jdbcType=INTEGER}, </if> <if test="record.sendmethod != null"> SENDMETHOD = #{record.sendmethod,jdbcType=INTEGER}, </if> <if test="record.requesttime != null"> REQUESTTIME = #{record.requesttime,jdbcType=TIMESTAMP}, </if> <if test="record.applicationid != null"> APPLICATIONID = #{record.applicationid,jdbcType=VARCHAR}, </if> </set> <if test="_parameter != null"> <include refid="Update_By_Example_Wh