报错:
Servlet.service() for servlet [dispatcherServlet] in context with path [/likelong] threw exception [Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.BindingException: Parameter 'b' not found. Available parameters are [list, param1]] with root cause
org.apache.ibatis.binding.BindingException: Parameter 'b' not found. Available parameters are [list, param1]
服务层代码部分结构:
List<TSkuPlu> productPage = TSkuPluMapper.selectMyPageByOracle(pageNum,num,queryWrapper);
Map map = baseMapper.findTest(productPage);
XML部分:
<insert id="findTest" parameterType="java.util.Map">
MERGE into TB_PRODUCT A
using
( select
#{item.plucode} plucode,
#{item.pluname} pluname
from TSKUPLU
) b
ON (
A.GOODS_ID=b.plucode
)
WHEN MATCHED THEN
UPDATE SET
A.NAME=b.pluname
WHEN NOT MATCHED THEN
INSERT (A.GOODS_ID)
VALUES (b.plucode)
</insert>