staffbasicinfodaoimpl.java

一个oa系统

package com.oa.crm.db;

import java.util.ArrayList;

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

import com.oa.db.Staffbasicinfo;

public class StaffBasicInfoDAOImpl extends HibernateDaoSupport implements
		StaffBasicinfoDao {

	public Staffbasicinfo findOneEmpByName(String realName) {
		// TODO 自动生成方法存根
		Staffbasicinfo staffBasicInfo = new Staffbasicinfo();
		staffBasicInfo = (Staffbasicinfo) getHibernateTemplate().find("from Staffbasicinfo where realname = ?", realName).get(0);
		return staffBasicInfo;
	}

	public ArrayList<Staffbasicinfo> findMartDeptAllEmp() {
		ArrayList<Staffbasicinfo> list = new ArrayList<Staffbasicinfo>();
		 String []staffStatus = new String[4]; 
		 staffStatus[0] = ""+4;
		 staffStatus[1] = "正式员工";
		 staffStatus[2]= "试用"; 
		 staffStatus[3]= "薛御翔";
		 String sql = "from Staffbasicinfo where departmentid = ? and (staffstatus = ? or staffstatus = ?) and realname!=?";	  
		 list = (ArrayList<Staffbasicinfo>) getHibernateTemplate().find(sql,staffStatus); 		 		
		return list;
	}

	public Staffbasicinfo findOneEmpById(String empId) {
		Staffbasicinfo staffBasicInfo = new Staffbasicinfo();
		staffBasicInfo = (Staffbasicinfo) getHibernateTemplate().find("from Staffbasicinfo where staffnamebh = ?", ""+empId).get(0);
		return staffBasicInfo;
	}
}