empbean.java

完整的JAVA工程

		}
		return s;
	}
	
	/**
	 * 根据职工编号查询职工基本信息
	 */
	public String[] empComSearch(String eid){
		
		Database DB = new Database();
		this.id = eid;
		String[] s = new String[9];
		sql = "select * from empcom where id = "+id+"";

		try{
			DB.OpenConn();
			rs = DB.executeQuery(sql);
			if(rs.next()){
				s[0] = rs.getString("id");
				s[1] = rs.getString("eid");
				s[2] = rs.getString("dname");
				s[3] = rs.getString("aname");
				s[4] = rs.getString("begtime");
				s[5] = rs.getString("endtime");
				s[6] = rs.getString("test");
				s[7] = rs.getString("officephone");
				s[8] = rs.getString("remark");
			}
			else
				s = null;
		}
		catch(Exception e){
		}
		finally {
			DB.closeStmt();
			DB.closeConn();
		}
		return s;
	}
	
	/**
	 *职工照片查询
	 */
	 public byte[] empPic(String eid){
	 	Database DB = new Database();
		this.eEid1 = eid;
		byte s[]=new byte[1];
		sql = "select photo from picture where eid = "+eEid1+"";

		try{
			DB.OpenConn();
			rs = DB.executeQuery(sql);
			if(rs.next()){
				s=rs.getBytes(1);
		    }
		}
		catch(Exception e){
		}
		finally {
			DB.closeStmt();
			DB.closeConn();
		}
		return s;
	}
	/**
	 * 职工信息综合查询(按照一个条件进行查询)
	 */
	public String[][] empAllSearch(String colname,String colvalue){
		this.colName = colname;
		this.colValue = colvalue;

		Database DB = new Database();
		String[][] sn = null;
		int row = 0;
		int i = 0;

		DB.toGBK(colvalue);
		
		if(colValue != null||colValue!=""){
			sql = "select * from empcom where "+colName+" = '"+colValue+"'";
		}
		try{
			DB.OpenConn();
			rs = DB.executeQuery(sql);

			if(rs.last()){
				row = rs.getRow();
			}
			
			if(row == 0){
				sn = null;
			}
			else{
				sn = new String[row][9];
				rs.first();
				rs.previous();
				while(rs.next()){
					sn[i][0] = rs.getString("id");
					sn[i][1] = rs.getString("eid");
					sn[i][2] = rs.getString("dname");
					sn[i][3] = rs.getString("aname");
					sn[i][4] = rs.getString("begtime");
					sn[i][5] = rs.getString("endtime");
					sn[i][6] = rs.getString("test");
					sn[i][7] = rs.getString("officephone");
					sn[i][8] = rs.getString("remark");
					i++;
				}
			}
		}
		catch(Exception e){
		}
		finally {
			DB.closeStmt();
			DB.closeConn();
		}
		return sn;
	}
	
	/**
	 * 职工信息综合查询(按照一个条件进行查询)
	 */
	public String[][] empTraSearch(String colname,String colvalue){
		this.colName = colname;
		this.colValue = colvalue;

		Database DB = new Database();
		String[][] sn = null;
		int row = 0;
		int i = 0;

		DB.toGBK(colvalue);
		
		if(colValue == null||colValue.equals("")){
			sql = "select * from employee";
		}
		else{
			sql = "select * from emptra where "+colName+" = '"+colValue+"'";
		}
		try{
			DB.OpenConn();
			rs = DB.executeQuery(sql);

			if(rs.last()){
				row = rs.getRow();
			}
			
			if(row == 0){
				sn = null;
			}
			else{
				sn = new String[row][7];
				rs.first();
				rs.previous();
				while(rs.next()){
					sn[i][0] = rs.getString("eid");
					sn[i][1] = rs.getString("tname");
					sn[i][2] = rs.getString("tcontent");
					sn[i][3] = rs.getString("begtime");
					sn[i][4] = rs.getString("endtime");
					sn[i][5] = rs.getString("test");
					sn[i][6] = rs.getString("remark");
					i++;
				}
			}
		}
		catch(Exception e){
		}
		finally {
			DB.closeStmt();
			DB.closeConn();
		}
		return sn;
	}
	/**
	 * 获得employee表中的所有职工编号eid
	 */
	public String[] getAllId(){
		String[] s = null;
		int row = 0;
		int i = 0;
		Database DB = new Database();
		sql = "select eid from employee";
		
		try{
			DB.OpenConn();
			rs = DB.executeQuery(sql);
			if(rs.last()){
				row = rs.getRow();
			}

			if(row == 0){
				s = null;
			}
			else{
				s = new String[row];
				rs.first();
				rs.previous();
				while(rs.next()){
					s[i] = rs.getString(1);
					i++;
				}
			}
		}
		catch(Exception e){
			System.out.println(e);
		}
		finally {
			DB.closeStmt();
			DB.closeConn();
		}
		return s;
	}
	
	/**
	 * 获得department表中的所有部门名称dname
	 */
	public String[] getAllDname(){
		String[] s = null;
		int row = 0;
		int i = 0;
		Database DB = new Database();
		sql = "select dname from department";
		
		try{
			DB.OpenConn();
			rs = DB.executeQuery(sql);
			if(rs.last()){
				row = rs.getRow();
			}

			if(row == 0){
				s = null;
			}
			else{
				s = new String[row];
				rs.first();
				rs.previous();
				while(rs.next()){
					s[i] = rs.getString(1);
					i++;
				}
			}
		}
		catch(Exception e){
			System.out.println(e);
		}
		finally {
			DB.closeStmt();
			DB.closeConn();
		}
		return s;
	}
	
	/**
	 * 获得appointment表中的所有职务名称aname
	 */
	public String[] getAllAname(){
		String[] s = null;
		int row = 0;
		int i = 0;
		Database DB = new Database();
		sql = "select aname from appointment";
		
		try{
			DB.OpenConn();
			rs = DB.executeQuery(sql);
			if(rs.last()){
				row = rs.getRow();
			}

			if(row == 0){
				s = null;
			}
			else{
				s = new String[row];
				rs.first();
				rs.previous();
				while(rs.next()){
					s[i] = rs.getString(1);
					i++;
				}
			}
		}
		catch(Exception e){
			System.out.println(e);
		}
		finally {
			DB.closeStmt();
			DB.closeConn();
		}
		return s;
	}
	
	/**
	 * 获得train表中的所有培训名称tname
	 */
	public String[] getAllTname(){
		String[] s = null;
		int row = 0;
		int i = 0;
		Database DB = new Database();
		sql = "select tname from train";
		
		try{
			DB.OpenConn();
			rs = DB.executeQuery(sql);
			if(rs.last()){
				row = rs.getRow();
			}

			if(row == 0){
				s = null;
			}
			else{
				s = new String[row];
				rs.first();
				rs.previous();
				while(rs.next()){
					s[i] = rs.getString(1);
					i++;
				}
			}
		}
		catch(Exception e){
			System.out.println(e);
		}
		finally {
			DB.closeStmt();
			DB.closeConn();
		}
		return s;
	}
}