Index: lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dao/hibernate/NoticeboardUserDAO.java =================================================================== RCS file: /usr/local/cvsroot/lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dao/hibernate/NoticeboardUserDAO.java,v diff -u -r1.1 -r1.2 --- lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dao/hibernate/NoticeboardUserDAO.java 5 Jul 2005 06:38:59 -0000 1.1 +++ lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dao/hibernate/NoticeboardUserDAO.java 21 Jul 2005 04:35:43 -0000 1.2 @@ -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(); + } + }