TbAtoDynamicThresholdDao.java
2.75 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
package com.sitech.database.dao;
import com.sitech.ismp.messageObject.TbAtoDynamicThreshold;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.regex.Matcher;
import java.util.regex.Pattern;
/**
* Created with IntelliJ IDEA.
* User: dongyj
* Date: 16-11-1
* Time: 上午10:12
* To change this template use File | Settings | File Templates.
*/
public class TbAtoDynamicThresholdDao extends BaseDao {
@SuppressWarnings("unchecked")
public List<TbAtoDynamicThreshold> queryDynamicCfgByKpiId(TbAtoDynamicThreshold tbAtoDynamicThreshold) {
try {
Map map = new HashMap();
map.put("UNIT_ID",tbAtoDynamicThreshold.getUNIT_ID().trim());
map.put("EXT_UNIT_ID",getExtUnitId(tbAtoDynamicThreshold.getUNIT_ID().trim()));
map.put("KPI_ID",tbAtoDynamicThreshold.getKPI_ID().trim());
map.put("CLL_TIME",tbAtoDynamicThreshold.getSTART_TIME());
map.put("DB_TIME",tbAtoDynamicThreshold.getEND_TIME());
return sqlmapClient.queryForList("queryDynamicCfgByKpiId", map);
} catch (Exception e) {
error.error("Exception while queryEventCfgByKpiId("+tbAtoDynamicThreshold+")", e);
return null;
}
}
/**
* 新增动态阀值数据
* @param tbAtoDynamicThreshold
*/
public void insertTbAtoDynamicThreshold(TbAtoDynamicThreshold tbAtoDynamicThreshold) {
try {
sqlmapClient.insert("insertTbAtoDynamicThreshold", tbAtoDynamicThreshold);
} catch (Exception e) {
error.error("Exception while insertTbAtoDynamicThreshold.", e);
}
}
/**
* 删除表中所有动态阀值配置
* @return
*/
public int deleteTbAtoDynamicThresholdAll() {
try {
return sqlmapClient.delete("deleteTbAtoDynamicThresholdAll", null);
} catch (Exception e) {
error.error("Exception while deleteTbAtoDynamicThresholdAll.", e);
return -1;
}
}
/**
* 根据guid[]删除动态阀值配置
* @param id
* @return
*/
public int deleteTbAtoDynamicThreshold(String[] id) {
HashMap<String, String[]> params = new HashMap<String, String[]>();
params.put("ID", id);
try {
return sqlmapClient.delete("deleteTbAtoDynamicThreshold", params);
} catch (Exception e) {
error.error("Exception while deleteTbAtoDynamicThreshold.", e);
return -1;
}
}
public static String getExtUnitId(String unitId) {
Matcher platform = Pattern.compile("^(10\\-\\d+\\-\\d++).*:([^\\-]+).*$").matcher(unitId);
if (platform.find()) {
return platform.group(1) + ":" + platform.group(2);
}
return "";
}
}