Index: lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dao/IMcQueContentDAO.java =================================================================== diff -u --- lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dao/IMcQueContentDAO.java (revision 0) +++ lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dao/IMcQueContentDAO.java (revision 2a44c30b10969e02e8231862e47f54974ce3d056) @@ -0,0 +1,45 @@ +/* + *Copyright (C) 2005 LAMS Foundation (http://lamsfoundation.org) + * + *This program is free software; you can redistribute it and/or modify + *it under the terms of the GNU General Public License as published by + *the Free Software Foundation; either version 2 of the License, or + *(at your option) any later version. + * + *This program is distributed in the hope that it will be useful, + *but WITHOUT ANY WARRANTY; without even the implied warranty of + *MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + *GNU General Public License for more details. + * + *You should have received a copy of the GNU General Public License + *along with this program; if not, write to the Free Software + *Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 + *USA + * + *http://www.gnu.org/licenses/gpl.txt + */ +package org.lamsfoundation.lams.tool.mc.dao; + +import org.lamsfoundation.lams.tool.mc.McQueContent; + + +/** + * + * @author Ozgur Demirtas + * + */ +public interface IMcQueContentDAO +{ + public McQueContent getMcQueContentByUID(Long uid); + + public McQueContent findMcQueContentById(Long mcQueContentId); + + public McQueContent getMcQueById(long mcQueContentId); + + public McQueContent getToolDefaultQuestionContent(final long mcContentId); + + public void createQueContent(McQueContent queContent); + + public void removeQueContent(long mcQueContentId); + +} Index: lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dao/hibernate/McContentDAO.java =================================================================== diff -u -r264cde6ac5b1ea0fef9da98db3463333d11132f9 -r2a44c30b10969e02e8231862e47f54974ce3d056 --- lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dao/hibernate/McContentDAO.java (.../McContentDAO.java) (revision 264cde6ac5b1ea0fef9da98db3463333d11132f9) +++ lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dao/hibernate/McContentDAO.java (.../McContentDAO.java) (revision 2a44c30b10969e02e8231862e47f54974ce3d056) @@ -33,7 +33,7 @@ import org.springframework.orm.hibernate.support.HibernateDaoSupport; /** - * @author mtruong + * @author ozgur *

Hibernate implementation for database access to Mc content for the mc tool.

*/ Index: lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dao/hibernate/McQueContentDAO.java =================================================================== diff -u --- lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dao/hibernate/McQueContentDAO.java (revision 0) +++ lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dao/hibernate/McQueContentDAO.java (revision 2a44c30b10969e02e8231862e47f54974ce3d056) @@ -0,0 +1,88 @@ +/* + * Created on 15/03/2005 + * + * TODO To change the template for this generated file go to + * Window - Preferences - Java - Code Style - Code Templates + */ +package org.lamsfoundation.lams.tool.mc.dao.hibernate; + +import java.util.List; + +import net.sf.hibernate.HibernateException; +import net.sf.hibernate.Session; + +import org.apache.log4j.Logger; +import org.lamsfoundation.lams.tool.mc.McQueContent; +import org.lamsfoundation.lams.tool.mc.dao.IMcQueContentDAO; +import org.springframework.orm.hibernate.HibernateCallback; +import org.springframework.orm.hibernate.support.HibernateDaoSupport; + + + + +/** + * @author ozgurd + * + * TODO To change the template for this generated type comment go to + * Window - Preferences - Java - Code Style - Code Templates + */ + +public class McQueContentDAO extends HibernateDaoSupport implements IMcQueContentDAO { + static Logger logger = Logger.getLogger(McQueContentDAO.class.getName()); + private static final String LOAD_QUESTION_CONTENT_BY_CONTENT_ID = "from mcQueContent in class McQueContent where mcQueContent.mcContentId=:mcContentId"; + + + /** @see org.lamsfoundation.lams.tool.mc.dao.IMcContentDAO#getMcQueContentByUID(java.lang.Long) */ + public McQueContent getMcQueContentByUID(Long uid) + { + return (McQueContent) this.getHibernateTemplate() + .get(McQueContent.class, uid); + } + + /** @see org.lamsfoundation.lams.tool.mc.dao.IMcContentDAO#findMcQueContentById(java.lang.Long) */ + public McQueContent findMcQueContentById(Long mcQueContentId) + { + String query = "from McContent as mc where mc.mcContentId = ?"; + List content = getHibernateTemplate().find(query,mcQueContentId); + + if(content!=null && content.size() == 0) + { + return null; + } + else + { + return (McQueContent)content.get(0); + } + + } + + public McQueContent getToolDefaultQuestionContent(final long mcContentId) + { + return (McQueContent) getHibernateTemplate().execute(new HibernateCallback() + { + public Object doInHibernate(Session session) throws HibernateException + { + return session.createQuery(LOAD_QUESTION_CONTENT_BY_CONTENT_ID) + .setLong("mcContentId", mcContentId) + .uniqueResult(); + } + }); + } + + + public McQueContent getMcQueById(long mcQueContentId) + { + return (McQueContent) this.getHibernateTemplate().load(McQueContent.class, new Long(mcQueContentId)); + } + + public void createQueContent(McQueContent queContent) + { + this.getHibernateTemplate().save(queContent); + } + + public void removeQueContent(long mcQueContentId) + { + McQueContent mcQueContent= (McQueContent) this.getHibernateTemplate().load(McQueContent.class, new Long(mcQueContentId)); + this.getHibernateTemplate().delete(mcQueContent); + } +} \ No newline at end of file