From dbc28ad9f10a7e4ae3d1c837f721b168343e961e Mon Sep 17 00:00:00 2001 From: fengxiang <fengxiang@blit.7drlb> Date: Wed, 25 Oct 2017 14:41:31 +0800 Subject: [PATCH] 修正 --- src/main/java/com/moral/monitor/service/LoggerService.java | 9 src/main/java/com/moral/monitor/entity/MonitorpointExample.java | 1011 +++++++++++ src/main/java/com/moral/monitor/entity/History.java | 53 src/main/java/com/moral/monitor/dao/MonitorpointDao.java | 30 src/main/java/com/moral/monitor/entity/Logger.java | 45 src/main/resources/mapper/EquipmentMapper.java | 30 src/main/java/com/moral/monitor/service/impl/LoggerServiceImpl.java | 22 src/main/java/com/moral/monitor/entity/Equipment.java | 99 src/main/java/com/moral/monitor/entity/SensorExample.java | 880 +++++++++ src/main/java/com/moral/monitor/service/HistoryService.java | 9 src/main/java/com/moral/monitor/controller/ApiController.java | 4 src/main/java/com/moral/monitor/controller/MgrController.java | 8 src/main/java/com/moral/monitor/entity/HistoryExample.java | 591 ++++++ src/main/java/com/moral/monitor/controller/Dashboard.java | 16 src/main/java/com/moral/monitor/service/EquipmentService.java | 9 src/main/java/com/moral/monitor/listener/Listener.java | 277 -- src/main/java/com/moral/monitor/entity/EquipmentExample.java | 1201 +++++++++++++ src/main/java/com/moral/monitor/dao/LoggerMapper.java | 30 src/main/java/com/moral/monitor/controller/MonitorPointController.java | 16 src/main/java/com/moral/monitor/dao/EquipmentMapper.java | 30 src/main/resources/mapper/SensorMapper.java | 30 src/main/resources/mapper/MonitorpointDao.java | 30 src/main/java/com/moral/monitor/service/impl/MonitorpointServiceImpl.java | 45 /dev/null | 35 src/main/java/com/moral/monitor/entity/Sensor.java | 143 src/main/java/com/moral/monitor/dao/TaskDao.java | 2 src/main/java/com/moral/monitor/dao/HistoryMapper.java | 30 src/main/java/com/moral/monitor/dao/MgrDao.java | 4 src/main/java/com/moral/monitor/service/MonitorpointService.java | 28 src/main/resources/mapper/HistoryMapper.java | 30 src/main/java/com/moral/monitor/listener/MonitorListener.java | 2 src/main/resources/mapper/LoggerMapper.java | 30 src/main/java/com/moral/monitor/entity/LoggerExample.java | 461 +++++ src/main/java/com/moral/monitor/dao/SensorMapper.java | 30 src/main/java/com/moral/monitor/service/MgrService.java | 8 src/main/java/com/moral/monitor/entity/Monitorpoint.java | 125 + 36 files changed, 4,930 insertions(+), 473 deletions(-) diff --git a/src/main/java/com/moral/monitor/controller/ApiController.java b/src/main/java/com/moral/monitor/controller/ApiController.java index ef4e3ad..3744c0b 100644 --- a/src/main/java/com/moral/monitor/controller/ApiController.java +++ b/src/main/java/com/moral/monitor/controller/ApiController.java @@ -275,7 +275,7 @@ ae.setDevice_name(e.getName()); ae.setMac(e.getMac()); ae.setStatus(e.getState()); - ae.setFei(e.getFei()); +// ae.setFei(e.get); // ae.setCreate_time(DateConvert.dateConvert(e.getTime())); apiEquipments.add(ae); @@ -330,7 +330,7 @@ ae.setDevice_name(e.getName()); ae.setMac(e.getMac()); ae.setStatus(e.getState()); - ae.setFei(e.getFei()); +// ae.setFei(e.getFei()); ae.setCreate_time(DateConvert.dateConvert(e.getTime())); apiEquipments.add(ae); diff --git a/src/main/java/com/moral/monitor/controller/Dashboard.java b/src/main/java/com/moral/monitor/controller/Dashboard.java index 311a3b0..024b9e6 100644 --- a/src/main/java/com/moral/monitor/controller/Dashboard.java +++ b/src/main/java/com/moral/monitor/controller/Dashboard.java @@ -134,13 +134,13 @@ for(Equipment e:equipments){ int state = e.getState(); - if (state==0){ - e.setStatedesc("������"); - }else if(state==4){ - e.setStatedesc("������"); - }else if(state==1||state==2||state==3){ - e.setStatedesc("������"); - } +// if (state==0){ +// e.setStatedesc("������"); +// }else if(state==4){ +// e.setStatedesc("������"); +// }else if(state==1||state==2||state==3){ +// e.setStatedesc("������"); +// } } s.put("rows",equipments); @@ -357,7 +357,7 @@ for (History a:historys){ String format = sdf.format(a.getTime()); xtime.add(format); - yvalue.add(a.getMac_value()); + yvalue.add(a.getMacValue()); } s.put("xtime",xtime); s.put("yvalue",yvalue); diff --git a/src/main/java/com/moral/monitor/controller/MgrController.java b/src/main/java/com/moral/monitor/controller/MgrController.java index 3beb0fb..34454a8 100644 --- a/src/main/java/com/moral/monitor/controller/MgrController.java +++ b/src/main/java/com/moral/monitor/controller/MgrController.java @@ -27,12 +27,12 @@ @ResponseBody public Map randpoint(){ - List<MonitorPoint> randpoint = mgrService.randpoint(); + List<Monitorpoint> randpoint = mgrService.randpoint(); LinkedHashMap<String, List<Equipment>> point_equ = new LinkedHashMap<String, List<Equipment>>(); - for (MonitorPoint point:randpoint){ + for (Monitorpoint point:randpoint){ String name = point.getName(); List<Equipment> equipments = mgrService.pointequ(name); if (equipments.size()>0){ @@ -125,13 +125,13 @@ @ResponseBody public String top100(){ - List<MonitorPoint> randpoint = mgrService.allpoint(); + List<Monitorpoint> randpoint = mgrService.allpoint(); LinkedHashMap<String, List<Equipment>> point_equ = new LinkedHashMap<String, List<Equipment>>(); - for (MonitorPoint point:randpoint){ + for (Monitorpoint point:randpoint){ String name = point.getName(); List<Equipment> equipments = mgrService.pointequ(name); if (equipments.size()>0){ diff --git a/src/main/java/com/moral/monitor/controller/MonitorPointController.java b/src/main/java/com/moral/monitor/controller/MonitorPointController.java index 73b6938..0715c34 100644 --- a/src/main/java/com/moral/monitor/controller/MonitorPointController.java +++ b/src/main/java/com/moral/monitor/controller/MonitorPointController.java @@ -1,16 +1,16 @@ package com.moral.monitor.controller; -import com.moral.monitor.entity.MonitorPoint; +import com.moral.monitor.entity.Monitorpoint; import com.moral.monitor.entity.QueryHelper; -import com.moral.monitor.service.MonitorPointService; +import com.moral.monitor.service.MonitorpointService; import org.apache.commons.logging.Log; import org.apache.commons.logging.LogFactory; +import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.RequestBody; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestParam; import org.springframework.web.bind.annotation.ResponseBody; -import javax.annotation.Resource; import java.util.LinkedHashMap; import java.util.List; import java.util.Map; @@ -23,8 +23,8 @@ private static final Log log = LogFactory.getLog(MonitorPointController.class); - @Resource - MonitorPointService monitorPointService; + @Autowired + MonitorpointService monitorPointService; @RequestMapping("/findAllMonitorpoint") @ResponseBody @@ -36,7 +36,7 @@ } LinkedHashMap<String, Object> s = new LinkedHashMap<String, Object>(); - List<MonitorPoint> equs = monitorPointService.allMonitorPoint(queryHelper); + List<Monitorpoint> equs = monitorPointService.allMonitorpoint(queryHelper); s.put("rows",equs); int total = monitorPointService.monitorCount(queryHelper); @@ -69,7 +69,7 @@ @RequestMapping("/addMonitorpoint") @ResponseBody - public String addMonitorpoint(@RequestBody MonitorPoint monitorPoint){ + public String addMonitorpoint(@RequestBody Monitorpoint monitorPoint){ try { String name = monitorPoint.getName(); @@ -90,7 +90,7 @@ @RequestMapping("/editMonitorPoint") @ResponseBody - public String editMonitorPoint(@RequestBody MonitorPoint monitorPoint){ + public String editMonitorPoint(@RequestBody Monitorpoint monitorPoint){ try { monitorPointService.updateMonitorpoint(monitorPoint); }catch (Exception e){ diff --git a/src/main/java/com/moral/monitor/dao/EquipmentMapper.java b/src/main/java/com/moral/monitor/dao/EquipmentMapper.java new file mode 100644 index 0000000..8d82c75 --- /dev/null +++ b/src/main/java/com/moral/monitor/dao/EquipmentMapper.java @@ -0,0 +1,30 @@ +package com.moral.monitor.dao; + +import com.moral.monitor.entity.Equipment; +import com.moral.monitor.entity.EquipmentExample; +import java.util.List; +import org.apache.ibatis.annotations.Param; + +public interface EquipmentMapper { + long countByExample(EquipmentExample example); + + int deleteByExample(EquipmentExample example); + + int deleteByPrimaryKey(Integer id); + + int insert(Equipment record); + + int insertSelective(Equipment record); + + List<Equipment> selectByExample(EquipmentExample example); + + Equipment selectByPrimaryKey(Integer id); + + int updateByExampleSelective(@Param("record") Equipment record, @Param("example") EquipmentExample example); + + int updateByExample(@Param("record") Equipment record, @Param("example") EquipmentExample example); + + int updateByPrimaryKeySelective(Equipment record); + + int updateByPrimaryKey(Equipment record); +} \ No newline at end of file diff --git a/src/main/java/com/moral/monitor/dao/HistoryMapper.java b/src/main/java/com/moral/monitor/dao/HistoryMapper.java new file mode 100644 index 0000000..50033a9 --- /dev/null +++ b/src/main/java/com/moral/monitor/dao/HistoryMapper.java @@ -0,0 +1,30 @@ +package com.moral.monitor.dao; + +import com.moral.monitor.entity.History; +import com.moral.monitor.entity.HistoryExample; +import java.util.List; +import org.apache.ibatis.annotations.Param; + +public interface HistoryMapper { + long countByExample(HistoryExample example); + + int deleteByExample(HistoryExample example); + + int deleteByPrimaryKey(Integer id); + + int insert(History record); + + int insertSelective(History record); + + List<History> selectByExample(HistoryExample example); + + History selectByPrimaryKey(Integer id); + + int updateByExampleSelective(@Param("record") History record, @Param("example") HistoryExample example); + + int updateByExample(@Param("record") History record, @Param("example") HistoryExample example); + + int updateByPrimaryKeySelective(History record); + + int updateByPrimaryKey(History record); +} \ No newline at end of file diff --git a/src/main/java/com/moral/monitor/dao/LoggerMapper.java b/src/main/java/com/moral/monitor/dao/LoggerMapper.java new file mode 100644 index 0000000..f5526d3 --- /dev/null +++ b/src/main/java/com/moral/monitor/dao/LoggerMapper.java @@ -0,0 +1,30 @@ +package com.moral.monitor.dao; + +import com.moral.monitor.entity.Logger; +import com.moral.monitor.entity.LoggerExample; +import java.util.List; +import org.apache.ibatis.annotations.Param; + +public interface LoggerMapper { + long countByExample(LoggerExample example); + + int deleteByExample(LoggerExample example); + + int deleteByPrimaryKey(Integer id); + + int insert(Logger record); + + int insertSelective(Logger record); + + List<Logger> selectByExample(LoggerExample example); + + Logger selectByPrimaryKey(Integer id); + + int updateByExampleSelective(@Param("record") Logger record, @Param("example") LoggerExample example); + + int updateByExample(@Param("record") Logger record, @Param("example") LoggerExample example); + + int updateByPrimaryKeySelective(Logger record); + + int updateByPrimaryKey(Logger record); +} \ No newline at end of file diff --git a/src/main/java/com/moral/monitor/dao/MgrDao.java b/src/main/java/com/moral/monitor/dao/MgrDao.java index e74fd86..99c4143 100644 --- a/src/main/java/com/moral/monitor/dao/MgrDao.java +++ b/src/main/java/com/moral/monitor/dao/MgrDao.java @@ -12,12 +12,12 @@ @Repository public interface MgrDao { - public List<MonitorPoint> randpoint(); + public List<Monitorpoint> randpoint(); public List<Equipment> pointequ(String monitorpoint); public List<State> equsensorstate(@Param("mac") String mac); - public List<MonitorPoint> allpoint(); + public List<Monitorpoint> allpoint(); public List<PointAvg> allPointsData(QueryHelper queryHelper); public int pointcount(QueryHelper queryHelper); diff --git a/src/main/java/com/moral/monitor/dao/MonitorPointDao.java b/src/main/java/com/moral/monitor/dao/MonitorPointDao.java deleted file mode 100644 index 23fe58c..0000000 --- a/src/main/java/com/moral/monitor/dao/MonitorPointDao.java +++ /dev/null @@ -1,24 +0,0 @@ -package com.moral.monitor.dao; - -import com.moral.monitor.entity.Equipment; -import com.moral.monitor.entity.MonitorPoint; -import com.moral.monitor.entity.QueryHelper; -import org.springframework.stereotype.Repository; - -import java.util.List; - -/** - * Created by a on 2017/7/18. - */ -@Repository -public interface MonitorPointDao { - - public List<MonitorPoint> allMonitorPoint(QueryHelper queryHelper); - public int monitorCount(QueryHelper queryHelper); - - public void deleteMonitor(String id); - - public void addMonitorpoint(MonitorPoint monitorPoint); - - public void updateMonitorpoint(MonitorPoint monitorPoint); -} diff --git a/src/main/java/com/moral/monitor/dao/MonitorpointDao.java b/src/main/java/com/moral/monitor/dao/MonitorpointDao.java new file mode 100644 index 0000000..43c238d --- /dev/null +++ b/src/main/java/com/moral/monitor/dao/MonitorpointDao.java @@ -0,0 +1,30 @@ +package com.moral.monitor.dao; + +import java.util.List; +import org.apache.ibatis.annotations.Param; +import com.moral.monitor.entity.Monitorpoint; +import com.moral.monitor.entity.MonitorpointExample; + +public interface MonitorpointDao { + long countByExample(MonitorpointExample example); + + int deleteByExample(MonitorpointExample example); + + int deleteByPrimaryKey(String id); + + int insert(Monitorpoint record); + + int insertSelective(Monitorpoint record); + + List<Monitorpoint> selectByExample(MonitorpointExample example); + + Monitorpoint selectByPrimaryKey(String id); + + int updateByExampleSelective(@Param("record") Monitorpoint record, @Param("example") MonitorpointExample example); + + int updateByExample(@Param("record") Monitorpoint record, @Param("example") MonitorpointExample example); + + int updateByPrimaryKeySelective(Monitorpoint record); + + int updateByPrimaryKey(Monitorpoint record); +} \ No newline at end of file diff --git a/src/main/java/com/moral/monitor/dao/SensorMapper.java b/src/main/java/com/moral/monitor/dao/SensorMapper.java new file mode 100644 index 0000000..9dd3e70 --- /dev/null +++ b/src/main/java/com/moral/monitor/dao/SensorMapper.java @@ -0,0 +1,30 @@ +package com.moral.monitor.dao; + +import com.moral.monitor.entity.Sensor; +import com.moral.monitor.entity.SensorExample; +import java.util.List; +import org.apache.ibatis.annotations.Param; + +public interface SensorMapper { + long countByExample(SensorExample example); + + int deleteByExample(SensorExample example); + + int deleteByPrimaryKey(Integer id); + + int insert(Sensor record); + + int insertSelective(Sensor record); + + List<Sensor> selectByExample(SensorExample example); + + Sensor selectByPrimaryKey(Integer id); + + int updateByExampleSelective(@Param("record") Sensor record, @Param("example") SensorExample example); + + int updateByExample(@Param("record") Sensor record, @Param("example") SensorExample example); + + int updateByPrimaryKeySelective(Sensor record); + + int updateByPrimaryKey(Sensor record); +} \ No newline at end of file diff --git a/src/main/java/com/moral/monitor/dao/TaskDao.java b/src/main/java/com/moral/monitor/dao/TaskDao.java index 80b806d..4275d84 100644 --- a/src/main/java/com/moral/monitor/dao/TaskDao.java +++ b/src/main/java/com/moral/monitor/dao/TaskDao.java @@ -18,7 +18,7 @@ public void insertTohistory(String mac, String sensor, String mac_key, String mac_value); //������state��� public List<State> selectFromstate(String mac, String mac_key); - //������stata��� + //������state��� public void deleteFromstateBymacandmackey(String mac, String mac_key); //������state��� public void insertTostate(String mac, String sensor, String mac_key, String mac_value); diff --git a/src/main/java/com/moral/monitor/entity/Equipment.java b/src/main/java/com/moral/monitor/entity/Equipment.java index 62c8236..5f85f86 100644 --- a/src/main/java/com/moral/monitor/entity/Equipment.java +++ b/src/main/java/com/moral/monitor/entity/Equipment.java @@ -2,33 +2,42 @@ import java.util.Date; -/**��������� - * Created by a on 2017/4/10. - */ public class Equipment { - private int id; + private Integer id; + private String name; + private String address; - private double longitude; - private double latitude; + + private Double longitude; + + private Double latitude; + private String mac; - private String province; - private String city; - private String area; - private int state; + + private Integer state; + private Date time; + private String installer; + private String repairman; - private String fei; - private String statedesc; + private String province; + private String city; - public int getId() { + private String area; + + private String monitorpoint; + + private String ownerId; + + public Integer getId() { return id; } - public void setId(int id) { + public void setId(Integer id) { this.id = id; } @@ -37,7 +46,7 @@ } public void setName(String name) { - this.name = name; + this.name = name == null ? null : name.trim(); } public String getAddress() { @@ -45,22 +54,22 @@ } public void setAddress(String address) { - this.address = address; + this.address = address == null ? null : address.trim(); } - public double getLongitude() { + public Double getLongitude() { return longitude; } - public void setLongitude(double longitude) { + public void setLongitude(Double longitude) { this.longitude = longitude; } - public double getLatitude() { + public Double getLatitude() { return latitude; } - public void setLatitude(double latitude) { + public void setLatitude(Double latitude) { this.latitude = latitude; } @@ -69,14 +78,14 @@ } public void setMac(String mac) { - this.mac = mac; + this.mac = mac == null ? null : mac.trim(); } - public int getState() { + public Integer getState() { return state; } - public void setState(int state) { + public void setState(Integer state) { this.state = state; } @@ -93,7 +102,7 @@ } public void setInstaller(String installer) { - this.installer = installer; + this.installer = installer == null ? null : installer.trim(); } public String getRepairman() { @@ -101,23 +110,7 @@ } public void setRepairman(String repairman) { - this.repairman = repairman; - } - - public String getFei() { - return fei; - } - - public void setFei(String fei) { - this.fei = fei; - } - - public String getStatedesc() { - return statedesc; - } - - public void setStatedesc(String statedesc) { - this.statedesc = statedesc; + this.repairman = repairman == null ? null : repairman.trim(); } public String getProvince() { @@ -125,7 +118,7 @@ } public void setProvince(String province) { - this.province = province; + this.province = province == null ? null : province.trim(); } public String getCity() { @@ -133,7 +126,7 @@ } public void setCity(String city) { - this.city = city; + this.city = city == null ? null : city.trim(); } public String getArea() { @@ -141,6 +134,22 @@ } public void setArea(String area) { - this.area = area; + this.area = area == null ? null : area.trim(); } -} + + public String getMonitorpoint() { + return monitorpoint; + } + + public void setMonitorpoint(String monitorpoint) { + this.monitorpoint = monitorpoint == null ? null : monitorpoint.trim(); + } + + public String getOwnerId() { + return ownerId; + } + + public void setOwnerId(String ownerId) { + this.ownerId = ownerId == null ? null : ownerId.trim(); + } +} \ No newline at end of file diff --git a/src/main/java/com/moral/monitor/entity/EquipmentExample.java b/src/main/java/com/moral/monitor/entity/EquipmentExample.java new file mode 100644 index 0000000..9d0d255 --- /dev/null +++ b/src/main/java/com/moral/monitor/entity/EquipmentExample.java @@ -0,0 +1,1201 @@ +package com.moral.monitor.entity; + +import java.util.ArrayList; +import java.util.Date; +import java.util.List; + +public class EquipmentExample { + protected String orderByClause; + + protected boolean distinct; + + protected List<Criteria> oredCriteria; + + public EquipmentExample() { + oredCriteria = new ArrayList<Criteria>(); + } + + public void setOrderByClause(String orderByClause) { + this.orderByClause = orderByClause; + } + + public String getOrderByClause() { + return orderByClause; + } + + public void setDistinct(boolean distinct) { + this.distinct = distinct; + } + + public boolean isDistinct() { + return distinct; + } + + public List<Criteria> getOredCriteria() { + return oredCriteria; + } + + public void or(Criteria criteria) { + oredCriteria.add(criteria); + } + + public Criteria or() { + Criteria criteria = createCriteriaInternal(); + oredCriteria.add(criteria); + return criteria; + } + + public Criteria createCriteria() { + Criteria criteria = createCriteriaInternal(); + if (oredCriteria.size() == 0) { + oredCriteria.add(criteria); + } + return criteria; + } + + protected Criteria createCriteriaInternal() { + Criteria criteria = new Criteria(); + return criteria; + } + + public void clear() { + oredCriteria.clear(); + orderByClause = null; + distinct = false; + } + + protected abstract static class GeneratedCriteria { + protected List<Criterion> criteria; + + protected GeneratedCriteria() { + super(); + criteria = new ArrayList<Criterion>(); + } + + public boolean isValid() { + return criteria.size() > 0; + } + + public List<Criterion> getAllCriteria() { + return criteria; + } + + public List<Criterion> getCriteria() { + return criteria; + } + + protected void addCriterion(String condition) { + if (condition == null) { + throw new RuntimeException("Value for condition cannot be null"); + } + criteria.add(new Criterion(condition)); + } + + protected void addCriterion(String condition, Object value, String property) { + if (value == null) { + throw new RuntimeException("Value for " + property + " cannot be null"); + } + criteria.add(new Criterion(condition, value)); + } + + protected void addCriterion(String condition, Object value1, Object value2, String property) { + if (value1 == null || value2 == null) { + throw new RuntimeException("Between values for " + property + " cannot be null"); + } + criteria.add(new Criterion(condition, value1, value2)); + } + + public Criteria andIdIsNull() { + addCriterion("id is null"); + return (Criteria) this; + } + + public Criteria andIdIsNotNull() { + addCriterion("id is not null"); + return (Criteria) this; + } + + public Criteria andIdEqualTo(Integer value) { + addCriterion("id =", value, "id"); + return (Criteria) this; + } + + public Criteria andIdNotEqualTo(Integer value) { + addCriterion("id <>", value, "id"); + return (Criteria) this; + } + + public Criteria andIdGreaterThan(Integer value) { + addCriterion("id >", value, "id"); + return (Criteria) this; + } + + public Criteria andIdGreaterThanOrEqualTo(Integer value) { + addCriterion("id >=", value, "id"); + return (Criteria) this; + } + + public Criteria andIdLessThan(Integer value) { + addCriterion("id <", value, "id"); + return (Criteria) this; + } + + public Criteria andIdLessThanOrEqualTo(Integer value) { + addCriterion("id <=", value, "id"); + return (Criteria) this; + } + + public Criteria andIdIn(List<Integer> values) { + addCriterion("id in", values, "id"); + return (Criteria) this; + } + + public Criteria andIdNotIn(List<Integer> values) { + addCriterion("id not in", values, "id"); + return (Criteria) this; + } + + public Criteria andIdBetween(Integer value1, Integer value2) { + addCriterion("id between", value1, value2, "id"); + return (Criteria) this; + } + + public Criteria andIdNotBetween(Integer value1, Integer value2) { + addCriterion("id not between", value1, value2, "id"); + return (Criteria) this; + } + + public Criteria andNameIsNull() { + addCriterion("name is null"); + return (Criteria) this; + } + + public Criteria andNameIsNotNull() { + addCriterion("name is not null"); + return (Criteria) this; + } + + public Criteria andNameEqualTo(String value) { + addCriterion("name =", value, "name"); + return (Criteria) this; + } + + public Criteria andNameNotEqualTo(String value) { + addCriterion("name <>", value, "name"); + return (Criteria) this; + } + + public Criteria andNameGreaterThan(String value) { + addCriterion("name >", value, "name"); + return (Criteria) this; + } + + public Criteria andNameGreaterThanOrEqualTo(String value) { + addCriterion("name >=", value, "name"); + return (Criteria) this; + } + + public Criteria andNameLessThan(String value) { + addCriterion("name <", value, "name"); + return (Criteria) this; + } + + public Criteria andNameLessThanOrEqualTo(String value) { + addCriterion("name <=", value, "name"); + return (Criteria) this; + } + + public Criteria andNameLike(String value) { + addCriterion("name like", value, "name"); + return (Criteria) this; + } + + public Criteria andNameNotLike(String value) { + addCriterion("name not like", value, "name"); + return (Criteria) this; + } + + public Criteria andNameIn(List<String> values) { + addCriterion("name in", values, "name"); + return (Criteria) this; + } + + public Criteria andNameNotIn(List<String> values) { + addCriterion("name not in", values, "name"); + return (Criteria) this; + } + + public Criteria andNameBetween(String value1, String value2) { + addCriterion("name between", value1, value2, "name"); + return (Criteria) this; + } + + public Criteria andNameNotBetween(String value1, String value2) { + addCriterion("name not between", value1, value2, "name"); + return (Criteria) this; + } + + public Criteria andAddressIsNull() { + addCriterion("address is null"); + return (Criteria) this; + } + + public Criteria andAddressIsNotNull() { + addCriterion("address is not null"); + return (Criteria) this; + } + + public Criteria andAddressEqualTo(String value) { + addCriterion("address =", value, "address"); + return (Criteria) this; + } + + public Criteria andAddressNotEqualTo(String value) { + addCriterion("address <>", value, "address"); + return (Criteria) this; + } + + public Criteria andAddressGreaterThan(String value) { + addCriterion("address >", value, "address"); + return (Criteria) this; + } + + public Criteria andAddressGreaterThanOrEqualTo(String value) { + addCriterion("address >=", value, "address"); + return (Criteria) this; + } + + public Criteria andAddressLessThan(String value) { + addCriterion("address <", value, "address"); + return (Criteria) this; + } + + public Criteria andAddressLessThanOrEqualTo(String value) { + addCriterion("address <=", value, "address"); + return (Criteria) this; + } + + public Criteria andAddressLike(String value) { + addCriterion("address like", value, "address"); + return (Criteria) this; + } + + public Criteria andAddressNotLike(String value) { + addCriterion("address not like", value, "address"); + return (Criteria) this; + } + + public Criteria andAddressIn(List<String> values) { + addCriterion("address in", values, "address"); + return (Criteria) this; + } + + public Criteria andAddressNotIn(List<String> values) { + addCriterion("address not in", values, "address"); + return (Criteria) this; + } + + public Criteria andAddressBetween(String value1, String value2) { + addCriterion("address between", value1, value2, "address"); + return (Criteria) this; + } + + public Criteria andAddressNotBetween(String value1, String value2) { + addCriterion("address not between", value1, value2, "address"); + return (Criteria) this; + } + + public Criteria andLongitudeIsNull() { + addCriterion("longitude is null"); + return (Criteria) this; + } + + public Criteria andLongitudeIsNotNull() { + addCriterion("longitude is not null"); + return (Criteria) this; + } + + public Criteria andLongitudeEqualTo(Double value) { + addCriterion("longitude =", value, "longitude"); + return (Criteria) this; + } + + public Criteria andLongitudeNotEqualTo(Double value) { + addCriterion("longitude <>", value, "longitude"); + return (Criteria) this; + } + + public Criteria andLongitudeGreaterThan(Double value) { + addCriterion("longitude >", value, "longitude"); + return (Criteria) this; + } + + public Criteria andLongitudeGreaterThanOrEqualTo(Double value) { + addCriterion("longitude >=", value, "longitude"); + return (Criteria) this; + } + + public Criteria andLongitudeLessThan(Double value) { + addCriterion("longitude <", value, "longitude"); + return (Criteria) this; + } + + public Criteria andLongitudeLessThanOrEqualTo(Double value) { + addCriterion("longitude <=", value, "longitude"); + return (Criteria) this; + } + + public Criteria andLongitudeIn(List<Double> values) { + addCriterion("longitude in", values, "longitude"); + return (Criteria) this; + } + + public Criteria andLongitudeNotIn(List<Double> values) { + addCriterion("longitude not in", values, "longitude"); + return (Criteria) this; + } + + public Criteria andLongitudeBetween(Double value1, Double value2) { + addCriterion("longitude between", value1, value2, "longitude"); + return (Criteria) this; + } + + public Criteria andLongitudeNotBetween(Double value1, Double value2) { + addCriterion("longitude not between", value1, value2, "longitude"); + return (Criteria) this; + } + + public Criteria andLatitudeIsNull() { + addCriterion("latitude is null"); + return (Criteria) this; + } + + public Criteria andLatitudeIsNotNull() { + addCriterion("latitude is not null"); + return (Criteria) this; + } + + public Criteria andLatitudeEqualTo(Double value) { + addCriterion("latitude =", value, "latitude"); + return (Criteria) this; + } + + public Criteria andLatitudeNotEqualTo(Double value) { + addCriterion("latitude <>", value, "latitude"); + return (Criteria) this; + } + + public Criteria andLatitudeGreaterThan(Double value) { + addCriterion("latitude >", value, "latitude"); + return (Criteria) this; + } + + public Criteria andLatitudeGreaterThanOrEqualTo(Double value) { + addCriterion("latitude >=", value, "latitude"); + return (Criteria) this; + } + + public Criteria andLatitudeLessThan(Double value) { + addCriterion("latitude <", value, "latitude"); + return (Criteria) this; + } + + public Criteria andLatitudeLessThanOrEqualTo(Double value) { + addCriterion("latitude <=", value, "latitude"); + return (Criteria) this; + } + + public Criteria andLatitudeIn(List<Double> values) { + addCriterion("latitude in", values, "latitude"); + return (Criteria) this; + } + + public Criteria andLatitudeNotIn(List<Double> values) { + addCriterion("latitude not in", values, "latitude"); + return (Criteria) this; + } + + public Criteria andLatitudeBetween(Double value1, Double value2) { + addCriterion("latitude between", value1, value2, "latitude"); + return (Criteria) this; + } + + public Criteria andLatitudeNotBetween(Double value1, Double value2) { + addCriterion("latitude not between", value1, value2, "latitude"); + return (Criteria) this; + } + + public Criteria andMacIsNull() { + addCriterion("mac is null"); + return (Criteria) this; + } + + public Criteria andMacIsNotNull() { + addCriterion("mac is not null"); + return (Criteria) this; + } + + public Criteria andMacEqualTo(String value) { + addCriterion("mac =", value, "mac"); + return (Criteria) this; + } + + public Criteria andMacNotEqualTo(String value) { + addCriterion("mac <>", value, "mac"); + return (Criteria) this; + } + + public Criteria andMacGreaterThan(String value) { + addCriterion("mac >", value, "mac"); + return (Criteria) this; + } + + public Criteria andMacGreaterThanOrEqualTo(String value) { + addCriterion("mac >=", value, "mac"); + return (Criteria) this; + } + + public Criteria andMacLessThan(String value) { + addCriterion("mac <", value, "mac"); + return (Criteria) this; + } + + public Criteria andMacLessThanOrEqualTo(String value) { + addCriterion("mac <=", value, "mac"); + return (Criteria) this; + } + + public Criteria andMacLike(String value) { + addCriterion("mac like", value, "mac"); + return (Criteria) this; + } + + public Criteria andMacNotLike(String value) { + addCriterion("mac not like", value, "mac"); + return (Criteria) this; + } + + public Criteria andMacIn(List<String> values) { + addCriterion("mac in", values, "mac"); + return (Criteria) this; + } + + public Criteria andMacNotIn(List<String> values) { + addCriterion("mac not in", values, "mac"); + return (Criteria) this; + } + + public Criteria andMacBetween(String value1, String value2) { + addCriterion("mac between", value1, value2, "mac"); + return (Criteria) this; + } + + public Criteria andMacNotBetween(String value1, String value2) { + addCriterion("mac not between", value1, value2, "mac"); + return (Criteria) this; + } + + public Criteria andStateIsNull() { + addCriterion("state is null"); + return (Criteria) this; + } + + public Criteria andStateIsNotNull() { + addCriterion("state is not null"); + return (Criteria) this; + } + + public Criteria andStateEqualTo(Integer value) { + addCriterion("state =", value, "state"); + return (Criteria) this; + } + + public Criteria andStateNotEqualTo(Integer value) { + addCriterion("state <>", value, "state"); + return (Criteria) this; + } + + public Criteria andStateGreaterThan(Integer value) { + addCriterion("state >", value, "state"); + return (Criteria) this; + } + + public Criteria andStateGreaterThanOrEqualTo(Integer value) { + addCriterion("state >=", value, "state"); + return (Criteria) this; + } + + public Criteria andStateLessThan(Integer value) { + addCriterion("state <", value, "state"); + return (Criteria) this; + } + + public Criteria andStateLessThanOrEqualTo(Integer value) { + addCriterion("state <=", value, "state"); + return (Criteria) this; + } + + public Criteria andStateIn(List<Integer> values) { + addCriterion("state in", values, "state"); + return (Criteria) this; + } + + public Criteria andStateNotIn(List<Integer> values) { + addCriterion("state not in", values, "state"); + return (Criteria) this; + } + + public Criteria andStateBetween(Integer value1, Integer value2) { + addCriterion("state between", value1, value2, "state"); + return (Criteria) this; + } + + public Criteria andStateNotBetween(Integer value1, Integer value2) { + addCriterion("state not between", value1, value2, "state"); + return (Criteria) this; + } + + public Criteria andTimeIsNull() { + addCriterion("time is null"); + return (Criteria) this; + } + + public Criteria andTimeIsNotNull() { + addCriterion("time is not null"); + return (Criteria) this; + } + + public Criteria andTimeEqualTo(Date value) { + addCriterion("time =", value, "time"); + return (Criteria) this; + } + + public Criteria andTimeNotEqualTo(Date value) { + addCriterion("time <>", value, "time"); + return (Criteria) this; + } + + public Criteria andTimeGreaterThan(Date value) { + addCriterion("time >", value, "time"); + return (Criteria) this; + } + + public Criteria andTimeGreaterThanOrEqualTo(Date value) { + addCriterion("time >=", value, "time"); + return (Criteria) this; + } + + public Criteria andTimeLessThan(Date value) { + addCriterion("time <", value, "time"); + return (Criteria) this; + } + + public Criteria andTimeLessThanOrEqualTo(Date value) { + addCriterion("time <=", value, "time"); + return (Criteria) this; + } + + public Criteria andTimeIn(List<Date> values) { + addCriterion("time in", values, "time"); + return (Criteria) this; + } + + public Criteria andTimeNotIn(List<Date> values) { + addCriterion("time not in", values, "time"); + return (Criteria) this; + } + + public Criteria andTimeBetween(Date value1, Date value2) { + addCriterion("time between", value1, value2, "time"); + return (Criteria) this; + } + + public Criteria andTimeNotBetween(Date value1, Date value2) { + addCriterion("time not between", value1, value2, "time"); + return (Criteria) this; + } + + public Criteria andInstallerIsNull() { + addCriterion("installer is null"); + return (Criteria) this; + } + + public Criteria andInstallerIsNotNull() { + addCriterion("installer is not null"); + return (Criteria) this; + } + + public Criteria andInstallerEqualTo(String value) { + addCriterion("installer =", value, "installer"); + return (Criteria) this; + } + + public Criteria andInstallerNotEqualTo(String value) { + addCriterion("installer <>", value, "installer"); + return (Criteria) this; + } + + public Criteria andInstallerGreaterThan(String value) { + addCriterion("installer >", value, "installer"); + return (Criteria) this; + } + + public Criteria andInstallerGreaterThanOrEqualTo(String value) { + addCriterion("installer >=", value, "installer"); + return (Criteria) this; + } + + public Criteria andInstallerLessThan(String value) { + addCriterion("installer <", value, "installer"); + return (Criteria) this; + } + + public Criteria andInstallerLessThanOrEqualTo(String value) { + addCriterion("installer <=", value, "installer"); + return (Criteria) this; + } + + public Criteria andInstallerLike(String value) { + addCriterion("installer like", value, "installer"); + return (Criteria) this; + } + + public Criteria andInstallerNotLike(String value) { + addCriterion("installer not like", value, "installer"); + return (Criteria) this; + } + + public Criteria andInstallerIn(List<String> values) { + addCriterion("installer in", values, "installer"); + return (Criteria) this; + } + + public Criteria andInstallerNotIn(List<String> values) { + addCriterion("installer not in", values, "installer"); + return (Criteria) this; + } + + public Criteria andInstallerBetween(String value1, String value2) { + addCriterion("installer between", value1, value2, "installer"); + return (Criteria) this; + } + + public Criteria andInstallerNotBetween(String value1, String value2) { + addCriterion("installer not between", value1, value2, "installer"); + return (Criteria) this; + } + + public Criteria andRepairmanIsNull() { + addCriterion("repairman is null"); + return (Criteria) this; + } + + public Criteria andRepairmanIsNotNull() { + addCriterion("repairman is not null"); + return (Criteria) this; + } + + public Criteria andRepairmanEqualTo(String value) { + addCriterion("repairman =", value, "repairman"); + return (Criteria) this; + } + + public Criteria andRepairmanNotEqualTo(String value) { + addCriterion("repairman <>", value, "repairman"); + return (Criteria) this; + } + + public Criteria andRepairmanGreaterThan(String value) { + addCriterion("repairman >", value, "repairman"); + return (Criteria) this; + } + + public Criteria andRepairmanGreaterThanOrEqualTo(String value) { + addCriterion("repairman >=", value, "repairman"); + return (Criteria) this; + } + + public Criteria andRepairmanLessThan(String value) { + addCriterion("repairman <", value, "repairman"); + return (Criteria) this; + } + + public Criteria andRepairmanLessThanOrEqualTo(String value) { + addCriterion("repairman <=", value, "repairman"); + return (Criteria) this; + } + + public Criteria andRepairmanLike(String value) { + addCriterion("repairman like", value, "repairman"); + return (Criteria) this; + } + + public Criteria andRepairmanNotLike(String value) { + addCriterion("repairman not like", value, "repairman"); + return (Criteria) this; + } + + public Criteria andRepairmanIn(List<String> values) { + addCriterion("repairman in", values, "repairman"); + return (Criteria) this; + } + + public Criteria andRepairmanNotIn(List<String> values) { + addCriterion("repairman not in", values, "repairman"); + return (Criteria) this; + } + + public Criteria andRepairmanBetween(String value1, String value2) { + addCriterion("repairman between", value1, value2, "repairman"); + return (Criteria) this; + } + + public Criteria andRepairmanNotBetween(String value1, String value2) { + addCriterion("repairman not between", value1, value2, "repairman"); + return (Criteria) this; + } + + public Criteria andProvinceIsNull() { + addCriterion("province is null"); + return (Criteria) this; + } + + public Criteria andProvinceIsNotNull() { + addCriterion("province is not null"); + return (Criteria) this; + } + + public Criteria andProvinceEqualTo(String value) { + addCriterion("province =", value, "province"); + return (Criteria) this; + } + + public Criteria andProvinceNotEqualTo(String value) { + addCriterion("province <>", value, "province"); + return (Criteria) this; + } + + public Criteria andProvinceGreaterThan(String value) { + addCriterion("province >", value, "province"); + return (Criteria) this; + } + + public Criteria andProvinceGreaterThanOrEqualTo(String value) { + addCriterion("province >=", value, "province"); + return (Criteria) this; + } + + public Criteria andProvinceLessThan(String value) { + addCriterion("province <", value, "province"); + return (Criteria) this; + } + + public Criteria andProvinceLessThanOrEqualTo(String value) { + addCriterion("province <=", value, "province"); + return (Criteria) this; + } + + public Criteria andProvinceLike(String value) { + addCriterion("province like", value, "province"); + return (Criteria) this; + } + + public Criteria andProvinceNotLike(String value) { + addCriterion("province not like", value, "province"); + return (Criteria) this; + } + + public Criteria andProvinceIn(List<String> values) { + addCriterion("province in", values, "province"); + return (Criteria) this; + } + + public Criteria andProvinceNotIn(List<String> values) { + addCriterion("province not in", values, "province"); + return (Criteria) this; + } + + public Criteria andProvinceBetween(String value1, String value2) { + addCriterion("province between", value1, value2, "province"); + return (Criteria) this; + } + + public Criteria andProvinceNotBetween(String value1, String value2) { + addCriterion("province not between", value1, value2, "province"); + return (Criteria) this; + } + + public Criteria andCityIsNull() { + addCriterion("city is null"); + return (Criteria) this; + } + + public Criteria andCityIsNotNull() { + addCriterion("city is not null"); + return (Criteria) this; + } + + public Criteria andCityEqualTo(String value) { + addCriterion("city =", value, "city"); + return (Criteria) this; + } + + public Criteria andCityNotEqualTo(String value) { + addCriterion("city <>", value, "city"); + return (Criteria) this; + } + + public Criteria andCityGreaterThan(String value) { + addCriterion("city >", value, "city"); + return (Criteria) this; + } + + public Criteria andCityGreaterThanOrEqualTo(String value) { + addCriterion("city >=", value, "city"); + return (Criteria) this; + } + + public Criteria andCityLessThan(String value) { + addCriterion("city <", value, "city"); + return (Criteria) this; + } + + public Criteria andCityLessThanOrEqualTo(String value) { + addCriterion("city <=", value, "city"); + return (Criteria) this; + } + + public Criteria andCityLike(String value) { + addCriterion("city like", value, "city"); + return (Criteria) this; + } + + public Criteria andCityNotLike(String value) { + addCriterion("city not like", value, "city"); + return (Criteria) this; + } + + public Criteria andCityIn(List<String> values) { + addCriterion("city in", values, "city"); + return (Criteria) this; + } + + public Criteria andCityNotIn(List<String> values) { + addCriterion("city not in", values, "city"); + return (Criteria) this; + } + + public Criteria andCityBetween(String value1, String value2) { + addCriterion("city between", value1, value2, "city"); + return (Criteria) this; + } + + public Criteria andCityNotBetween(String value1, String value2) { + addCriterion("city not between", value1, value2, "city"); + return (Criteria) this; + } + + public Criteria andAreaIsNull() { + addCriterion("area is null"); + return (Criteria) this; + } + + public Criteria andAreaIsNotNull() { + addCriterion("area is not null"); + return (Criteria) this; + } + + public Criteria andAreaEqualTo(String value) { + addCriterion("area =", value, "area"); + return (Criteria) this; + } + + public Criteria andAreaNotEqualTo(String value) { + addCriterion("area <>", value, "area"); + return (Criteria) this; + } + + public Criteria andAreaGreaterThan(String value) { + addCriterion("area >", value, "area"); + return (Criteria) this; + } + + public Criteria andAreaGreaterThanOrEqualTo(String value) { + addCriterion("area >=", value, "area"); + return (Criteria) this; + } + + public Criteria andAreaLessThan(String value) { + addCriterion("area <", value, "area"); + return (Criteria) this; + } + + public Criteria andAreaLessThanOrEqualTo(String value) { + addCriterion("area <=", value, "area"); + return (Criteria) this; + } + + public Criteria andAreaLike(String value) { + addCriterion("area like", value, "area"); + return (Criteria) this; + } + + public Criteria andAreaNotLike(String value) { + addCriterion("area not like", value, "area"); + return (Criteria) this; + } + + public Criteria andAreaIn(List<String> values) { + addCriterion("area in", values, "area"); + return (Criteria) this; + } + + public Criteria andAreaNotIn(List<String> values) { + addCriterion("area not in", values, "area"); + return (Criteria) this; + } + + public Criteria andAreaBetween(String value1, String value2) { + addCriterion("area between", value1, value2, "area"); + return (Criteria) this; + } + + public Criteria andAreaNotBetween(String value1, String value2) { + addCriterion("area not between", value1, value2, "area"); + return (Criteria) this; + } + + public Criteria andMonitorpointIsNull() { + addCriterion("monitorpoint is null"); + return (Criteria) this; + } + + public Criteria andMonitorpointIsNotNull() { + addCriterion("monitorpoint is not null"); + return (Criteria) this; + } + + public Criteria andMonitorpointEqualTo(String value) { + addCriterion("monitorpoint =", value, "monitorpoint"); + return (Criteria) this; + } + + public Criteria andMonitorpointNotEqualTo(String value) { + addCriterion("monitorpoint <>", value, "monitorpoint"); + return (Criteria) this; + } + + public Criteria andMonitorpointGreaterThan(String value) { + addCriterion("monitorpoint >", value, "monitorpoint"); + return (Criteria) this; + } + + public Criteria andMonitorpointGreaterThanOrEqualTo(String value) { + addCriterion("monitorpoint >=", value, "monitorpoint"); + return (Criteria) this; + } + + public Criteria andMonitorpointLessThan(String value) { + addCriterion("monitorpoint <", value, "monitorpoint"); + return (Criteria) this; + } + + public Criteria andMonitorpointLessThanOrEqualTo(String value) { + addCriterion("monitorpoint <=", value, "monitorpoint"); + return (Criteria) this; + } + + public Criteria andMonitorpointLike(String value) { + addCriterion("monitorpoint like", value, "monitorpoint"); + return (Criteria) this; + } + + public Criteria andMonitorpointNotLike(String value) { + addCriterion("monitorpoint not like", value, "monitorpoint"); + return (Criteria) this; + } + + public Criteria andMonitorpointIn(List<String> values) { + addCriterion("monitorpoint in", values, "monitorpoint"); + return (Criteria) this; + } + + public Criteria andMonitorpointNotIn(List<String> values) { + addCriterion("monitorpoint not in", values, "monitorpoint"); + return (Criteria) this; + } + + public Criteria andMonitorpointBetween(String value1, String value2) { + addCriterion("monitorpoint between", value1, value2, "monitorpoint"); + return (Criteria) this; + } + + public Criteria andMonitorpointNotBetween(String value1, String value2) { + addCriterion("monitorpoint not between", value1, value2, "monitorpoint"); + return (Criteria) this; + } + + public Criteria andOwnerIdIsNull() { + addCriterion("owner_id is null"); + return (Criteria) this; + } + + public Criteria andOwnerIdIsNotNull() { + addCriterion("owner_id is not null"); + return (Criteria) this; + } + + public Criteria andOwnerIdEqualTo(String value) { + addCriterion("owner_id =", value, "ownerId"); + return (Criteria) this; + } + + public Criteria andOwnerIdNotEqualTo(String value) { + addCriterion("owner_id <>", value, "ownerId"); + return (Criteria) this; + } + + public Criteria andOwnerIdGreaterThan(String value) { + addCriterion("owner_id >", value, "ownerId"); + return (Criteria) this; + } + + public Criteria andOwnerIdGreaterThanOrEqualTo(String value) { + addCriterion("owner_id >=", value, "ownerId"); + return (Criteria) this; + } + + public Criteria andOwnerIdLessThan(String value) { + addCriterion("owner_id <", value, "ownerId"); + return (Criteria) this; + } + + public Criteria andOwnerIdLessThanOrEqualTo(String value) { + addCriterion("owner_id <=", value, "ownerId"); + return (Criteria) this; + } + + public Criteria andOwnerIdLike(String value) { + addCriterion("owner_id like", value, "ownerId"); + return (Criteria) this; + } + + public Criteria andOwnerIdNotLike(String value) { + addCriterion("owner_id not like", value, "ownerId"); + return (Criteria) this; + } + + public Criteria andOwnerIdIn(List<String> values) { + addCriterion("owner_id in", values, "ownerId"); + return (Criteria) this; + } + + public Criteria andOwnerIdNotIn(List<String> values) { + addCriterion("owner_id not in", values, "ownerId"); + return (Criteria) this; + } + + public Criteria andOwnerIdBetween(String value1, String value2) { + addCriterion("owner_id between", value1, value2, "ownerId"); + return (Criteria) this; + } + + public Criteria andOwnerIdNotBetween(String value1, String value2) { + addCriterion("owner_id not between", value1, value2, "ownerId"); + return (Criteria) this; + } + } + + public static class Criteria extends GeneratedCriteria { + + protected Criteria() { + super(); + } + } + + public static class Criterion { + private String condition; + + private Object value; + + private Object secondValue; + + private boolean noValue; + + private boolean singleValue; + + private boolean betweenValue; + + private boolean listValue; + + private String typeHandler; + + public String getCondition() { + return condition; + } + + public Object getValue() { + return value; + } + + public Object getSecondValue() { + return secondValue; + } + + public boolean isNoValue() { + return noValue; + } + + public boolean isSingleValue() { + return singleValue; + } + + public boolean isBetweenValue() { + return betweenValue; + } + + public boolean isListValue() { + return listValue; + } + + public String getTypeHandler() { + return typeHandler; + } + + protected Criterion(String condition) { + super(); + this.condition = condition; + this.typeHandler = null; + this.noValue = true; + } + + protected Criterion(String condition, Object value, String typeHandler) { + super(); + this.condition = condition; + this.value = value; + this.typeHandler = typeHandler; + if (value instanceof List<?>) { + this.listValue = true; + } else { + this.singleValue = true; + } + } + + protected Criterion(String condition, Object value) { + this(condition, value, null); + } + + protected Criterion(String condition, Object value, Object secondValue, String typeHandler) { + super(); + this.condition = condition; + this.value = value; + this.secondValue = secondValue; + this.typeHandler = typeHandler; + this.betweenValue = true; + } + + protected Criterion(String condition, Object value, Object secondValue) { + this(condition, value, secondValue, null); + } + } +} \ No newline at end of file diff --git a/src/main/java/com/moral/monitor/entity/History.java b/src/main/java/com/moral/monitor/entity/History.java index d417fb2..b0ae9d5 100644 --- a/src/main/java/com/moral/monitor/entity/History.java +++ b/src/main/java/com/moral/monitor/entity/History.java @@ -2,24 +2,33 @@ import java.util.Date; -/** - * Created by a on 2017/6/20. - * ������������������������������������������������ - */ public class History { + private Integer id; + private String mac; + private String sensor; - private String mac_key; - private Double mac_value; + + private String macKey; + + private Double macValue; + private Date time; - private String units; + + public Integer getId() { + return id; + } + + public void setId(Integer id) { + this.id = id; + } public String getMac() { return mac; } public void setMac(String mac) { - this.mac = mac; + this.mac = mac == null ? null : mac.trim(); } public String getSensor() { @@ -27,23 +36,23 @@ } public void setSensor(String sensor) { - this.sensor = sensor; + this.sensor = sensor == null ? null : sensor.trim(); } - public String getMac_key() { - return mac_key; + public String getMacKey() { + return macKey; } - public void setMac_key(String mac_key) { - this.mac_key = mac_key; + public void setMacKey(String macKey) { + this.macKey = macKey == null ? null : macKey.trim(); } - public Double getMac_value() { - return mac_value; + public Double getMacValue() { + return macValue; } - public void setMac_value(Double mac_value) { - this.mac_value = mac_value; + public void setMacValue(Double macValue) { + this.macValue = macValue; } public Date getTime() { @@ -53,12 +62,4 @@ public void setTime(Date time) { this.time = time; } - - public String getUnits() { - return units; - } - - public void setUnits(String units) { - this.units = units; - } -} +} \ No newline at end of file diff --git a/src/main/java/com/moral/monitor/entity/HistoryExample.java b/src/main/java/com/moral/monitor/entity/HistoryExample.java new file mode 100644 index 0000000..2c1f791 --- /dev/null +++ b/src/main/java/com/moral/monitor/entity/HistoryExample.java @@ -0,0 +1,591 @@ +package com.moral.monitor.entity; + +import java.util.ArrayList; +import java.util.Date; +import java.util.List; + +public class HistoryExample { + protected String orderByClause; + + protected boolean distinct; + + protected List<Criteria> oredCriteria; + + public HistoryExample() { + oredCriteria = new ArrayList<Criteria>(); + } + + public void setOrderByClause(String orderByClause) { + this.orderByClause = orderByClause; + } + + public String getOrderByClause() { + return orderByClause; + } + + public void setDistinct(boolean distinct) { + this.distinct = distinct; + } + + public boolean isDistinct() { + return distinct; + } + + public List<Criteria> getOredCriteria() { + return oredCriteria; + } + + public void or(Criteria criteria) { + oredCriteria.add(criteria); + } + + public Criteria or() { + Criteria criteria = createCriteriaInternal(); + oredCriteria.add(criteria); + return criteria; + } + + public Criteria createCriteria() { + Criteria criteria = createCriteriaInternal(); + if (oredCriteria.size() == 0) { + oredCriteria.add(criteria); + } + return criteria; + } + + protected Criteria createCriteriaInternal() { + Criteria criteria = new Criteria(); + return criteria; + } + + public void clear() { + oredCriteria.clear(); + orderByClause = null; + distinct = false; + } + + protected abstract static class GeneratedCriteria { + protected List<Criterion> criteria; + + protected GeneratedCriteria() { + super(); + criteria = new ArrayList<Criterion>(); + } + + public boolean isValid() { + return criteria.size() > 0; + } + + public List<Criterion> getAllCriteria() { + return criteria; + } + + public List<Criterion> getCriteria() { + return criteria; + } + + protected void addCriterion(String condition) { + if (condition == null) { + throw new RuntimeException("Value for condition cannot be null"); + } + criteria.add(new Criterion(condition)); + } + + protected void addCriterion(String condition, Object value, String property) { + if (value == null) { + throw new RuntimeException("Value for " + property + " cannot be null"); + } + criteria.add(new Criterion(condition, value)); + } + + protected void addCriterion(String condition, Object value1, Object value2, String property) { + if (value1 == null || value2 == null) { + throw new RuntimeException("Between values for " + property + " cannot be null"); + } + criteria.add(new Criterion(condition, value1, value2)); + } + + public Criteria andIdIsNull() { + addCriterion("id is null"); + return (Criteria) this; + } + + public Criteria andIdIsNotNull() { + addCriterion("id is not null"); + return (Criteria) this; + } + + public Criteria andIdEqualTo(Integer value) { + addCriterion("id =", value, "id"); + return (Criteria) this; + } + + public Criteria andIdNotEqualTo(Integer value) { + addCriterion("id <>", value, "id"); + return (Criteria) this; + } + + public Criteria andIdGreaterThan(Integer value) { + addCriterion("id >", value, "id"); + return (Criteria) this; + } + + public Criteria andIdGreaterThanOrEqualTo(Integer value) { + addCriterion("id >=", value, "id"); + return (Criteria) this; + } + + public Criteria andIdLessThan(Integer value) { + addCriterion("id <", value, "id"); + return (Criteria) this; + } + + public Criteria andIdLessThanOrEqualTo(Integer value) { + addCriterion("id <=", value, "id"); + return (Criteria) this; + } + + public Criteria andIdIn(List<Integer> values) { + addCriterion("id in", values, "id"); + return (Criteria) this; + } + + public Criteria andIdNotIn(List<Integer> values) { + addCriterion("id not in", values, "id"); + return (Criteria) this; + } + + public Criteria andIdBetween(Integer value1, Integer value2) { + addCriterion("id between", value1, value2, "id"); + return (Criteria) this; + } + + public Criteria andIdNotBetween(Integer value1, Integer value2) { + addCriterion("id not between", value1, value2, "id"); + return (Criteria) this; + } + + public Criteria andMacIsNull() { + addCriterion("mac is null"); + return (Criteria) this; + } + + public Criteria andMacIsNotNull() { + addCriterion("mac is not null"); + return (Criteria) this; + } + + public Criteria andMacEqualTo(String value) { + addCriterion("mac =", value, "mac"); + return (Criteria) this; + } + + public Criteria andMacNotEqualTo(String value) { + addCriterion("mac <>", value, "mac"); + return (Criteria) this; + } + + public Criteria andMacGreaterThan(String value) { + addCriterion("mac >", value, "mac"); + return (Criteria) this; + } + + public Criteria andMacGreaterThanOrEqualTo(String value) { + addCriterion("mac >=", value, "mac"); + return (Criteria) this; + } + + public Criteria andMacLessThan(String value) { + addCriterion("mac <", value, "mac"); + return (Criteria) this; + } + + public Criteria andMacLessThanOrEqualTo(String value) { + addCriterion("mac <=", value, "mac"); + return (Criteria) this; + } + + public Criteria andMacLike(String value) { + addCriterion("mac like", value, "mac"); + return (Criteria) this; + } + + public Criteria andMacNotLike(String value) { + addCriterion("mac not like", value, "mac"); + return (Criteria) this; + } + + public Criteria andMacIn(List<String> values) { + addCriterion("mac in", values, "mac"); + return (Criteria) this; + } + + public Criteria andMacNotIn(List<String> values) { + addCriterion("mac not in", values, "mac"); + return (Criteria) this; + } + + public Criteria andMacBetween(String value1, String value2) { + addCriterion("mac between", value1, value2, "mac"); + return (Criteria) this; + } + + public Criteria andMacNotBetween(String value1, String value2) { + addCriterion("mac not between", value1, value2, "mac"); + return (Criteria) this; + } + + public Criteria andSensorIsNull() { + addCriterion("sensor is null"); + return (Criteria) this; + } + + public Criteria andSensorIsNotNull() { + addCriterion("sensor is not null"); + return (Criteria) this; + } + + public Criteria andSensorEqualTo(String value) { + addCriterion("sensor =", value, "sensor"); + return (Criteria) this; + } + + public Criteria andSensorNotEqualTo(String value) { + addCriterion("sensor <>", value, "sensor"); + return (Criteria) this; + } + + public Criteria andSensorGreaterThan(String value) { + addCriterion("sensor >", value, "sensor"); + return (Criteria) this; + } + + public Criteria andSensorGreaterThanOrEqualTo(String value) { + addCriterion("sensor >=", value, "sensor"); + return (Criteria) this; + } + + public Criteria andSensorLessThan(String value) { + addCriterion("sensor <", value, "sensor"); + return (Criteria) this; + } + + public Criteria andSensorLessThanOrEqualTo(String value) { + addCriterion("sensor <=", value, "sensor"); + return (Criteria) this; + } + + public Criteria andSensorLike(String value) { + addCriterion("sensor like", value, "sensor"); + return (Criteria) this; + } + + public Criteria andSensorNotLike(String value) { + addCriterion("sensor not like", value, "sensor"); + return (Criteria) this; + } + + public Criteria andSensorIn(List<String> values) { + addCriterion("sensor in", values, "sensor"); + return (Criteria) this; + } + + public Criteria andSensorNotIn(List<String> values) { + addCriterion("sensor not in", values, "sensor"); + return (Criteria) this; + } + + public Criteria andSensorBetween(String value1, String value2) { + addCriterion("sensor between", value1, value2, "sensor"); + return (Criteria) this; + } + + public Criteria andSensorNotBetween(String value1, String value2) { + addCriterion("sensor not between", value1, value2, "sensor"); + return (Criteria) this; + } + + public Criteria andMacKeyIsNull() { + addCriterion("mac_key is null"); + return (Criteria) this; + } + + public Criteria andMacKeyIsNotNull() { + addCriterion("mac_key is not null"); + return (Criteria) this; + } + + public Criteria andMacKeyEqualTo(String value) { + addCriterion("mac_key =", value, "macKey"); + return (Criteria) this; + } + + public Criteria andMacKeyNotEqualTo(String value) { + addCriterion("mac_key <>", value, "macKey"); + return (Criteria) this; + } + + public Criteria andMacKeyGreaterThan(String value) { + addCriterion("mac_key >", value, "macKey"); + return (Criteria) this; + } + + public Criteria andMacKeyGreaterThanOrEqualTo(String value) { + addCriterion("mac_key >=", value, "macKey"); + return (Criteria) this; + } + + public Criteria andMacKeyLessThan(String value) { + addCriterion("mac_key <", value, "macKey"); + return (Criteria) this; + } + + public Criteria andMacKeyLessThanOrEqualTo(String value) { + addCriterion("mac_key <=", value, "macKey"); + return (Criteria) this; + } + + public Criteria andMacKeyLike(String value) { + addCriterion("mac_key like", value, "macKey"); + return (Criteria) this; + } + + public Criteria andMacKeyNotLike(String value) { + addCriterion("mac_key not like", value, "macKey"); + return (Criteria) this; + } + + public Criteria andMacKeyIn(List<String> values) { + addCriterion("mac_key in", values, "macKey"); + return (Criteria) this; + } + + public Criteria andMacKeyNotIn(List<String> values) { + addCriterion("mac_key not in", values, "macKey"); + return (Criteria) this; + } + + public Criteria andMacKeyBetween(String value1, String value2) { + addCriterion("mac_key between", value1, value2, "macKey"); + return (Criteria) this; + } + + public Criteria andMacKeyNotBetween(String value1, String value2) { + addCriterion("mac_key not between", value1, value2, "macKey"); + return (Criteria) this; + } + + public Criteria andMacValueIsNull() { + addCriterion("mac_value is null"); + return (Criteria) this; + } + + public Criteria andMacValueIsNotNull() { + addCriterion("mac_value is not null"); + return (Criteria) this; + } + + public Criteria andMacValueEqualTo(Double value) { + addCriterion("mac_value =", value, "macValue"); + return (Criteria) this; + } + + public Criteria andMacValueNotEqualTo(Double value) { + addCriterion("mac_value <>", value, "macValue"); + return (Criteria) this; + } + + public Criteria andMacValueGreaterThan(Double value) { + addCriterion("mac_value >", value, "macValue"); + return (Criteria) this; + } + + public Criteria andMacValueGreaterThanOrEqualTo(Double value) { + addCriterion("mac_value >=", value, "macValue"); + return (Criteria) this; + } + + public Criteria andMacValueLessThan(Double value) { + addCriterion("mac_value <", value, "macValue"); + return (Criteria) this; + } + + public Criteria andMacValueLessThanOrEqualTo(Double value) { + addCriterion("mac_value <=", value, "macValue"); + return (Criteria) this; + } + + public Criteria andMacValueIn(List<Double> values) { + addCriterion("mac_value in", values, "macValue"); + return (Criteria) this; + } + + public Criteria andMacValueNotIn(List<Double> values) { + addCriterion("mac_value not in", values, "macValue"); + return (Criteria) this; + } + + public Criteria andMacValueBetween(Double value1, Double value2) { + addCriterion("mac_value between", value1, value2, "macValue"); + return (Criteria) this; + } + + public Criteria andMacValueNotBetween(Double value1, Double value2) { + addCriterion("mac_value not between", value1, value2, "macValue"); + return (Criteria) this; + } + + public Criteria andTimeIsNull() { + addCriterion("time is null"); + return (Criteria) this; + } + + public Criteria andTimeIsNotNull() { + addCriterion("time is not null"); + return (Criteria) this; + } + + public Criteria andTimeEqualTo(Date value) { + addCriterion("time =", value, "time"); + return (Criteria) this; + } + + public Criteria andTimeNotEqualTo(Date value) { + addCriterion("time <>", value, "time"); + return (Criteria) this; + } + + public Criteria andTimeGreaterThan(Date value) { + addCriterion("time >", value, "time"); + return (Criteria) this; + } + + public Criteria andTimeGreaterThanOrEqualTo(Date value) { + addCriterion("time >=", value, "time"); + return (Criteria) this; + } + + public Criteria andTimeLessThan(Date value) { + addCriterion("time <", value, "time"); + return (Criteria) this; + } + + public Criteria andTimeLessThanOrEqualTo(Date value) { + addCriterion("time <=", value, "time"); + return (Criteria) this; + } + + public Criteria andTimeIn(List<Date> values) { + addCriterion("time in", values, "time"); + return (Criteria) this; + } + + public Criteria andTimeNotIn(List<Date> values) { + addCriterion("time not in", values, "time"); + return (Criteria) this; + } + + public Criteria andTimeBetween(Date value1, Date value2) { + addCriterion("time between", value1, value2, "time"); + return (Criteria) this; + } + + public Criteria andTimeNotBetween(Date value1, Date value2) { + addCriterion("time not between", value1, value2, "time"); + return (Criteria) this; + } + } + + public static class Criteria extends GeneratedCriteria { + + protected Criteria() { + super(); + } + } + + public static class Criterion { + private String condition; + + private Object value; + + private Object secondValue; + + private boolean noValue; + + private boolean singleValue; + + private boolean betweenValue; + + private boolean listValue; + + private String typeHandler; + + public String getCondition() { + return condition; + } + + public Object getValue() { + return value; + } + + public Object getSecondValue() { + return secondValue; + } + + public boolean isNoValue() { + return noValue; + } + + public boolean isSingleValue() { + return singleValue; + } + + public boolean isBetweenValue() { + return betweenValue; + } + + public boolean isListValue() { + return listValue; + } + + public String getTypeHandler() { + return typeHandler; + } + + protected Criterion(String condition) { + super(); + this.condition = condition; + this.typeHandler = null; + this.noValue = true; + } + + protected Criterion(String condition, Object value, String typeHandler) { + super(); + this.condition = condition; + this.value = value; + this.typeHandler = typeHandler; + if (value instanceof List<?>) { + this.listValue = true; + } else { + this.singleValue = true; + } + } + + protected Criterion(String condition, Object value) { + this(condition, value, null); + } + + protected Criterion(String condition, Object value, Object secondValue, String typeHandler) { + super(); + this.condition = condition; + this.value = value; + this.secondValue = secondValue; + this.typeHandler = typeHandler; + this.betweenValue = true; + } + + protected Criterion(String condition, Object value, Object secondValue) { + this(condition, value, secondValue, null); + } + } +} \ No newline at end of file diff --git a/src/main/java/com/moral/monitor/entity/Logger.java b/src/main/java/com/moral/monitor/entity/Logger.java new file mode 100644 index 0000000..f23586d --- /dev/null +++ b/src/main/java/com/moral/monitor/entity/Logger.java @@ -0,0 +1,45 @@ +package com.moral.monitor.entity; + +import java.util.Date; + +public class Logger { + private Integer id; + + private String mac; + + private String macLog; + + private Date time; + + public Integer getId() { + return id; + } + + public void setId(Integer id) { + this.id = id; + } + + public String getMac() { + return mac; + } + + public void setMac(String mac) { + this.mac = mac == null ? null : mac.trim(); + } + + public String getMacLog() { + return macLog; + } + + public void setMacLog(String macLog) { + this.macLog = macLog == null ? null : macLog.trim(); + } + + public Date getTime() { + return time; + } + + public void setTime(Date time) { + this.time = time; + } +} \ No newline at end of file diff --git a/src/main/java/com/moral/monitor/entity/LoggerExample.java b/src/main/java/com/moral/monitor/entity/LoggerExample.java new file mode 100644 index 0000000..6739bee --- /dev/null +++ b/src/main/java/com/moral/monitor/entity/LoggerExample.java @@ -0,0 +1,461 @@ +package com.moral.monitor.entity; + +import java.util.ArrayList; +import java.util.Date; +import java.util.List; + +public class LoggerExample { + protected String orderByClause; + + protected boolean distinct; + + protected List<Criteria> oredCriteria; + + public LoggerExample() { + oredCriteria = new ArrayList<Criteria>(); + } + + public void setOrderByClause(String orderByClause) { + this.orderByClause = orderByClause; + } + + public String getOrderByClause() { + return orderByClause; + } + + public void setDistinct(boolean distinct) { + this.distinct = distinct; + } + + public boolean isDistinct() { + return distinct; + } + + public List<Criteria> getOredCriteria() { + return oredCriteria; + } + + public void or(Criteria criteria) { + oredCriteria.add(criteria); + } + + public Criteria or() { + Criteria criteria = createCriteriaInternal(); + oredCriteria.add(criteria); + return criteria; + } + + public Criteria createCriteria() { + Criteria criteria = createCriteriaInternal(); + if (oredCriteria.size() == 0) { + oredCriteria.add(criteria); + } + return criteria; + } + + protected Criteria createCriteriaInternal() { + Criteria criteria = new Criteria(); + return criteria; + } + + public void clear() { + oredCriteria.clear(); + orderByClause = null; + distinct = false; + } + + protected abstract static class GeneratedCriteria { + protected List<Criterion> criteria; + + protected GeneratedCriteria() { + super(); + criteria = new ArrayList<Criterion>(); + } + + public boolean isValid() { + return criteria.size() > 0; + } + + public List<Criterion> getAllCriteria() { + return criteria; + } + + public List<Criterion> getCriteria() { + return criteria; + } + + protected void addCriterion(String condition) { + if (condition == null) { + throw new RuntimeException("Value for condition cannot be null"); + } + criteria.add(new Criterion(condition)); + } + + protected void addCriterion(String condition, Object value, String property) { + if (value == null) { + throw new RuntimeException("Value for " + property + " cannot be null"); + } + criteria.add(new Criterion(condition, value)); + } + + protected void addCriterion(String condition, Object value1, Object value2, String property) { + if (value1 == null || value2 == null) { + throw new RuntimeException("Between values for " + property + " cannot be null"); + } + criteria.add(new Criterion(condition, value1, value2)); + } + + public Criteria andIdIsNull() { + addCriterion("id is null"); + return (Criteria) this; + } + + public Criteria andIdIsNotNull() { + addCriterion("id is not null"); + return (Criteria) this; + } + + public Criteria andIdEqualTo(Integer value) { + addCriterion("id =", value, "id"); + return (Criteria) this; + } + + public Criteria andIdNotEqualTo(Integer value) { + addCriterion("id <>", value, "id"); + return (Criteria) this; + } + + public Criteria andIdGreaterThan(Integer value) { + addCriterion("id >", value, "id"); + return (Criteria) this; + } + + public Criteria andIdGreaterThanOrEqualTo(Integer value) { + addCriterion("id >=", value, "id"); + return (Criteria) this; + } + + public Criteria andIdLessThan(Integer value) { + addCriterion("id <", value, "id"); + return (Criteria) this; + } + + public Criteria andIdLessThanOrEqualTo(Integer value) { + addCriterion("id <=", value, "id"); + return (Criteria) this; + } + + public Criteria andIdIn(List<Integer> values) { + addCriterion("id in", values, "id"); + return (Criteria) this; + } + + public Criteria andIdNotIn(List<Integer> values) { + addCriterion("id not in", values, "id"); + return (Criteria) this; + } + + public Criteria andIdBetween(Integer value1, Integer value2) { + addCriterion("id between", value1, value2, "id"); + return (Criteria) this; + } + + public Criteria andIdNotBetween(Integer value1, Integer value2) { + addCriterion("id not between", value1, value2, "id"); + return (Criteria) this; + } + + public Criteria andMacIsNull() { + addCriterion("mac is null"); + return (Criteria) this; + } + + public Criteria andMacIsNotNull() { + addCriterion("mac is not null"); + return (Criteria) this; + } + + public Criteria andMacEqualTo(String value) { + addCriterion("mac =", value, "mac"); + return (Criteria) this; + } + + public Criteria andMacNotEqualTo(String value) { + addCriterion("mac <>", value, "mac"); + return (Criteria) this; + } + + public Criteria andMacGreaterThan(String value) { + addCriterion("mac >", value, "mac"); + return (Criteria) this; + } + + public Criteria andMacGreaterThanOrEqualTo(String value) { + addCriterion("mac >=", value, "mac"); + return (Criteria) this; + } + + public Criteria andMacLessThan(String value) { + addCriterion("mac <", value, "mac"); + return (Criteria) this; + } + + public Criteria andMacLessThanOrEqualTo(String value) { + addCriterion("mac <=", value, "mac"); + return (Criteria) this; + } + + public Criteria andMacLike(String value) { + addCriterion("mac like", value, "mac"); + return (Criteria) this; + } + + public Criteria andMacNotLike(String value) { + addCriterion("mac not like", value, "mac"); + return (Criteria) this; + } + + public Criteria andMacIn(List<String> values) { + addCriterion("mac in", values, "mac"); + return (Criteria) this; + } + + public Criteria andMacNotIn(List<String> values) { + addCriterion("mac not in", values, "mac"); + return (Criteria) this; + } + + public Criteria andMacBetween(String value1, String value2) { + addCriterion("mac between", value1, value2, "mac"); + return (Criteria) this; + } + + public Criteria andMacNotBetween(String value1, String value2) { + addCriterion("mac not between", value1, value2, "mac"); + return (Criteria) this; + } + + public Criteria andMacLogIsNull() { + addCriterion("mac_log is null"); + return (Criteria) this; + } + + public Criteria andMacLogIsNotNull() { + addCriterion("mac_log is not null"); + return (Criteria) this; + } + + public Criteria andMacLogEqualTo(String value) { + addCriterion("mac_log =", value, "macLog"); + return (Criteria) this; + } + + public Criteria andMacLogNotEqualTo(String value) { + addCriterion("mac_log <>", value, "macLog"); + return (Criteria) this; + } + + public Criteria andMacLogGreaterThan(String value) { + addCriterion("mac_log >", value, "macLog"); + return (Criteria) this; + } + + public Criteria andMacLogGreaterThanOrEqualTo(String value) { + addCriterion("mac_log >=", value, "macLog"); + return (Criteria) this; + } + + public Criteria andMacLogLessThan(String value) { + addCriterion("mac_log <", value, "macLog"); + return (Criteria) this; + } + + public Criteria andMacLogLessThanOrEqualTo(String value) { + addCriterion("mac_log <=", value, "macLog"); + return (Criteria) this; + } + + public Criteria andMacLogLike(String value) { + addCriterion("mac_log like", value, "macLog"); + return (Criteria) this; + } + + public Criteria andMacLogNotLike(String value) { + addCriterion("mac_log not like", value, "macLog"); + return (Criteria) this; + } + + public Criteria andMacLogIn(List<String> values) { + addCriterion("mac_log in", values, "macLog"); + return (Criteria) this; + } + + public Criteria andMacLogNotIn(List<String> values) { + addCriterion("mac_log not in", values, "macLog"); + return (Criteria) this; + } + + public Criteria andMacLogBetween(String value1, String value2) { + addCriterion("mac_log between", value1, value2, "macLog"); + return (Criteria) this; + } + + public Criteria andMacLogNotBetween(String value1, String value2) { + addCriterion("mac_log not between", value1, value2, "macLog"); + return (Criteria) this; + } + + public Criteria andTimeIsNull() { + addCriterion("time is null"); + return (Criteria) this; + } + + public Criteria andTimeIsNotNull() { + addCriterion("time is not null"); + return (Criteria) this; + } + + public Criteria andTimeEqualTo(Date value) { + addCriterion("time =", value, "time"); + return (Criteria) this; + } + + public Criteria andTimeNotEqualTo(Date value) { + addCriterion("time <>", value, "time"); + return (Criteria) this; + } + + public Criteria andTimeGreaterThan(Date value) { + addCriterion("time >", value, "time"); + return (Criteria) this; + } + + public Criteria andTimeGreaterThanOrEqualTo(Date value) { + addCriterion("time >=", value, "time"); + return (Criteria) this; + } + + public Criteria andTimeLessThan(Date value) { + addCriterion("time <", value, "time"); + return (Criteria) this; + } + + public Criteria andTimeLessThanOrEqualTo(Date value) { + addCriterion("time <=", value, "time"); + return (Criteria) this; + } + + public Criteria andTimeIn(List<Date> values) { + addCriterion("time in", values, "time"); + return (Criteria) this; + } + + public Criteria andTimeNotIn(List<Date> values) { + addCriterion("time not in", values, "time"); + return (Criteria) this; + } + + public Criteria andTimeBetween(Date value1, Date value2) { + addCriterion("time between", value1, value2, "time"); + return (Criteria) this; + } + + public Criteria andTimeNotBetween(Date value1, Date value2) { + addCriterion("time not between", value1, value2, "time"); + return (Criteria) this; + } + } + + public static class Criteria extends GeneratedCriteria { + + protected Criteria() { + super(); + } + } + + public static class Criterion { + private String condition; + + private Object value; + + private Object secondValue; + + private boolean noValue; + + private boolean singleValue; + + private boolean betweenValue; + + private boolean listValue; + + private String typeHandler; + + public String getCondition() { + return condition; + } + + public Object getValue() { + return value; + } + + public Object getSecondValue() { + return secondValue; + } + + public boolean isNoValue() { + return noValue; + } + + public boolean isSingleValue() { + return singleValue; + } + + public boolean isBetweenValue() { + return betweenValue; + } + + public boolean isListValue() { + return listValue; + } + + public String getTypeHandler() { + return typeHandler; + } + + protected Criterion(String condition) { + super(); + this.condition = condition; + this.typeHandler = null; + this.noValue = true; + } + + protected Criterion(String condition, Object value, String typeHandler) { + super(); + this.condition = condition; + this.value = value; + this.typeHandler = typeHandler; + if (value instanceof List<?>) { + this.listValue = true; + } else { + this.singleValue = true; + } + } + + protected Criterion(String condition, Object value) { + this(condition, value, null); + } + + protected Criterion(String condition, Object value, Object secondValue, String typeHandler) { + super(); + this.condition = condition; + this.value = value; + this.secondValue = secondValue; + this.typeHandler = typeHandler; + this.betweenValue = true; + } + + protected Criterion(String condition, Object value, Object secondValue) { + this(condition, value, secondValue, null); + } + } +} \ No newline at end of file diff --git a/src/main/java/com/moral/monitor/entity/MonitorPoint.java b/src/main/java/com/moral/monitor/entity/MonitorPoint.java deleted file mode 100644 index 7d2f154..0000000 --- a/src/main/java/com/moral/monitor/entity/MonitorPoint.java +++ /dev/null @@ -1,73 +0,0 @@ -package com.moral.monitor.entity; - -import java.util.Date; - -/** - * Created by a on 2017/7/18. - */ -public class MonitorPoint { - - private int id; - private String name; - private String address; - private String repairman; - private Date create_time; - private String owner; - private int equcount; - - public int getId() { - return id; - } - - public void setId(int id) { - this.id = id; - } - - public String getName() { - return name; - } - - public void setName(String name) { - this.name = name; - } - - public String getAddress() { - return address; - } - - public void setAddress(String address) { - this.address = address; - } - - public String getRepairman() { - return repairman; - } - - public void setRepairman(String repairman) { - this.repairman = repairman; - } - - public Date getCreate_time() { - return create_time; - } - - public void setCreate_time(Date create_time) { - this.create_time = create_time; - } - - public String getOwner() { - return owner; - } - - public void setOwner(String owner) { - this.owner = owner; - } - - public int getEqucount() { - return equcount; - } - - public void setEqucount(int equcount) { - this.equcount = equcount; - } -} diff --git a/src/main/java/com/moral/monitor/entity/Monitorpoint.java b/src/main/java/com/moral/monitor/entity/Monitorpoint.java new file mode 100644 index 0000000..1e0c672 --- /dev/null +++ b/src/main/java/com/moral/monitor/entity/Monitorpoint.java @@ -0,0 +1,125 @@ +package com.moral.monitor.entity; + +import java.util.Date; + +public class Monitorpoint { + private String id; + + private String name; + + private Double longitude; + + private Double latitude; + + private String provincecode; + + private String citycode; + + private String areacode; + + private String address; + + private String repairman; + + private String regionDescription; + + private Date createTime; + + private String owner; + + public String getId() { + return id; + } + + public void setId(String id) { + this.id = id == null ? null : id.trim(); + } + + public String getName() { + return name; + } + + public void setName(String name) { + this.name = name == null ? null : name.trim(); + } + + public Double getLongitude() { + return longitude; + } + + public void setLongitude(Double longitude) { + this.longitude = longitude; + } + + public Double getLatitude() { + return latitude; + } + + public void setLatitude(Double latitude) { + this.latitude = latitude; + } + + public String getProvincecode() { + return provincecode; + } + + public void setProvincecode(String provincecode) { + this.provincecode = provincecode == null ? null : provincecode.trim(); + } + + public String getCitycode() { + return citycode; + } + + public void setCitycode(String citycode) { + this.citycode = citycode == null ? null : citycode.trim(); + } + + public String getAreacode() { + return areacode; + } + + public void setAreacode(String areacode) { + this.areacode = areacode == null ? null : areacode.trim(); + } + + public String getAddress() { + return address; + } + + public void setAddress(String address) { + this.address = address == null ? null : address.trim(); + } + + public String getRepairman() { + return repairman; + } + + public void setRepairman(String repairman) { + this.repairman = repairman == null ? null : repairman.trim(); + } + + public String getRegionDescription() { + return regionDescription; + } + + public void setRegionDescription(String regionDescription) { + this.regionDescription = regionDescription == null ? null : regionDescription.trim(); + } + + public Date getCreateTime() { + return createTime; + } + + public void setCreateTime(Date createTime) { + this.createTime = createTime; + } + + public String getOwner() { + return owner; + } + + public void setOwner(String owner) { + this.owner = owner == null ? null : owner.trim(); + } +} \ No newline at end of file diff --git a/src/main/java/com/moral/monitor/entity/MonitorpointExample.java b/src/main/java/com/moral/monitor/entity/MonitorpointExample.java new file mode 100644 index 0000000..9b9de0f --- /dev/null +++ b/src/main/java/com/moral/monitor/entity/MonitorpointExample.java @@ -0,0 +1,1011 @@ +package com.moral.monitor.entity; + +import java.util.ArrayList; +import java.util.Date; +import java.util.List; + +public class MonitorpointExample { + protected String orderByClause; + + protected boolean distinct; + + protected List<Criteria> oredCriteria; + + public MonitorpointExample() { + oredCriteria = new ArrayList<Criteria>(); + } + + public void setOrderByClause(String orderByClause) { + this.orderByClause = orderByClause; + } + + public String getOrderByClause() { + return orderByClause; + } + + public void setDistinct(boolean distinct) { + this.distinct = distinct; + } + + public boolean isDistinct() { + return distinct; + } + + public List<Criteria> getOredCriteria() { + return oredCriteria; + } + + public void or(Criteria criteria) { + oredCriteria.add(criteria); + } + + public Criteria or() { + Criteria criteria = createCriteriaInternal(); + oredCriteria.add(criteria); + return criteria; + } + + public Criteria createCriteria() { + Criteria criteria = createCriteriaInternal(); + if (oredCriteria.size() == 0) { + oredCriteria.add(criteria); + } + return criteria; + } + + protected Criteria createCriteriaInternal() { + Criteria criteria = new Criteria(); + return criteria; + } + + public void clear() { + oredCriteria.clear(); + orderByClause = null; + distinct = false; + } + + protected abstract static class GeneratedCriteria { + protected List<Criterion> criteria; + + protected GeneratedCriteria() { + super(); + criteria = new ArrayList<Criterion>(); + } + + public boolean isValid() { + return criteria.size() > 0; + } + + public List<Criterion> getAllCriteria() { + return criteria; + } + + public List<Criterion> getCriteria() { + return criteria; + } + + protected void addCriterion(String condition) { + if (condition == null) { + throw new RuntimeException("Value for condition cannot be null"); + } + criteria.add(new Criterion(condition)); + } + + protected void addCriterion(String condition, Object value, String property) { + if (value == null) { + throw new RuntimeException("Value for " + property + " cannot be null"); + } + criteria.add(new Criterion(condition, value)); + } + + protected void addCriterion(String condition, Object value1, Object value2, String property) { + if (value1 == null || value2 == null) { + throw new RuntimeException("Between values for " + property + " cannot be null"); + } + criteria.add(new Criterion(condition, value1, value2)); + } + + public Criteria andIdIsNull() { + addCriterion("id is null"); + return (Criteria) this; + } + + public Criteria andIdIsNotNull() { + addCriterion("id is not null"); + return (Criteria) this; + } + + public Criteria andIdEqualTo(String value) { + addCriterion("id =", value, "id"); + return (Criteria) this; + } + + public Criteria andIdNotEqualTo(String value) { + addCriterion("id <>", value, "id"); + return (Criteria) this; + } + + public Criteria andIdGreaterThan(String value) { + addCriterion("id >", value, "id"); + return (Criteria) this; + } + + public Criteria andIdGreaterThanOrEqualTo(String value) { + addCriterion("id >=", value, "id"); + return (Criteria) this; + } + + public Criteria andIdLessThan(String value) { + addCriterion("id <", value, "id"); + return (Criteria) this; + } + + public Criteria andIdLessThanOrEqualTo(String value) { + addCriterion("id <=", value, "id"); + return (Criteria) this; + } + + public Criteria andIdLike(String value) { + addCriterion("id like", value, "id"); + return (Criteria) this; + } + + public Criteria andIdNotLike(String value) { + addCriterion("id not like", value, "id"); + return (Criteria) this; + } + + public Criteria andIdIn(List<String> values) { + addCriterion("id in", values, "id"); + return (Criteria) this; + } + + public Criteria andIdNotIn(List<String> values) { + addCriterion("id not in", values, "id"); + return (Criteria) this; + } + + public Criteria andIdBetween(String value1, String value2) { + addCriterion("id between", value1, value2, "id"); + return (Criteria) this; + } + + public Criteria andIdNotBetween(String value1, String value2) { + addCriterion("id not between", value1, value2, "id"); + return (Criteria) this; + } + + public Criteria andNameIsNull() { + addCriterion("name is null"); + return (Criteria) this; + } + + public Criteria andNameIsNotNull() { + addCriterion("name is not null"); + return (Criteria) this; + } + + public Criteria andNameEqualTo(String value) { + addCriterion("name =", value, "name"); + return (Criteria) this; + } + + public Criteria andNameNotEqualTo(String value) { + addCriterion("name <>", value, "name"); + return (Criteria) this; + } + + public Criteria andNameGreaterThan(String value) { + addCriterion("name >", value, "name"); + return (Criteria) this; + } + + public Criteria andNameGreaterThanOrEqualTo(String value) { + addCriterion("name >=", value, "name"); + return (Criteria) this; + } + + public Criteria andNameLessThan(String value) { + addCriterion("name <", value, "name"); + return (Criteria) this; + } + + public Criteria andNameLessThanOrEqualTo(String value) { + addCriterion("name <=", value, "name"); + return (Criteria) this; + } + + public Criteria andNameLike(String value) { + addCriterion("name like", value, "name"); + return (Criteria) this; + } + + public Criteria andNameNotLike(String value) { + addCriterion("name not like", value, "name"); + return (Criteria) this; + } + + public Criteria andNameIn(List<String> values) { + addCriterion("name in", values, "name"); + return (Criteria) this; + } + + public Criteria andNameNotIn(List<String> values) { + addCriterion("name not in", values, "name"); + return (Criteria) this; + } + + public Criteria andNameBetween(String value1, String value2) { + addCriterion("name between", value1, value2, "name"); + return (Criteria) this; + } + + public Criteria andNameNotBetween(String value1, String value2) { + addCriterion("name not between", value1, value2, "name"); + return (Criteria) this; + } + + public Criteria andLongitudeIsNull() { + addCriterion("longitude is null"); + return (Criteria) this; + } + + public Criteria andLongitudeIsNotNull() { + addCriterion("longitude is not null"); + return (Criteria) this; + } + + public Criteria andLongitudeEqualTo(Double value) { + addCriterion("longitude =", value, "longitude"); + return (Criteria) this; + } + + public Criteria andLongitudeNotEqualTo(Double value) { + addCriterion("longitude <>", value, "longitude"); + return (Criteria) this; + } + + public Criteria andLongitudeGreaterThan(Double value) { + addCriterion("longitude >", value, "longitude"); + return (Criteria) this; + } + + public Criteria andLongitudeGreaterThanOrEqualTo(Double value) { + addCriterion("longitude >=", value, "longitude"); + return (Criteria) this; + } + + public Criteria andLongitudeLessThan(Double value) { + addCriterion("longitude <", value, "longitude"); + return (Criteria) this; + } + + public Criteria andLongitudeLessThanOrEqualTo(Double value) { + addCriterion("longitude <=", value, "longitude"); + return (Criteria) this; + } + + public Criteria andLongitudeIn(List<Double> values) { + addCriterion("longitude in", values, "longitude"); + return (Criteria) this; + } + + public Criteria andLongitudeNotIn(List<Double> values) { + addCriterion("longitude not in", values, "longitude"); + return (Criteria) this; + } + + public Criteria andLongitudeBetween(Double value1, Double value2) { + addCriterion("longitude between", value1, value2, "longitude"); + return (Criteria) this; + } + + public Criteria andLongitudeNotBetween(Double value1, Double value2) { + addCriterion("longitude not between", value1, value2, "longitude"); + return (Criteria) this; + } + + public Criteria andLatitudeIsNull() { + addCriterion("latitude is null"); + return (Criteria) this; + } + + public Criteria andLatitudeIsNotNull() { + addCriterion("latitude is not null"); + return (Criteria) this; + } + + public Criteria andLatitudeEqualTo(Double value) { + addCriterion("latitude =", value, "latitude"); + return (Criteria) this; + } + + public Criteria andLatitudeNotEqualTo(Double value) { + addCriterion("latitude <>", value, "latitude"); + return (Criteria) this; + } + + public Criteria andLatitudeGreaterThan(Double value) { + addCriterion("latitude >", value, "latitude"); + return (Criteria) this; + } + + public Criteria andLatitudeGreaterThanOrEqualTo(Double value) { + addCriterion("latitude >=", value, "latitude"); + return (Criteria) this; + } + + public Criteria andLatitudeLessThan(Double value) { + addCriterion("latitude <", value, "latitude"); + return (Criteria) this; + } + + public Criteria andLatitudeLessThanOrEqualTo(Double value) { + addCriterion("latitude <=", value, "latitude"); + return (Criteria) this; + } + + public Criteria andLatitudeIn(List<Double> values) { + addCriterion("latitude in", values, "latitude"); + return (Criteria) this; + } + + public Criteria andLatitudeNotIn(List<Double> values) { + addCriterion("latitude not in", values, "latitude"); + return (Criteria) this; + } + + public Criteria andLatitudeBetween(Double value1, Double value2) { + addCriterion("latitude between", value1, value2, "latitude"); + return (Criteria) this; + } + + public Criteria andLatitudeNotBetween(Double value1, Double value2) { + addCriterion("latitude not between", value1, value2, "latitude"); + return (Criteria) this; + } + + public Criteria andProvincecodeIsNull() { + addCriterion("provincecode is null"); + return (Criteria) this; + } + + public Criteria andProvincecodeIsNotNull() { + addCriterion("provincecode is not null"); + return (Criteria) this; + } + + public Criteria andProvincecodeEqualTo(String value) { + addCriterion("provincecode =", value, "provincecode"); + return (Criteria) this; + } + + public Criteria andProvincecodeNotEqualTo(String value) { + addCriterion("provincecode <>", value, "provincecode"); + return (Criteria) this; + } + + public Criteria andProvincecodeGreaterThan(String value) { + addCriterion("provincecode >", value, "provincecode"); + return (Criteria) this; + } + + public Criteria andProvincecodeGreaterThanOrEqualTo(String value) { + addCriterion("provincecode >=", value, "provincecode"); + return (Criteria) this; + } + + public Criteria andProvincecodeLessThan(String value) { + addCriterion("provincecode <", value, "provincecode"); + return (Criteria) this; + } + + public Criteria andProvincecodeLessThanOrEqualTo(String value) { + addCriterion("provincecode <=", value, "provincecode"); + return (Criteria) this; + } + + public Criteria andProvincecodeLike(String value) { + addCriterion("provincecode like", value, "provincecode"); + return (Criteria) this; + } + + public Criteria andProvincecodeNotLike(String value) { + addCriterion("provincecode not like", value, "provincecode"); + return (Criteria) this; + } + + public Criteria andProvincecodeIn(List<String> values) { + addCriterion("provincecode in", values, "provincecode"); + return (Criteria) this; + } + + public Criteria andProvincecodeNotIn(List<String> values) { + addCriterion("provincecode not in", values, "provincecode"); + return (Criteria) this; + } + + public Criteria andProvincecodeBetween(String value1, String value2) { + addCriterion("provincecode between", value1, value2, "provincecode"); + return (Criteria) this; + } + + public Criteria andProvincecodeNotBetween(String value1, String value2) { + addCriterion("provincecode not between", value1, value2, "provincecode"); + return (Criteria) this; + } + + public Criteria andCitycodeIsNull() { + addCriterion("citycode is null"); + return (Criteria) this; + } + + public Criteria andCitycodeIsNotNull() { + addCriterion("citycode is not null"); + return (Criteria) this; + } + + public Criteria andCitycodeEqualTo(String value) { + addCriterion("citycode =", value, "citycode"); + return (Criteria) this; + } + + public Criteria andCitycodeNotEqualTo(String value) { + addCriterion("citycode <>", value, "citycode"); + return (Criteria) this; + } + + public Criteria andCitycodeGreaterThan(String value) { + addCriterion("citycode >", value, "citycode"); + return (Criteria) this; + } + + public Criteria andCitycodeGreaterThanOrEqualTo(String value) { + addCriterion("citycode >=", value, "citycode"); + return (Criteria) this; + } + + public Criteria andCitycodeLessThan(String value) { + addCriterion("citycode <", value, "citycode"); + return (Criteria) this; + } + + public Criteria andCitycodeLessThanOrEqualTo(String value) { + addCriterion("citycode <=", value, "citycode"); + return (Criteria) this; + } + + public Criteria andCitycodeLike(String value) { + addCriterion("citycode like", value, "citycode"); + return (Criteria) this; + } + + public Criteria andCitycodeNotLike(String value) { + addCriterion("citycode not like", value, "citycode"); + return (Criteria) this; + } + + public Criteria andCitycodeIn(List<String> values) { + addCriterion("citycode in", values, "citycode"); + return (Criteria) this; + } + + public Criteria andCitycodeNotIn(List<String> values) { + addCriterion("citycode not in", values, "citycode"); + return (Criteria) this; + } + + public Criteria andCitycodeBetween(String value1, String value2) { + addCriterion("citycode between", value1, value2, "citycode"); + return (Criteria) this; + } + + public Criteria andCitycodeNotBetween(String value1, String value2) { + addCriterion("citycode not between", value1, value2, "citycode"); + return (Criteria) this; + } + + public Criteria andAreacodeIsNull() { + addCriterion("areacode is null"); + return (Criteria) this; + } + + public Criteria andAreacodeIsNotNull() { + addCriterion("areacode is not null"); + return (Criteria) this; + } + + public Criteria andAreacodeEqualTo(String value) { + addCriterion("areacode =", value, "areacode"); + return (Criteria) this; + } + + public Criteria andAreacodeNotEqualTo(String value) { + addCriterion("areacode <>", value, "areacode"); + return (Criteria) this; + } + + public Criteria andAreacodeGreaterThan(String value) { + addCriterion("areacode >", value, "areacode"); + return (Criteria) this; + } + + public Criteria andAreacodeGreaterThanOrEqualTo(String value) { + addCriterion("areacode >=", value, "areacode"); + return (Criteria) this; + } + + public Criteria andAreacodeLessThan(String value) { + addCriterion("areacode <", value, "areacode"); + return (Criteria) this; + } + + public Criteria andAreacodeLessThanOrEqualTo(String value) { + addCriterion("areacode <=", value, "areacode"); + return (Criteria) this; + } + + public Criteria andAreacodeLike(String value) { + addCriterion("areacode like", value, "areacode"); + return (Criteria) this; + } + + public Criteria andAreacodeNotLike(String value) { + addCriterion("areacode not like", value, "areacode"); + return (Criteria) this; + } + + public Criteria andAreacodeIn(List<String> values) { + addCriterion("areacode in", values, "areacode"); + return (Criteria) this; + } + + public Criteria andAreacodeNotIn(List<String> values) { + addCriterion("areacode not in", values, "areacode"); + return (Criteria) this; + } + + public Criteria andAreacodeBetween(String value1, String value2) { + addCriterion("areacode between", value1, value2, "areacode"); + return (Criteria) this; + } + + public Criteria andAreacodeNotBetween(String value1, String value2) { + addCriterion("areacode not between", value1, value2, "areacode"); + return (Criteria) this; + } + + public Criteria andAddressIsNull() { + addCriterion("address is null"); + return (Criteria) this; + } + + public Criteria andAddressIsNotNull() { + addCriterion("address is not null"); + return (Criteria) this; + } + + public Criteria andAddressEqualTo(String value) { + addCriterion("address =", value, "address"); + return (Criteria) this; + } + + public Criteria andAddressNotEqualTo(String value) { + addCriterion("address <>", value, "address"); + return (Criteria) this; + } + + public Criteria andAddressGreaterThan(String value) { + addCriterion("address >", value, "address"); + return (Criteria) this; + } + + public Criteria andAddressGreaterThanOrEqualTo(String value) { + addCriterion("address >=", value, "address"); + return (Criteria) this; + } + + public Criteria andAddressLessThan(String value) { + addCriterion("address <", value, "address"); + return (Criteria) this; + } + + public Criteria andAddressLessThanOrEqualTo(String value) { + addCriterion("address <=", value, "address"); + return (Criteria) this; + } + + public Criteria andAddressLike(String value) { + addCriterion("address like", value, "address"); + return (Criteria) this; + } + + public Criteria andAddressNotLike(String value) { + addCriterion("address not like", value, "address"); + return (Criteria) this; + } + + public Criteria andAddressIn(List<String> values) { + addCriterion("address in", values, "address"); + return (Criteria) this; + } + + public Criteria andAddressNotIn(List<String> values) { + addCriterion("address not in", values, "address"); + return (Criteria) this; + } + + public Criteria andAddressBetween(String value1, String value2) { + addCriterion("address between", value1, value2, "address"); + return (Criteria) this; + } + + public Criteria andAddressNotBetween(String value1, String value2) { + addCriterion("address not between", value1, value2, "address"); + return (Criteria) this; + } + + public Criteria andRepairmanIsNull() { + addCriterion("repairman is null"); + return (Criteria) this; + } + + public Criteria andRepairmanIsNotNull() { + addCriterion("repairman is not null"); + return (Criteria) this; + } + + public Criteria andRepairmanEqualTo(String value) { + addCriterion("repairman =", value, "repairman"); + return (Criteria) this; + } + + public Criteria andRepairmanNotEqualTo(String value) { + addCriterion("repairman <>", value, "repairman"); + return (Criteria) this; + } + + public Criteria andRepairmanGreaterThan(String value) { + addCriterion("repairman >", value, "repairman"); + return (Criteria) this; + } + + public Criteria andRepairmanGreaterThanOrEqualTo(String value) { + addCriterion("repairman >=", value, "repairman"); + return (Criteria) this; + } + + public Criteria andRepairmanLessThan(String value) { + addCriterion("repairman <", value, "repairman"); + return (Criteria) this; + } + + public Criteria andRepairmanLessThanOrEqualTo(String value) { + addCriterion("repairman <=", value, "repairman"); + return (Criteria) this; + } + + public Criteria andRepairmanLike(String value) { + addCriterion("repairman like", value, "repairman"); + return (Criteria) this; + } + + public Criteria andRepairmanNotLike(String value) { + addCriterion("repairman not like", value, "repairman"); + return (Criteria) this; + } + + public Criteria andRepairmanIn(List<String> values) { + addCriterion("repairman in", values, "repairman"); + return (Criteria) this; + } + + public Criteria andRepairmanNotIn(List<String> values) { + addCriterion("repairman not in", values, "repairman"); + return (Criteria) this; + } + + public Criteria andRepairmanBetween(String value1, String value2) { + addCriterion("repairman between", value1, value2, "repairman"); + return (Criteria) this; + } + + public Criteria andRepairmanNotBetween(String value1, String value2) { + addCriterion("repairman not between", value1, value2, "repairman"); + return (Criteria) this; + } + + public Criteria andRegionDescriptionIsNull() { + addCriterion("region_description is null"); + return (Criteria) this; + } + + public Criteria andRegionDescriptionIsNotNull() { + addCriterion("region_description is not null"); + return (Criteria) this; + } + + public Criteria andRegionDescriptionEqualTo(String value) { + addCriterion("region_description =", value, "regionDescription"); + return (Criteria) this; + } + + public Criteria andRegionDescriptionNotEqualTo(String value) { + addCriterion("region_description <>", value, "regionDescription"); + return (Criteria) this; + } + + public Criteria andRegionDescriptionGreaterThan(String value) { + addCriterion("region_description >", value, "regionDescription"); + return (Criteria) this; + } + + public Criteria andRegionDescriptionGreaterThanOrEqualTo(String value) { + addCriterion("region_description >=", value, "regionDescription"); + return (Criteria) this; + } + + public Criteria andRegionDescriptionLessThan(String value) { + addCriterion("region_description <", value, "regionDescription"); + return (Criteria) this; + } + + public Criteria andRegionDescriptionLessThanOrEqualTo(String value) { + addCriterion("region_description <=", value, "regionDescription"); + return (Criteria) this; + } + + public Criteria andRegionDescriptionLike(String value) { + addCriterion("region_description like", value, "regionDescription"); + return (Criteria) this; + } + + public Criteria andRegionDescriptionNotLike(String value) { + addCriterion("region_description not like", value, "regionDescription"); + return (Criteria) this; + } + + public Criteria andRegionDescriptionIn(List<String> values) { + addCriterion("region_description in", values, "regionDescription"); + return (Criteria) this; + } + + public Criteria andRegionDescriptionNotIn(List<String> values) { + addCriterion("region_description not in", values, "regionDescription"); + return (Criteria) this; + } + + public Criteria andRegionDescriptionBetween(String value1, String value2) { + addCriterion("region_description between", value1, value2, "regionDescription"); + return (Criteria) this; + } + + public Criteria andRegionDescriptionNotBetween(String value1, String value2) { + addCriterion("region_description not between", value1, value2, "regionDescription"); + return (Criteria) this; + } + + public Criteria andCreateTimeIsNull() { + addCriterion("create_time is null"); + return (Criteria) this; + } + + public Criteria andCreateTimeIsNotNull() { + addCriterion("create_time is not null"); + return (Criteria) this; + } + + public Criteria andCreateTimeEqualTo(Date value) { + addCriterion("create_time =", value, "createTime"); + return (Criteria) this; + } + + public Criteria andCreateTimeNotEqualTo(Date value) { + addCriterion("create_time <>", value, "createTime"); + return (Criteria) this; + } + + public Criteria andCreateTimeGreaterThan(Date value) { + addCriterion("create_time >", value, "createTime"); + return (Criteria) this; + } + + public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) { + addCriterion("create_time >=", value, "createTime"); + return (Criteria) this; + } + + public Criteria andCreateTimeLessThan(Date value) { + addCriterion("create_time <", value, "createTime"); + return (Criteria) this; + } + + public Criteria andCreateTimeLessThanOrEqualTo(Date value) { + addCriterion("create_time <=", value, "createTime"); + return (Criteria) this; + } + + public Criteria andCreateTimeIn(List<Date> values) { + addCriterion("create_time in", values, "createTime"); + return (Criteria) this; + } + + public Criteria andCreateTimeNotIn(List<Date> values) { + addCriterion("create_time not in", values, "createTime"); + return (Criteria) this; + } + + public Criteria andCreateTimeBetween(Date value1, Date value2) { + addCriterion("create_time between", value1, value2, "createTime"); + return (Criteria) this; + } + + public Criteria andCreateTimeNotBetween(Date value1, Date value2) { + addCriterion("create_time not between", value1, value2, "createTime"); + return (Criteria) this; + } + + public Criteria andOwnerIsNull() { + addCriterion("owner is null"); + return (Criteria) this; + } + + public Criteria andOwnerIsNotNull() { + addCriterion("owner is not null"); + return (Criteria) this; + } + + public Criteria andOwnerEqualTo(String value) { + addCriterion("owner =", value, "owner"); + return (Criteria) this; + } + + public Criteria andOwnerNotEqualTo(String value) { + addCriterion("owner <>", value, "owner"); + return (Criteria) this; + } + + public Criteria andOwnerGreaterThan(String value) { + addCriterion("owner >", value, "owner"); + return (Criteria) this; + } + + public Criteria andOwnerGreaterThanOrEqualTo(String value) { + addCriterion("owner >=", value, "owner"); + return (Criteria) this; + } + + public Criteria andOwnerLessThan(String value) { + addCriterion("owner <", value, "owner"); + return (Criteria) this; + } + + public Criteria andOwnerLessThanOrEqualTo(String value) { + addCriterion("owner <=", value, "owner"); + return (Criteria) this; + } + + public Criteria andOwnerLike(String value) { + addCriterion("owner like", value, "owner"); + return (Criteria) this; + } + + public Criteria andOwnerNotLike(String value) { + addCriterion("owner not like", value, "owner"); + return (Criteria) this; + } + + public Criteria andOwnerIn(List<String> values) { + addCriterion("owner in", values, "owner"); + return (Criteria) this; + } + + public Criteria andOwnerNotIn(List<String> values) { + addCriterion("owner not in", values, "owner"); + return (Criteria) this; + } + + public Criteria andOwnerBetween(String value1, String value2) { + addCriterion("owner between", value1, value2, "owner"); + return (Criteria) this; + } + + public Criteria andOwnerNotBetween(String value1, String value2) { + addCriterion("owner not between", value1, value2, "owner"); + return (Criteria) this; + } + } + + public static class Criteria extends GeneratedCriteria { + + protected Criteria() { + super(); + } + } + + public static class Criterion { + private String condition; + + private Object value; + + private Object secondValue; + + private boolean noValue; + + private boolean singleValue; + + private boolean betweenValue; + + private boolean listValue; + + private String typeHandler; + + public String getCondition() { + return condition; + } + + public Object getValue() { + return value; + } + + public Object getSecondValue() { + return secondValue; + } + + public boolean isNoValue() { + return noValue; + } + + public boolean isSingleValue() { + return singleValue; + } + + public boolean isBetweenValue() { + return betweenValue; + } + + public boolean isListValue() { + return listValue; + } + + public String getTypeHandler() { + return typeHandler; + } + + protected Criterion(String condition) { + super(); + this.condition = condition; + this.typeHandler = null; + this.noValue = true; + } + + protected Criterion(String condition, Object value, String typeHandler) { + super(); + this.condition = condition; + this.value = value; + this.typeHandler = typeHandler; + if (value instanceof List<?>) { + this.listValue = true; + } else { + this.singleValue = true; + } + } + + protected Criterion(String condition, Object value) { + this(condition, value, null); + } + + protected Criterion(String condition, Object value, Object secondValue, String typeHandler) { + super(); + this.condition = condition; + this.value = value; + this.secondValue = secondValue; + this.typeHandler = typeHandler; + this.betweenValue = true; + } + + protected Criterion(String condition, Object value, Object secondValue) { + this(condition, value, secondValue, null); + } + } +} \ No newline at end of file diff --git a/src/main/java/com/moral/monitor/entity/Sensor.java b/src/main/java/com/moral/monitor/entity/Sensor.java index 796f42a..adae357 100644 --- a/src/main/java/com/moral/monitor/entity/Sensor.java +++ b/src/main/java/com/moral/monitor/entity/Sensor.java @@ -1,83 +1,32 @@ package com.moral.monitor.entity; -/**��������������� - * Created by a on 2017/4/10. - */ public class Sensor { - private int id; + private Integer id; + private String type; + private String sensor; - private String sensor_desc; - private String mac_key; + + private String sensorDesc; + + private String macKey; + private String upper; + private String lower; + private String units; - private int digit; + + private Integer digit; + private String ver; - - public int getId() { + public Integer getId() { return id; } - public void setId(int id) { + public void setId(Integer id) { this.id = id; - } - - public String getSensor() { - return sensor; - } - - public void setSensor(String sensor) { - this.sensor = sensor; - } - - public String getSensor_desc() { - return sensor_desc; - } - - public void setSensor_desc(String sensor_desc) { - this.sensor_desc = sensor_desc; - } - - public String getMac_key() { - return mac_key; - } - - public void setMac_key(String mac_key) { - this.mac_key = mac_key; - } - - public String getUpper() { - return upper; - } - - public void setUpper(String upper) { - this.upper = upper; - } - - public String getLower() { - return lower; - } - - public void setLower(String lower) { - this.lower = lower; - } - - public String getUnits() { - return units; - } - - public void setUnits(String units) { - this.units = units; - } - - public int getDigit() { - return digit; - } - - public void setDigit(int digit) { - this.digit = digit; } public String getType() { @@ -85,7 +34,63 @@ } public void setType(String type) { - this.type = type; + this.type = type == null ? null : type.trim(); + } + + public String getSensor() { + return sensor; + } + + public void setSensor(String sensor) { + this.sensor = sensor == null ? null : sensor.trim(); + } + + public String getSensorDesc() { + return sensorDesc; + } + + public void setSensorDesc(String sensorDesc) { + this.sensorDesc = sensorDesc == null ? null : sensorDesc.trim(); + } + + public String getMacKey() { + return macKey; + } + + public void setMacKey(String macKey) { + this.macKey = macKey == null ? null : macKey.trim(); + } + + public String getUpper() { + return upper; + } + + public void setUpper(String upper) { + this.upper = upper == null ? null : upper.trim(); + } + + public String getLower() { + return lower; + } + + public void setLower(String lower) { + this.lower = lower == null ? null : lower.trim(); + } + + public String getUnits() { + return units; + } + + public void setUnits(String units) { + this.units = units == null ? null : units.trim(); + } + + public Integer getDigit() { + return digit; + } + + public void setDigit(Integer digit) { + this.digit = digit; } public String getVer() { @@ -93,6 +98,6 @@ } public void setVer(String ver) { - this.ver = ver; + this.ver = ver == null ? null : ver.trim(); } -} +} \ No newline at end of file diff --git a/src/main/java/com/moral/monitor/entity/SensorExample.java b/src/main/java/com/moral/monitor/entity/SensorExample.java new file mode 100644 index 0000000..5553556 --- /dev/null +++ b/src/main/java/com/moral/monitor/entity/SensorExample.java @@ -0,0 +1,880 @@ +package com.moral.monitor.entity; + +import java.util.ArrayList; +import java.util.List; + +public class SensorExample { + protected String orderByClause; + + protected boolean distinct; + + protected List<Criteria> oredCriteria; + + public SensorExample() { + oredCriteria = new ArrayList<Criteria>(); + } + + public void setOrderByClause(String orderByClause) { + this.orderByClause = orderByClause; + } + + public String getOrderByClause() { + return orderByClause; + } + + public void setDistinct(boolean distinct) { + this.distinct = distinct; + } + + public boolean isDistinct() { + return distinct; + } + + public List<Criteria> getOredCriteria() { + return oredCriteria; + } + + public void or(Criteria criteria) { + oredCriteria.add(criteria); + } + + public Criteria or() { + Criteria criteria = createCriteriaInternal(); + oredCriteria.add(criteria); + return criteria; + } + + public Criteria createCriteria() { + Criteria criteria = createCriteriaInternal(); + if (oredCriteria.size() == 0) { + oredCriteria.add(criteria); + } + return criteria; + } + + protected Criteria createCriteriaInternal() { + Criteria criteria = new Criteria(); + return criteria; + } + + public void clear() { + oredCriteria.clear(); + orderByClause = null; + distinct = false; + } + + protected abstract static class GeneratedCriteria { + protected List<Criterion> criteria; + + protected GeneratedCriteria() { + super(); + criteria = new ArrayList<Criterion>(); + } + + public boolean isValid() { + return criteria.size() > 0; + } + + public List<Criterion> getAllCriteria() { + return criteria; + } + + public List<Criterion> getCriteria() { + return criteria; + } + + protected void addCriterion(String condition) { + if (condition == null) { + throw new RuntimeException("Value for condition cannot be null"); + } + criteria.add(new Criterion(condition)); + } + + protected void addCriterion(String condition, Object value, String property) { + if (value == null) { + throw new RuntimeException("Value for " + property + " cannot be null"); + } + criteria.add(new Criterion(condition, value)); + } + + protected void addCriterion(String condition, Object value1, Object value2, String property) { + if (value1 == null || value2 == null) { + throw new RuntimeException("Between values for " + property + " cannot be null"); + } + criteria.add(new Criterion(condition, value1, value2)); + } + + public Criteria andIdIsNull() { + addCriterion("id is null"); + return (Criteria) this; + } + + public Criteria andIdIsNotNull() { + addCriterion("id is not null"); + return (Criteria) this; + } + + public Criteria andIdEqualTo(Integer value) { + addCriterion("id =", value, "id"); + return (Criteria) this; + } + + public Criteria andIdNotEqualTo(Integer value) { + addCriterion("id <>", value, "id"); + return (Criteria) this; + } + + public Criteria andIdGreaterThan(Integer value) { + addCriterion("id >", value, "id"); + return (Criteria) this; + } + + public Criteria andIdGreaterThanOrEqualTo(Integer value) { + addCriterion("id >=", value, "id"); + return (Criteria) this; + } + + public Criteria andIdLessThan(Integer value) { + addCriterion("id <", value, "id"); + return (Criteria) this; + } + + public Criteria andIdLessThanOrEqualTo(Integer value) { + addCriterion("id <=", value, "id"); + return (Criteria) this; + } + + public Criteria andIdIn(List<Integer> values) { + addCriterion("id in", values, "id"); + return (Criteria) this; + } + + public Criteria andIdNotIn(List<Integer> values) { + addCriterion("id not in", values, "id"); + return (Criteria) this; + } + + public Criteria andIdBetween(Integer value1, Integer value2) { + addCriterion("id between", value1, value2, "id"); + return (Criteria) this; + } + + public Criteria andIdNotBetween(Integer value1, Integer value2) { + addCriterion("id not between", value1, value2, "id"); + return (Criteria) this; + } + + public Criteria andTypeIsNull() { + addCriterion("type is null"); + return (Criteria) this; + } + + public Criteria andTypeIsNotNull() { + addCriterion("type is not null"); + return (Criteria) this; + } + + public Criteria andTypeEqualTo(String value) { + addCriterion("type =", value, "type"); + return (Criteria) this; + } + + public Criteria andTypeNotEqualTo(String value) { + addCriterion("type <>", value, "type"); + return (Criteria) this; + } + + public Criteria andTypeGreaterThan(String value) { + addCriterion("type >", value, "type"); + return (Criteria) this; + } + + public Criteria andTypeGreaterThanOrEqualTo(String value) { + addCriterion("type >=", value, "type"); + return (Criteria) this; + } + + public Criteria andTypeLessThan(String value) { + addCriterion("type <", value, "type"); + return (Criteria) this; + } + + public Criteria andTypeLessThanOrEqualTo(String value) { + addCriterion("type <=", value, "type"); + return (Criteria) this; + } + + public Criteria andTypeLike(String value) { + addCriterion("type like", value, "type"); + return (Criteria) this; + } + + public Criteria andTypeNotLike(String value) { + addCriterion("type not like", value, "type"); + return (Criteria) this; + } + + public Criteria andTypeIn(List<String> values) { + addCriterion("type in", values, "type"); + return (Criteria) this; + } + + public Criteria andTypeNotIn(List<String> values) { + addCriterion("type not in", values, "type"); + return (Criteria) this; + } + + public Criteria andTypeBetween(String value1, String value2) { + addCriterion("type between", value1, value2, "type"); + return (Criteria) this; + } + + public Criteria andTypeNotBetween(String value1, String value2) { + addCriterion("type not between", value1, value2, "type"); + return (Criteria) this; + } + + public Criteria andSensorIsNull() { + addCriterion("sensor is null"); + return (Criteria) this; + } + + public Criteria andSensorIsNotNull() { + addCriterion("sensor is not null"); + return (Criteria) this; + } + + public Criteria andSensorEqualTo(String value) { + addCriterion("sensor =", value, "sensor"); + return (Criteria) this; + } + + public Criteria andSensorNotEqualTo(String value) { + addCriterion("sensor <>", value, "sensor"); + return (Criteria) this; + } + + public Criteria andSensorGreaterThan(String value) { + addCriterion("sensor >", value, "sensor"); + return (Criteria) this; + } + + public Criteria andSensorGreaterThanOrEqualTo(String value) { + addCriterion("sensor >=", value, "sensor"); + return (Criteria) this; + } + + public Criteria andSensorLessThan(String value) { + addCriterion("sensor <", value, "sensor"); + return (Criteria) this; + } + + public Criteria andSensorLessThanOrEqualTo(String value) { + addCriterion("sensor <=", value, "sensor"); + return (Criteria) this; + } + + public Criteria andSensorLike(String value) { + addCriterion("sensor like", value, "sensor"); + return (Criteria) this; + } + + public Criteria andSensorNotLike(String value) { + addCriterion("sensor not like", value, "sensor"); + return (Criteria) this; + } + + public Criteria andSensorIn(List<String> values) { + addCriterion("sensor in", values, "sensor"); + return (Criteria) this; + } + + public Criteria andSensorNotIn(List<String> values) { + addCriterion("sensor not in", values, "sensor"); + return (Criteria) this; + } + + public Criteria andSensorBetween(String value1, String value2) { + addCriterion("sensor between", value1, value2, "sensor"); + return (Criteria) this; + } + + public Criteria andSensorNotBetween(String value1, String value2) { + addCriterion("sensor not between", value1, value2, "sensor"); + return (Criteria) this; + } + + public Criteria andSensorDescIsNull() { + addCriterion("sensor_desc is null"); + return (Criteria) this; + } + + public Criteria andSensorDescIsNotNull() { + addCriterion("sensor_desc is not null"); + return (Criteria) this; + } + + public Criteria andSensorDescEqualTo(String value) { + addCriterion("sensor_desc =", value, "sensorDesc"); + return (Criteria) this; + } + + public Criteria andSensorDescNotEqualTo(String value) { + addCriterion("sensor_desc <>", value, "sensorDesc"); + return (Criteria) this; + } + + public Criteria andSensorDescGreaterThan(String value) { + addCriterion("sensor_desc >", value, "sensorDesc"); + return (Criteria) this; + } + + public Criteria andSensorDescGreaterThanOrEqualTo(String value) { + addCriterion("sensor_desc >=", value, "sensorDesc"); + return (Criteria) this; + } + + public Criteria andSensorDescLessThan(String value) { + addCriterion("sensor_desc <", value, "sensorDesc"); + return (Criteria) this; + } + + public Criteria andSensorDescLessThanOrEqualTo(String value) { + addCriterion("sensor_desc <=", value, "sensorDesc"); + return (Criteria) this; + } + + public Criteria andSensorDescLike(String value) { + addCriterion("sensor_desc like", value, "sensorDesc"); + return (Criteria) this; + } + + public Criteria andSensorDescNotLike(String value) { + addCriterion("sensor_desc not like", value, "sensorDesc"); + return (Criteria) this; + } + + public Criteria andSensorDescIn(List<String> values) { + addCriterion("sensor_desc in", values, "sensorDesc"); + return (Criteria) this; + } + + public Criteria andSensorDescNotIn(List<String> values) { + addCriterion("sensor_desc not in", values, "sensorDesc"); + return (Criteria) this; + } + + public Criteria andSensorDescBetween(String value1, String value2) { + addCriterion("sensor_desc between", value1, value2, "sensorDesc"); + return (Criteria) this; + } + + public Criteria andSensorDescNotBetween(String value1, String value2) { + addCriterion("sensor_desc not between", value1, value2, "sensorDesc"); + return (Criteria) this; + } + + public Criteria andMacKeyIsNull() { + addCriterion("mac_key is null"); + return (Criteria) this; + } + + public Criteria andMacKeyIsNotNull() { + addCriterion("mac_key is not null"); + return (Criteria) this; + } + + public Criteria andMacKeyEqualTo(String value) { + addCriterion("mac_key =", value, "macKey"); + return (Criteria) this; + } + + public Criteria andMacKeyNotEqualTo(String value) { + addCriterion("mac_key <>", value, "macKey"); + return (Criteria) this; + } + + public Criteria andMacKeyGreaterThan(String value) { + addCriterion("mac_key >", value, "macKey"); + return (Criteria) this; + } + + public Criteria andMacKeyGreaterThanOrEqualTo(String value) { + addCriterion("mac_key >=", value, "macKey"); + return (Criteria) this; + } + + public Criteria andMacKeyLessThan(String value) { + addCriterion("mac_key <", value, "macKey"); + return (Criteria) this; + } + + public Criteria andMacKeyLessThanOrEqualTo(String value) { + addCriterion("mac_key <=", value, "macKey"); + return (Criteria) this; + } + + public Criteria andMacKeyLike(String value) { + addCriterion("mac_key like", value, "macKey"); + return (Criteria) this; + } + + public Criteria andMacKeyNotLike(String value) { + addCriterion("mac_key not like", value, "macKey"); + return (Criteria) this; + } + + public Criteria andMacKeyIn(List<String> values) { + addCriterion("mac_key in", values, "macKey"); + return (Criteria) this; + } + + public Criteria andMacKeyNotIn(List<String> values) { + addCriterion("mac_key not in", values, "macKey"); + return (Criteria) this; + } + + public Criteria andMacKeyBetween(String value1, String value2) { + addCriterion("mac_key between", value1, value2, "macKey"); + return (Criteria) this; + } + + public Criteria andMacKeyNotBetween(String value1, String value2) { + addCriterion("mac_key not between", value1, value2, "macKey"); + return (Criteria) this; + } + + public Criteria andUpperIsNull() { + addCriterion("upper is null"); + return (Criteria) this; + } + + public Criteria andUpperIsNotNull() { + addCriterion("upper is not null"); + return (Criteria) this; + } + + public Criteria andUpperEqualTo(String value) { + addCriterion("upper =", value, "upper"); + return (Criteria) this; + } + + public Criteria andUpperNotEqualTo(String value) { + addCriterion("upper <>", value, "upper"); + return (Criteria) this; + } + + public Criteria andUpperGreaterThan(String value) { + addCriterion("upper >", value, "upper"); + return (Criteria) this; + } + + public Criteria andUpperGreaterThanOrEqualTo(String value) { + addCriterion("upper >=", value, "upper"); + return (Criteria) this; + } + + public Criteria andUpperLessThan(String value) { + addCriterion("upper <", value, "upper"); + return (Criteria) this; + } + + public Criteria andUpperLessThanOrEqualTo(String value) { + addCriterion("upper <=", value, "upper"); + return (Criteria) this; + } + + public Criteria andUpperLike(String value) { + addCriterion("upper like", value, "upper"); + return (Criteria) this; + } + + public Criteria andUpperNotLike(String value) { + addCriterion("upper not like", value, "upper"); + return (Criteria) this; + } + + public Criteria andUpperIn(List<String> values) { + addCriterion("upper in", values, "upper"); + return (Criteria) this; + } + + public Criteria andUpperNotIn(List<String> values) { + addCriterion("upper not in", values, "upper"); + return (Criteria) this; + } + + public Criteria andUpperBetween(String value1, String value2) { + addCriterion("upper between", value1, value2, "upper"); + return (Criteria) this; + } + + public Criteria andUpperNotBetween(String value1, String value2) { + addCriterion("upper not between", value1, value2, "upper"); + return (Criteria) this; + } + + public Criteria andLowerIsNull() { + addCriterion("lower is null"); + return (Criteria) this; + } + + public Criteria andLowerIsNotNull() { + addCriterion("lower is not null"); + return (Criteria) this; + } + + public Criteria andLowerEqualTo(String value) { + addCriterion("lower =", value, "lower"); + return (Criteria) this; + } + + public Criteria andLowerNotEqualTo(String value) { + addCriterion("lower <>", value, "lower"); + return (Criteria) this; + } + + public Criteria andLowerGreaterThan(String value) { + addCriterion("lower >", value, "lower"); + return (Criteria) this; + } + + public Criteria andLowerGreaterThanOrEqualTo(String value) { + addCriterion("lower >=", value, "lower"); + return (Criteria) this; + } + + public Criteria andLowerLessThan(String value) { + addCriterion("lower <", value, "lower"); + return (Criteria) this; + } + + public Criteria andLowerLessThanOrEqualTo(String value) { + addCriterion("lower <=", value, "lower"); + return (Criteria) this; + } + + public Criteria andLowerLike(String value) { + addCriterion("lower like", value, "lower"); + return (Criteria) this; + } + + public Criteria andLowerNotLike(String value) { + addCriterion("lower not like", value, "lower"); + return (Criteria) this; + } + + public Criteria andLowerIn(List<String> values) { + addCriterion("lower in", values, "lower"); + return (Criteria) this; + } + + public Criteria andLowerNotIn(List<String> values) { + addCriterion("lower not in", values, "lower"); + return (Criteria) this; + } + + public Criteria andLowerBetween(String value1, String value2) { + addCriterion("lower between", value1, value2, "lower"); + return (Criteria) this; + } + + public Criteria andLowerNotBetween(String value1, String value2) { + addCriterion("lower not between", value1, value2, "lower"); + return (Criteria) this; + } + + public Criteria andUnitsIsNull() { + addCriterion("units is null"); + return (Criteria) this; + } + + public Criteria andUnitsIsNotNull() { + addCriterion("units is not null"); + return (Criteria) this; + } + + public Criteria andUnitsEqualTo(String value) { + addCriterion("units =", value, "units"); + return (Criteria) this; + } + + public Criteria andUnitsNotEqualTo(String value) { + addCriterion("units <>", value, "units"); + return (Criteria) this; + } + + public Criteria andUnitsGreaterThan(String value) { + addCriterion("units >", value, "units"); + return (Criteria) this; + } + + public Criteria andUnitsGreaterThanOrEqualTo(String value) { + addCriterion("units >=", value, "units"); + return (Criteria) this; + } + + public Criteria andUnitsLessThan(String value) { + addCriterion("units <", value, "units"); + return (Criteria) this; + } + + public Criteria andUnitsLessThanOrEqualTo(String value) { + addCriterion("units <=", value, "units"); + return (Criteria) this; + } + + public Criteria andUnitsLike(String value) { + addCriterion("units like", value, "units"); + return (Criteria) this; + } + + public Criteria andUnitsNotLike(String value) { + addCriterion("units not like", value, "units"); + return (Criteria) this; + } + + public Criteria andUnitsIn(List<String> values) { + addCriterion("units in", values, "units"); + return (Criteria) this; + } + + public Criteria andUnitsNotIn(List<String> values) { + addCriterion("units not in", values, "units"); + return (Criteria) this; + } + + public Criteria andUnitsBetween(String value1, String value2) { + addCriterion("units between", value1, value2, "units"); + return (Criteria) this; + } + + public Criteria andUnitsNotBetween(String value1, String value2) { + addCriterion("units not between", value1, value2, "units"); + return (Criteria) this; + } + + public Criteria andDigitIsNull() { + addCriterion("digit is null"); + return (Criteria) this; + } + + public Criteria andDigitIsNotNull() { + addCriterion("digit is not null"); + return (Criteria) this; + } + + public Criteria andDigitEqualTo(Integer value) { + addCriterion("digit =", value, "digit"); + return (Criteria) this; + } + + public Criteria andDigitNotEqualTo(Integer value) { + addCriterion("digit <>", value, "digit"); + return (Criteria) this; + } + + public Criteria andDigitGreaterThan(Integer value) { + addCriterion("digit >", value, "digit"); + return (Criteria) this; + } + + public Criteria andDigitGreaterThanOrEqualTo(Integer value) { + addCriterion("digit >=", value, "digit"); + return (Criteria) this; + } + + public Criteria andDigitLessThan(Integer value) { + addCriterion("digit <", value, "digit"); + return (Criteria) this; + } + + public Criteria andDigitLessThanOrEqualTo(Integer value) { + addCriterion("digit <=", value, "digit"); + return (Criteria) this; + } + + public Criteria andDigitIn(List<Integer> values) { + addCriterion("digit in", values, "digit"); + return (Criteria) this; + } + + public Criteria andDigitNotIn(List<Integer> values) { + addCriterion("digit not in", values, "digit"); + return (Criteria) this; + } + + public Criteria andDigitBetween(Integer value1, Integer value2) { + addCriterion("digit between", value1, value2, "digit"); + return (Criteria) this; + } + + public Criteria andDigitNotBetween(Integer value1, Integer value2) { + addCriterion("digit not between", value1, value2, "digit"); + return (Criteria) this; + } + + public Criteria andVerIsNull() { + addCriterion("ver is null"); + return (Criteria) this; + } + + public Criteria andVerIsNotNull() { + addCriterion("ver is not null"); + return (Criteria) this; + } + + public Criteria andVerEqualTo(String value) { + addCriterion("ver =", value, "ver"); + return (Criteria) this; + } + + public Criteria andVerNotEqualTo(String value) { + addCriterion("ver <>", value, "ver"); + return (Criteria) this; + } + + public Criteria andVerGreaterThan(String value) { + addCriterion("ver >", value, "ver"); + return (Criteria) this; + } + + public Criteria andVerGreaterThanOrEqualTo(String value) { + addCriterion("ver >=", value, "ver"); + return (Criteria) this; + } + + public Criteria andVerLessThan(String value) { + addCriterion("ver <", value, "ver"); + return (Criteria) this; + } + + public Criteria andVerLessThanOrEqualTo(String value) { + addCriterion("ver <=", value, "ver"); + return (Criteria) this; + } + + public Criteria andVerLike(String value) { + addCriterion("ver like", value, "ver"); + return (Criteria) this; + } + + public Criteria andVerNotLike(String value) { + addCriterion("ver not like", value, "ver"); + return (Criteria) this; + } + + public Criteria andVerIn(List<String> values) { + addCriterion("ver in", values, "ver"); + return (Criteria) this; + } + + public Criteria andVerNotIn(List<String> values) { + addCriterion("ver not in", values, "ver"); + return (Criteria) this; + } + + public Criteria andVerBetween(String value1, String value2) { + addCriterion("ver between", value1, value2, "ver"); + return (Criteria) this; + } + + public Criteria andVerNotBetween(String value1, String value2) { + addCriterion("ver not between", value1, value2, "ver"); + return (Criteria) this; + } + } + + public static class Criteria extends GeneratedCriteria { + + protected Criteria() { + super(); + } + } + + public static class Criterion { + private String condition; + + private Object value; + + private Object secondValue; + + private boolean noValue; + + private boolean singleValue; + + private boolean betweenValue; + + private boolean listValue; + + private String typeHandler; + + public String getCondition() { + return condition; + } + + public Object getValue() { + return value; + } + + public Object getSecondValue() { + return secondValue; + } + + public boolean isNoValue() { + return noValue; + } + + public boolean isSingleValue() { + return singleValue; + } + + public boolean isBetweenValue() { + return betweenValue; + } + + public boolean isListValue() { + return listValue; + } + + public String getTypeHandler() { + return typeHandler; + } + + protected Criterion(String condition) { + super(); + this.condition = condition; + this.typeHandler = null; + this.noValue = true; + } + + protected Criterion(String condition, Object value, String typeHandler) { + super(); + this.condition = condition; + this.value = value; + this.typeHandler = typeHandler; + if (value instanceof List<?>) { + this.listValue = true; + } else { + this.singleValue = true; + } + } + + protected Criterion(String condition, Object value) { + this(condition, value, null); + } + + protected Criterion(String condition, Object value, Object secondValue, String typeHandler) { + super(); + this.condition = condition; + this.value = value; + this.secondValue = secondValue; + this.typeHandler = typeHandler; + this.betweenValue = true; + } + + protected Criterion(String condition, Object value, Object secondValue) { + this(condition, value, secondValue, null); + } + } +} \ No newline at end of file diff --git a/src/main/java/com/moral/monitor/listener/Listener.java b/src/main/java/com/moral/monitor/listener/Listener.java index 70dcf96..b1ed5cb 100644 --- a/src/main/java/com/moral/monitor/listener/Listener.java +++ b/src/main/java/com/moral/monitor/listener/Listener.java @@ -1,287 +1,28 @@ package com.moral.monitor.listener; -import com.moral.monitor.dao.TaskDao; -import com.moral.monitor.entity.*; -import com.moral.monitor.listener.message.Tomq; -import net.sf.json.JSONObject; -import org.apache.commons.lang3.StringUtils; import org.slf4j.Logger; import org.slf4j.LoggerFactory; import org.springframework.amqp.core.Message; import org.springframework.amqp.core.MessageListener; import org.springframework.amqp.rabbit.core.RabbitTemplate; -import javax.annotation.Resource; -import java.io.UnsupportedEncodingException; -import java.math.BigDecimal; -import java.text.SimpleDateFormat; -import java.util.*; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.stereotype.Component; + +import com.moral.monitor.dao.TaskDao; /*���������������*/ +@Component public class Listener implements MessageListener { - @Resource + @Autowired RabbitTemplate rabbitTemplate; - @Resource - TaskDao taskDao; +// @Autowired +// Lo private Logger logger = LoggerFactory.getLogger(Listener.class); public void onMessage(Message message) { - logger.warn("���������������������������=" + Thread.currentThread().getName()); - - String receiveMsg = null; - try { - receiveMsg = new String(message.getBody(), "utf-8"); - } catch (UnsupportedEncodingException e) { - logger.warn(e.getMessage()); - } - - logger.warn(receiveMsg); - Map<String, String> receiveMsgMap = toMap(receiveMsg); - String mac = receiveMsgMap.remove("mac"); - String ver = receiveMsgMap.remove("ver"); - String rtime = receiveMsgMap.remove("time"); - String win = receiveMsgMap.remove("win"); - removeNotNumber(receiveMsgMap); - String date = getDate(); //logger���noticelog������ - Equipment equipment = taskDao.selectFromequipment(mac); - if (equipment==null) { - logger.warn("������" + mac + "������������������"); - return; - } - //������������������������4 - if (equipment.getState()==0) { - taskDao.updateequipmentstate(4, mac); - } - //eX���������������������������,��������������������������������� - Map<String, String> exsensorMap = exSensortoMap(ver); - taskDao.insertTologger(mac, receiveMsg, date); - //��������������������������������� - Map<String, String> bindsensor = macBindSensor(mac); - if (bindsensor.size()<=0) { - logger.warn("������" + mac + "���������������������������"); - return; - }else { - removeNotBind(receiveMsgMap,exsensorMap,bindsensor); - } - - - //��������������������������������������������� - List<State> states = taskDao.findstateBymac(mac); - updateOrinsertstate(receiveMsgMap, mac, exsensorMap); - if (states.size()==0){ - insertTohistory(receiveMsgMap, mac, exsensorMap); - } else { - insertTohistoryDistinct(receiveMsgMap,mac,exsensorMap,states); - } - - - //������������������ - List<Critical> criticals = taskDao.findcritical(); - LinkedHashMap<String, Critical> sensor_criticals = new LinkedHashMap<String, Critical>(); - for (Critical c:criticals){ - String sensor = c.getSensor(); - sensor_criticals.put(sensor,c); - } - - //��������������������������������������������������� - //������������������������ - List<Integer> level = new ArrayList<Integer>(); - Set<Map.Entry<String, String>> entries = receiveMsgMap.entrySet(); - Iterator<Map.Entry<String, String>> iterator = entries.iterator(); - while (iterator.hasNext()){ - Map.Entry<String, String> next = iterator.next(); - String mac_key = next.getKey(); - String mac_value = next.getValue(); - String sensor = exsensorMap.get(mac_key); - double value =Double.parseDouble(mac_value); - //��������������������� ��������������� - Critical critical = sensor_criticals.get(sensor); - - int sensor_level = 0; - if (value >= critical.getFirst()) { - level.add(1); - sensor_level =1; - } else if (value >= critical.getSecond()) { - level.add(2); - sensor_level = 2; - } else if (value >= critical.getThird()) { - level.add(3); - sensor_level = 3; - } - - if(sensor_level!=0){ - String alarmMsg = "{\"mac\":\"" + mac + "\",\"" +mac_key + "\":" + value + ",\"level\":" + sensor_level + "}"; - Tomq tomq = new Tomq(rabbitTemplate, alarmMsg); - tomq.run(); - } - - } - - //������������������ - if (!(level.size() > 0)) { - taskDao.updateequipmentstate(4, mac);//������������������������������������ - return; - } - - Integer maxlevel = Collections.max(level); - taskDao.updateequipmentstate(maxlevel, mac); + } - - - private String getDate() { - Date d = new Date(); - SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); - return formatter.format(d); - } - - private void saveNotice(Equipment equipment, User u, AlarmSensor sensor, String alarm_content, String noticetype, int sensor_level, String date) { - taskDao.insertTonoticelog(u.getId(), u.getName(), noticetype, equipment.getMac(), equipment.getName(), alarm_content, sensor.getSensor(), equipment.getAddress(), sensor_level, date); - } - - public String digit(double num, int digit) { - BigDecimal y = new BigDecimal(num); - double b = y.setScale(digit, BigDecimal.ROUND_HALF_UP).doubleValue(); - double c = b - (int) b; - if (c == 0) { - return String.valueOf((int) b); - } else { - return String.valueOf(b); - } - } - - private void updateOrinsertstate(Map<String, String> receiveMsgMap, String mac, Map<String, String> exsensorMap) { - Set<Map.Entry<String, String>> entries = receiveMsgMap.entrySet(); - Iterator<Map.Entry<String, String>> iterator = entries.iterator(); - while (iterator.hasNext()) { - Map.Entry<String, String> next = iterator.next(); - String mac_key = next.getKey(); - String mac_value = next.getValue(); - String sensor = exsensorMap.get(mac_key); - List<State> states = taskDao.selectFromstate(mac, mac_key);//������������������������������������������ - if (states.size() == 0) { - taskDao.insertTostate(mac, sensor, mac_key, mac_value); - } else if (states.size() == 1) { - taskDao.updatestate(mac_value, mac, mac_key); - } else if (states.size() >= 2) { - taskDao.deleteFromstateBymacandmackey(mac, mac_key); - taskDao.insertTostate(mac, sensor, mac_key, mac_value); - } - - } - } - - - - private void insertTohistoryDistinct(Map<String, String> receiveMsgMap, String mac, Map<String, String> exsensorMap,List<State> states){ - LinkedHashMap<String, Double> state_kv = new LinkedHashMap<String, Double>(); - for(State s:states){ - state_kv.put(s.getMac_key(),s.getMac_value()); - } - Set<Map.Entry<String, String>> entries = receiveMsgMap.entrySet(); - Iterator<Map.Entry<String, String>> iterator = entries.iterator(); - while(iterator.hasNext()){ - Map.Entry<String, String> next = iterator.next(); - String mac_key = next.getKey(); - String mac_value = next.getValue(); - double value =Double.parseDouble(mac_value); - String sensor = exsensorMap.get(mac_key); - Double statevalue = state_kv.get(mac_key); - if(value!=statevalue){ - taskDao.insertTohistory(mac, sensor, mac_key,mac_value); - } - } - - - } - - - - private void insertTohistory(Map<String, String> receiveMsgMap, String mac, Map<String, String> exsensorMap) { - Set<Map.Entry<String, String>> entries = receiveMsgMap.entrySet(); - Iterator<Map.Entry<String, String>> iterator = entries.iterator(); - while (iterator.hasNext()) { - Map.Entry<String, String> next = iterator.next(); - String mac_key = next.getKey(); - String mac_value = next.getValue(); - String sensor = exsensorMap.get(mac_key); - taskDao.insertTohistory(mac, sensor, mac_key, mac_value); - - } - } - - private Map<String, String> macBindSensor(String mac) { - Map<String, String> bindsensor = new LinkedHashMap<String, String>(); - List<AlarmSensor> alarmSensors = taskDao.selectFrommacBymac(mac); - for (AlarmSensor sensor : alarmSensors) { - String sensorname = sensor.getSensor(); - if (StringUtils.isNotBlank(sensorname)) { - bindsensor.put(sensorname, sensorname);//value��������� - } - } - return bindsensor; - } - - private Map<String, String> exSensortoMap(String ver) { - List<Sensor> sensors = taskDao.selectFromsensorByver(ver); - Map<String, String> ex_sensorMap = new LinkedHashMap<String, String>(); - for (Sensor sensor : sensors) { - ex_sensorMap.put(sensor.getMac_key(), sensor.getSensor()); - } - return ex_sensorMap; - } - - - - - private void removeNotBind(Map<String, String> receiveMsgMap,Map<String, String> exsensorMap,Map<String, String> bindsensor){ - Set<Map.Entry<String, String>> entries = receiveMsgMap.entrySet(); - Iterator<Map.Entry<String, String>> iterator = entries.iterator(); - while (iterator.hasNext()) { - Map.Entry<String, String> next = iterator.next(); - String mac_key = next.getKey(); - String sensor = exsensorMap.get(mac_key); - if(!bindsensor.containsKey(sensor)){ - iterator.remove(); - } - } - } - - - private void removeNotNumber(Map<String, String> receiveMsgMap){ - Set<Map.Entry<String, String>> entries = receiveMsgMap.entrySet(); - Iterator<Map.Entry<String, String>> iterator = entries.iterator(); - while (iterator.hasNext()) { - Map.Entry<String, String> next = iterator.next(); - String mac_value = next.getValue(); - boolean str2Num = isStr2Num(mac_value); - if (!str2Num) { - iterator.remove(); - } - } - } - - - private boolean isStr2Num(String str) { - try { - Double.parseDouble(str); - return true; - } catch (NumberFormatException e) { - return false; - } - } - - - private Map<String, String> toMap(String receiveMsg) { - Map<String, String> receiveMsgMap = new LinkedHashMap<String, String>(); - JSONObject jsonObject = JSONObject.fromObject(receiveMsg); - Iterator it = jsonObject.keys(); - while (it.hasNext()) { - String key = it.next().toString(); - String value = jsonObject.get(key).toString(); - receiveMsgMap.put(key, value); - } - return receiveMsgMap; - } } \ No newline at end of file diff --git a/src/main/java/com/moral/monitor/listener/MonitorListener.java b/src/main/java/com/moral/monitor/listener/MonitorListener.java index df7c2f5..366c523 100644 --- a/src/main/java/com/moral/monitor/listener/MonitorListener.java +++ b/src/main/java/com/moral/monitor/listener/MonitorListener.java @@ -258,7 +258,7 @@ List<Sensor> sensors = taskDao.selectFromsensorByver(ver); Map<String, String> ex_sensorMap = new LinkedHashMap<String, String>(); for (Sensor sensor : sensors) { - ex_sensorMap.put(sensor.getMac_key(), sensor.getSensor()); + ex_sensorMap.put(sensor.getMacKey(), sensor.getSensor()); } return ex_sensorMap; } diff --git a/src/main/java/com/moral/monitor/service/EquipmentService.java b/src/main/java/com/moral/monitor/service/EquipmentService.java new file mode 100644 index 0000000..ab0d6e9 --- /dev/null +++ b/src/main/java/com/moral/monitor/service/EquipmentService.java @@ -0,0 +1,9 @@ +package com.moral.monitor.service; +/** + * @author fengxiang + * @Time���2017���10���25��� ������2:22:21 + * @version 1.0 + */ +public interface EquipmentService { + +} diff --git a/src/main/java/com/moral/monitor/service/HistoryService.java b/src/main/java/com/moral/monitor/service/HistoryService.java new file mode 100644 index 0000000..d823884 --- /dev/null +++ b/src/main/java/com/moral/monitor/service/HistoryService.java @@ -0,0 +1,9 @@ +package com.moral.monitor.service; +/** + * @author fengxiang + * @Time���2017���10���25��� ������2:23:19 + * @version 1.0 + */ +public interface HistoryService { + +} diff --git a/src/main/java/com/moral/monitor/service/LoggerService.java b/src/main/java/com/moral/monitor/service/LoggerService.java new file mode 100644 index 0000000..50c5ecd --- /dev/null +++ b/src/main/java/com/moral/monitor/service/LoggerService.java @@ -0,0 +1,9 @@ +package com.moral.monitor.service; +/** + * @author fengxiang + * @Time���2017���10���25��� ������2:36:22 + * @version 1.0 + */ +public interface LoggerService { + +} diff --git a/src/main/java/com/moral/monitor/service/MgrService.java b/src/main/java/com/moral/monitor/service/MgrService.java index cbfbe72..651a575 100644 --- a/src/main/java/com/moral/monitor/service/MgrService.java +++ b/src/main/java/com/moral/monitor/service/MgrService.java @@ -15,18 +15,18 @@ @Resource MgrDao mgrDao; - public List<MonitorPoint> randpoint(){ + public List<Monitorpoint> randpoint(){ return mgrDao.randpoint(); } - public List<Equipment> pointequ(String monitorpoint){ - return mgrDao.pointequ(monitorpoint); + public List<Equipment> pointequ(String Monitorpoint){ + return mgrDao.pointequ(Monitorpoint); } public List<State> equsensorstate(String mac){return mgrDao.equsensorstate(mac);} - public List<MonitorPoint> allpoint(){ + public List<Monitorpoint> allpoint(){ return mgrDao.allpoint(); } diff --git a/src/main/java/com/moral/monitor/service/MonitorPointService.java b/src/main/java/com/moral/monitor/service/MonitorPointService.java deleted file mode 100644 index dcd899b..0000000 --- a/src/main/java/com/moral/monitor/service/MonitorPointService.java +++ /dev/null @@ -1,35 +0,0 @@ -package com.moral.monitor.service; - -import com.moral.monitor.dao.MonitorPointDao; -import com.moral.monitor.entity.MonitorPoint; -import com.moral.monitor.entity.QueryHelper; -import org.springframework.stereotype.Service; - -import javax.annotation.Resource; -import java.util.List; - -/** - * Created by a on 2017/7/18. - */ -@Service -public class MonitorPointService { - @Resource - MonitorPointDao monitorPointDao; - - public List<MonitorPoint> allMonitorPoint(QueryHelper queryHelper){return monitorPointDao.allMonitorPoint(queryHelper);} - public int monitorCount(QueryHelper queryHelper){return monitorPointDao.monitorCount(queryHelper);} - - - public void deleteMonitor(String id){monitorPointDao.deleteMonitor(id);} - - - public void addMonitorpoint(MonitorPoint monitorPoint){monitorPointDao.addMonitorpoint(monitorPoint);} - - public void updateMonitorpoint(MonitorPoint monitorPoint){ - monitorPointDao.updateMonitorpoint(monitorPoint); - } - - -} - - diff --git a/src/main/java/com/moral/monitor/service/MonitorpointService.java b/src/main/java/com/moral/monitor/service/MonitorpointService.java new file mode 100644 index 0000000..e4a455f --- /dev/null +++ b/src/main/java/com/moral/monitor/service/MonitorpointService.java @@ -0,0 +1,28 @@ +package com.moral.monitor.service; + +import com.moral.monitor.entity.Monitorpoint; +import com.moral.monitor.entity.QueryHelper; +import org.springframework.stereotype.Service; +import java.util.List; + +/** + * Created by a on 2017/7/18. + */ +@Service +public interface MonitorpointService { + public List<Monitorpoint> allMonitorpoint(QueryHelper queryHelper); + + public int monitorCount(QueryHelper queryHelper); + + + public void deleteMonitor(String id); + + + public void addMonitorpoint(Monitorpoint Monitorpoint); + + public void updateMonitorpoint(Monitorpoint Monitorpoint); + + +} + + diff --git a/src/main/java/com/moral/monitor/service/impl/LoggerServiceImpl.java b/src/main/java/com/moral/monitor/service/impl/LoggerServiceImpl.java new file mode 100644 index 0000000..ad85272 --- /dev/null +++ b/src/main/java/com/moral/monitor/service/impl/LoggerServiceImpl.java @@ -0,0 +1,22 @@ +package com.moral.monitor.service.impl; + +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.stereotype.Service; + +import com.moral.monitor.dao.LoggerMapper; +import com.moral.monitor.entity.Logger; +import com.moral.monitor.service.LoggerService; + +/** + * @author fengxiang + * @Time���2017���10���25��� ������2:37:55 + * @version 1.0 + */ +@Service +public class LoggerServiceImpl implements LoggerService { + @Autowired + LoggerMapper loggerMapper; + public void inserLogger(Logger logger) { + + } +} diff --git a/src/main/java/com/moral/monitor/service/impl/MonitorpointServiceImpl.java b/src/main/java/com/moral/monitor/service/impl/MonitorpointServiceImpl.java new file mode 100644 index 0000000..520800b --- /dev/null +++ b/src/main/java/com/moral/monitor/service/impl/MonitorpointServiceImpl.java @@ -0,0 +1,45 @@ +package com.moral.monitor.service.impl; + +import java.util.List; + +import javax.annotation.Resource; + +import com.moral.monitor.dao.MonitorpointDao; +import com.moral.monitor.entity.Monitorpoint; +import com.moral.monitor.entity.QueryHelper; +import com.moral.monitor.service.MonitorpointService; + +/** + * @author fengxiang + * @Time���2017���10���25��� ������2:24:46 + * @version 1.0 + */ +public class MonitorpointServiceImpl implements MonitorpointService { + @Resource + MonitorpointDao monitorpointDao; + public List<Monitorpoint> allMonitorpoint(QueryHelper queryHelper) { + // TODO Auto-generated method stub + return null; + } + + public int monitorCount(QueryHelper queryHelper) { + // TODO Auto-generated method stub + return 0; + } + + public void deleteMonitor(String id) { + // TODO Auto-generated method stub + + } + + public void addMonitorpoint(Monitorpoint Monitorpoint) { + // TODO Auto-generated method stub + + } + + public void updateMonitorpoint(Monitorpoint Monitorpoint) { + // TODO Auto-generated method stub + + } + +} diff --git a/src/main/resources/mapper/EquipmentMapper.java b/src/main/resources/mapper/EquipmentMapper.java new file mode 100644 index 0000000..78e3e8d --- /dev/null +++ b/src/main/resources/mapper/EquipmentMapper.java @@ -0,0 +1,30 @@ +package mapper; + +import com.moral.monitor.entity.Equipment; +import com.moral.monitor.entity.EquipmentExample; +import java.util.List; +import org.apache.ibatis.annotations.Param; + +public interface EquipmentMapper { + long countByExample(EquipmentExample example); + + int deleteByExample(EquipmentExample example); + + int deleteByPrimaryKey(Integer id); + + int insert(Equipment record); + + int insertSelective(Equipment record); + + List<Equipment> selectByExample(EquipmentExample example); + + Equipment selectByPrimaryKey(Integer id); + + int updateByExampleSelective(@Param("record") Equipment record, @Param("example") EquipmentExample example); + + int updateByExample(@Param("record") Equipment record, @Param("example") EquipmentExample example); + + int updateByPrimaryKeySelective(Equipment record); + + int updateByPrimaryKey(Equipment record); +} \ No newline at end of file diff --git a/src/main/resources/mapper/HistoryMapper.java b/src/main/resources/mapper/HistoryMapper.java new file mode 100644 index 0000000..05a2b1f --- /dev/null +++ b/src/main/resources/mapper/HistoryMapper.java @@ -0,0 +1,30 @@ +package mapper; + +import com.moral.monitor.entity.History; +import com.moral.monitor.entity.HistoryExample; +import java.util.List; +import org.apache.ibatis.annotations.Param; + +public interface HistoryMapper { + long countByExample(HistoryExample example); + + int deleteByExample(HistoryExample example); + + int deleteByPrimaryKey(Integer id); + + int insert(History record); + + int insertSelective(History record); + + List<History> selectByExample(HistoryExample example); + + History selectByPrimaryKey(Integer id); + + int updateByExampleSelective(@Param("record") History record, @Param("example") HistoryExample example); + + int updateByExample(@Param("record") History record, @Param("example") HistoryExample example); + + int updateByPrimaryKeySelective(History record); + + int updateByPrimaryKey(History record); +} \ No newline at end of file diff --git a/src/main/resources/mapper/LoggerMapper.java b/src/main/resources/mapper/LoggerMapper.java new file mode 100644 index 0000000..603dd48 --- /dev/null +++ b/src/main/resources/mapper/LoggerMapper.java @@ -0,0 +1,30 @@ +package mapper; + +import com.moral.monitor.entity.Logger; +import com.moral.monitor.entity.LoggerExample; +import java.util.List; +import org.apache.ibatis.annotations.Param; + +public interface LoggerMapper { + long countByExample(LoggerExample example); + + int deleteByExample(LoggerExample example); + + int deleteByPrimaryKey(Integer id); + + int insert(Logger record); + + int insertSelective(Logger record); + + List<Logger> selectByExample(LoggerExample example); + + Logger selectByPrimaryKey(Integer id); + + int updateByExampleSelective(@Param("record") Logger record, @Param("example") LoggerExample example); + + int updateByExample(@Param("record") Logger record, @Param("example") LoggerExample example); + + int updateByPrimaryKeySelective(Logger record); + + int updateByPrimaryKey(Logger record); +} \ No newline at end of file diff --git a/src/main/resources/mapper/MonitorpointDao.java b/src/main/resources/mapper/MonitorpointDao.java new file mode 100644 index 0000000..b31bb3d --- /dev/null +++ b/src/main/resources/mapper/MonitorpointDao.java @@ -0,0 +1,30 @@ +package mapper; + +import com.moral.monitor.entity.Monitorpoint; +import com.moral.monitor.entity.MonitorpointExample; +import java.util.List; +import org.apache.ibatis.annotations.Param; + +public interface MonitorpointDao { + long countByExample(MonitorpointExample example); + + int deleteByExample(MonitorpointExample example); + + int deleteByPrimaryKey(String id); + + int insert(Monitorpoint record); + + int insertSelective(Monitorpoint record); + + List<Monitorpoint> selectByExample(MonitorpointExample example); + + Monitorpoint selectByPrimaryKey(String id); + + int updateByExampleSelective(@Param("record") Monitorpoint record, @Param("example") MonitorpointExample example); + + int updateByExample(@Param("record") Monitorpoint record, @Param("example") MonitorpointExample example); + + int updateByPrimaryKeySelective(Monitorpoint record); + + int updateByPrimaryKey(Monitorpoint record); +} \ No newline at end of file diff --git a/src/main/resources/mapper/SensorMapper.java b/src/main/resources/mapper/SensorMapper.java new file mode 100644 index 0000000..5a4e44b --- /dev/null +++ b/src/main/resources/mapper/SensorMapper.java @@ -0,0 +1,30 @@ +package mapper; + +import com.moral.monitor.entity.Sensor; +import com.moral.monitor.entity.SensorExample; +import java.util.List; +import org.apache.ibatis.annotations.Param; + +public interface SensorMapper { + long countByExample(SensorExample example); + + int deleteByExample(SensorExample example); + + int deleteByPrimaryKey(Integer id); + + int insert(Sensor record); + + int insertSelective(Sensor record); + + List<Sensor> selectByExample(SensorExample example); + + Sensor selectByPrimaryKey(Integer id); + + int updateByExampleSelective(@Param("record") Sensor record, @Param("example") SensorExample example); + + int updateByExample(@Param("record") Sensor record, @Param("example") SensorExample example); + + int updateByPrimaryKeySelective(Sensor record); + + int updateByPrimaryKey(Sensor record); +} \ No newline at end of file -- Gitblit v1.8.0