salary_infodaofordwr.java

人力资源管理系统

package org.HumResManSys.dao.impl;

import java.util.List;

import org.HumResManSys.dao.Salary_infoDAO;
import org.HumResManSys.factory.DAOFactory;
import org.HumResManSys.vo.Salary_info;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.dao.DataAccessException;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

public class Salary_infoDAOForDWR extends HibernateDaoSupport{
	private DAOFactory daoFactory;
	
	public DAOFactory getDaoFactory() {
		ApplicationContext ac=
			new ClassPathXmlApplicationContext("/applicationContext.xml");
		DAOFactory daoFactory=(DAOFactory)ac.getBean("DAOFactory");
		return daoFactory;
	}

	public void setDaoFactory(DAOFactory daoFactory) {
		this.daoFactory = daoFactory;
	}

	public List<Salary_info> queryAllSalary_info(){
		List list=null;
		try {
			Salary_infoDAO sd=this.getDaoFactory().getSalary_infoDAO();
			list=sd.queryAllSalary_infos();
//			System.out.println(list.size());
			sd.closeSession();
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			System.out.println("Salary_infoDAOForDWR queryAllSalary_info error");
		}
		return list;
	}

	public boolean createSalary_info(String[] sal){
		boolean okOrNot=false;
		try {
			Salary_info s=new Salary_info();
			String name = new String(sal[0].getBytes("ISO-8859-1"), "gb2312");
			System.out.println(name);
			s.setEmp_name(name);
			s.setMonth(sal[1]);
			if(!"".equals(sal[2])){
			s.setBasic_sal(Long.parseLong(sal[2]));
			}
			if(!"".equals(sal[3])){
			s.setJintie(Long.parseLong(sal[3]));
			}
			if(!"".equals(sal[4])){
			s.setBonus(Long.parseLong(sal[4]));
			}
			if(!"".equals(sal[5])){
				s.setTax_rate(Long.parseLong(sal[5]));
				}
			if(!"".equals(sal[6])){
			s.setSum_sal(Long.parseLong(sal[6]));
			}
			Salary_infoDAO sd=this.getDaoFactory().getSalary_infoDAO();
			okOrNot=sd.createSalary_info(s);
			sd.closeSession();
		}catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			System.out.println("Salary_infoDAOForDWR createSalary_info error");
			return false;
		}
		return okOrNot;
	}
	
	public boolean updateSalary_info(String[] sal){
		boolean okOrNot=false;
		try {
			Salary_infoDAO sd=this.getDaoFactory().getSalary_infoDAO();
			Salary_info s=
				sd.queryOneSalary_infoByCondition("emp_name", sal[0]);
		//	s.setEmp_name(sal[0]);
			s.setMonth(sal[1]);
			if(!"".equals(sal[2])){
			s.setBasic_sal(Long.parseLong(sal[2]));
			}
			if(!"".equals(sal[3])){
			s.setJintie(Long.parseLong(sal[3]));
			}
			if(!"".equals(sal[4])){
			s.setBonus(Long.parseLong(sal[4]));
			}
			if(!"".equals(sal[5])){
				s.setTax_rate(Long.parseLong(sal[5]));
				}
			if(!"".equals(sal[6])){
			s.setSum_sal(Long.parseLong(sal[6]));
			}
			okOrNot=sd.updateSalary_info(s);
			sd.closeSession();
		} catch (NumberFormatException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (DataAccessException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			System.out.println("Salary_infoDAOForDWR updateSalary_info error");
			return false;
		}
		return okOrNot;
	}
	
	public boolean deleteSalary_info(String emp_name){
		boolean okOrNot=false;
		try {
			Salary_infoDAO sd=this.getDaoFactory().getSalary_infoDAO();
			okOrNot=
				sd.deleteSalary_infoByCondition("emp_name", emp_name);
			sd.closeSession();
		} catch (NumberFormatException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (DataAccessException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			System.out.println("Salary_infoDAOForDWR deleteSalary_info error");
			return false;
		}
		return okOrNot;
	}
	
}