2 * Copyright © 2017-2018 AT&T Intellectual Property.
\r
3 * Modifications Copyright © 2018 IBM.
\r
5 * Licensed under the Apache License, Version 2.0 (the "License");
\r
6 * you may not use this file except in compliance with the License.
\r
7 * You may obtain a copy of the License at
\r
9 * http://www.apache.org/licenses/LICENSE-2.0
\r
11 * Unless required by applicable law or agreed to in writing, software
\r
12 * distributed under the License is distributed on an "AS IS" BASIS,
\r
13 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
\r
14 * See the License for the specific language governing permissions and
\r
15 * limitations under the License.
\r
18 package org.onap.ccsdk.features.data.adaptor.dao;
\r
20 import java.util.List;
\r
21 import java.util.Map;
\r
22 import org.onap.ccsdk.sli.core.sli.SvcLogicException;
\r
23 import org.springframework.beans.factory.annotation.Autowired;
\r
24 import org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate;
\r
25 import com.att.eelf.configuration.EELFLogger;
\r
26 import com.att.eelf.configuration.EELFManager;
\r
28 public class NamedQueryExecutorDaoImpl implements NamedQueryExecutorDao {
\r
29 private static EELFLogger logger = EELFManager.getInstance().getLogger(QueryExecutorDaoImpl.class);
\r
30 private static final String CLASS_NAME = "NamedQueryExecutorDaoImpl";
\r
32 @Autowired(required = true)
\r
33 private NamedParameterJdbcTemplate namedParameterJdbcTemplate;
\r
35 public NamedQueryExecutorDaoImpl(NamedParameterJdbcTemplate namedParameterJdbcTemplate) {
\r
36 this.namedParameterJdbcTemplate = namedParameterJdbcTemplate;
\r
37 logger.info("{} Constructor initialised..", CLASS_NAME);
\r
41 public List<Map<String, Object>> query(String sql, Map<String, Object> parameters) throws SvcLogicException {
\r
42 logger.debug("Query ({}) with parameters ({})", sql, parameters);
\r
43 return namedParameterJdbcTemplate.queryForList(sql, parameters);
\r
47 public NamedParameterJdbcTemplate getNamedParameterJdbcTemplate() {
\r
48 return namedParameterJdbcTemplate;
\r
52 public int update(String sql, Map<String, Object> parameters) throws SvcLogicException {
\r
53 logger.debug("update ({}) with parameters ({})", sql, parameters);
\r
54 return namedParameterJdbcTemplate.update(sql, parameters);
\r