Example #1
0
  public void doJob() {
    String url = "jdbc:mysql://192.168.51.145:3306/product";
    String jdbcDriver = "com.mysql.jdbc.Driver";
    String user = "******";
    String password = "******";

    DbUtils.loadDriver(jdbcDriver);
    Connection conn = null;

    try {
      conn = (Connection) DriverManager.getConnection(url, user, password);
    } catch (SQLException e) {
      e.printStackTrace();
      System.out.println("连接MySQL失败,url=" + url);
      Tool.exitSystem();
    }

    String sql =
        "select asset_id,asset_name,borrower_uid,borrower_name,total_amount,"
            + "annual_rate,add_rate,phase_total,phase_mode,repay_mode,"
            + "full_time "
            + "from product.t_assets where asset_id=%d";
    QueryRunner qr = new QueryRunner();
    ResultSetHandler<List<AssetInfo>> handler = new BeanListHandler<AssetInfo>(AssetInfo.class);
    List<AssetInfo> assets = null;
    try {
      assets = qr.query(conn, sql, handler);
    } catch (SQLException e) {
      e.printStackTrace();
      System.out.println("SQL查询错误,sql=" + sql);
      Tool.exitSystem();
    }

    // System.out.println(loans);

    //		Tool.initUidMapFromLoans(assets);

    for (AssetInfo asset : assets) {
      long capital = asset.total_amount;
      long annualRate = asset.annual_rate;
      long periods = asset.phase_total;
      long periodType = asset.phase_mode;
      String valueDate = "2016-09-21 00:00:00";
      int repaymentMode = asset.repay_mode;
      RepaymentSchedule rs =
          new RepaymentSchedule(capital, annualRate, periods, periodType, valueDate);
      rs.calRepaymentSchedule(repaymentMode);
      List<Repayment> repayments = rs.getRepaymentList();
      checkRepayments(conn, asset, repayments);
    }

    try {
      conn.close();
    } catch (SQLException e) {
      e.printStackTrace();
      System.out.println("关闭MySQL连接失败");
      Tool.exitSystem();
    }

    saveFile();
  }
Example #2
0
  public void saveFile() {
    // 标旧id,标题,借款本金,年化利率,加息利率,还款方式,期数类型,借款期数,标新id,借款人姓名,借款人旧uid,借款人新uid,还款期号,旧本金,新本金,本金差额,旧利息,新利息,利息差额,总差额
    StringBuffer fileDispatch = new StringBuffer();
    fileDispatch.append(
        "标旧id,标题,借款本金,年化利率,加息利率,还款方式,期数类型,借款期数,标新id,借款人姓名,借款人旧uid,借款人新uid,还款期号,旧本金,新本金,本金差额,旧利息,新利息,利息差额,总差额");
    fileDispatch.append("\n");

    StringBuffer sumFileDispatch = new StringBuffer();
    sumFileDispatch.append("借款人姓名,借款人旧uid,借款人新uid,总差额");
    sumFileDispatch.append("\n");

    StringBuffer fileFixPrincipalSqls = new StringBuffer();
    StringBuffer fileFixInterestSqls = new StringBuffer();

    Map<String, DispatchInfo> sumDispatch = new HashMap<String, DispatchInfo>();

    for (DispatchInfo dispatch : dispatchs) {

      if (dispatch.diffPrincipal > 0) {
        String fixSql =
            String.format(
                "update product.t_repayments set expect_principal=%d+%d where asset_id=%d and borrower_uid=%d and phase=%d and state=0 and expect_principal=%d;",
                Tool.getMoney(dispatch.oldPrincipal),
                dispatch.diffPrincipal,
                dispatch.newAssetId,
                dispatch.newBorrowerUid,
                dispatch.phase,
                Tool.getMoney(dispatch.oldPrincipal));
        fileFixPrincipalSqls.append(fixSql);
        fileFixPrincipalSqls.append("\n");

        fixSql =
            String.format(
                "update product.t_repayment_%02d set expect_principal=%d+%d where asset_id=%s and borrower_uid=%s and phase=%d and state=0 and expect_principal=%d;",
                dispatch.newBorrowerUid % 100,
                Tool.getMoney(dispatch.oldPrincipal),
                dispatch.diffPrincipal,
                dispatch.newAssetId,
                dispatch.newBorrowerUid,
                dispatch.phase,
                Tool.getMoney(dispatch.oldPrincipal));
        fileFixPrincipalSqls.append(fixSql);
        fileFixPrincipalSqls.append("\n");
      }

      if (dispatch.diffInterest > 0) {
        String fixSql =
            String.format(
                "update product.t_repayments set expect_interest=%d+%d where asset_id=%d and borrower_uid=%d and phase=%d and state=0 and expect_interest=%d;",
                Tool.getMoney(dispatch.oldInterest),
                dispatch.diffInterest,
                dispatch.newAssetId,
                dispatch.newBorrowerUid,
                dispatch.phase,
                Tool.getMoney(dispatch.oldInterest));
        fileFixInterestSqls.append(fixSql);
        fileFixInterestSqls.append("\n");

        fixSql =
            String.format(
                "update product.t_repayment_%02d set expect_interest=%d+%d where asset_id=%s and borrower_uid=%s and phase=%d and state=0 and expect_interest=%d;",
                dispatch.newBorrowerUid % 100,
                Tool.getMoney(dispatch.oldInterest),
                dispatch.diffInterest,
                dispatch.newAssetId,
                dispatch.newBorrowerUid,
                dispatch.phase,
                Tool.getMoney(dispatch.oldInterest));
        fileFixInterestSqls.append(fixSql);
        fileFixInterestSqls.append("\n");
      }

      if (dispatch.diffTotal > 0) {
        fileDispatch.append(dispatch.getOut());
        fileDispatch.append("\n");

        DispatchInfo dispatchInfo = sumDispatch.get(String.valueOf(dispatch.newBorrowerUid));
        if (null == dispatchInfo) {
          dispatchInfo = dispatch;
          sumDispatch.put(String.valueOf(dispatch.newBorrowerUid), dispatch);
        } else {
          dispatchInfo.diffTotal += dispatch.diffTotal;
        }
      }
    }

    try {
      if (fileDispatch.length() > 0) {
        File w = new File("D:\\job_projects\\python\\asset_dispatch_money.dat");
        FileWriter fw = new FileWriter(w.getAbsoluteFile());
        BufferedWriter bw = new BufferedWriter(fw);
        bw.write(fileDispatch.toString());
        bw.close();
      }
    } catch (Exception e) {
      e.printStackTrace();
      System.out.println("保存文件失败-散标还款修复,D:\\job_projects\\python\\asset_dispatch_money.dat");
      Tool.exitSystem();
    }

    Iterator<Map.Entry<String, DispatchInfo>> iterator2 = sumDispatch.entrySet().iterator();
    while (iterator2.hasNext()) {
      Map.Entry<String, DispatchInfo> entry = iterator2.next();
      DispatchInfo dispatchInfo = entry.getValue();
      sumFileDispatch.append(dispatchInfo.getSumOut());
      sumFileDispatch.append("\n");
    }

    try {
      if (sumFileDispatch.length() > 0) {
        File w = new File("D:\\job_projects\\python\\asset_sum_dispatch_money.dat");
        FileWriter fw = new FileWriter(w.getAbsoluteFile());
        BufferedWriter bw = new BufferedWriter(fw);
        bw.write(sumFileDispatch.toString());
        bw.close();
      }
    } catch (Exception e) {
      e.printStackTrace();
      System.out.println("保存文件失败-散标还款修复,D:\\job_projects\\python\\asset_sum_dispatch_money.dat");
      Tool.exitSystem();
    }

    try {
      if (fileFixPrincipalSqls.length() > 0) {
        File w = new File("D:\\job_projects\\python\\asset_fix_principal_sqls.dat");
        FileWriter fw = new FileWriter(w.getAbsoluteFile());
        BufferedWriter bw = new BufferedWriter(fw);
        bw.write(fileFixPrincipalSqls.toString());
        bw.close();
      }
    } catch (Exception e) {
      e.printStackTrace();
      System.out.println("保存文件失败-散标还款修复,D:\\job_projects\\python\\asset_fix_principal_sqls.dat");
      Tool.exitSystem();
    }

    try {
      if (fileFixInterestSqls.length() > 0) {
        File w = new File("D:\\job_projects\\python\\asset_fix_interest_sqls.dat");
        FileWriter fw = new FileWriter(w.getAbsoluteFile());
        BufferedWriter bw = new BufferedWriter(fw);
        bw.write(fileFixInterestSqls.toString());
        bw.close();
      }
    } catch (Exception e) {
      e.printStackTrace();
      System.out.println("保存文件失败-散标还款修复,D:\\job_projects\\python\\asset_fix_interest_sqls.dat");
      Tool.exitSystem();
    }
  }