mybatis返回List<Map<String,Object>>
来源:互联网 发布:网络销售代理合同范本 编辑:程序博客网 时间:2024/05/17 06:27
<mapper namespace="com.brkc.epolice.mysql.dao.OnlineStatMapper" >
<select id="selectOnlineRateCurrent" resultType="java.util.HashMap" >
SELECT count(*) value, c. NAME label, ifnull(b.device_status, 0) device_status
FROM td01_device a
LEFT OUTER JOIN td06_device_status b ON a.id = b.device_id
LEFT OUTER JOIN td05_dd_device_status c ON c.ID = ifnull(b.device_status, 0)
GROUP BY ifnull(b.device_status, 0), c. NAME
ORDER BY device_status
</select>
<select id="selectOnlineRateCurrent" resultType="java.util.HashMap" >
SELECT count(*) value, c. NAME label, ifnull(b.device_status, 0) device_status
FROM td01_device a
LEFT OUTER JOIN td06_device_status b ON a.id = b.device_id
LEFT OUTER JOIN td05_dd_device_status c ON c.ID = ifnull(b.device_status, 0)
GROUP BY ifnull(b.device_status, 0), c. NAME
ORDER BY device_status
</select>
</mapper>
public interface OnlineStatMapper {
public List<Map<String, Object>> selectOnlineRateCurrent();
}
0 0
- mybatis返回List<Map<String,Object>>
- Spring Mybatis 返回List<Map<String,Object>>
- Spring Mybatis 返回 List<String> 和List<Map<String,Object>>
- mybatis返回Map<String, Object>
- Mybatis 如何 返回 List<String> 类型 或 List<Map<String,Object>>类型
- 数据库查询返回List<Map<String, Object>>
- Mybatis无实体类,以List<Map<String,Object>>方式返回
- Mybatis查询表数据及其列名,返回List<Map<String,Object>>
- mybatis 返回 list<object>
- List<Map<String, Object>>
- List<Map<String, Object>>
- List<Map<String, Object>>
- mybatis返回List<Map>
- mybatis返回list<Map>
- mybatis返回List<Map>
- 服务端返回List<Map<String,Object>>数据,$http 无法接收
- mybatis返回List<Object[]>数组
- mybatis返回List<Object[]>数据
- 深入剖析Android音频之AudioSystem
- socket结束后如何立刻释放端口
- php-wamp环境搭建
- 淘宝框架历程
- 移除HTML5 input在type="number"时的上下小箭头
- mybatis返回List<Map<String,Object>>
- 如何实现servlet的单线程模式
- iOS获取UUID,并使用keychain存储
- user版本如何打开uart,让android log从串口kernel log输出
- 深入剖析Android音频之AudioTrack
- 已解——Android Studio中AVD Manager之“Repair Device”问题
- AsyncTask 和 Handler
- 写一个替换for的语句
- ajax下提交form表单不能使用submit