Esempio n. 1
0
  public void updateSlaParam(SlaParam slaParam) {

    try {

      PreparedStatement preparedStatement =
          connection.prepareStatement(
              "update casvid_slaparameters set slaparam_name=?, slaparam_unit=?, slaparam_description=?"
                  + "where slaparam_id=?");

      // Parameters start with 1

      preparedStatement.setString(1, slaParam.getSlaParamName());

      preparedStatement.setString(2, slaParam.getSlaParamUnit());

      preparedStatement.setString(3, slaParam.getSlaParamDesc());

      preparedStatement.setInt(4, slaParam.getSlaParamId());

      preparedStatement.executeUpdate();

    } catch (SQLException e) {

      e.printStackTrace();
    }
  }
Esempio n. 2
0
  public void addSlaParam(SlaParam slaParam) {

    try {

      PreparedStatement preparedStatement =
          connection.prepareStatement(
              "insert into casvid_slaparameters(slaparam_name,slaparam_unit,slaparam_description) values (?, ?, ?)");

      preparedStatement.setString(1, slaParam.getSlaParamName());

      preparedStatement.setString(2, slaParam.getSlaParamUnit());

      preparedStatement.setString(3, slaParam.getSlaParamDesc());

      preparedStatement.executeUpdate();

    } catch (SQLException e) {

      e.printStackTrace();
    }
  }