Пример #1
0
  private int insertCropData(CropDataDO dobj) throws ClientException {

    int returnValue = 0;
    String tableName = "c_" + dobj.getStateUT() + dobj.getDistCd();
    boolean validate = chkAndCreateCropTable(tableName);
    if (validate) {
      String sqlQuery =
          "INSERT INTO "
              + tableName
              + "( state_ut, dist_cd, tehs_cd, vill_cd, sr_no, crop_sr, crop_cd,area_irrigated, area_unirrigated)  VALUES (?, ?, ?, ?, ?, ?, ?,?, ?)";
      TransactionManagerLocal tmgr = null;
      try {
        tmgr = new TransactionManagerLocal("Holding Data Entry");
        PreparedStatement prstmt = tmgr.prepareStatement(sqlQuery);
        prstmt.setString(1, dobj.getStateUT());
        prstmt.setString(2, dobj.getDistCd());
        prstmt.setString(3, dobj.getTehsCd());
        prstmt.setString(4, dobj.getVillCd());
        prstmt.setInt(5, dobj.getSrNo());
        prstmt.setInt(6, dobj.getCropSrNo());
        prstmt.setString(7, dobj.getCropCd());
        prstmt.setDouble(8, dobj.getAreaIrrigated());
        prstmt.setDouble(9, dobj.getAreaUnIrrigated());
        tmgr.executePreparedDML();
        tmgr.commit();
        returnValue = 1;

      } catch (SQLException ex) {

        if (ex.getMessage().contains("duplicate key value")) {
          throw new ClientException("Sr No [  " + dobj.getSrNo() + "  ] is already exist.");
        } else {
          ex.printStackTrace();
        }
      } finally {
        if (tmgr != null) {
          tmgr.release();
        }
      }
    }
    return returnValue;
  }
Пример #2
0
  private int insertHoldingAndCropData(CropDataDO cropDobj, HoldingDataDO holdingDobj)
      throws ClientException {

    int returnValue = 0;
    String tableNameCrop = "c_" + cropDobj.getStateUT() + cropDobj.getDistCd();
    boolean validateCrop = chkAndCreateCropTable(tableNameCrop);
    String tableNameHolding = "h_" + holdingDobj.getStateUT() + holdingDobj.getDistCd();
    boolean validateHolding = chkAndCreateCropTable(tableNameHolding);
    if (validateCrop && validateHolding) {
      String sqlCropQuery =
          "INSERT INTO "
              + tableNameCrop
              + "( state_ut, dist_cd, tehs_cd, vill_cd, sr_no, crop_sr, crop_cd,area_irrigated, area_unirrigated)  VALUES (?, ?, ?, ?, ?, ?, ?,?, ?)";
      TransactionManagerLocal tmgr = null;
      try {
        tmgr = new TransactionManagerLocal("Crop And Holding Data Entry");
        PreparedStatement prstmt = tmgr.prepareStatement(sqlCropQuery);
        prstmt.setString(1, cropDobj.getStateUT());
        prstmt.setString(2, cropDobj.getDistCd());
        prstmt.setString(3, cropDobj.getTehsCd());
        prstmt.setString(4, cropDobj.getVillCd());
        prstmt.setInt(5, cropDobj.getSrNo());
        prstmt.setInt(6, cropDobj.getCropSrNo());
        prstmt.setString(7, cropDobj.getCropCd());
        prstmt.setDouble(8, cropDobj.getAreaIrrigated());
        prstmt.setDouble(9, cropDobj.getAreaUnIrrigated());
        tmgr.executePreparedDML();

        String sqlHoldingQuery =
            "INSERT INTO "
                + tableNameHolding
                + "(state_ut, dist_cd, tehs_cd, vill_cd, sr_no, area_sown, current_fallow,area_uncultivated, area_irrigated) VALUES (?, ?, ?, ?, ?, ?, ?,?, ?)";

        PreparedStatement prstmtHolding = tmgr.prepareStatement(sqlHoldingQuery);
        prstmtHolding.setString(1, holdingDobj.getStateUT());
        prstmtHolding.setString(2, holdingDobj.getDistCd());
        prstmtHolding.setString(3, holdingDobj.getTehsCd());
        prstmtHolding.setString(4, holdingDobj.getVillCd());
        prstmtHolding.setInt(5, holdingDobj.getSrNo());
        prstmtHolding.setDouble(6, holdingDobj.getAreaSown());
        prstmtHolding.setDouble(7, holdingDobj.getCurrentFallow());
        prstmtHolding.setDouble(8, holdingDobj.getAreaUncultivated());
        prstmtHolding.setDouble(9, holdingDobj.getAreaIrrigated());
        tmgr.executePreparedDML();
        tmgr.commit();
        returnValue = 1;

      } catch (SQLException ex) {

        if (ex.getMessage().contains("duplicate key value")) {
          throw new ClientException(
              "Crop Sr No [  "
                  + cropDobj.getSrNo()
                  + "  ] or Holding Sr No [  "
                  + holdingDobj.getSrNo()
                  + "  ]  is already exist.");
        } else {
          ex.printStackTrace();
        }
      } finally {
        if (tmgr != null) {
          tmgr.release();
        }
      }
    }
    return returnValue;
  }