employeemanager.java

基于J2EE的网络物流系统 用户操作： 1． 录入出库商品信息 2． 查询出库单信息 3． 录入入库商品信息 4． 查询入库单信息 5． 查询商品位置信息 6． 查询商品信息 7． 查

package com.logistic.business;

import java.sql.Statement;
import java.sql.ResultSet;
import com.logistic.data.DataConnect;
import com.logistic.model.EmployeeInfo;
import com.logistic.dao.*;
import java.util.Vector;
import com.logistic.business.PageAble;

public class EmployeeManager implements IEmployeeDAO{


	DataConnect dc=new DataConnect();
	Statement   stat=null;
	ResultSet   rs=null;
	
	public int AddEmployee(String employeeid,String employeename,String employeesex,int employeeage,String employeeidencard,String employeebirthdate,String employeediploma,String employeejoindate,String employeeadd,String employeephone,String employeemobile,String departmentid,String jobsid){
		
		int flag=-10;
		try{
			
			String id=employeeid;
			String name=employeename;
			String sex=employeesex;
			int    age=employeeage;
			String idencard=employeeidencard;
			String birthdate=employeebirthdate;
			String diploma=employeediploma;
			String joindate=employeejoindate;
			String address=employeeadd;
			String phone=employeephone;
			String mobile=employeemobile;
			String deparid=departmentid;
			String jobid=jobsid;
			
			System.out.print("EmployeeaManager");
			System.out.print(name);
	    	String	sqls="insert into employeeinfotable(EmployeeId,EmployeeName,EmployeeSex,EmployeeAge,EmployeeIdenCard,EmployeeBirthDate,EmployeeDiploma,EmployeeJoinDate,EmployeeAdd,EmployeePhone,EmployeeMobile,DepartmentId,JobsId)values" +
	    			"('"+id+"','"+name+"','"+sex+"','"+age+"','"+idencard+"','"+birthdate+"','"+diploma+"','"+joindate+"','"+address+"','"+phone+"','"+mobile+"','"+deparid+"','"+jobid+"')";
		    flag=0;
	    	flag=dc.updata(sqls);
			if(flag>0){
				System.out.print("员工数据插入成功!");
			}else{
				
				System.out.print("员工数据插入失败!");
			}
			
		 }catch(Exception ex){
			 flag=-1;
			 ex.printStackTrace();
		   }finally{dc.close();}
		 return flag;
	   }
		
	public Vector EmployeeSearch(String strsql,int page){
		
		Vector items=new Vector();
		
		try{
			
			  stat=dc.getStmtread();
			  rs=stat.executeQuery(strsql);
			  
		  if(rs.next()){	  
			  PageAble pgb=new PageAble(rs);
			  pgb.setPagesize(5);
			  pgb.setCurrentpage(1);
			  pgb.gotoPage(page);
			 
			  rs.absolute(pgb.getRowscount());
			  int i=0;
			  do{
				   items.add(new EmployeeInfo(rs.getString("EmployeeId"),rs.getString("EmployeeName"),rs.getString("EmployeeSex"),rs.getInt("EmployeeAge"),rs.getString("EmployeeIdenCard"),rs.getString("EmployeeBirthDate"),rs.getString("EmployeeDiploma"),rs.getString("EmployeeJoinDate"),rs.getString("EmployeeAdd"),rs.getString("EmployeePhone"),rs.getString("EmployeeMobile"),rs.getString("DepartmentId"),rs.getString("JobsId")));
			  }while(rs.next()&&i<pgb.getCurrentPageRowsCount());
			  
		  }else{
			  
			  System.out.println("职员信息为空!");
			  
		  }	  
			
		}catch(Exception ex){
			ex.printStackTrace();
		}finally{dc.close();}
		
		return items;
	}

	public int DelEmployee(String employeeid){
		
		String delemployee="delete from employeeinfotable where Employeeid="+employeeid;
		
		int flag=0;
		
		try{
			flag=dc.updata(delemployee);
			if(flag>0){
				System.out.println("职员数据删除成功，职员编号:"+employeeid);
			   }else{
				System.out.println("职员数据删除失败，职员编号:"+employeeid);
			         }
		}catch(Exception ex){
				ex.printStackTrace();
			}finally{dc.close();}
			
	    return flag;
		}
	
	public int ModifyEmployee(String employeeid,String employeename,String employeesex,int employeeage,String employeeidencard,String employeebirthdate,String employeediploma,String employeejoindate,String employeeadd,String employeephone,String employeemobile,String departmentid,String jobsid){
		
		int flag=-10;
		try{
			
			String id=employeeid;
			String name=employeename;
			String sex=employeesex;
			int    age=employeeage;
			String idencard=employeeidencard;
			String birthdate=employeebirthdate;
			String diploma=employeediploma;
			String joindate=employeejoindate;
			String address=employeeadd;
			String phone=employeephone;
			String mobile=employeemobile;
			String deparid=departmentid;
			String jobid=jobsid;
			String strsql="update employeeinfotable set EmployeeName='"+name+"',EmployeeSex='"+sex+"',EmployeeAge='"+age+"',EmployeeIdenCard='"+idencard+"',EmployeeBirthDate='"+birthdate+"',EmployeeDiploma='"+diploma+"',EmployeeJoinDate='"+joindate+"',EmployeeAdd='"+address+"',EmployeePhone='"+phone+"',EmployeeMobile='"+mobile+"',DepartmentId='"+deparid+"',JobsId='"+jobid+"' where EmployeeId="+id;
			
	    	flag=dc.updata(strsql);
			if(flag>0){
				System.out.print("编号="+id+"的员工信息更新成功!");
			}else{
				
				System.out.print("编号="+id+"的员工信息更新失败!");
			}
			
		 }catch(Exception ex){flag=-1;ex.printStackTrace();}finally{dc.close();}
	return flag;	   
	}

	public EmployeeInfo EmployeeSearchById(String employeeid){
		
		String strsql="select * from employeeinfotable where EmployeeId="+employeeid;
		EmployeeInfo ei=new EmployeeInfo();
		try{
			stat=dc.getStmtread();
			rs  =stat.executeQuery(strsql);
			while(rs.next()){
				ei.setEmployeeId(rs.getString("EmployeeId"));
				ei.setEmployeeName(rs.getString("EmployeeName"));
				ei.setEmployeeSex(rs.getString("EmployeeSex"));
				ei.setEmployeeAge(rs.getInt("EmployeeAge"));
				ei.setEmployeeIdenCard(rs.getString("EmployeeIdenCard"));
				ei.setEmployeeBirthDate(rs.getString("EmployeeBirthDate"));
				ei.setEmployeeDiploma(rs.getString("EmployeeDiploma"));
				ei.setEmployeeJoinDate(rs.getString("EmployeeJoinDate"));
				ei.setEmployeeAdd(rs.getString("EmployeeAdd"));
				ei.setEmployeePhone(rs.getString("EmployeePhone"));
				ei.setEmployeeMobile(rs.getString("EmployeeMobile"));
				ei.setDepartmentId(rs.getString("DepartmentId"));
				ei.setJobsId(rs.getString("JobsId"));
			}
		}catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
	return ei;	
	}
}