jbo数据库取值_IT分享知识网

大家好，欢迎来到IT知识分享网。

首先要配置web.xml

这是数据库配置的申请表信息

2.建立类连接

public class JBOUtil {

   public final static String JBO_BUSINESS_APPLY = “jbo.app.BUSINESS_APPLY”;
   public final static String JBO_CUSTOMER_INFO = “jbo.customer.CUSTOMER_INFO”;
   public final static String JBO_IND_INFO = “jbo.customer.IND_INFO”;
   public final static String JBO_ACCT_RATE_SEGMENT = “jbo.acct.ACCT_RATE_SEGMENT”;
   public final static String JBO_DEYUNSHENG_RECORD = “jbo.app.DEYUNSHENG_RECORD”;
   public final static String JBO_LIMIT_RANK_WORKAGE = “jbo.app.LIMIT_RANK_WORKAGE”;
   public final static String JBO_ACCT_BUSINESS_ACCOUNT = “jbo.acct.ACCT_BUSINESS_ACCOUNT”;
   public final static String JBO_ACCT_RPT_SEGMENT = “jbo.acct.ACCT_RPT_SEGMENT”;
   public static final String JBO_PRD_SPECIFIC_LIBRARY = “jbo.prd.PRD_SPECIFIC_LIBRARY”;
   public final static String JBO_FLOW_TASK = “jbo.sys.FLOW_TASK”;
   public final static String JBO_DOC_LIBRARY = “jbo.doc.DOC_LIBRARY”;
   public final static String JBO_DOC_ATTACHMENT = “jbo.doc.DOC_ATTACHMENT”;
   public final static String JBO_DOC_RELATIVE = “jbo.doc.DOC_RELATIVE”;
   public static final String JBO_BUSINESS_CONTRACT = “jbo.app.BUSINESS_CONTRACT”;
   public static final String JBO_LIMIT_PRD_LIBRARY = “jbo.prd.LIMIT_PRD_LIBRARY”;
   public static final String JBO_INTEREST_RATE_CHANGE = “jbo.app.INTEREST_RATE_CHANGE”;
}
3.最后是类方法调用数据库的数据

public static double getSysCalLimit(String baSerialno) throws Exception{

       BizObjectManager bmBA = JBOFactory.getBizObjectManager(JBOUtil.JBO_BUSINESS_APPLY);
       BizObject boBA = bmBA.createQuery(” serialno=:serialno”).setParameter(“serialno”, baSerialno).getSingleResult(false);
       double businessSum = boBA.getAttribute(“BUSINESSSUM”).getDouble();
       double limitIncomeLiabiltyRate = boBA.getAttribute(“LIABILITIES”).getDouble();
       /*if(limitIncomeLiabiltyRate==0){

           return businessSum;//限制收入比为0或为空时返回原申请金额
       }*/
       String customerId = boBA.getAttribute(“CUSTOMERID”).getString();
       int businessTerm = boBA.getAttribute(“BUSINESSTERM”).getInt();
       if(businessTerm==0){

           throw new Exception(“请确认贷款期限!”);
       }
       double monthPayment = LimitCalManage.getMonthPayment(baSerialno,businessSum,businessTerm,”RPT-01″,false);//rs/(1-1/(1+r)^m) r:月利率 s:申请金额 m:贷款期限
       double newMonthPayment = getNewMonthPayment(baSerialno,customerId,limitIncomeLiabiltyRate);
       double newBusinessSum = businessSum*newMonthPayment/monthPayment;
       if(newBusinessSum<0){

           return -1;
       }
       double maxBusinessSum = ;
       System.err.println(“businessSum–>”+businessSum);
       System.err.println(“limitIncomeLiabiltyRate–>”+limitIncomeLiabiltyRate);
       System.err.println(“businessTerm–>”+businessTerm);
       System.err.println(“monthPayment–>”+monthPayment);
       System.err.println(“newMonthPayment–>”+newMonthPayment);
       System.err.println(“newBusinessSum–>”+newBusinessSum);

       return Math.min(maxBusinessSum, newBusinessSum);
   }

转载于:https://my.oschina.net/zhuguilin/blog/

免责声明：本站所有文章内容,图片，视频等均是来源于用户投稿和互联网及文摘转载整编而成，不代表本站观点，不承担相关法律责任。其著作权各归其原作者或其出版社所有。如发现本站有涉嫌抄袭侵权/违法违规的内容,侵犯到您的权益，请在线联系站长,一经查实,本站将立刻删除。本文来自网络,若有侵权，请联系删除，如若转载，请注明出处：https://haidsoft.com/155552.html

jbo数据库取值

相关推荐

发表回复