Mybatis框架--封装Map和List返回结果

select记录封装Map

1.编写映射文件：

<select id="getEmpByMap" resultType="Bean.Employee">
        select * from tbl_employee where id=#{id} and last_name=#{lastName}
</select>

2.dao层接口方法：

public interface EmployeeMapper {

    public Employee getEmpByMap(Map<String,Object> map);
}

3.注册到全局配置文件

4.测试类：

@Test
    public void test04() throws IOException {
        try {
            InputStream resource = Resources.getResourceAsStream("mybatis-config.xml");
            SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resource);
            SqlSession sqlSession = sqlSessionFactory.openSession();
            EmployeeMapper mapper = sqlSession.getMapper(EmployeeMapper.class);
            
            Map<String,Object> map = new HashMap<String,Object>();
            map.put("id",1);
            map.put("lastName","GINO");
            Employee employee = mapper.getEmpByMap(map);
            System.out.println(employee);

        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}

运行结果：

List条件查询

1.编写映射文件：

<select id="getEmpsByLastNameLike" resultType="Bean.Employee">
        select * from tbl_employee where last_name like #{lastNmae}
</select>

2.dao层接口方法：

public interface EmployeeMapper {
    public List<Employee> getEmpsByLastNameLike(String lastName);
}

3.注册到全局配置文件

4.测试类：
我们选择查询名字中含有 “e” 字符的员工信息

@Test
    public void test04() throws IOException {
        try {
            InputStream resource = Resources.getResourceAsStream("mybatis-config.xml");
            SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resource);
            SqlSession sqlSession = sqlSessionFactory.openSession();
            EmployeeMapper mapper = sqlSession.getMapper(EmployeeMapper.class);

            List<Employee> like = mapper.getEmpsByLastNameLike("%e%");
            for (Employee employee: like) {
                System.out.println(employee);
            }
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

运行结果：