HRMS.zip_HRMS_企业管理

package cn.edu.pdsu.java1.hrms.dao; import java.sql.SQLException; import java.util.ArrayList; import java.util.Date; import java.util.List; import org.hibernate.Criteria; import org.hibernate.HibernateException; import org.hibernate.Session; import org.hibernate.SessionFactory; import org.hibernate.criterion.Criterion; import org.hibernate.criterion.DetachedCriteria; import org.hibernate.criterion.Order; import org.hibernate.criterion.Projections; import org.hibernate.criterion.Restrictions; import org.springframework.orm.hibernate3.HibernateCallback; import org.springframework.orm.hibernate3.support.HibernateDaoSupport; import cn.edu.pdsu.java1.hrms.bean.HrmsOffice; import cn.edu.pdsu.java1.hrms.bean.HrmsUser; import cn.edu.pdsu.java1.hrms.bean.HrmsWorktype; public class UserDao extends HibernateDaoSupport { public HrmsUser findById(String id) { // TODO Auto-generated method stub return (HrmsUser) getHibernateTemplate().get(HrmsUser.class, new Integer(id)); } public ArrayList<HrmsUser> findUserByNumber(final String number) { // TODO Auto-generated method stub ArrayList<HrmsUser> list = (ArrayList<HrmsUser>) getHibernateTemplate() .execute(new HibernateCallback() { public Object doInHibernate(Session session) throws HibernateException, SQLException { // TODO Auto-generated method stub ArrayList<HrmsUser> result = (ArrayList<HrmsUser>) session .createCriteria(HrmsUser.class) .add(Restrictions.eq("number", new Integer(number))) .addOrder(Order.asc("id")).list(); return result; } }); return list; } public ArrayList<HrmsUser> findUserByOffice(final String office) { // TODO Auto-generated method stub ArrayList<HrmsUser> list = (ArrayList<HrmsUser>) getHibernateTemplate() .execute(new HibernateCallback() { public Object doInHibernate(Session session) throws HibernateException, SQLException { // TODO Auto-generated method stub ArrayList<HrmsUser> result = (ArrayList<HrmsUser>) session .createCriteria(HrmsUser.class) .add(Restrictions.eq("hrmsOffice.id", new Integer(office))) .add(Restrictions.eq("type", 0)) .addOrder(Order.asc("id")).list(); return result; } }); return list; } public int findMaxNumberUser() { List list = (List) getHibernateTemplate().execute( new HibernateCallback() { public Object doInHibernate(Session session) throws HibernateException, SQLException { // TODO Auto-generated method stub List result = session.createCriteria(HrmsUser.class) .setProjection(Projections.max("number")) .list(); return result; } }); if (list.size() > 0) { return (Integer) list.get(0); } else { return 0; } } public HrmsOffice findOfficeById(final String id) { List list = (List) getHibernateTemplate().execute( new HibernateCallback() { public Object doInHibernate(Session session) throws HibernateException, SQLException { // TODO Auto-generated method stub List result = session.createCriteria(HrmsOffice.class) .add(Restrictions.eq("id", new Integer(id))) .list(); return result; } }); if (list.size() > 0) { return (HrmsOffice) (list.get(0)); } else { return null; } } public HrmsWorktype findWorktypeById(final String id) { List list = (List) getHibernateTemplate().execute( new HibernateCallback() { public Object doInHibernate(Session session) throws HibernateException, SQLException { // TODO Auto-generated method stub List result = session.createCriteria(HrmsWorktype.class) .add(Restrictions.eq("id", new Integer(id))) .list(); return result; } }); if (list.size() > 0) { return (HrmsWorktype) (list.get(0)); } else { return null; } } public void insert(HrmsUser hrmsUser) { // TODO Auto-generated method stub getHibernateTemplate().save(hrmsUser); } public void delete(String id) { // TODO Auto-generated method stub Object p = getHibernateTemplate().load(HrmsUser.class, new Integer(id)); getHibernateTemplate().delete(p); } public void update(HrmsUser hrmsUser) { // TODO Auto-generated method stub getHibernateTemplate().saveOrUpdate(hrmsUser); } public boolean isVaild(final String number, final String password) { // TODO Auto-generated method stub List list = (List) getHibernateTemplate().execute( new HibernateCallback() { public Object doInHibernate(Session session) throws HibernateException, SQLException { // TODO Auto-generated method stub List result = session.createCriteria(HrmsUser.class) .add(Restrictions.eq("number", new Integer(number))) .add(Restrictions.eq("password", password)) .list(); return result; } }); if (list.size() > 0) { return true; } else { return false; } } public boolean isExist(final String number) { // TODO Auto-generated method stub List list = (List) getHibernateTemplate().execute( new HibernateCallback() { public Object doInHibernate(Session session) throws HibernateException, SQLException { // TODO Auto-generated method stub List result = session.createCriteria(HrmsUser.class) .add(Restrictions.eq("number", new Integer(number))) .list(); return result; } }); if (list.size() > 0) { return true; } else { return false; } } public ArrayList<HrmsUser> findAllManager() { // TODO Auto-generated method stub ArrayList<HrmsUser> list = (ArrayList<HrmsUser>) getHibernateTemplate() .execute(new HibernateCallback() { public Object doInHibernate(Session session) throws HibernateException, SQLException { // TODO Auto-generated method stub ArrayList<HrmsUser> result = (ArrayList<HrmsUser>) session .createCriteria(HrmsUser.class).add(Restrictions.eq("type", 1)).addOrder(Order.asc("id")).list(); return result; } }); return list; } public ArrayList<HrmsUser> findAllUser() { // TODO Auto-generated method stub ArrayList<HrmsUser> list = (ArrayList<HrmsUser>) getHibernateTemplate() .execute(new HibernateCallback() { public Object doInHibernate(Session session) throws HibernateException, SQLException { // TODO Auto-generated method stub ArrayList<HrmsUser> result = (ArrayList<HrmsUser>) session .createCriteria(HrmsUser.class).add(Restrictions.eq("type", 0)).addOrder(Order.asc("id")).list(); return result; } }); return list; } }