通过 远程已解决
function getConnection(application){
var approcess= createProcess("cn.myapps.core.deploy.application.ejb.ApplicationProcess");//实例化应用业务处理类
var dtprocess= new Packages.cn.myapps.core.dynaform.dts.datasource.ejb.DataSourceProcessBean();//实例化数据源业务处理类
var appvo = approcess.doView(application);//获取应用VO对象
var sourceid =appvo.getDatasourceid();//获取应用数据源ID
var dtvo=dtprocess.doView(sourceid);
if (dtvo != null) {
var username = dtvo.getUsername();
var password = dtvo.getPassword();
var driver = dtvo.getDriverClass();
var url = dtvo.getUrl();
var poolsize = dtvo.getPoolsize();
poolsize = poolsize!=null && poolsize.length()>0? dtvo.getPoolsize() : "10";
var timeout = dtvo.getTimeout();
timeout = timeout!=null && timeout.length()>0? dtvo.getTimeout() : "5000";
var dataSource = new Packages.cn.myapps.base.dao.PersistenceUtils.getDBCPDataSource(username, password, driver, url, poolsize,timeout);
return dataSource.getConnection();
}
return null}
/**
* 调用存储过程
*/
function callMax(){
//获取连接
var maxs=0;
var conn = getConnection(getApplication());
var cs = null;
try {
var cid=getItemValueAsString("Meid");
cs = conn.prepareCall("{ call getEncoding(?,?) }");
cs.setString(1, "11e3-527e-6b85bb4b-a987-13bd8e479f23");
cs.registerOutParameter(2, Packages.java.sql.Types.VARCHAR);
cs.execute();
maxs= cs.getString(2);
} catch (e) {
} finally {
try {
if(cs != null){
cs.close();
}
if(conn != null){
conn.close();
}
} catch (ex) {
}
}
return maxs; }
callMax();
红色部分有问题 |