/**
   * Get the SummarySignalDefinition sequence id num. <br>
   *
   * @param dataBaseName データベース名
   * @param summarySignalDefinition summarySignal
   * @return SummarySignalDefinitionのID
   * @throws SQLException SQL 実行時に例外が発生した場合
   */
  public int selectSequenceNum(String dataBaseName, SummarySignalDefinition summarySignalDefinition)
      throws SQLException {
    int result = 0;
    String summarySignalName = summarySignalDefinition.getSummarySignalName();
    Connection conn = null;
    PreparedStatement pstmt = null;
    ResultSet rs = null;
    try {
      conn = getConnection(dataBaseName, false);

      String sql =
          "select SUMMARY_SIGNAL_ID from "
              + SUMMARY_SIGNAL_DEFINITION
              + " where SUMMARY_SIGNAL_NAME=?";
      pstmt = conn.prepareStatement(sql);
      pstmt.setString(1, summarySignalName);
      rs = pstmt.executeQuery();
      while (rs.next() == true) {
        int summarySignalId = rs.getInt(1);
        result = summarySignalId;
      }

    } finally {
      SQLUtil.closeResultSet(rs);
      SQLUtil.closeStatement(pstmt);
      SQLUtil.closeConnection(conn);
    }

    return result;
  }
예제 #2
0
  /**
   * SQL実行計画のレコードを追加します。<br>
   *
   * @param database データベース名
   * @param sqlPlan 挿入するSQL実行計画
   * @throws SQLException SQL 実行時に例外が発生した場合
   */
  public static void insert(final String database, final SqlPlan sqlPlan) throws SQLException {
    Connection conn = null;
    PreparedStatement pstmt = null;
    ResultSet rs = null;
    try {
      conn = getConnection(database);
      pstmt =
          conn.prepareStatement(
              "insert into "
                  + SQL_PLAN
                  + " (MEASUREMENT_ITEM_NAME, SQL_STATEMENT,"
                  + " EXECUTION_PLAN, GETTING_PLAN_TIME, STACK_TRACE)"
                  + " values (?,?,?,?,?)");
      PreparedStatement delegated = getDelegatingStatement(pstmt);
      // CHECKSTYLE:OFF
      String measurementItemName = sqlPlan.measurementItemName;
      String sqlStatement = sqlPlan.sqlStatement;
      String executionPlan = sqlPlan.executionPlan;
      Timestamp gettingPlanTime = sqlPlan.gettingPlanTime;
      String stackTrace = sqlPlan.stackTrace;

      delegated.setString(1, measurementItemName);
      delegated.setString(2, sqlStatement);
      delegated.setString(3, executionPlan);
      delegated.setTimestamp(4, gettingPlanTime);
      delegated.setString(5, stackTrace);
      // CHECKSTYLE:ON
      delegated.execute();
    } finally {
      SQLUtil.closeResultSet(rs);
      SQLUtil.closeStatement(pstmt);
      SQLUtil.closeConnection(conn);
    }
  }
  /**
   * Insert new Summary Signal Data
   *
   * @param dataBaseName データベース名
   * @param summarySignalDefinition summarySignalDefinition
   * @throws SQLException SQL 実行時に例外が発生した場合
   */
  public static void insert(String dataBaseName, SummarySignalDefinition summarySignalDefinition)
      throws SQLException {
    Connection conn = null;
    PreparedStatement pstmt = null;
    try {
      conn = getConnection(dataBaseName);
      String sql =
          "insert into "
              + SUMMARY_SIGNAL_DEFINITION
              + "(SUMMARY_SIGNAL_NAME, TARGET_SIGNAL_ID,SIGNAL_TYPE, PRIORITY_NO)"
              + " values (?, ?, ?, ?)";
      pstmt = conn.prepareStatement(sql);
      pstmt.setString(1, summarySignalDefinition.getSummarySignalName());

      String signalList = "";
      if (summarySignalDefinition.getSignalList() != null
          && summarySignalDefinition.getSignalList().size() > 0) {
        for (int count = 0; count < summarySignalDefinition.getSignalList().size(); count++) {
          signalList += summarySignalDefinition.getSignalList().get(count);
          if (count != summarySignalDefinition.getSignalList().size() - 1) {
            signalList += ",";
          }
        }
      }

      pstmt.setString(2, signalList);
      pstmt.setInt(SUMMARY_SIGNAL_INDEX1, summarySignalDefinition.getSummarySignalType());
      pstmt.setInt(SUMMARY_SIGNAL_INDEX2, summarySignalDefinition.getPriority());
      pstmt.execute();
    } finally {
      SQLUtil.closeStatement(pstmt);
      SQLUtil.closeConnection(conn);
    }
  }
  /**
   * update the summary signal Information by matching the name<br>
   *
   * @param dataBaseName データベース名
   * @param summarySignalId summary signal のid
   * @param summarySignalDefinitionDto summarySignalのDto
   * @param priorityFlag flag to update all data or not
   * @throws SQLException SQL 実行時に例外が発生した場合
   */
  public void update(
      String dataBaseName,
      long summarySignalId,
      SummarySignalDefinitionDto summarySignalDefinitionDto,
      boolean priorityFlag)
      throws SQLException {

    Connection conn = null;
    PreparedStatement pstmt = null;
    String sql = null;
    try {
      conn = getConnection(dataBaseName);
      if (priorityFlag) {
        sql =
            "update "
                + SUMMARY_SIGNAL_DEFINITION
                + " SET PRIORITY_NO=? where SUMMARY_SIGNAL_NAME=?";
        pstmt = conn.prepareStatement(sql);
        pstmt.setInt(1, summarySignalDefinitionDto.getPriority());
        pstmt.setString(2, summarySignalDefinitionDto.getSummarySignalName());

      } else {
        sql =
            "update "
                + SUMMARY_SIGNAL_DEFINITION
                + " SET SUMMARY_SIGNAL_NAME=?, TARGET_SIGNAL_ID=?,SIGNAL_TYPE=?, PRIORITY_NO=? where SUMMARY_SIGNAL_NAME=?";

        pstmt = conn.prepareStatement(sql);

        pstmt.setString(1, summarySignalDefinitionDto.getSummarySignalName());
        String signalList = "";
        if (summarySignalDefinitionDto.getSignalList() != null
            && summarySignalDefinitionDto.getSignalList().size() > 0) {
          for (int count = 0; count < summarySignalDefinitionDto.getSignalList().size(); count++) {
            signalList += summarySignalDefinitionDto.getSignalList().get(count);
            if (count != summarySignalDefinitionDto.getSignalList().size() - 1) {
              signalList += ",";
            }
          }
        }

        pstmt.setString(2, signalList);
        pstmt.setInt(3, summarySignalDefinitionDto.getSummmarySignalType());
        pstmt.setInt(4, summarySignalDefinitionDto.getPriority());
        pstmt.setString(5, summarySignalDefinitionDto.getSummarySignalName());
      }

      pstmt.executeUpdate();
    } finally {
      SQLUtil.closeStatement(pstmt);
      SQLUtil.closeConnection(conn);
    }
  }
 /**
  * Delete the summary signal data according to the name.<br>
  *
  * @param dataBaseName データベース名
  * @param summarySignalName summarySignalのname
  * @throws SQLException SQL 実行時に例外が発生した場合
  */
 public void delete(String dataBaseName, String summarySignalName) throws SQLException {
   Connection conn = null;
   PreparedStatement pstmt = null;
   try {
     conn = getConnection(dataBaseName, false);
     String sql = "delete from " + SUMMARY_SIGNAL_DEFINITION + " where SUMMARY_SIGNAL_NAME=?";
     pstmt = conn.prepareStatement(sql);
     pstmt.setString(1, summarySignalName);
     pstmt.execute();
   } finally {
     SQLUtil.closeStatement(pstmt);
     SQLUtil.closeConnection(conn);
   }
 }
  /**
   * Get the SummarySignalDefinition List according to the selected name.<br>
   *
   * @param dbName データベース名
   * @param summarySignalName SummarySignal名
   * @return SummarySignalDefinitionのリスト
   * @throws SQLException SQL 実行時に例外が発生した場合
   */
  public List<SummarySignalDefinition> selectByName(String dbName, String summarySignalName)
      throws SQLException {
    List<SummarySignalDefinition> result = new ArrayList<SummarySignalDefinition>();
    List<String> summarySignalList = new ArrayList<String>();
    Connection conn = null;
    PreparedStatement pstmt = null;
    ResultSet rs = null;
    String summarySignal;
    try {
      conn = getConnection(dbName, false);
      String sql = "select * from " + SUMMARY_SIGNAL_DEFINITION + " where SUMMARY_SIGNAL_NAME=?";
      pstmt = conn.prepareStatement(sql);
      pstmt.setString(1, summarySignalName);
      rs = pstmt.executeQuery();
      while (rs.next() == true) {
        // CHECKSTYLE:OFF
        SummarySignalDefinition summarySignalInfo = new SummarySignalDefinition();
        summarySignalInfo.summarySignalId = rs.getLong(1);
        summarySignalInfo.summarySignalName = rs.getString(2);
        summarySignal = rs.getString(3);
        String[] temp = null;
        temp = summarySignal.split(",");
        for (int index = 0; index < temp.length; index++) {
          summarySignalList.add(temp[index]);
        }
        summarySignalInfo.signalList = summarySignalList;
        summarySignalInfo.summarySignalType = rs.getInt(4);
        summarySignalInfo.priority = rs.getInt(5);
        // CHECKSTYLE:ON
        result.add(summarySignalInfo);
      }
    } finally {
      SQLUtil.closeResultSet(rs);
      SQLUtil.closeStatement(pstmt);
      SQLUtil.closeConnection(conn);
    }

    return result;
  }
  /**
   * Get the SummarySignalDefinition List by ordering the priority.<br>
   *
   * @param dataBaseName データベース名
   * @return SummarySignalDefinitionのリスト
   * @throws SQLException SQL 実行時に例外が発生した場合
   */
  public List<SummarySignalDefinition> selectAllByPriority(String dataBaseName)
      throws SQLException {
    List<SummarySignalDefinition> result = new ArrayList<SummarySignalDefinition>();

    Connection conn = null;
    Statement stmt = null;
    ResultSet rs = null;
    String summarySignal;
    try {
      conn = getConnection(dataBaseName, false);
      stmt = conn.createStatement();
      String sql = "select * from " + SUMMARY_SIGNAL_DEFINITION + " ORDER BY PRIORITY_NO DESC";
      rs = stmt.executeQuery(sql);
      while (rs.next() == true) {
        List<String> summarySignalList = new ArrayList<String>();
        // CHECKSTYLE:OFF
        SummarySignalDefinition summarySignalInfo = new SummarySignalDefinition();
        summarySignalInfo.summarySignalId = rs.getLong(1);
        summarySignalInfo.summarySignalName = rs.getString(2);
        summarySignal = rs.getString(3);
        String[] temp = null;
        temp = summarySignal.split(",");
        for (int index = 0; index < temp.length; index++) {
          summarySignalList.add(temp[index]);
        }
        summarySignalInfo.signalList = summarySignalList;
        summarySignalInfo.summarySignalType = rs.getInt(4);
        summarySignalInfo.priority = rs.getInt(5);
        result.add(summarySignalInfo);
      }
    } finally {
      SQLUtil.closeResultSet(rs);
      SQLUtil.closeStatement(stmt);
      SQLUtil.closeConnection(conn);
    }

    return result;
  }