employeelist.java

来自「《Java课程设计案例精编（第二版）》-黄晓东-源代码-4450」· Java 代码 · 共 63 行

package records;
import accessDB.*;
import java.awt.*;
import java.sql.Date;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.*;
public class EmployeeList {
	private Vector EmployeeContainer = null;
	private TableData tableData = null;
	private Employee emp = null;
	
	
	private boolean fillEmployeeList() throws SQLException {
		this.tableData = new TableData();
		if( EmployeeContainer == null )
			EmployeeContainer = new Vector();		
		ResultSet rSet = this.tableData.getAllTableData(DBConstantVariable.EmployeeTable);
		
		while(rSet.next())
		{
			emp = new Employee();
			if( emp == null ){
				System.out.println("Memory Allocate Error!");
				System.exit(-1);
			}
			emp.setEmployee_ID( rSet.getInt("EMPLOYEE_ID") );
			emp.setFirstName( rSet.getString("FIRST_NAME") );
			emp.setLastName( rSet.getString("LAST_NAME") );
			emp.setEmail( rSet.getString("EMAIL") );
			emp.setPhone_Number( rSet.getString("PHONE_NUMBER") );
			emp.setHire_Date( rSet.getDate("HIRE_DATE").toString() );
			emp.setJob_ID( rSet.getString("JOB_ID"));
			emp.setSalary( rSet.getFloat("SALARY"));
			emp.setManager_ID( rSet.getInt("MANAGER_ID"));
			emp.setDepartment_ID( rSet.getString("DEPARTMENT_ID"));
			if( EmployeeContainer == null )
				EmployeeContainer = new Vector();
			EmployeeContainer.add( emp );
		};
		return true;
	}

	public Vector getEmployeeList(){
		try{
			if ( this.fillEmployeeList() == true )
				return this.EmployeeContainer;
			else 
				System.out.println( "No Data Found!");
			return null;
		}
		catch(SQLException ex){
			System.out.println( "Get DataTable Error!" + ex.getMessage());
			System.exit(-1);
		}
		catch(Exception ex){
			System.out.println(" UnHandle exception !" + ex.getMessage());
			System.exit(-1);
		}
		return null;
	}
}