Others have mentioned using Object/Relational mapping software. I would recommend this too. Personally, I'm using Hibernate which I like a lot. I think Hibernate uses PreparedStatements internally. Hibernate also has what it calls a "Criteria API" which you can use to build up queries programatically. I use this a lot when I have a Web form that has several fields and depending which fields are filled in it adds filter criteria to the query. Hibernate is one of the best new software packages that I've used. That and JSF of course! ;-)
Jon
----- Original Message ----- From: "Conway. Fintan (IT Solutions)" <[EMAIL PROTECTED]>
To: "MyFaces Discussion" <[email protected]>
Sent: Thursday, March 24, 2005 5:33 AM
Subject: SQL Injection attack
Hi all,
Is there anything in JSF (or in MyFaces) which can detect / filter out text entered into a text box which could inject and run SQL commands on the database?
Any thoughts on this matter would be appreciated,
Thanks,
Fintan
* ** *** ** * ** *** ** * ** *** ** *
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed.
Any views or opinions presented are solely those of the author, and do not necessarily
represent those of ESB.
If you have received this email in error please notify the sender.
Although ESB scans e-mail and attachments for viruses, it does not guarantee
that either are virus-free and accepts no liability for any damage sustained
as a result of viruses.
* ** *** ** * ** *** ** * ** *** ** *

