WannaCry is just the start. Read how Liquid Web is protecting itself and its customers against new threats.
Solved
Replacing HTML parameters with Java
Posted on 2011-03-06
Hi,
As a part of our department requirements, we need to send out HTML emails that are predefined.
These templates are stored in a table.
Please consider the below case
<HTML>
<TR>
<TD>
#NAME#
</TD>
</TR>
</HTML>
Value for the tag #NAME# needs to be picked up from the database and the HTML template populated accordingly.
Could you please advise, on how this can be achieved with Java ? Any sample code would be highly appreciated.
I have the code ready to send out emails. Only worry is to populate the HTML templates with the values form the database.
Regards
As a part of our department requirements, we need to send out HTML emails that are predefined.
These templates are stored in a table.
Please consider the below case
<HTML>
<TR>
<TD>
#NAME#
</TD>
</TR>
</HTML>
Value for the tag #NAME# needs to be picked up from the database and the HTML template populated accordingly.
Could you please advise, on how this can be achieved with Java ? Any sample code would be highly appreciated.
I have the code ready to send out emails. Only worry is to populate the HTML templates with the values form the database.
Regards
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3-
2
- +2
8 Comments
The Apache Velocity could help you best for this kind of task. For details, check this:
http://velocity.apache.org/engine/devel/user-guide.html
http://velocity.apache.org/engine/devel/user-guide.html
You can use JSTL to achieve this .....
you set the value in java and get the values in Java like
request.setParameter("name
in JSP
<HTML>
<TR>
<TD>
${name}
</TD>
</TR>
</HTML>
you set the value in java and get the values in Java like
request.setParameter("name
in JSP
<HTML>
<TR>
<TD>
${name}
</TD>
</TR>
</HTML>
Active 7 days ago
Do you have code to get Name?
http://www.exampledepot.com/egs/java.sql/connectoracle.html
get name value in code and send using mail code.
http://www.exampledepot.com/egs/java.sql/connectoracle.html
get name value in code and send using mail code.
Hi All,
The example I provided was just a sample. In our case the HTML templates are quite large. These are infact some newsletters. that we need to send out to customers periodically.
The java code needs to call the templates(stored as a column in a database table) and then needs to replace the tags with the appropriate value (again picked up from different tables). Then the HTML needs to be emailed.
Regards
The example I provided was just a sample. In our case the HTML templates are quite large. These are infact some newsletters. that we need to send out to customers periodically.
The java code needs to call the templates(stored as a column in a database table) and then needs to replace the tags with the appropriate value (again picked up from different tables). Then the HTML needs to be emailed.
Regards
Active today
Then what you need to do in Java is read in the text from the file which has the email HTML text.
Get the replacement values from the database.
Replace the "#name#" text strings in the HTML email text with the values from the database.
Which parts do you not know how to do in Java?
Get the replacement values from the database.
Replace the "#name#" text strings in the HTML email text with the values from the database.
Which parts do you not know how to do in Java?
Thanks mrcoffee365.
You have provided me a simple solution that will serve my purpose.
I can do the coding for that. Now once I replace all the tags with the values from the database, how can I provide the output HTML to the users ?
Thanks and regards
You have provided me a simple solution that will serve my purpose.
I can do the coding for that. Now once I replace all the tags with the values from the database, how can I provide the output HTML to the users ?
Thanks and regards
Active today
You can send mail using JavaMail. You'll need the list of user email addresses and it would be best to send from a legitimate mail server, probably your department server.
You can get javamail from
http://www.oracle.com/technetwork/java/javamail/index.html
You can get javamail from
http://www.oracle.com/technetwork/java/javamail/index.html
Featured Post
Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Use these top 10 tips to master the art of email signature design. Create an email signature design that will easily wow recipients, promote your brand and highlight your professionalism.
Finding original email is quite difficult due to their duplicates. From this article, you will come to know why multiple duplicates of same emails appear and how to delete duplicate emails from Outlook securely and instantly while vital emails remai…
The viewer will receive an overview of the basics of CSS showing inline styles.
In the head tags set up your style tags:
(CODE)
Reference the nav tag and set your properties.: (CODE)
Set the reference for the UL element and styles for it to ensu…
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.
Suggested Courses
Course of the Month8 days, 18 hours left to enroll
734 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.