postsinfodaoimpl.java

jsp+servlet+Hibernte实现的公务员网上报名系统。为大学毕业设计成果

package com.dao.impl;

import java.util.ArrayList;
import java.util.HashSet;
import java.util.Iterator;
import java.util.List;
import java.util.Set;

import net.sf.hibernate.HibernateException;
import net.sf.hibernate.Query;
import net.sf.hibernate.Session;
import net.sf.hibernate.Transaction;

import com.dao.PostsInfoDAO;
import com.entity.AppInfo;
import com.entity.PostsInfo;
import com.hibernate.HibernateSessionFactory;

public class PostsInfoDAOImpl implements PostsInfoDAO {

	public boolean addPostsInfo(PostsInfo postsInfo) {
		Session session = HibernateSessionFactory.openHibernateSession();
		boolean state = false;
		try {
			Transaction tran = session.beginTransaction();
			session.save(postsInfo);
			tran.commit();
			state = true;
		} catch (HibernateException e) {
			e.printStackTrace();
		}
		return state;
	}

	public boolean delPostsInfo(int postsID) {
		Session session = HibernateSessionFactory.openHibernateSession();
		PostsInfo postsInfo = null;
		boolean state = false;
		try {
			Transaction tran = session.beginTransaction();
			postsInfo = queryPostsInfoByID(postsID);
			session.delete(postsInfo);
			tran.commit();
		} catch (HibernateException e) {
			e.printStackTrace();
		}
		return state;
	}

	public List queryPostsInfo() {
		Session session = HibernateSessionFactory.openHibernateSession();
		List list = null;
		Query query = null;
		try {
			query = session.createQuery("from PostsInfo");
			list = query.list();
		} catch (HibernateException e) {
			e.printStackTrace();
		}
		return list;
	}

	public PostsInfo queryPostsInfoByID(int postsID) {
		Session session = HibernateSessionFactory.openHibernateSession();
		PostsInfo postsInfo = null;
		try {
			postsInfo = (PostsInfo) session.get(PostsInfo.class, postsID);
		} catch (HibernateException e) {
			e.printStackTrace();
		}
		return postsInfo;
	}

	public List queryPostsInfoByPostName(String postsName) {
		Session session = HibernateSessionFactory.openHibernateSession();
		List list = null;
		Query query = null;
		try {
			query = session.createQuery("from PostsInfo p where p.postsName='"+postsName+"'");
		    list = query.list();
		} catch (HibernateException e) {
			e.printStackTrace();
		}
		return list;
	}

	public List queryPostsInfoByPostsDep(String postsDep) {
		Session session = HibernateSessionFactory.openHibernateSession();
		List list = null;
		Query query = null;
		try {
			query = session.createQuery("from PostsInfo p where p.postsDep='"+postsDep+"'");
			list = query.list();
		} catch (HibernateException e) {
			e.printStackTrace();
		}
		return list;
	}

	public boolean updatePostsInfo(PostsInfo postsInfo) {
		Session session = HibernateSessionFactory.openHibernateSession();
		boolean state = false;
		try {
			Transaction tran = session.beginTransaction();
			session.update(postsInfo);
			tran.commit();
		} catch (HibernateException e) {
			e.printStackTrace();
		}
		return state;
	}

	public List queryAppInfoByPostsInfo(List listPosts) {
		Iterator iteratorList = listPosts.iterator(); 
		List<AppInfo> listAppInfo = new ArrayList<AppInfo>();
		while(iteratorList.hasNext()){
			PostsInfo postsInfo = (PostsInfo) iteratorList.next();
			Set set = postsInfo.getAppInfos();
			Iterator iteratorSet = set.iterator();
			while(iteratorSet.hasNext()){
				AppInfo appInfo = (AppInfo) iteratorSet.next();
				listAppInfo.add(appInfo);
			}
		}
		return listAppInfo;
	}

	public PostsInfo qureyPostsInfoByIndify(int postsIndify) {
		Session session = HibernateSessionFactory.openHibernateSession();
		PostsInfo postsInfo = null;
		try {
			Query query = session.createQuery("from PostsInfo p where p.postsIndify='"+postsIndify+"'");
			List list = query.list();
			postsInfo = (PostsInfo) list.get(0);
		} catch (HibernateException e) {
			e.printStackTrace();
		}
		return postsInfo;
	}

	public boolean delPostsInfoByIndify(int postsIndify) {
		Session session = HibernateSessionFactory.openHibernateSession();
		PostsInfo postsInfo = null;
		boolean state = false;
		try {
			Transaction tran = session.beginTransaction();
			postsInfo = qureyPostsInfoByIndify(postsIndify);
			session.delete(postsInfo);
			tran.commit();
		} catch (HibernateException e) {
			e.printStackTrace();
		}
		return state;
	}

	public Set queryPostsNames() {
		List list = queryPostsInfo();
		Set<String> set = new HashSet<String>();
		for(int i=0;i<list.size();i++){
			PostsInfo postsInfo = (PostsInfo) list.get(i);
			String postsName = postsInfo.getPostsName();
			set.add(postsName);
		}
		return set;
	}

	public Set queryPostsDeps() {
		List list = queryPostsInfo();
		Set<String> set = new HashSet<String>();
		for(int i=0;i<list.size();i++){
			PostsInfo postsInfo = (PostsInfo) list.get(i);
			String postsDep = postsInfo.getPostsDep();
			set.add(postsDep);
		}
		return set;
	}

}