From f5bbfc98b412f79e6695106f66d25fe65b3b7ba4 Mon Sep 17 00:00:00 2001
From: lxw <810412026@qq.com>
Date: 星期三, 25 十月 2023 12:05:35 +0800
Subject: [PATCH] 修改sql注入中时间格式bug
---
src/main/java/com/whyc/service/StandardFeatureCurveService.java | 30 ++++++++++--------------------
1 files changed, 10 insertions(+), 20 deletions(-)
diff --git a/src/main/java/com/whyc/service/StandardFeatureCurveService.java b/src/main/java/com/whyc/service/StandardFeatureCurveService.java
index c6c335a..1573965 100644
--- a/src/main/java/com/whyc/service/StandardFeatureCurveService.java
+++ b/src/main/java/com/whyc/service/StandardFeatureCurveService.java
@@ -116,19 +116,10 @@
return list;
}*/
public Response testTableDb() {
- Date date1 = null;
- Date date2 = null;
- Date date3 = null;
- Date date4 = null;
- try {
- date1 = ActionUtil.sdf.parse("2023-03-27 10:10:01" );
- date2 = ActionUtil.sdf.parse("2023-03-31 14:36:55");
-
- date3 = ActionUtil.sdf.parse("2022-06-25 03:47:37");
- date4 = ActionUtil.sdf.parse("2022-06-27 03:47:37");
- } catch (ParseException e) {
- e.printStackTrace();
- }
+ Date date1 = ThreadLocalUtil.parse("2020-03-22 15:11:23",1 );
+ Date date2 = ThreadLocalUtil.parse("2020-03-23 15:11:23",1);
+ Date date3 = ThreadLocalUtil.parse("2022-06-25 03:47:37",1);
+ Date date4 =ThreadLocalUtil.parse("2022-06-27 03:47:37",1);
/*2锛�3 "2020-03-22 15:11:23" "2020-03-23 15:11:23"
PwrdevAlarmHistory data=new PwrdevAlarmHistory();
data.setRecordYear("tb_pwrdev_alarm_history_2020");
@@ -177,7 +168,7 @@
param.setLimitStart(1);
param.setLimitEnd(10);
List list=subService.getListForInterface(param);*/
- /*10 2020-03-22 15:11:23 2020-03-23 15:11:23
+ /*10 2020-03-22 15:11:23 2020-03-23 15:11:23*/
PwrdevAlarmHistory data=new PwrdevAlarmHistory();
data.setRecordYear("tb_pwrdev_alarm_history_2020");
data.setAlmStartTime(date1);
@@ -196,7 +187,7 @@
data.setLimitEnd(10);
int count=subService.getCount(data);
List list=new ArrayList();
- list.add(count);*/
+ list.add(count);
/*13
DevAlarmPar param=new DevAlarmPar();
param.setRecordYear("tb_devalarm_data_history_2023_03");
@@ -501,12 +492,11 @@
typelist.add(110121);
typelist.add(110122);
List list=subService.getLevelSubList_pwr(1002,"tb_pwrdev_alarm_history_2022",typelist);*/
- /*鏃堕棿鏍煎紡娴嬭瘯1*/
+ /*鏃堕棿鏍煎紡娴嬭瘯1
String time1= ThreadLocalUtil.format(date2,2);
-
- /*鏃堕棿鏍煎紡娴嬭瘯2*/
+ /*鏃堕棿鏍煎紡娴嬭瘯2
Date date= ThreadLocalUtil.parse(time1,2);
- System.out.println(date);
- return new Response().setII(1,true,date,time1);
+ System.out.println(date);*/
+ return new Response().setII(1,true,list,null);
}
}
--
Gitblit v1.9.1