1.xml文件
<select id="selectList" resultType="java.util.HashMap">
SELECT *FROM employee
</select>
2.dao层
public List<Map<String,Object>> selectList();
3.测试
public static void main(String[] args) throws IOException {
String resource = "mybatis-config.xml";
InputStream inputStream = Resources.getResourceAsStream(resource);
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
SqlSession session = sqlSessionFactory.openSession();
EmployeeMapper mapper = session.getMapper(EmployeeMapper.class);
List<Map<String,Object>> selectList = mapper.selectList();
for (Map<String,Object> map : selectList) {
for (Map.Entry<String, Object> m : map.entrySet()) {
System.out.print(m.getKey()+"--"+m.getValue());
}
}
}