| Code with Finding: |
class SocialNetworkDatabasePosts {
public static Boolean isFFAPostCreator(Connection conn, String username, int post) {
Boolean isCreator = null;
String query = "SELECT postedby FROM freeforall.posts " +
"WHERE pid = ?";
PreparedStatement pstmt = null;
ResultSet result = null;
try {
pstmt = conn.prepareStatement(query);
pstmt.setInt(1, post);
result = pstmt.executeQuery();
if (result.next()) {
isCreator = new Boolean(username.equals(result.getString("postedby")));
}
} catch (SQLException e) {
isCreator = null;
} finally {
DBManager.closeResultSet(result);
DBManager.closePreparedStatement(pstmt);
}
return isCreator;
}
}
class SocialNetworkDatabasePosts {
public static int addFFAParticipipant(Connection conn, int post, String username, String priv) {
int status = 0;
String query = "INSERT INTO freeforall.postprivileges (pid, username, privilege) " +
"VALUES (?, ?, ?)";
PreparedStatement pstmt = null;
try {
pstmt = conn.prepareStatement(query);
pstmt.setInt(1, post);
pstmt.setString(2, username);
pstmt.setString(3, priv);
status = pstmt.executeUpdate();
} catch (SQLException e) {
status = 0;
}
return status;
}
}
|
