[TOC] # 返回值是list resultType里面寫list里面的屬性就行 # 返回值是map ## 多個返回值,指定key xml ~~~ <select id="findAll" resultType="java.util.Map"> select * from user where username = #{username} or address = #{address} </select> ~~~ dao ~~~ //告訴mybatis 鍵是那個字段 @MapKey("id") Map<Integer, User> findAll(Map<String, Object> map); ~~~ 執行 ~~~ HashMap<String, Object> map = new HashMap<>(); map.put("username", "老王"); map.put("address", "北京"); Map<Integer, User> all = userDao.findAll(map); System.out.println(all); ~~~ 返回 `id=>javaBean` ## 單個返回值 **只適合查找一條記錄,不然會報錯** dao ~~~ Map<String, Object> findAll(Integer id); ~~~ xml 加limit是只要1條,不然返回多條會報錯 ~~~ <select id="findAll" resultType="java.util.Map"> select * from user where id = #{id} limit 1 </select> ~~~ 執行 ~~~ Map<String, Object> res = userDao.findAll(41); System.out.println(res); ~~~ 返回 ~~~ {birthday=2018-02-27 17:47:08.0, address=北京, sex=男, id=41, username=老王} ~~~