@Override
public Parameter getParameter(ParameterKey key) {
Connection connection = connectionDaoService.getRiceConnection();
try (PreparedStatement stmt =
setString(
4,
key.getApplicationId(),
setString(
3,
key.getName(),
setString(
2,
key.getComponentCode(),
setString(
1,
key.getNamespaceCode(),
connection.prepareStatement(
"SELECT VAL, PARM_DESC_TXT, PARM_TYP_CD, EVAL_OPRTR_CD "
+ " FROM KRCR_PARM_T WHERE NMSPC_CD = ? AND CMPNT_CD = ? AND PARM_NM = ? AND APPL_ID = ?")))));
ResultSet result = stmt.executeQuery()) {
if (result.next()) {
Parameter p = new Parameter();
p.setParameterKey(key);
p.setValue(result.getString(1));
p.setDescription(result.getString(2));
p.setParameterTypeCode(result.getString(3));
p.setEvaluationOperatorCode(result.getString(4));
return p;
}
return null;
} catch (SQLException e) {
throw new RuntimeException(e);
}
}
@Override
public void deleteParameter(ParameterKey key) {
Connection connection = connectionDaoService.getRiceConnection();
try (PreparedStatement stmt =
setString(
4,
key.getApplicationId(),
setString(
3,
key.getName(),
setString(
2,
key.getComponentCode(),
setString(
1,
key.getNamespaceCode(),
connection.prepareStatement(
"DELETE FROM KRCR_PARM_T WHERE NMSPC_CD = ? AND CMPNT_CD = ? AND PARM_NM = ? AND APPL_ID = ?"))))); ) {
stmt.executeUpdate();
} catch (SQLException e) {
throw new RuntimeException(e);
}
}