jbo数据库取值

最新推荐文章于 2019-03-20 14:47:04 发布

choubie9793

最新推荐文章于 2019-03-20 14:47:04 发布

阅读量1k

点赞数

文章标签：数据库 web.xml

原文链接：https://my.oschina.net/zhuguilin/blog/983027

版权

首先要配置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 = 2300000;
       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/983027

choubie9793

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
jbo数据库取值

首先要配置web.xml <class name="BUSINESS_APPLY" label="申请信息" keyAttributes="SERIALNO"> <attributes> <attribu...
复制链接

扫一扫