Index: lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dao/hibernate/McContentDAO.java =================================================================== RCS file: /usr/local/cvsroot/lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dao/hibernate/McContentDAO.java,v diff -u -r1.2 -r1.3 --- lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dao/hibernate/McContentDAO.java 3 Oct 2005 13:17:53 -0000 1.2 +++ lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dao/hibernate/McContentDAO.java 4 Oct 2005 08:35:58 -0000 1.3 @@ -24,6 +24,7 @@ import java.util.List; import java.lang.Long; +import net.sf.hibernate.Hibernate; import net.sf.hibernate.HibernateException; import net.sf.hibernate.Session; import org.lamsfoundation.lams.tool.mc.McContent; @@ -33,14 +34,14 @@ import org.springframework.orm.hibernate.support.HibernateDaoSupport; /** - * @author ozgur + * @author ozgurd *
Hibernate implementation for database access to Mc content for the mc tool.
*/ public class McContentDAO extends HibernateDaoSupport implements IMcContentDAO { - private static final String LOAD_NB_BY_SESSION = "select mc from McContent mc left join fetch " + private static final String LOAD_MC_BY_SESSION = "select mc from McContent mc left join fetch " + "mc.mcSessions session where session.mcSessionId=:sessionId"; @@ -77,7 +78,7 @@ public Object doInHibernate(Session session) throws HibernateException { - return session.createQuery(LOAD_NB_BY_SESSION) + return session.createQuery(LOAD_MC_BY_SESSION) .setLong("sessionId", mcSessionId.longValue()) .uniqueResult(); @@ -110,6 +111,15 @@ this.getHibernateTemplate().delete(queryString); } + + public void removeMcById(Long mcContentId) + { + String query = "from mc in class org.lamsfoundation.lams.tool.mc.McContent" + + " where qa.mcContentId = ?"; + this.getHibernateTemplate().delete(query,mcContentId,Hibernate.LONG); + } + + /** @see org.lamsfoundation.lams.tool.mc.dao.IMcContentDAO#removeMc(org.lamsfoundation.lams.tool.mc.McContent)*/ public void removeMc(McContent mcContent) @@ -133,5 +143,11 @@ this.getHibernateTemplate().saveOrUpdate(content); } + + public void flush() + { + this.getHibernateTemplate().flush(); + } + }