mybatis-210719-01---映射文件_select_返回List&记录封装map

mybatis-210719-01—映射文件_select_返回List&记录封装map

• 返回List
  • EmployeeMapper.java
  • EmployeeMapper.xml
  • MybatisTest.java
• 记录封装map
  • EmployeeMapper.java
  • EmployeeMapper.xml
  • MybatisTest.java

---

返回List

EmployeeMapper.java

package com.bgy.mybatis.dao;
import java.util.List;
import java.util.Map;
import org.apache.ibatis.annotations.Param;
import com.bgy.mybatis.bean.Employee;

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

EmployeeMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
  PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
  "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.bgy.mybatis.dao.EmployeeMapper">
	<!--  -->
	<select id="getEmpByLastNameLike" resultType="com.bgy.mybatis.bean.Employee">
    select 
    	id,last_name,gender,email
    from
    	tbl_employee 
    where 
    	last_name like #{lastName}
  </select>
</mapper>

MybatisTest.java

package com.bgy.mybatis.test;

import static org.junit.jupiter.api.Assertions.*;

import java.io.IOException;
import java.io.InputStream;
import java.util.List;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.jupiter.api.Test;
import com.bgy.mybatis.bean.Employee;
import com.bgy.mybatis.dao.EmployeeMapper;

class MybatisTest {
	
	public SqlSessionFactory getSqlSessionFactory() throws IOException {
		String resource = "mybatis-config.xml";
		InputStream inputStream = Resources.getResourceAsStream(resource);
		return new SqlSessionFactoryBuilder().build(inputStream);
	}

	/**
	 * 测试select返回一个List集合
	 * @throws IOException
	 */
	@Test
	public void test03() throws IOException{
		SqlSessionFactory sqlSessionFactory = getSqlSessionFactory();
		SqlSession sqlSession = sqlSessionFactory.openSession();
		
		try {
			EmployeeMapper mapper = sqlSession.getMapper(EmployeeMapper.class);
			
			List<Employee> employees = mapper.getEmpByLastNameLike("%zhang%");
			for (Employee e : employees) {
				System.out.println(e);
			}
		} finally {
			sqlSession.close();
		}
	}
}

---

---

记录封装map

EmployeeMapper.java

package com.bgy.mybatis.dao;

import java.util.Map;
import org.apache.ibatis.annotations.MapKey;
import com.bgy.mybatis.bean.Employee;

public interface EmployeeMapper {
    
	// 返回一条记录的map，key就是列明，值就是对应的值
	public Map<String,Object> getEmpByIdTurnMap(Integer id);
	
	
	// 多条记录封装一个map，Map<Integer,Employee>
	// 键是这条记录的主键，值是记录封装后的JavaBean对象
	// 告诉mybatis封装这个map的时候使用哪个属性作为map的key
//	@MapKey("id")
	@MapKey("lastName")
	public Map<Integer,Employee> getEmpByLastNameLikeReturnMap(String lastName);
}

EmployeeMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
  PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
  "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.bgy.mybatis.dao.EmployeeMapper">
	<!-- 返回一条记录的map -->
	<select id="getEmpByIdTurnMap" resultType="map">
    select 
    	*
    from
    	tbl_employee 
    where 
    	id=#{id}
  </select>
  
  <!-- 多条记录封装一个map -->
  <select id="getEmpByLastNameLikeReturnMap" resultType="com.bgy.mybatis.bean.Employee">
  	select * from tbl_employee where last_name like #{lastName}
  </select>
</mapper>

MybatisTest.java

package com.bgy.mybatis.test;

import java.io.IOException;
import java.io.InputStream;
import java.util.Map;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.jupiter.api.Test;
import com.bgy.mybatis.bean.Employee;
import com.bgy.mybatis.dao.EmployeeMapper;

class MybatisTest {
	
	public SqlSessionFactory getSqlSessionFactory() throws IOException {
		String resource = "mybatis-config.xml";
		InputStream inputStream = Resources.getResourceAsStream(resource);
		return new SqlSessionFactoryBuilder().build(inputStream);
	}

	/**
	 * 测试select,记录封装map
	 * @throws IOException
	 */
	@Test
	public void test03() throws IOException{
		SqlSessionFactory sqlSessionFactory = getSqlSessionFactory();
		
		SqlSession sqlSession = sqlSessionFactory.openSession();
		
		try {
			EmployeeMapper mapper = sqlSession.getMapper(EmployeeMapper.class);
			
			// 返回一条记录的map
//			Map<String,Object> map = mapper.getEmpByIdTurnMap(1);
//			System.out.println(map);
			
			// 多条记录封装一个map
			Map<Integer,Employee> map = mapper.getEmpByLastNameLikeReturnMap("%g%");
			System.out.println(map);
		} finally {
			sqlSession.close();
		}
	}
}