////////////////////////////////////////////////////////////////////////
/// Insert to db an S-MPSM entry. If entry exists, updates frequency ///
@SuppressWarnings("resource")
public static void updateStatistics(StatisticsEntry entry, String uid) {
String nodeID = uid;
String interfaceName = entry.getInterfaceName();
String interfaceIP = entry.getInterfaceIp();
String maliciousPattern = entry.getMaliciousPattern();
int frequency = entry.getFrequency();
DBCreation sql = DBCreation.getInstance(); // new DBCreation();
Connection conn;
ResultSet res = null;
PreparedStatement st;
conn = sql.connect();
try {
// st = conn.prepareStatement("SELECT * FROM clients c, statistics s, maliciousPatterns m
// WHERE nodeID=? AND interfaceIP=? AND s.maliciousPatternID=m.patternID AND
// (m.maliciousStringPattern=? OR m.maliciousIP=?)");
st =
conn.prepareStatement(
"SELECT nodeID,interfaceName,interfaceIP,maliciousPatternID FROM statistics WHERE nodeID=? AND interfaceName=? AND interfaceIP=? AND maliciousPatternID=(select patternID from maliciousPatterns WHERE maliciousStringPattern=? OR maliciousIP=?)");
st.setString(1, nodeID);
st.setString(2, interfaceName);
st.setString(3, interfaceIP);
st.setString(4, maliciousPattern);
st.setString(5, maliciousPattern);
res = st.executeQuery();
///////////////////////////////////////////////////
/// If the trinity already exist in an entry ///
/// (nodeID - interfaceIP - maliciousPattern) ///
/// Then we just update the frequency ///
if (res.next()) {
st.clearParameters();
// freq = res.getInt("frequency");
// st = conn.prepareStatement("UPDATE statistics SET frequency=frequency+? WHERE
// nodeID=? AND interfaceIP=? AND maliciousPattern=?");
st =
conn.prepareStatement(
"UPDATE statistics SET frequency=frequency+? WHERE nodeID=? AND interfaceIP=? AND maliciousPatternID=(select patternID from maliciousPatterns WHERE maliciousStringPattern=? OR maliciousIP=?)");
st.setInt(1, frequency);
st.setString(2, nodeID);
st.setString(3, interfaceIP);
st.setString(4, maliciousPattern);
st.setString(5, maliciousPattern);
st.executeUpdate();
conn.close();
} else {
st.clearParameters();
st =
conn.prepareStatement(
"INSERT INTO statistics (nodeID, interfaceName, interfaceIP, maliciousPatternID, frequency) VALUES ( ?, ?, ?, (select patternID from maliciousPatterns where maliciousStringPattern=? OR maliciousIP=?), ?)");
// st = conn.prepareStatement("INSERT INTO statistics (nodeID, interfaceName,
// interfaceIP, maliciousPatternID, frequency) VALUES ( (select clientID from clients where
// clientID=?), ?, ?, ?, ?)");
st.setString(1, nodeID);
st.setString(2, interfaceName);
st.setString(3, interfaceIP);
st.setString(4, maliciousPattern);
st.setString(5, maliciousPattern);
st.setInt(6, frequency);
st.executeUpdate();
st.clearParameters();
}
} catch (SQLException e) {
System.out.println("Can't insert into statistics table");
} finally {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
