JS 调用存储过程的action，找不到FID

zdq · 发表于 2014-6-12 09:35:49

请问一下高手：
用js调用存储过程的action，需要表的FID，这个参数怎么获得？
action 调用存储过程的Java
public static void pWanGJQ(String FID){
  try {
Connection conn = ModelUtils.getConnectionInTransaction("/ICT/JinDGL/data");//数据源格式  比如：/system/data即data位置
      CallableStatement cstmt = conn.prepareCall("{? = call dbo.pWanGJQ(?)}");    //调用存储过程
      cstmt.registerOutParameter(1, java.sql.Types.INTEGER);  //设置输出值
      cstmt.setString(2, FID);
      cstmt.execute();
      System.out.println("RETURN STATUS: " + cstmt.getInt(1));
   cstmt.close();
   }
   catch (Exception e) {
      e.printStackTrace();
}
}

JS调用action
mainActivity.flwAdvanceCommit = function(event){
var FID = justep.xbl("dataMaster").getID();
var param = new justep.Request.ActionParam();
param.setString("TGongCJDQR", FID);
justep.Request.sendBizRequest2({
dataType: "json",
action: "erpCodeAction",
parameters:param,
callback: function(result) {
      if (result.state) {       justep.xbl("dataMaster").setValue("pWanGJQ",result.response);
//这里result.response为action传递过来的值
      } else {
         throw new Error(result.response.message);
      }
}

});
};

yinlun · 发表于 2014-6-12 09:38:05

问题在你的参数名不同，当然取不到值了

把public static void pWanGJQ(String FID){的参数名改成public static void pWanGJQ(String TGongCJDQR)
或者
把param.setString("TGongCJDQR", FID)改成param.setString("FID", FID);

zf_fz · 发表于 2014-6-12 09:38:28

把 TGongCJDQR 改成 FID

jason2014 · 发表于 2014-6-12 09:44:28

param.setString("TGongCJDQR", FID);
"TGongCJDQR"对应action的参数名，必须一样

zdq · 发表于 2014-6-12 09:51:19

谢谢高手们，除了这个错误，js和action其他地方有没有错的？

fpj · 发表于 2014-6-12 09:59:15

zdq 发表于 2014-6-12 09:51
谢谢高手们，除了这个错误，js和action其他地方有没有错的？

FID应该是你的概念中的主键，你要用主键，你可以进行用概念名称即可；
需要注意的是，概念名与关系名是区别大小写的；

至于你的程序还有没有其它问题，你可以运行一下看看，报不报错即可；
如果报错，贴一下你TOMCAT中的信息，看一下。

zdq · 发表于 2014-6-12 11:21:35

报错，一大堆乱码

编译模块"/ICT/JinDGL/logic/code"中的类"JinDGL"出错
E:\ICT0611\ICT\model\BIZ\ICT\JinDGL\logic\code\dsrc\JinDGL.java:13: 找不到符号
符号：变量 ModelUtils
位置：类 JinDGL
Connection conn = ModelUtils.getConnectionInTransaction("/ICT/JinDGL/data");//鏁版嵁婧愭牸寮� 姣斿锛�/system/data鍗砫ata浣嶇疆
^
1 错误
Error: 编译模块"/ICT/JinDGL/logic/code"中的类"JinDGL"出错
E:\ICT0611\ICT\model\BIZ\ICT\JinDGL\logic\code\dsrc\JinDGL.java:13: 找不到符号
符号：变量 ModelUtils
位置：类 JinDGL
Connection conn = ModelUtils.getConnectionInTransaction("/ICT/JinDGL/data");//鏁版嵁婧愭牸寮� 姣斿锛�/system/data鍗砫ata浣嶇疆
^
1 错误

at Object.justep.Request.sendBizRequest2.callback (http://localhost:8080/x5/$v9ffd10df693d4ca99587a066d4394712/UI/ICT/JinDGL/process/GongCJDQR/mainActivity.js?language=zh_CN:47:19)
at cbf (http://localhost:8080/x5/$vf23cd71d8fee4513a93d812e92320704/base/base.js?language=zh_CN:1:41796)
at Object.sendRequest2 (http://localhost:8080/x5/$vf23cd71d8fee4513a93d812e92320704/base/base.js?language=zh_CN:1:42040)
at Object.sendBizRequest2 (http://localhost:8080/x5/$vf23cd71d8fee4513a93d812e92320704/base/base.js?language=zh_CN:1:82391)
at mainActivity.flwAdvanceCommit (http://localhost:8080/x5/$v9ffd10df693d4ca99587a066d4394712/UI/ICT/JinDGL/process/GongCJDQR/mainActivity.js?language=zh_CN:40:17)
at z [as ev_onadvancecommit] (http://localhost:8080/x5/$v40275acd8d9e4b6e975716d9603d26c2/form/form.js?language=zh_CN:1:77516)
at obj.(anonymous function) [as callEvent] (http://localhost:8080/x5/$v40275acd8d9e4b6e975716d9603d26c2/form/form.js?language=zh_CN:1:77243)
at Object.options.callback (http://localhost:8080/x5/$ve7ceeebcc57441239676543565a6626a/UI/system/components/process/process.js?language=zh_CN:1577:12)
at Object._requestCallback (http://localhost:8080/x5/$vf23cd71d8fee4513a93d812e92320704/base/base.js?language=zh_CN:1:53383)
at Object.endBatch (http://localhost:8080/x5/$vf23cd71d8fee4513a93d812e92320704/base/base.js?language=zh_CN:1:76346)

zdq · 发表于 2014-6-12 11:27:33

2014-06-12 11:24:01 action:<?xml version="1.0" encoding="UTF-8"?>
<action direct-execute="false" process="/ICT/JinDGL/process/GongCJDQR/gongCJDQRProcess" activity="mainActivity" action-flag="__action_0__" executor="PSN01" execute-context="" name="pWanGJQ"><parameters xmlns:xbiz="http://www.justep.com/xbiz#"><parameter name="FID"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"/></parameter></parameters></action>
com.justep.exception.BusinessException: 编码: JUSTEP151044; 提示: 编译模块"/ICT/JinDGL/logic/code"中的类"JinDGL"出错
E:\ICT0611\ICT\model\BIZ\ICT\JinDGL\logic\code\dsrc\JinDGL.java:11: 找不到符号
符号：变量 ModelUtils
位置：类 JinDGL
Connection conn = ModelUtils.getConnectionInTransaction("/ICT/JinDGL/data");
^
1 错误
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.model.impl.ModelImpl$DynamicClassManager.compile(Unknown Source)
at com.justep.model.impl.ModelImpl$DynamicClassManager.getDynamicClass(Unknown Source)
at com.justep.model.impl.ModelImpl$DynamicClassManager.getDynamicMethod(Unknown Source)
at com.justep.model.impl.ModelImpl.getModelMethod(Unknown Source)
at com.justep.system.action.Engine.invokeActions(Native Method)
at com.justep.system.action.Engine.invokeActions(Unknown Source)
at com.justep.business.server.BusinessServer.doAction(Unknown Source)
at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
at com.justep.business.server.BusinessServer.excute(Unknown Source)
at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:595)

jishuang · 发表于 2014-6-12 11:56:47

java文件所在dsrc目录右键用作源码路径，根据错误提示导入包

zdq · 发表于 2014-6-12 11:58:17

jishuang 发表于 2014-6-12 11:56
java文件所在dsrc目录右键用作源码路径，根据错误提示导入包

高手这个包刚才导入了还是不行您能帮忙远程一下么

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

[结贴] JS 调用存储过程的action，找不到FID

评分

评分

评分