大家好，又见面了，我是你们的朋友全栈君。如果您正在找激活码,请点击查看最新教程,关注关注公众号 “全栈程序员社区” 获取激活教程,可能之前旧版本教程已经失效.最新Idea2022.1教程亲测有效,一键激活。
Jetbrains全系列IDE稳定放心使用
publicfloatcountmonthmoney(Longblogid){java.text.SimpleDateFormatsf=newjava.text.SimpleDateFormat(“yyyyMM”);Stringtoday=sf.format(newjava.util.Date());StringBuilderstring…
public float countmonthmoney(Long blogid) {
java.text.SimpleDateFormat sf = new java.text.SimpleDateFormat(“yyyyMM”);
String today = sf.format(new java.util.Date());
StringBuilder stringBuilder = new StringBuilder(“select sum(d.emolument) from ” + DesignerSelled.REF+ ” as d where d.” + designerSelled.PROP_DESIGNERID+ “=” + blogid + ” and ” + “to_char(d.”+ DesignerSelled.PROP_SELLEDTIME + “,’yyyyMM’)” + “='”+ today + “‘”);
Session session = null;
float result = 0.0f;
try {
session = this.getSession();
Query query = session.createQuery(stringBuilder.toString());
result = Float.parseFloat((query.uniqueResult()==null?””:query.uniqueResult()).toString());
} finally {closeSession(session);}return result;}
那位高手帮忙看看呀，我这样写是没有错的，但是，每当数据库DesignerSelled表中emolument没有值的时候就会报错 result = Float.parseFloat((query.uniqueResult()==null?””:query.uniqueResult()).toString());就是这句出错严重: Servlet.service() for servlet default threw exception
java.lang.NumberFormatException: empty String
at sun.misc.FloatingDecimal.readJavaFormatString(FloatingDecimal.java:994)
at java.lang.Float.parseFloat(Float.java:422)
at com.ipingou.shopping.model.dao.impl.DesignerSelledDAOImpl.countmonthmoney(DesignerSelledDAOImpl.java:232)
at com.ipingou.shopping.web.action.member.MemberConsoleAction.toListMyPay(MemberConsoleAction.java:734)
我的字段不为空，我已经给它设为0，但是还是报错。
展开
发布者：全栈程序员-站长，转载请注明出处：https://javaforall.net/187418.html原文链接：https://javaforall.net
![SQL中like的用法.[通俗易懂]](https://javaforall.net/wp-content/uploads/2020/11/2020110817443450-480x300.jpg)
