Java开发网 Java开发网
注册 | 登录 | 帮助 | 搜索 | 排行榜 | 发帖统计  

您没有登录

» Java开发网 » Database/JDBC/SQL/JDO/Hibernate  

按打印兼容模式打印这个话题 打印话题    把这个话题寄给朋友 寄给朋友    该主题的所有更新都将Email到你的邮箱 订阅主题
flat modethreaded modego to previous topicgo to next topicgo to back
作者 求援：PreparedStatement
guoqing_w





发贴: 19
积分: 0
于 2005-02-28 21:44 user profilesend a private message to usersearch all posts byselect and copy to clipboard. ie only, sorry for netscape users:-)add this post to my favorite list
使用PreparedStatement构造一个以商品名为条伯的SQL语句，例如：
SELECT 。。。。。。FROM Product WHERE ProductName=?
但是想在商品名的问号前后加%，应该怎么写？？？？


作者 Re:求援：PreparedStatement [Re:guoqing_w]
safe





发贴: 37
积分: 0
于 2005-03-01 02:00 user profilesend a private message to usersearch all posts byselect and copy to clipboard. ie only, sorry for netscape users:-)add this post to my favorite list
PreparedStatement pstmt = con.prepareStatement("... ProductName = ?");
pstmt.setString(1, "%"+keyword+"%");


作者 Re:求援：PreparedStatement [Re:guoqing_w]
liuyxit





发贴: 13
积分: 0
于 2005-03-04 15:11 user profilesend a private message to usersearch all posts byselect and copy to clipboard. ie only, sorry for netscape users:-)add this post to my favorite list
PreparedStatement pstmt = con.prepareStatement("...OriductName like ?");
pstmt.setString(1,"%"+keyword+"%");

注：对应的DBMS要支持LIKE。



flat modethreaded modego to previous topicgo to next topicgo to back
  已读帖子
  新的帖子
  被删除的帖子
Jump to the top of page

   Powered by Jute Powerful Forum® Version Jute 1.5.6 Ent
Copyright © 2002-2021 Cjsdn Team. All Righits Reserved. 闽ICP备05005120号-1
客服电话 18559299278    客服信箱 714923@qq.com    客服QQ 714923