SQL injection and HTML

[Avi Gafa]

Hi All,
I have a text box(on a jsp page) which should enable a free txt input including an HTML tags.
Some background:
In my customer page, there is an empty <div> that shoud be filled dinamiclly by calling to my servlet.
my servlet should return a text that can be including an HTML tags and this text will be emmbeded in the div and will be formatted as a regular HTML.
in order to retrive this text, I'm giving my customer a text box where he can put his free text(again, including HTML tags) and I store it in the DB.
my problem is, how to give my customer the ability to put his free text with the HTML tags in the text box and in the DB and to avoid security issuse like SQL injection.

Thanks,
Avi

[Jeanne Boyarsky]

Avi,
If you use a PreparedStatement to update the database, it will protect you from SQL injection. For example:

insert mytable(bigHunkOfHtml) values ( ? )

This will automatically escape any of the HTML inside the "?".