【mybatis】06 -查询-条件查询

• 条件查询：用户数据某几项信息，通过这些信息模糊查询用户需要的数据

1. 编写条件查询的sql

    <!--
    条件查询：status使用等值链接，其他使用模糊查询，字段要用对象属性名避免麻烦。
-->
       <select id="selectByCondition" resultMap="brandResultMap">
         select *
         from tb_brand
         where status = #{status}
           and company_name like #{companyName}
           and brand_name like #{brandName}
     </select>

2. 编写接口

  List<Brand> selectByCondition(Map map);

3. 测试类

 @Test
    public void testSelectCondition() throws IOException {
        //条件查询
        //1.获取session工厂
        String resource = "mybatis-config";
        InputStream inputStream = Resources.getResourceAsStream(resource);
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        //2.获取session
        SqlSession sqlSession = sqlSessionFactory.openSession();
        //3.获取mapper
        BrandMapper mapper = sqlSession.getMapper(BrandMapper.class);
        //4.执行sql
        int status = 1;
        String companyName = "华为";
        String brandName = "华为";
        //处理参数
        companyName ="%" + companyName +"%";
        brandName = "%" + brandName + "%";

        HashMap hashMap = new HashMap();
        hashMap.put("status",status);
        hashMap.put("companyName",companyName);
        hashMap.put("brandName",brandName);
        List<Brand> brands = mapper.selectByCondition(hashMap);
        System.out.println(brands);
        //5.关闭资源
        sqlSession.close();
    }

4. 运行失败

解决数据库和idea之间的编码不一致导致无法输出或报错的问题