SQL参数化查询报此错。

StringBuilder sb = new Stringbuilder("select * from XXX c");
 sql.append(" AND c.name LIKE ?");
 params.add("%"+ classesDTO.getName()+"%");

之前写成  c.name LIKE %?%  params.add(classesDTO.getName())导致出错。 【异常-java- java.lang.IllegalArgumentException: Parameter with that position [1] did not exist】 SQL参数化查询报此错。StringBuilder sb = new Stringbuilder(&quot;select * from XXX c&quot;); sql.append(&quot; AND c.name LIKE ?&quot;); params.add(&quot;%&quot;+ classesDTO.getName()+&quot;%&quot;);之前写成  c.name LIKE %?%  params.add(classesDTO.getN... 【异常-java- java.lang.IllegalArgumentException: Parameter with that position [1] did not exist】 org.springframework.beans.factory.NoSuchBeanDefinitionException: No qualifying bean of type 。a.a.a.: 你好 我在serviceimpl中写了 @Service("CommodityServicesImpl") 但就是显示上面这个报错 请问这是怎么回事呢 [code=java] package services.impl; import java.util.List; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import entity.CommodityInfo; import mapper.CommodityMapper; import services.CommodityServices; @Service("CommodityServicesImpl") public class CommodityServicesImpl implements CommodityServices { @Autowired private CommodityMapper commodityMapper; @Override public List<CommodityInfo> findAll() { // TODO Auto-generated method stub return commodityMapper.findAll(); @Override public int addInfo(CommodityInfo commodityInfo) { // TODO Auto-generated method stub return commodityMapper.addInfo(commodityInfo); @Override public int delInfo(int id) { // TODO Auto-generated method stub return commodityMapper.delInfo(id); [/code] Spring data jpa HQL @Query 自定义查询及更新删除 及 sql写法 文天大人: