othersetdaoimpl.java

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

package cn.jsprun.dao.impl;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;

import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;


import cn.jsprun.dao.OtherSetDao;
import cn.jsprun.domain.Announcements;
import cn.jsprun.domain.Faqs;
import cn.jsprun.domain.Forumlinks;
import cn.jsprun.domain.Magicmarket;
import cn.jsprun.domain.Magics;
import cn.jsprun.domain.Medals;
import cn.jsprun.domain.Settings;
import cn.jsprun.utils.HibernateUtil;

public class OtherSetDaoImpl implements OtherSetDao {
	
	public boolean magicBasicSet(List<Settings> setBeanList) {
		Session session = HibernateUtil.getSessionFactory().getCurrentSession();
		Transaction ts = null;
		try {
			ts = session.beginTransaction();
			Iterator<Settings> setIt = setBeanList.iterator();
			Settings setBean = null;
			while(setIt.hasNext()){
				setBean = setIt.next();
				session.saveOrUpdate(setBean);
				session.flush();
				session.evict(setBean);
			}
			ts.commit();
			return true;
		} catch (HibernateException e) {
			if(ts!=null){
				ts.rollback();
			}
			e.printStackTrace();
		}	
		return false;
		
	}
	
	@SuppressWarnings("unchecked")
	public List<Magics> queryAllMagic() {
		Session session = HibernateUtil.getSessionFactory().getCurrentSession();
		Transaction ts = null;
		try {
			ts = session.beginTransaction();
			List magicList = session.createQuery("from Magics order by displayorder,name ").list();	
			ts.commit();
			return magicList;
		} catch (HibernateException e) {
			if(ts!=null){
				ts.rollback();
			}
			e.printStackTrace();
		}
		return null;
	}
	
	public List<Magics> queryAllMagic(Integer begin, Integer maxNum) {
		Transaction transaction = null;
		try{
			Session session = HibernateUtil.getSessionFactory().getCurrentSession();
			transaction = session.beginTransaction();
			String hql = "FROM Magics ORDER BY displayorder,name ";
			Query query = session.createQuery(hql);
			query.setFirstResult(begin);
			query.setMaxResults(maxNum);
			
			List<Magics> magicList = query.list();
			transaction.commit();
			return magicList;
		}catch(Exception exception){
			if(transaction!= null){
				transaction.rollback();
			}
		}
		return null;
	}
	@SuppressWarnings("unchecked")
	public List<Magics> queryAllMagicByType(Short typeNum) {
		Session session = HibernateUtil.getSessionFactory().getCurrentSession();
		Transaction ts = null;
		try {
			ts = session.beginTransaction();
			Query query = session.createQuery("from Magics m where m.type=:typeNum");
			query.setShort("typeNum", typeNum);
			List magicList = query.list();
			ts.commit();
			return magicList;			
		} catch (HibernateException e) {
			ts.rollback();
			e.printStackTrace();
		}
		return null;
	}
	public List<Magics> queryAllMagicByType(Short typeNum, Integer begin,
			Integer Max) {
		Session session = HibernateUtil.getSessionFactory().getCurrentSession();
		Transaction ts = null;
		try {
			ts = session.beginTransaction();
			Query query = session.createQuery("from Magics m where m.type=:typeNum");
			query.setShort("typeNum", typeNum);
			query.setFirstResult(begin);
			query.setMaxResults(Max);
			List magicList = query.list();
			ts.commit();
			return magicList;			
		} catch (HibernateException e) {
			ts.rollback();
			e.printStackTrace();
		}
		return null;
	}
	public Magics queryMagicById(short id) {
		Session session = HibernateUtil.getSessionFactory().getCurrentSession();
		Transaction ts = null;
		try{
			ts = session.beginTransaction();
			Magics magic = (Magics)session.get(Magics.class, id);
			return magic;
		}catch (HibernateException e) {
			if(ts!=null){
				ts.rollback();
			}
			e.printStackTrace();
		}
		return null;
	}
	

	public List<Magics> getMagicsListByMagicIdList(List<Short> magicIdList) {
		Session session = HibernateUtil.getSessionFactory().getCurrentSession();
		Transaction ts = null;
		List<Magics> magicsList = new ArrayList<Magics>();
		try{
			ts = session.beginTransaction();
			for(int i = 0;i<magicIdList.size();i++){
				Magics magic = (Magics)session.get(Magics.class, magicIdList.get(i));
				magicsList.add(magic);
			}
			return magicsList;
		}catch (HibernateException e) {
			if(ts!=null){
				ts.rollback();
			}
			e.printStackTrace();
		}
		return null;
	}
	public List<Magics> getAvailableMagics() {
		Transaction transaction = null;
		try{
			Session session = HibernateUtil.getSessionFactory().getCurrentSession();
			transaction = session.beginTransaction();
			String hql = "FROM Magics m WHERE m.available=1";
			Query query = session.createQuery(hql);
			List<Magics> list = query.list();
			transaction.commit();
			return list;
		}catch(Exception exception){
			exception.printStackTrace();
			if(transaction!=null){
				transaction.rollback();
			}
			return null;
		}
	}
	public boolean updateMagic(Magics magicBean){
		Session session = HibernateUtil.getSessionFactory().getCurrentSession();
		Transaction ts = null;
		try {
			ts = session.beginTransaction();
			session.update(magicBean);
			ts.commit();
			return true;
		} catch (HibernateException e) {
			if(ts!=null){
				ts.rollback();
			}
			e.printStackTrace();
		}
		return false;
	}
	
	public boolean updateMagics(List<Magics> magicBeanList) {
		Session session = HibernateUtil.getSessionFactory().getCurrentSession();
		Transaction ts = null;
		try {
			ts = session.beginTransaction();
			Iterator<Magics> magicIt = magicBeanList.iterator();
			Magics magic = null;
			while(magicIt.hasNext()){
				magic = magicIt.next();
				session.saveOrUpdate(magic);
				session.flush();
				session.evict(magic);
			}
			ts.commit();
			return true;
		} catch (HibernateException e) {
			if(ts!=null){
				ts.rollback();
			}
			e.printStackTrace();
		}
		return false;
	}
	
	public boolean delAnyMagicByIds(String[] ids) {
		Session session = HibernateUtil.getSessionFactory().getCurrentSession();
		Transaction ts = null;
		try {
			ts = session.beginTransaction();
			int len = ids.length;
			Magics magic = null;
			for(int i=0;i<len;i++){
				magic = (Magics)session.get(Magics.class, Short.parseShort(ids[i]));
				session.delete(magic);
			}
			ts.commit();
			return true;
		} catch (HibernateException e) {
			if(ts!=null){
				ts.rollback();
			}
			e.printStackTrace();
		}
		return false;
	}
	
	@SuppressWarnings({ "unchecked", "unchecked" })
	public List<Magicmarket> queryAllMagicInMarket() {
		Session session = HibernateUtil.getSessionFactory().getCurrentSession();
		Transaction ts = null;
		try {
			ts = session.beginTransaction();
			List mmBeanList = session.createQuery("from Magicmarket").list();
			ts.commit();
			return mmBeanList;
		} catch (HibernateException e) {
			if(ts!=null){
				ts.rollback();
			}
			e.printStackTrace();
		}
		return null;
	}
	
	public Magicmarket queryMagicMarketById(short id) {
		Session session = HibernateUtil.getSessionFactory().getCurrentSession();
		Transaction ts = null;
		try {
			ts = session.beginTransaction();
			Magicmarket mmBean = (Magicmarket)session.get(Magicmarket.class, id);
			ts.commit();
			return mmBean;
		} catch (HibernateException e) {
			if(ts!=null){
				ts.rollback();
			}
			e.printStackTrace();
		}
		return null;
	}
	
	public boolean delAnyMagicFromMagicMarket(String[] ids) {
		Session session = HibernateUtil.getSessionFactory().getCurrentSession();
		Transaction ts = null;
		try {
			ts = session.beginTransaction();
			int len = ids.length;
			Magicmarket mmBean = null;
			for(int i=0;i<len;i++){
				mmBean = (Magicmarket)session.get(Magicmarket.class, Short.parseShort(ids[i]));
				session.delete(mmBean);
			}
			ts.commit();
			return true;
		} catch (HibernateException e) {
			if(ts!=null){
				ts.rollback();
			}
			e.printStackTrace();
		}
		return false;
	}
	
	public boolean updateMagicMarket(List<Magicmarket> mmBeanList) {
		Session session = HibernateUtil.getSessionFactory().getCurrentSession();
		Transaction ts = null;
		try {
			ts = session.beginTransaction();
			Iterator<Magicmarket> mmBeanIt = mmBeanList.iterator();
			Magicmarket mmBean = null;
			while(mmBeanIt.hasNext()){
				mmBean = mmBeanIt.next();
				session.update(mmBean);
				session.flush();
				session.evict(mmBean);
			}
			ts.commit();
			return true;
		} catch (HibernateException e) {
			if(ts!=null){
				ts.rollback();
			}
			e.printStackTrace();
		}
		return false;
	}
	
	public List<Magics> getMagicByIdentifier(String identifier) {
		Session session = HibernateUtil.getSessionFactory().getCurrentSession();
		Transaction transaction = null;
		List<Magics> list = null;
		transaction = session.beginTransaction();
		String hql = "from Magics as magcis where magcis.identifier = ?";
		Query query = session.createQuery(hql);
		query.setString(0, identifier);
		list = query.list();
		transaction.commit();
		return list;
	}
	public Announcements queryAnnouncementById(short id) {
		Session session = HibernateUtil.getSessionFactory().getCurrentSession();
		Transaction ts = null;
		try {
			ts = session.beginTransaction();
			Announcements annBean = (Announcements)session.get(Announcements.class, id);
			ts.commit();
			return annBean;
		} catch (HibernateException e) {
			if(ts!=null){
				ts.rollback();
			}
			e.printStackTrace();
		}
		return null;
	}
	public boolean updateAnnouncement(Announcements ann) {
		Session session = HibernateUtil.getSessionFactory().getCurrentSession();
		Transaction ts = null;
		try {
			ts = session.beginTransaction();
			session.update(ann);
			ts.commit();
			return true;
		} catch (HibernateException e) {
			if(ts!=null){
				ts.rollback();
			}
			e.printStackTrace();
		}
		return false;
	}
	
	public boolean delAnyAnnouncement(String[] deletes) {
		Session session = HibernateUtil.getSessionFactory().getCurrentSession();
		Transaction  ts = null;
		try {
			ts = session.beginTransaction();
			int len = deletes.length;
			Announcements annBean = null;
			for(int i=0;i<len;i++){
				annBean = (Announcements)session.get(Announcements.class, Short.valueOf(deletes[i]));
				session.delete(annBean);