有个存储过程:
create or replace procedure SHOP_CASH_FLOW_paysum(
sums out sys_refcursor,
ORDERAUTOID in number,
shopautoId in number,
queryDate in varchar2
)
as
begin
select sum(ORDERITEM.PAIDACCOUNT) as SUM_PAIDACCOUNT into sums
from ORDER_T left join ORDERITEM on ORDER_T.AUTOID = ORDERITEM.ORDER_FK
where ORDER_T.ORDERTYPE = 'purchase.payment'
and ORDER_T.STATUS in ('ACCEPT','TRANSIT')
and ORDER_T.ENABLE = 1
and ORDER_T.SHOPAUTOID = shopautoid
and ORDERITEM.ORDERAUTOID = ORDERAUTOID
and to_char(acceptDate,'yyyy-MM-dd')= queryDate ;
dbms_output.put_line(shopautoid ||ORDERAUTOID);end ;
//得到一个和
然后java调用的时候
CallableStatement cstemt = conn
.prepareCall("{call shop_cash_flow_paysum(?,?,?,?)}");
cstemt.registerOutParameter(1, Types.VARCHAR);
cstemt.setLong(2, order.getAutoId());
cstemt.setLong(3, order.getShopAutoId());
cstemt.setString(4, queryDate);
cstemt.executeQuery();
String result =cstem.getString(1);
System.out.println(result);//打印这个和 但是总等于空 我在数据库测试 sums是等于300
问下高手 问题出在那
create or replace procedure SHOP_CASH_FLOW_paysum(
sums out sys_refcursor,
ORDERAUTOID in number,
shopautoId in number,
queryDate in varchar2
)
as
begin
select sum(ORDERITEM.PAIDACCOUNT) as SUM_PAIDACCOUNT into sums
from ORDER_T left join ORDERITEM on ORDER_T.AUTOID = ORDERITEM.ORDER_FK
where ORDER_T.ORDERTYPE = 'purchase.payment'
and ORDER_T.STATUS in ('ACCEPT','TRANSIT')
and ORDER_T.ENABLE = 1
and ORDER_T.SHOPAUTOID = shopautoid
and ORDERITEM.ORDERAUTOID = ORDERAUTOID
and to_char(acceptDate,'yyyy-MM-dd')= queryDate ;
dbms_output.put_line(shopautoid ||ORDERAUTOID);end ;
//得到一个和
然后java调用的时候
CallableStatement cstemt = conn
.prepareCall("{call shop_cash_flow_paysum(?,?,?,?)}");
cstemt.registerOutParameter(1, Types.VARCHAR);
cstemt.setLong(2, order.getAutoId());
cstemt.setLong(3, order.getShopAutoId());
cstemt.setString(4, queryDate);
cstemt.executeQuery();
String result =cstem.getString(1);
System.out.println(result);//打印这个和 但是总等于空 我在数据库测试 sums是等于300
问下高手 问题出在那
解决方案 »
- java.lang.AbstractMethodError: org.apache.xerces.dom.ElementNSImpl.setUserData
- XSD文档的转化问题
- 用jxl.jar操作excel文件的问题
- 想问下现在时下最流行最常用的JAVA开发环境是什么呀
- 如何用JAVA用设置或取消EXCEL表中单元格只读属性
- Acegi怎样做remember password?
- 初用Spring,请教Session为什么为空?
- struts问题
- 关于newInstance()调用的错误
- 多个事件调用许多类的某个方法,怎么实现优化
- 我在编写一个java连接SQL2000的时候说JdbTable无法为简析类型求助
- 我用s2sh框架同事只用struts2框架我把用户id什么的放在session里他能接到么如何接
参数没问题
sums 已经改了 不是游标 是个varchar型
改成sums out varchar2看行不行