From 28e7d3937f819a3486b22bfa1c84aee172aaccb4 Mon Sep 17 00:00:00 2001
From: java110 <928255095@qq.com>
Date: 星期一, 17 一月 2022 17:46:42 +0800
Subject: [PATCH] 优化代码
---
java110-service/src/main/java/com/java110/service/develop/notice/GetNoticesByJava.java | 7 ++++---
1 files changed, 4 insertions(+), 3 deletions(-)
diff --git a/java110-service/src/main/java/com/java110/service/develop/notice/GetNoticesByJava.java b/java110-service/src/main/java/com/java110/service/develop/notice/GetNoticesByJava.java
old mode 100644
new mode 100755
index 2974f3f..5ebc976
--- a/java110-service/src/main/java/com/java110/service/develop/notice/GetNoticesByJava.java
+++ b/java110-service/src/main/java/com/java110/service/develop/notice/GetNoticesByJava.java
@@ -7,6 +7,7 @@
import java.util.ArrayList;
import java.util.List;
+import java.util.Map;
/**
* @ClassName GetNoticesByJava
@@ -20,7 +21,7 @@
@Override
public JSONObject execute(DataQuery dataQuery) {
JSONObject params = dataQuery.getRequestParams();
- List sqlParams = new ArrayList();
+ List<Object> sqlParams = new ArrayList<Object>();
String sql = "SELECT nn.`notice_id` noticeId," +
"nn.`title`," +
@@ -44,11 +45,11 @@
sqlParams.add(params.get("userId"));
}
if(params.containsKey("title") && !StringUtils.isEmpty(params.getString("title"))){
- sql += "and nn.`notice_id` LIKE CONCAT('%',?,'%') ";
+ sql += "and nn.`title` LIKE CONCAT('%',?,'%') ";
sqlParams.add(params.get("title"));
}
- List outParam = dataQuery.queryDataBySql(sql,sqlParams);
+ List<Map<String, Object>> outParam = dataQuery.queryDataBySql(sql,sqlParams);
JSONObject outObj = new JSONObject();
outObj.put("notices", outParam);
--
Gitblit v1.8.0