public static void insertAlerts(EventsBean event) {
		PreparedStatement pst = null;  
		Connection conn=null;
		String str = "There is an event "+event.getEventName() +" added for category ";
		try {  
			conn=ConnectionPool.getConnectionFromPool();
			pst = conn  
					.prepareStatement("INSERT INTO STUDENT_ALERTS (PERSON_ID, ALERT_DESCRIPTION, VIEWED) "
							+ " SELECT DISTINCT id, CONCAT(? ,c.category_name) alert_description, 'N'"
							+ " FROM person p, category c, student_category_mapping sc"
							+ " WHERE p.id=sc.s_id"
							+ " AND c.categoryId=sc.c_id"
							+ " AND c.categoryId=?");  
			pst.setString(1, str);  
			pst.setInt(2, event.getCategoryId());

			pst.execute();  
		}catch (Exception e) {  
			System.out.println(e);  
		} finally {  
			if(conn!=null){
				ConnectionPool.addConnectionBackToPool(conn);
			}
			if (pst != null) {  
				try {  
					pst.close();  
				} catch (SQLException e) {  
					e.printStackTrace();  
				}  
			}  
		}
		
	}