`
流浪鱼
  • 浏览: 1636170 次
  • 性别: Icon_minigender_1
  • 来自: 北京
社区版块
存档分类
最新评论

sqlmap.xml的文件

 
阅读更多

使用typealias元素自定义对象

<?xml version="1.0" encoding="utf-8" standalone="no"?>
<!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN"
	"http://www.ibatis.com/dtd/sql-map-2.dtd">
	
<sqlMap namespace="project">

	<typeAlias alias="Project" type="com.voiinnov.drbl.project.bean.ProjectBean"/>
	<!-- 查询所有项目-->
	<select id="pageQuery" parameterClass="map" resultClass="java.util.HashMap">
	 	<![CDATA[
			SELECT  T1.ID,
					T1.PRJTEST_CODE,
					T1.PRJTEST_NAME,
					T1.PRJTEST_STATUS,
					T2.CUSTEST_NAME PRJOECTEST_CUSTNAME,
					T3. NAME PRJTEST_PLATE_NAME,
					T4.FLAG PRJTEST_MODEL1_NAME,
					T5.PRODUCTEST_NAME PRJTEST_PROPERTY_NAME,
					T6.NAME PRJTEST_PM_NAME,
					T7.NAME CREATOR_NAME,
					TO_CHAR(T1.CREATE_TIME, 'yyyy-MM-dd') CREATE_DATE
				FROM TEST_PRJTEST_PROJECT T1
				LEFT JOIN TEST_CUSTEST_CUSTOMER T2 ON T1.CUSTEST_ID = T2.CUSTEST_ID
				LEFT JOIN TEST_SYS_LINKAGECONFIG T3 ON T3.ID = T1.PRJTEST_PLATE1
				LEFT JOIN TEST_DATA_DICTIONARY T4 ON (
					T4. CODE = T1.PRJTEST_TYPE
					AND T4.TYPE = #PRJTEST_TYPE#
				)
				LEFT JOIN TEST_PRODUCTEST_PROCONFIG T5 ON (
		          T5.ID = T1.FACTORING_TYPE 
		        )
				LEFT JOIN TEST_USER_USER T6 ON T6.ID = T1.PRJTEST_PM
				LEFT JOIN TEST_USER_USER T7 ON T7.ID = T1.CREATE_ID
			 WHERE T1.STATUS > -2
		]]>
		<isNotEmpty prepend="" property="searchContent">
				<![CDATA[
					AND (T1.PRJTEST_CODE LIKE '%$searchContent$%' 
					OR T1.PRJTEST_NAME LIKE '%$searchContent$%'
					OR T2.CUSTEST_NAME LIKE '%$searchContent$%'
					OR T7.NAME LIKE '%$searchContent$%'
					)
				]]>
		</isNotEmpty>
		<isEmpty property="orderType">
				<![CDATA[ORDER BY T1.CREATE_TIME DESC ]]>
		</isEmpty>
		<isNotEmpty property="orderType">
				<![CDATA[ORDER BY $orderType$]]>
		</isNotEmpty>
	</select>

	<!-- 查询所有客户档案资料配置数量 -->
	<select id="pageQuery_count" parameterClass="java.util.HashMap" resultClass="java.lang.Integer">
		<![CDATA[ 
			SELECT  COUNT(T1.ID)
				FROM TEST_PRJTEST_PROJECT T1
				LEFT JOIN TEST_CUSTEST_CUSTOMER T2 ON T1.CUSTEST_ID = T2.CUSTEST_ID
				LEFT JOIN TEST_SYS_LINKAGECONFIG T3 ON T3.ID = T1.PRJTEST_PLATE1
				LEFT JOIN TEST_DATA_DICTIONARY T4 ON (
					T4. CODE = T1.PRJTEST_TYPE
					AND T4.TYPE = #PRJTEST_TYPE#
				)
				LEFT JOIN TEST_DATA_DICTIONARY T5 ON (
					T5. CODE = T1.FACTORING_TYPE
					AND T5.TYPE = #FACTORING_TYPE#
				)
				LEFT JOIN TEST_USER_USER T6 ON T6.ID = T1.PRJTEST_PM
				LEFT JOIN TEST_USER_USER T7 ON T7.ID = T1.CREATE_ID
			 WHERE T1.STATUS > -2
		 ]]>
		<isNotEmpty prepend="" property="searchContent">
				<![CDATA[
				  AND (T1.PRJTEST_CODE LIKE '%$searchContent$%' 
					OR T1.PRJTEST_NAME LIKE '%$searchContent$%'
					OR T2.CUSTEST_NAME LIKE '%$searchContent$%'
					OR T7.NAME LIKE '%$searchContent$%'
					)
				]]>
		</isNotEmpty>
	</select>
	
	<!-- 查看页面查询项目全信息 -->
	<select id="queryProjectFullInfo" parameterClass="map" resultClass="Project">
			SELECT T1.ID,
		       T1.PRJTEST_CODE,
		       T1.PRJTEST_NAME,
		       T1.PRJTEST_PM,
		       T3.NAME PRJTEST_PM_NAME,
		       T1.PM_DEPT,
		       T4.DEPTEST_NAME PM_DEPTEST_NAME,
		       T1.PRJTEST_PLATE1,
		       T5.NAME PRJTEST_PLATE1_NAME,
		       T1.PRJTEST_PLATE2,
		       T6.NAME PRJTEST_PLATE2_NAME,
		       fn_rebuild_UserName(T1.PRJTEST_AM) PRJTEST_AM_NAME,
		       T1.FACTORING_TYPE,
		       T7.PRODUCTEST_NAME FACTORING_TYPE_NAME,
		       T1.PRJTEST_TYPE,
		       T8.FLAG PRJTEST_TYPE_NAME,
		       T1.CUSTEST_CODE,
		       T1.CUSTEST_ID,
		       T9.CUSTEST_NAME CUSTEST_NAME,
		       T1.CO_AGENCY,
		       T1.CREDITEST_WAY,
		       T1.PRODUCTEST_INFO,
		       T1.TRADE_CDT,
		       T1.PRJTEST_STATUS,
		       T1.AUDITPASS_TIME,
		       T1.RECE_WAY,
		       T1.VERSION
		  FROM TEST_PRJTEST_PROJECT T1
		  LEFT JOIN TEST_USER_USER T3 ON T3.ID = T1.PRJTEST_PM
		  LEFT JOIN TEST_DEPTEST_DEPARTMENT T4 ON T4.ID = T1.PM_DEPT
		  LEFT JOIN TEST_SYS_LINKAGECONFIG T5 ON T5.ID = T1.PRJTEST_PLATE1
		  LEFT JOIN TEST_SYS_LINKAGECONFIG T6 ON T6.ID = T1.PRJTEST_PLATE2
		  LEFT JOIN TEST_PRODUCTEST_PROCONFIG T7 ON T7.ID = T1.FACTORING_TYPE
		  LEFT JOIN TEST_DATA_DICTIONARY T8 ON T8.CODE = T1.PRJTEST_TYPE AND T8.TYPE=#DTYPE1#
		  LEFT JOIN TEST_CUSTEST_CUSTOMER T9 ON T9.CUSTEST_ID = T1.CUSTEST_ID
		  WHERE T1.ID = #ID#
	</select>
	
	<insert id="insert" parameterClass="Project">
		 <selectKey resultClass="java.lang.Integer" keyProperty="ID">
	        <![CDATA[SELECT SEQ_PRJTEST_PROJECT.NEXTVAL AS ID FROM DUAL ]]>
	    </selectKey>
    <![CDATA[
     INSERT  INTO TEST_PRJTEST_PROJECT
              ( ID,
				PRJTEST_CODE,
				PRJTEST_NAME,
				PRJTEST_PM,
				PM_DEPT,
				PRJTEST_PLATE1,
				PRJTEST_PLATE2,
				PRJTEST_AM,
				FACTORING_TYPE,
				PRJTEST_TYPE,
				CUSTEST_CODE,
				CUSTEST_ID,
				CO_AGENCY,
				CREDITEST_WAY,
				PRODUCTEST_INFO,
				TRADE_CDT,
				PRJTEST_STATUS,
				AUDITPASS_TIME,
				RECE_WAY,
				VERSION,
				CREATE_TIME,
				CREATE_ID,
				MODIFY_TIME,
				MODIFY_ID,
				STATUS
               )
      VALUES  ( 
      			#ID#,
				#PRJTEST_CODE#,
				#PRJTEST_NAME#,
				#PRJTEST_PM#,
				#PM_DEPT#,
				#PRJTEST_PLATE1#,
				#PRJTEST_PLATE2#,
				#PRJTEST_AM#,
				#FACTORING_TYPE#,
				#PRJTEST_TYPE#,
				#CUSTEST_CODE#,
				#CUSTEST_ID#,
				#CO_AGENCY#,
				#CREDITEST_WAY#,
				#PRODUCTEST_INFO#,
				#TRADE_CDT#,
				#PRJTEST_STATUS#,
				#AUDITPASS_TIME#,
				#RECE_WAY#,
				#VERSION#,
				SYSDATE,
				#CREATE_ID#,
				SYSDATE,
				#MODIFY_ID#,
				0
              	)
      ]]>
  </insert>
  
  <update id="update" parameterClass="Project">
  		UPDATE TEST_PRJTEST_PROJECT
  		SET 
				<isNotEmpty prepend=" " property="PRJTEST_NAME">PRJTEST_NAME=#PRJTEST_NAME#,</isNotEmpty>
				<isNotEmpty prepend=" " property="PRJTEST_PM">PRJTEST_PM=#PRJTEST_PM#,</isNotEmpty>
				<isNotEmpty prepend=" " property="PM_DEPT">PM_DEPT=#PM_DEPT#,</isNotEmpty>
				<isNotEmpty prepend=" " property="PRJTEST_PLATE1">PRJTEST_PLATE1=#PRJTEST_PLATE1#,</isNotEmpty>
				<isNotEmpty prepend=" " property="PRJTEST_PLATE2">PRJTEST_PLATE2=#PRJTEST_PLATE2#,</isNotEmpty>
				<isNotEmpty prepend=" " property="PRJTEST_AM">PRJTEST_AM=#PRJTEST_AM#,</isNotEmpty>
				<isNotEmpty prepend=" " property="FACTORING_TYPE">FACTORING_TYPE=#FACTORING_TYPE#,</isNotEmpty>
				<isNotEmpty prepend=" " property="PRJTEST_TYPE">PRJTEST_TYPE=#PRJTEST_TYPE#,</isNotEmpty>
				<isNotEmpty prepend=" " property="CUSTEST_CODE">CUSTEST_CODE=#CUSTEST_CODE#,</isNotEmpty>
				<isNotEmpty prepend=" " property="CUSTEST_ID">CUSTEST_ID=#CUSTEST_ID#,</isNotEmpty>
				<isNotEmpty prepend=" " property="CO_AGENCY">CO_AGENCY=#CO_AGENCY#,</isNotEmpty>
				<isNotEmpty prepend=" " property="CREDITEST_WAY">CREDITEST_WAY=#CREDITEST_WAY#,</isNotEmpty>
				<isNotEmpty prepend=" " property="PRODUCTEST_INFO">PRODUCTEST_INFO=#PRODUCTEST_INFO#,</isNotEmpty>
				<isNotEmpty prepend=" " property="TRADE_CDT">TRADE_CDT=#TRADE_CDT#,</isNotEmpty>
				<isNotEmpty prepend=" " property="PRJTEST_STATUS">PRJTEST_STATUS=#PRJTEST_STATUS#,</isNotEmpty>
				<isNotEmpty prepend=" " property="AUDITPASS_TIME">AUDITPASS_TIME=#AUDITPASS_TIME#,</isNotEmpty>
				<isNotEmpty prepend=" " property="RECE_WAY">RECE_WAY=#RECE_WAY#,</isNotEmpty>
				<isNotEmpty prepend=" " property="VERSION">VERSION=#VERSION#,</isNotEmpty>
				<isNotEmpty prepend=" " property="MODIFY_TIME">MODIFY_TIME=SYSDATE,</isNotEmpty>
				<isNotEmpty prepend=" " property="MODIFY_ID">MODIFY_ID=#MODIFY_ID#, </isNotEmpty>
				ID=#ID#
         WHERE ID=#ID#
  </update>
  
  <select id="getById" parameterClass="map" resultClass="Project">
  		SELECT  ID,
				PRJTEST_CODE,
				PRJTEST_NAME,
				PRJTEST_PM,
				PM_DEPT,
				PRJTEST_PLATE1,
				PRJTEST_PLATE2,
				PRJTEST_AM,
				FACTORING_TYPE,
				PRJTEST_TYPE,
				CUSTEST_CODE,
				CUSTEST_ID,
				CO_AGENCY,
				CREDITEST_WAY,
				PRODUCTEST_INFO,
				TRADE_CDT,
				PRJTEST_STATUS,
				AUDITPASS_TIME,
				RECE_WAY,
				VERSION,
				CREATE_TIME,
				CREATE_ID,
				STATUS
             FROM TEST_PRJTEST_PROJECT
             WHERE ID = #ID# 
  </select>
  
</sqlMap>

全部使用map的类型

<?xml version="1.0" encoding="utf-8" standalone="no"?>
<!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN"
	"http://www.ibatis.com/dtd/sql-map-2.dtd">
<!-- 
	资源配置
 -->
<sqlMap namespace="permissionConfig">
	
	<!-- 
		查询所有角色
	 -->
	<select id="queryRoleList" parameterClass="map" resultClass="java.util.HashMap">
		<![CDATA[ SELECT ID,NAME FROM TEST_PERMISSION_ROLE WHERE STATUS = 0 ORDER BY ID ]]>
	</select>
	<!-- 
		通过角色查询资源菜单(STATUS：0已分配 1未分配)
	 -->
	 <resultMap class="hashmap" id="queryPermissionByRoleIdMap">
	 	<result property="id" column="ID"/>
	 	<result property="name" column="NAME"/>
	 	<result property="pId" column="PARENTEST_ID"/>
	 	<result property="level_num" column="LEVEL_NUM"/>
	 </resultMap>
	 <select id="queryPermissionByRoleId" parameterClass="map" resultMap="queryPermissionByRoleIdMap">
	 			SELECT  *
				FROM    ( SELECT  T1.ID ,
				                  T1.NAME ,
				                  NVL(T1.PARENTEST_ID,0) PARENTEST_ID,
				                  T1.LEVEL_NUM
				          FROM    TEST_PERMISSION_RESOURCE T1
				          WHERE   T1.ID <isEqual property="STATUS" compareValue="1"> NOT </isEqual> IN (
				                  SELECT  RESOURCE_ID
				                  FROM    TEST_PERMISSION_RESOURCE2ROLE
				                  WHERE   ROLE_ID = #ROLE_ID#
				                          AND STATUS = 0 )
				                  AND T1.STATUS = 0
				                  AND PARENTEST_ID IS NOT NULL
				          UNION ALL
				          SELECT  T1.ID ,
				                  T1.NAME ,
				                  NVL(T1.PARENTEST_ID,0) PARENTEST_ID,
				                  T1.LEVEL_NUM
				          FROM    TEST_PERMISSION_RESOURCE T1
				          WHERE   T1.STATUS = 0
				                  AND PARENTEST_ID IS NULL
				                  AND ID IN (
				                  SELECT  T1.PARENTEST_ID
				                  FROM    TEST_PERMISSION_RESOURCE T1
				                  WHERE   T1.ID <isEqual property="STATUS" compareValue="1"> NOT </isEqual> IN (
				                          SELECT  RESOURCE_ID
				                          FROM    TEST_PERMISSION_RESOURCE2ROLE
				                          WHERE   ROLE_ID = #ROLE_ID#
				                                  AND STATUS = 0 )
				                          AND T1.STATUS = 0 )
				        ) T
				ORDER BY LEVEL_NUM
	 </select>
	 
	 <!-- 
	 	查询所有公司
	  -->
	   <resultMap class="hashmap" id="queryCompanyMap">
	 	<result property="id" column="ID"/>
	 	<result property="name" column="NAME"/>
	 	<result property="pId" column="PARENTEST_ID"/>
	 	<result property="pId" column="PARENTEST_ID"/>
	 	<result property="type" column="TYPE"/>
	 	<result property="flag" column="FLAG"/>
	 </resultMap>
	  <select id="queryAllCompany" parameterClass="map" resultMap="queryCompanyMap">
	  	<![CDATA[
	  		SELECT DECP_ID ID, DECP_NAME_CN NAME, PARENTEST_ID , 'DECP' TYPE , 0 FLAG
				  FROM TEST_DEPTEST_COMPANY
				 WHERE STATUS = 0
				 ORDER BY DECP_ID
	  	]]>
	  </select>
	  
	   <!-- 
	 	查询所有部门
	  -->
	  <resultMap class="hashmap" id="queryDepartmentMap">
	 	<result property="id" column="ID"/>
	 	<result property="name" column="NAME"/>
	 	<result property="pId" column="PARENTEST_ID"/>
	 	<result property="parentId" column="PARENTEST_ID"/>
	 	<result property="decpId" column="DECP_ID"/>
	 	<result property="type" column="TYPE"/>
	 	<result property="flag" column="FLAG"/>
	  </resultMap>
	  <select id="queryAllDepartment" parameterClass="map" resultMap="queryDepartmentMap">
	  	<![CDATA[
  			SELECT ID, DEPTEST_NAME NAME, PARENTEST_ID ,DECP_ID , 'DEPT' TYPE , 0 FLAG
			  FROM TEST_DEPTEST_DEPARTMENT
			 WHERE STATUS = 0
			 ORDER BY ID
	  	]]>
	  </select>
	 
	 <!-- 
		通过角色查询未分配员工(STATUS：0已分配 1未分配)
	 -->
	  <resultMap class="hashmap" id="queryNoUserByRoleIdMap">
	 	<result property="id" column="ID"/>
	 	<result property="name" column="NAME"/>
	 	<result property="pId" column="PARENTEST_ID"/>
	 	<result property="flag" column="FLAG"/>
	 </resultMap>
	 <select id="queryNoUserByRoleId" parameterClass="map" resultMap="queryNoUserByRoleIdMap">
	        SELECT  ID ,
	                  NAME ,
	                  NVL(DEPTEST_ID,0) PARENTEST_ID,
	                  1 FLAG
	          FROM    TEST_USER_USER
	          WHERE   STATUS = 0
	                  AND ID NOT IN ( SELECT  EMPLOYEE_ID
	                                  FROM    TEST_USER_USER2ROLE
	                                  WHERE   ROLE_ID = #ROLE_ID#
	                                          AND STATUS = 0 )
	 </select>
	  <!-- 
		通过角色查询已分配员工
	 -->
	  <resultMap class="hashmap" id="queryUserByRoleIdMap">
	 	<result property="id" column="ID"/>
	 	<result property="name" column="NAME_"/>
	 	<result property="trueName" column="NAME"/>
	 	<result property="parentId" column="PARENTEST_ID"/>
	 	<result property="flag" column="FLAG"/>
	 </resultMap>
	 <select id="queryUserByRoleId" parameterClass="map" resultMap="queryUserByRoleIdMap">
	      SELECT T1.ID ,
			        T1.NAME ,
					CASE WHEN T2.DEPTEST_NAME IS NOT NULL THEN 
			        T1.NAME || #POINTER# || T2.DEPTEST_NAME 
					ELSE T1.NAME END NAME_,
			        NVL(T1.DEPTEST_ID , 0) PARENTEST_ID ,
			        1 FLAG
			 FROM   TEST_USER_USER T1
			        LEFT JOIN TEST_DEPTEST_DEPARTMENT T2 ON ( T1.DEPTEST_ID = T2.ID
			                                            AND T2.STATUS = 0 )
			 WHERE  T1.STATUS = 0
			        AND T1.ID IN ( SELECT EMPLOYEE_ID
			                       FROM   TEST_USER_USER2ROLE
			                       WHERE  ROLE_ID = #ROLE_ID#
			                              AND STATUS = 0 )
	 </select>
	 
	 <!-- 
	 	根据角色id删除已分配资源
	  -->
	 <delete id="deleteResourceByRoleId" parameterClass="map">
	 	<![CDATA[
	 		DELETE FROM TEST_PERMISSION_RESOURCE2ROLE  WHERE ROLE_ID = #ROLE_ID#
	 	]]>
	 </delete>
	 <!-- 
	 	分配资源
	  -->
	  <insert id="createResourceToRole" parameterClass="map">
	  	<![CDATA[
	  		INSERT INTO TEST_PERMISSION_RESOURCE2ROLE (
	  				ID,
  		            ROLE_ID,
  		            RESOURCE_ID,
  		            STATUS,
  		            CREATE_DATE
  		           ) VALUES (
  		            SEQ_PERMISSION_RESOU2ROLE.NEXTVAL,
  		     		#ROLE_ID#,
  		            #RESOURCE_ID#,
  		            0,
  		            SYSDATE
  		     		)
	  	]]>
	  </insert>
	  
	   <!-- 
	 	根据角色id删除已分配人员
	  -->
	 <delete id="deleteUserByRoleId" parameterClass="map">
	 	<![CDATA[
	 		DELETE FROM TEST_USER_USER2ROLE  WHERE ROLE_ID = #ROLE_ID#
	 	]]>
	 </delete>
	 <!-- 
	 	分配人员
	  -->
	  <insert id="createUserToRole" parameterClass="map">
	  	<![CDATA[
	  		INSERT INTO TEST_USER_USER2ROLE (
	  				ID,
	  		 		EMPLOYEE_ID,
	  		 		ROLE_ID,
	  		 		STATUS,
	  		 		CREATE_DATE
	  		 	  ) VALUES (
	  		 	    SEQ_USER_USER2ROLE.NEXTVAL,
	  		 	  	#EMPLOYEE_ID#,
	  		 	  	#ROLE_ID#,
	  		 	  	0,
	  		 	  	SYSDATE
	  		 	  )
	  	]]>
	  </insert>
</sqlMap>

  

 

 

 

分享到：
| cacheModel元素
评论
发表评论

您还没有登录,请您登录后再发表评论

相关推荐

    SqlMap.xsd

    SqlMap.xsd SqlMap.xsd

    ibatis sqlmap配置详解

    SqlMap的配置是iBatis中应用的核心。这部分任务占据了iBatis开发的...Sql Map配置文件是iBatis配置的核心，从数据库连接到执行SQL时使用的sqlMap文件都是通过此文件中的配置提供给框架的，它通常命名为sqlMapConfig.xml

    SqlMap自动生成小工具SqlMapAutoGen1.0

    设计思路： 通过java原生的反射机制获取java类的私有字段 1)获取字段名转换成数据库字段名 注意这里有潜规则，默认是这样处理的 createDateTime --&gt; CREATE_DATE_TIME ...文件名 = 表名 + "_SqlMap.xml

    原创的一个iBatis例子

    SqlMapConfig.xml：SqlMap配置，在最后应该加上每个表的Map文件，特别注意useStatementNamespaces="true"不能为false org：生成的代码，分为三个目录，目录名在ibatorConfig.xml中指定 注意：其中生成的person_...

    ibatis配置文件模板

    ibatis配置文件模板.包括（SqlMap.properties和SqlMapConfig.xml以及跟javabean的映射文件）

    ibatis.net入门实例,应用程序

    注意事项：各xml文件的头部信息xmlns，xmlns:xsi不能改 对本入门例子需要修改的地方： 1，首先根据自己的数据库，修改SqlMap.config的数据库联接信息 2，入门后修改：sqlmap和表 环境:.net2.0,vs2005

    mybatis自动生成工具

    举例: 如你有一个模板 SqlMap.xml.ftl 将变为 SqlMap.xml 所以你要生成ftl扩展名的文件,应该将文件名从 list.ftl =&gt; list.ftl.ftl 七. 模板自动include所有父目录的:macro.include文件,可以存放公共的macro ...

    ibatis代码自动生成工具项目

    自动生成ibatis所需文件，达到快速查询，减少工作量的效果 CorpChannelDAO.java CorpChannelDAOimpl....game_channel__corp_channel_SqlMap.xml 详情步骤请见http://blog.csdn.net/yjqyyjw/article/details/48089041

    JAVA代码生成工具

    举例: 如你有一个模板 SqlMap.xml.ftl 将变为 SqlMap.xml 所以你要生成ftl扩展名的文件,应该将文件名从 list.ftl =&gt; list.ftl.ftl 七. 模板自动include所有父目录的:macro.include文件,可以存放公共的macro ...

    一个基于oralce java 的ibatis 映射文件生成工具

    基于oracle的,支持生成序列,pojo sqlmap.xml,dao daointerface,生成字段的注释 四个基本方法,增删改查, 写的时候基于oracle11的,低版本的可能在到得字段注释 的地方会不兼容,自已改改或不加注释就可以了

    iBATIS 帮助文档

    SQL Map XML配置文件..............................................................................................................10 元素...................................................................

    好用的代码生成源码

    举例: 如你有一个模板 SqlMap.xml.ftl 将变为 SqlMap.xml 所以你要生成ftl扩展名的文件,应该将文件名从 list.ftl =&gt; list.ftl.ftl 5.模板自动include同级目录:macro.include文件 示例: 如你的模板为 java_src/...

    ibatis2代码生成工具（生成实体Bean,Dao,SqlMap）

    须将ibatorConfig.xml文件中的相关数据库、表、文件目录改成你自己的即可使用.

    IBATIS实用记录

    2.1 SQLMAPCONFIG.XML文件 3 2.1.1 Settings 节点 3 2.1.2 transactionManager节点 4 2.1.3 dataSource节点 4 2.1.4 sqlMap节点 6 3. IBATIS基础语义 6 3.1 XMLSQLMAPCLIENTBUILDER 6 3.2 SQLMAPCLIENT 6 3.3 ...

    ibaits2.3.4源代码

    转载请注明:来自http://blog.csdn.net/M_ChangGong/作者:张燕广该系列文章我主要是在JavaSE工程中演示一下通过 ...ibaits配置文件一般命名为 sqlmap-config.xml，但不一定非要如此命名。在src目录下创建sqlmap-confi

    ibatis 开发指南(pdf)

    xml version="1.0" encoding="UTF-8" ?&gt; &lt;!DOCTYPE sqlMapConfig PUBLIC "-//iBATIS....

    ibatis配置文件自动加载组件

    将代码更新到src目录下；即可！对应的ibatis的版本是2.3.4；建议使用同版本测试。 如有改动，请sqlmap的xml文件格式化后保存，这样以便组件发现修改时间不同而重新加载。

    ibatis-sqlMap-入门教程（代码）

    eclipse工程，工程中所用到library在lib文件夹下，建表的语句在工程文件下person.sql

Magicbox
Global site tag (gtag.js) - Google Analytics