public static Map<String, String> getNameMap() {
Map<String, String> nameMap = new HashMap<String, String>();
try {
Object[] dbArgs = new Object[] {};
DBResultSet rs =
dbClient_config.execSQLQuery(
"select itemtype,itemtypeid,itemcredittext from shopitem where itemAmount=1", dbArgs);
while (rs.next()) {
String type = rs.getString("itemtype");
nameMap.put(type + rs.getInt("itemtypeid"), rs.getString("itemcredittext"));
// System.out.println(type+rs.getInt("itemtypeid")+":"+rs.getString("itemcredittext"));
}
} catch (Exception e) {
logger.error("getNameMap ", e);
}
return nameMap;
}
public static Map<String, String> getNameMapItemLog() {
Map<String, String> nameMap = new HashMap<String, String>();
try {
Object[] dbArgs = new Object[] {};
DBResultSet rs =
dbClient_config.execSQLQuery("select itemid,itemcredittext from shopitem", dbArgs);
while (rs.next()) {
nameMap.put("" + rs.getInt("itemid"), rs.getString("itemcredittext"));
}
} catch (Exception e) {
logger.error("getNameMap ", e);
}
return nameMap;
}