aboutsummaryrefslogtreecommitdiffstats
path: root/appc-config/appc-config-generator/provider/src/main/java/org/onap/sdnc/config/generator/tool/DbServiceUtil.java
diff options
context:
space:
mode:
Diffstat (limited to 'appc-config/appc-config-generator/provider/src/main/java/org/onap/sdnc/config/generator/tool/DbServiceUtil.java')
-rw-r--r--appc-config/appc-config-generator/provider/src/main/java/org/onap/sdnc/config/generator/tool/DbServiceUtil.java71
1 files changed, 37 insertions, 34 deletions
diff --git a/appc-config/appc-config-generator/provider/src/main/java/org/onap/sdnc/config/generator/tool/DbServiceUtil.java b/appc-config/appc-config-generator/provider/src/main/java/org/onap/sdnc/config/generator/tool/DbServiceUtil.java
index c8340816e..94b346c1a 100644
--- a/appc-config/appc-config-generator/provider/src/main/java/org/onap/sdnc/config/generator/tool/DbServiceUtil.java
+++ b/appc-config/appc-config-generator/provider/src/main/java/org/onap/sdnc/config/generator/tool/DbServiceUtil.java
@@ -1,9 +1,11 @@
/*-
* ============LICENSE_START=======================================================
- * ONAP : APP-C
+ * ONAP : APPC
* ================================================================================
- * Copyright (C) 2017 AT&T Intellectual Property. All rights reserved.
+ * Copyright (C) 2017 AT&T Intellectual Property. All rights reserved.
* ================================================================================
+ * Copyright (C) 2017 Amdocs
+ * =============================================================================
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
@@ -15,59 +17,60 @@
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
+ *
+ * ECOMP is a trademark and service mark of AT&T Intellectual Property.
* ============LICENSE_END=========================================================
*/
-package org.openecomp.sdnc.config.generator.tool;
+package org.onap.sdnc.config.generator.tool;
import java.io.File;
import java.net.URL;
import java.sql.SQLException;
import java.util.ArrayList;
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;
-import org.onap.ccsdk.sli.core.dblib.DbLibService;
+public class DbServiceUtil {
+ private static final Logger log = LoggerFactory.getLogger(DbServiceUtil.class);
-public class DbServiceUtil
-{
- private static final Logger log = LoggerFactory
- .getLogger(DbServiceUtil.class);
-
private static Properties props;
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;
+
+ 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;
+ }
+
+
+ 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, 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 DBResourceManager initDbLibService() throws Exception
- {
+
+
+ public static DBResourceManager initDbLibService() throws Exception {
props = new Properties();
- File file = new File("/opt/app/bvc/properties/dblib.properties");
- URL propURL = file.toURI().toURL();
- props.load(propURL.openStream());
+ File file = new File("/opt/app/bvc/properties/dblib.properties");
+ URL propURL = file.toURI().toURL();
+ props.load(propURL.openStream());
+
+ // this is an expected difference in CCSDK
jdbcDataSource = new DBResourceManager(props);
+
return jdbcDataSource;
-
+
}