Mybatis的xml中,模糊查询like在MySQL和SQLServer中的语法不同,注意!!!’ 1.MySQL的语法 <select id="listSkuPrice" resultMap="walmartSkuMap"> select sku, price, create_date, create_by, last_update_date, last_update_by from twalmart_sku_price where 1=1 and sku like concat('%',#{name},'%') </select> 2.SQLServer的语法 ...