Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dao/hibernate/QaContentDAO.java =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dao/hibernate/QaContentDAO.java,v diff -u -r1.17 -r1.17.2.1 --- lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dao/hibernate/QaContentDAO.java 27 Oct 2008 00:48:05 -0000 1.17 +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dao/hibernate/QaContentDAO.java 19 Feb 2009 00:57:01 -0000 1.17.2.1 @@ -39,8 +39,8 @@ /** * @author Ozgur Demirtas * - * TODO To change the template for this generated type comment go to Window - Preferences - Java - Code Style - Code - * Templates + * TODO To change the template for this generated type comment go to Window - + * Preferences - Java - Code Style - Code Templates */ public class QaContentDAO extends HibernateDaoSupport implements IQaContentDAO { Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dao/hibernate/QaQueContentDAO.java =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dao/hibernate/Attic/QaQueContentDAO.java,v diff -u -r1.20 -r1.20.4.1 --- lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dao/hibernate/QaQueContentDAO.java 20 Sep 2006 15:15:44 -0000 1.20 +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dao/hibernate/QaQueContentDAO.java 19 Feb 2009 00:57:00 -0000 1.20.4.1 @@ -34,150 +34,119 @@ import org.springframework.orm.hibernate3.HibernateTemplate; import org.springframework.orm.hibernate3.support.HibernateDaoSupport; - - - /** * @author Ozgur Demirtas - * - * TODO To change the template for this generated type comment go to - * Window - Preferences - Java - Code Style - Code Templates + * + * TODO To change the template for this generated type comment go to Window - + * Preferences - Java - Code Style - Code Templates */ public class QaQueContentDAO extends HibernateDaoSupport implements IQaQueContentDAO { - static Logger logger = Logger.getLogger(QaQueContentDAO.class.getName()); - private static final String LOAD_QUESTION_CONTENT_BY_CONTENT_ID = "from qaQueContent in class QaQueContent where qaQueContent.qaContentId=:qaContentId"; - private static final String GET_QUESTION_IDS_FOR_CONTENT = "select qaQueContent.qaQueContentId from QaQueContent qaQueContent where qaQueContent.qaContentId = :qa"; - private static final String LOAD_QUESTION_CONTENT_BY_QUESTION_TEXT = "from qaQueContent in class QaQueContent where qaQueContent.question=:question and qaQueContent.qaContentId=:qaContentId"; - private static final String LOAD_QUESTION_CONTENT_BY_DISPLAY_ORDER = "from qaQueContent in class QaQueContent where qaQueContent.displayOrder=:displayOrder and qaQueContent.qaContentId=:qaContentId"; - private static final String SORT_QUESTION_CONTENT_BY_DISPLAY_ORDER = "from qaQueContent in class QaQueContent where qaQueContent.qaContentId=:qaContentId order by qaQueContent.displayOrder"; - - public QaQueContent getToolDefaultQuestionContent(final long qaContentId) - { + static Logger logger = Logger.getLogger(QaQueContentDAO.class.getName()); + private static final String LOAD_QUESTION_CONTENT_BY_CONTENT_ID = "from qaQueContent in class QaQueContent where qaQueContent.qaContentId=:qaContentId"; + private static final String GET_QUESTION_IDS_FOR_CONTENT = "select qaQueContent.qaQueContentId from QaQueContent qaQueContent where qaQueContent.qaContentId = :qa"; + private static final String LOAD_QUESTION_CONTENT_BY_QUESTION_TEXT = "from qaQueContent in class QaQueContent where qaQueContent.question=:question and qaQueContent.qaContentId=:qaContentId"; + private static final String LOAD_QUESTION_CONTENT_BY_DISPLAY_ORDER = "from qaQueContent in class QaQueContent where qaQueContent.displayOrder=:displayOrder and qaQueContent.qaContentId=:qaContentId"; + private static final String SORT_QUESTION_CONTENT_BY_DISPLAY_ORDER = "from qaQueContent in class QaQueContent where qaQueContent.qaContentId=:qaContentId order by qaQueContent.displayOrder"; - HibernateTemplate templ = this.getHibernateTemplate(); - List list = getSession().createQuery(LOAD_QUESTION_CONTENT_BY_CONTENT_ID) - .setLong("qaContentId", qaContentId) - .list(); + public QaQueContent getToolDefaultQuestionContent(final long qaContentId) { - if(list != null && list.size() > 0){ - QaQueContent qa = (QaQueContent) list.get(0); - return qa; - } - return null; - } - + HibernateTemplate templ = this.getHibernateTemplate(); + List list = getSession().createQuery(LOAD_QUESTION_CONTENT_BY_CONTENT_ID).setLong("qaContentId", qaContentId) + .list(); - public QaQueContent getQaQueById(long qaQueContentId) - { - String query = "from QaQueContent as qu where qu.qaQueContentId = ?"; - HibernateTemplate templ = this.getHibernateTemplate(); - List list = getSession().createQuery(query) - .setLong(0,qaQueContentId) - .list(); - - if(list != null && list.size() > 0){ - QaQueContent qa = (QaQueContent) list.get(0); - return qa; - } - return null; - } + if (list != null && list.size() > 0) { + QaQueContent qa = (QaQueContent) list.get(0); + return qa; + } + return null; + } - - public QaQueContent getQuestionContentByQuestionText(final String question, Long qaContentId) - { - HibernateTemplate templ = this.getHibernateTemplate(); + public QaQueContent getQaQueById(long qaQueContentId) { + String query = "from QaQueContent as qu where qu.qaQueContentId = ?"; + HibernateTemplate templ = this.getHibernateTemplate(); + List list = getSession().createQuery(query).setLong(0, qaQueContentId).list(); - List list = getSession().createQuery(LOAD_QUESTION_CONTENT_BY_QUESTION_TEXT) - .setString("question", question) - .setLong("qaContentId", qaContentId.longValue()) - .list(); - - if(list != null && list.size() > 0){ - QaQueContent qa = (QaQueContent) list.get(0); - return qa; - } - return null; - } + if (list != null && list.size() > 0) { + QaQueContent qa = (QaQueContent) list.get(0); + return qa; + } + return null; + } + public QaQueContent getQuestionContentByQuestionText(final String question, Long qaContentId) { + HibernateTemplate templ = this.getHibernateTemplate(); - public QaQueContent getQuestionContentByDisplayOrder(Long displayOrder, Long qaContentId) - { - HibernateTemplate templ = this.getHibernateTemplate(); + List list = getSession().createQuery(LOAD_QUESTION_CONTENT_BY_QUESTION_TEXT).setString("question", question) + .setLong("qaContentId", qaContentId.longValue()).list(); - List list = getSession().createQuery(LOAD_QUESTION_CONTENT_BY_DISPLAY_ORDER) - .setLong("displayOrder", displayOrder.longValue()) - .setLong("qaContentId", qaContentId.longValue()) - .list(); - - if(list != null && list.size() > 0){ - QaQueContent qa = (QaQueContent) list.get(0); - return qa; - } - return null; - } + if (list != null && list.size() > 0) { + QaQueContent qa = (QaQueContent) list.get(0); + return qa; + } + return null; + } - public List getAllQuestionEntriesSorted(final long qaContentId) - { - HibernateTemplate templ = this.getHibernateTemplate(); - List list = getSession().createQuery(SORT_QUESTION_CONTENT_BY_DISPLAY_ORDER) - .setLong("qaContentId", qaContentId) - .list(); + public QaQueContent getQuestionContentByDisplayOrder(Long displayOrder, Long qaContentId) { + HibernateTemplate templ = this.getHibernateTemplate(); - return list; - } + List list = getSession().createQuery(LOAD_QUESTION_CONTENT_BY_DISPLAY_ORDER).setLong("displayOrder", + displayOrder.longValue()).setLong("qaContentId", qaContentId.longValue()).list(); + if (list != null && list.size() > 0) { + QaQueContent qa = (QaQueContent) list.get(0); + return qa; + } + return null; + } - public List getQuestionIndsForContent(QaContent qa) - { - - List listDefaultQuestionIds=(getHibernateTemplate().findByNamedParam(GET_QUESTION_IDS_FOR_CONTENT, - "qa", - qa)); - - return listDefaultQuestionIds; - } - - public List getAllQuestionEntries(final long qaContentId) - { - HibernateTemplate templ = this.getHibernateTemplate(); - List list = getSession().createQuery(LOAD_QUESTION_CONTENT_BY_CONTENT_ID) - .setLong("qaContentId", qaContentId) - .list(); + public List getAllQuestionEntriesSorted(final long qaContentId) { + HibernateTemplate templ = this.getHibernateTemplate(); + List list = getSession().createQuery(SORT_QUESTION_CONTENT_BY_DISPLAY_ORDER) + .setLong("qaContentId", qaContentId).list(); - return list; - } - - - public void createQueContent(QaQueContent queContent) - { - this.getSession().setFlushMode(FlushMode.AUTO); - this.getHibernateTemplate().save(queContent); - } - - public void updateQaQueContent(QaQueContent qaQueContent) - { - this.getSession().setFlushMode(FlushMode.AUTO); - this.getHibernateTemplate().update(qaQueContent); - } + return list; + } - - public void removeQueContent(long qaQueContentId) - { - QaQueContent qaQueContent= (QaQueContent) this.getHibernateTemplate().load(QaQueContent.class, new Long(qaQueContentId)); - this.getSession().setFlushMode(FlushMode.AUTO); - this.getHibernateTemplate().delete(qaQueContent); - } - - - public void removeQaQueContent(QaQueContent qaQueContent) - { - this.getSession().setFlushMode(FlushMode.AUTO); - this.getHibernateTemplate().delete(qaQueContent); - } + public List getQuestionIndsForContent(QaContent qa) { - - public List getQaQueContentsByContentId(long qaContentId){ - return getHibernateTemplate().findByNamedParam(LOAD_QUESTION_CONTENT_BY_CONTENT_ID, "qaContentId", new Long(qaContentId)); - } -} \ No newline at end of file + List listDefaultQuestionIds = (getHibernateTemplate().findByNamedParam(GET_QUESTION_IDS_FOR_CONTENT, "qa", qa)); + + return listDefaultQuestionIds; + } + + public List getAllQuestionEntries(final long qaContentId) { + HibernateTemplate templ = this.getHibernateTemplate(); + List list = getSession().createQuery(LOAD_QUESTION_CONTENT_BY_CONTENT_ID).setLong("qaContentId", qaContentId) + .list(); + + return list; + } + + public void createQueContent(QaQueContent queContent) { + this.getSession().setFlushMode(FlushMode.AUTO); + this.getHibernateTemplate().save(queContent); + } + + public void updateQaQueContent(QaQueContent qaQueContent) { + this.getSession().setFlushMode(FlushMode.AUTO); + this.getHibernateTemplate().update(qaQueContent); + } + + public void removeQueContent(long qaQueContentId) { + QaQueContent qaQueContent = (QaQueContent) this.getHibernateTemplate().load(QaQueContent.class, + new Long(qaQueContentId)); + this.getSession().setFlushMode(FlushMode.AUTO); + this.getHibernateTemplate().delete(qaQueContent); + } + + public void removeQaQueContent(QaQueContent qaQueContent) { + this.getSession().setFlushMode(FlushMode.AUTO); + this.getHibernateTemplate().delete(qaQueContent); + } + + public List getQaQueContentsByContentId(long qaContentId) { + return getHibernateTemplate().findByNamedParam(LOAD_QUESTION_CONTENT_BY_CONTENT_ID, "qaContentId", + new Long(qaContentId)); + } +} \ No newline at end of file Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dao/hibernate/QaQueUsrDAO.java =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dao/hibernate/QaQueUsrDAO.java,v diff -u -r1.18 -r1.18.4.1 --- lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dao/hibernate/QaQueUsrDAO.java 20 Sep 2006 15:15:44 -0000 1.18 +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dao/hibernate/QaQueUsrDAO.java 19 Feb 2009 00:57:01 -0000 1.18.4.1 @@ -35,138 +35,106 @@ import org.springframework.orm.hibernate3.HibernateTemplate; import org.springframework.orm.hibernate3.support.HibernateDaoSupport; - - /** * @author Ozgur Demirtas - * - * TODO To change the template for this generated type comment go to - * Window - Preferences - Java - Code Style - Code Templates + * + * TODO To change the template for this generated type comment go to Window - + * Preferences - Java - Code Style - Code Templates */ public class QaQueUsrDAO extends HibernateDaoSupport implements IQaQueUsrDAO { - static Logger logger = Logger.getLogger(QaQueUsrDAO.class.getName()); - - private static final String COUNT_SESSION_USER = "select qaQueUsr.queUsrId from QaQueUsr qaQueUsr where qaQueUsr.qaSessionId= :qaSession"; - private static final String LOAD_USER_FOR_SESSION = "from qaQueUsr in class QaQueUsr where qaQueUsr.qaSessionId= :qaSessionId"; - - public QaQueUsr getQaUserByUID(Long uid) - { - return (QaQueUsr) this.getHibernateTemplate() - .get(QaQueUsr.class, uid); - } + static Logger logger = Logger.getLogger(QaQueUsrDAO.class.getName()); - - public int countSessionUser(QaSession qaSession) - { - return (getHibernateTemplate().findByNamedParam(COUNT_SESSION_USER, - "qaSession", - qaSession)).size(); - } - + private static final String COUNT_SESSION_USER = "select qaQueUsr.queUsrId from QaQueUsr qaQueUsr where qaQueUsr.qaSessionId= :qaSession"; + private static final String LOAD_USER_FOR_SESSION = "from qaQueUsr in class QaQueUsr where qaQueUsr.qaSessionId= :qaSessionId"; - public QaQueUsr getQaQueUsrById(long qaQueUsrId) - { - String query = "from QaQueUsr user where user.queUsrId=?"; - - HibernateTemplate templ = this.getHibernateTemplate(); - List list = getSession().createQuery(query) - .setLong(0,qaQueUsrId) - .list(); - - if(list != null && list.size() > 0){ - QaQueUsr qu = (QaQueUsr) list.get(0); - return qu; - } - return null; - } + public QaQueUsr getQaUserByUID(Long uid) { + return (QaQueUsr) this.getHibernateTemplate().get(QaQueUsr.class, uid); + } + public int countSessionUser(QaSession qaSession) { + return (getHibernateTemplate().findByNamedParam(COUNT_SESSION_USER, "qaSession", qaSession)).size(); + } - public QaQueUsr getQaUserBySession(final Long queUsrId, final Long qaSessionId) - { - - String strGetUser = "from qaQueUsr in class QaQueUsr where qaQueUsr.queUsrId=:queUsrId and qaQueUsr.qaSessionId=:qaSessionId"; - HibernateTemplate templ = this.getHibernateTemplate(); - List list = getSession().createQuery(strGetUser) - .setLong("queUsrId", queUsrId.longValue()) - .setLong("qaSessionId", qaSessionId.longValue()) - .list(); - - if(list != null && list.size() > 0){ - QaQueUsr usr = (QaQueUsr) list.get(0); - return usr; - } - return null; - } + public QaQueUsr getQaQueUsrById(long qaQueUsrId) { + String query = "from QaQueUsr user where user.queUsrId=?"; - - - - public List getUserBySessionOnly(final QaSession qaSession) - { - HibernateTemplate templ = this.getHibernateTemplate(); - List list = getSession().createQuery(LOAD_USER_FOR_SESSION) - .setLong("qaSessionId", qaSession.getUid().longValue()) - .list(); - return list; - } - - - public QaQueUsr loadQaQueUsrById(long qaQueUsrId) - { - return getQaQueUsrById(qaQueUsrId); - } + HibernateTemplate templ = this.getHibernateTemplate(); + List list = getSession().createQuery(query).setLong(0, qaQueUsrId).list(); - - public void createUsr(QaQueUsr usr) - { - this.getSession().setFlushMode(FlushMode.AUTO); - this.getHibernateTemplate().save(usr); - } - - public void updateUsr(QaQueUsr usr) - { - this.getSession().setFlushMode(FlushMode.AUTO); - this.getHibernateTemplate().update(usr); - } + if (list != null && list.size() > 0) { + QaQueUsr qu = (QaQueUsr) list.get(0); + return qu; + } + return null; + } - - public void deleteQaQueUsr(QaQueUsr qaQueUsr) - { - this.getSession().setFlushMode(FlushMode.AUTO); - this.getHibernateTemplate().delete(qaQueUsr); + public QaQueUsr getQaUserBySession(final Long queUsrId, final Long qaSessionId) { + + String strGetUser = "from qaQueUsr in class QaQueUsr where qaQueUsr.queUsrId=:queUsrId and qaQueUsr.qaSessionId=:qaSessionId"; + HibernateTemplate templ = this.getHibernateTemplate(); + List list = getSession().createQuery(strGetUser).setLong("queUsrId", queUsrId.longValue()).setLong( + "qaSessionId", qaSessionId.longValue()).list(); + + if (list != null && list.size() > 0) { + QaQueUsr usr = (QaQueUsr) list.get(0); + return usr; + } + return null; + } + + public List getUserBySessionOnly(final QaSession qaSession) { + HibernateTemplate templ = this.getHibernateTemplate(); + List list = getSession().createQuery(LOAD_USER_FOR_SESSION).setLong("qaSessionId", + qaSession.getUid().longValue()).list(); + return list; + } + + public QaQueUsr loadQaQueUsrById(long qaQueUsrId) { + return getQaQueUsrById(qaQueUsrId); + } + + public void createUsr(QaQueUsr usr) { + this.getSession().setFlushMode(FlushMode.AUTO); + this.getHibernateTemplate().save(usr); + } + + public void updateUsr(QaQueUsr usr) { + this.getSession().setFlushMode(FlushMode.AUTO); + this.getHibernateTemplate().update(usr); + } + + public void deleteQaQueUsr(QaQueUsr qaQueUsr) { + this.getSession().setFlushMode(FlushMode.AUTO); + this.getHibernateTemplate().delete(qaQueUsr); + } + + public int getTotalNumberOfUsers() { + String query = "from obj in class QaQueUsr"; + return this.getHibernateTemplate().find(query).size(); + } + + public int getTotalNumberOfUsers(QaContent qa) { + String strGetUser = "from qaQueUsr in class QaQueUsr"; + HibernateTemplate templ = this.getHibernateTemplate(); + List list = getSession().createQuery(strGetUser).list(); + logger.debug("strGetUser: " + strGetUser); + logger.debug("qa: " + qa); + logger.debug("list: " + list); + + int totalUserCount = 0; + if (list != null && list.size() > 0) { + QaQueUsr usr = (QaQueUsr) list.get(0); + logger.debug("usr: " + usr); + logger.debug("local usr content uid versus incoming content uid: " + + usr.getQaSession().getQaContent().getUid().intValue() + " versus " + qa.getUid().intValue()); + + if (usr.getQaSession().getQaContent().getUid().intValue() == qa.getUid().intValue()) { + ++totalUserCount; } - - public int getTotalNumberOfUsers() { - String query="from obj in class QaQueUsr"; - return this.getHibernateTemplate().find(query).size(); - } - - - public int getTotalNumberOfUsers(QaContent qa) - { - String strGetUser = "from qaQueUsr in class QaQueUsr"; - HibernateTemplate templ = this.getHibernateTemplate(); - List list = getSession().createQuery(strGetUser) - .list(); - logger.debug("strGetUser: " + strGetUser); - logger.debug("qa: " + qa); - logger.debug("list: " + list); - - int totalUserCount=0; - if(list != null && list.size() > 0){ - QaQueUsr usr = (QaQueUsr) list.get(0); - logger.debug("usr: " + usr); - logger.debug("local usr content uid versus incoming content uid: " + - usr.getQaSession().getQaContent().getUid().intValue() + " versus " + qa.getUid().intValue()); - - if (usr.getQaSession().getQaContent().getUid().intValue() == qa.getUid().intValue()) - { - ++totalUserCount; - } - } - logger.debug("final totalUserCount: " + totalUserCount); - return totalUserCount; - } - -} \ No newline at end of file + } + logger.debug("final totalUserCount: " + totalUserCount); + return totalUserCount; + } + +} \ No newline at end of file Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dao/hibernate/QaSessionDAO.java =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dao/hibernate/QaSessionDAO.java,v diff -u -r1.16 -r1.16.4.1 --- lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dao/hibernate/QaSessionDAO.java 20 Sep 2006 15:15:44 -0000 1.16 +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dao/hibernate/QaSessionDAO.java 19 Feb 2009 00:57:01 -0000 1.16.4.1 @@ -33,169 +33,129 @@ import org.springframework.orm.hibernate3.HibernateTemplate; import org.springframework.orm.hibernate3.support.HibernateDaoSupport; - - /** * @author Ozgur Demirtas - * + * */ -public class QaSessionDAO extends HibernateDaoSupport implements - IQaSessionDAO -{ - private static final String COUNT_SESSION_INCOMPLITE = "select qaSession.session_status from QaSession qaSession where qaSession.session_status='INCOMPLETE' and qaSession.qaContentId = :qa"; - private static final String COUNT_SESSION_ACTIVITY = "select qaSession.session_status from QaSession qaSession where qaSession.qaContentId = :qa"; - private static final String GET_SESSION_IDS_FOR_CONTENT = "select qaSession.qaSessionId from QaSession qaSession where qaSession.qaContentId = :qa"; - private static final String COUNT_SESSION_COMPLETE = "from qaSession in class QaSession where qaSession.session_status='COMPLETE'"; - private static final String COUNT_SESSION_INCOMPLETE = "from qaSession in class QaSession where qaSession.session_status='INCOMPLETE'"; - private static final String GET_SESSIONS_FROM_CONTENT = "select qas.qaSessionId from QaSession qas where qas.qaContent=:qaContent order by qas.qaSessionId"; - private static final String GET_SESSIONNAMES_FROM_CONTENT = "select qas.session_name from QaSession qas where qas.qaContent=:qaContent order by qas.qaSessionId"; - - public int countSessionComplete() - { - HibernateTemplate templ = this.getHibernateTemplate(); - List list = getSession().createQuery(COUNT_SESSION_COMPLETE) - .list(); - - if(list != null && list.size() > 0){ - return list.size(); - } - else return 0; - } - - public int countSessionComplete(QaContent qa) - { - HibernateTemplate templ = this.getHibernateTemplate(); - List list = getSession().createQuery(COUNT_SESSION_COMPLETE) - .list(); +public class QaSessionDAO extends HibernateDaoSupport implements IQaSessionDAO { + private static final String COUNT_SESSION_INCOMPLITE = "select qaSession.session_status from QaSession qaSession where qaSession.session_status='INCOMPLETE' and qaSession.qaContentId = :qa"; + private static final String COUNT_SESSION_ACTIVITY = "select qaSession.session_status from QaSession qaSession where qaSession.qaContentId = :qa"; + private static final String GET_SESSION_IDS_FOR_CONTENT = "select qaSession.qaSessionId from QaSession qaSession where qaSession.qaContentId = :qa"; + private static final String COUNT_SESSION_COMPLETE = "from qaSession in class QaSession where qaSession.session_status='COMPLETE'"; + private static final String COUNT_SESSION_INCOMPLETE = "from qaSession in class QaSession where qaSession.session_status='INCOMPLETE'"; + private static final String GET_SESSIONS_FROM_CONTENT = "select qas.qaSessionId from QaSession qas where qas.qaContent=:qaContent order by qas.qaSessionId"; + private static final String GET_SESSIONNAMES_FROM_CONTENT = "select qas.session_name from QaSession qas where qas.qaContent=:qaContent order by qas.qaSessionId"; - int sessionCount=0; - if(list != null && list.size() > 0){ - QaSession qaSession = (QaSession) list.get(0); - logger.debug("qaSession: " + qaSession); - logger.debug("local session's content uid versus incoming content uid: " + - qaSession.getQaContent().getUid().intValue() + " versus " + qa.getUid().intValue()); - - if (qaSession.getQaContent().getUid().intValue() == qa.getUid().intValue()) - { - ++sessionCount; - } - } - logger.debug("sessionCount: " + sessionCount); - return sessionCount; - } + public int countSessionComplete() { + HibernateTemplate templ = this.getHibernateTemplate(); + List list = getSession().createQuery(COUNT_SESSION_COMPLETE).list(); - - public int countSessionIncomplete() - { - HibernateTemplate templ = this.getHibernateTemplate(); - List list = getSession().createQuery(COUNT_SESSION_INCOMPLETE) - .list(); - - if(list != null && list.size() > 0){ - return list.size(); - } - else return 0; + if (list != null && list.size() > 0) { + return list.size(); + } else + return 0; + } + + public int countSessionComplete(QaContent qa) { + HibernateTemplate templ = this.getHibernateTemplate(); + List list = getSession().createQuery(COUNT_SESSION_COMPLETE).list(); + + int sessionCount = 0; + if (list != null && list.size() > 0) { + QaSession qaSession = (QaSession) list.get(0); + logger.debug("qaSession: " + qaSession); + logger.debug("local session's content uid versus incoming content uid: " + + qaSession.getQaContent().getUid().intValue() + " versus " + qa.getUid().intValue()); + + if (qaSession.getQaContent().getUid().intValue() == qa.getUid().intValue()) { + ++sessionCount; + } } + logger.debug("sessionCount: " + sessionCount); + return sessionCount; + } - - public int studentActivityOccurred(QaContent qa) - { - return (getHibernateTemplate().findByNamedParam(COUNT_SESSION_ACTIVITY, - "qa", - qa)).size(); + public int countSessionIncomplete() { + HibernateTemplate templ = this.getHibernateTemplate(); + List list = getSession().createQuery(COUNT_SESSION_INCOMPLETE).list(); + + if (list != null && list.size() > 0) { + return list.size(); + } else + return 0; } - - - public List getToolSessionsForContent(QaContent qa) - { - - List lisToolSessionIds=(getHibernateTemplate().findByNamedParam(GET_SESSION_IDS_FOR_CONTENT, - "qa", - qa)); - return lisToolSessionIds; + + public int studentActivityOccurred(QaContent qa) { + return (getHibernateTemplate().findByNamedParam(COUNT_SESSION_ACTIVITY, "qa", qa)).size(); } - + + public List getToolSessionsForContent(QaContent qa) { + + List lisToolSessionIds = (getHibernateTemplate().findByNamedParam(GET_SESSION_IDS_FOR_CONTENT, "qa", qa)); + return lisToolSessionIds; + } + /** * @see org.lamsfoundation.lams.tool.survey.dao.interfaces.ISurveySessionDAO#getSurveySessionById(long) */ - public QaSession getQaSessionById(long qaSessionId) - { - String query = "from QaSession as qus where qus.qaSessionId = ?"; - HibernateTemplate templ = this.getHibernateTemplate(); - List list = getSession().createQuery(query) - .setLong(0,qaSessionId) - .list(); - - if(list != null && list.size() > 0){ - QaSession qus = (QaSession) list.get(0); - return qus; - } - return null; + public QaSession getQaSessionById(long qaSessionId) { + String query = "from QaSession as qus where qus.qaSessionId = ?"; + HibernateTemplate templ = this.getHibernateTemplate(); + List list = getSession().createQuery(query).setLong(0, qaSessionId).list(); + + if (list != null && list.size() > 0) { + QaSession qus = (QaSession) list.get(0); + return qus; + } + return null; } - - - public String getSessionNameById(long qaSessionId) - { - String query = "from QaSession as qus where qus.qaSessionId = ?"; - HibernateTemplate templ = this.getHibernateTemplate(); - List list = getSession().createQuery(query) - .setLong(0,qaSessionId) - .list(); - - if(list != null && list.size() > 0){ - QaSession qus = (QaSession) list.get(0); - return qus.getSession_name() ; - } - return null; + + public String getSessionNameById(long qaSessionId) { + String query = "from QaSession as qus where qus.qaSessionId = ?"; + HibernateTemplate templ = this.getHibernateTemplate(); + List list = getSession().createQuery(query).setLong(0, qaSessionId).list(); + + if (list != null && list.size() > 0) { + QaSession qus = (QaSession) list.get(0); + return qus.getSession_name(); + } + return null; } - - - public QaSession getQaSessionOrNullById(long qaSessionId) - { - return getQaSessionById(qaSessionId); + + public QaSession getQaSessionOrNullById(long qaSessionId) { + return getQaSessionById(qaSessionId); } /** * @see org.lamsfoundation.lams.tool.survey.dao.interfaces.ISurveySessionDAO#CreateSurveySession(com.lamsinternational.tool.survey.domain.SurveySession) */ - public void CreateQaSession(QaSession session) - { - this.getSession().setFlushMode(FlushMode.AUTO); - this.getHibernateTemplate().save(session); + public void CreateQaSession(QaSession session) { + this.getSession().setFlushMode(FlushMode.AUTO); + this.getHibernateTemplate().save(session); } /** * @see org.lamsfoundation.lams.tool.survey.dao.interfaces.ISurveySessionDAO#UpdateSurveySession(com.lamsinternational.tool.survey.domain.SurveySession) */ - public void UpdateQaSession(QaSession session) - { - this.getSession().setFlushMode(FlushMode.AUTO); - this.getHibernateTemplate().update(session); + public void UpdateQaSession(QaSession session) { + this.getSession().setFlushMode(FlushMode.AUTO); + this.getHibernateTemplate().update(session); } /** * @see org.lamsfoundation.lams.tool.survey.dao.interfaces.ISurveySessionDAO#deleteSurveySession(com.lamsinternational.tool.survey.domain.SurveySession) */ - public void deleteQaSession(QaSession qaSession) - { - this.getSession().setFlushMode(FlushMode.AUTO); - this.getHibernateTemplate().delete(qaSession); + public void deleteQaSession(QaSession qaSession) { + this.getSession().setFlushMode(FlushMode.AUTO); + this.getHibernateTemplate().delete(qaSession); } - - public List getSessionsFromContent(QaContent qaContent) - { - return (getHibernateTemplate().findByNamedParam(GET_SESSIONS_FROM_CONTENT, - "qaContent", - qaContent)); - } - - public List getSessionNamesFromContent(QaContent qaContent) - { - return (getHibernateTemplate().findByNamedParam(GET_SESSIONNAMES_FROM_CONTENT, - "qaContent", - qaContent)); - } - - - + + public List getSessionsFromContent(QaContent qaContent) { + return (getHibernateTemplate().findByNamedParam(GET_SESSIONS_FROM_CONTENT, "qaContent", qaContent)); + } + + public List getSessionNamesFromContent(QaContent qaContent) { + return (getHibernateTemplate().findByNamedParam(GET_SESSIONNAMES_FROM_CONTENT, "qaContent", qaContent)); + } + } Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dao/hibernate/QaUploadedFileDAO.java =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dao/hibernate/Attic/QaUploadedFileDAO.java,v diff -u -r1.12 -r1.12.4.1 --- lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dao/hibernate/QaUploadedFileDAO.java 20 Sep 2006 15:15:44 -0000 1.12 +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dao/hibernate/QaUploadedFileDAO.java 19 Feb 2009 00:57:01 -0000 1.12.4.1 @@ -34,119 +34,98 @@ import org.springframework.orm.hibernate3.HibernateTemplate; import org.springframework.orm.hibernate3.support.HibernateDaoSupport; - /** * @author Ozgur Demirtas - * - * TODO To change the template for this generated type comment go to - * Window - Preferences - Java - Code Style - Code Templates + * + * TODO To change the template for this generated type comment go to Window - + * Preferences - Java - Code Style - Code Templates */ public class QaUploadedFileDAO extends HibernateDaoSupport implements IQaUploadedFileDAO { - static Logger logger = Logger.getLogger(QaUploadedFileDAO.class.getName()); - - private static final String GET_UPLOADED_FILES = "from QaUploadedFile qaUploadedFile where qaUploadedFile.qaContent.qaContentId = :contentId"; - - private static final String DELETE_FILES_META_DATA = "from qaUploadedFile in class QaUploadedFile"; - - public QaUploadedFile getUploadedFileById(long submissionId) - { - return (QaUploadedFile) this.getHibernateTemplate() - .load(QaUploadedFile.class, new Long(submissionId)); - } - - /** - * - * return null if not found - */ - public QaUploadedFile loadUploadedFileById(long submissionId) - { - return (QaUploadedFile) this.getHibernateTemplate().get(QaUploadedFile.class, new Long(submissionId)); - } + static Logger logger = Logger.getLogger(QaUploadedFileDAO.class.getName()); - - - public void updateUploadFile(QaUploadedFile qaUploadedFile) - { - this.getSession().setFlushMode(FlushMode.AUTO); - this.getHibernateTemplate().update(qaUploadedFile); + private static final String GET_UPLOADED_FILES = "from QaUploadedFile qaUploadedFile where qaUploadedFile.qaContent.qaContentId = :contentId"; + + private static final String DELETE_FILES_META_DATA = "from qaUploadedFile in class QaUploadedFile"; + + public QaUploadedFile getUploadedFileById(long submissionId) { + return (QaUploadedFile) this.getHibernateTemplate().load(QaUploadedFile.class, new Long(submissionId)); + } + + /** + * + * return null if not found + */ + public QaUploadedFile loadUploadedFileById(long submissionId) { + return (QaUploadedFile) this.getHibernateTemplate().get(QaUploadedFile.class, new Long(submissionId)); + } + + public void updateUploadFile(QaUploadedFile qaUploadedFile) { + this.getSession().setFlushMode(FlushMode.AUTO); + this.getHibernateTemplate().update(qaUploadedFile); + } + + public void saveUploadFile(QaUploadedFile qaUploadedFile) { + this.getSession().setFlushMode(FlushMode.AUTO); + this.getHibernateTemplate().save(qaUploadedFile); + } + + public void createUploadFile(QaUploadedFile qaUploadedFile) { + this.getSession().setFlushMode(FlushMode.AUTO); + this.getHibernateTemplate().save(qaUploadedFile); + } + + public void UpdateUploadFile(QaUploadedFile qaUploadedFile) { + this.getSession().setFlushMode(FlushMode.AUTO); + this.getHibernateTemplate().update(qaUploadedFile); + } + + public void cleanUploadedFilesMetaData() { + /* + String query = "from uploadedFile in class org.lamsfoundation.lams.tool.qa.QaUploadedFile"; + this.getSession().setFlushMode(FlushMode.AUTO); + this.getHibernateTemplate().delete(query); + */ + HibernateTemplate templ = this.getHibernateTemplate(); + List list = getSession().createQuery(DELETE_FILES_META_DATA).list(); + + if (list != null && list.size() > 0) { + Iterator listIterator = list.iterator(); + while (listIterator.hasNext()) { + QaUploadedFile mcFile = (QaUploadedFile) listIterator.next(); + this.getSession().setFlushMode(FlushMode.AUTO); + templ.delete(mcFile); + templ.flush(); } - - - public void saveUploadFile(QaUploadedFile qaUploadedFile) - { - this.getSession().setFlushMode(FlushMode.AUTO); - this.getHibernateTemplate().save(qaUploadedFile); - } - - public void createUploadFile(QaUploadedFile qaUploadedFile) - { - this.getSession().setFlushMode(FlushMode.AUTO); - this.getHibernateTemplate().save(qaUploadedFile); - } - - public void UpdateUploadFile(QaUploadedFile qaUploadedFile) - { - this.getSession().setFlushMode(FlushMode.AUTO); - this.getHibernateTemplate().update(qaUploadedFile); - } + } + } - - public void cleanUploadedFilesMetaData() - { - /* - String query = "from uploadedFile in class org.lamsfoundation.lams.tool.qa.QaUploadedFile"; - this.getSession().setFlushMode(FlushMode.AUTO); - this.getHibernateTemplate().delete(query); - */ - HibernateTemplate templ = this.getHibernateTemplate(); - List list = getSession().createQuery(DELETE_FILES_META_DATA) - .list(); + public void removeUploadFile(Long submissionId) { + if (submissionId != null) { - if(list != null && list.size() > 0){ - Iterator listIterator=list.iterator(); - while (listIterator.hasNext()) - { - QaUploadedFile mcFile=(QaUploadedFile)listIterator.next(); - this.getSession().setFlushMode(FlushMode.AUTO); - templ.delete(mcFile); - templ.flush(); - } - } + String query = "from uploadedFile in class org.lamsfoundation.lams.tool.qa.QaUploadedFile" + + " where uploadedFile.submissionId = ?"; + Object obj = this.getSession().createQuery(query).setLong(0, submissionId.longValue()).uniqueResult(); + if (obj != null) { + this.getSession().setFlushMode(FlushMode.AUTO); + this.getHibernateTemplate().delete(obj); } - - public void removeUploadFile(Long submissionId) - { - if (submissionId != null ) { - - String query = "from uploadedFile in class org.lamsfoundation.lams.tool.qa.QaUploadedFile" - + " where uploadedFile.submissionId = ?"; - Object obj = this.getSession().createQuery(query) - .setLong(0,submissionId.longValue()) - .uniqueResult(); - if ( obj != null ) { - this.getSession().setFlushMode(FlushMode.AUTO); - this.getHibernateTemplate().delete(obj); - } - } - } - - public List retrieveQaUploadedFiles(QaContent qa) - { - List listFilenames=null; - listFilenames=(getHibernateTemplate().findByNamedParam(GET_UPLOADED_FILES, "contentId", qa.getQaContentId())); - return listFilenames; - } - - public void deleteUploadFile(QaUploadedFile qaUploadedFile) - { - this.getSession().setFlushMode(FlushMode.AUTO); - this.getHibernateTemplate().delete(qaUploadedFile); - } - - public void flush() - { - this.getHibernateTemplate().flush(); - } - -} \ No newline at end of file + } + } + + public List retrieveQaUploadedFiles(QaContent qa) { + List listFilenames = null; + listFilenames = (getHibernateTemplate().findByNamedParam(GET_UPLOADED_FILES, "contentId", qa.getQaContentId())); + return listFilenames; + } + + public void deleteUploadFile(QaUploadedFile qaUploadedFile) { + this.getSession().setFlushMode(FlushMode.AUTO); + this.getHibernateTemplate().delete(qaUploadedFile); + } + + public void flush() { + this.getHibernateTemplate().flush(); + } + +} \ No newline at end of file Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dao/hibernate/QaUsrRespDAO.java =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dao/hibernate/QaUsrRespDAO.java,v diff -u -r1.15 -r1.15.4.1 --- lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dao/hibernate/QaUsrRespDAO.java 11 Nov 2006 14:58:38 -0000 1.15 +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dao/hibernate/QaUsrRespDAO.java 19 Feb 2009 00:57:01 -0000 1.15.4.1 @@ -33,124 +33,96 @@ import org.springframework.orm.hibernate3.HibernateTemplate; import org.springframework.orm.hibernate3.support.HibernateDaoSupport; - /** * * @author Ozgur Demirtas * */ -public class QaUsrRespDAO extends HibernateDaoSupport implements IQaUsrRespDAO -{ - private static final String LOAD_ATTEMPT_FOR_USER_AND_QUESTION_CONTENT = "from qaUsrResp in class QaUsrResp where qaUsrResp.queUsrId=:queUsrId and qaUsrResp.qaQueContentId=:qaQueContentId"; +public class QaUsrRespDAO extends HibernateDaoSupport implements IQaUsrRespDAO { + private static final String LOAD_ATTEMPT_FOR_USER_AND_QUESTION_CONTENT = "from qaUsrResp in class QaUsrResp where qaUsrResp.queUsrId=:queUsrId and qaUsrResp.qaQueContentId=:qaQueContentId"; - public QaQueUsr getUserById(long userId) - { - return (QaQueUsr)this.getHibernateTemplate().load(QaQueUsr.class,new Long(userId)); - + public QaQueUsr getUserById(long userId) { + return (QaQueUsr) this.getHibernateTemplate().load(QaQueUsr.class, new Long(userId)); + } - public void createUserResponse(QaUsrResp qaUsrResp) - { - this.getSession().setFlushMode(FlushMode.AUTO); - this.getHibernateTemplate().save(qaUsrResp); + public void createUserResponse(QaUsrResp qaUsrResp) { + this.getSession().setFlushMode(FlushMode.AUTO); + this.getHibernateTemplate().save(qaUsrResp); } - public QaUsrResp retrieveQaUsrResp(long responseId) - { - return (QaUsrResp) this.getHibernateTemplate().get(QaUsrResp.class, new Long(responseId)); + public QaUsrResp retrieveQaUsrResp(long responseId) { + return (QaUsrResp) this.getHibernateTemplate().get(QaUsrResp.class, new Long(responseId)); } - public QaUsrResp getAttemptByUID(Long uid) - { - String query = "from QaUsrResp attempt where attempt.responseId=?"; - - HibernateTemplate templ = this.getHibernateTemplate(); - List list = getSession().createQuery(query) - .setLong(0,uid.longValue()) - .list(); - - if(list != null && list.size() > 0){ - QaUsrResp attempt = (QaUsrResp) list.get(0); - return attempt; - } - return null; + public QaUsrResp getAttemptByUID(Long uid) { + String query = "from QaUsrResp attempt where attempt.responseId=?"; + + HibernateTemplate templ = this.getHibernateTemplate(); + List list = getSession().createQuery(query).setLong(0, uid.longValue()).list(); + + if (list != null && list.size() > 0) { + QaUsrResp attempt = (QaUsrResp) list.get(0); + return attempt; } - - - - /** + return null; + } + + /** * @see org.lamsfoundation.lams.tool.qa.dao.interfaces.IQaUsrRespDAO#saveUserResponse(com.lamsinternational.tool.qa.domain.QaUsrResp) */ - public void saveUserResponse(QaUsrResp resp) - { - this.getSession().setFlushMode(FlushMode.AUTO); - this.getHibernateTemplate().save(resp); + public void saveUserResponse(QaUsrResp resp) { + this.getSession().setFlushMode(FlushMode.AUTO); + this.getHibernateTemplate().save(resp); } /** * @see org.lamsfoundation.lams.tool.qa.dao.IQaUsrRespDAO#updateUserResponse(org.lamsfoundation.lams.tool.qa.QaUsrResp) */ - public void updateUserResponse(QaUsrResp resp) - { - this.getSession().setFlushMode(FlushMode.AUTO); - this.getHibernateTemplate().update(resp); + public void updateUserResponse(QaUsrResp resp) { + this.getSession().setFlushMode(FlushMode.AUTO); + this.getHibernateTemplate().update(resp); } - - public void removeUserResponse(QaUsrResp resp) - { - this.getSession().setFlushMode(FlushMode.AUTO); - this.getHibernateTemplate().delete(resp); + + public void removeUserResponse(QaUsrResp resp) { + this.getSession().setFlushMode(FlushMode.AUTO); + this.getHibernateTemplate().delete(resp); } - public List getAttemptsForUserAndQuestionContent(final Long queUsrId, final Long qaQueContentId) - { - HibernateTemplate templ = this.getHibernateTemplate(); - List list = getSession().createQuery(LOAD_ATTEMPT_FOR_USER_AND_QUESTION_CONTENT) - .setLong("queUsrId", queUsrId.longValue()) - .setLong("qaQueContentId", qaQueContentId.longValue()) - .list(); - - return list; + public List getAttemptsForUserAndQuestionContent(final Long queUsrId, final Long qaQueContentId) { + HibernateTemplate templ = this.getHibernateTemplate(); + List list = getSession().createQuery(LOAD_ATTEMPT_FOR_USER_AND_QUESTION_CONTENT).setLong("queUsrId", + queUsrId.longValue()).setLong("qaQueContentId", qaQueContentId.longValue()).list(); + + return list; } - - - public void removeAttemptsForUserAndQuestionContent(final Long queUsrId, final Long qaQueContentId) - { - HibernateTemplate templ = this.getHibernateTemplate(); - List list = getSession().createQuery(LOAD_ATTEMPT_FOR_USER_AND_QUESTION_CONTENT) - .setLong("queUsrId", queUsrId.longValue()) - .setLong("qaQueContentId", qaQueContentId.longValue()) - .list(); - - - if(list != null && list.size() > 0){ - Iterator listIterator=list.iterator(); - while (listIterator.hasNext()) - { - QaUsrResp qaUsrResp=(QaUsrResp)listIterator.next(); - this.getSession().setFlushMode(FlushMode.AUTO); - templ.delete(qaUsrResp); - templ.flush(); - } - } + + public void removeAttemptsForUserAndQuestionContent(final Long queUsrId, final Long qaQueContentId) { + HibernateTemplate templ = this.getHibernateTemplate(); + List list = getSession().createQuery(LOAD_ATTEMPT_FOR_USER_AND_QUESTION_CONTENT).setLong("queUsrId", + queUsrId.longValue()).setLong("qaQueContentId", qaQueContentId.longValue()).list(); + + if (list != null && list.size() > 0) { + Iterator listIterator = list.iterator(); + while (listIterator.hasNext()) { + QaUsrResp qaUsrResp = (QaUsrResp) listIterator.next(); + this.getSession().setFlushMode(FlushMode.AUTO); + templ.delete(qaUsrResp); + templ.flush(); + } + } } - - - public void removeUserResponseByQaQueId(Long qaQueId) - { - if ( qaQueId != null ) { - String query = "from resp in class org.lamsfoundation.lams.tool.qa.QaUsrResp" - + " where resp.qaQueContentId = ?"; - Object obj = getSession().createQuery(query) - .setLong(0,qaQueId.longValue()) - .uniqueResult(); - if ( obj != null ) { - this.getSession().setFlushMode(FlushMode.AUTO); - getHibernateTemplate().delete(obj); - } - } + + public void removeUserResponseByQaQueId(Long qaQueId) { + if (qaQueId != null) { + String query = "from resp in class org.lamsfoundation.lams.tool.qa.QaUsrResp" + + " where resp.qaQueContentId = ?"; + Object obj = getSession().createQuery(query).setLong(0, qaQueId.longValue()).uniqueResult(); + if (obj != null) { + this.getSession().setFlushMode(FlushMode.AUTO); + getHibernateTemplate().delete(obj); + } } + } } - - Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dao/hibernate/QaWizardDAO.java =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dao/hibernate/QaWizardDAO.java,v diff -u -r1.2 -r1.2.2.1 --- lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dao/hibernate/QaWizardDAO.java 4 Nov 2008 05:10:34 -0000 1.2 +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dao/hibernate/QaWizardDAO.java 19 Feb 2009 00:57:01 -0000 1.2.2.1 @@ -41,11 +41,10 @@ public class QaWizardDAO extends BaseDAO implements IQaWizardDAO { private static final String QUERY_FIND_ALL_CATEGORIES = "from " + QaWizardCategory.class.getName(); - private static final String QUERY_DELETE_ALL_CATEGORIES = "from " + QaWizardCategory.class.getName(); private static final String QUERY_GET_CATEGORY = "from " + QaWizardCategory.class.getName() + " c where c.uid=?"; private static final String QUERY_GET_SKILL = "from " + QaWizardCognitiveSkill.class.getName() + " c where c.uid=?"; private static final String QUERY_GET_QUESTION = "from " + QaWizardQuestion.class.getName() + " q where q.uid=?"; - + public void saveOrUpdateCategories(SortedSet categories) { getHibernateTemplate().saveOrUpdateAll(categories); } @@ -62,70 +61,57 @@ public void deleteWizardCategoryByUID(Long uid) { QaWizardCategory cat = getWizardCategoryByUID(uid); - if (cat != null) - { + if (cat != null) { getHibernateTemplate().delete(cat); } } - public void deleteWizardSkillByUID(Long uid){ + public void deleteWizardSkillByUID(Long uid) { QaWizardCognitiveSkill skill = getWizardSkillByUID(uid); - if (skill != null) - { + if (skill != null) { getHibernateTemplate().delete(skill); } } - - public void deleteWizardQuestionByUID(Long uid){ + + public void deleteWizardQuestionByUID(Long uid) { QaWizardQuestion question = getWizardQuestionByUID(uid); - if (question != null) - { + if (question != null) { getHibernateTemplate().delete(question); } } @SuppressWarnings("unchecked") public QaWizardCategory getWizardCategoryByUID(Long uid) { List result = getHibernateTemplate().find(QUERY_GET_CATEGORY, uid); - if (result.size() > 0) - { - return (QaWizardCategory)result.get(0); - } - else - { + if (result.size() > 0) { + return (QaWizardCategory) result.get(0); + } else { return null; } } @SuppressWarnings("unchecked") - public QaWizardCognitiveSkill getWizardSkillByUID(Long uid){ + public QaWizardCognitiveSkill getWizardSkillByUID(Long uid) { List result = getHibernateTemplate().find(QUERY_GET_SKILL, uid); - if (result.size() > 0) - { - return (QaWizardCognitiveSkill)result.get(0); - } - else - { + if (result.size() > 0) { + return (QaWizardCognitiveSkill) result.get(0); + } else { return null; } } - + @SuppressWarnings("unchecked") - public QaWizardQuestion getWizardQuestionByUID(Long uid){ - + public QaWizardQuestion getWizardQuestionByUID(Long uid) { + List result = getHibernateTemplate().find(QUERY_GET_QUESTION, uid); - if (result.size() > 0) - { - return (QaWizardQuestion)result.get(0); - } - else - { + if (result.size() > 0) { + return (QaWizardQuestion) result.get(0); + } else { return null; } } - - public void deleteAllWizardCategories() - { + + public void deleteAllWizardCategories() { this.getHibernateTemplate().deleteAll(getWizardCategories()); }