generateexceldoctest.java

人力资源管理系统

package org.HumanResManSys.util;

import java.util.List;

import org.HumResManSys.factory.DAOFactory;
import org.HumResManSys.util.GenerateExcelDoc;
import org.HumResManSys.vo.Salary_info;
import org.junit.Test;
import org.springframework.beans.BeansException;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

public class GenerateExcelDocTest {
	private GenerateExcelDoc g=new GenerateExcelDoc();

	@Test
	public void testGenerateAllEmployeesSalaryExcel() {
		try {

			ApplicationContext ac=
				new ClassPathXmlApplicationContext("/applicationContext.xml");
			DAOFactory f=(DAOFactory)ac.getBean("DAOFactory");
			Salary_info salary_info=new Salary_info();
			List<Salary_info> list=f.getSalary_infoDAO().queryAllSalary_infos();
			g.generateAllEmployeesSalaryExcel(list,"d:/员工工资报表.xls");
		} catch (BeansException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

}