如图所示
sql拼接，多条件模糊查询
dao层代码
public List<Product> findBy(String name, String keywords) throws SQLException {QueryRunner qr = new QueryRunner(DataSourceUtil.getDataSource());String sql="select * from product where 1=1 ";//存放参数ArrayList<String> params=new ArrayList<>();//判断参数是否为空 拼接sqlif(name!=null && name.trim().length()>0){sql+=(" and pname like ? ");params.add("%"+name+"%");}if(keywords!=null && keywords.trim().length()>0){sql+=(" and pdesc like ? ");params.add("%"+keywords+"%");}return qr.query(sql, new BeanListHandler<>(Product.class), params.toArray());}
如果觉得《拼接sql语句 实现多条件模糊查询》对你有帮助，请点赞、收藏，并留下你的观点哦！
