mybatis sqlserver 多结果集

返回两个结果集 mybatis的xml 配置

点击(此处)折叠或打开

1.     <resultMap type=\"java.util.HashMap\" id=\"resultStract\">
   
2.         <result property=\"stractid\" column=\"iRoomStractId\" javaType=\"java.lang.Integer\" jdbcType=\"INTEGER\" />
   
3.         <result property=\"stractname\" column=\"strRoomStractName\" javaType=\"java.lang.String\" jdbcType=\"VARCHAR\" />
   
4.         <result property=\"onlineuser\" column=\"iRoomOnlineCount\" javaType=\"java.lang.Integer\" jdbcType=\"INTEGER\" />
   
5.         <result property=\"color\" column=\"iCorlor\" javaType=\"java.lang.Integer\" jdbcType=\"INTEGER\" />
   
6.         <result property=\"imageid\" column=\"iImage\" javaType=\"java.lang.Integer\" jdbcType=\"INTEGER\"/>
   
7.         <result property=\"type\" column=\"iStractType\" javaType=\"java.lang.Integer\" jdbcType=\"INTEGER\"/>
   
8.         <result property=\"url\" column=\"strUrl\" javaType=\"java.lang.String\" jdbcType=\"VARCHAR\"/>
   
9.     </resultMap>
   
10.     
    
11.     <resultMap type=\"java.util.HashMap\" id=\"resultRoom\" >
    
12.         <result property=\"roomid\" column=\"i64RoomID\" javaType=\"java.lang.Long\" jdbcType=\"BIGINT\" />
    
13.         <result property=\"roomname\" column=\"strRoomName\" javaType=\"java.lang.String\" jdbcType=\"VARCHAR\" />
    
14.         <result property=\"color\" column=\"iColor\" javaType=\"java.lang.Integer\" jdbcType=\"INTEGER\" />
    
15.         <result property=\"imageid\" column=\"iRoomImage\" javaType=\"java.lang.Integer\" jdbcType=\"INTEGER\"/>
    
16.         <result property=\"needpasswd\" column=\"bisNeedPassword\" javaType=\"java.lang.Boolean\" jdbcType=\"CHAR\"/>
    
17.         <result property=\"maxuser\" column=\"iMaxUserCount\" javaType=\"java.lang.Integer\" jdbcType=\"INTEGER\"/>
    
18.         <result property=\"curuser\" column=\"iRoomOnlineCount\" javaType=\"java.lang.Integer\" jdbcType=\"INTEGER\"/>
    
19.         <result property=\"property\" column=\"iRoomPro\" javaType=\"java.lang.Integer\" jdbcType=\"INTEGER\"/>
    
20.         <result property=\"roompos\" column=\"roompos\" javaType=\"java.lang.String\" jdbcType=\"VARCHAR\"/>
    
21.     </resultMap>
    
22.     
    
23.     <select id =\"mobileRoomQuery\" parameterType=\"Map\" statementType=\"CALLABLE\" resultMap=\"resultStract,resultRoom\" >
    
24.             {call sp_stract_room_query(#{id,mode=IN,jdbcType=BIGINT})}
    
25.     </select>

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/28714879/viewspace-1590496/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/28714879/viewspace-1590496/