userdaohbnimpl.java

一个用户管理系统的例子,作的很好,有前端,有后台,增加,删除,修改,查找都可以实现

package com.allanlxf.ums.dao.impl;

import java.util.Collection;

import org.hibernate.Criteria;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;
import org.hibernate.criterion.Example;
import org.hibernate.criterion.MatchMode;
import org.hibernate.criterion.Restrictions;

import com.allanlxf.ums.dao.UserDao;
import com.allanlxf.ums.entity.Administrator;
import com.allanlxf.ums.entity.SystemUser;
import com.allanlxf.ums.util.HibernateUtil;

public class UserDaoHbnImpl implements UserDao
{
    public UserDaoHbnImpl()
    {
        System.out.println("UserDaoHbnImpl()");
    }

    public void insert(SystemUser user)
    {
        Session session = null;
        Transaction trans = null;

        try
        {
            session = HibernateUtil.getSession();
            trans = session.beginTransaction();
            session.save(user);
            trans.commit();
        } catch (Exception e)
        {
            e.printStackTrace();
            trans.rollback();
            throw new RuntimeException(e.getMessage());
        } finally
        {
            session.close();
        }
    }

    public void update(SystemUser user)
    {
        Session session = null;
        Transaction trans = null;

        try
        {
            session = HibernateUtil.getSession();
            trans = session.beginTransaction();
            session.update(user);
            trans.commit();
        } catch (Exception e)
        {
            e.printStackTrace();
            trans.rollback();
            throw new RuntimeException(e.getMessage());
        } finally
        {
            session.close();
        }
    }

    public void delete(int id)
    {
        Session session = null;
        Transaction trans = null;

        try
        {
            session = HibernateUtil.getSession();
            trans = session.beginTransaction();
            String hql = "delete from SystemUser where id = :id";
            Query query = session.createQuery(hql);
            query.setInteger("id", id).executeUpdate();
            trans.commit();
        } catch (Exception e)
        {
            e.printStackTrace();
            trans.rollback();
            throw new RuntimeException(e.getMessage());
        } finally
        {
            session.close();
        }
    }

    public SystemUser selectById(int id)
    {
        Session session = null;
        Transaction trans = null;
        SystemUser user = null;

        try
        {
            session = HibernateUtil.getSession();
            trans = session.beginTransaction();
            user = (SystemUser) session.get(SystemUser.class, id);
            trans.commit();
        } catch (Exception e)
        {
            e.printStackTrace();
            trans.rollback();
            throw new RuntimeException(e.getMessage());
        } finally
        {
            session.close();
        }

        return user;
    }

    public Collection<SystemUser> select(SystemUser user)
    {
        Session session = null;
        Transaction trans = null;
        Collection users = null;

        try
        {
            session = HibernateUtil.getSession();
            trans = session.beginTransaction();
            Criteria crit = session.createCriteria(SystemUser.class);
            Example example = Example.create(user);
            example.excludeProperty("college");
            crit.add(example);
            if (user.getCollege() != null)
            {
                crit.add(Restrictions.ilike("college", user.getCollege(),
                        MatchMode.ANYWHERE));
            }
            users = crit.list();
            trans.commit();
        } catch (Exception e)
        {
            e.printStackTrace();
            trans.rollback();
            throw new RuntimeException(e.getMessage());
        } finally
        {
            session.close();
        }

        return users;
    }

    public Administrator select(String userName, String password)
    {
        Session session = null;
        Transaction trans = null;
        Administrator admin = null;

        try
        {
            session = HibernateUtil.getSession();
            trans = session.beginTransaction();
            String hql = "from Administrator admin where admin.userName = :userName and admin.password = :password";
            Query query = session.createQuery(hql);
            query.setString("userName", userName);
            query.setString("password", password);
            admin = (Administrator) query.uniqueResult();
            trans.commit();
        } catch (Exception e)
        {
            e.printStackTrace();
            trans.rollback();
            throw new RuntimeException(e.getMessage());
        } finally
        {
            session.close();
        }

        return admin;
    }
}