mapper sql 传参错误导致:
"SELECT NAME,image FROM tb_brand WHERE id IN (SELECT brand_id FROM tb_category_brand WHERE category_id IN (SELECT id FROM tb_category WHERE NAME=${name})) ORDER BY seq"
Cause: java.sql.SQLSyntaxErrorException: Unknown column
org.springframework.jdbc.BadSqlGrammarException:
### Error querying database. Cause: java.sql.SQLSyntaxErrorException: Unknown column '手机' in 'where clause'
### The error may exist in com/changgou/goods/dao/BrandMapper.java (best guess)
### The error may involve com.changgou.goods.dao.BrandMapper.findListByCategoryName-Inline
### The error occurred while setting parameters
### SQL: SELECT NAME,image FROM tb_brand WHERE id IN (SELECT brand_id FROM tb_category_brand WHERE category_id IN (SELECT id FROM tb_category WHERE NAME=手机)) ORDER BY seq
### Cause: java.sql.SQLSyntaxErrorException: Unknown column '手机' in 'where clause'
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Unknown column '手机' in 'where clause'
原因此处写成了${name}应该是#{name}