1、自定义实现该类 package com.linmain.dict.handle;import org.apache.ibatis.session.ResultContext;import org.
package com.linmain.dict.handle;import org.apache.ibatis.session.ResultContext;import org.apache.ibatis.session.ResultHandler;import java.util.HashMap;import java.util.Map;@SuppressWarnings("all")public class MapResultHandle<K, V> implements ResultHandler<Map<K, V>> { private final Map<K,V> mappedResults = new HashMap<>(); @Override public void handleResult(ResultContext<? extends Map<K, V>> resultContext) { Map map = (Map) resultContext.getResultObject(); //key和value是xml中映射的 mappedResults.put((K)map.get("key"), (V)map.get("value")); } public Map<K, V> getMappedResults() { return mappedResults; }}
Map<String,String> pageByTypeId(Serializable typeId);
<resultMap id="mapResult" type="java.util.HashMap"> <result property="key" column="data_value"/> <result property="value" column="data_name"/> resultMap> <select id="pageByTypeId" resultMap="mapResult"> select data_name, data_value from dict_data where dict_id = #{typeId} and is_delete = '0'; select>
@Override public Map<String,String> getAllByTypeId(Serializable typeId) { //获取一个sqlsession对象,true:自动提交 SqlSession sqlSession = sqlSessionFactory.openSession(true); //创建一个结果处理器 MapResultHandle<String, String> mapResultHandle = new MapResultHandle<>(); //进行数据查询和结果封装 sqlSession.select("com.linmain.dict.dao.DictDataDao.pageByTypeId", typeId, mapResultHandle); Map<String, String> mappedResults = mapResultHandle.getMappedResults(); return mappedResults; }
来源地址:https://blog.csdn.net/u011746120/article/details/129441077
--结束END--
本文标题: mybatisPlus返回Map类型的集合(两列字段,一列为key,一列为value)
本文链接: https://www.lsjlt.com/news/392461.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-04-03
2024-04-03
2024-04-01
2024-01-21
2024-01-21
2024-01-21
2024-01-21
2023-12-23
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0