RosterItem.SubType.getTypeFromInt(rs.getInt(3)), RosterItem.AskType.getTypeFromInt(rs.getInt(4)), RosterItem.RecvType.getTypeFromInt(rs.getInt(5)),
@Override public void updateItem(String username, RosterItem item) { Connection con = null; PreparedStatement pstmt = null; long rosterID = item.getID(); try { con = DbConnectionManager.getConnection(); // Update existing roster item pstmt = con.prepareStatement(UPDATE_ROSTER_ITEM); pstmt.setInt(1, item.getSubStatus().getValue()); pstmt.setInt(2, item.getAskStatus().getValue()); pstmt.setInt(3, item.getRecvStatus().getValue()); pstmt.setString(4, item.getNickname()); pstmt.setLong(5, rosterID); pstmt.executeUpdate(); // Close now the statement (do not wait to be GC'ed) DbConnectionManager.fastcloseStmt(pstmt); // Delete old group list pstmt = con.prepareStatement(DELETE_ROSTER_ITEM_GROUPS); pstmt.setLong(1, rosterID); pstmt.executeUpdate(); insertGroups(rosterID, item.getGroups().iterator(), con); } catch (SQLException e) { Log.error(LocaleUtils.getLocalizedString("admin.error"), e); } finally { DbConnectionManager.closeConnection(pstmt, con); } }
RosterItem.SubType.getTypeFromInt(rs.getInt(3)), RosterItem.AskType.getTypeFromInt(rs.getInt(4)), RosterItem.RecvType.getTypeFromInt(rs.getInt(5)),
roster.addItem(item.getJid(), item.getNickname(), getAskStatus(item.getAskStatus()), org.xmpp.packet.Roster.Subscription.valueOf(item.getSubStatus().getName()), groups); broadcast(roster);
@Override public void updateItem(String username, RosterItem item) throws UserNotFoundException { Connection con = null; PreparedStatement pstmt = null; long rosterID = item.getID(); try { con = DbConnectionManager.getConnection(); // Update existing roster item pstmt = con.prepareStatement(UPDATE_ROSTER_ITEM); pstmt.setInt(1, item.getSubStatus().getValue()); pstmt.setInt(2, item.getAskStatus().getValue()); pstmt.setInt(3, item.getRecvStatus().getValue()); pstmt.setString(4, item.getNickname()); pstmt.setLong(5, rosterID); pstmt.executeUpdate(); // Close now the statement (do not wait to be GC'ed) DbConnectionManager.fastcloseStmt(pstmt); // Delete old group list pstmt = con.prepareStatement(DELETE_ROSTER_ITEM_GROUPS); pstmt.setLong(1, rosterID); pstmt.executeUpdate(); insertGroups(rosterID, item.getGroups().iterator(), con); } catch (SQLException e) { Log.error(LocaleUtils.getLocalizedString("admin.error"), e); } finally { DbConnectionManager.closeConnection(pstmt, con); } }
@Override public RosterItem createItem(String username, RosterItem item) throws UserAlreadyExistsException { Connection con = null; PreparedStatement pstmt = null; try { long rosterID = SequenceManager.nextID(JiveConstants.ROSTER); con = DbConnectionManager.getConnection(); pstmt = con.prepareStatement(CREATE_ROSTER_ITEM); pstmt.setString(1, username); pstmt.setLong(2, rosterID); pstmt.setString(3, item.getJid().toBareJID()); pstmt.setInt(4, item.getSubStatus().getValue()); pstmt.setInt(5, item.getAskStatus().getValue()); pstmt.setInt(6, item.getRecvStatus().getValue()); pstmt.setString(7, item.getNickname()); pstmt.executeUpdate(); item.setID(rosterID); insertGroups(rosterID, item.getGroups().iterator(), con); } catch (SQLException e) { Log.warn("Error trying to insert a new row in ofRoster", e); throw new UserAlreadyExistsException(item.getJid().toBareJID()); } finally { DbConnectionManager.closeConnection(pstmt, con); } return item; }
@Override public void readExternal(ObjectInput in) throws IOException, ClassNotFoundException { jid = (JID) ExternalizableUtil.getInstance().readSerializable(in); if (ExternalizableUtil.getInstance().readBoolean(in)) { nickname = ExternalizableUtil.getInstance().readSafeUTF(in); } this.groups = new LinkedList<>(); ExternalizableUtil.getInstance().readStrings(in, groups); ExternalizableUtil.getInstance().readStrings(in, sharedGroups); ExternalizableUtil.getInstance().readStrings(in, invisibleSharedGroups); recvStatus = RecvType.getTypeFromInt(ExternalizableUtil.getInstance().readInt(in)); subStatus = SubType.getTypeFromInt(ExternalizableUtil.getInstance().readInt(in)); askStatus = AskType.getTypeFromInt(ExternalizableUtil.getInstance().readInt(in)); rosterID = ExternalizableUtil.getInstance().readLong(in); } }
@Override public void writeExternal(ObjectOutput out) throws IOException { ExternalizableUtil.getInstance().writeSerializable(out, jid); ExternalizableUtil.getInstance().writeBoolean(out, nickname != null); if (nickname != null) { ExternalizableUtil.getInstance().writeSafeUTF(out, nickname); } ExternalizableUtil.getInstance().writeStrings(out, groups); ExternalizableUtil.getInstance().writeStrings(out, sharedGroups); ExternalizableUtil.getInstance().writeStrings(out, invisibleSharedGroups); ExternalizableUtil.getInstance().writeInt(out, recvStatus.getValue()); ExternalizableUtil.getInstance().writeInt(out, subStatus.getValue()); ExternalizableUtil.getInstance().writeInt(out, askStatus.getValue()); ExternalizableUtil.getInstance().writeLong(out, rosterID); }
public String getName() { return name().toLowerCase(); }
public static SubType getTypeFromInt(int value) { for (SubType subType : values()) { if (subType.value == value) { return subType; } } return null; } }
roster.addItem(item.getJid(), item.getNickname(), getAskStatus(item.getAskStatus()), org.xmpp.packet.Roster.Subscription.valueOf(item.getSubStatus().getName()), groups); broadcast(roster);
@Override public RosterItem createItem(String username, RosterItem item) throws UserAlreadyExistsException { Connection con = null; PreparedStatement pstmt = null; try { long rosterID = SequenceManager.nextID(JiveConstants.ROSTER); con = DbConnectionManager.getConnection(); pstmt = con.prepareStatement(CREATE_ROSTER_ITEM); pstmt.setString(1, username); pstmt.setLong(2, rosterID); pstmt.setString(3, item.getJid().toBareJID()); pstmt.setInt(4, item.getSubStatus().getValue()); pstmt.setInt(5, item.getAskStatus().getValue()); pstmt.setInt(6, item.getRecvStatus().getValue()); pstmt.setString(7, item.getNickname()); pstmt.executeUpdate(); item.setID(rosterID); insertGroups(rosterID, item.getGroups().iterator(), con); } catch (SQLException e) { Log.warn("Error trying to insert a new row in ofRoster", e); throw new UserAlreadyExistsException(item.getJid().toBareJID()); } finally { DbConnectionManager.closeConnection(pstmt, con); } return item; }
@Override public void readExternal(ObjectInput in) throws IOException, ClassNotFoundException { jid = (JID) ExternalizableUtil.getInstance().readSerializable(in); if (ExternalizableUtil.getInstance().readBoolean(in)) { nickname = ExternalizableUtil.getInstance().readSafeUTF(in); } this.groups = new LinkedList<>(); ExternalizableUtil.getInstance().readStrings(in, groups); ExternalizableUtil.getInstance().readStrings(in, sharedGroups); ExternalizableUtil.getInstance().readStrings(in, invisibleSharedGroups); recvStatus = RecvType.getTypeFromInt(ExternalizableUtil.getInstance().readInt(in)); subStatus = SubType.getTypeFromInt(ExternalizableUtil.getInstance().readInt(in)); askStatus = AskType.getTypeFromInt(ExternalizableUtil.getInstance().readInt(in)); rosterID = ExternalizableUtil.getInstance().readLong(in); } }
@Override public void writeExternal(ObjectOutput out) throws IOException { ExternalizableUtil.getInstance().writeSerializable(out, jid); ExternalizableUtil.getInstance().writeBoolean(out, nickname != null); if (nickname != null) { ExternalizableUtil.getInstance().writeSafeUTF(out, nickname); } ExternalizableUtil.getInstance().writeStrings(out, groups); ExternalizableUtil.getInstance().writeStrings(out, sharedGroups); ExternalizableUtil.getInstance().writeStrings(out, invisibleSharedGroups); ExternalizableUtil.getInstance().writeInt(out, recvStatus.getValue()); ExternalizableUtil.getInstance().writeInt(out, subStatus.getValue()); ExternalizableUtil.getInstance().writeInt(out, askStatus.getValue()); ExternalizableUtil.getInstance().writeLong(out, rosterID); }
public String getName() { return name().toLowerCase(); }
public static SubType getTypeFromInt(int value) { for (SubType subType : values()) { if (subType.value == value) { return subType; } } return null; } }