KlServiceImpl.java
1.68 KB
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
package com.bsth.service.Kl.impl;
import com.bsth.service.Kl.KlService;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Service;
import java.util.*;
@Service
public class KlServiceImpl implements KlService {
Logger logger = LoggerFactory.getLogger(this.getClass());
@Autowired
JdbcTemplate jdbcTemplate;
@Override
public Map<String, Object> query(Map<String, Object> map) {
Map<String, Object> modelMap = new HashMap<>();
StringBuffer sql=new StringBuffer("SELECT * FROM bsth_c_kl where 1=1 ");
if(map.get("line")!=null && !map.get("line").equals("")){
sql.append(" and line_code ='"+map.get("line")+"'");
}
if(map.get("deviceId_like")!=null && !map.get("deviceId_like").equals("")){
sql.append(" and deviceId like '%"+map.get("deviceId_like")+"%'");
}
List<Map<String,Object>> query = jdbcTemplate.queryForList(sql.toString());
Integer page = Integer.valueOf(map.containsKey("page")?map.get("page").toString():"0");
int end = (page+1)*10>query.size()?query.size():(page+1)*10;
List<Map<String,Object>> result=query.subList(page*10, end);
for (Map<String, Object> m : result) {
m.put("time",m.get("createDate").toString().substring(0,19));
}
modelMap.put("dataList", result);
modelMap.put("totalPages", query.size()%10>0?query.size()/10+1:query.size()/10);
modelMap.put("code","00");
return modelMap;
}
}