I have a backend MySQL database which keeps track of the number of invalid accesses to a file on a web server(I am new to the use of cron jobs though)I want an email to be sent to the file owner when the number of accesses exceed a certain number.Could anyone please suggest how this could be done using JSP?
Thanks in advance.
Freemarker is a library (jar). NetBeans (and all other IDEs) let you add jars to your classpath. You could also use a Freemarker plugin to make you editing easier. But that's independent of getting the jar itself.
I question whether you even need Freemarker. Unless your email is complicated, you might just concatenate strings to compose the email. It's a minor part of the problem - just for the formatting part.
As you said, I don't think I need FreeMarker at all, because my email isn't going to be complicated(just a fixed message to reset their password).However MySQL by itself cannot send the email I believe.There were suggestions on the net to make the trigger run an external script(written in PHP ) which does this.And there's this JavaMail API,which also comes to my mind.I am confused as to what to use now.Thank you.