用PreparedStatement怎么就行like的模糊查询啊,用Statement就可以 我想大概是这样,当用pstmt.setString(1, name);给?参数负值时,这个方法会在?的位置两边加上一对单引号。SQL语句也就成了这样 a.au_lname like '%'XXXX'%'".我是猜的哦,不一定对。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 用system.out输出这个sql,在数据库直接执行,可以通过吗? 查一下.. 应该这样写 try { pstmt = conn.prepareStatement(sql, 1005, 1007); pstmt.setString(1, "%"+name+"%"); rs = pstmt.executeQuery();.........}这样就OK啦,试试吧 public boolean getTitles(String name){ String sql = "SELECT a.au_lname,t.title "+ "FROM titles t,titleauthor ta,authors a "+ "WHERE a.au_id=ta.au_id "+ "AND t.title_id=ta.title_id "+ "AND a.au_lname like ?"; try { pstmt = conn.prepareStatement(sql, 1005, 1007); pstmt.setString(1, "%"+name+"%"); rs = pstmt.executeQuery(); } 两位大哥啊,你们这方法不行啊,我还是按照stmt那样写pstmt是可以的,就是不写setString()直接在sql中赋值,不过还是不爽啊,没用setString() String sql = "SELECT a.au_lname,t.title "+ "FROM titles t,titleauthor ta,authors a "+ "WHERE a.au_id=ta.au_id "+ "AND t.title_id=ta.title_id "+ "AND a.au_lname like '%"+name+"%'"; pstmt = conn.prepareStatement(sql, 1005, 1007); rs = pstmt.executeQuery(); Struts2.Jsp页面如果做时间判断. 请问有java开源的B2B网站吗?推荐下。最好有数据库的 java web项目思路求助 Struts2配置 struts2有哪些优点 谁知道怎么根据hql得到要查询的字段,条件等 eclipse下集成ssh2环境,求解 hibernatetemplate查询会造成sql注入吗 页面刷新delete 润乾报表发布后报表无法在IE中打开! struts关于页面链接跳转。。。 NHibernate加分布式,欢迎大家来提供建议!!
try {
pstmt = conn.prepareStatement(sql, 1005, 1007);
pstmt.setString(1, "%"+name+"%");
rs = pstmt.executeQuery();
.........}
这样就OK啦,试试吧
String sql = "SELECT a.au_lname,t.title "+
"FROM titles t,titleauthor ta,authors a "+
"WHERE a.au_id=ta.au_id "+
"AND t.title_id=ta.title_id "+
"AND a.au_lname like ?";
try {
pstmt = conn.prepareStatement(sql, 1005, 1007);
pstmt.setString(1, "%"+name+"%");
rs = pstmt.executeQuery();
}
String sql = "SELECT a.au_lname,t.title "+
"FROM titles t,titleauthor ta,authors a "+
"WHERE a.au_id=ta.au_id "+
"AND t.title_id=ta.title_id "+
"AND a.au_lname like '%"+name+"%'";
pstmt = conn.prepareStatement(sql, 1005, 1007);
rs = pstmt.executeQuery();