public static String[] searchEmployee(Integer ID) {
            Database db = dbconnect();
            String [] Array = null;
	try {
		String query = ("SELECT * FROM employee WHERE EID = ? AND bDeleted = 0");
                db.prepare(query);
                db.bind_param(1, ID.toString());
		ResultSet rs = db.executeQuery();    
                while(rs.next()) {
                   Array = new String[]{rs.getString(rs.getMetaData().getColumnName(2)), 
                                        rs.getString(rs.getMetaData().getColumnName(3)),
                                        rs.getString(rs.getMetaData().getColumnName(4)),
                                        rs.getString(rs.getMetaData().getColumnName(5)),
                                        rs.getString(rs.getMetaData().getColumnName(6))};
		}
	        db.close();      

            } catch (SQLException e) {
                Error_Frame.Error(e.toString());
             } 
         return Array;
         }