mybatis 如何利用resultMap复杂类型list映射_Java教程

mybatis resultMap复杂类型list映射

映射泛型为对象

xml

				?

									<resultMap id="internetDataDTO" type="com.mdm.skr.mdm_common.dto.StrategyInternetDataDTO">

									    <id property="id" column="id" jdbcType="INTEGER"/>

									    <result property="internetData" column="internet_data" jdbcType="INTEGER"/>

									    <collection property="userList" ofType="com.mdm.skr.mdm_common.entity.SysUser">

									        <id property="id" column="id" jdbcType="INTEGER"/>

									        <result property="number" column="number" jdbcType="VARCHAR"/>

									        <result property="pushToken" column="push_token" jdbcType="VARCHAR"/>

									        <result property="wsChannelId" column="ws_channel_id" jdbcType="VARCHAR"/>

									    </collection>

									</resultMap> 

									<select id="selectInternetDataDTOByInternetDataIdList" resultMap="internetDataDTO">

									      SELECT sidu.id, sidu.internet_data, su.id, su.number, su.push_token, su.ws_channel_id

									      FROM strategy_internet_data_user sidu JOIN skr_user su on su.id = sidu.user_id

									      WHERE sidu.id IN

									      <foreach collection="internetDataIdList" open="(" close=")"

									          separator="," item="internetDataId">

									          #{internetDataId}

									      </foreach>

									</select>

DTO

				?

									@Data

									public class StrategyInternetDataDTO { 

									    private Integer id ;

									    private Integer internetData ;

									    private List<SysUser> userList ;

									}

ENTITY

				?

									@Data

									public class SysUser { 

									    private Integer id;

									    private String number;

									    private String pushToken;

									    private String wsChannelId ; 

									}

MAPPER

				?

									List<StrategyInternetDataDTO> selectInternetDataDTOByInternetDataIdList(@Param("internetDataIdList") List<Integer> internetDataIdList);

映射泛型为包装类型

xml

				?

									<resultMap id="internetDataDTO" type="com.mdm.skr.mdm_common.dto.StrategyInternetDataDTO">

									    <id property="id" column="id" jdbcType="INTEGER"/>

									    <result property="internetData" column="internet_data" jdbcType="INTEGER"/>

									    <collection property="userIdList" ofType="java.lang.Integer" javaType="java.util.List">

									        <result column="userId"/>

									    </collection>

									</resultMap>  

									<select id="selectInternetDataDTOByInternetDataIdList" resultMap="internetDataDTO">

									      SELECT sidu.id, sidu.internet_data, sidu.user_id userId

									      FROM strategy_internet_data_user sidu

									      WHERE sidu.id IN

									      <foreach collection="internetDataIdList" open="(" close=")"

									          separator="," item="internetDataId">

									          #{internetDataId}

									      </foreach>

									</select>

DTO

				?

									@Data

									public class StrategyInternetDataDTO { 

									    private Integer id ;

									    private Integer internetData ;

									    private List<Integer> userIdList ; 

									}

MAPPER

				?

									List<StrategyInternetDataDTO> selectInternetDataDTOByInternetDataIdList(@Param("internetDataIdList") List<Integer> internetDataIdList);

mybatis的几种传值方式

1.单个参数传参

				?

									User selectUserInfo(Integer userId);

									<select id = "selectUserInfo" parameterType = "java.lang.Inte" resultMap="BaseResultMap" >

									    select

									    <include refid="Base_Column_List" />

									    from user

									    where userId = #{userId , jdbcType=INTEGER}

									</select>

2. 按照顺序传参

				?

									User selectUserInfo(Integer userId, String userName, String userPass);

									<select id = "selectUserInfo" resultMap="BaseResultMap" >

									    select

									    <include refid="Base_Column_List" />

									    from user

									    where userId = #{arg0} and userName = #{arg1} and userPass = #{arg2}

									</select>

3. 使用@Param注解传参

				?

									User selectUserInfo(@Param("userName")String userName, @Param("userPass")String userPass);

									<select id = "selectUserInfo" resultMap="BaseResultMap" >

									    select

									    <include refid="Base_Column_List" />

									    from user

									    where userName = #{userName} and userPass = #{userPass}

									</select>

4. 使用Map传参注意传参方式：parameterType="java.util.Map"

				?

									Map<String,Object> map = new HashMap();

									map.put("userName","张三");

									map.put("userPass","123");

									User user = userMapper.selectUserInfo(map);

									User selectUserInfo(Map<String,Object> map);

									<select id="selectUserInfo" parameterType="java.util.Map" resultMap="BaseResultMap" >

									    select

									    <include refid="Base_Column_List" />

									    from user

									    where userName = #{userName} and userPass = #{userPass}

									</select>

5. 实体对象传参

				?

									User user = new User();

									user.setUserName("张三");

									user.setUserPass("123");

									User user = UserMapper.selectUserInfo(user);

									User selectUserInfo(User record);

									<select id="selectUserInfo" parameterType="com.LiuXu.bean.User" resultMap="BaseResultMap" >

									    select

									    <include refid="Base_Column_List" />

									    from user

									    where userName = #{userName} and userPass = #{userPass}

									</select>

6. List传参

				?

									List<User> list = new ArrayList<>();

									list.add(user1);

									list.add(user2);

									List<User> userList = userMapper.selectUserInfo(list);

									List<User> selectUserInfo(List<User> record);

									<select id="selectUserInfo" resultMap="BaseResultMap" >

									    select

									    <include refid="Base_Column_List" />

									    from user

									    where userId in

									    <foreach item="item" index="index" collection="list" open="(" separator="," close=")">

									        #{item}

									    </foreach>

									</select>