来源：深圳沃龙软件开发公司 2017-05-24
mybatis sql中查询类型为double的字段，返回null的异常,
org.apache.ibatis.binding.BindingException: to return null from a method with a primitive return type (double)
mybatis 查询如下，当 可以查到有跟follower_id 值相关的话，就没有问题
<select id="sumFollowerSubgroupSalesMoney" resultType="java.lang.Double"
parameterType="java.lang.Integer">
select
sum(sales_money)
from follower_subgroup_info
where 1=1
<if test="followerId != null" >
and follower_id = #{followerId,jdbcType=INTEGER}
</if>
</select>
可是当没有查到记录，返回null的时候，就会抛to return null from a method with a primitive return type (double) 这个异常，
解决办法如下：
<select id="sumFollowerSubgroupSalesMoney" resultType="java.lang.Double"
parameterType="java.lang.Integer">
select
IFNULL(sum(sales_money),0) as salesMoney
from follower_subgroup_info
where 1=1
<if test="followerId != null" >
and follower_id = #{followerId,jdbcType=INTEGER}
</if>
</select>
本内容皆为 深圳沃龙软件开发公司 原创
如需转载，请注明文章出处和来源网址：http://www.wooolong.com/blog/13.html
Wow! Finally I got a website from where I can in fact obtain helpful data concerning my study and knowledge.
Hello, I think your site might be having browser compatibility issues. When I look at your blog in Opera, it looks fine but when opening in Internet Explorer, it has some overlapping. I just wanted to give you a quick heads up! Other then that, very good blog!
I couldn't resist commenting. Very well written!
hey there and thank you for your information – I've definitely picked up anything new from right here. I did however expertise some technical issues using this site, since I experienced to reload the site lots of times previous to I could get it to load correctly. I had been wondering if your web host is OK? Not that I am complaining, but sluggish loading instances times will very frequently affect your placement in google and can damage your high-quality score if ads and marketing
Link exchange is nothing else except it is just placing the other person's web site link on your page at proper place and other person will also do similar in support of you.
Pretty great post. I just stumbled upon your blog and wanted to mention that I've really loved surfing around your weblog posts. In any case I'll be subscribing on your rss feed and I'm hoping you write again very soon!
Very good article. I definitely love this site. Thanks!
Wow! At last I got a web site from where I know how to truly take valuable facts concerning my study and knowledge.
My partner and I absolutely love your blog and find most of your post's to be just what I'm looking for. Do you offer guest writers to write content to suit your needs? I wouldn't mind producing a post or elaborating on a number of the subjects you write regarding here. Again, awesome blog!
Have you ever thought about creating an e-book or guest authoring on other blogs? I have a blog centered on the same information you discuss and would love to have you share some stories/information. I know my visitors would value your work. If you are even remotely interested, feel free to send me an email.
Have you ever thought about creating an e-book or guest authoring on other blogs? I have a blog centered on the same information you discuss and would love to have you share some stories/information. I know my visitors would value your work. If you are even remotely interested, feel free to send me an email.
Have you ever thought about creating an e-book or guest authoring on other blogs? I have a blog centered on the same information you discuss and would love to have you share some stories/information. I know my visitors would value your work. If you are even remotely interested, feel free to send me an email.
Have you ever thought about creating an e-book or guest authoring on other blogs? I have a blog centered on the same information you discuss and would love to have you share some stories/information. I know my visitors would value your work. If you are even remotely interested, feel free to send me an email.
Hello colleagues, nice article and pleasant urging commented here, I am in fact enjoying by these.
I was recommended this blog by my cousin. I am not sure whether this post is written by him as no one else know such detailed about my problem. You're amazing! Thanks!
An interesting discussion is definitely worth comment. I do believe that you need to publish more about this issue, it may not be a taboo matter but generally people do not talk about these issues. To the next! Kind regards!!
Actually no matter if someone doesn't be aware of after that its up to other users that they will help, so here it occurs.
Remarkable things here. I am very happy to see your post. Thank you so much and I'm looking forward to contact you. Will you please drop me a e-mail?
hey there and thank you for your information – I have certainly picked up something new from right here. I did however expertise some technical issues using this web site, since I experienced to reload the website a lot of times previous to I could get it to load correctly. I had been wondering if your hosting is OK? Not that I'm complaining, but sluggish loading instances times will often affect your placement in google and can damage your high-quality score if advertising and
We are a group of volunteers and starting a new scheme in our community. Your website provided us with valuable info to work on. You have done an impressive job and our entire community will be thankful to you.
Wow! Finally I got a blog from where I be able to really obtain helpful facts concerning my study and knowledge.
Néanmoins il s’agit d’une installation très minutieuse et le recours à un professionnel expérimenté se montre rassurant.
Hi there, You have done an incredible job. I will certainly digg it and personally recommend to my friends. I am confident they will be benefited from this website.
This design is steller! You definitely know how to keep a reader entertained. Between your wit and your videos, I was almost moved to start my own blog (well, almost...HaHa!) Excellent job. I really enjoyed what you had to say, and more than that, how you presented it. Too cool!
I’m not that much of a online reader to be honest but your sites really nice, keep it up! I'll go ahead and bookmark your site to come back down the road. Cheers
Hey I know this is off topic but I was wondering if you knew of any widgets I could add to my blog that automatically tweet my newest twitter updates. I've been looking for a plug-in like this for quite some time and was hoping maybe you would have some experience with something like this. Please let me know if you run into anything. I truly enjoy reading your blog and I look forward to your new updates.
It's wonderful that you are getting ideas from this piece of writing as well as from our argument made at this time.
Hello there, I found your site via Google at the same time as searching for a related matter, your web site came up, it looks good. I have bookmarked it in my google bookmarks. Hello there, simply turned into aware of your weblog through Google, and located that it's really informative. I'm going to watch out for brussels. I will appreciate should you proceed this in future. A lot of people will be benefited from your writing. Cheers!
I don't know whether it's just me or if everybody else encountering issues with your website. It appears like some of the text on your content are running off the screen. Can somebody else please provide feedback and let me know if this is happening to them too? This could be a problem with my web browser because I've had this happen previously. Thanks
It's an awesome paragraph in support of all the internet viewers; they will get benefit from it I am sure.
After looking into a handful of the blog articles on your web page, I truly like your way of writing a blog. I added it to my bookmark website list and will be checking back in the near future. Please visit my web site too and tell me what you think.
Magnificent beat ! I wish to apprentice while you amend your website, how could i subscribe for a blog site? The account aided me a acceptable deal. I had been tiny bit acquainted of this your broadcast provided bright clear idea
Woah! I'm really loving the template/theme of this website. It's simple, yet effective. A lot of times it's difficult to get that "perfect balance" between superb usability and appearance. I must say you've done a superb job with this. Additionally, the blog loads super quick for me on Safari. Excellent Blog!
I have been exploring for a bit for any high quality articles or blog posts in this sort of house . Exploring in Yahoo I eventually stumbled upon this website. Reading this info So i'm happy to convey that I have an incredibly good uncanny feeling I found out just what I needed. I most indisputably will make certain to don?t put out of your mind this website and provides it a glance regularly.
Hi there, all is going sound here and ofcourse every one is sharing facts, that's truly excellent, keep up writing.
Hermep (Aidan Scott) est exactement le même que dans l’animé et pour lui, c’est carrément bluffant.
I'm really loving the theme/design of your weblog. Do you ever run into any internet browser compatibility problems? A handful of my blog readers have complained about my site not operating correctly in Explorer but looks great in Opera. Do you have any suggestions to help fix this issue?
《a href=HHtp://viagr.top》viagra liquid《/a》 There are insufficient data available regarding the effect of Tamifine tamoxifen citrate on breast cancer incidence in women with inherited mutations BRCA1, BRCA2 to be able to make specific recommendations on the effectiveness of Tamifine tamoxifen citrate in these patients
Have you ever thought about including a little bit more than just your articles? I mean, what you say is valuable and everything. However just imagine if you added some great graphics or videos to give your posts more, "pop"! Your content is excellent but with pics and clips, this site could undeniably be one of the greatest in its field. Fantastic blog!
Thanks foｒ shaгing your thoughts about blow. Regards
Youг styⅼe is very unique compared to other pеople I have read stuff fгоm. I appreciate you ffor posting when you haѵe the opportunity, Guesｚs I will just bookmark tһis blog.
发表评论