pstmt.setLong(1, room.getID()); pstmt.setString(2, affiliationJid); pstmt.setInt(3, newAffiliation.getValue()); pstmt.executeUpdate(); pstmt.setLong(1, room.getID()); pstmt.setString(2, affiliationJid); pstmt.setInt(3, newAffiliation.getValue()); pstmt.executeUpdate(); con = DbConnectionManager.getConnection(); pstmt = con.prepareStatement(UPDATE_AFFILIATION); pstmt.setInt(1, newAffiliation.getValue()); pstmt.setLong(2, room.getID()); pstmt.setString(3, affiliationJid);
pstmt.setLong(1, room.getID()); pstmt.setString(2, affiliationJid); pstmt.setInt(3, newAffiliation.getValue()); pstmt.executeUpdate(); pstmt.setLong(1, room.getID()); pstmt.setString(2, affiliationJid); pstmt.setInt(3, newAffiliation.getValue()); pstmt.executeUpdate(); con = DbConnectionManager.getConnection(); pstmt = con.prepareStatement(UPDATE_AFFILIATION); pstmt.setInt(1, newAffiliation.getValue()); pstmt.setLong(2, room.getID()); pstmt.setString(3, affiliationJid);