关于mysql模糊查询问题，急！急！急！

最近，小弟用到mysql模糊查询时碰到了一个难以解决的问题，在网上找了很多了资料，也没能解决，希望在这里碰到高手，帮小弟度过难关，小弟我感激涕零~~~
好的，看下面这段代码吧：
SQL code:

mysql> use mingxuan;
Database changed
mysql> select count(id) from product where ptype like '%联想%' and bid=(
-> select id from brand where bname='联想' and cid=(
-> select id from category where id=4
-> )
-> );
+-----------+
| count(id) |
+-----------+
| 2 |
+-----------+
1 row in set (0.00 sec)


在mysql里面可以用这个sql语句进行模糊查询，但是到了Java程序里面用con.prepareStatement(sql);问题就来了
代码如下：
Java code:

String sql = "select count(id) from product "
+ "where ptype like ? and bid=( "
+ "select id from brand where bname=? and cid=( "
+ "select id from category where id=?));";
con = DBUtil.getConnect();
try {
ps = con.prepareStatement(sql);
ps.setString(1, "%" + type + "%");
ps.setString(2, bname);
ps.setInt(3, cid);
rs = ps.executeQuery();
if (rs.next()) {