sqlmap.txt

生成与Oracle相关的Ibatis相关配置文件及Java源码

///-------------------------------------------------------SQL MAP---------------------------------------------------------
///-----------------------------------------------------------------------------------------------------------------------
$PCONM
    	<parameter property="#COLNAME#" column="#COLNAME#" javaType="#JAVATYPE#" jdbcType="#JDBCTYPE#" /> 
$RCONM
    	<result property="#COLNAME#" column="#COLNAME#" javaType="#JAVATYPE#" jdbcType="#JDBCTYPE#" /> 
$PMAPM
    <parameterMap id="p#TABNAME#" class = "#TABNAME#">
    	#PARAMS#
    </parameterMap> 
    
$RMAPM
    <resultMap id="r#TABNAME#" class="#TABNAME#">
        #RESULTS#
    </resultMap>
///-----------------------------------------------------------------------------------------------------------------------
$SQLMAP
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd" >
#MHEAD#
<sqlMap namespace="#PROJECT#.#TABNAME#">
    <typeAlias alias="#TABNAME#" type="#TPACK#.bean.#UPTABNAME#"/> 
    #PMAPM#
    #RMAPM#
    <!-- 插入记录 -->
    <insert id="insert" #PCLASS#>
    	<![CDATA[
    		insert into #UPTABNAME#(
    			#COLS#
    		) values(
    			#COLVALS#
    		)
    	]]>
    </insert>
    	
    <!-- 更新记录 -->
    <update id="update" #PCLASS#>
    	<![CDATA[
    		update #UPTABNAME# set 
    		#COLSETS# 
    		where #KEYRULE#
    	]]>
    </update>
    
    <!-- 删除记录 -->
    <delete id="delete" parameterClass="java.lang.String">
    	<![CDATA[
    		delete #UPTABNAME# where #KEYRULE#
    	]]>
    </delete>
    
    <!-- 根据主键获取 -->
    <select id="findByPkid" parameterClass="java.lang.String" #RCLASS#>
    	<![CDATA[
    		select * from #UPTABNAME# where #KEYRULE#
    	]]>
    </select>
    
    <!-- 获取所有记录 -->
    <select id="findAll" #RCLASS#>
    	<![CDATA[
    		select * from #UPTABNAME#
    	]]>
    </select>
    
    <!-- 获取所有记录数 -->
    <select id="getAllCount" resultClass="java.lang.Integer">
    	<![CDATA[
    		select count(*) from #UPTABNAME#
    	]]>
    </select>
</sqlMap>
///-----------------------------------------------------BE END------------------------------------------------------------ 
$BEEND