Java开发网 - 求援：PreparedStatement

Topic: 求援：PreparedStatement

1.求援：PreparedStatement	Copy to clipboard
Posted by: guoqing_w Posted on: 2005-02-28 21:44 使用PreparedStatement构造一个以商品名为条伯的SQL语句，例如： SELECT 。。。。。。FROM Product WHERE ProductName=? 但是想在商品名的问号前后加%，应该怎么写？？？？

2.Re:求援：PreparedStatement [Re: guoqing_w]	Copy to clipboard
Posted by: safe Posted on: 2005-03-01 02:00 PreparedStatement pstmt = con.prepareStatement("... ProductName = ?"); pstmt.setString(1, "%"+keyword+"%");

3.Re:求援：PreparedStatement [Re: guoqing_w]	Copy to clipboard
Posted by: liuyxit Posted on: 2005-03-04 15:11 PreparedStatement pstmt = con.prepareStatement("...OriductName like ?"); pstmt.setString(1,"%"+keyword+"%"); 注：对应的DBMS要支持LIKE。