88e030b7
 王彪总
init project
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
|
package com.java110.service.develop.user;
import com.alibaba.fastjson.JSONObject;
import com.java110.service.context.DataQuery;
import com.java110.service.develop.IDevelop;
import org.apache.commons.lang.StringUtils;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;
/**
* @ClassName GetNoticesByJava
* @Description TODO
* @Author wuxw
* @Date 2019/9/8 14:31
* @Version 1.0
* add by wuxw 2019/9/8
**/
public class GetUserByJava implements IDevelop {
@Override
public JSONObject execute(DataQuery dataQuery) {
JSONObject params = dataQuery.getRequestParams();
List<Object> sqlParams = new ArrayList<Object>();
String sql = "SELECT nn.`notice_id` noticeId," +
"nn.`title`," +
"nn.`notice_type_cd` noticeTypeCd," +
"nn.`context`," +
"nn.`community_id` communityId," +
"nn.`user_id` userId," +
"nn.`start_time` startTime " +
"FROM n_notice nn\n" +
"WHERE nn.status_cd = '0'" ;
if(params.containsKey("noticeId") && !StringUtils.isEmpty(params.getString("noticeId"))){
sql += "and nn.`notice_id` = ? ";
sqlParams.add(params.get("noticeId"));
}
if(params.containsKey("communityId") && !StringUtils.isEmpty(params.getString("communityId"))){
sql += "and nn.`community_id` = ? ";
sqlParams.add(params.get("communityId"));
}
if(params.containsKey("userId") && !StringUtils.isEmpty(params.getString("userId"))){
sql += "and nn.`user_id` = ? ";
sqlParams.add(params.get("userId"));
}
if(params.containsKey("title") && !StringUtils.isEmpty(params.getString("title"))){
sql += "and nn.`title` LIKE CONCAT('%',?,'%') ";
sqlParams.add(params.get("title"));
}
List<Map<String, Object>> outParam = dataQuery.queryDataBySql(sql,sqlParams);
JSONObject outObj = new JSONObject();
outObj.put("notices", outParam);
return outObj;
}
}
|
