public static ArrayList<SchoolBean> viewSchools(){

		Connection con=DBConnection.getConnection();
		
		ArrayList<SchoolBean> list=new ArrayList<SchoolBean>();
		if(con==null)
			return null;
		try {
			Statement pt=con.createStatement();
			ResultSet rs=pt.executeQuery("select * from school");
			//rs.next();
		while(rs.next()){
			
			SchoolBean sb=new SchoolBean();
				sb.setSchoolid(rs.getString(1));
				sb.setName(rs.getString(2));
				sb.setLocation(rs.getString(3));
				sb.setPhone(rs.getString(4));
				sb.setBoard(rs.getString(5));
				sb.setEmail(rs.getString(6));
				list.add(sb);
			}
			//con.commit();
			con.close();

		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		return list;
	}