public static int allocateSchools(String id[]) {
		String schoolid=id[0];
		System.out.println("in DAO school award");
		System.out.println(schoolid);
		String testid="",awardid="",awardname="";

		try{ 
			con=DBConnection.getConnection();
			System.out.println("in try");
			String query1="select count(schoolid) from awardschool where schoolid=?";
			pt=con.prepareStatement(query1);
			pt.setString(1, schoolid);
			rs=pt.executeQuery();
			rs.next();
			if(rs.getInt(1)==0){

				String query="select * from awardstudent where schoolid=?";

				pt=con.prepareStatement(query);
				pt.setString(1, schoolid);

				rs=pt.executeQuery();
				while(rs.next()){
					testid=rs.getString("testid");
					awardid=rs.getString("awardid");
					schoolid=rs.getString("schoolid");
					awardname=rs.getString("awardname");
					System.out.println(schoolid);
				}		
				Statement stmt=con.createStatement();
				query="insert into awardschool values('"+testid+"','"+awardid+"','"+schoolid+"','"+awardname+"')";
				System.out.println(query);
				stmt.executeQuery(query);
				con.commit();
				i=1;
			}
			else{
				System.out.println("in else");
				i=2;
			}

		}
		catch(Exception e){

		}
		finally
		{
			try {
				con.close();
				pt.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}

		}System.out.println(i);
		return i;


	}