empbo.java

办公自动化系统,有人事资源管理模块,考勤管理,审批管理,权限设定等.

package com.lovo.bo.mjy;


import java.util.GregorianCalendar;
import java.util.Vector;

import com.lovo.dao.mjy.DataBase;
import com.lovo.dao.mjy.SqlSentence;
import com.lovo.po.mjy.EmpPo;
import com.lovo.po.mjy.LeavePo;
import com.lovo.po.mjy.WorkInfoPo;
import com.lovo.util.DBConnection;
import com.lovo.vo.mjy.TermVo;
import com.mysql.jdbc.PreparedStatement;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.SimpleDateFormat;

public class EmpBo {
	//得到员工的个人信息
	public Vector getSelectPIM(TermVo vo){
		EmpPo ep = new EmpPo();
		ep.setId(vo.getEmpId());
		ep.setStart(vo.getStart());
		DataBase d= new DataBase();
		Vector vector = d.getSelectPIM(ep);
		return vector;
	}
	//得到所有员工的个人信息
	public Vector getSelectAll(TermVo vo){
		EmpPo ep = new EmpPo();
		ep.setStart(vo.getStart());
		DataBase d= new DataBase();
		Vector vector = d.getSelectAll(ep);
		return vector;
	}
	//得到员工的个人信息一共的条数
	public TermVo getCountB(TermVo vo){
		EmpPo e=new EmpPo();
		e.setId(vo.getEmpId());
		DataBase d= new DataBase();
		EmpPo ep = d.getCountB(e);
		TermVo v= new TermVo();
		vo.setCount(ep.getCount());
		return v;
	}
	
	//得到所有员工的个人信息一共的条数
	public TermVo getCountA(){
		DataBase d= new DataBase();
		EmpPo ep = d.getCountA();
		TermVo vo= new TermVo();
		vo.setCount(ep.getCount());
		vo.setYear(ep.getYear());
		return vo;
	}
	//更新员工的初始化日期
	public boolean updateYear(TermVo vo){
			DataBase d= new DataBase();
			EmpPo ep=new EmpPo();
			ep.setYear(vo.getYear());
			return d.updateYear(ep);
	}
	//更新员工的请假信息������ݿ��е�������
	public boolean update(boolean isInitialize){
		if(isInitialize){
			DataBase d= new DataBase();
			d.update(true);
			return true;
		}else{
			return false;
		}
	}
	public static void main(String[] args){
		EmpBo a = new EmpBo();
		TermVo vo = new TermVo();
		vo.setYear("1234");
//		System.out.println(a.getCountB(vo).getCount());
		EmpPo e = new EmpPo();
	//	ep.setYear("1534");
	//	DataBase d= new DataBase();
		System.out.println(a.updateYear(vo));
		System.out.println(a.getCountA().getCount());
//		System.out.println(d.getCountB(ep).getCount());
		vo.setStart(0);
//		vo.setEmpId("1");
		//Vector v=a.getSelectPIM(vo);
//		boolean n=a.update(true);
//		if(n){
//			System.out.println("成功了��ȳ�ʼ���chenggong");
//		}else{
//			System.out.println("失败了");
//		}
//		vo.setStart(0);
		Vector v=a.getSelectAll(vo);
		for(int i=0;i<v.size();i++){
			EmpPo ep =(EmpPo)v.get(i);
			System.out.println(ep.getYear()+" \t    "+ep.getTanqing()+" \t    "+ep.getGongli()+" \t    "+ep.getName());
			//System.out.println(ep.getName()+" \t    "+ep.getLaevePo().getOverTime()+" \t    "+ep.getLaevePo().getStartTime()+" \t    "+ep.getMyWorkInfoPo().getMyPosition().getName()+" \t    "+ep.getMyWorkInfoPo().getMyDepartment().getName()+"\t    "+ep.getLaevePo().getReason());
		}

	}
}