daoimp.java

适合学生课程设计使用,这是我自己编写的一个系统.

package persistence;

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

import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
import org.hibernate.Query;
import org.hibernate.Criteria;
import org.hibernate.criterion.Restrictions;
import org.hibernate.criterion.MatchMode;
import org.hibernate.Transaction;
import org.hibernate.exception.*;
import org.hibernate.criterion.Example;

import bean.*;
import tools.*;

public class DAOImp {
	static Session session = null;
	
	public static void createPer(userInfo ui) {			//创建或更新人物
		try {
			session = HibernateUtil.currentSession();
			Transaction tx = session.beginTransaction();
			session.saveOrUpdate(ui);
			tx.commit();
		} catch(HibernateException e) {
			e.printStackTrace();
		} finally {
			HibernateUtil.closeSession(session);
		}
	}
	
	public static void createPop(popedom pop) {			//创建或更新权限
		try {
			session = HibernateUtil.currentSession();
			Transaction tx = session.beginTransaction();
			session.saveOrUpdate(pop);
			tx.commit();
		} catch(HibernateException e) {
			e.printStackTrace();
		} finally {
			HibernateUtil.closeSession(session);
		}
	}

	public static void createRol(role rol) {			//创建或更新角色
		try {
			session = HibernateUtil.currentSession();
			Transaction tx = session.beginTransaction();
			session.saveOrUpdate(rol);
			tx.commit();
		} catch(HibernateException e) {
			e.printStackTrace();
		} finally {
			HibernateUtil.closeSession(session);
		}
	}
	
	public static void createBookInfo(bookInfo bi) {			//创建或更新书
		try {
			session = HibernateUtil.currentSession();
			Transaction tx = session.beginTransaction();
			session.saveOrUpdate(bi);
			tx.commit();
		} catch(HibernateException e) {
			e.printStackTrace();
		} finally {
			HibernateUtil.closeSession(session);
		}
	}

	public static void createBookType(bookType bt) {			//创建或更新书的类型
		try {
			session = HibernateUtil.currentSession();
			Transaction tx = session.beginTransaction();
			session.saveOrUpdate(bt);
			tx.commit();
		} catch(HibernateException e) {
			e.printStackTrace();
		} finally {
			HibernateUtil.closeSession(session);
		}
	}
	
	public static void createBookState(bookState bs) {			//创建或更新书的状态
		try {
			session = HibernateUtil.currentSession();
			Transaction tx = session.beginTransaction();
			session.saveOrUpdate(bs);
			tx.commit();
		} catch(HibernateException e) {
			e.printStackTrace();
		} finally {
			HibernateUtil.closeSession(session);
		}
	}	
	
	public static void createPublishingCompany(publishingCompany pc) {			//创建或更新书的出版社
		try {
			session = HibernateUtil.currentSession();
			Transaction tx = session.beginTransaction();
			session.saveOrUpdate(pc);
			tx.commit();
		} catch(HibernateException e) {
			e.printStackTrace();
		} finally {
			HibernateUtil.closeSession(session);
		}
	}
	
	public static void createModule(module mod) {			//创建或更新模块
		try {
			session = HibernateUtil.currentSession();
			Transaction tx = session.beginTransaction();
			session.saveOrUpdate(mod);
			tx.commit();
		} catch(HibernateException e) {
			e.printStackTrace();
		} finally {
			HibernateUtil.closeSession(session);
		}
	}
	
	public static boolean isContantUserInfo(String id,String pwd) {			//判断Id和密码是否正确,登录时用
		boolean bool = false;
		try {
			session = HibernateUtil.currentSession();
			Transaction tx = session.beginTransaction();
			Criteria crit = session.createCriteria(userInfo.class);
			crit.add(Restrictions.eq("id",id)).add(Restrictions.eq("password",Encrypt.createCode(pwd)));
			List list = crit.list();
			Iterator iter = list.iterator();
			if(iter.hasNext()) {
				bool = true;
			}
			tx.commit();
		} catch(HibernateException e) {
			e.printStackTrace();
		} finally {
			HibernateUtil.closeSession(session);
		}
		return bool;
	}		

	public static boolean isContantUser(String id) {			//判断是否有此Id的人
		boolean bool = false;
		try {
			session = HibernateUtil.currentSession();
			Transaction tx = session.beginTransaction();
			Criteria crit = session.createCriteria(userInfo.class);
			crit.add(Restrictions.eq("id",id));
			List list = crit.list();
			Iterator iter = list.iterator();
			if(iter.hasNext()) {
				bool = true;
			}
			tx.commit();
		} catch(HibernateException e) {
			e.printStackTrace();
		} finally {
			HibernateUtil.closeSession(session);
		}
		return bool;
	}	
	
	public static userInfo searchUserInfo(String id) {			//获得此Id人物的信息
		userInfo use = null;
		try {
			session = HibernateUtil.currentSession();
			Transaction tx = session.beginTransaction();
			
			Criteria crit = session.createCriteria(userInfo.class);
			crit.add(Restrictions.eq("id",id));
			List list = crit.list();
			Iterator iter = list.iterator();
			if(iter.hasNext()) {
				use = (userInfo)iter.next();
				System.out.println(use.getName() + " , " + use.getAge() + " , " + use.getAddress());
				Set<role> rol = use.getRol();
				Iterator riter = rol.iterator();
				while(riter.hasNext()) {
					role ro = (role)riter.next();
					System.out.println(ro.getName());
					Set<module> smo = ro.getMod();
					Iterator miter = smo.iterator();
					while(miter.hasNext()) {
						module mod = (module)miter.next();
						System.out.println(mod.getName());
					}
				}
			}
			tx.commit();
		} catch(HibernateException e) {
			e.printStackTrace();
		} finally {
			HibernateUtil.closeSession(session);
		}
		return use;
	}

	public static boolean searchBookRows(String str) {			//模糊查询,是否有此图书记录
		boolean bool = false;
		try {
			session = HibernateUtil.currentSession();
			Transaction tx = session.beginTransaction();
			
			Criteria crit = session.createCriteria(bookInfo.class);
			crit.add(Restrictions.like("name",str,MatchMode.ANYWHERE));
			List list = crit.list();
			Iterator iter = list.iterator();
			if(iter.hasNext()) {
				bool = true;
				bookInfo book = (bookInfo)iter.next();
				System.out.println(book.getName());
			}
			
			tx.commit();
		} catch(HibernateException e) {
			e.printStackTrace();
		} finally {
			HibernateUtil.closeSession(session);
		}
		return bool;
	}	

	public static List getBookRows(String str) {			//模糊查询,返回图书记录
		List list = null;
		try {
			session = HibernateUtil.currentSession();
			Transaction tx = session.beginTransaction();
			Criteria crit = session.createCriteria(bookInfo.class);
			crit.add(Restrictions.like("name",str,MatchMode.ANYWHERE));
			list = crit.list();
			tx.commit();
		} catch(HibernateException e) {
			e.printStackTrace();
		} finally {
			HibernateUtil.closeSession(session);
		}
		return list;
	}
	
	public static boolean modifyUserPwd(String id,String pwd) {			//修改密码
		boolean bool = false;
		try {
			session = HibernateUtil.currentSession();
			Transaction tx = session.beginTransaction();
			userInfo ui = (userInfo)session.get(userInfo.class,id);
			ui.setPassword(Encrypt.createCode(pwd));
			session.update(ui);
			bool = true;
			tx.commit();
		} catch(HibernateException e) {
			e.printStackTrace();
		} finally {
			HibernateUtil.closeSession(session);
		}
		return bool;
	}	

	public static List getPopedomRows() {			//返回所有权限记录
		List list = null;
		try {
			session = HibernateUtil.currentSession();
			Transaction tx = session.beginTransaction();
			Criteria crit = session.createCriteria(popedom.class);
			Query q = session.createQuery("from popedom");
			list = q.list();
			tx.commit();
		} catch(HibernateException e) {
			e.printStackTrace();
		} finally {
			HibernateUtil.closeSession(session);
		}
		return list;
	}

	public static void main(String[] args) {
		DAOImp test = new DAOImp();
		System.out.println(test.searchBookRows("2000"));
	}

}