传参数问题

qq1198076000 · 发表于 2013-11-18 16:52:29

Connection ct=null;
         Transaction tr=null;
         CallableStatement c=null;
         System.out.print("hello");
         try{
            tr=new Transaction();
            ct=tr.getConnection("/erp/sfj/data");
         com.justep.model.Model fnModel=com.justep.model.ModelUtils.getModel("/system/logic/fn");
         c=ct.prepareCall("{call ckdsh(?,?)}");

      c.setString(1,fid);
      c.setString(2,shr);
      c.registerOutParameter(3,java.sql.Types.INTEGER);
      c.execute();
      int res=c.getInt(3);
      if(res==1){
        return "审核成功";}
      if(res==2){
        return "单据已审核,不能重复审核";}
      if(res==3){
        return "请先保存";}
      System.out.print(res);
      return"审核失败";

            }catch(Exception e){

            e.printStackTrace();
            return "审核失败";
            }finally{
            try{if(null!=c){
            c.close();}
            if(null!=ct) ct.close();
            }catch(Exception e){}
            }
}

出错提示：  wrong number of arguments

qq1198076000 · 发表于 2013-11-18 16:54:00

Connection ct=null;
         Transaction tr=null;
         CallableStatement c=null;
         System.out.print("hello");
         try{
            tr=new Transaction();
            ct=tr.getConnection("/erp/sfj/data");
         com.justep.model.Model fnModel=com.justep.model.ModelUtils.getModel("/system/logic/fn");
         c=ct.prepareCall("{call ckdsh(?,?,?)}");

      c.setString(1,fid);
      c.setString(2,shr);
      c.registerOutParameter(3,java.sql.Types.INTEGER);
      c.execute();
      int res=c.getInt(3);
      if(res==1){
        return "审核成功";}
      if(res==2){
        return "单据已审核,不能重复审核";}
      if(res==3){
        return "请先保存";}
      System.out.print(res);
      return"审核失败";

            }catch(Exception e){

            e.printStackTrace();
            return "审核失败";
            }finally{
            try{if(null!=c){
            c.close();}
            if(null!=ct) ct.close();
            }catch(Exception e){}
            }
}
上面那个错了，重新发一下。
ckdsh存储过程，是3个参数，前2个传入string，最后一个输出int
不知道哪里是不是不对。

qq1198076000 · 发表于 2013-11-18 16:54:19

url:/UI/system/service/common/bizAction.j
param:Error: {"message":"","reason":"","code":"","stack":"","messages":["wrong number of arguments"],"url":"/UI/system/service/common/bizAction.j","param":""}
at Anonymous function (http://127.0.0.1:8080/x5/$v4c0f9350688641b4ad70dc07155815ff/base/base.js?language=zh_CN:1:91308)
at cbf (http://127.0.0.1:8080/x5/$v4c0f9350688641b4ad70dc07155815ff/base/base.js?language=zh_CN:1:76631)
at Anonymous function (http://127.0.0.1:8080/x5/$v4c0f9350688641b4ad70dc07155815ff/base/base.js?language=zh_CN:1:76842)
at Anonymous function (http://127.0.0.1:8080/x5/$v4c0f9350688641b4ad70dc07155815ff/base/base.js?language=zh_CN:1:79829)
at trigger7Click (http://127.0.0.1:8080/x5/$v8e205261e70746e2a7e6dafeb4b133d1/UI/erp/sfj/process/ckd/mainActivity.js?language=zh_CN:49:2)
at Anonymous function (http://127.0.0.1:8080/x5/$v9f6dd3a9b73a4da09d6cad8b3becc69c/UI/erp/sfj/process/ckd/.cache/mainActivity_zh_CN_x5_26f097181b0d4000bbbcaa4deb0defb0.js?language=zh_CN&$version=61fbb91b-842b-4dea-8c6b-14806f6f33f9:432:106)
at Anonymous function (http://127.0.0.1:8080/x5/$v72bf122054224a99aceddb14dd1b874f/form/form.js?language=zh_CN:1:409831)
at Anonymous function (http://127.0.0.1:8080/x5/$v72bf122054224a99aceddb14dd1b874f/form/form.js?language=zh_CN:1:353806)
at Anonymous function (http://127.0.0.1:8080/x5/$v72bf122054224a99aceddb14dd1b874f/form/form.js?language=zh_CN:1:462211)
at Anonymous function (http://127.0.0.1:8080/x5/$v72bf122054224a99aceddb14dd1b874f/form/form.js?language=zh_CN:1:238028)

wangyutao · 发表于 2013-11-21 14:39:32

如果不是工程项目管理相关的问题，请到开发者论坛板块发帖。
如果是，请明确哪个功能的问题

qq1198076000 · 发表于 2013-12-24 09:41:18

请结贴

		自动登录	找回密码
密码			注册