Java Servlet Code

[sreekandank]

Hi...
I am doing one online web application. In this application I want to produce the dynamic alert message for every user registration. I mean to send the alert message to the admin whenever the database value is updated with the new user registration. So I want to know whether it is possible or not?. Kindly help on my project. Thanks in advance.

[r035198x]

Are you doing the alerting through an email message?
You can use the JavaMail API to send out the email.

[neeraj0708]

you can check out with the triggers.

http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=%2Fsqlp%2Frbafysqltrig.htm

[sreekandank]

I don't want to send the email alert, instead just I want to provide the database updates on my web page. So kindly anyone help me this.

[r035198x]

How are the database updates done?
What technologies are you using? If you are using JSF 2 you get observer/observable support built in.

[sreekandank]

I am using Java Servlet and MSAccess

[r035198x]

But you are using JSPs for the view right?
You'll need your view to be autorefreshing for the changes to update on the page.

[sreekandank]

Yes. You are right. I want to display the updated values in my web page from the database table. Kindly help me on this.

[r035198x]

If you use JSF you can use AJAX to auto update specific components.
If you are using plain JSP then you can use the meta tag

META HTTP-EQUIV="Refresh" CONTENT="5;

to auto refresh the JSP page.
You should really consider using JSF 2 or newer for any web applications these days.