appinfodaoimpl.java

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

package com.dao.impl;

import java.util.List;

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

import com.dao.AppInfoDAO;
import com.entity.AppInfo;
import com.hibernate.HibernateSessionFactory;

public class AppInfoDAOImpl implements AppInfoDAO {

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

	public boolean delAppInfo(int appID) {
		AppInfo appInfo = null;
		Session session = HibernateSessionFactory.openHibernateSession();
		boolean state = false;
		
		try {
			Transaction tran = session.beginTransaction();
			appInfo = queryAppInfoByID(appID);
			session.delete(appInfo);
			tran.commit();
			state = true;
		} catch (HibernateException e) {
			e.printStackTrace();
		}
		
		return state;
	}

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

	public AppInfo queryAppInfoByID(int appID) {
		Session session = HibernateSessionFactory.openHibernateSession();
		AppInfo appInfo = null;
		try {
			appInfo = (AppInfo) session.get(AppInfo.class, appID);
		} catch (HibernateException e) {
			e.printStackTrace();
		}
		return appInfo;
	}

	public boolean updateAppInfo(AppInfo appInfo) {
		Session session = HibernateSessionFactory.openHibernateSession();
		boolean state = false;
		Transaction tran;
		try {
			tran = session.beginTransaction();
			session.update(appInfo);
			tran.commit();
			state = true;
		} catch (HibernateException e) {
			e.printStackTrace();
		}
		return state;
	}
	
	public List queryAppInfoByPostsID(int postsID) {
		Session session = HibernateSessionFactory.openHibernateSession();
		List list = null;
		Query query = null;
		try {
			query = session.createQuery("from AppInfo a where a.postsID='"+postsID+"'");
			list = query.list();
		} catch (HibernateException e) {
			e.printStackTrace();
		}
		return list;
	}

	public String queryPasswordByAppIndify(int appIndify, String passwordQuestion, String passwordAnswer) {
		Session session = HibernateSessionFactory.openHibernateSession();
		String password = null;
		Query query = null;
		try {
			query = session.createQuery("from AppInfo a where a.appIndify='"+appIndify+"' and a.passwordQuestion='"+passwordQuestion+"' and a.passwordAnswer='"+passwordAnswer+"'");
			List list = query.list();
			AppInfo appInfo = (AppInfo)list.get(0);
			password = appInfo.getAppPassword();
		} catch (HibernateException e) {
			e.printStackTrace();
		}
		return password;
	}

	public String queryPasswordByIndify(int appIndify) {
		Session session = HibernateSessionFactory.openHibernateSession();
		String password = null;
		Query query = null;
		try {
			query = session.createQuery("from AppInfo a where a.appIndify='"+appIndify+"'");
			List list = query.list();
			AppInfo appInfo = (AppInfo)list.get(0);
			password = appInfo.getAppPassword();
		} catch (HibernateException e) {
			e.printStackTrace();
		}
		return password;
	}

	public AppInfo queryAppInfoByIndify(int appIndify) {
		Session session = HibernateSessionFactory.openHibernateSession();
		AppInfo appInfo = null;
		Query query = null;
		try {
			query = session.createQuery("from AppInfo a where a.appIndify='"+appIndify+"'");
			List list = query.list();
			appInfo = (AppInfo) list.get(0);
		} catch (HibernateException e) {
			e.printStackTrace();
		}
		return appInfo;
	}
}