othersetdaoimpl.java

论坛软件系统亦称电子公告板(BBS)系统

			}
			ts.commit();
			return true;
		} catch (HibernateException e) {
			if(ts!=null){
				ts.rollback();
			}
			e.printStackTrace();
		}
		return false;
	}
	
	
	public boolean updateAnnouncement(List<Announcements> annBeanList) {
		Session session = HibernateUtil.getSessionFactory().getCurrentSession();
		Transaction ts = null;
		try {
			ts = session.beginTransaction();
			Iterator<Announcements> annIt = annBeanList.iterator();
			Announcements annBean = null;
			while(annIt.hasNext()){
				annBean = annIt.next();
				session.update(annBean);
				session.flush();
				session.evict(annBean);
			}
			ts.commit();
			return true;
		} catch (HibernateException e) {
			if(ts!=null){
				ts.rollback();
			}
			e.printStackTrace();
		}
		return false;
	}
	
	public boolean addAnnouncement(Announcements annBean) {
		Session session = HibernateUtil.getSessionFactory().getCurrentSession();
		Transaction ts = null;
		try {
			ts = session.beginTransaction();
			session.save(annBean);
			ts.commit();
			return true;
		} catch (HibernateException e) {
			if(ts!=null){
				ts.rollback();
			}
			e.printStackTrace();
		}
		return false;
	}
	public boolean addMedal(Medals medalBean) {
		Session session = HibernateUtil.getSessionFactory().getCurrentSession();
		Transaction ts = null;
		try {
			ts = session.beginTransaction();
			session.save(medalBean);
			ts.commit();
			return true;
		} catch (HibernateException e) {
			if(ts!=null){
				ts.rollback();
			}
			e.printStackTrace();
		}
		return false;
	}
	public boolean delAnyMedals(String[] deletes) {
		Session session = HibernateUtil.getSessionFactory().getCurrentSession();
		Transaction ts = null;
		try {
			ts = session.beginTransaction();
			int len = deletes.length;
			Medals mBean = null;
			for(int i=0;i<len;i++){
				mBean = (Medals)session.get(Medals.class, Short.valueOf(deletes[i]));
				session.delete(mBean);
			}
			ts.commit();
			return true;
		} catch (HibernateException e) {
			if(ts!=null){
				ts.rollback();
			}
			e.printStackTrace();
		}
		return false;
	}
	@SuppressWarnings("unchecked")
	public List<Medals> queryAllMedals() {
		Session session = HibernateUtil.getSessionFactory().getCurrentSession();
		Transaction ts = null;
		try {
			ts = session.beginTransaction();
			List<Medals> medalBeanList = session.createQuery("from Medals").list();
			ts.commit();
			return medalBeanList;
		} catch (HibernateException e) {
			if(ts!=null){
				ts.rollback();
			}
			e.printStackTrace();
		}
		return null;
	}

	public Medals queryMedalById(short id) {
		Session session = HibernateUtil.getSessionFactory().getCurrentSession();
		Transaction ts = null;
		try {
			ts = session.beginTransaction();
			Medals mBean = (Medals)session.get(Medals.class, id);
			ts.commit();
			return mBean;
		} catch (HibernateException e) {
			if(ts!=null){
				ts.rollback();
			}
			e.printStackTrace();
		}
		return null;
	}

	public boolean updateMedals(List<Medals> medalBeanList) {
		Session session = HibernateUtil.getSessionFactory().getCurrentSession();
		Transaction ts = null;
		try {
			ts = session.beginTransaction();
			Iterator<Medals> mIt = medalBeanList.iterator();
			Medals mBean = null;
			while(mIt.hasNext()){
				mBean = mIt.next();
				session.update(mBean);
				session.flush();
				session.evict(mBean);
			}
			ts.commit();
			return true;
		} catch (HibernateException e) {
			if(ts!=null){
				ts.rollback();
			}
			e.printStackTrace();
		}
		return false;
	}
	public boolean addForumLink(Forumlinks fBean) {
		Session session = HibernateUtil.getSessionFactory().getCurrentSession();
		Transaction ts = null;
		try {
			ts = session.beginTransaction();
			session.save(fBean);
			ts.commit();
			return true;
		} catch (HibernateException e) {
			if(ts!=null){
				ts.rollback();
			}
			e.printStackTrace();
		}
		return false;
	}

	public boolean delAnyForumLinks(String[] deletes) {
		Session session = HibernateUtil.getSessionFactory().getCurrentSession();
		Transaction ts = null;
		try {
			ts = session.beginTransaction();
			int len = deletes.length;
			Forumlinks fBean = null;
			for(int i=0;i<len;i++){
				fBean = (Forumlinks)session.get(Forumlinks.class, Short.valueOf(deletes[i]));
				session.delete(fBean);
			}
			ts.commit();
			return true;
		} catch (HibernateException e) {
			if(ts!=null){
				ts.rollback();
			}
			e.printStackTrace();
		}
		return false;
	}
	@SuppressWarnings("unchecked")
	public List<Forumlinks> queryAllForumLink() {
		Session session = HibernateUtil.getSessionFactory().getCurrentSession();
		Transaction ts = null;
		try {
			ts = session.beginTransaction();
			List<Forumlinks> flList = session.createQuery("from Forumlinks order by displayorder asc,id desc").list();
			ts.commit();
			return flList;
		} catch (HibernateException e) {
			if(ts!=null){
				ts.rollback();
			}
			e.printStackTrace();
		}
		return null;
	}

	public Forumlinks queryForumLinkById(short id) {
		Session session = HibernateUtil.getSessionFactory().getCurrentSession();
		Transaction ts = null;
		try {
			ts = session.beginTransaction();
			Forumlinks fBean = (Forumlinks)session.get(Forumlinks.class, id);
			ts.commit();
			return fBean;
		} catch (HibernateException e) {
			if(ts!=null){
				ts.rollback();
			}
			e.printStackTrace();
		}
		return null;
	}
	public boolean updateForumLinks(List<Forumlinks> flList) {
		Session session = HibernateUtil.getSessionFactory().getCurrentSession();
		Transaction ts = null;
		try {
			ts = session.beginTransaction();
			Iterator<Forumlinks> flIt = flList.iterator();
			Forumlinks fBean = null;
			while(flIt.hasNext()){
				fBean = flIt.next();
				session.saveOrUpdate(fBean);
				session.flush();
				session.evict(fBean);
			}
			ts.commit();
			return true;
		} catch (HibernateException e) {
			if(ts!=null){
				ts.rollback();
			}
			e.printStackTrace();
		}
		return false;
	}
	public boolean delAnyFaqs(List<Faqs> faqsListDelete) {
		Session session = HibernateUtil.getSessionFactory().getCurrentSession();
		Transaction ts = null;
		try {
			ts = session.beginTransaction();
			int len = faqsListDelete.size();
			for(int i=0;i<len;i++){
				session.delete(faqsListDelete.get(i));
			}
			ts.commit();
			return true;
		} catch (HibernateException e) {
			if(ts!=null){
				ts.rollback();
			}
			e.printStackTrace();
			return false;
		}
	}

	@SuppressWarnings("unchecked")
	public List<Faqs> queryAllFaq() {
		Session session = HibernateUtil.getSessionFactory().getCurrentSession();
		Transaction ts = null;
		try {
			ts = session.beginTransaction();
			List faqList = session.createQuery("from Faqs order by displayorder").list();
			ts.commit();
			return faqList;
		} catch (HibernateException e) {
			if(ts!=null){
				ts.rollback();
			}
			e.printStackTrace();
			return null;
		}
	}
	public Faqs queryFaqById(Short id) {
		Session session = HibernateUtil.getSessionFactory().getCurrentSession();
		Transaction ts = null;
		try {
			ts = session.beginTransaction();
			Faqs fBean = (Faqs)session.get(Faqs.class, id);
			ts.commit();
			return fBean;
		} catch (HibernateException e) {
			if(ts!=null){
				ts.rollback();
			}
			e.printStackTrace();
		}
		return null;
	}
	public boolean updateFaq(Faqs fBean) {
		Session session = HibernateUtil.getSessionFactory().getCurrentSession();
		Transaction ts = null;
		try{
			ts = session.beginTransaction();
			session.update(fBean);
			ts.commit();
			return true;
		}catch (HibernateException e) {
			if(ts!=null){
				ts.rollback();
			}
			e.printStackTrace();
		}
		return false;
	}

	public boolean updateFaqs(List<Faqs> faqList) {
		Session session = HibernateUtil.getSessionFactory().getCurrentSession();
		Transaction ts = null;
		try {
			ts = session.beginTransaction();
			Iterator<Faqs> fIt = faqList.iterator();
			Faqs fBean = null;
			while(fIt.hasNext()){
				fBean = fIt.next();
				session.saveOrUpdate(fBean);
				session.flush();
				session.evict(fBean);
			}
			ts.commit();
			return true;
		} catch (HibernateException e) {
			if(ts!=null){
				ts.rollback();
			}
			e.printStackTrace();
			return false;
		}
	}
	public boolean addFaqs(Faqs faqs){
		if(faqs==null){
			return true;
		}
		Session session = HibernateUtil.getSessionFactory().getCurrentSession();
		Transaction ts = null;
		try {
			ts = session.beginTransaction();
			session.save(faqs);
			ts.commit();
			return true;
		} catch (HibernateException e) {
			if(ts!=null){
				ts.rollback();
			}
			e.printStackTrace();
			return false;
		}
	}
	public List<Faqs> getRootFaqs() {
		Session session = HibernateUtil.getSessionFactory().getCurrentSession();
		List<Faqs> list = null;
		Transaction ts = null;
		try {
			ts = session.beginTransaction();
			String hql = "from Faqs where fpid=0";
			list = session.createQuery(hql).list();
			ts.commit();
		} catch (HibernateException e) {
			if(ts!=null){
				ts.rollback();
			}
			e.printStackTrace();
		}
		return list;
	}
}