PreparedStatement 中 like 的用法 

1 String deptName="人力资源部";
2 String sql = "select title, begintime, endtime, columnname from p_web where p_web_extendfield2 like ? order by begintime desc";
3 ps = conn.prepareStatement(sql);
4 String str ="%"+deptName+"%";
5 ps.setString(1, str);
6 rs = ps.executeQuery();

 

posted @ 2012-11-23 14:19  雨心竹  阅读(312)  评论(0)    收藏  举报