sql.append(" select sum(to_number(t.BeginMoney)) BeginSum, ");
sql.append(" sum(to_number(t.EndMoney)) EndSum, ");
sql.append(" sum(to_number(t.InMoney)) InSum, ");
sql.append(" sum(to_number(t.RtnMoney)) RtnSum, ");
sql.append(" sum(to_number(t.FixMoney)) FixSum, ");
sql.append(" sum(to_number(t.TranMoneyCM)) MoneyCMSum, ");
sql.append(" sum(to_number(t.TranCountCM)) CountCMSum, ");
sql.append(" sum(to_number(t.TranMoneyCUN)) MoneyCUNSum, ");
sql.append(" sum(to_number(t.TranCountCUN)) CountCunSum, ");
sql.append(" sum(to_number(t.TranMoneyCTC)) MoneyCTCSum, ");
sql.append(" sum(to_number(t.TranCountCTC)) CountCTCSum, ");
sql.append(" sum(to_number(t.TranMoneyTotal)) MoneyTotalSum, ");
sql.append(" sum(to_number(t.TranCountTotal)) CountTotalSum ");
sql.append(" from user_checkinfo t ");
总是报ava.sql.SQLException: Invalid column name:
at oracle.jdbc.rowset.OracleCachedRowSet.getColumnIndex(OracleCachedRowSet.java:1255)
at oracle.jdbc.rowset.OracleCachedRowSet.getString(OracleCachedRowSet.java:5127)
at com.tppension.dfms.acctmgr.action.MerchantRzCheckOutAction.execManager(MerchantRzCheckOutAction.java:433)
at com.tppension.dfms.acctmgr.action.MerchantRzCheckOutAction.executeAction
的错误
sql.append(" sum(to_number(t.EndMoney)) EndSum, ");
sql.append(" sum(to_number(t.InMoney)) InSum, ");
sql.append(" sum(to_number(t.RtnMoney)) RtnSum, ");
sql.append(" sum(to_number(t.FixMoney)) FixSum, ");
sql.append(" sum(to_number(t.TranMoneyCM)) MoneyCMSum, ");
sql.append(" sum(to_number(t.TranCountCM)) CountCMSum, ");
sql.append(" sum(to_number(t.TranMoneyCUN)) MoneyCUNSum, ");
sql.append(" sum(to_number(t.TranCountCUN)) CountCunSum, ");
sql.append(" sum(to_number(t.TranMoneyCTC)) MoneyCTCSum, ");
sql.append(" sum(to_number(t.TranCountCTC)) CountCTCSum, ");
sql.append(" sum(to_number(t.TranMoneyTotal)) MoneyTotalSum, ");
sql.append(" sum(to_number(t.TranCountTotal)) CountTotalSum ");
sql.append(" from user_checkinfo t ");
总是报ava.sql.SQLException: Invalid column name:
at oracle.jdbc.rowset.OracleCachedRowSet.getColumnIndex(OracleCachedRowSet.java:1255)
at oracle.jdbc.rowset.OracleCachedRowSet.getString(OracleCachedRowSet.java:5127)
at com.tppension.dfms.acctmgr.action.MerchantRzCheckOutAction.execManager(MerchantRzCheckOutAction.java:433)
at com.tppension.dfms.acctmgr.action.MerchantRzCheckOutAction.executeAction
的错误
解决方案 »
- 我已经加了在jsp页面上加了<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>,但是我的<c:if...>,<c:forEach...>都不能正常运行,这是怎么回事,请帮忙解答,谢谢
- JSP读XML文件乱码
- 才开始搞spring+strurs,问几个问题,希望能得到答案
- 导入tag文件出现乱码
- 各位帮忙 各位老大:帮帮我(江湖救急)在线等待此问题对我关系重大请大家多帮忙
- Jsp页取session怎么取呀?
- 请问在JSP中如何禁止站外提交啊!我想获取提交页的名称,可是没有!!!
- 我做了一个bbs写入英文很正常可是写入中文就显示的都是问号阿 高人们我该怎么办啊
- 怎样在Eclipse里安装并使用一个插件?
- CSDN有开放的源代码
- select onchange 如何重新填充table
- XML文件存入数据库
java.sql.SQLException: Invalid column name:
这个name后面会提示具体是哪一列呀!