summaryrefslogtreecommitdiffstats
path: root/appc-config/appc-encryption-tool/provider/src/main/java
diff options
context:
space:
mode:
authorJakub Dudycz <jakub.dudycz@nokia.com>2018-02-22 15:28:55 +0100
committerPatrick Brady <pb071s@att.com>2018-02-23 22:35:49 +0000
commitf9f214d530f5d18ca1e36d5c0e12e6f048bdd24d (patch)
tree2ccaec6fe5c061b978fe5e3bc26ce24f2be47716 /appc-config/appc-encryption-tool/provider/src/main/java
parent2b4298540f9c79cc2b452023800d066c56920b52 (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.java48
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;
}
-
}