// --------------------------------------------------
private HashMap<String, Integer> getMap(int leaveOutFileId, int Type) {
// ---------------------------------------------------
// nb this not include leave one out
String sql = "Select reviewType, featureId, value, count(*) count from ReviewFeatureAnalysis ";
if (leaveOutFileId != 0) sql = sql + " where fileId <> " + leaveOutFileId;
sql = sql + " group by reviewType, featureId, value";
// System.out.println("GetMap : Sql : " + sql);
String key = "";
Integer value;
HashMap<String, Integer> map = new HashMap<String, Integer>();
Connection conn = Database.getDBConnection();
java.sql.Statement st;
try {
st = conn.createStatement();
ResultSet rs = st.executeQuery(sql);
while (rs.next()) {
int type = rs.getInt("reviewType");
if (type == Type) {
key = rs.getString("featureId") + "_" + rs.getString("value");
value = rs.getInt("count");
// System.out.println("Key " + key + " value : " + value);
map.put(key, new Integer(value));
}
}
st.close();
return map;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return map;
}
}
