import java.util.List;\r
\r
\r
-import javax.persistence.EntityManagerFactory;\r
-import javax.transaction.Transactional;\r
+import jakarta.persistence.EntityManagerFactory;\r
+import jakarta.transaction.Transactional;\r
\r
import com.google.common.base.Throwables;\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.PerformanceInformation;\r
import org.onap.usecaseui.server.service.PerformanceInformationService;\r
import org.onap.usecaseui.server.util.UuiCommonUtil;\r
}\r
Query query = session.createQuery(hql);\r
if (resourceId != null && !"".equals(resourceId)){\r
- query.setString("resourceId",resourceId);\r
+ query.setParameter("resourceId",resourceId);\r
}\r
if (name != null && !"".equals(name)){\r
- query.setString("name",name);\r
+ query.setParameter("name",name);\r
}\r
if (startTime != null && !"".equals(startTime) && endTime != null && !"".equals(endTime)){\r
- query.setString("startTime", startTime).setString("endTime", endTime);\r
+ query.setParameter("startTime", startTime).setParameter("endTime", endTime);\r
}\r
logger.info("PerformanceInformationServiceImpl queryDateBetween: list={}", query.list());\r
return query.list();\r
try {\r
String string = "from PerformanceInformation a where 1=1 and a.headerId=:headerId";\r
Query query = session.createQuery(string);\r
- query.setString("headerId",headerId);\r
+ query.setParameter("headerId",headerId);\r
List<PerformanceInformation> list = query.list();\r
session.flush();\r
return list;\r
}\r
Query query = session.createQuery(hql);\r
if (sourceId != null && !"".equals(sourceId)){\r
- query.setString("resourceId",sourceId);\r
+ query.setParameter("resourceId",sourceId);\r
}\r
if (name != null && !"".equals(name)){\r
- query.setString("name",name);\r
+ query.setParameter("name",name);\r
}\r
if (startTime != null && !"".equals(startTime) && endTime != null && !"".equals(endTime)){\r
- query.setString("startTime", startTime).setString("endTime", endTime);\r
+ query.setParameter("startTime", startTime).setParameter("endTime", endTime);\r
}\r
String num=(String) query.uniqueResult();\r
return UuiCommonUtil.isNotNullOrEmpty(num)?num:0+"";\r