can u help me in Jsp Project for Alert Messaging System.....

[attachment=10754]
Private Messaging System
In this tutorial you will learn on how to write a simple Private Messaging System for an existing userlogin script. I won't tell you how to write a login system, there are several good tutorials out there.
In this tutorial you will learn on how to write a simple Private Messaging System for an existing userlogin script. I won't tell you how to write a login system, there are several good tutorials out there.
First we need to create the mysql database, I want to make it as simple as possible, so everybody can use this. That's why I only use one database, for more complex systems you should't use only one table for everything
Enable Private Messaging
Before any members can use the Private Messaging System – regardless of their permissions – it must first be enabled, or turned on. Once active, only those in user groups with a permission set allowing the use of private messaging will be able to access the system.
Email Notifications
If you are allowing the use of Private Messaging you may enable sending of notification to be sent to members when a message arrives in their Inbox. This is a global setting. If enabled, users may choose to enable or disable emails for themselves in their profile.
Maximum Inbox Size
Maximum Inbox size is based on the number of messages stored, regardless of their individual size. If you set this option to zero no limitation is imposed on the size of members Inboxes. However, you may also set a maximum limit. In reality the maximum limit imposed is spread over both a members Inbox and Sentbox. When the limit is reached (adding both boxes together), the member will still be allowed to receive Private Messages but will no longer be allowed to send any until they have removed some old messages to below their maximum limit
Private Messages Auto Removal
In this admin panel, you can set it up such that PMs in user’s Inbox and Outbox will automatically be removed after a period of time. When you enable the auto removal option, the period of time is specified in days in the input box. A warning message will be displayed to users in their Inbox so they are aware of the auto removal.
Private Messaging Addressing Options
In this admin panel, you can set some options for how users can address PMs.
You can limit the number of PM recipients a user may send a PM to. If you don’t want to limit, enter 0.
You can also allow or disallow the use of the CC (carbon copy) and BCC (blind carbon copy) selectors for PM addressees.
You can also optionally only allow sending of PMs from one member to another member via the SEND PM page link in a post. If this option is selected, users will not be able to assign addresses from within the compose PM panel. Users will not be able to PM members from their buddy list either. The PM system becomes a person to person communication system using the SEND PM page link in posts.
you should use a database, one way of setting it out would be to have 2 tables for each user. 1 for incoming messages, one for outgoing.
The incoming table's columns could be
- subject
- sender
- date sent
- status (read unread or replied)
- message content
The outgoings table's columns could be
- subject
- user message is to
- date received
- read, unread or reply received
- message content
Or you could merge the two, and have columns like these:
- sender
- receiving user
- subject
- date sent
- read, unread or replied
- message content
- message type (sent or received)