Just wondering why EJBs are much preferred to JDBC? Can you give an example?
Roland
You can use "like" in a prepared statement; as I recall, all you'd need is
to make sure the string you're setting has the wildcards. To wit:
PreparedStatement ps=connection.createPreparedStatement(
"select * from products where name like ?");
ps.setString(1, "%"+searchName+"%");
I've not tested that code, and I don't usually use JDBC directly any more
(EJBs much preferred) so you may have to tweak some.
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
