<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" "http://www.ibatis.com/dtd/sql-map-2.dtd">
<sqlMap namespace="${Entity}">
<!-- Alias Map Defined -->
<typeAlias alias="${Entity}Query" type="${query_p}.${Entity}Query" />
<typeAlias alias="${Entity}" type="${entity_p}.${Entity}" />
<resultMap id="${entity}" class="${Entity}">
<#list fields as field>
<result property="<#list field.name?split('_') as n><#if n_index ==0>${n}<#else>${n?cap_first}</#if></#list>" column="${field.name}" />
</#list>
</resultMap>
<!-- Select SQL -->
<sql id="${entity}.selector">
SELECT
<dynamic>
<isNotEmpty property="fields">
$fields$
</isNotEmpty>
<isEmpty property="fields">
<#list fields as field><#if field_has_next>${field.name},<#else>${field.name}</#if></#list>
</isEmpty>
</dynamic>
FROM ${table}
</sql>
<sql id="${entity}List.where">
<dynamic prepend=" WHERE ">
<#list fields as field>
<isNotNull property="<#list field.name?split('_') as n><#if n_index ==0>${n}<#else>${n?cap_first}</#if></#list>" prepend=" AND ">
<#if field.fieldType?contains("bigint") || field.fieldType?contains("int") || field.fieldType?contains("datetime") || field.fieldType?contains("binary") || field.fieldType?contains("blob") || field.fieldType?contains("float") || field.fieldType?contains("double")>
${field.name}=#<#list field.name?split('_') as n><#if n_index ==0>${n}<#else>${n?cap_first}</#if></#list>#
<#else>
<isEqual property="<#list field.name?split('_') as n><#if n_index ==0>${n}<#else>${n?cap_first}</#if></#list>Like" compareValue="false">
${field.name}=#<#list field.name?split('_') as n><#if n_index ==0>${n}<#else>${n?cap_first}</#if></#list>#
</isEqual>
<isEqual property="<#list field.name?split('_') as n><#if n_index ==0>${n}<#else>${n?cap_first}</#if></#list>Like" compareValue="true">
<![CDATA[ ${field.name} like '%$<#list field.name?split('_') as n><#if n_index ==0>${n}<#else>${n?cap_first}</#if></#list>$%' ]]>
</isEqual>
</#if>
</isNotNull>
</#list>
</dynamic>
</sql>
<!-- 用#号会导致druid连接池报错 -->
<sql id="${entity}List.order">
<dynamic prepend=" ORDER BY ">
<isNotEmpty property="orderFields">
<iterate property="orderFields" conjunction="," open=""
close="">
$orderFields[].fieldName$ $orderFields[].order$
</iterate>
</isNotEmpty>
</dynamic>
</sql>
<sql id="${entity}List.limit">
<dynamic prepend=" LIMIT ">
<isNotEmpty property="startRow">
#startRow#,#pageSize#
</isNotEmpty>
</dynamic>
</sql>
<!-- 根据主键查询 -->
<select id="${Entity}.get${Entity}ByKey" resultMap="${entity}" parameterClass="hashMap">
SELECT <#list fields as field><#if field_has_next>${field.name},<#else>${field.name}</#if></#list> FROM ${table}
WHERE
${fields[0].name}=#id#
</select>
<select id="${Entity}.get${Entity}sByKeys" resultMap="${entity}"
parameterClass="hashMap">
SELECT <#list fields as field><#if field_has_next>${field.name},<#else>${field.name}</#if></#list> FROM ${table}
WHERE
${fields[0].name} in
<iterate conjunction="," open="(" close=")" property="keys">
#keys[]#
</iterate>
</select>
<!-- 根据主键删除 -->
<delete id="${Entity}.deleteByKey" parameterClass="hashMap">
DELETE FROM ${table}
WHERE
${fields[0].name}=#id#
</delete>
<delete id="${Entity}.deleteByKeys">
DELETE FROM ${table}
WHERE
${fields[0].name} in
<iterate conjunction="," open="(" close=")" property="keys">
#keys[]#
</iterate>
</delete>
<!-- 根据主键更新 -->
<update id="${Entity}.update${Entity}ByKey" parameterClass="${Entity}">
UPDATE ${table}
<dynamic prepend="SET">
<#list fields as field>
<isNotNull prepend="," property="<#list field.name?split('_') as n><#if n_index ==0>${n}<#else>${n?cap_first}</#if></#list>">
${field.name} = #<#list field.name?split('_') as n><#if n_index ==0>${n}<#else>${n?cap_first}</#if></#list>#
</isNotNull>
</#list>
</dynamic>
WHERE
${fields[0].name}=#<#list fields[0].name?split('_') as n><#if n_index ==0>${n}<#else>${n?cap_first}</#if></#list>#
</update>
<!-- 分页 -->
<select id="${Entity}.get${Entity}ListWithPage" parameterClass="${Entity}Query"
resultMap="${entity}">
<include refid="${entity}.selector" />
<include refid="${entity}List.where" />
<include refid="${entity}List.order" />
<include refid="${entity}List.limit" />
</select>
<select id="${Entity}.get${Entity}ListCount" parameterClass="${Entity}Query"
resultClass="int">
SELECT count(1) FROM ${table}
<include refid="${entity}List.where" />
</select>
<select id="${Entity}.get${Entity}List" parameterClass="${Entity}Query"
resultMap="${entity}">
<include refid="${entity}.selector" />
<include refid="${entity}List.where" />
<include refid="${entity}List.order" />
</select>
<!-- 如果使用自定义字段查询,则要使用resultClass否则会出现异常 -->
<select id="${Entity}.get${Entity}ListWithPageFields" parameterClass="${Entity}Query"
resultClass="${Entity}">
<include refid="${entity}.selector" />
<include refid="${entity}List.where" />
<include refid="${entity}List.order" />
<include refid="${entity}List.limit" />
</select>
<select id="${Entity}.get${Entity}ListFields" parameterClass="${Entity}Query"
resultClass="${Entity}">
<include refid="${entity}.selector" />
<include refid="${entity}List.where" />
<include refid="${entity}List.order" />
</select>
<insert id="${Entity}.insert${Entity}" parameterClass="${Entity}">
INSERT INTO ${table}
<dynamic prepend="(" close=")">
<#list fields as field>
<isNotEmpty prepend="," property="<#list field.name?split('_') as n><#if n_index ==0>${n}<#else>${n?cap_first}</#if></#list>">
${field.name}
</isNotEmpty>
</#list>
</dynamic>
VALUES
<dynamic prepend="(" close=")">
<#list fields as field>
<isNotEmpty prepend="," property="<#list field.name?split('_') as n><#if n_index ==0>${n}<#else>${n?cap_first}</#if></#list>">
#<#list field.name?split('_') as n><#if n_index ==0>${n}<#else>${n?cap_first}</#if></#list>#
</isNotEmpty>
</#list>
</dynamic>
<selectKey resultClass="<@fieldType type=fields[0].fieldType/>" keyProperty="<#list fields[0].name?split('_') as n><#if n_index ==0>${n}<#else>${n?cap_first}</#if></#list>">
SELECT LAST_INSERT_ID() AS ${fields[0].name?upper_case}
</selectKey>
</insert>
</sqlMap>
<#macro fieldType type>
<#if type?contains("bigint")>
Long<#t/>
<#elseif type?contains("int")>
Integer<#t/>
<#elseif type?contains("datetime")>
Date<#t/>
<#elseif type?contains("binary") || type?contains("blob")>
Byte[]<#t/>
<#elseif type?contains("float")>
Float<#t/>
<#elseif type?contains("double")>
Double<#t/>
<#else>
String<#t/>
</#if>
</#macro>
Spring + Ibatis 与mysql集群集成 （249个子文件） 
ModuleGenerator.class 9KB RequestUtils.class 8KB WebErrors.class 8KB OrderQuery.class 5KB UserQuery.class 5KB MemcachedDangaCache.class 5KB DataDaoImpl.class 5KB CacheSessionProvider.class 4KB FrontContextInterceptor.class 4KB OrderServiceImpl.class 4KB MemcachedSpyCache.class 4KB UserServiceImpl.class 4KB OrderDao.class 4KB UserDao.class 4KB SimpleFreeMarkerView.class 4KB CookieUtils.class 3KB EhcacheSessionCache.class 3KB TestAct.class 3KB WebErrors.class 3KB XssHttpServletRequestWrapper.class 2KB OrderAct.class 2KB DateTypeEditor.class 2KB SimplePage.class 2KB UserAct.class 2KB Field.class 2KB TestUser.class 2KB TestOrder.class 2KB HttpSessionProvider.class 2KB ResponseUtils.class 2KB ProcessTimeFilter.class 2KB Order.class 2KB User.class 2KB Constraints.class 2KB MessageResolver.class 2KB Table.class 2KB BaseQuery.class 2KB XssFilter.class 2KB AbstractSpringJunitTest.class 2KB DataMngImpl.class 2KB AdminContextInterceptor.class 2KB JugUUIDGenerator.class 2KB HashFunction.class 1KB JdkUUIDGenerator.class 1KB SimpleFreeMarkerViewResolver.class 1KB RichFreeMarkerViewResolver.class 1KB ServletContextRealPathResolver.class 1KB AdminLocaleInterceptor.class 1KB Pagination.class 1KB FrontUtils.class 1KB OrderQuery$OrderField.class 1KB UserQuery$OrderField.class 1KB RichFreeMarkerView.class 972B BindingInitializer.class 947B OrderService.class 946B UserService.class 931B SessionCache.class 705B Constants.class 657B SessionProvider.class 623B DataMng.class 556B DataDao.class 556B Paginable.class 309B RealPathResolver.class 200B SessionIdGenerator.class 187B .classpath 962B org.eclipse.wst.common.component 566B org.eclipse.wst.jsdt.ui.superType.container 49B
index.html 566B
druid-0.2.26.jar 1.71MB IKAnalyzer2012_u6.jar 1.11MB lucene-core-3.0.3.jar 1010KB jna.jar 983KB freemarker-2.3.16.jar 860KB spring-core-3.2.4.RELEASE.jar 849KB spring-context-3.2.4.RELEASE.jar 843KB jackson-mapper-asl-1.9.12.jar 762KB mvel2-2.1.0.Final.jar 724KB mysql-connector-5.1.8.jar 707KB spring-webmvc-3.2.4.RELEASE.jar 622KB spring-web-3.2.4.RELEASE.jar 611KB c3p0-0.9.1.2.jar 596KB spring-beans-3.2.4.RELEASE.jar 594KB javassist-3.9.0.jar 582KB commons-collections-3.1.jar 546KB xstream-1.4.2.jar 470KB log4j-1.2.16.jar 470KB spymemcached-2.3.1.jar 470KB spring-test-3.2.4.RELEASE.jar 447KB antlr-2.7.6.jar 433KB quartz-1.6.0.jar 412KB spring.web.servlet-3.0.5.jar 409KB spring-jdbc-3.2.4.RELEASE.jar 396KB spring-orm-3.2.4.RELEASE.jar 378KB ibatis-sqlmap-2.3.4.726.jar 375KB jcaptcha-1.0.jar 352KB spring-aop-3.2.4.RELEASE.jar 328KB dom4j-1.6.1.jar 307KB logback-core-0.9.27.jar 302KB httpclient-4.0.3.jar 286KB htmlparser-1.6.jar 281KB commons-lang-2.4.jar 256KB共 249 条
- 1
- 2
- 3
资源评论
云渊阁2018-04-28项目源码 可参考学习
莫然
- 粉丝: 415
- 资源: 8
最新资源
- 两相步进电机FOC矢量控制Simulink仿真模型 1.采用针对两相步进电机的SVPWM控制算法，实现FOC矢量控制，DQ轴解耦控制～ 2.转速电流双闭环控制，电流环采用PI控制，转速环分别采用PI和
- VMware虚拟机USB驱动
- Halcon手眼标定简介(1)
- (175128050)c&c++课程设计-图书管理系统
- 视频美学多任务学习中PyTorch的多回归实现-含代码及解释
- 基于ssh员工管理系统
- 5G SRM815模组原理框图.jpg
- T型3电平逆变器，lcl滤波器滤波器参数计算，半导体损耗计算，逆变电感参数设计损耗计算 mathcad格式输出，方便修改 同时支持plecs损耗仿真，基于plecs的闭环仿真，电压外环，电流内环
- 毒舌（解锁版）.apk
- 显示HEX、S19、Bin、VBF等其他汽车制造商特定的文件格式
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
