为什么编码能通过却输出空列表
//接收用户请求参数
int di = 1;
String companyName = "呵呵";
String brandName = "哈哈";
当我们采用模糊查询
<select id="selectByCondition" resultMap="hehe">
select *
from tb_brand
where
id = #{id}
and company_name like #{companyName}
and brand_name like #{brandName}
</select>
如果我们传入的参数个数不完整,比如只传入id不传入,不传入companyName和brandName
则mysql接收到的select语句是
select*
from tb_brand
where
id=1
and company_name like ?
and brand_name like ?;
mysql不会报错而是返回Empty set
所以出现返回空列表,一般是传入参数不对或
idea输出没有改为utf-8导致输出参数乱码
select无法找到