-
Notifications
You must be signed in to change notification settings - Fork 5
/
WordStandard.java
82 lines (76 loc) · 2.22 KB
/
WordStandard.java
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
/*
Ver Creation_Time Created_By Update_Time Updated_By Description
--- ------------- -------------- ----------- -------------- -------------------------------------
1.0 2019-08-26 xlzhu@ips.com for wordStandard
1.1 2019-08-29 xlzhu@ips.com redesign java class
*/
import java.util.ArrayList;
import java.util.List;
public class WordStandard extends DataSource{
private List<String[]> wordStandardLst;
private int dbTypeIdx;
public WordStandard(){
wordStandardLst=new ArrayList<String[]>();
for (String[] strArr : getDataList("",null)) {
wordStandardLst.add(strArr);
}
}
@Override
protected List<String[]> getDataList(String pDataStr,SqlLogging pLogger){
//Override&customize this function,maybe visit your data from database or other source
String conifgKeyWSdFilePath="FILE_WORDSTANDARD";
String pathFile=getPropValue(conifgKeyWSdFilePath);
return getCSVDataList(pathFile);
}
public List<String[]> getWordList(){
return wordStandardLst;
}
private int getDbTypeIdx(){
return dbTypeIdx;
}
private void setDbTypeIdx(String dbType){
for (int i=0;i<wordStandardLst.get(0).length;i++){
if (wordStandardLst.get(0)[i].toUpperCase().equals(dbType.toUpperCase())){
dbTypeIdx=i;
break;
}
}
}
private String purgeStr(String str){
String strtmp=str.replaceAll("'","");
strtmp=strtmp.replaceAll("`","");
return strtmp;
}
public String getSDWord(String Desc){
String rst="";
for (String[] strArr:wordStandardLst){
if (strArr[2].toUpperCase().equals(Desc.toUpperCase())){
rst= strArr[1];
break;
}
}
return rst;
}
public String getSDTypeLen(String dbType,String Desc){
String rst="";
setDbTypeIdx(dbType);
for (String[] strArr:wordStandardLst){
if (strArr[2].toUpperCase().equals(Desc.toUpperCase())){
rst= strArr[getDbTypeIdx()];
break;
}
}
return rst;
}
public String getSDTypeLenByCol(String dbType,String colName){
String rst="";
setDbTypeIdx(dbType);
for (String[] strArr:wordStandardLst){
if (strArr[1].toUpperCase().equals(purgeStr(colName).toUpperCase())){
rst= strArr[getDbTypeIdx()];
break;
}
}
return rst;
}
}