public static void insertEvents (EventsBean event){
		PreparedStatement pst = null;  
		Connection conn=null;
		boolean result = false;
		try {  
			conn=ConnectionPool.getConnectionFromPool();
			pst = conn  
					.prepareStatement("INSERT INTO EVENTS (NAME, DESCRIPTION, EVENT_DATE, VENUE, TOTAL_SEATS, BOOKED_SEATS, TICKET_PRICE, CATEGORYID, DEPARTMENTID) "
							+ "VALUES (?,?,?,?,?,?,?,?,?)");  
			pst.setString(1, event.getEventName());  
			pst.setString(2, event.getDescription());
			pst.setTimestamp(3, new Timestamp(event.getEventDate().getTime()));
			pst.setString(4, event.getVenue());
			pst.setInt(5, event.getTotalNoOfSeats());
			pst.setInt(6, event.getBookedSeats());
			pst.setDouble(7, event.getTicketPrice());
			pst.setInt(8, event.getCategoryId());
			pst.setInt(9, event.getDepartmentId());

			result = pst.execute();  
			//insertAlerts(event);
		}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();  
				}  
			}  
		}
	}