public Athlete findAthlete(int aid) {		
		con = DBConnection.getConnection();
		try {
			if (!con.isClosed()) {
				System.out.println("HAHAHAHAH");
			}
		} catch (SQLException e1) {
			// TODO Auto-generated catch block
			e1.printStackTrace();
		}
		
		PreparedStatement pd = null;
		ResultSet rs = null;
		String sql = "";
		
		sql = "select * from athletes_information where aid =" + aid + ";"; 
		Athlete ath = new Athlete(); 
		try {
			pd = con.prepareStatement(sql);
			rs = pd.executeQuery(); 
			int flag = 0;
			while (rs.next()) { 
				if (flag == 1) {
					break;
				}
				  
				ath.setAid(rs.getInt(1));
			    ath.setName(rs.getString(2));
			    if (rs.getString(3).equals(new String("M"))) {
			    	ath.setGender("Male");
			    } else if (rs.getString(3).equals(new String("F"))) {
			    	ath.setGender("Female");
			    } else {
			    	ath.setGender("");
			    }
			    ath.setBirthDtae(rs.getString(4));
			    ath.setBirthPlace(rs.getString(5));
			    ath.setCountry(rs.getString(6));
			    String sport = rs.getString(7);	     
			    ath.setSport(rs.getString(7));
			    ath.setRecord(constructList(aid));
			}
			
			System.out.println("HAHAHAHAH");			
			System.out.println(ath.getAid());
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			try {
				if (pd != null) {
					rs.close();
					pd.close();
					con.close();
				}
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
		return ath; 
	}