01: package com.bostechcorp.cbesb.common.util.runtimedb;
02:
03: import java.util.List;
04:
05: import com.bostechcorp.cbesb.common.util.runtimedb.vo.EndpointStatVO;
06:
07: public class EndpointStatisticsDB extends AbstractRuntimeDB {
08:
09: public static List<EndpointStatVO> query() throws Exception {
10:
11: List list = sqlMap.queryForList("queryEndpointStat", null);
12: return list;
13: }
14:
15: public static List<EndpointStatVO> queryBySA(String saName)
16: throws Exception {
17: EndpointStatVO statVO = new EndpointStatVO();
18: statVO.setSaName(saName);
19: List list = sqlMap
20: .queryForList("queryEndpointStatBySA", statVO);
21: return list;
22: }
23:
24: public static void delete(String saName) throws Exception {
25: EndpointStatVO statVO = new EndpointStatVO();
26: statVO.setSaName(saName);
27: sqlMap.delete("deleteEndpointStat", statVO);
28: }
29:
30: public static void delete() throws Exception {
31: sqlMap.delete("deleteEndpointStat", null);
32: }
33:
34: public static void deleteEndpointStatistics(String saName)
35: throws Exception {
36: EndpointStatVO statVO = new EndpointStatVO();
37: statVO.setSaName(saName);
38:
39: sqlMap.delete("deleteEndpointStat", statVO);
40: }
41:
42: public static void deleteAllEndpointStatistics() throws Exception {
43:
44: sqlMap.delete("deleteAllEndpointStat", null);
45: }
46:
47: }
|