Hi everyone

I'm completely new here. Let me introduce myself - My name's Dave and I'm a student studying Multimedia applications development at the Waterford Institute of Technology in Waterford, Ireland.

I'm currently involved in a college project where I have a JSP web application connecting to a MySQL database.

I'm currently doing some brainstorming on certain parts of the project and I'm using a number of different tools and technologies for different parts of the project. My requirements for JSP/MySQL is the following:

I have a database table called "alerts" with columns "alert ID", "alert status", and "alert owner e-mail".

This table is currently being populated with the following values from an external source (example)

Alert ID: 1
Alert Status: OK
Alert owner e-mail doesn't change.

I wish to enable the web application to e-mail an alert owner if the alert status changes from 'OK' to 'Issue'. Can this be done and can someone point me in the direction of some resources if so? I apreciate your ideas.