String sql = "SELECT count(*) from topic where sid = ? and publishTime like ?";
System.out.println(sid+"\t"+date);
//设置参数
String newString = "%"+date+"%";
System.out.println(newString);
Object[] objects = {sid,newString};
需要对like后面的整条语句都作为一个参数进行传参,否则的话会出现数据库传参错误。