Adding Events to the Calendar
You will now enhance the Calendar Application to display events for a particular day. This can be achieved by hyperlinking the days displayed in the monthly calendar. When the user clicks on any of the links, a window is opened, displaying the events for the day.
The information about the events is stored in the Events table. You can enter the information in the table using simple SQL INSERT statements as shown in Listing 6.4.
Listing 6.4. PopulateCalendar.sql: Inserting Events into the Events Table
CONNECT TO AUCTION; INSERT INTO EVENTS ( EVENT_ID, NAME, DESCRIPTION, START_DATE) VALUES ('1', 'Anniversary Sale', 'Our first Anniversary auctions...special dutch ' auctions', '2000-05-05-00.00.00.000000'), ('2', ... |
Get Java Server Pages from scratch now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
