diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmRecordsMapper.xml b/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmRecordsMapper.xml index 62fd6b5..b990166 100644 --- a/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmRecordsMapper.xml +++ b/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmRecordsMapper.xml @@ -58,10 +58,9 @@ TO_CHAR(${paramTime},'yyyy-mm-dd hh24:mi:ss') - SELECT - ar.ID as id, + ar.ID as "id", bwi.WELL_CODE as "wellCode", ar.ALARM_CONTENT as "alarmContentName", ar.DEVICE_ID as "deviceId", @@ -74,10 +73,10 @@ ar.ALARM_VALUE AS "alarmValue", ar.ALARM_LEVEL AS "alarmLevel", ar.ALARM_MSG AS "alarmMessage", - ar.DEVCODE as devcode, + ar.DEVCODE as "devcode", aj.JOB_STATUS as "jobStatus", ar.JOB_ID as "jobId", - bwi.DEPTID AS deptid + bwi.DEPTID AS "deptid" FROM alarm_records ar JOIN bus_device_well rdv ON ar.DEVICE_ID = rdv.DEVICE_ID JOIN alarm_job aj ON ar.JOB_ID = aj.ID diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/SysDictMapper.xml b/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/SysDictMapper.xml index 7515612..b53d701 100644 --- a/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/SysDictMapper.xml +++ b/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/SysDictMapper.xml @@ -99,8 +99,8 @@ diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmRecordsMapper.xml b/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmRecordsMapper.xml index 62fd6b5..b990166 100644 --- a/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmRecordsMapper.xml +++ b/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmRecordsMapper.xml @@ -58,10 +58,9 @@ TO_CHAR(${paramTime},'yyyy-mm-dd hh24:mi:ss') - diff --git a/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataAnalysisMapper.xml b/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataAnalysisMapper.xml index 7008ff9..c85cefc 100644 --- a/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataAnalysisMapper.xml +++ b/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataAnalysisMapper.xml @@ -1413,7 +1413,7 @@ OR dh2s.WELL_CODE LIKE) - ORDER BY logtime DESC + ORDER BY uptime DESC diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmRecordsMapper.xml b/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmRecordsMapper.xml index 62fd6b5..b990166 100644 --- a/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmRecordsMapper.xml +++ b/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmRecordsMapper.xml @@ -58,10 +58,9 @@ TO_CHAR(${paramTime},'yyyy-mm-dd hh24:mi:ss') - diff --git a/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataAnalysisMapper.xml b/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataAnalysisMapper.xml index 7008ff9..c85cefc 100644 --- a/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataAnalysisMapper.xml +++ b/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataAnalysisMapper.xml @@ -1413,7 +1413,7 @@ OR dh2s.WELL_CODE LIKE) - ORDER BY logtime DESC + ORDER BY uptime DESC diff --git a/casic-web/pom.xml b/casic-web/pom.xml index 8ef5725..b3cce52 100644 --- a/casic-web/pom.xml +++ b/casic-web/pom.xml @@ -161,6 +161,12 @@ postgresql + + com.dameng + DmJdbcDriver18 + 1.8 + + diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmRecordsMapper.xml b/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmRecordsMapper.xml index 62fd6b5..b990166 100644 --- a/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmRecordsMapper.xml +++ b/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/AlarmRecordsMapper.xml @@ -58,10 +58,9 @@ TO_CHAR(${paramTime},'yyyy-mm-dd hh24:mi:ss') - diff --git a/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataAnalysisMapper.xml b/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataAnalysisMapper.xml index 7008ff9..c85cefc 100644 --- a/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataAnalysisMapper.xml +++ b/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataAnalysisMapper.xml @@ -1413,7 +1413,7 @@ OR dh2s.WELL_CODE LIKE) - ORDER BY logtime DESC + ORDER BY uptime DESC diff --git a/casic-web/pom.xml b/casic-web/pom.xml index 8ef5725..b3cce52 100644 --- a/casic-web/pom.xml +++ b/casic-web/pom.xml @@ -161,6 +161,12 @@ postgresql + + com.dameng + DmJdbcDriver18 + 1.8 + + diff --git a/pom.xml b/pom.xml index 1591db7..040ce65 100644 --- a/pom.xml +++ b/pom.xml @@ -83,6 +83,8 @@ 2.4.5 + +