build.xml 和iBATIS 配置 build.properties

<?xml>

<!--
 描 述：Ant打包工具
 作 者：吴进>

 <!-- 
       >  <property name="lib.home" value="${basedir}" />
 <property>  <property name="java.home" value="${env.JAVA_HOME}" />
 <property>

 <!-- 路径设置 包括了jar文件才能编译-->
 <path>   <!-- 项目lib下的所有jar -->
  <fileset>    <include name="**/*.jar" />
  </fileset>
  <!-- 项目tomcat>    <include name="**/*.jar" />
  </fileset>
 </path>

 <!-- 清除 -->
 <target>   <delete dir="${deploy.home}" failοnerrοr="false" />
  <delete>   <delete dir="${cache.home}" failοnerrοr="false" />
  <delete>   <echo message="卸载成功" />
 </target>

 <!-- 初始化 -->
 <target>   <mkdir dir="${build.home}" />
  <mkdir>   <mkdir dir="${build.web-inf}" />
  <mkdir>   <mkdir dir="${build.lib}" />
 </target>

 <!-- 准备 -->
 <target>   <copy todir="${build.home}">
   <fileset>   </copy>
 </target>

 <!-- 编译 -->
 <target>   <echo message="编译开始" />
  <javac>    <classpath refid="compile.classpath" />
  </javac>
  <copy>    <fileset dir="../${src.res}">
    <include>    </fileset>
  </copy>
  <echo>  </target>

 <!-- 发布 -->
 <target>   <mkdir dir="${deploy.home}" />
  <copy>    <fileset dir="${build.home}" />
  </copy>
  <echo>  </target>

 <!-- 打war包 -->
 <target>   <war destfile="${deploy.path}/${project.name}.war" webxml="${build.web-inf}/web.xml">
   <fileset>     <include name="**/*.*" />
   </fileset>
   <manifest>
    <attribute>     <attribute name="Created-By" value="jin.wu" />
    <attribute>     <attribute name="Specification-Vendor" value="${doc.vendor}" />
   </manifest>
  </war>
 </target>

 <!-- 打jar包 -->
 <target>   <delete>   <mkdir>   <jar destfile="${doc.home}/${project.name}.jar" basedir="${build.class}">
   <manifest>
    <attribute>     <attribute name="Created-By" value="jin.wu" />
    <attribute>     <attribute name="Specification-Vendor" value="${doc.vendor}" />
   </manifest>
  </jar>
 </target>

 <!-- 输出并打包api文档成rar -->
 <!-- 文档打包暂时出现GBK编码问题不能成功，暂缓 -->
 <target>   <echo message="文档打包开始" />
  <tstamp>
   <format>   </tstamp>
  <javadoc>    <classpath refid="compile.classpath" />
  </javadoc>
  <zip>    <zipfileset dir="${doc.home}" prefix="${doc.name}" />
  </zip>
  <echo>  </target>

 <!-- Tomcat 启动与停止 纯净 -->
 <target>   <exec executable="cmd" dir="${appserver.home}/bin">
   <arg>    <arg value="startup.bat" />
  </exec>
 </target>

 <target>   <exec executable="cmd" dir="${appserver.home}/bin" spawn="true">
   <arg>    <arg value="shutdown.bat" />
  </exec>
 </target>

 <!-- Tomcat 启动与停止 -->
 <target>  </target>

 <target>  </target>
</project>

----------------------------------------

build.properties

# JavaEE Ant Properties
# ==============================================================================
project.name = OTAServer2.0

appserver.home = D:/Soft/apache-tomcat-6.0.29
casserver.home = D:/Soft/apache-tomcat-6.0.29

app.version = 1.0

tomcat.lib = ${appserver.home}/lib
tomcat.manager.url => tomcat.manager.password = admin

src.home =>

src.webroot = ../WebRoot
src.meta-inf = ${src.webroot}/META-INF
src.web-inf = ${src.webroot}/WEB-INF
src.lib = ${src.web-inf}/lib

build.home = ../build
build.meta-inf = ${build.home}/META-INF
build.web-inf = ${build.home}/WEB-INF
build.class = ${build.web-inf}/classes
build.lib = ${build.web-inf}/lib

deploy.path = ${appserver.home}/webapps
deploy.home = ${deploy.path}/${project.name}
cache.home = ${appserver.home}/work/Catalina/localhost
 
doc.home = E:/Wujin/Doc_OTA2.0
doc.title = OTAServer2.0 API
doc.vendor = Tempus Age Co. Ltd.

compile.debug => compile.optimize =true

------------------------------------------

iBATIS

<?xml> <!DOCTYPE sqlMapConfig  
  PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN" 
  "http://www.ibatis.com/dtd/sql-map-config-2.dtd">
<sqlMapConfig>

 <settings
  cacheModelsEnabled="true"
  enhancementEnabled="false"
  lazyLoadingEnabled="false"
  errorTracingEnabled="true"
  maxRequests="512"
  maxSessions="50"
  maxTransactions="32"
  useStatementNamespaces="false"
       >         classInfoCacheEnabled="true"/>
 
 <sqlMap>  <sqlMap resource="mapper/ibatis/purchase/ota-init-SqlMap.xml" />
 <sqlMap> </sqlMapConfig>

 

 

-----------------------

<?xml> <!DOCTYPE sqlMap     
    PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"     
    "http://ibatis.apache.org/dtd/sql-map-2.dtd">

<sqlMap>  <typeAlias alias="failOrderinfo" type="com.tempus.OTAServer.outer.qunar.order.orderBaseVo.FailOrderInfoVo" />
 <typeAlias>  <typeAlias alias="orderNo" type="com.tempus.OTAServer.outer.qunar.order.orderBaseVo.OrderNoVo" />
 
 <resultMap>   <result property="orderNo" column="ORDER_NO" />
  <result>   <result property="type" column="TYPE" />
  <result>  </resultMap>
 
 <resultMap>   <result property="b2cOrderNo" column="B2C_ORDER_NO" />
  <result>   <result property="payStatus" column="PAY_STATUS" />
  <result>   <result property="isItineraryFlag" column="IS_ITINERARY_FLAG" />
  <result>  </resultMap>
 
 <resultMap>   <result property="orderNo" column="ORDER_NO"/>
  <result>  </resultMap>
 
 
    <!-- 添加失败订单 -->
    <insert>      <![CDATA[
      INSERT INTO FAIL_ORDER_INFO (
     ORDER_NO,
     ERROR_MSG,
     TYPE,
     STATUS
   )
   VALUES(
    #orderNo#,#errorMsg#,#type#,#status#      
   )
     
     ]]>
    </insert>
   
    <!-- 添加成功订单 -->
    <insert>      <![CDATA[
      INSERT INTO SUCCESS_ORDER_INFO (
     B2C_ORDER_NO,
     QNR_ORDER_NO,
     PAY_STATUS,
     IS_TICKET_NO_FLAG,
     IS_ITINERARY_FLAG,
     CREATE_TIME
   )
   VALUES(
    #b2cOrderNo#,#qnrOrderNo#,#payStatus#,#isTicketNoFlag#,#isItineraryFlag#,#createTime#      
   )
     
     ]]>
    </insert>
   
   
    <!-- 查询失败订单 -->
    <select>      <![CDATA[
      SELECT * FROM FAIL_ORDER_INFO WHERE  1=1
     ]]>
     
     <isNotEmpty>           STATUS = #status#
     </isNotEmpty>
     
     <isNotEmpty>          TYPE = #type#
     </isNotEmpty>
        
    </select>
    
     <!-- 更新失败订单状态 -->
    <update>      <![CDATA[
         UPDATE FAIL_ORDER_INFO SET STATUS = #status#, ERROR_MSG =#errorMsg# WHERE 1=1 
     ]]>
     
     <isNotEmpty>          ORDER_NO = #orderNo#
     </isNotEmpty>
     
     <isNotEmpty>          TYPE = #type#
     </isNotEmpty>
     
    </update>
   
     <!-- 更改增量导出订单的订单号 -->
    <update>      <![CDATA[
         UPDATE ADD_ORDERNO SET ORDER_NO = #orderNo# WHERE>      ]]>
    </update>
   
    <!-- 查询增量导出订单号 -->
    <select>      <![CDATA[
      SELECT * FROM ADD_ORDERNO WHERE TYPE = #type#
     ]]>
    </select>
   
   
     <!-- 批量查询淘宝订单信息 -->
    <select>      <![CDATA[
      SELECT * FROM SUCCESS_ORDER_INFO
       WHERE 1=1
     ]]>
     
     <isPropertyAvailable>             <isNotNull property="lstB2cOrder" prepend=" and B2C_ORDER_NO IN "> 
                <iterate>                   <![CDATA[  #lstB2cOrder[]#  ]]>
                </iterate> 
            </isNotNull> 
        </isPropertyAvailable>
     
     <isPropertyAvailable>             <isNotNull property="lstQNROrder" prepend=" and QNR_ORDER_NO IN "> 
                <iterate>                       <![CDATA[ #lstQNROrder[]#   ]]>
                </iterate> 
            </isNotNull> 
        </isPropertyAvailable>
       
        <isNotEmpty>           PAY_STATUS=#payStatus#
     </isNotEmpty>
     
     <isNotEmpty>           IS_TICKET_NO_FLAG=#isTicketNoFlag#
     </isNotEmpty>
     
     <isNotEmpty>           IS_ITINERARY_FLAG=#isItineraryFlag#
     </isNotEmpty>
          
    </select>
   
     <!-- 根据订单号查询失败订单 -->
    <select>      <![CDATA[
      SELECT * FROM FAIL_ORDER_INFO WHERE ORDER_NO = #orderNo#
     ]]>
     
      <isNotEmpty>           TYPE = #type#
     </isNotEmpty>
     
    </select>
   
      <!-- 修改异常订单的标识 -->
    <update>      <![CDATA[
      UPDATE FAIL_ORDER_INFO SET STATUS = '0'
         WHERE ORDER_NO = #orderNo#
          AND TYPE = #type#
     ]]>
    </update>
   
      <!-- 修改成功订单支付状态 -->
    <update>      <![CDATA[
      UPDATE SUCCESS_ORDER_INFO SET PAY_STATUS = '1'
         WHERE B2C_ORDER_NO = #b2cOrderNo#
     ]]>
    </update>
   
      <!-- 修改成功订单票号推送状态 -->
    <update>      <![CDATA[
      UPDATE SUCCESS_ORDER_INFO SET IS_TICKET_NO_FLAG = '1'
         WHERE B2C_ORDER_NO = #b2cOrderNo#
     ]]>
    </update>
   
     <!-- 修改成功订单快递配送推送状态 -->
    <update>      <![CDATA[
      UPDATE SUCCESS_ORDER_INFO SET IS_ITINERARY_FLAG = '1'
         WHERE B2C_ORDER_NO = #b2cOrderNo#
     ]]>
    </update>
   
     <!-- 批量查询淘宝订单信息 -->
    <select>      <![CDATA[
      SELECT * FROM SUCCESS_ORDER_INFO
       WHERE 1=1
     ]]>
            
        <isNotEmpty>           QNR_ORDER_NO = #qnrOrderNo#
     </isNotEmpty>
          
    </select>
   
</sqlMap>