mybatis 如何通過resultMap 返回long
<resultMap type='java.lang.Long'> <result column='budget' property='budget' javaType='long'/> </resultMap> mybatis long 類型返回為null報(bào)異常
Mapper method ’com.mpn.dao.TWeatherMapper.avgWeatherTemperature attempted to return null from a method with a primitive return type (long).
<select resultType='java.lang.Long' parameterType='java.lang.String' >SELECT IFNULL(AVG(WeatherTemperature),0) AS OrderAverage FROM t_weather WHERE WeatherDate= #{date,jdbcType=VARCHAR}; </select> <select resultType='java.lang.Long' parameterType='java.lang.String' >SELECT SUM(WeatherTemperature) AS OrderAverage FROM t_weather WHERE WeatherDate= #{date,jdbcType=VARCHAR}; </select> <select resultType='java.lang.Long' parameterType='java.lang.String' >SELECT IFNULL(AVG(WeatherHumidity),0) AS OrderAverage FROM t_weather WHERE WeatherDate= #{date,jdbcType=VARCHAR}; </select>
由于返回為空long中沒有此類型所以拋異常,改為
<!-- 根據(jù)日期來進(jìn)行計(jì)算平局值與 --> <select resultType='java.lang.Long' parameterType='java.lang.String' >SELECT IFNULL(AVG(WeatherTemperature),0) AS OrderAverage FROM t_weather WHERE WeatherDate= #{date,jdbcType=VARCHAR}; </select> <select resultType='java.lang.Long' parameterType='java.lang.String' >SELECT IFNULL(SUM(WeatherTemperature),0) AS OrderAverage FROM t_weather WHERE WeatherDate= #{date,jdbcType=VARCHAR}; </select> <select resultType='java.lang.Long' parameterType='java.lang.String' >SELECT IFNULL(AVG(WeatherHumidity),0) AS OrderAverage FROM t_weather WHERE WeatherDate= #{date,jdbcType=VARCHAR}; </select>
用IFNULL來進(jìn)行判斷!
以上為個(gè)人經(jīng)驗(yàn),希望能給大家一個(gè)參考,也希望大家多多支持好吧啦網(wǎng)。
相關(guān)文章:
1. Docker部署Mysql集群的實(shí)現(xiàn)2. SQL SERVER數(shù)據(jù)庫開發(fā)之存儲(chǔ)過程的應(yīng)用3. SQL Server全文檢索簡介4. idea連接SQL Server數(shù)據(jù)庫的詳細(xì)圖文教程5. MySQL 的啟動(dòng)和連接方式實(shí)例分析6. Oracle?Users表空間重命名問題解決7. mybatis中方法返回泛型與resultType不一致的解決8. Oracle中pivot函數(shù)圖文實(shí)例詳解9. 在SQL Server 2005修改存儲(chǔ)過程10. 服務(wù)器Centos部署MySql并連接Navicat過程詳解
