MyBatis批量查询用户信息

<code class="hljs applescript has-numbering" style="display: block; padding: 0px; color: inherit; box-sizing: border-box; font-family: 'Source Code Pro', monospace;font-size:undefined; white-space: pre; border-radius: 0px; word-wrap: normal; background: transparent;">    <select <span class="hljs-property" style="box-sizing: border-box;">id</span>=<span class="hljs-string" style="color: rgb(0, 136, 0); box-sizing: border-box;">"selectByIdBatch"</span> parameterType=<span class="hljs-string" style="color: rgb(0, 136, 0); box-sizing: border-box;">"java.util.List"</span> resultMap=<span class="hljs-string" style="color: rgb(0, 136, 0); box-sizing: border-box;">"userInfo"</span>>
        SELECT
            <span class="hljs-property" style="box-sizing: border-box;">id</span>,<span class="hljs-property" style="box-sizing: border-box;">name</span>,sex,phone
        FROM
            user_info
        <<span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">where</span>>
            <span class="hljs-property" style="box-sizing: border-box;">id</span> <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">in</span>
            <foreach <span class="hljs-property" style="box-sizing: border-box;">item</span>=<span class="hljs-string" style="color: rgb(0, 136, 0); box-sizing: border-box;">"id"</span> collection=<span class="hljs-string" style="color: rgb(0, 136, 0); box-sizing: border-box;">"list"</span> separator=<span class="hljs-string" style="color: rgb(0, 136, 0); box-sizing: border-box;">","</span> open=<span class="hljs-string" style="color: rgb(0, 136, 0); box-sizing: border-box;">"("</span> close=<span class="hljs-string" style="color: rgb(0, 136, 0); box-sizing: border-box;">")"</span> index=<span class="hljs-string" style="color: rgb(0, 136, 0); box-sizing: border-box;">""</span>>
                <span class="hljs-comment" style="color: rgb(136, 0, 0); box-sizing: border-box;">#{id, jdbcType=NUMERIC}</span>
            </foreach>
        </<span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">where</span>>
    </select></code><ul class="pre-numbering" style="box-sizing: border-box; position: absolute; width: 50px; top: 0px; left: 0px; margin: 0px; padding: 6px 0px 40px; border-right-width: 1px; border-right-style: solid; border-right-color: rgb(221, 221, 221); list-style: none; text-align: right; background-color: rgb(238, 238, 238);"><li style="box-sizing: border-box; padding: 0px 5px;">1</li><li style="box-sizing: border-box; padding: 0px 5px;">2</li><li style="box-sizing: border-box; padding: 0px 5px;">3</li><li style="box-sizing: border-box; padding: 0px 5px;">4</li><li style="box-sizing: border-box; padding: 0px 5px;">5</li><li style="box-sizing: border-box; padding: 0px 5px;">6</li><li style="box-sizing: border-box; padding: 0px 5px;">7</li><li style="box-sizing: border-box; padding: 0px 5px;">8</li><li style="box-sizing: border-box; padding: 0px 5px;">9</li><li style="box-sizing: border-box; padding: 0px 5px;">10</li><li style="box-sizing: border-box; padding: 0px 5px;">11</li><li style="box-sizing: border-box; padding: 0px 5px;">12</li></ul>

然后使用在循环里面，找到多个id，然后用in查询将user_info数据查询出来，在放到msg的对象里面。

<code class="hljs cs has-numbering" style="display: block; padding: 0px; color: inherit; box-sizing: border-box; font-family: 'Source Code Pro', monospace;font-size:undefined; white-space: pre; border-radius: 0px; word-wrap: normal; background: transparent;">比如两个类
<span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">public</span> <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">class</span> Message{
    <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">private</span> Long id;
    <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">private</span> String content;
    <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">private</span> Date createTime;
    <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">private</span> Long uid;
    priavte UserInfo userInfo;
}

<span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">public</span> <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">class</span> UserInfo{
    <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">private</span> Long id;
    <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">private</span> String name;
    <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">private</span> String phone;
}</code><ul class="pre-numbering" style="box-sizing: border-box; position: absolute; width: 50px; top: 0px; left: 0px; margin: 0px; padding: 6px 0px 40px; border-right-width: 1px; border-right-style: solid; border-right-color: rgb(221, 221, 221); list-style: none; text-align: right; background-color: rgb(238, 238, 238);"><li style="box-sizing: border-box; padding: 0px 5px;">1</li><li style="box-sizing: border-box; padding: 0px 5px;">2</li><li style="box-sizing: border-box; padding: 0px 5px;">3</li><li style="box-sizing: border-box; padding: 0px 5px;">4</li><li style="box-sizing: border-box; padding: 0px 5px;">5</li><li style="box-sizing: border-box; padding: 0px 5px;">6</li><li style="box-sizing: border-box; padding: 0px 5px;">7</li><li style="box-sizing: border-box; padding: 0px 5px;">8</li><li style="box-sizing: border-box; padding: 0px 5px;">9</li><li style="box-sizing: border-box; padding: 0px 5px;">10</li><li style="box-sizing: border-box; padding: 0px 5px;">11</li><li style="box-sizing: border-box; padding: 0px 5px;">12</li><li style="box-sizing: border-box; padding: 0px 5px;">13</li><li style="box-sizing: border-box; padding: 0px 5px;">14</li></ul>

<code class="hljs php has-numbering" style="display: block; padding: 0px; color: inherit; box-sizing: border-box; font-family: 'Source Code Pro', monospace;font-size:undefined; white-space: pre; border-radius: 0px; word-wrap: normal; background: transparent;"><span class="hljs-comment" style="color: rgb(136, 0, 0); box-sizing: border-box;">//示意代码：用作代码展示，没有编译过。</span>
<span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">List</span><Message> msgList = msgMapper.selectPage(<span class="hljs-number" style="color: rgb(0, 102, 102); box-sizing: border-box;">0</span>,<span class="hljs-number" style="color: rgb(0, 102, 102); box-sizing: border-box;">10</span>);
<span class="hljs-comment" style="color: rgb(136, 0, 0); box-sizing: border-box;">//示意Set存储，保证Id不重复。</span>
Set<Long> msgIds = <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">new</span> HashSet<Long>();
<span class="hljs-comment" style="color: rgb(136, 0, 0); box-sizing: border-box;">//循环Message消息，找到所有Id。</span>
<span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">for</span>(Message msg:msgList){
    <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">if</span>(msg != <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">null</span> && msg.getId() != <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">null</span>){
        msgIds.add(msg.getId());
    }
}
<span class="hljs-comment" style="color: rgb(136, 0, 0); box-sizing: border-box;">//批量查询用户信息。</span>
<span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">List</span><UserInfo> userList = userMapper.selectByIdBatch(<span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">new</span> ArrayList<Long>(msgIds));
<span class="hljs-comment" style="color: rgb(136, 0, 0); box-sizing: border-box;">//将用户List转换成Map</span>
Map<Long,<span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">List</span><UserInfo>> userMap = <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">new</span> HashMap<Long,<span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">List</span><UserInfo>>();
<span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">for</span>(UserInfo userInfo:userList){
    <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">if</span>(userInfo != <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">null</span> && userInfo.getId() != <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">null</span>){
        <span class="hljs-comment" style="color: rgb(136, 0, 0); box-sizing: border-box;">//转换map。</span>
        userMap.add(userInfo.getId(),userInfo);
    }
}
<span class="hljs-comment" style="color: rgb(136, 0, 0); box-sizing: border-box;">//循环消息再把UserInfo对象放回去。</span>
<span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">for</span>(Message msg : msgList){
    <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">if</span>(msg != <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">null</span> && msg.getUid() != <span class="hljs-keyword" style="color: rgb(0, 0, 136); box-sizing: border-box;">null</span>){
        UserInfo userInfo = userMap.get(msg.getUid());
        <span class="hljs-comment" style="color: rgb(136, 0, 0); box-sizing: border-box;">//设置用户</span>
        msg.setUserInfo(userInfo);
    }
}
<span class="hljs-comment" style="color: rgb(136, 0, 0); box-sizing: border-box;">//最后再显示。</span>
.....</code>