81,094
社区成员
发帖
与我相关
我的任务
分享
type r_cursor is ref cursor;
procedure getRoleByLoginId(p_loginid varchar2,R_cur Out R_Cursor)is
begin
open R_cur for select t3.id,t3.rolename,t3.roledesc from sys_user t1,sys_user_role t2,sys_role t3 where
t1.id = t2.userid and t2.roleid =t3.id and t1.loginid = p_loginid;
end getRoleByLoginId;
<select id="方法" statementType="CALLABLE" resultType="Map">
<![CDATA[
{call sequence_procedure (#{tableName,mode=IN,jdbcType=VARCHAR})}
]]>
</select>
mapper对应接口public List<Map> 方法();
不行吗<resultMap id=\”getItemsResult\” class=\”java.util.HashMap\”>
<result property=\”itemName\” column=\”item_name\” />
<result property=\”itemValue\” column=\”item_value\” />
</resultMap>
<select id=\”getItems\” resultMap=\”getItemsResult\”>
select item_name, item_value from item_table
</select>
Map<String,Object> map=getSqlMapClientTemplate().queryForMap(\”getItems\”, null, \”itemName\”, \”itemValue\”);
List<Map<String,Object>> list=new ArrayList()<Map<String,Object>>;
list.add(map); <resultMap class="java.util.HashMap" id="getActionIdAndActionNumber">
<result column="actionId" property="actionId" jdbcType="BIGINT" javaType="long"/>
<result column="count" property="count" jdbcType="INT" javaType="int"/>
</resultMap>
List<Map<String,Object>> list=getSqlMapClientTemplate().queryForList(sqlName,parameter);