String name = "xxx"; PreparedStatement ps = conn.prepareStatement(sql); ps.setString(1, "%" + name + "%");
楼上的方法我没有成功过。。 不知道为啥 我都是用这种方法。和楼上的差不多 String sen="select * from table where a like '%"+b+"%'"; PreparedStatement statement=conn.prepareStatement(sen); statement.executeQuery();
在百分号外面加上引号试试: ps.setString(1, "'%" + name + "%'");
String sen="select * from table where a like ?"; PreparedStatement statement=conn.prepareStatement(sen); statement.setString(1, "%" + b+ "%"); statement.executeQuery();
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(1, "%" + name + "%");
我都是用这种方法。和楼上的差不多
String sen="select * from table where a like '%"+b+"%'";
PreparedStatement statement=conn.prepareStatement(sen);
statement.executeQuery();
ps.setString(1, "'%" + name + "%'");
PreparedStatement statement=conn.prepareStatement(sen);
statement.setString(1, "%" + b+ "%");
statement.executeQuery();