<?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="Calib0">
<insert id="calib0.insert" parameterClass="com.tpaic.ruleengine.domain.Calib0">
<![CDATA[
INSERT INTO T_CALIB1
( CREATED_BY,
CREATED_DATE,
CALIB_ID,
DEPARTMENT_CODE,
CHANNEL_SOURCE_CODE,
BUSINESS_TYPE,
APPLY_TYPE
)
VALUES
(#createdBy:VARCHAR#,
sysdate,
#calibId:VARCHAR#,
#departmentCode:VARCHAR#,
#channelSourceCode:VARCHAR#,
#businessType:VARCHAR#,
#applyType:VARCHAR#
)
]]>
</insert>
<select id="calib0.search" parameterClass="com.tpaic.ruleengine.domain.Calib0"
resultClass="com.tpaic.ruleengine.domain.Calib0">
select
c.CREATED_DATE createdDate,
c.CREATED_BY createdBy,
c.CALIB_ID calibId,
c.DEPARTMENT_CODE departmentCode,
(select t.department_chinese_name from t_department_define t where t.internal_department_code = c.department_code) departmentName,
c.CHANNEL_SOURCE_CODE channelSourceCode,
c.BUSINESS_TYPE businessType,
c.APPLY_TYPE applyType,
(select a1.rule_id from t_calib_rule a1 where a1.calib_id=c.calib_id and a1.business_type='R1') as forbiddenRuleId,
(select b1.rule_name from t_decision_rule b1 where b1.rule_id in (select a1.rule_id from t_calib_rule a1 where a1.calib_id=c.calib_id and a1.business_type='R1')) as forbiddenRuleName,
(select a1.rule_id from t_calib_rule a1 where a1.calib_id=c.calib_id and a1.business_type='R2') as mustRuleId,
(select b1.rule_name from t_decision_rule b1 where b1.rule_id in (select a1.rule_id from t_calib_rule a1 where a1.calib_id=c.calib_id and a1.business_type='R2')) as mustRuleName,
(select a1.rule_id from t_calib_rule a1 where a1.calib_id=c.calib_id and a1.business_type='R3') as limitRuleId,
(select b1.rule_name from t_decision_rule b1 where b1.rule_id in (select a1.rule_id from t_calib_rule a1 where a1.calib_id=c.calib_id and a1.business_type='R3')) as limitRuleName
from T_CALIB1 c
where 1 = 1
<isNotEmpty prepend="and" property="departmentCode">
<isNotEmpty prepend="" property="subOrganFlag">
c.DEPARTMENT_CODE in
(select tdd01.internal_department_code from t_department_define tdd01
connect by prior tdd01.internal_department_code = tdd01.upper_department_code
start with tdd01.internal_department_code=#departmentCode#)
</isNotEmpty>
<isEmpty prepend="" property="subOrganFlag">
c.DEPARTMENT_CODE = #departmentCode#
</isEmpty>
</isNotEmpty>
<isNotEmpty prepend="and" property="channelSourceCode">
c.CHANNEL_SOURCE_CODE = #channelSourceCode#
</isNotEmpty>
<isNotEmpty prepend="and" property="businessType">
c.BUSINESS_TYPE = #businessType#
</isNotEmpty>
<isNotEmpty prepend="and" property="applyType">
c.APPLY_TYPE = #applyType#
</isNotEmpty>
<isNotEmpty prepend="AND" property="userDept">
c.DEPARTMENT_CODE IN
(select tdd01.internal_department_code from t_department_define tdd01
connect by prior tdd01.internal_department_code = tdd01.upper_department_code
start with tdd01.internal_department_code=#userDept#)
</isNotEmpty>
</select>
<select id="calib0.searchById" parameterClass="java.lang.String"
resultClass="com.tpaic.ruleengine.domain.Calib0">
select
c.CALIB_ID calibId,
c.DEPARTMENT_CODE departmentCode,
(select t.department_chinese_name from t_department_define t where t.internal_department_code = c.department_code) departmentName,
c.CHANNEL_SOURCE_CODE channelSourceCode,
c.BUSINESS_TYPE businessType,
c.APPLY_TYPE applyType
from T_CALIB1 c where c.CALIB_ID = #calibId#
</select>
<delete id="calib0.delete" parameterClass="com.tpaic.ruleengine.domain.Calib0">
<![CDATA[
DELETE FROM T_CALIB1
WHERE CALIB_ID = #calibId#
]]>
</delete>
<update id="vehicleBlackList.delete" parameterClass="com.tpaic.ruleengine.domain.VehicleBlackList">
UPDATE T_VEHICLE_BLACK_LIST
SET DELETED_FLAG = '1',
DELETED_DATE = sysdate,
DELETED_BY =#deletedBy#
WHERE ID = #id#
</update>
<update id="vehicleBlackList.update" parameterClass="com.tpaic.ruleengine.domain.VehicleBlackList">
UPDATE T_VEHICLE_BLACK_LIST set
updated_date =sysdate,
updated_by =#updatedBy#,
ENGINE_NO =#engineNo#,
VEHICLE_FRAME_NO =#vehicleFrameNo#,
SORT_DISPLAY =#sortDisplay#,
CLAIM_TIMES =#claimTimes#,
CLAIM_RATIO =#claimRatio#,
REMARK =#remark#
WHERE ID = #id#
</update>
</sqlMap>
相关推荐
ibatis常用sql语句,简单易懂,方便查询,初学者宝典
在ibatis日志信息中打印SQL语句的方法(个人总结)
ibatis常用的sql语句,很全的一篇文档。。。
iBatis最全的动态SQL语句,你需要的都有,资源在于大家共享
WAS上log4j日志不能输出(ibatis)sql语句解决办法[借鉴].pdf
ibatis16个常用sql语句
ibatis sql 语句的编写 ,包括增删改查,很简单 很实用 ,对初学者是很好的选择
ibatis mybatis crud 完整代码
ibatis简单CRUD例子,供新手学习用。
ibatis实现CRUD操作,它比学好hibernate更简单
ibatis sql语句对条件中特殊字符% # 处理
iBATIS-SqlMaps-2-Tutorial_cniBATIS-SqlMaps-2-Tutorial_cn.pdf.pdfiBATIS-SqlMaps-2-Tutorial_cn.pdfiBATIS-SqlMaps-2-Tutorial_cn.pdf
通过java程序查看ibatis配置文件中的sql语句(注:无法查看变量值)
ibatis 开发指南 和 iBATIS-SqlMaps两本图书
用Ibatis时,配置sql语句时候 如果直接从sql里面把语句拷出来,玩玩格式不严谨,我写了这个工具来帮助我们格式化sql语句
[iBATIS]sql转换工具 简单哦~ 项目组自己写的哦~分享给大家了
iBATIS-SqlMaps2入门代码文档
根据MyBatis或iBatis的SQLMapper文件解析生成数据库表,通常是指通过解析MyBatis或iBatis的SQLMapper文件中的SQL语句,然后根据这些SQL语句来生成对应的数据库表结构。这样的需求可能源于需要将已有的SQLMapper文件...
sql语句中用问号代替参数
可以针对一个表中一个或几个字段进行更新等操作。Hibernate会更新所有的字段。 (3) ibatis可维护性高一点。 2.Ibatis需要的jar包 (1) ibatis-2.3.4.726.jar (3) 数据库的连接包 3.Ibatis的使用 (1) 建数据库表和...