deptdao.java

机房运营维护系统 java+oracle9i 使用struts 分用户权限 完成用户对机房信息的增删改查等功能

package com.model;

import java.sql.Date;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;
import java.util.Set;

import ms.hibernate.Dept;
import ms.hibernate.Emp;
import ms.hibernate.Log;
import ms.hibernate.Popedom;
import ms.hibernate.Role;
import ms.hibernate.Room;

import org.springframework.dao.DataAccessException;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.yourcompany.struts.form.NewDeptForm;

public class DeptDao extends HibernateDaoSupport implements IDeptDao {

	public List<DeptForm> findAllDept() {
		List<Dept> dept = this.getHibernateTemplate().find("from Dept");
		List<DeptForm> list = new ArrayList<DeptForm>();
		for (Iterator<Dept> it = dept.iterator(); it.hasNext();) {
			Dept de = it.next();
			DeptForm df = new DeptForm();
			df.setId(de.getDeptid());
			df.setDeptname(de.getDname());
			if (de.getEmp() != null) {
				df.setAdmin(de.getEmp().getEname());
			}
			list.add(df);
		}
		return list;
	}

	public boolean newCreateDept(NewDeptForm form, String empid) {
		Dept dept = new Dept();
		dept.setDname(form.getDname());
		dept.setTel(form.getTel());
		dept.setFax(form.getFax());
		dept.setMemo(form.getMemo());
		boolean temp = true;
		try {
			this.getHibernateTemplate().save(dept);
		} catch (DataAccessException e) {
			temp = false;
			e.printStackTrace();
		}
		return temp;
	}

	public void createLog(String empid, Long popedomid) {
		
		Popedom pope = (Popedom) this.getHibernateTemplate().load(
				Popedom.class, popedomid);
		Log log = new Log();
		log.setEmpid(empid);
		log.setPopedom(pope);
		Date date = new Date((new java.util.Date()).getTime());
		log.setWorkdate(date);
		this.getHibernateTemplate().save(log);

	}

	public List<Dept> findAllDepts() {
		List<Dept> list = this.getHibernateTemplate().find("from Dept");
		return list;
	}

	public DeptForm findDeptById(Long id) {
		DeptForm df = new DeptForm();
		Dept dept = (Dept) this.getHibernateTemplate().get(Dept.class, id);
		List<Emp> emps = new ArrayList<Emp>();
		for (Iterator<Emp> it = dept.getEmps().iterator(); it.hasNext();) {
			emps.add(it.next());
		}
		df.setAllEmps(emps);
		df.setDeptname(dept.getDname());
		df.setTel(dept.getTel());
		df.setFax(dept.getFax());
		df.setMemo(dept.getMemo());
		df.setId(dept.getDeptid());
		return df;
	}

	public boolean update(NewDeptForm form, String empid) {
		boolean temp = true;
		try {
			Dept dept = (Dept) this.getHibernateTemplate().get(Dept.class,
					form.getDeptid());
			Emp emp = null;
			if (form.getAdminid() != null) {
				emp = (Emp) this.getHibernateTemplate().get(Emp.class,
						form.getAdminid());
			}
			dept.setDname(form.getDname());
			dept.setEmp(emp);
			dept.setFax(form.getFax());
			dept.setMemo(form.getMemo());
			dept.setTel(form.getTel());
			this.getHibernateTemplate().update(dept);
		} catch (DataAccessException e) {
			temp = false;
			e.printStackTrace();
		}
		return temp;
	}

	public boolean delDept(Long[] ids, String empid) {
		boolean temp = true;
		try {
			if (ids != null) {
				for (Long i : ids) {
					Dept dept = (Dept) this.getHibernateTemplate().load(
							Dept.class, i);
					Set set = dept.getEmps();
					Set set1 = dept.getRooms();
					for (Iterator it = set1.iterator(); it.hasNext();) {
						Room room = (Room) it.next();
						room.setDept(null);
					}
					for (Iterator it = set.iterator(); it.hasNext();) {
						Emp emp = (Emp) it.next();
						emp.setDept(null);
					}
					this.getHibernateTemplate().delete(dept);
				}
			} else {
				return false;
			}
		} catch (DataAccessException e) {
			// TODO Auto-generated catch block
			temp = false;
			e.printStackTrace();
		}
		return temp;
	}

	public List<Emp> finaAllEmpByDept() {
		List<Dept> list = this.getHibernateTemplate().find("from Dept");
		List<Emp> emps = new ArrayList<Emp>();
		for (Iterator<Dept> it = list.iterator(); it.hasNext();) {
			Dept dept = it.next();
			if (dept.getEmp() != null) {
				Emp emp = dept.getEmp();
				emps.add(emp);
			}

		}
		return emps;
	}

	public List<DeptForm> queryResult(String dname, String empid, String id) {
		dname = dname.trim();
		id = id.trim();
		List<DeptForm> list = new ArrayList<DeptForm>();
		if ((id == null||id.equals("")) && (dname == null||dname.equals(""))) {
			List<Dept> dept = this.getHibernateTemplate().find("from Dept");
              
			for (Iterator<Dept> it = dept.iterator(); it.hasNext();) {
				Dept de = it.next();
				DeptForm df = new DeptForm();
				df.setId(de.getDeptid());
				df.setDeptname(de.getDname());
				if (de.getEmp() != null) {
					df.setAdmin(de.getEmp().getEname());
				}
				list.add(df);
				System.out.println("1");
			}
		}
		if (id != null&&(!id.equals("")) && (dname == null||dname.equals(""))) {
			Emp emp = (Emp) this.getHibernateTemplate().get(Emp.class, id);
			Set<Dept> depts = emp.getDepts();
			for (Iterator<Dept> it = depts.iterator(); it.hasNext();) {
				Dept de = it.next();
				DeptForm df = new DeptForm();
				df.setId(de.getDeptid());
				df.setDeptname(de.getDname());
				if (de.getEmp() != null) {
					df.setAdmin(de.getEmp().getEname());
				}
				list.add(df);
				
			}
		}
		if ((id == null||id.equals("")) && dname != null&&(!dname.equals(""))) {
			List<Dept> dept = this.getHibernateTemplate().find("from Dept where dname like ? ","%"+dname+"%");

			for (Iterator<Dept> it = dept.iterator(); it.hasNext();) {
				Dept de = it.next();
				DeptForm df = new DeptForm();
				df.setId(de.getDeptid());
				df.setDeptname(de.getDname());
				if (de.getEmp() != null) {
					df.setAdmin(de.getEmp().getEname());
				}
					list.add(df);
			}
		}
		if (id != null&&(!id.equals(""))&& dname != null&&(!dname.equals(""))) {
			Emp emp = (Emp) this.getHibernateTemplate().get(Emp.class, id);
			Set<Dept> depts = emp.getDepts();
			for (Iterator<Dept> it = depts.iterator(); it.hasNext();) {
				Dept de = it.next();
				if (de.getDname().indexOf(dname)==-1) {
					break;
				}
				DeptForm df = new DeptForm();
				df.setId(de.getDeptid());
				df.setDeptname(de.getDname());
				if (de.getEmp() != null) {
					df.setAdmin(de.getEmp().getEname());
				}
				list.add(df);
				
			}
		}
		return list;
	}

	public boolean checkName(String name) {
		name = name.trim();
		List list = this.getHibernateTemplate().find("from Dept where dname = ?",name);
		if(list==null||list.size()==0){
			return true;
		}else{
	    	return false;
		}
	}

}