<!-- selectAll操作

   resultType="map"表示返回的是一个map对象 -->

    <select id="selectAll" resultType="map">

        select * from tb_user

    </select>

/**

 * fayuan.com Inc.

 * Copyright (c) 2017-2018 All Rights Reserved.

 */

package com.fayuan.test;

import com.fayuan.factory.SqlSessionFactoryClass;

import org.apache.ibatis.session.SqlSession;

import java.util.List;

import java.util.Map;

/**

 * 测试ResultMaps功能

 *

 * @author fayuan.fzw

 * @version $Id: SelectMapTest.java, v 0.1 2018年02月25日 下午11:54 fayuan.fzw Exp $

 */

public class SelectMapTest {

    public static void main(String[] args) {

        SqlSession sqlSession = SqlSessionFactoryClass.getSqlSession();

        List<Map<String, Object>> list = sqlSession.selectList("com.fayuan.mapper.UserMapper.selectAll");

        for (Map<String, Object> row : list) {

            System.out.println(row);

        }

        sqlSession.close();

    }

}

DEBUG [main] - ==>  Preparing: select * from tb_user

DEBUG [main] - ==> Parameters:

DEBUG [main] - <==      Total: 6

{sex=?, name=fayuan, id=2, age=24}

{sex=?, name=fayuan, id=3, age=24}

{sex=?, name=fayuan, id=4, age=24}

{sex=?, name=fayuan, id=5, age=24}

{sex=?, name=fayuan, id=6, age=24}

{sex=?, name=fayuan, id=7, age=24}