CollSdfs.java
3.04 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
package com.sitech.ismp.coll.centercoll;
import com.sitech.ismp.coll.basic.TblATO_KPIDETAIL;
import com.sitech.util.DES3;
import java.util.HashMap;
import java.util.Scanner;
import java.util.Vector;
/**
* Created by mooker on 15/6/23.
*/
public class CollSdfs implements CollSdfsMBean{
public Vector collHtable(HashMap params) {
CollSdfsWithCMD cmd = new CollSdfsWithCMD();
return cmd.collHtable(params);
}
public static void main(String[] args) {
System.out.println("***************SDFS Collect Test Begin*********************");
String ipAddr = "172.21.2.74";
String username = "ocsapp";
String password = "ocsapp";
String protocal = "ssh";
String protocalPort = "22";
String sdfsName = "ocsapp5";
String sdfsHome = "/ocsapp/work/wangmina/SDFS/";
// String methodStr = read("METHOD(0:getAll, 1:getConfig\n");
String methodStr = "1";
System.out.println("IP_ADDR=" + ipAddr + ", USERNAME=" + username
+ ", PASSWORD=" + password + ", PROTOTAL=" + protocal
+ ", SDFSNAME=" + sdfsName + ", METHOD=" + methodStr);
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("PROTOCOL_PORT", protocalPort);
params.put("SDFSNAME", sdfsName);
params.put("SDFSHOME", sdfsHome);
int method = Integer.parseInt(methodStr);
Vector<TblATO_KPIDETAIL> result = new Vector<TblATO_KPIDETAIL>();
CollSdfs collector = new CollSdfs();
switch (method) {
case 0:
result.addAll(collector.collHtable(params));
break;
case 1:
result.addAll(collector.collHtable(params));
break;
default:
break;
}
System.out.println("***************SDFS Collect Test End*********************");
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-32-17:ocsapp5', #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();
}
}