一段典型的ibatis配置模版，ibatis配置模版,<select id=＂

一段典型的ibatis配置模版，ibatis配置模版,<select id="StatEnterpriseStateGroupByEquipmentType" parameterClass="healthStatQueryBean" resultMap="equipTypeHealthStatResultMap"> SELECT T.EQUIPMENT_TYPE_CODE, Y.NAME, VOLTAGE_RANK, unknown, normal, notice, exception, serious FROM (SELECT EQUIPMENT_TYPE_CODE, VOLTAGE_RANK || 'kV' VOLTAGE_RANK, SUM(DECODE(HGRADE_TYPE_CODE, 0, 1, 0)) unknown, SUM(DECODE(HGRADE_TYPE_CODE, 1, 1, 0)) normal, SUM(DECODE(HGRADE_TYPE_CODE, 2, 1, 0)) notice, SUM(DECODE(HGRADE_TYPE_CODE, 3, 1, 0)) exception, SUM(DECODE(HGRADE_TYPE_CODE, 4, 1, 0)) serious FROM (SELECT A.SUBSTATION_ID, A.EQUIPMENT_ID, A.EQUIPMENT_TYPE_CODE, A.VOLTAGE_RANK, NVL(EH.HGRADE_TYPE_CODE, 0) HGRADE_TYPE_CODE FROM (SELECT EH1.SUBSTATION_ID, EH1.EQUIPMENT_ID, EH1.HGRADE_TYPE_CODE FROM EQUIPMENT_HEALTH EH1 WHERE EH1.GMT_EVENT =(SELECT MAX(EH2.GMT_EVENT) FROM EQUIPMENT_HEALTH EH2 WHERE EH2.SUBSTATION_ID = EH1.SUBSTATION_ID AND EH2.EQUIPMENT_ID = EH1.EQUIPMENT_ID)) EH, EQUIPMENT A, <dynamic> <isNotEmpty property="bayId"> EQUIPMENT_ON_BAY C, </isNotEmpty> </dynamic> SUBSTATION S, ENTERPRISE E WHERE A.SUBSTATION_ID = EH.SUBSTATION_ID AND A.EQUIPMENT_ID = EH.EQUIPMENT_ID <dynamic> <isNotEmpty prepend="AND" property="enterpriseId"> E.ENTERPRISE_ID = #enterpriseId# </isNotEmpty> </dynamic> <dynamic> <isNotEmpty prepend="AND" property="bayId"> A.SUBSTATION_ID = C.SUBSTATION_ID AND A.EQUIPMENT_ID = C.EQUIPMENT_ID AND C.BAY_ID = #bayId# </isNotEmpty> </dynamic> AND A.SUBSTATION_ID = S.SUBSTATION_ID <dynamic> <isNotEmpty prepend="AND" property="substationId"> A.SUBSTATION_ID = #substationId# </isNotEmpty> </dynamic> AND E.ENTERPRISE_ID = S.ENTERPRISE_ID AND A.RSTAT_TYPE_CODE = 1 <dynamic> <isNotEmpty property="equipmentTypeCodes"> <iterate property="equipmentTypeCodes" open="AND A.EQUIPMENT_TYPE_CODE in(" close=")" conjunction=","> #equipmentTypeCodes[]# </iterate> </isNotEmpty> </dynamic> ) GROUP BY EQUIPMENT_TYPE_CODE, VOLTAGE_RANK) T, EQUIPMENT_TYPE Y WHERE T.EQUIPMENT_TYPE_CODE = Y.EQUIPMENT_TYPE_CODE ORDER BY T.EQUIPMENT_TYPE_CODE </select>//该片段来自于http://byrx.net

相关文章

• 转义oracle数据库的通配查询符，转义oracle数据库,/** * De
• 屏幕右下角弹出气泡窗口，屏幕气泡窗口,public class
• 使用Java不借助框架直接抽取rtf文本，java框架抽取rtf,如下代码是
• 使用Java基于数据流直接抽取ppt文本，java数据流抽取ppt,如下代码
• 添加窗口尺寸调整图标，窗口尺寸图标,void paintIc

相关文章

• 转义oracle数据库的通配查询符，转义oracle数据库,/** * De
• 屏幕右下角弹出气泡窗口，屏幕气泡窗口,public class
• 使用Java不借助框架直接抽取rtf文本，java框架抽取rtf,如下代码是
• 使用Java基于数据流直接抽取ppt文本，java数据流抽取ppt,如下代码
• 添加窗口尺寸调整图标，窗口尺寸图标,void paintIc

用户点评