function getConnection(application){
	var process = createProcess("cn.myapps.core.deploy.application.ejb.ApplicationProcess");
	var appvo = process.doView(application);

	if (appvo != null) {
		var username = appvo.getDbusername();
		var password = appvo.getDbpassword();
		var driver = appvo.getDbdriver();
		var url = appvo.getDburl();
		var poolsize = appvo.getDbpoolsize();
		poolsize = poolsize!=null && poolsize.length()>0? appvo.getDbpoolsize() : "10";
		var timeout = appvo.getDbtimeout();
		timeout = timeout!=null && timeout.length()>0? appvo.getDbtimeout() : "5000";

		var dataSource = Packages.cn.myapps.base.dao.PersistenceUtils.getDBCPDataSource(username, password, driver, url, poolsize,timeout);
		return dataSource.getConnection();
		}
	return null;
}


 /**
  * ô洢
  */
function callMax(formname,fieldname){
  //ȡ
  var max=0; 
  var conn = getConnection(getApplication());
  var cs = null;
  try {
   var statement = conn.createStatement();
   var proced = "DROP PROCEDURE IF EXISTS sp1_"+formname+"_"+fieldname;
   statement.executeUpdate(proced);
   proced=" CREATE procedure sp1_"+formname+"_"+fieldname+"(out p int)";
   proced+=" begin select max(item_"+fieldname+") into p from tlk_"+formname+";  end";
   statement.executeUpdate(proced);

   cs = conn.prepareCall("{call sp1_"+formname+"_"+fieldname+"(?)}");
   //õһֵΪ110
   cs.registerOutParameter(1, Packages.java.sql.Types.INTEGER);
   cs.execute();
   max= cs.getInt(1);
  } catch (e) {
  } finally {
   try {
    if(cs != null){
     cs.close();
    }
    if(conn != null){
     conn.close();
    }
   } catch (ex) {
   }
  }
  return max;
}

var proced = "DROP PROCEDURE IF EXISTS sp1_"+fieldname;
proced+=" CREATE procedure sp1_"+fieldname+"(out p int)";
proced+=" begin select max(id) into p from test;  end";

