diff options
author | Jakub Dudycz <jakub.dudycz@nokia.com> | 2018-02-22 15:28:55 +0100 |
---|---|---|
committer | Patrick Brady <pb071s@att.com> | 2018-02-23 22:35:49 +0000 |
commit | f9f214d530f5d18ca1e36d5c0e12e6f048bdd24d (patch) | |
tree | 2ccaec6fe5c061b978fe5e3bc26ce24f2be47716 /appc-config/appc-encryption-tool/provider/src/main/java | |
parent | 2b4298540f9c79cc2b452023800d066c56920b52 (diff) |
DbServiceUtil sonar fixes
Change-Id: Iaeca67ccb70134ba2bac0fe04e045592d8d9efcc
Issue-ID: APPC-661
Signed-off-by: Jakub Dudycz <jakub.dudycz@nokia.com>
Diffstat (limited to 'appc-config/appc-encryption-tool/provider/src/main/java')
-rw-r--r-- | appc-config/appc-encryption-tool/provider/src/main/java/org/onap/appc/encryptiontool/wrapper/DbServiceUtil.java | 48 |
1 files changed, 21 insertions, 27 deletions
diff --git a/appc-config/appc-encryption-tool/provider/src/main/java/org/onap/appc/encryptiontool/wrapper/DbServiceUtil.java b/appc-config/appc-encryption-tool/provider/src/main/java/org/onap/appc/encryptiontool/wrapper/DbServiceUtil.java index 87d1c97c0..2849641b5 100644 --- a/appc-config/appc-encryption-tool/provider/src/main/java/org/onap/appc/encryptiontool/wrapper/DbServiceUtil.java +++ b/appc-config/appc-encryption-tool/provider/src/main/java/org/onap/appc/encryptiontool/wrapper/DbServiceUtil.java @@ -22,52 +22,46 @@ package org.onap.appc.encryptiontool.wrapper; +import com.google.common.collect.Lists; import java.io.File; +import java.io.IOException; import java.net.URL; import java.sql.SQLException; -import java.util.ArrayList; +import java.util.List; import java.util.Properties; - import javax.sql.rowset.CachedRowSet; - +import org.onap.ccsdk.sli.core.dblib.DBResourceManager; import org.slf4j.Logger; import org.slf4j.LoggerFactory; -import org.onap.ccsdk.sli.core.dblib.DBResourceManager; - -public class DbServiceUtil -{ - private static final Logger log = LoggerFactory - .getLogger(DbServiceUtil.class); +public class DbServiceUtil { - private static Properties props; + private static final Logger log = LoggerFactory.getLogger(DbServiceUtil.class); private static DBResourceManager jdbcDataSource = null; - public static boolean updateDB(String tableName, ArrayList inputArgs, - String scema, String whereClause, String setCluase) throws SQLException - { - String updatePasswordString = "update " + tableName + " set " + setCluase + " where " + whereClause ; - boolean result = jdbcDataSource.writeData(updatePasswordString, inputArgs,Constants.SCHEMA_SDNCTL); - return result; + private DbServiceUtil() {} + + public static boolean updateDB(String tableName, List<String> argList, String whereClause, String setCluase) + throws SQLException { + + String updatePasswordString = "update " + tableName + " set " + setCluase + " where " + whereClause; + return jdbcDataSource.writeData(updatePasswordString, Lists.newArrayList(argList), Constants.SCHEMA_SDNCTL); } - public static CachedRowSet getData(String tableName, ArrayList argList, String schema, - String getselectData, String getDataClasue ) throws SQLException - { - String selectQuery = "select " + getselectData + "from " + tableName + " where " + getDataClasue ; - CachedRowSet data = jdbcDataSource.getData(selectQuery, argList, schema); - return data; - } + public static CachedRowSet getData(String tableName, List<String> argList, String schema, + String getselectData, String getDataClasue) throws SQLException { + String selectQuery = "select " + getselectData + "from " + tableName + " where " + getDataClasue; + return jdbcDataSource.getData(selectQuery, Lists.newArrayList(argList), schema); + } - public static DBResourceManager initDbLibService() throws Exception - { - props = new Properties(); + + public static DBResourceManager initDbLibService() throws IOException { + Properties props = new Properties(); File file = new File("/opt/onap/appc/data/properties/dblib.properties"); URL propURL = file.toURI().toURL(); props.load(propURL.openStream()); jdbcDataSource = new DBResourceManager(props); return jdbcDataSource; } - } |