/**
* The main program for the DictCachService class
*
* @param args The command line arguments
*/
public static void main(String[] args) {
HashMap h = DictCachService.getInstance().getDictSql("select * from tab");
HashMap h2 = DictCachService.getInstance().getDictSql("select * from tab");
HashMap hash = DictCachService.getInstance().getDictSql("select code ,name from t_kouan");
Iterator itor1 = hash.keySet().iterator();
while (itor1.hasNext()) {
String code = (String) itor1.next();
String text = (String) hash.get(code);
System.out.println(code + " " + text);
}
}
public String getTextOfDic(String strSql) {
String returnValue = "";
Debug.getAppErrLogger().debug("get select text's sql is:" + strSql);
if (strSql != null && !strSql.equals("")) {
HashMap hp = getDictSql(strSql);
Iterator it = hp.keySet().iterator();
String sText = "";
while (it.hasNext()) {
sText = (String) it.next() + ",";
}
if (sText.length() > 0 && sText.lastIndexOf(",") == (sText.length() - 1)) {
sText = sText.substring(0, sText.lastIndexOf(","));
}
returnValue = sText;
}
return returnValue;
}
private void loadNewDict(String sql) {
Debug.getAppErrLogger().debug("------------------------------------------------load:" + sql);
HashMap htemp = new HashMap();
Statement state = null;
ResultSet rs_dic = null;
try {
if (conn != null) {
conn.close();
conn = null;
}
getConnection();
state = conn.createStatement();
rs_dic = state.executeQuery(sql);
while (rs_dic.next()) {
String text = rs_dic.getString(1);
String value = rs_dic.getString(2);
if (null != text && value != null) {
htemp.put(text.trim(), value.trim());
}
}
hashCache.put(sql, htemp);
rs_dic.close();
state.close();
} catch (Exception e) {
e.printStackTrace();
Debug.getAppErrLogger().error(e);
} finally {
try {
if (rs_dic != null) {
rs_dic.close();
rs_dic = null;
}
if (state != null) {
state.close();
state = null;
}
} catch (Exception e) {
Debug.getAppErrLogger().error("Inside DictCachService::loadNewDict() - 关闭时出错!\n" + e);
}
close();
}
}