public List constructList(int aid) {	
		con2 = DBConnection.getConnection();
		try {
			if (!con2.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_record where aid = " + aid + " order by year limit 0, 100;"; 
		List<AthleteRecord> lstList = new ArrayList(); 
		try {
			pd = con2.prepareStatement(sql);
			rs = pd.executeQuery(); 
			while (rs.next()) { 
				
				AthleteRecord record = new AthleteRecord();  
				record.setRid(rs.getInt(1));
				record.setAid(rs.getInt(2));
			    record.setAthName(rs.getString(3));
			    record.setYear(rs.getInt(4));
			    record.setGameType(rs.getString(5));
			    record.setAge(rs.getInt(6));
			    record.setSport(rs.getString(7));
			    record.setEvent(rs.getString(8));
			    record.setCountry(rs.getString(9));
			    record.setRank(rs.getString(10));
			    record.setMedal(rs.getString(11));
				
				lstList.add(record);
				System.out.println(rs.getString(11));
			}
			
			System.out.println("HAHAHAHAH");
			
			System.out.println(lstList.size());
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			try {
				if (pd != null) {
					rs.close();
					pd.close();
					con2.close();
				}
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
		return lstList; 
	}