Upgrade java 17

[usecase-ui/server.git] / server / src / main / java / org / onap / usecaseui / server / service / impl / AlarmsHeaderServiceImpl.java

diff --git a/server/src/main/java/org/onap/usecaseui/server/service/impl/AlarmsHeaderServiceImpl.java b/server/src/main/java/org/onap/usecaseui/server/service/impl/AlarmsHeaderServiceImpl.java
index d8e1eae..3e0777e 100755 (executable)
--- a/server/src/main/java/org/onap/usecaseui/server/service/impl/AlarmsHeaderServiceImpl.java
+++ b/server/src/main/java/org/onap/usecaseui/server/service/impl/AlarmsHeaderServiceImpl.java
@@ -21,13 +21,12 @@ import java.util.ArrayList;
 import java.util.Collections;\r
 import java.util.List;\r
 \r
-import javax.persistence.EntityManagerFactory;\r
-import javax.transaction.Transactional;\r
+import jakarta.persistence.EntityManagerFactory;\r
+import jakarta.transaction.Transactional;\r
 \r
-import org.hibernate.Query;\r
+import org.hibernate.query.Query;\r
 import org.hibernate.Session;\r
 import org.hibernate.SessionFactory;\r
-import org.hibernate.Transaction;\r
 import org.onap.usecaseui.server.bean.AlarmsHeader;\r
 import org.onap.usecaseui.server.bean.SortMaster;\r
 import org.onap.usecaseui.server.service.AlarmsHeaderService;\r
@@ -44,7 +43,7 @@ import org.springframework.stereotype.Service;
 @Transactional\r
 @org.springframework.context.annotation.Configuration\r
 @EnableAspectJAutoProxy\r
-public class AlarmsHeaderServiceImpl implements AlarmsHeaderService {\r
+public class   AlarmsHeaderServiceImpl implements AlarmsHeaderService {\r
 \r
        private static final Logger logger = LoggerFactory.getLogger(AlarmsHeaderServiceImpl.class);\r
 \r
@@ -115,8 +114,8 @@ public class AlarmsHeaderServiceImpl implements AlarmsHeaderService {
                        }\r
                        Query query = session.createQuery(count.toString());\r
                        if(UuiCommonUtil.isNotNullOrEmpty(alarmsHeader.getStartEpochMicrosec())&&UuiCommonUtil.isNotNullOrEmpty(alarmsHeader.getLastEpochMicroSec())) {\r
-                               query.setString("startTime",alarmsHeader.getStartEpochMicrosec());\r
-                               query.setString("endTime",alarmsHeader.getLastEpochMicroSec());\r
+                               query.setParameter("startTime",alarmsHeader.getStartEpochMicrosec());\r
+                               query.setParameter("endTime",alarmsHeader.getLastEpochMicroSec());\r
                        }\r
                        long q=(long)query.uniqueResult();\r
                        session.flush();\r
@@ -159,8 +158,8 @@ public class AlarmsHeaderServiceImpl implements AlarmsHeaderService {
                        logger.info("AlarmsHeaderServiceImpl queryAlarmsHeader: alarmsHeader={}", alarmsHeader);\r
                        Query query = session.createQuery(hql.toString());\r
                        if(UuiCommonUtil.isNotNullOrEmpty(alarmsHeader.getStartEpochMicrosec())&&UuiCommonUtil.isNotNullOrEmpty(alarmsHeader.getLastEpochMicroSec())) {\r
-                               query.setString("startTime",alarmsHeader.getStartEpochMicrosec());\r
-                               query.setString("endTime",alarmsHeader.getLastEpochMicroSec());\r
+                               query.setParameter("startTime",alarmsHeader.getStartEpochMicrosec());\r
+                               query.setParameter("endTime",alarmsHeader.getLastEpochMicroSec());\r
                        }\r
                        query.setFirstResult(offset);\r
                        query.setMaxResults(pageSize);\r
@@ -205,13 +204,13 @@ public class AlarmsHeaderServiceImpl implements AlarmsHeaderService {
                        //Query q=session.createQuery("update AlarmsHeader set status='"+status+"', updateTime='"+date+"' , startEpochMicrosecCleared='"+startEpochMicrosecCleared+"'  ,lastEpochMicroSecCleared='"+lastEpochMicroSecCleared+"'    where eventName='"+eventName+"' and reportingEntityName='"+reportingEntityName+"' and specificProblem ='"+specificProblem+"'");\r
             Query q=session.createQuery("update AlarmsHeader set status=:status, startEpochMicrosecCleared=:startEpochMicrosecCleared  ,lastEpochMicroSecCleared=:lastEpochMicroSecCleared    where eventName=:eventName and reportingEntityName=:reportingEntityName and specificProblem =:specificProblem");\r
 \r
-            q.setString("status",status);\r
+            q.setParameter("status",status);\r
 \r
-            q.setString("startEpochMicrosecCleared",startEpochMicrosecCleared);\r
-            q.setString("lastEpochMicroSecCleared",lastEpochMicroSecCleared);\r
-            q.setString("eventName",eventName);\r
-            q.setString("reportingEntityName",reportingEntityName);\r
-            q.setString("specificProblem",specificProblem);\r
+            q.setParameter("startEpochMicrosecCleared",startEpochMicrosecCleared);\r
+            q.setParameter("lastEpochMicroSecCleared",lastEpochMicroSecCleared);\r
+            q.setParameter("eventName",eventName);\r
+            q.setParameter("reportingEntityName",reportingEntityName);\r
+            q.setParameter("specificProblem",specificProblem);\r
 \r
 \r
             q.executeUpdate();\r
@@ -232,7 +231,7 @@ public class AlarmsHeaderServiceImpl implements AlarmsHeaderService {
                 hql+=" where a.status = :status";\r
             Query query = session.createQuery(hql);\r
             if (!status.equals("0"))\r
-                query.setString("status",status);\r
+                query.setParameter("status",status);\r
             return query.uniqueResult().toString();\r
         } catch (Exception e) {\r
             logger.error("exception occurred while performing AlarmsHeaderServiceImpl queryStatusCount. Details:" + e.getMessage());\r
@@ -247,7 +246,7 @@ public class AlarmsHeaderServiceImpl implements AlarmsHeaderService {
 \r
                        String string = "from AlarmsHeader a where 1=1 and a.id=:id";\r
                        Query q = session.createQuery(string);\r
-                       q.setString("id",id);\r
+                       q.setParameter("id",id);\r
                        AlarmsHeader alarmsHeader =(AlarmsHeader)q.uniqueResult();\r
                        return alarmsHeader;\r
 \r
@@ -263,7 +262,7 @@ public class AlarmsHeaderServiceImpl implements AlarmsHeaderService {
                try{\r
                        StringBuffer hql =new StringBuffer("from SortMaster a where 1=1 and a.sortType=:sortType");\r
                        Query query = session.createQuery(hql.toString());\r
-                       query.setString("sortType",sortType);\r
+                       query.setParameter("sortType",sortType);\r
                        List<SortMaster> list= query.list();\r
                        return list;\r
                } catch (Exception e) {\r