EventReminder.Com

EventReminder.Com allows users to register events and get notified about the events through mail when the event is about to occur.

It provides all the common operations related to users such as registration, login, change password and forgot password.

Architecture Of the Project

This project uses JSF to build the interface. Managed Beans talk to DAO (Data Access Objects), which talk to database using JDBC.

So overall architecure is - JSF Form -> Managed Beans -> DAO -> JDBC -> Oracle Database.

It also uses a filter (Intercepting Filter design pattern) to ensure only authenticated users access secured pages.

It uses JQuery to implement AJAX to check whether username is present at the time of registration. As soon as user comes out of username field, JQuery is used to make AJAX request to check the validity of username.

Products used in this project

Steps to download and deploy this project

  1. Download eventreminder.rar. The .rar file contains the entire source code for the project. Unzip the file into C:\ so that c:\eventreminder folder is create with all the components of the project.
  2. Open the project using File -> Open Project option in NetBeans 6.8.
  3. Go to properties of the project using popup menu. Select libraries node and delete existing libraries using  Remove button. Then add - mail.jar (for javamail) and Oracle - ojdbc14.jar. You have to add these .jar files to the project using Add Jar/Folder button.
  4. Add JSF 1.2 libraries using Add Library button
  5. .
  6. Create er account with password er in Oracle10g Express Edition. This must be done after you log in as SYSTEM user.
  7. Grant required provileges to ER account as shown in the script below.
  8. The following is the script to create user and required schema objects.
    create user er identified by er;
    grant all privileges to er;
    
    connect er/er
    
    create table users
    ( username  varchar(10) primary key,
      password  varchar2(10) not null,
      email     varchar2(50)  unique
    );
    
    create table events
    (  eventid  	nuumber(5) primary key,
       username     varchar2(10) references users(username),
       eventdesc 	varchar2(100),
       eventdate    date,
       informbefore number(3),
       eventtype    char(1)  check( eventtype in ('r','o'))
    );
    
    create sequence eventid_sequence start with 1 increment by 1 nocache;
    
  9. Create an account in CMail Server (Download mail server from youngzsoft.net and configure Outlook express to add the mail account created in mail server.
  10. At the time of registering user in the project using register.jsp, use this email address for user so that you can test forgot password feature using this email address.
  11. Run this project - you must see login.jsp page.

EventReminderAdmin  Application

This is a Java application that reads data from EVENTS and USERS tables and sends reminders to users regarding the events.
  1. Download eventreminderadmin application.
  2. Unzip and open the project in NetBeans 6.8.
  3. Add mail.jar and ojdbc14.jar to the project using Add Jar/Folder option.
  4. Run SendReminders.java to send reminders to users regarding events. Make sure mail server and oracle database are available at the time of running this application.