package com.tfy.oa.dao.impl;
import java.io.Serializable;
import java.util.Collection;
import java.util.List;
import java.util.Set;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import com.tfy.oa.dao.DepartmentDao;
import com.tfy.oa.domain.Department;
import com.tfy.oa.domain.User;
public class DepartmentDaoImpl extends HibernateDaoSupport implements DepartmentDao {
public void addDepartment(Department department) {
System.out.println(this.getHibernateTemplate());
this.getHibernateTemplate().save(department);
}
public void deleteDepartmentById(Serializable pid) {
Department department=(Department) this.getHibernateTemplate().get(Department.class, pid);
Set<User> users=department.getUsers();
for(User user:users){
user.setDepartment(null);
}
this.getHibernateTemplate().delete(department);
}
public Collection<Department> getAllDepartment() {
return this.getHibernateTemplate().find("from Department");
}
public Department getDepartmentById(Serializable pid) {
String sql = "FROM Department WHERE did=?";
System.out.println(this.getHibernateTemplate());
System.out.println(this.getHibernateTemplate().getClass());
List<Department> departments = this.getHibernateTemplate().find(sql,
new Object[] { pid });
if (departments == null || departments.size() < 1)
return null;
return (Department) departments.get(0);
}
public void updateDepartment(Department department) {
this.getHibernateTemplate().update(department);
}
}
import java.io.Serializable;
import java.util.Collection;
import java.util.List;
import java.util.Set;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import com.tfy.oa.dao.DepartmentDao;
import com.tfy.oa.domain.Department;
import com.tfy.oa.domain.User;
public class DepartmentDaoImpl extends HibernateDaoSupport implements DepartmentDao {
public void addDepartment(Department department) {
System.out.println(this.getHibernateTemplate());
this.getHibernateTemplate().save(department);
}
public void deleteDepartmentById(Serializable pid) {
Department department=(Department) this.getHibernateTemplate().get(Department.class, pid);
Set<User> users=department.getUsers();
for(User user:users){
user.setDepartment(null);
}
this.getHibernateTemplate().delete(department);
}
public Collection<Department> getAllDepartment() {
return this.getHibernateTemplate().find("from Department");
}
public Department getDepartmentById(Serializable pid) {
String sql = "FROM Department WHERE did=?";
System.out.println(this.getHibernateTemplate());
System.out.println(this.getHibernateTemplate().getClass());
List<Department> departments = this.getHibernateTemplate().find(sql,
new Object[] { pid });
if (departments == null || departments.size() < 1)
return null;
return (Department) departments.get(0);
}
public void updateDepartment(Department department) {
this.getHibernateTemplate().update(department);
}
}