CollRedis.java
2.84 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
package com.sitech.ismp.coll.centercoll;
import com.sitech.ismp.coll.basic.TblATO_KPIDETAIL;
import com.sitech.util.DES3;
import java.util.Date;
import java.util.HashMap;
import java.util.Scanner;
import java.util.Vector;
/**
* Created with IntelliJ IDEA.
* User: Owen
* Date: 15-5-11
* Time: 下午1:54
* To change this template use File | Settings | File Templates.
*/
public class CollRedis implements CollRedisMBean {
@Override
public Vector getCluster(HashMap params) {
CollRedisWithCMD cmd = new CollRedisWithCMD();
return cmd.getCluster(params);
}
public static void main(String[] args) {
System.out
.println("***************Linux Center Collect Test Begin*********************");
String ipAddr = "localhost";
String username = "iddbs";
String password = "iddbs";
String protocal = "ssh";
String hostName = "172_16_212_209";
String listeningPort = "60026";
String redisKey = "8001";
System.out.println("IP_ADDR=" + ipAddr + ", USERNAME=" + username
+ ", PASSWORD=" + password + ", PROTOTAL=" + protocal
+ ", HOST_NAME=" + hostName);
HashMap<String, String> params = new HashMap<String, String>();
params.put("IP_ADDR", ipAddr);
params.put("USERNAME", username);
params.put("PASSWORD", DES3.encrypt(password));
params.put("PROTOCOL", protocal);
params.put("DEVICEID", hostName);
params.put("PROTOCOL_PORT", listeningPort);
params.put("REDIS_KEY", redisKey);
Vector<TblATO_KPIDETAIL> result = new Vector<TblATO_KPIDETAIL>();
CollRedis collector = new CollRedis();
result.addAll(collector.getCluster(params));
System.out.println("***************Linux Center Collect Test End*********************" + new Date());
System.out.println();
for (int i = 0; i < result.size(); i++) {
TblATO_KPIDETAIL record = (TblATO_KPIDETAIL) result.get(i);
// System.out.println(record.UNIT_ID + "\t" + record.KPI_ID + "\t" + record.KPI_VALUE);
String insSql = "INSERT INTO TB_ATO_KPIDETAIL (KPI_ID, UNIT_ID, CLL_TIME, KPI_VALUE, EXT_INFO, DB_TIME, EXT_UNIT_ID, `INTERVAL`) " +
"VALUES ('#KPI_ID#', '#UNIT_ID#', now(), '#KPI_VALUE#', 'null', now(), '10-41-11:redis26_e3basestorage1', #INTERVAL#);";
insSql = insSql.replace("#KPI_ID#", record.KPI_ID);
insSql = insSql.replace("#UNIT_ID#", record.UNIT_ID);
insSql = insSql.replace("#KPI_VALUE#", record.KPI_VALUE);
insSql = insSql.replace("#INTERVAL#", record.INTERVAL);
System.out.println(insSql);
}
}
private static String read(String prompt) {
Scanner scanner = new Scanner(System.in);
System.out.print(prompt);
return scanner.nextLine();
}
}