select返回List

public interface EmployeeMapper {public List<Employee> getEmpsByLastNameLike(String lastName);} <!-- public List<Employee> getEmpsByLastNameLike(String lastName);--><!--resultType;如果返回的是一個集合，要寫集合中元素的類型--><select id = "getEmpsByLastNameLike" resultType="com.atguigu.mybatis.bean.Employee">select * from tb1_employee where last_name like #{lastName} </select> @Testpublic void test03() throws IOException {SqlSessionFactory sqlSessionFactory = getSqlSessionFactory();SqlSession sqlSession = sqlSessionFactory.openSession();try{EmployeeMapper mapper = sqlSession.getMapper(EmployeeMapper.class);List<Employee> like = mapper.getEmpsByLastNameLike("%e%");for (Employee employee : like){System.out.println(employee);}}finally {sqlSession.close();}}

select返回map

public interface EmployeeMapper {//返回一條記錄的map；key就是列名，值就是對應的值public Map<String,Object> getEmpByIdReturnMap(Integer id);} <!-- public Map<String,Object> getEmpByIdReturnMap(Integer id);--><select id="getEmpByIdReturnMap" resultType="map">select * from tb1_employee where id = #{id}</select> @Testpublic void test03() throws IOException {SqlSessionFactory sqlSessionFactory = getSqlSessionFactory();SqlSession sqlSession = sqlSessionFactory.openSession();try{EmployeeMapper mapper = sqlSession.getMapper(EmployeeMapper.class);Map<String,Object> map = mapper.getEmpByIdReturnMap(1);System.out.println(map);}finally {sqlSession.close();}}

select返回多條記錄封裝的map

public interface EmployeeMapper {//多條記錄封裝一個map：Map<String, Employee>:鍵是這條記錄的主鍵，值是這條記錄的主鍵，值是記錄封裝后的javaBean//告訴mybatis封裝這個map的時候，使用哪個屬性作為map的key@MapKey("id")public Map<Integer,Employee> getEmpByLastNameLikeReturnMap(String lastName);} <!--resultType;如果返回的是一個集合，要寫集合中元素的類型--><!-- public Map<Integer,Employee> getEmpByLastNameLikeReturnMap(String lastName);--> <select id="getEmpByLastNameLikeReturnMap" resultType="com.atguigu.mybatis.bean.Employee">select * from tb1_employee where last_name like #{lastName}</select> @Testpublic void test03() throws IOException {SqlSessionFactory sqlSessionFactory = getSqlSessionFactory();SqlSession sqlSession = sqlSessionFactory.openSession();try{EmployeeMapper mapper = sqlSession.getMapper(EmployeeMapper.class);Map<Integer, Employee> map = mapper.getEmpByLastNameLikeReturnMap("%j%");System.out.println(map);}finally {sqlSession.close();}}

總結

以上是生活随笔為你收集整理的[mybatis]映射文件_select_返回集合(List，Map)的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。