Index: lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dao/hibernate/NoticeboardUserDAO.java =================================================================== diff -u -rd3052fb70e4f634f28056bea13f91d9b8fd41b4c -r7a3020549c35733eee27e1231408b085b2b301e7 --- lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dao/hibernate/NoticeboardUserDAO.java (.../NoticeboardUserDAO.java) (revision d3052fb70e4f634f28056bea13f91d9b8fd41b4c) +++ lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dao/hibernate/NoticeboardUserDAO.java (.../NoticeboardUserDAO.java) (revision 7a3020549c35733eee27e1231408b085b2b301e7) @@ -29,11 +29,16 @@ import org.lamsfoundation.lams.tool.noticeboard.dao.INoticeboardUserDAO; import org.lamsfoundation.lams.tool.noticeboard.NoticeboardUser; import org.springframework.orm.hibernate.support.HibernateDaoSupport; +import org.lamsfoundation.lams.tool.noticeboard.NoticeboardSession; + /** * @author mtruong */ public class NoticeboardUserDAO extends HibernateDaoSupport implements INoticeboardUserDAO { + private static final String COUNT_USERS_IN_SESSION = "select nu.userId from NoticeboardUser nu where nu.nbSession= :nbSession"; + + /** *

Return the persistent instance of a NoticeboardUser * with the given identifier uid, returns null if not found.

@@ -117,5 +122,19 @@ this.getHibernateTemplate().delete(nbUser); } + /** + * Returns the number of users that are in this particular + * session. + * + * @param nbSession + * @return the number of users that are in this session + */ + public int getNumberOfUsers(NoticeboardSession nbSession) + { + return (getHibernateTemplate().findByNamedParam(COUNT_USERS_IN_SESSION, + "nbSession", + nbSession)).size(); + } + }