mybatis返回key|mybatis返回key value map集合方式 mybatis返回keyvaluemap集合方式

mybatis返回key value map集合
mybatis返回map，key为主键，value为对象

mybatis返回key value map集合 XML:文件

SELECT id,name FROM user

Service实现类： namespaceXml根据自己xml命名取

import org.apache.ibatis.session.SqlSession; @Autowiredprivate SqlSession sqlSession; public Map getBasicInformationOfCompanyPersonnel(String status) throws Exception {Map params = new HashMap<>(); params.put("status", status); MapResultHandler handler = new MapResultHandler(); Map result = handler.getMappedResults(); sqlSession.select("namespaceXml.getData",params,handler); return result; }

工具类：

import org.apache.ibatis.session.ResultContext; import org.apache.ibatis.session.ResultHandler; public class MapResultHandler implements ResultHandler { @SuppressWarnings("rawtypes")private final Map mappedResults = new HashMap(); @SuppressWarnings("unchecked")@Overridepublic void handleResult(ResultContext context) {@SuppressWarnings("rawtypes")Map map = (Map) context.getResultObject(); // xml配置里面的property的值，对应的列mappedResults.put(map.get("key"), map.get("value")); } @SuppressWarnings("rawtypes")public Map getMappedResults() {return mappedResults; }}

mybatis返回map，key为主键，value为对象