|
版本: |
BeX5V3.5 |
小版本号: |
|
|
|
数据库: |
MySQL |
服务器操作系统: |
Windows |
应用服务器: |
Tomcat |
客户端操作系统: |
Windows 7 |
浏览器: |
Chrome |
|
|
public static String byjh_auto_DbProcedure(String fid) throws NamingException, SQLException {
// 从当前上下文的事务对象中获取数据库连接
Connection conn = ModelUtils.getConnectionInTransaction("/shebeixinxi/sbjbxx/data");
// 创建一个 CallableStatement对象来调用数据库存储过程
CallableStatement stat = conn.prepareCall("{call build_byjh_procedure(?, ?)}");
try {
// 设置IN参数,参数以顺序匹配
stat.setString(1, fid);
// 执行存储过程
stat.execute();
return "调用成功!";
} finally {
stat.close();
}
}
下面是调用代码:
Model.prototype.aftermainSave = function(event) {
var mainData = this.comp("mainData");
var fID=mainData.val('fID');
var biz = require("$UI/system/lib/biz");
var options = {};
var Request=biz.Request;
var param = new Request.ActionParam();
param.setString('fid', fID);
options.parameters = param;
options.action = "byjh_auto_DbProcedure";
options.callback = function(RequestCallbackData){
RequestCallbackData.ignoreError = false;
if(RequestCallbackData.state){
var backinfo = RequestCallbackData.response;
justep.Util.hint(backinfo);
}else{
//失败
justep.Util.hint("执行失败!");
}
};
};
|
|