哪个高手把这个代码逻辑简化下 多谢
日期：2014-05-20 浏览次数：20723 次
哪个高手把这个代码逻辑简化下 谢谢
------解决方案--------------------
- Java code
if(!beginTime.equals("")&&!endTime.equals("")) {
hql="select sum(d.money) from Income d where d.company.id="+companyId+" and d.incomeTime>='"+beginTime+"' and d.incomeTime<='"+endTime+"' and d.isDeleted=0";
}
else if(!beginTime.equals("")) {
hql="select sum(d.money) from Income d where d.company.id="+companyId+" and d.incomeTime>='"+beginTime+"' and d.isDeleted=0";
}
else if(!endTime.equals("")) {
hql="select sum(d.money) from Income d where d.company.id="+companyId+" and d.incomeTime<='"+endTime+"' and d.isDeleted=0";
}
else {
hql="select sum(d.money) from Income d where d.company.id="+companyId+" and d.isDeleted=0";
}
------解决方案--------------------
- Java code
StringBuilder buff = new StringBuilder("select sum(d.money) from Income d where d.isDeleted=0 and d.company.id=");
buff.append(companyId);
if (beginTime != null && beginTime.length() != 0) {
buff.append(" and d.incomeTime >= '").append(beginTime).append("'");
}
if (endTime != null && endTime.length() != 0) {
buff.append(" and d.incomeTime <= '").append(endTime).append("'");
}
hql = buff.toString();
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
