1.问题描述见图
2.1代码示例--->模糊查询接口编写
/**
* 模糊查询
*
* @param status
* @param brandName
* @param companyName
* @return
*/
List<Brand> SelectAll(@Param("status") int status, @Param("brandName") String brandName, @Param("companyName") String companyName);
2.2代码示例--->mapper映射文件 编写
<select id="SelectAll" resultMap="brandmap">
select * from tb_brand where status = #{status}
AND brand_name LIKE concat('%',#{brandName},'%')
AND company_name LIKE concat('%',#{companyName},'%')
</select>
2.3代码示例--->测试类编写
@Test
public void SelectAll() {
SqlSession sqlSession = MyBatisUtils.getsqlSessionFactory();
BrandMapper mapper = sqlSession.getMapper(BrandMapper.class);
List<Brand> list = mapper.SelectAll(1, "华为", "华为");
System.out.println(list);
sqlSession.close();
}
3.运行结果:sql执行正常,但是控制台显示无数据
4.问题解决方法:修改JDBC配置文件连接数据库的编码集
4.1原配置文件
4.2最新解决后的配置文件
driver=com.mysql.jdbc.Driver
url=jdbc:mysql://192.168.23.129:3307/mybatis?useSSL=true&useUnicode=true&characterEncoding=UTF-8
username=root
password=9987