public static ArrayList<Bean> viewStudents() throws SQLException {
		ArrayList<Bean> list=new ArrayList<Bean>();
		Bean bean=null;
		try{ 
			String query="select count(schoolid),schoolid from awardstudent group by schoolid ";
			con=DBConnection.getConnection();
			pt=con.prepareStatement(query);
			System.out.println(query);


			rs=pt.executeQuery();

			while(rs.next())
			{
				if(rs.getInt(1)>=3){
					bean=new Bean();
					String a=rs.getString(2);
					bean.setSchoolid(a);
					list.add(bean);
				}

			}

		}
		catch(Exception e){

		}
		finally
		{
			con.close();
			//	pt.close();
		}
		return list;
	}