From dba72443e05e7b0a52ee85bfd9f4641aebc42c60 Mon Sep 17 00:00:00 2001 From: xufenglei <xufenglei> Date: Thu, 07 Dec 2017 08:58:09 +0800 Subject: [PATCH] app接口 --- src/main/resources/mapper/OperateUserMapper.xml | 289 ------- src/main/java/com/moral/common/mapper/BaseMapper.java | 29 src/main/java/com/moral/mapper/OrganizationRelationMapper.java | 6 src/main/resources/mapper/OrganizationRelationMapper.xml | 172 ---- src/main/java/com/moral/config/MapperScannerConfig.java | 26 src/main/java/com/moral/controller/MobileController.java | 71 + src/main/java/com/moral/mapper/HistoryMapper.java | 3 src/main/java/com/moral/service/OperateUserService.java | 4 src/main/resources/mapper/AccountMapper.xml | 275 ------ src/main/java/com/moral/config/PageHelperConfig.java | 25 src/main/java/com/moral/mapper/UserMapper.java | 2 src/main/java/com/moral/service/impl/OperateUserServiceImpl.java | 37 pom.xml | 22 src/main/java/com/moral/common/util/ValidateUtil.java | 37 src/main/java/com/moral/service/impl/DeviceServiceImpl.java | 38 src/main/java/com/moral/mapper/AccountMapper.java | 6 src/main/java/com/moral/service/DeviceService.java | 6 src/main/java/com/moral/entity/OperateUser.java | 5 src/main/java/com/moral/mapper/DeviceMapper.java | 5 src/main/java/com/moral/controller/ScreenController.java | 28 src/main/resources/mapper/OrganizationMapper.xml | 320 ------- src/main/java/com/moral/service/impl/AccountServiceImpl.java | 15 src/main/java/com/moral/common/exception/ValidateException.java | 26 src/main/resources/mapper/DeviceMapper.xml | 375 --------- src/main/java/com/moral/common/bean/ResultBean.java | 22 src/main/java/com/moral/entity/Device.java | 51 + /dev/null | 380 --------- src/main/java/com/moral/service/impl/HistoryServiceImpl.java | 1 src/main/java/com/moral/mapper/OperateUserMapper.java | 6 src/test/java/com/moral/MybatisConfig.java | 23 src/main/java/com/moral/common/aop/ControllerAOP.java | 55 + src/main/java/com/moral/service/impl/OrganizationServiceImpl.java | 7 src/main/java/com/moral/mapper/OrganizationMapper.java | 6 src/main/resources/application.yml | 8 34 files changed, 446 insertions(+), 1,935 deletions(-) diff --git a/pom.xml b/pom.xml index 46215af..5e54f94 100644 --- a/pom.xml +++ b/pom.xml @@ -95,11 +95,11 @@ <artifactId>mysql-connector-java</artifactId> <version>5.1.44</version> </dependency> + <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-data-mongodb</artifactId> </dependency> - <dependency> <groupId>org.apache.commons</groupId> <artifactId>commons-lang3</artifactId> @@ -122,15 +122,25 @@ <classifier>jdk15</classifier> </dependency> <dependency> - <groupId>org.projectlombok</groupId> - <artifactId>lombok</artifactId> - <version>1.16.18</version> - </dependency> + <groupId>org.projectlombok</groupId> + <artifactId>lombok</artifactId> + <version>1.16.18</version> + </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-aop</artifactId> </dependency> - </dependencies> + <dependency> + <groupId>com.github.pagehelper</groupId> + <artifactId>pagehelper</artifactId> + <version>4.2.1</version> + </dependency> + <dependency> + <groupId>tk.mybatis</groupId> + <artifactId>mapper</artifactId> + <version>3.3.9</version> + </dependency> + </dependencies> <build> <plugins> diff --git a/src/main/java/com/moral/common/aop/ControllerAOP.java b/src/main/java/com/moral/common/aop/ControllerAOP.java index bd542c7..a30d404 100644 --- a/src/main/java/com/moral/common/aop/ControllerAOP.java +++ b/src/main/java/com/moral/common/aop/ControllerAOP.java @@ -1,14 +1,21 @@ package com.moral.common.aop; +import java.lang.reflect.Method; +import java.lang.reflect.ParameterizedType; +import java.lang.reflect.Type; import java.util.HashMap; import java.util.Map; import org.aspectj.lang.ProceedingJoinPoint; +import org.aspectj.lang.Signature; import org.aspectj.lang.annotation.Around; import org.aspectj.lang.annotation.Aspect; +import org.aspectj.lang.reflect.MethodSignature; import org.springframework.stereotype.Component; +import com.moral.common.bean.ResultBean; import com.moral.common.exception.BusinessException; +import com.moral.common.exception.ValidateException; import lombok.extern.log4j.Log4j; @@ -16,13 +23,15 @@ @Aspect @Component public class ControllerAOP { - + @Around("execution(* com.moral.controller.*Controller.*(..))") - public Object handlerControllerMethod(ProceedingJoinPoint pjp) { + public Object handlerControllerMethod(ProceedingJoinPoint pjp) throws Exception { + long startTime = System.currentTimeMillis(); - Map<String, Object> result; + Object result; + try { - result = (Map<String, Object>) pjp.proceed(); + result = pjp.proceed(); log.info(pjp.getSignature() + "use time:" + (System.currentTimeMillis() - startTime)); } catch (Throwable e) { result = handlerException(pjp, e); @@ -31,18 +40,40 @@ return result; } - private Map<String, Object> handlerException(ProceedingJoinPoint pjp, Throwable e) { - Map<String, Object> result = new HashMap<String, Object>(); - - // ������������ + @SuppressWarnings("rawtypes") + private Object handlerException(ProceedingJoinPoint pjp, Throwable e) throws Exception { + Signature sig = pjp.getSignature(); + MethodSignature msig = null; + if (!(sig instanceof MethodSignature)) { + throw new IllegalArgumentException("���������������������������"); + } + msig = (MethodSignature) sig; + Object target = pjp.getTarget(); + Method currentMethod = target.getClass().getMethod(msig.getName(), msig.getParameterTypes()); + Type type = currentMethod.getGenericReturnType(); + String message = ""; if (e instanceof BusinessException) { - result.put("msg", e.getLocalizedMessage()); + message = e.getLocalizedMessage(); + } else if (e instanceof ValidateException) { + message = e.getLocalizedMessage(); } else { log.error(pjp.getSignature() + " error ", e); - result.put("msg", e.toString()); - //TODO ������������������������������������������������������������������ + message = e.toString(); } - return result; + if (type instanceof ParameterizedType) { + Type rawType = ((ParameterizedType) type).getRawType(); + if (rawType == ResultBean.class) { + ResultBean<?> resultBean = new ResultBean(ResultBean.FAIL); + resultBean.setMessage(message); + return resultBean; + } else if (rawType == Map.class) { + Map<String, Object> result = new HashMap<String, Object>(); + result.put("msg",message); + return result; + } + } + return null; + } } diff --git a/src/main/java/com/moral/common/bean/ResultBean.java b/src/main/java/com/moral/common/bean/ResultBean.java index 6506493..7e74ecb 100644 --- a/src/main/java/com/moral/common/bean/ResultBean.java +++ b/src/main/java/com/moral/common/bean/ResultBean.java @@ -9,11 +9,11 @@ private static final long serialVersionUID = 1L; - public static final int FAIL = 0; - public static final int SUCCESS = 1; + public static final int SUCCESS = 0; + public static final int FAIL = 1; public static final int NO_PERMISSION = 2; - private String msg = "success"; - private int code = SUCCESS; + private String message = "success"; + private int errno = SUCCESS; private T data; public ResultBean() { super(); @@ -25,16 +25,16 @@ public ResultBean(Throwable e) { super(); - this.msg = e.toString(); - this.code = FAIL; + this.message = e.toString(); + this.errno = FAIL; } - public ResultBean(String msg, int code) { + public ResultBean(String message, int errno) { super(); - this.msg = msg; - this.code = code; + this.message = message; + this.errno = errno; } - public ResultBean(int code) { + public ResultBean(int errno) { super(); - this.code = code; + this.errno = errno; } } diff --git a/src/main/java/com/moral/common/exception/ValidateException.java b/src/main/java/com/moral/common/exception/ValidateException.java new file mode 100644 index 0000000..124a371 --- /dev/null +++ b/src/main/java/com/moral/common/exception/ValidateException.java @@ -0,0 +1,26 @@ +package com.moral.common.exception; + +public class ValidateException extends RuntimeException { + + private static final long serialVersionUID = 1L; + + public ValidateException() { + } + + public ValidateException(String message) { + super(message); + } + + public ValidateException(Throwable cause) { + super(cause); + } + + public ValidateException(String message, Throwable cause) { + super(message, cause); + } + + public ValidateException(String message, Throwable cause, boolean enableSuppression, boolean writableStackTrace) { + super(message, cause, enableSuppression, writableStackTrace); + } + +} diff --git a/src/main/java/com/moral/common/mapper/BaseMapper.java b/src/main/java/com/moral/common/mapper/BaseMapper.java index 20a1454..139da85 100644 --- a/src/main/java/com/moral/common/mapper/BaseMapper.java +++ b/src/main/java/com/moral/common/mapper/BaseMapper.java @@ -1,31 +1,8 @@ package com.moral.common.mapper; -import java.io.Serializable; -import java.util.List; +import tk.mybatis.mapper.common.Mapper; +import tk.mybatis.mapper.common.MySqlMapper; -import org.apache.ibatis.annotations.Param; -import org.springframework.dao.DataAccessException; +public interface BaseMapper<T> extends Mapper<T>,MySqlMapper<T> { -public interface BaseMapper<Entity, Example, PK extends Serializable> extends Serializable { - int insert(Entity record) throws DataAccessException; - - int insertSelective(Entity record) throws DataAccessException; - - int deleteByPrimaryKey(PK PK) throws DataAccessException; - - int deleteByExample(Example example) throws DataAccessException; - - int updateByPrimaryKeySelective(Entity record) throws DataAccessException; - - int updateByPrimaryKey(Entity record) throws DataAccessException; - - int updateByExampleSelective(@Param("record") Entity record, @Param("example") Example example)throws DataAccessException; - - int updateByExample(@Param("record") Entity record, @Param("example") Example example) throws DataAccessException; - - int countByExample(Example example) throws DataAccessException; - - Entity selectByPrimaryKey(PK pk) throws DataAccessException; - - List<Entity> selectByExample(Example example) throws DataAccessException; } diff --git a/src/main/java/com/moral/common/util/ValidateUtil.java b/src/main/java/com/moral/common/util/ValidateUtil.java new file mode 100644 index 0000000..da579bc --- /dev/null +++ b/src/main/java/com/moral/common/util/ValidateUtil.java @@ -0,0 +1,37 @@ +package com.moral.common.util; + +import java.util.Locale; + +import org.springframework.context.MessageSource; + +import com.moral.common.exception.ValidateException; + +public class ValidateUtil { + private static MessageSource resources; + + public static void setResources(MessageSource resources) { + ValidateUtil.resources = resources; + } + + public static void check(boolean condition, String msgKey, Object... args) { + if (!condition) { + fail(msgKey, args); + } + } + + public static void notEmpty(String str, String msgKey, Object... args) { + if (str == null || str.trim().isEmpty()) { + fail(msgKey, args); + } + } + + public static void notNull(Object obj, String msgKey, Object... args) { + if (obj == null) { + fail(msgKey, args); + } + } + + private static void fail(String msgKey, Object... args) { + throw new ValidateException(resources.getMessage(msgKey, args, Locale.CHINESE)); + } +} diff --git a/src/main/java/com/moral/config/MapperScannerConfig.java b/src/main/java/com/moral/config/MapperScannerConfig.java new file mode 100644 index 0000000..c612d32 --- /dev/null +++ b/src/main/java/com/moral/config/MapperScannerConfig.java @@ -0,0 +1,26 @@ +package com.moral.config; + +import java.util.Properties; +import org.springframework.context.annotation.Bean; +import org.springframework.context.annotation.Configuration; + +import com.moral.common.mapper.BaseMapper; + +import tk.mybatis.spring.mapper.MapperScannerConfigurer; + +@Configuration +public class MapperScannerConfig { + @Bean + public MapperScannerConfigurer mapperScannerConfigurer() { + MapperScannerConfigurer mapperScannerConfigurer = new MapperScannerConfigurer(); + mapperScannerConfigurer.setSqlSessionFactoryBeanName("sqlSessionFactory"); + mapperScannerConfigurer.setBasePackage("com.moral.mapper");//���������������������dao + Properties properties = new Properties(); + properties.setProperty("mappers", BaseMapper.class.getName());//������dao + properties.setProperty("notEmpty", "false"); + properties.setProperty("IDENTITY", "MYSQL"); + mapperScannerConfigurer.setProperties(properties); + return mapperScannerConfigurer; + } + +} diff --git a/src/main/java/com/moral/config/PageHelperConfig.java b/src/main/java/com/moral/config/PageHelperConfig.java new file mode 100644 index 0000000..d51c7e7 --- /dev/null +++ b/src/main/java/com/moral/config/PageHelperConfig.java @@ -0,0 +1,25 @@ +package com.moral.config; + +import java.util.Properties; + +import org.springframework.cache.annotation.EnableCaching; +import org.springframework.context.annotation.Bean; +import org.springframework.context.annotation.Configuration; + +import com.github.pagehelper.PageHelper; + +@Configuration +@EnableCaching +public class PageHelperConfig { + @Bean + public PageHelper pageHelper(){ + PageHelper pageHelper = new PageHelper(); + Properties properties = new Properties(); + properties.setProperty("offsetAsPageNum","true"); + properties.setProperty("rowBoundsWithCount","true"); + properties.setProperty("reasonable","true"); + properties.setProperty("dialect","mysql"); //������mysql������������������ + pageHelper.setProperties(properties); + return pageHelper; + } +} \ No newline at end of file diff --git a/src/main/java/com/moral/controller/MobileController.java b/src/main/java/com/moral/controller/MobileController.java new file mode 100644 index 0000000..d178bc7 --- /dev/null +++ b/src/main/java/com/moral/controller/MobileController.java @@ -0,0 +1,71 @@ +package com.moral.controller; + +import java.util.List; + +import javax.annotation.Resource; + +import org.springframework.web.bind.annotation.CrossOrigin; +import org.springframework.web.bind.annotation.GetMapping; +import org.springframework.web.bind.annotation.RequestMapping; +import org.springframework.web.bind.annotation.RestController; + +import com.github.pagehelper.PageHelper; +import com.moral.common.bean.PageBean; +import com.moral.common.bean.ResultBean; +import com.moral.entity.Device; +import com.moral.entity.OperateUser; +import com.moral.service.DeviceService; +import com.moral.service.OperateUserService; + +@RestController +@RequestMapping(value = "mobile") +@CrossOrigin(origins = "*", maxAge = 3600) +public class MobileController { + + @Resource + private OperateUserService operateUserService; + + @Resource + private DeviceService deviceService; + + // 1������ + @GetMapping(value = "accountlogin") + public ResultBean<OperateUser> mobileLogin(String username, String password) { + OperateUser operateUser = operateUserService.mobileLogin(username,password); + return new ResultBean<OperateUser>(operateUser); + } + + // 4������������ + @GetMapping(value = "upPassword") + public ResultBean<OperateUser> updatePassword(Integer uid, String password, String newpassword) { + OperateUser operateUser = operateUserService.updatePassword(uid,password,newpassword); + return new ResultBean<OperateUser>(operateUser); + } + + // 11������������ + @GetMapping(value = "reportDevice") + public ResultBean<String> installDevice(Device device) { + deviceService.saveOrUpdateDevice(device); + return new ResultBean<String>(""); + } + + // 5������������������(������) + @GetMapping(value = "myRelease") + public ResultBean<List<Device>> getInstallDevicesByOperateUser(Integer uid, Integer pageIndex, Integer pageSize) { + List<Device> devices = deviceService.getInstallDevicesByOperateUser(uid,pageIndex,pageSize); + return new ResultBean<List<Device>>(devices); + } + + @GetMapping(value = "getEquInfoByMac") + public void getEquInfoByMac(String mac) { + } + + @GetMapping(value = "getMpointsByAreaName") + public void getMpointsByAreaName(String areaName) { + } + + @GetMapping(value = "getOrgsByAreaName") + public void getOrgsByAreaName(String areaName) { + + } +} diff --git a/src/main/java/com/moral/controller/ScreenController.java b/src/main/java/com/moral/controller/ScreenController.java index f752dc3..0da945c 100644 --- a/src/main/java/com/moral/controller/ScreenController.java +++ b/src/main/java/com/moral/controller/ScreenController.java @@ -26,15 +26,14 @@ import com.alibaba.fastjson.JSON; import com.alibaba.fastjson.JSONReader; import com.alibaba.fastjson.TypeReference; -import com.moral.common.bean.ResultBean; import com.moral.common.exception.BusinessException; -import com.moral.entity.Account; +import com.moral.common.util.ValidateUtil; import com.moral.service.AccountService; import com.moral.service.DeviceService; import com.moral.service.HistoryService; /** - * The Class ScreenController. + * The Class ScreenController.������������ */ @RestController @RequestMapping(value = "screen") @@ -84,22 +83,6 @@ return resultMap; } - @GetMapping("login1") - public ResultBean<Account> screenLogin1(HttpServletRequest request) { - ResultBean<Account> resultBean = new ResultBean<Account>(ResultBean.FAIL); - try { - Map<String, Object> parameters = getParametersStartingWith(request, null); - if (!(parameters.containsKey("account") && parameters.containsKey("password"))) { - resultBean.setMsg("������������������������������������"); - } else { - resultBean = accountService.screenLogin1(parameters); - } - } catch (Exception e) { - e.printStackTrace(); - resultBean = new ResultBean<Account>(e); - } - return resultBean; - } /** * Gets the equipment states. ��������������������������������������� @@ -156,11 +139,8 @@ @GetMapping("sensor-standard") public Map<String, Object> getStandardBySensor(@RequestParam("macKey") String macKey) { Map<String, Object> result = new HashMap<String, Object>(); - if (isEmpty(macKey)) { - throw new BusinessException("���������������������"); - } else { - result.put("standard", getValue(macKey + "-standard")); - } + ValidateUtil.notEmpty(macKey, "���������������������"); + result.put("standard", getValue(macKey + "-standard")); return result; } diff --git a/src/main/java/com/moral/entity/AccountExample.java b/src/main/java/com/moral/entity/AccountExample.java deleted file mode 100644 index afe9f2a..0000000 --- a/src/main/java/com/moral/entity/AccountExample.java +++ /dev/null @@ -1,855 +0,0 @@ -package com.moral.entity; - -import java.util.ArrayList; -import java.util.Date; -import java.util.List; - -public class AccountExample { - protected String orderByClause; - - protected boolean distinct; - - protected List<Criteria> oredCriteria; - - public AccountExample() { - 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 andAccountNameIsNull() { - addCriterion("account_name is null"); - return (Criteria) this; - } - - public Criteria andAccountNameIsNotNull() { - addCriterion("account_name is not null"); - return (Criteria) this; - } - - public Criteria andAccountNameEqualTo(String value) { - addCriterion("account_name =", value, "accountName"); - return (Criteria) this; - } - - public Criteria andAccountNameNotEqualTo(String value) { - addCriterion("account_name <>", value, "accountName"); - return (Criteria) this; - } - - public Criteria andAccountNameGreaterThan(String value) { - addCriterion("account_name >", value, "accountName"); - return (Criteria) this; - } - - public Criteria andAccountNameGreaterThanOrEqualTo(String value) { - addCriterion("account_name >=", value, "accountName"); - return (Criteria) this; - } - - public Criteria andAccountNameLessThan(String value) { - addCriterion("account_name <", value, "accountName"); - return (Criteria) this; - } - - public Criteria andAccountNameLessThanOrEqualTo(String value) { - addCriterion("account_name <=", value, "accountName"); - return (Criteria) this; - } - - public Criteria andAccountNameLike(String value) { - addCriterion("account_name like", value, "accountName"); - return (Criteria) this; - } - - public Criteria andAccountNameNotLike(String value) { - addCriterion("account_name not like", value, "accountName"); - return (Criteria) this; - } - - public Criteria andAccountNameIn(List<String> values) { - addCriterion("account_name in", values, "accountName"); - return (Criteria) this; - } - - public Criteria andAccountNameNotIn(List<String> values) { - addCriterion("account_name not in", values, "accountName"); - return (Criteria) this; - } - - public Criteria andAccountNameBetween(String value1, String value2) { - addCriterion("account_name between", value1, value2, "accountName"); - return (Criteria) this; - } - - public Criteria andAccountNameNotBetween(String value1, String value2) { - addCriterion("account_name not between", value1, value2, "accountName"); - return (Criteria) this; - } - - public Criteria andPasswordIsNull() { - addCriterion("password is null"); - return (Criteria) this; - } - - public Criteria andPasswordIsNotNull() { - addCriterion("password is not null"); - return (Criteria) this; - } - - public Criteria andPasswordEqualTo(String value) { - addCriterion("password =", value, "password"); - return (Criteria) this; - } - - public Criteria andPasswordNotEqualTo(String value) { - addCriterion("password <>", value, "password"); - return (Criteria) this; - } - - public Criteria andPasswordGreaterThan(String value) { - addCriterion("password >", value, "password"); - return (Criteria) this; - } - - public Criteria andPasswordGreaterThanOrEqualTo(String value) { - addCriterion("password >=", value, "password"); - return (Criteria) this; - } - - public Criteria andPasswordLessThan(String value) { - addCriterion("password <", value, "password"); - return (Criteria) this; - } - - public Criteria andPasswordLessThanOrEqualTo(String value) { - addCriterion("password <=", value, "password"); - return (Criteria) this; - } - - public Criteria andPasswordLike(String value) { - addCriterion("password like", value, "password"); - return (Criteria) this; - } - - public Criteria andPasswordNotLike(String value) { - addCriterion("password not like", value, "password"); - return (Criteria) this; - } - - public Criteria andPasswordIn(List<String> values) { - addCriterion("password in", values, "password"); - return (Criteria) this; - } - - public Criteria andPasswordNotIn(List<String> values) { - addCriterion("password not in", values, "password"); - return (Criteria) this; - } - - public Criteria andPasswordBetween(String value1, String value2) { - addCriterion("password between", value1, value2, "password"); - return (Criteria) this; - } - - public Criteria andPasswordNotBetween(String value1, String value2) { - addCriterion("password not between", value1, value2, "password"); - return (Criteria) this; - } - - public Criteria andOrganizationIdIsNull() { - addCriterion("organization_id is null"); - return (Criteria) this; - } - - public Criteria andOrganizationIdIsNotNull() { - addCriterion("organization_id is not null"); - return (Criteria) this; - } - - public Criteria andOrganizationIdEqualTo(Integer value) { - addCriterion("organization_id =", value, "organizationId"); - return (Criteria) this; - } - - public Criteria andOrganizationIdNotEqualTo(Integer value) { - addCriterion("organization_id <>", value, "organizationId"); - return (Criteria) this; - } - - public Criteria andOrganizationIdGreaterThan(Integer value) { - addCriterion("organization_id >", value, "organizationId"); - return (Criteria) this; - } - - public Criteria andOrganizationIdGreaterThanOrEqualTo(Integer value) { - addCriterion("organization_id >=", value, "organizationId"); - return (Criteria) this; - } - - public Criteria andOrganizationIdLessThan(Integer value) { - addCriterion("organization_id <", value, "organizationId"); - return (Criteria) this; - } - - public Criteria andOrganizationIdLessThanOrEqualTo(Integer value) { - addCriterion("organization_id <=", value, "organizationId"); - return (Criteria) this; - } - - public Criteria andOrganizationIdIn(List<Integer> values) { - addCriterion("organization_id in", values, "organizationId"); - return (Criteria) this; - } - - public Criteria andOrganizationIdNotIn(List<Integer> values) { - addCriterion("organization_id not in", values, "organizationId"); - return (Criteria) this; - } - - public Criteria andOrganizationIdBetween(Integer value1, Integer value2) { - addCriterion("organization_id between", value1, value2, "organizationId"); - return (Criteria) this; - } - - public Criteria andOrganizationIdNotBetween(Integer value1, Integer value2) { - addCriterion("organization_id not between", value1, value2, "organizationId"); - return (Criteria) this; - } - - public Criteria andEmailIsNull() { - addCriterion("email is null"); - return (Criteria) this; - } - - public Criteria andEmailIsNotNull() { - addCriterion("email is not null"); - return (Criteria) this; - } - - public Criteria andEmailEqualTo(String value) { - addCriterion("email =", value, "email"); - return (Criteria) this; - } - - public Criteria andEmailNotEqualTo(String value) { - addCriterion("email <>", value, "email"); - return (Criteria) this; - } - - public Criteria andEmailGreaterThan(String value) { - addCriterion("email >", value, "email"); - return (Criteria) this; - } - - public Criteria andEmailGreaterThanOrEqualTo(String value) { - addCriterion("email >=", value, "email"); - return (Criteria) this; - } - - public Criteria andEmailLessThan(String value) { - addCriterion("email <", value, "email"); - return (Criteria) this; - } - - public Criteria andEmailLessThanOrEqualTo(String value) { - addCriterion("email <=", value, "email"); - return (Criteria) this; - } - - public Criteria andEmailLike(String value) { - addCriterion("email like", value, "email"); - return (Criteria) this; - } - - public Criteria andEmailNotLike(String value) { - addCriterion("email not like", value, "email"); - return (Criteria) this; - } - - public Criteria andEmailIn(List<String> values) { - addCriterion("email in", values, "email"); - return (Criteria) this; - } - - public Criteria andEmailNotIn(List<String> values) { - addCriterion("email not in", values, "email"); - return (Criteria) this; - } - - public Criteria andEmailBetween(String value1, String value2) { - addCriterion("email between", value1, value2, "email"); - return (Criteria) this; - } - - public Criteria andEmailNotBetween(String value1, String value2) { - addCriterion("email not between", value1, value2, "email"); - return (Criteria) this; - } - - public Criteria andMobileIsNull() { - addCriterion("mobile is null"); - return (Criteria) this; - } - - public Criteria andMobileIsNotNull() { - addCriterion("mobile is not null"); - return (Criteria) this; - } - - public Criteria andMobileEqualTo(String value) { - addCriterion("mobile =", value, "mobile"); - return (Criteria) this; - } - - public Criteria andMobileNotEqualTo(String value) { - addCriterion("mobile <>", value, "mobile"); - return (Criteria) this; - } - - public Criteria andMobileGreaterThan(String value) { - addCriterion("mobile >", value, "mobile"); - return (Criteria) this; - } - - public Criteria andMobileGreaterThanOrEqualTo(String value) { - addCriterion("mobile >=", value, "mobile"); - return (Criteria) this; - } - - public Criteria andMobileLessThan(String value) { - addCriterion("mobile <", value, "mobile"); - return (Criteria) this; - } - - public Criteria andMobileLessThanOrEqualTo(String value) { - addCriterion("mobile <=", value, "mobile"); - return (Criteria) this; - } - - public Criteria andMobileLike(String value) { - addCriterion("mobile like", value, "mobile"); - return (Criteria) this; - } - - public Criteria andMobileNotLike(String value) { - addCriterion("mobile not like", value, "mobile"); - return (Criteria) this; - } - - public Criteria andMobileIn(List<String> values) { - addCriterion("mobile in", values, "mobile"); - return (Criteria) this; - } - - public Criteria andMobileNotIn(List<String> values) { - addCriterion("mobile not in", values, "mobile"); - return (Criteria) this; - } - - public Criteria andMobileBetween(String value1, String value2) { - addCriterion("mobile between", value1, value2, "mobile"); - return (Criteria) this; - } - - public Criteria andMobileNotBetween(String value1, String value2) { - addCriterion("mobile not between", value1, value2, "mobile"); - return (Criteria) this; - } - - public Criteria andWeixinIsNull() { - addCriterion("weixin is null"); - return (Criteria) this; - } - - public Criteria andWeixinIsNotNull() { - addCriterion("weixin is not null"); - return (Criteria) this; - } - - public Criteria andWeixinEqualTo(String value) { - addCriterion("weixin =", value, "weixin"); - return (Criteria) this; - } - - public Criteria andWeixinNotEqualTo(String value) { - addCriterion("weixin <>", value, "weixin"); - return (Criteria) this; - } - - public Criteria andWeixinGreaterThan(String value) { - addCriterion("weixin >", value, "weixin"); - return (Criteria) this; - } - - public Criteria andWeixinGreaterThanOrEqualTo(String value) { - addCriterion("weixin >=", value, "weixin"); - return (Criteria) this; - } - - public Criteria andWeixinLessThan(String value) { - addCriterion("weixin <", value, "weixin"); - return (Criteria) this; - } - - public Criteria andWeixinLessThanOrEqualTo(String value) { - addCriterion("weixin <=", value, "weixin"); - return (Criteria) this; - } - - public Criteria andWeixinLike(String value) { - addCriterion("weixin like", value, "weixin"); - return (Criteria) this; - } - - public Criteria andWeixinNotLike(String value) { - addCriterion("weixin not like", value, "weixin"); - return (Criteria) this; - } - - public Criteria andWeixinIn(List<String> values) { - addCriterion("weixin in", values, "weixin"); - return (Criteria) this; - } - - public Criteria andWeixinNotIn(List<String> values) { - addCriterion("weixin not in", values, "weixin"); - return (Criteria) this; - } - - public Criteria andWeixinBetween(String value1, String value2) { - addCriterion("weixin between", value1, value2, "weixin"); - return (Criteria) this; - } - - public Criteria andWeixinNotBetween(String value1, String value2) { - addCriterion("weixin not between", value1, value2, "weixin"); - return (Criteria) this; - } - - public Criteria andIsDeleteIsNull() { - addCriterion("is_delete is null"); - return (Criteria) this; - } - - public Criteria andIsDeleteIsNotNull() { - addCriterion("is_delete is not null"); - return (Criteria) this; - } - - public Criteria andIsDeleteEqualTo(String value) { - addCriterion("is_delete =", value, "isDelete"); - return (Criteria) this; - } - - public Criteria andIsDeleteNotEqualTo(String value) { - addCriterion("is_delete <>", value, "isDelete"); - return (Criteria) this; - } - - public Criteria andIsDeleteGreaterThan(String value) { - addCriterion("is_delete >", value, "isDelete"); - return (Criteria) this; - } - - public Criteria andIsDeleteGreaterThanOrEqualTo(String value) { - addCriterion("is_delete >=", value, "isDelete"); - return (Criteria) this; - } - - public Criteria andIsDeleteLessThan(String value) { - addCriterion("is_delete <", value, "isDelete"); - return (Criteria) this; - } - - public Criteria andIsDeleteLessThanOrEqualTo(String value) { - addCriterion("is_delete <=", value, "isDelete"); - return (Criteria) this; - } - - public Criteria andIsDeleteLike(String value) { - addCriterion("is_delete like", value, "isDelete"); - return (Criteria) this; - } - - public Criteria andIsDeleteNotLike(String value) { - addCriterion("is_delete not like", value, "isDelete"); - return (Criteria) this; - } - - public Criteria andIsDeleteIn(List<String> values) { - addCriterion("is_delete in", values, "isDelete"); - return (Criteria) this; - } - - public Criteria andIsDeleteNotIn(List<String> values) { - addCriterion("is_delete not in", values, "isDelete"); - return (Criteria) this; - } - - public Criteria andIsDeleteBetween(String value1, String value2) { - addCriterion("is_delete between", value1, value2, "isDelete"); - return (Criteria) this; - } - - public Criteria andIsDeleteNotBetween(String value1, String value2) { - addCriterion("is_delete not between", value1, value2, "isDelete"); - 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 andExpireTimeIsNull() { - addCriterion("expire_time is null"); - return (Criteria) this; - } - - public Criteria andExpireTimeIsNotNull() { - addCriterion("expire_time is not null"); - return (Criteria) this; - } - - public Criteria andExpireTimeEqualTo(Date value) { - addCriterion("expire_time =", value, "expireTime"); - return (Criteria) this; - } - - public Criteria andExpireTimeNotEqualTo(Date value) { - addCriterion("expire_time <>", value, "expireTime"); - return (Criteria) this; - } - - public Criteria andExpireTimeGreaterThan(Date value) { - addCriterion("expire_time >", value, "expireTime"); - return (Criteria) this; - } - - public Criteria andExpireTimeGreaterThanOrEqualTo(Date value) { - addCriterion("expire_time >=", value, "expireTime"); - return (Criteria) this; - } - - public Criteria andExpireTimeLessThan(Date value) { - addCriterion("expire_time <", value, "expireTime"); - return (Criteria) this; - } - - public Criteria andExpireTimeLessThanOrEqualTo(Date value) { - addCriterion("expire_time <=", value, "expireTime"); - return (Criteria) this; - } - - public Criteria andExpireTimeIn(List<Date> values) { - addCriterion("expire_time in", values, "expireTime"); - return (Criteria) this; - } - - public Criteria andExpireTimeNotIn(List<Date> values) { - addCriterion("expire_time not in", values, "expireTime"); - return (Criteria) this; - } - - public Criteria andExpireTimeBetween(Date value1, Date value2) { - addCriterion("expire_time between", value1, value2, "expireTime"); - return (Criteria) this; - } - - public Criteria andExpireTimeNotBetween(Date value1, Date value2) { - addCriterion("expire_time not between", value1, value2, "expireTime"); - 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/entity/Device.java b/src/main/java/com/moral/entity/Device.java index 83a0858..ca4ebc2 100644 --- a/src/main/java/com/moral/entity/Device.java +++ b/src/main/java/com/moral/entity/Device.java @@ -4,6 +4,10 @@ import lombok.Data; + +/** + * Instantiates a new device. + */ @Data public class Device {/** * This field was generated by MyBatis Generator. This field corresponds to the database column device.id @@ -65,4 +69,51 @@ * @mbggenerated Wed Nov 29 16:17:59 CST 2017 */ private Integer deviceVersionId; + + /** + * Sets the uid. + * + * @param uid the new uid + */ + public void setUid(Integer uid) { + this.operateUserId = uid; + } + + /** + * Sets the device name. + * + * @param device_name the new device name + */ + public void setDevice_name(String device_name) { + this.name = device_name; + } + + /** + * Gets the device name. + * + * @return the device name + */ + public String getDevice_name() { + return name; + } + + /** + * Sets the monitorpoint. + * + * @param monitorpoint the new monitorpoint + */ + public void setMonitorpoint(Integer monitorpoint) { + this.monitorPointId = monitorpoint; + } + + /** + * Gets the status. + * + * @return the status + */ + public String getStatus() { + return state; + } + + } \ No newline at end of file diff --git a/src/main/java/com/moral/entity/DeviceExample.java b/src/main/java/com/moral/entity/DeviceExample.java deleted file mode 100644 index 756e5fe..0000000 --- a/src/main/java/com/moral/entity/DeviceExample.java +++ /dev/null @@ -1,1020 +0,0 @@ -package com.moral.entity; - -import java.util.ArrayList; -import java.util.Date; -import java.util.List; - -public class DeviceExample { - /** - * This field was generated by MyBatis Generator. This field corresponds to the database table device - * @mbggenerated Wed Nov 29 16:17:59 CST 2017 - */ - protected String orderByClause; - /** - * This field was generated by MyBatis Generator. This field corresponds to the database table device - * @mbggenerated Wed Nov 29 16:17:59 CST 2017 - */ - protected boolean distinct; - /** - * This field was generated by MyBatis Generator. This field corresponds to the database table device - * @mbggenerated Wed Nov 29 16:17:59 CST 2017 - */ - protected List<Criteria> oredCriteria; - - /** - * This method was generated by MyBatis Generator. This method corresponds to the database table device - * @mbggenerated Wed Nov 29 16:17:59 CST 2017 - */ - public DeviceExample() { - oredCriteria = new ArrayList<Criteria>(); - } - - /** - * This method was generated by MyBatis Generator. This method corresponds to the database table device - * @mbggenerated Wed Nov 29 16:17:59 CST 2017 - */ - public void setOrderByClause(String orderByClause) { - this.orderByClause = orderByClause; - } - - /** - * This method was generated by MyBatis Generator. This method corresponds to the database table device - * @mbggenerated Wed Nov 29 16:17:59 CST 2017 - */ - public String getOrderByClause() { - return orderByClause; - } - - /** - * This method was generated by MyBatis Generator. This method corresponds to the database table device - * @mbggenerated Wed Nov 29 16:17:59 CST 2017 - */ - public void setDistinct(boolean distinct) { - this.distinct = distinct; - } - - /** - * This method was generated by MyBatis Generator. This method corresponds to the database table device - * @mbggenerated Wed Nov 29 16:17:59 CST 2017 - */ - public boolean isDistinct() { - return distinct; - } - - /** - * This method was generated by MyBatis Generator. This method corresponds to the database table device - * @mbggenerated Wed Nov 29 16:17:59 CST 2017 - */ - public List<Criteria> getOredCriteria() { - return oredCriteria; - } - - /** - * This method was generated by MyBatis Generator. This method corresponds to the database table device - * @mbggenerated Wed Nov 29 16:17:59 CST 2017 - */ - public void or(Criteria criteria) { - oredCriteria.add(criteria); - } - - /** - * This method was generated by MyBatis Generator. This method corresponds to the database table device - * @mbggenerated Wed Nov 29 16:17:59 CST 2017 - */ - public Criteria or() { - Criteria criteria = createCriteriaInternal(); - oredCriteria.add(criteria); - return criteria; - } - - /** - * This method was generated by MyBatis Generator. This method corresponds to the database table device - * @mbggenerated Wed Nov 29 16:17:59 CST 2017 - */ - public Criteria createCriteria() { - Criteria criteria = createCriteriaInternal(); - if (oredCriteria.size() == 0) { - oredCriteria.add(criteria); - } - return criteria; - } - - /** - * This method was generated by MyBatis Generator. This method corresponds to the database table device - * @mbggenerated Wed Nov 29 16:17:59 CST 2017 - */ - protected Criteria createCriteriaInternal() { - Criteria criteria = new Criteria(); - return criteria; - } - - /** - * This method was generated by MyBatis Generator. This method corresponds to the database table device - * @mbggenerated Wed Nov 29 16:17:59 CST 2017 - */ - public void clear() { - oredCriteria.clear(); - orderByClause = null; - distinct = false; - } - - /** - * This class was generated by MyBatis Generator. This class corresponds to the database table device - * @mbggenerated Wed Nov 29 16:17:59 CST 2017 - */ - 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(Float value) { - addCriterion("longitude =", value, "longitude"); - return (Criteria) this; - } - - public Criteria andLongitudeNotEqualTo(Float value) { - addCriterion("longitude <>", value, "longitude"); - return (Criteria) this; - } - - public Criteria andLongitudeGreaterThan(Float value) { - addCriterion("longitude >", value, "longitude"); - return (Criteria) this; - } - - public Criteria andLongitudeGreaterThanOrEqualTo(Float value) { - addCriterion("longitude >=", value, "longitude"); - return (Criteria) this; - } - - public Criteria andLongitudeLessThan(Float value) { - addCriterion("longitude <", value, "longitude"); - return (Criteria) this; - } - - public Criteria andLongitudeLessThanOrEqualTo(Float value) { - addCriterion("longitude <=", value, "longitude"); - return (Criteria) this; - } - - public Criteria andLongitudeIn(List<Float> values) { - addCriterion("longitude in", values, "longitude"); - return (Criteria) this; - } - - public Criteria andLongitudeNotIn(List<Float> values) { - addCriterion("longitude not in", values, "longitude"); - return (Criteria) this; - } - - public Criteria andLongitudeBetween(Float value1, Float value2) { - addCriterion("longitude between", value1, value2, "longitude"); - return (Criteria) this; - } - - public Criteria andLongitudeNotBetween(Float value1, Float 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(Float value) { - addCriterion("latitude =", value, "latitude"); - return (Criteria) this; - } - - public Criteria andLatitudeNotEqualTo(Float value) { - addCriterion("latitude <>", value, "latitude"); - return (Criteria) this; - } - - public Criteria andLatitudeGreaterThan(Float value) { - addCriterion("latitude >", value, "latitude"); - return (Criteria) this; - } - - public Criteria andLatitudeGreaterThanOrEqualTo(Float value) { - addCriterion("latitude >=", value, "latitude"); - return (Criteria) this; - } - - public Criteria andLatitudeLessThan(Float value) { - addCriterion("latitude <", value, "latitude"); - return (Criteria) this; - } - - public Criteria andLatitudeLessThanOrEqualTo(Float value) { - addCriterion("latitude <=", value, "latitude"); - return (Criteria) this; - } - - public Criteria andLatitudeIn(List<Float> values) { - addCriterion("latitude in", values, "latitude"); - return (Criteria) this; - } - - public Criteria andLatitudeNotIn(List<Float> values) { - addCriterion("latitude not in", values, "latitude"); - return (Criteria) this; - } - - public Criteria andLatitudeBetween(Float value1, Float value2) { - addCriterion("latitude between", value1, value2, "latitude"); - return (Criteria) this; - } - - public Criteria andLatitudeNotBetween(Float value1, Float 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 andOperateUserIdIsNull() { - addCriterion("operate_user_id is null"); - return (Criteria) this; - } - - public Criteria andOperateUserIdIsNotNull() { - addCriterion("operate_user_id is not null"); - return (Criteria) this; - } - - public Criteria andOperateUserIdEqualTo(Integer value) { - addCriterion("operate_user_id =", value, "operateUserId"); - return (Criteria) this; - } - - public Criteria andOperateUserIdNotEqualTo(Integer value) { - addCriterion("operate_user_id <>", value, "operateUserId"); - return (Criteria) this; - } - - public Criteria andOperateUserIdGreaterThan(Integer value) { - addCriterion("operate_user_id >", value, "operateUserId"); - return (Criteria) this; - } - - public Criteria andOperateUserIdGreaterThanOrEqualTo(Integer value) { - addCriterion("operate_user_id >=", value, "operateUserId"); - return (Criteria) this; - } - - public Criteria andOperateUserIdLessThan(Integer value) { - addCriterion("operate_user_id <", value, "operateUserId"); - return (Criteria) this; - } - - public Criteria andOperateUserIdLessThanOrEqualTo(Integer value) { - addCriterion("operate_user_id <=", value, "operateUserId"); - return (Criteria) this; - } - - public Criteria andOperateUserIdIn(List<Integer> values) { - addCriterion("operate_user_id in", values, "operateUserId"); - return (Criteria) this; - } - - public Criteria andOperateUserIdNotIn(List<Integer> values) { - addCriterion("operate_user_id not in", values, "operateUserId"); - return (Criteria) this; - } - - public Criteria andOperateUserIdBetween(Integer value1, Integer value2) { - addCriterion("operate_user_id between", value1, value2, "operateUserId"); - return (Criteria) this; - } - - public Criteria andOperateUserIdNotBetween(Integer value1, Integer value2) { - addCriterion("operate_user_id not between", value1, value2, "operateUserId"); - 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(String value) { - addCriterion("state =", value, "state"); - return (Criteria) this; - } - - public Criteria andStateNotEqualTo(String value) { - addCriterion("state <>", value, "state"); - return (Criteria) this; - } - - public Criteria andStateGreaterThan(String value) { - addCriterion("state >", value, "state"); - return (Criteria) this; - } - - public Criteria andStateGreaterThanOrEqualTo(String value) { - addCriterion("state >=", value, "state"); - return (Criteria) this; - } - - public Criteria andStateLessThan(String value) { - addCriterion("state <", value, "state"); - return (Criteria) this; - } - - public Criteria andStateLessThanOrEqualTo(String value) { - addCriterion("state <=", value, "state"); - return (Criteria) this; - } - - public Criteria andStateLike(String value) { - addCriterion("state like", value, "state"); - return (Criteria) this; - } - - public Criteria andStateNotLike(String value) { - addCriterion("state not like", value, "state"); - return (Criteria) this; - } - - public Criteria andStateIn(List<String> values) { - addCriterion("state in", values, "state"); - return (Criteria) this; - } - - public Criteria andStateNotIn(List<String> values) { - addCriterion("state not in", values, "state"); - return (Criteria) this; - } - - public Criteria andStateBetween(String value1, String value2) { - addCriterion("state between", value1, value2, "state"); - return (Criteria) this; - } - - public Criteria andStateNotBetween(String value1, String value2) { - addCriterion("state not between", value1, value2, "state"); - 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 andInstallTimeIsNull() { - addCriterion("install_time is null"); - return (Criteria) this; - } - - public Criteria andInstallTimeIsNotNull() { - addCriterion("install_time is not null"); - return (Criteria) this; - } - - public Criteria andInstallTimeEqualTo(Date value) { - addCriterion("install_time =", value, "installTime"); - return (Criteria) this; - } - - public Criteria andInstallTimeNotEqualTo(Date value) { - addCriterion("install_time <>", value, "installTime"); - return (Criteria) this; - } - - public Criteria andInstallTimeGreaterThan(Date value) { - addCriterion("install_time >", value, "installTime"); - return (Criteria) this; - } - - public Criteria andInstallTimeGreaterThanOrEqualTo(Date value) { - addCriterion("install_time >=", value, "installTime"); - return (Criteria) this; - } - - public Criteria andInstallTimeLessThan(Date value) { - addCriterion("install_time <", value, "installTime"); - return (Criteria) this; - } - - public Criteria andInstallTimeLessThanOrEqualTo(Date value) { - addCriterion("install_time <=", value, "installTime"); - return (Criteria) this; - } - - public Criteria andInstallTimeIn(List<Date> values) { - addCriterion("install_time in", values, "installTime"); - return (Criteria) this; - } - - public Criteria andInstallTimeNotIn(List<Date> values) { - addCriterion("install_time not in", values, "installTime"); - return (Criteria) this; - } - - public Criteria andInstallTimeBetween(Date value1, Date value2) { - addCriterion("install_time between", value1, value2, "installTime"); - return (Criteria) this; - } - - public Criteria andInstallTimeNotBetween(Date value1, Date value2) { - addCriterion("install_time not between", value1, value2, "installTime"); - return (Criteria) this; - } - - public Criteria andMonitorPointIdIsNull() { - addCriterion("monitor_point_id is null"); - return (Criteria) this; - } - - public Criteria andMonitorPointIdIsNotNull() { - addCriterion("monitor_point_id is not null"); - return (Criteria) this; - } - - public Criteria andMonitorPointIdEqualTo(Integer value) { - addCriterion("monitor_point_id =", value, "monitorPointId"); - return (Criteria) this; - } - - public Criteria andMonitorPointIdNotEqualTo(Integer value) { - addCriterion("monitor_point_id <>", value, "monitorPointId"); - return (Criteria) this; - } - - public Criteria andMonitorPointIdGreaterThan(Integer value) { - addCriterion("monitor_point_id >", value, "monitorPointId"); - return (Criteria) this; - } - - public Criteria andMonitorPointIdGreaterThanOrEqualTo(Integer value) { - addCriterion("monitor_point_id >=", value, "monitorPointId"); - return (Criteria) this; - } - - public Criteria andMonitorPointIdLessThan(Integer value) { - addCriterion("monitor_point_id <", value, "monitorPointId"); - return (Criteria) this; - } - - public Criteria andMonitorPointIdLessThanOrEqualTo(Integer value) { - addCriterion("monitor_point_id <=", value, "monitorPointId"); - return (Criteria) this; - } - - public Criteria andMonitorPointIdIn(List<Integer> values) { - addCriterion("monitor_point_id in", values, "monitorPointId"); - return (Criteria) this; - } - - public Criteria andMonitorPointIdNotIn(List<Integer> values) { - addCriterion("monitor_point_id not in", values, "monitorPointId"); - return (Criteria) this; - } - - public Criteria andMonitorPointIdBetween(Integer value1, Integer value2) { - addCriterion("monitor_point_id between", value1, value2, "monitorPointId"); - return (Criteria) this; - } - - public Criteria andMonitorPointIdNotBetween(Integer value1, Integer value2) { - addCriterion("monitor_point_id not between", value1, value2, "monitorPointId"); - return (Criteria) this; - } - - public Criteria andDeviceVersionIdIsNull() { - addCriterion("device_version_id is null"); - return (Criteria) this; - } - - public Criteria andDeviceVersionIdIsNotNull() { - addCriterion("device_version_id is not null"); - return (Criteria) this; - } - - public Criteria andDeviceVersionIdEqualTo(Integer value) { - addCriterion("device_version_id =", value, "deviceVersionId"); - return (Criteria) this; - } - - public Criteria andDeviceVersionIdNotEqualTo(Integer value) { - addCriterion("device_version_id <>", value, "deviceVersionId"); - return (Criteria) this; - } - - public Criteria andDeviceVersionIdGreaterThan(Integer value) { - addCriterion("device_version_id >", value, "deviceVersionId"); - return (Criteria) this; - } - - public Criteria andDeviceVersionIdGreaterThanOrEqualTo(Integer value) { - addCriterion("device_version_id >=", value, "deviceVersionId"); - return (Criteria) this; - } - - public Criteria andDeviceVersionIdLessThan(Integer value) { - addCriterion("device_version_id <", value, "deviceVersionId"); - return (Criteria) this; - } - - public Criteria andDeviceVersionIdLessThanOrEqualTo(Integer value) { - addCriterion("device_version_id <=", value, "deviceVersionId"); - return (Criteria) this; - } - - public Criteria andDeviceVersionIdIn(List<Integer> values) { - addCriterion("device_version_id in", values, "deviceVersionId"); - return (Criteria) this; - } - - public Criteria andDeviceVersionIdNotIn(List<Integer> values) { - addCriterion("device_version_id not in", values, "deviceVersionId"); - return (Criteria) this; - } - - public Criteria andDeviceVersionIdBetween(Integer value1, Integer value2) { - addCriterion("device_version_id between", value1, value2, "deviceVersionId"); - return (Criteria) this; - } - - public Criteria andDeviceVersionIdNotBetween(Integer value1, Integer value2) { - addCriterion("device_version_id not between", value1, value2, "deviceVersionId"); - return (Criteria) this; - } - } - - /** - * This class was generated by MyBatis Generator. This class corresponds to the database table device - * @mbggenerated Wed Nov 29 16:17:59 CST 2017 - */ - 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); - } - } - - /** - * This class was generated by MyBatis Generator. This class corresponds to the database table device - * @mbggenerated do_not_delete_during_merge - */ - public static class Criteria extends GeneratedCriteria { - protected Criteria() { - super(); - } - } - -} \ No newline at end of file diff --git a/src/main/java/com/moral/entity/OperateUser.java b/src/main/java/com/moral/entity/OperateUser.java index 10a6ed5..405d8db 100644 --- a/src/main/java/com/moral/entity/OperateUser.java +++ b/src/main/java/com/moral/entity/OperateUser.java @@ -27,5 +27,10 @@ private Date createTime; private Date expireTime; + + public Integer getUid() { + return id; + } + } \ No newline at end of file diff --git a/src/main/java/com/moral/entity/OperateUserExample.java b/src/main/java/com/moral/entity/OperateUserExample.java deleted file mode 100644 index 3e67a6b..0000000 --- a/src/main/java/com/moral/entity/OperateUserExample.java +++ /dev/null @@ -1,931 +0,0 @@ -package com.moral.entity; - -import java.util.ArrayList; -import java.util.Date; -import java.util.List; - -public class OperateUserExample { - protected String orderByClause; - - protected boolean distinct; - - protected List<Criteria> oredCriteria; - - public OperateUserExample() { - 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 andJobNumberIsNull() { - addCriterion("job_number is null"); - return (Criteria) this; - } - - public Criteria andJobNumberIsNotNull() { - addCriterion("job_number is not null"); - return (Criteria) this; - } - - public Criteria andJobNumberEqualTo(String value) { - addCriterion("job_number =", value, "jobNumber"); - return (Criteria) this; - } - - public Criteria andJobNumberNotEqualTo(String value) { - addCriterion("job_number <>", value, "jobNumber"); - return (Criteria) this; - } - - public Criteria andJobNumberGreaterThan(String value) { - addCriterion("job_number >", value, "jobNumber"); - return (Criteria) this; - } - - public Criteria andJobNumberGreaterThanOrEqualTo(String value) { - addCriterion("job_number >=", value, "jobNumber"); - return (Criteria) this; - } - - public Criteria andJobNumberLessThan(String value) { - addCriterion("job_number <", value, "jobNumber"); - return (Criteria) this; - } - - public Criteria andJobNumberLessThanOrEqualTo(String value) { - addCriterion("job_number <=", value, "jobNumber"); - return (Criteria) this; - } - - public Criteria andJobNumberLike(String value) { - addCriterion("job_number like", value, "jobNumber"); - return (Criteria) this; - } - - public Criteria andJobNumberNotLike(String value) { - addCriterion("job_number not like", value, "jobNumber"); - return (Criteria) this; - } - - public Criteria andJobNumberIn(List<String> values) { - addCriterion("job_number in", values, "jobNumber"); - return (Criteria) this; - } - - public Criteria andJobNumberNotIn(List<String> values) { - addCriterion("job_number not in", values, "jobNumber"); - return (Criteria) this; - } - - public Criteria andJobNumberBetween(String value1, String value2) { - addCriterion("job_number between", value1, value2, "jobNumber"); - return (Criteria) this; - } - - public Criteria andJobNumberNotBetween(String value1, String value2) { - addCriterion("job_number not between", value1, value2, "jobNumber"); - 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 andPasswordIsNull() { - addCriterion("password is null"); - return (Criteria) this; - } - - public Criteria andPasswordIsNotNull() { - addCriterion("password is not null"); - return (Criteria) this; - } - - public Criteria andPasswordEqualTo(String value) { - addCriterion("password =", value, "password"); - return (Criteria) this; - } - - public Criteria andPasswordNotEqualTo(String value) { - addCriterion("password <>", value, "password"); - return (Criteria) this; - } - - public Criteria andPasswordGreaterThan(String value) { - addCriterion("password >", value, "password"); - return (Criteria) this; - } - - public Criteria andPasswordGreaterThanOrEqualTo(String value) { - addCriterion("password >=", value, "password"); - return (Criteria) this; - } - - public Criteria andPasswordLessThan(String value) { - addCriterion("password <", value, "password"); - return (Criteria) this; - } - - public Criteria andPasswordLessThanOrEqualTo(String value) { - addCriterion("password <=", value, "password"); - return (Criteria) this; - } - - public Criteria andPasswordLike(String value) { - addCriterion("password like", value, "password"); - return (Criteria) this; - } - - public Criteria andPasswordNotLike(String value) { - addCriterion("password not like", value, "password"); - return (Criteria) this; - } - - public Criteria andPasswordIn(List<String> values) { - addCriterion("password in", values, "password"); - return (Criteria) this; - } - - public Criteria andPasswordNotIn(List<String> values) { - addCriterion("password not in", values, "password"); - return (Criteria) this; - } - - public Criteria andPasswordBetween(String value1, String value2) { - addCriterion("password between", value1, value2, "password"); - return (Criteria) this; - } - - public Criteria andPasswordNotBetween(String value1, String value2) { - addCriterion("password not between", value1, value2, "password"); - return (Criteria) this; - } - - public Criteria andOrganizationIdIsNull() { - addCriterion("organization_id is null"); - return (Criteria) this; - } - - public Criteria andOrganizationIdIsNotNull() { - addCriterion("organization_id is not null"); - return (Criteria) this; - } - - public Criteria andOrganizationIdEqualTo(Integer value) { - addCriterion("organization_id =", value, "organizationId"); - return (Criteria) this; - } - - public Criteria andOrganizationIdNotEqualTo(Integer value) { - addCriterion("organization_id <>", value, "organizationId"); - return (Criteria) this; - } - - public Criteria andOrganizationIdGreaterThan(Integer value) { - addCriterion("organization_id >", value, "organizationId"); - return (Criteria) this; - } - - public Criteria andOrganizationIdGreaterThanOrEqualTo(Integer value) { - addCriterion("organization_id >=", value, "organizationId"); - return (Criteria) this; - } - - public Criteria andOrganizationIdLessThan(Integer value) { - addCriterion("organization_id <", value, "organizationId"); - return (Criteria) this; - } - - public Criteria andOrganizationIdLessThanOrEqualTo(Integer value) { - addCriterion("organization_id <=", value, "organizationId"); - return (Criteria) this; - } - - public Criteria andOrganizationIdIn(List<Integer> values) { - addCriterion("organization_id in", values, "organizationId"); - return (Criteria) this; - } - - public Criteria andOrganizationIdNotIn(List<Integer> values) { - addCriterion("organization_id not in", values, "organizationId"); - return (Criteria) this; - } - - public Criteria andOrganizationIdBetween(Integer value1, Integer value2) { - addCriterion("organization_id between", value1, value2, "organizationId"); - return (Criteria) this; - } - - public Criteria andOrganizationIdNotBetween(Integer value1, Integer value2) { - addCriterion("organization_id not between", value1, value2, "organizationId"); - return (Criteria) this; - } - - public Criteria andMobileIsNull() { - addCriterion("mobile is null"); - return (Criteria) this; - } - - public Criteria andMobileIsNotNull() { - addCriterion("mobile is not null"); - return (Criteria) this; - } - - public Criteria andMobileEqualTo(String value) { - addCriterion("mobile =", value, "mobile"); - return (Criteria) this; - } - - public Criteria andMobileNotEqualTo(String value) { - addCriterion("mobile <>", value, "mobile"); - return (Criteria) this; - } - - public Criteria andMobileGreaterThan(String value) { - addCriterion("mobile >", value, "mobile"); - return (Criteria) this; - } - - public Criteria andMobileGreaterThanOrEqualTo(String value) { - addCriterion("mobile >=", value, "mobile"); - return (Criteria) this; - } - - public Criteria andMobileLessThan(String value) { - addCriterion("mobile <", value, "mobile"); - return (Criteria) this; - } - - public Criteria andMobileLessThanOrEqualTo(String value) { - addCriterion("mobile <=", value, "mobile"); - return (Criteria) this; - } - - public Criteria andMobileLike(String value) { - addCriterion("mobile like", value, "mobile"); - return (Criteria) this; - } - - public Criteria andMobileNotLike(String value) { - addCriterion("mobile not like", value, "mobile"); - return (Criteria) this; - } - - public Criteria andMobileIn(List<String> values) { - addCriterion("mobile in", values, "mobile"); - return (Criteria) this; - } - - public Criteria andMobileNotIn(List<String> values) { - addCriterion("mobile not in", values, "mobile"); - return (Criteria) this; - } - - public Criteria andMobileBetween(String value1, String value2) { - addCriterion("mobile between", value1, value2, "mobile"); - return (Criteria) this; - } - - public Criteria andMobileNotBetween(String value1, String value2) { - addCriterion("mobile not between", value1, value2, "mobile"); - return (Criteria) this; - } - - public Criteria andEmailIsNull() { - addCriterion("email is null"); - return (Criteria) this; - } - - public Criteria andEmailIsNotNull() { - addCriterion("email is not null"); - return (Criteria) this; - } - - public Criteria andEmailEqualTo(String value) { - addCriterion("email =", value, "email"); - return (Criteria) this; - } - - public Criteria andEmailNotEqualTo(String value) { - addCriterion("email <>", value, "email"); - return (Criteria) this; - } - - public Criteria andEmailGreaterThan(String value) { - addCriterion("email >", value, "email"); - return (Criteria) this; - } - - public Criteria andEmailGreaterThanOrEqualTo(String value) { - addCriterion("email >=", value, "email"); - return (Criteria) this; - } - - public Criteria andEmailLessThan(String value) { - addCriterion("email <", value, "email"); - return (Criteria) this; - } - - public Criteria andEmailLessThanOrEqualTo(String value) { - addCriterion("email <=", value, "email"); - return (Criteria) this; - } - - public Criteria andEmailLike(String value) { - addCriterion("email like", value, "email"); - return (Criteria) this; - } - - public Criteria andEmailNotLike(String value) { - addCriterion("email not like", value, "email"); - return (Criteria) this; - } - - public Criteria andEmailIn(List<String> values) { - addCriterion("email in", values, "email"); - return (Criteria) this; - } - - public Criteria andEmailNotIn(List<String> values) { - addCriterion("email not in", values, "email"); - return (Criteria) this; - } - - public Criteria andEmailBetween(String value1, String value2) { - addCriterion("email between", value1, value2, "email"); - return (Criteria) this; - } - - public Criteria andEmailNotBetween(String value1, String value2) { - addCriterion("email not between", value1, value2, "email"); - return (Criteria) this; - } - - public Criteria andWeixinIsNull() { - addCriterion("weixin is null"); - return (Criteria) this; - } - - public Criteria andWeixinIsNotNull() { - addCriterion("weixin is not null"); - return (Criteria) this; - } - - public Criteria andWeixinEqualTo(String value) { - addCriterion("weixin =", value, "weixin"); - return (Criteria) this; - } - - public Criteria andWeixinNotEqualTo(String value) { - addCriterion("weixin <>", value, "weixin"); - return (Criteria) this; - } - - public Criteria andWeixinGreaterThan(String value) { - addCriterion("weixin >", value, "weixin"); - return (Criteria) this; - } - - public Criteria andWeixinGreaterThanOrEqualTo(String value) { - addCriterion("weixin >=", value, "weixin"); - return (Criteria) this; - } - - public Criteria andWeixinLessThan(String value) { - addCriterion("weixin <", value, "weixin"); - return (Criteria) this; - } - - public Criteria andWeixinLessThanOrEqualTo(String value) { - addCriterion("weixin <=", value, "weixin"); - return (Criteria) this; - } - - public Criteria andWeixinLike(String value) { - addCriterion("weixin like", value, "weixin"); - return (Criteria) this; - } - - public Criteria andWeixinNotLike(String value) { - addCriterion("weixin not like", value, "weixin"); - return (Criteria) this; - } - - public Criteria andWeixinIn(List<String> values) { - addCriterion("weixin in", values, "weixin"); - return (Criteria) this; - } - - public Criteria andWeixinNotIn(List<String> values) { - addCriterion("weixin not in", values, "weixin"); - return (Criteria) this; - } - - public Criteria andWeixinBetween(String value1, String value2) { - addCriterion("weixin between", value1, value2, "weixin"); - return (Criteria) this; - } - - public Criteria andWeixinNotBetween(String value1, String value2) { - addCriterion("weixin not between", value1, value2, "weixin"); - return (Criteria) this; - } - - public Criteria andIsDeleteIsNull() { - addCriterion("is_delete is null"); - return (Criteria) this; - } - - public Criteria andIsDeleteIsNotNull() { - addCriterion("is_delete is not null"); - return (Criteria) this; - } - - public Criteria andIsDeleteEqualTo(String value) { - addCriterion("is_delete =", value, "isDelete"); - return (Criteria) this; - } - - public Criteria andIsDeleteNotEqualTo(String value) { - addCriterion("is_delete <>", value, "isDelete"); - return (Criteria) this; - } - - public Criteria andIsDeleteGreaterThan(String value) { - addCriterion("is_delete >", value, "isDelete"); - return (Criteria) this; - } - - public Criteria andIsDeleteGreaterThanOrEqualTo(String value) { - addCriterion("is_delete >=", value, "isDelete"); - return (Criteria) this; - } - - public Criteria andIsDeleteLessThan(String value) { - addCriterion("is_delete <", value, "isDelete"); - return (Criteria) this; - } - - public Criteria andIsDeleteLessThanOrEqualTo(String value) { - addCriterion("is_delete <=", value, "isDelete"); - return (Criteria) this; - } - - public Criteria andIsDeleteLike(String value) { - addCriterion("is_delete like", value, "isDelete"); - return (Criteria) this; - } - - public Criteria andIsDeleteNotLike(String value) { - addCriterion("is_delete not like", value, "isDelete"); - return (Criteria) this; - } - - public Criteria andIsDeleteIn(List<String> values) { - addCriterion("is_delete in", values, "isDelete"); - return (Criteria) this; - } - - public Criteria andIsDeleteNotIn(List<String> values) { - addCriterion("is_delete not in", values, "isDelete"); - return (Criteria) this; - } - - public Criteria andIsDeleteBetween(String value1, String value2) { - addCriterion("is_delete between", value1, value2, "isDelete"); - return (Criteria) this; - } - - public Criteria andIsDeleteNotBetween(String value1, String value2) { - addCriterion("is_delete not between", value1, value2, "isDelete"); - 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 andExpireTimeIsNull() { - addCriterion("expire_time is null"); - return (Criteria) this; - } - - public Criteria andExpireTimeIsNotNull() { - addCriterion("expire_time is not null"); - return (Criteria) this; - } - - public Criteria andExpireTimeEqualTo(Date value) { - addCriterion("expire_time =", value, "expireTime"); - return (Criteria) this; - } - - public Criteria andExpireTimeNotEqualTo(Date value) { - addCriterion("expire_time <>", value, "expireTime"); - return (Criteria) this; - } - - public Criteria andExpireTimeGreaterThan(Date value) { - addCriterion("expire_time >", value, "expireTime"); - return (Criteria) this; - } - - public Criteria andExpireTimeGreaterThanOrEqualTo(Date value) { - addCriterion("expire_time >=", value, "expireTime"); - return (Criteria) this; - } - - public Criteria andExpireTimeLessThan(Date value) { - addCriterion("expire_time <", value, "expireTime"); - return (Criteria) this; - } - - public Criteria andExpireTimeLessThanOrEqualTo(Date value) { - addCriterion("expire_time <=", value, "expireTime"); - return (Criteria) this; - } - - public Criteria andExpireTimeIn(List<Date> values) { - addCriterion("expire_time in", values, "expireTime"); - return (Criteria) this; - } - - public Criteria andExpireTimeNotIn(List<Date> values) { - addCriterion("expire_time not in", values, "expireTime"); - return (Criteria) this; - } - - public Criteria andExpireTimeBetween(Date value1, Date value2) { - addCriterion("expire_time between", value1, value2, "expireTime"); - return (Criteria) this; - } - - public Criteria andExpireTimeNotBetween(Date value1, Date value2) { - addCriterion("expire_time not between", value1, value2, "expireTime"); - 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/entity/OrganizationExample.java b/src/main/java/com/moral/entity/OrganizationExample.java deleted file mode 100644 index d18d01b..0000000 --- a/src/main/java/com/moral/entity/OrganizationExample.java +++ /dev/null @@ -1,1041 +0,0 @@ -package com.moral.entity; - -import java.util.ArrayList; -import java.util.Date; -import java.util.List; - -public class OrganizationExample { - protected String orderByClause; - - protected boolean distinct; - - protected List<Criteria> oredCriteria; - - public OrganizationExample() { - 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 andRankIsNull() { - addCriterion("rank is null"); - return (Criteria) this; - } - - public Criteria andRankIsNotNull() { - addCriterion("rank is not null"); - return (Criteria) this; - } - - public Criteria andRankEqualTo(Integer value) { - addCriterion("rank =", value, "rank"); - return (Criteria) this; - } - - public Criteria andRankNotEqualTo(Integer value) { - addCriterion("rank <>", value, "rank"); - return (Criteria) this; - } - - public Criteria andRankGreaterThan(Integer value) { - addCriterion("rank >", value, "rank"); - return (Criteria) this; - } - - public Criteria andRankGreaterThanOrEqualTo(Integer value) { - addCriterion("rank >=", value, "rank"); - return (Criteria) this; - } - - public Criteria andRankLessThan(Integer value) { - addCriterion("rank <", value, "rank"); - return (Criteria) this; - } - - public Criteria andRankLessThanOrEqualTo(Integer value) { - addCriterion("rank <=", value, "rank"); - return (Criteria) this; - } - - public Criteria andRankIn(List<Integer> values) { - addCriterion("rank in", values, "rank"); - return (Criteria) this; - } - - public Criteria andRankNotIn(List<Integer> values) { - addCriterion("rank not in", values, "rank"); - return (Criteria) this; - } - - public Criteria andRankBetween(Integer value1, Integer value2) { - addCriterion("rank between", value1, value2, "rank"); - return (Criteria) this; - } - - public Criteria andRankNotBetween(Integer value1, Integer value2) { - addCriterion("rank not between", value1, value2, "rank"); - return (Criteria) this; - } - - public Criteria andProvinceCodeIsNull() { - addCriterion("province_code is null"); - return (Criteria) this; - } - - public Criteria andProvinceCodeIsNotNull() { - addCriterion("province_code is not null"); - return (Criteria) this; - } - - public Criteria andProvinceCodeEqualTo(Integer value) { - addCriterion("province_code =", value, "provinceCode"); - return (Criteria) this; - } - - public Criteria andProvinceCodeNotEqualTo(Integer value) { - addCriterion("province_code <>", value, "provinceCode"); - return (Criteria) this; - } - - public Criteria andProvinceCodeGreaterThan(Integer value) { - addCriterion("province_code >", value, "provinceCode"); - return (Criteria) this; - } - - public Criteria andProvinceCodeGreaterThanOrEqualTo(Integer value) { - addCriterion("province_code >=", value, "provinceCode"); - return (Criteria) this; - } - - public Criteria andProvinceCodeLessThan(Integer value) { - addCriterion("province_code <", value, "provinceCode"); - return (Criteria) this; - } - - public Criteria andProvinceCodeLessThanOrEqualTo(Integer value) { - addCriterion("province_code <=", value, "provinceCode"); - return (Criteria) this; - } - - public Criteria andProvinceCodeIn(List<Integer> values) { - addCriterion("province_code in", values, "provinceCode"); - return (Criteria) this; - } - - public Criteria andProvinceCodeNotIn(List<Integer> values) { - addCriterion("province_code not in", values, "provinceCode"); - return (Criteria) this; - } - - public Criteria andProvinceCodeBetween(Integer value1, Integer value2) { - addCriterion("province_code between", value1, value2, "provinceCode"); - return (Criteria) this; - } - - public Criteria andProvinceCodeNotBetween(Integer value1, Integer value2) { - addCriterion("province_code not between", value1, value2, "provinceCode"); - return (Criteria) this; - } - - public Criteria andCityCodeIsNull() { - addCriterion("city_code is null"); - return (Criteria) this; - } - - public Criteria andCityCodeIsNotNull() { - addCriterion("city_code is not null"); - return (Criteria) this; - } - - public Criteria andCityCodeEqualTo(Integer value) { - addCriterion("city_code =", value, "cityCode"); - return (Criteria) this; - } - - public Criteria andCityCodeNotEqualTo(Integer value) { - addCriterion("city_code <>", value, "cityCode"); - return (Criteria) this; - } - - public Criteria andCityCodeGreaterThan(Integer value) { - addCriterion("city_code >", value, "cityCode"); - return (Criteria) this; - } - - public Criteria andCityCodeGreaterThanOrEqualTo(Integer value) { - addCriterion("city_code >=", value, "cityCode"); - return (Criteria) this; - } - - public Criteria andCityCodeLessThan(Integer value) { - addCriterion("city_code <", value, "cityCode"); - return (Criteria) this; - } - - public Criteria andCityCodeLessThanOrEqualTo(Integer value) { - addCriterion("city_code <=", value, "cityCode"); - return (Criteria) this; - } - - public Criteria andCityCodeIn(List<Integer> values) { - addCriterion("city_code in", values, "cityCode"); - return (Criteria) this; - } - - public Criteria andCityCodeNotIn(List<Integer> values) { - addCriterion("city_code not in", values, "cityCode"); - return (Criteria) this; - } - - public Criteria andCityCodeBetween(Integer value1, Integer value2) { - addCriterion("city_code between", value1, value2, "cityCode"); - return (Criteria) this; - } - - public Criteria andCityCodeNotBetween(Integer value1, Integer value2) { - addCriterion("city_code not between", value1, value2, "cityCode"); - return (Criteria) this; - } - - public Criteria andAreaCodeIsNull() { - addCriterion("area_code is null"); - return (Criteria) this; - } - - public Criteria andAreaCodeIsNotNull() { - addCriterion("area_code is not null"); - return (Criteria) this; - } - - public Criteria andAreaCodeEqualTo(Integer value) { - addCriterion("area_code =", value, "areaCode"); - return (Criteria) this; - } - - public Criteria andAreaCodeNotEqualTo(Integer value) { - addCriterion("area_code <>", value, "areaCode"); - return (Criteria) this; - } - - public Criteria andAreaCodeGreaterThan(Integer value) { - addCriterion("area_code >", value, "areaCode"); - return (Criteria) this; - } - - public Criteria andAreaCodeGreaterThanOrEqualTo(Integer value) { - addCriterion("area_code >=", value, "areaCode"); - return (Criteria) this; - } - - public Criteria andAreaCodeLessThan(Integer value) { - addCriterion("area_code <", value, "areaCode"); - return (Criteria) this; - } - - public Criteria andAreaCodeLessThanOrEqualTo(Integer value) { - addCriterion("area_code <=", value, "areaCode"); - return (Criteria) this; - } - - public Criteria andAreaCodeIn(List<Integer> values) { - addCriterion("area_code in", values, "areaCode"); - return (Criteria) this; - } - - public Criteria andAreaCodeNotIn(List<Integer> values) { - addCriterion("area_code not in", values, "areaCode"); - return (Criteria) this; - } - - public Criteria andAreaCodeBetween(Integer value1, Integer value2) { - addCriterion("area_code between", value1, value2, "areaCode"); - return (Criteria) this; - } - - public Criteria andAreaCodeNotBetween(Integer value1, Integer value2) { - addCriterion("area_code 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 andTelephoneIsNull() { - addCriterion("telephone is null"); - return (Criteria) this; - } - - public Criteria andTelephoneIsNotNull() { - addCriterion("telephone is not null"); - return (Criteria) this; - } - - public Criteria andTelephoneEqualTo(String value) { - addCriterion("telephone =", value, "telephone"); - return (Criteria) this; - } - - public Criteria andTelephoneNotEqualTo(String value) { - addCriterion("telephone <>", value, "telephone"); - return (Criteria) this; - } - - public Criteria andTelephoneGreaterThan(String value) { - addCriterion("telephone >", value, "telephone"); - return (Criteria) this; - } - - public Criteria andTelephoneGreaterThanOrEqualTo(String value) { - addCriterion("telephone >=", value, "telephone"); - return (Criteria) this; - } - - public Criteria andTelephoneLessThan(String value) { - addCriterion("telephone <", value, "telephone"); - return (Criteria) this; - } - - public Criteria andTelephoneLessThanOrEqualTo(String value) { - addCriterion("telephone <=", value, "telephone"); - return (Criteria) this; - } - - public Criteria andTelephoneLike(String value) { - addCriterion("telephone like", value, "telephone"); - return (Criteria) this; - } - - public Criteria andTelephoneNotLike(String value) { - addCriterion("telephone not like", value, "telephone"); - return (Criteria) this; - } - - public Criteria andTelephoneIn(List<String> values) { - addCriterion("telephone in", values, "telephone"); - return (Criteria) this; - } - - public Criteria andTelephoneNotIn(List<String> values) { - addCriterion("telephone not in", values, "telephone"); - return (Criteria) this; - } - - public Criteria andTelephoneBetween(String value1, String value2) { - addCriterion("telephone between", value1, value2, "telephone"); - return (Criteria) this; - } - - public Criteria andTelephoneNotBetween(String value1, String value2) { - addCriterion("telephone not between", value1, value2, "telephone"); - return (Criteria) this; - } - - public Criteria andEmailIsNull() { - addCriterion("email is null"); - return (Criteria) this; - } - - public Criteria andEmailIsNotNull() { - addCriterion("email is not null"); - return (Criteria) this; - } - - public Criteria andEmailEqualTo(String value) { - addCriterion("email =", value, "email"); - return (Criteria) this; - } - - public Criteria andEmailNotEqualTo(String value) { - addCriterion("email <>", value, "email"); - return (Criteria) this; - } - - public Criteria andEmailGreaterThan(String value) { - addCriterion("email >", value, "email"); - return (Criteria) this; - } - - public Criteria andEmailGreaterThanOrEqualTo(String value) { - addCriterion("email >=", value, "email"); - return (Criteria) this; - } - - public Criteria andEmailLessThan(String value) { - addCriterion("email <", value, "email"); - return (Criteria) this; - } - - public Criteria andEmailLessThanOrEqualTo(String value) { - addCriterion("email <=", value, "email"); - return (Criteria) this; - } - - public Criteria andEmailLike(String value) { - addCriterion("email like", value, "email"); - return (Criteria) this; - } - - public Criteria andEmailNotLike(String value) { - addCriterion("email not like", value, "email"); - return (Criteria) this; - } - - public Criteria andEmailIn(List<String> values) { - addCriterion("email in", values, "email"); - return (Criteria) this; - } - - public Criteria andEmailNotIn(List<String> values) { - addCriterion("email not in", values, "email"); - return (Criteria) this; - } - - public Criteria andEmailBetween(String value1, String value2) { - addCriterion("email between", value1, value2, "email"); - return (Criteria) this; - } - - public Criteria andEmailNotBetween(String value1, String value2) { - addCriterion("email not between", value1, value2, "email"); - return (Criteria) this; - } - - public Criteria andIsDeleteIsNull() { - addCriterion("is_delete is null"); - return (Criteria) this; - } - - public Criteria andIsDeleteIsNotNull() { - addCriterion("is_delete is not null"); - return (Criteria) this; - } - - public Criteria andIsDeleteEqualTo(String value) { - addCriterion("is_delete =", value, "isDelete"); - return (Criteria) this; - } - - public Criteria andIsDeleteNotEqualTo(String value) { - addCriterion("is_delete <>", value, "isDelete"); - return (Criteria) this; - } - - public Criteria andIsDeleteGreaterThan(String value) { - addCriterion("is_delete >", value, "isDelete"); - return (Criteria) this; - } - - public Criteria andIsDeleteGreaterThanOrEqualTo(String value) { - addCriterion("is_delete >=", value, "isDelete"); - return (Criteria) this; - } - - public Criteria andIsDeleteLessThan(String value) { - addCriterion("is_delete <", value, "isDelete"); - return (Criteria) this; - } - - public Criteria andIsDeleteLessThanOrEqualTo(String value) { - addCriterion("is_delete <=", value, "isDelete"); - return (Criteria) this; - } - - public Criteria andIsDeleteLike(String value) { - addCriterion("is_delete like", value, "isDelete"); - return (Criteria) this; - } - - public Criteria andIsDeleteNotLike(String value) { - addCriterion("is_delete not like", value, "isDelete"); - return (Criteria) this; - } - - public Criteria andIsDeleteIn(List<String> values) { - addCriterion("is_delete in", values, "isDelete"); - return (Criteria) this; - } - - public Criteria andIsDeleteNotIn(List<String> values) { - addCriterion("is_delete not in", values, "isDelete"); - return (Criteria) this; - } - - public Criteria andIsDeleteBetween(String value1, String value2) { - addCriterion("is_delete between", value1, value2, "isDelete"); - return (Criteria) this; - } - - public Criteria andIsDeleteNotBetween(String value1, String value2) { - addCriterion("is_delete not between", value1, value2, "isDelete"); - 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 andExpireTimeIsNull() { - addCriterion("expire_time is null"); - return (Criteria) this; - } - - public Criteria andExpireTimeIsNotNull() { - addCriterion("expire_time is not null"); - return (Criteria) this; - } - - public Criteria andExpireTimeEqualTo(Date value) { - addCriterion("expire_time =", value, "expireTime"); - return (Criteria) this; - } - - public Criteria andExpireTimeNotEqualTo(Date value) { - addCriterion("expire_time <>", value, "expireTime"); - return (Criteria) this; - } - - public Criteria andExpireTimeGreaterThan(Date value) { - addCriterion("expire_time >", value, "expireTime"); - return (Criteria) this; - } - - public Criteria andExpireTimeGreaterThanOrEqualTo(Date value) { - addCriterion("expire_time >=", value, "expireTime"); - return (Criteria) this; - } - - public Criteria andExpireTimeLessThan(Date value) { - addCriterion("expire_time <", value, "expireTime"); - return (Criteria) this; - } - - public Criteria andExpireTimeLessThanOrEqualTo(Date value) { - addCriterion("expire_time <=", value, "expireTime"); - return (Criteria) this; - } - - public Criteria andExpireTimeIn(List<Date> values) { - addCriterion("expire_time in", values, "expireTime"); - return (Criteria) this; - } - - public Criteria andExpireTimeNotIn(List<Date> values) { - addCriterion("expire_time not in", values, "expireTime"); - return (Criteria) this; - } - - public Criteria andExpireTimeBetween(Date value1, Date value2) { - addCriterion("expire_time between", value1, value2, "expireTime"); - return (Criteria) this; - } - - public Criteria andExpireTimeNotBetween(Date value1, Date value2) { - addCriterion("expire_time not between", value1, value2, "expireTime"); - return (Criteria) this; - } - - public Criteria andDescriptionIsNull() { - addCriterion("description is null"); - return (Criteria) this; - } - - public Criteria andDescriptionIsNotNull() { - addCriterion("description is not null"); - return (Criteria) this; - } - - public Criteria andDescriptionEqualTo(String value) { - addCriterion("description =", value, "description"); - return (Criteria) this; - } - - public Criteria andDescriptionNotEqualTo(String value) { - addCriterion("description <>", value, "description"); - return (Criteria) this; - } - - public Criteria andDescriptionGreaterThan(String value) { - addCriterion("description >", value, "description"); - return (Criteria) this; - } - - public Criteria andDescriptionGreaterThanOrEqualTo(String value) { - addCriterion("description >=", value, "description"); - return (Criteria) this; - } - - public Criteria andDescriptionLessThan(String value) { - addCriterion("description <", value, "description"); - return (Criteria) this; - } - - public Criteria andDescriptionLessThanOrEqualTo(String value) { - addCriterion("description <=", value, "description"); - return (Criteria) this; - } - - public Criteria andDescriptionLike(String value) { - addCriterion("description like", value, "description"); - return (Criteria) this; - } - - public Criteria andDescriptionNotLike(String value) { - addCriterion("description not like", value, "description"); - return (Criteria) this; - } - - public Criteria andDescriptionIn(List<String> values) { - addCriterion("description in", values, "description"); - return (Criteria) this; - } - - public Criteria andDescriptionNotIn(List<String> values) { - addCriterion("description not in", values, "description"); - return (Criteria) this; - } - - public Criteria andDescriptionBetween(String value1, String value2) { - addCriterion("description between", value1, value2, "description"); - return (Criteria) this; - } - - public Criteria andDescriptionNotBetween(String value1, String value2) { - addCriterion("description not between", value1, value2, "description"); - 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/entity/OrganizationRelationExample.java b/src/main/java/com/moral/entity/OrganizationRelationExample.java deleted file mode 100644 index 6367c29..0000000 --- a/src/main/java/com/moral/entity/OrganizationRelationExample.java +++ /dev/null @@ -1,380 +0,0 @@ -package com.moral.entity; - -import java.util.ArrayList; -import java.util.List; - -public class OrganizationRelationExample { - protected String orderByClause; - - protected boolean distinct; - - protected List<Criteria> oredCriteria; - - public OrganizationRelationExample() { - 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 andParentIdIsNull() { - addCriterion("parent_id is null"); - return (Criteria) this; - } - - public Criteria andParentIdIsNotNull() { - addCriterion("parent_id is not null"); - return (Criteria) this; - } - - public Criteria andParentIdEqualTo(Integer value) { - addCriterion("parent_id =", value, "parentId"); - return (Criteria) this; - } - - public Criteria andParentIdNotEqualTo(Integer value) { - addCriterion("parent_id <>", value, "parentId"); - return (Criteria) this; - } - - public Criteria andParentIdGreaterThan(Integer value) { - addCriterion("parent_id >", value, "parentId"); - return (Criteria) this; - } - - public Criteria andParentIdGreaterThanOrEqualTo(Integer value) { - addCriterion("parent_id >=", value, "parentId"); - return (Criteria) this; - } - - public Criteria andParentIdLessThan(Integer value) { - addCriterion("parent_id <", value, "parentId"); - return (Criteria) this; - } - - public Criteria andParentIdLessThanOrEqualTo(Integer value) { - addCriterion("parent_id <=", value, "parentId"); - return (Criteria) this; - } - - public Criteria andParentIdIn(List<Integer> values) { - addCriterion("parent_id in", values, "parentId"); - return (Criteria) this; - } - - public Criteria andParentIdNotIn(List<Integer> values) { - addCriterion("parent_id not in", values, "parentId"); - return (Criteria) this; - } - - public Criteria andParentIdBetween(Integer value1, Integer value2) { - addCriterion("parent_id between", value1, value2, "parentId"); - return (Criteria) this; - } - - public Criteria andParentIdNotBetween(Integer value1, Integer value2) { - addCriterion("parent_id not between", value1, value2, "parentId"); - return (Criteria) this; - } - - public Criteria andChildIdIsNull() { - addCriterion("child_id is null"); - return (Criteria) this; - } - - public Criteria andChildIdIsNotNull() { - addCriterion("child_id is not null"); - return (Criteria) this; - } - - public Criteria andChildIdEqualTo(Integer value) { - addCriterion("child_id =", value, "childId"); - return (Criteria) this; - } - - public Criteria andChildIdNotEqualTo(Integer value) { - addCriterion("child_id <>", value, "childId"); - return (Criteria) this; - } - - public Criteria andChildIdGreaterThan(Integer value) { - addCriterion("child_id >", value, "childId"); - return (Criteria) this; - } - - public Criteria andChildIdGreaterThanOrEqualTo(Integer value) { - addCriterion("child_id >=", value, "childId"); - return (Criteria) this; - } - - public Criteria andChildIdLessThan(Integer value) { - addCriterion("child_id <", value, "childId"); - return (Criteria) this; - } - - public Criteria andChildIdLessThanOrEqualTo(Integer value) { - addCriterion("child_id <=", value, "childId"); - return (Criteria) this; - } - - public Criteria andChildIdIn(List<Integer> values) { - addCriterion("child_id in", values, "childId"); - return (Criteria) this; - } - - public Criteria andChildIdNotIn(List<Integer> values) { - addCriterion("child_id not in", values, "childId"); - return (Criteria) this; - } - - public Criteria andChildIdBetween(Integer value1, Integer value2) { - addCriterion("child_id between", value1, value2, "childId"); - return (Criteria) this; - } - - public Criteria andChildIdNotBetween(Integer value1, Integer value2) { - addCriterion("child_id not between", value1, value2, "childId"); - 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/mapper/AccountMapper.java b/src/main/java/com/moral/mapper/AccountMapper.java index 6d2c135..22aaf08 100644 --- a/src/main/java/com/moral/mapper/AccountMapper.java +++ b/src/main/java/com/moral/mapper/AccountMapper.java @@ -3,14 +3,10 @@ import java.util.List; import java.util.Map; -import org.apache.ibatis.annotations.Mapper; - import com.moral.common.mapper.BaseMapper; import com.moral.entity.Account; -import com.moral.entity.AccountExample; -@Mapper -public interface AccountMapper extends BaseMapper<Account, AccountExample, Integer> { +public interface AccountMapper extends BaseMapper<Account> { List<Map<String, Object>> getRoleNameByAccountId(Integer accountId); } \ No newline at end of file diff --git a/src/main/java/com/moral/mapper/DeviceMapper.java b/src/main/java/com/moral/mapper/DeviceMapper.java index ee2a7f9..f4ce1f4 100644 --- a/src/main/java/com/moral/mapper/DeviceMapper.java +++ b/src/main/java/com/moral/mapper/DeviceMapper.java @@ -3,15 +3,12 @@ import java.util.List; import java.util.Map; -import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; import com.moral.common.mapper.BaseMapper; import com.moral.entity.Device; -import com.moral.entity.DeviceExample; -@Mapper -public interface DeviceMapper extends BaseMapper<Device, DeviceExample, Integer>{ +public interface DeviceMapper extends BaseMapper<Device>{ List<Map<String, Object>> getDeviceStatesByAccount(Map<String, Object> parameters); diff --git a/src/main/java/com/moral/mapper/HistoryMapper.java b/src/main/java/com/moral/mapper/HistoryMapper.java index 8fecdda..2247950 100644 --- a/src/main/java/com/moral/mapper/HistoryMapper.java +++ b/src/main/java/com/moral/mapper/HistoryMapper.java @@ -3,9 +3,6 @@ import java.util.List; import java.util.Map; -import org.apache.ibatis.annotations.Mapper; - -@Mapper public interface HistoryMapper{ Map<String, Double> getDayAQIByDevice(Map<String, Object> parameters); diff --git a/src/main/java/com/moral/mapper/OperateUserMapper.java b/src/main/java/com/moral/mapper/OperateUserMapper.java index b8b4008..5c1bdbc 100644 --- a/src/main/java/com/moral/mapper/OperateUserMapper.java +++ b/src/main/java/com/moral/mapper/OperateUserMapper.java @@ -1,11 +1,7 @@ package com.moral.mapper; -import org.apache.ibatis.annotations.Mapper; - import com.moral.common.mapper.BaseMapper; import com.moral.entity.OperateUser; -import com.moral.entity.OperateUserExample; -@Mapper -public interface OperateUserMapper extends BaseMapper<OperateUser, OperateUserExample, Integer> { +public interface OperateUserMapper extends BaseMapper<OperateUser> { } \ No newline at end of file diff --git a/src/main/java/com/moral/mapper/OrganizationMapper.java b/src/main/java/com/moral/mapper/OrganizationMapper.java index 1f93400..f0ce07d 100644 --- a/src/main/java/com/moral/mapper/OrganizationMapper.java +++ b/src/main/java/com/moral/mapper/OrganizationMapper.java @@ -1,11 +1,7 @@ package com.moral.mapper; -import org.apache.ibatis.annotations.Mapper; - import com.moral.common.mapper.BaseMapper; import com.moral.entity.Organization; -import com.moral.entity.OrganizationExample; -@Mapper -public interface OrganizationMapper extends BaseMapper<Organization, OrganizationExample, Integer> { +public interface OrganizationMapper extends BaseMapper<Organization> { } \ No newline at end of file diff --git a/src/main/java/com/moral/mapper/OrganizationRelationMapper.java b/src/main/java/com/moral/mapper/OrganizationRelationMapper.java index 4fa020c..d72c0aa 100644 --- a/src/main/java/com/moral/mapper/OrganizationRelationMapper.java +++ b/src/main/java/com/moral/mapper/OrganizationRelationMapper.java @@ -1,11 +1,7 @@ package com.moral.mapper; -import org.apache.ibatis.annotations.Mapper; - import com.moral.common.mapper.BaseMapper; import com.moral.entity.OrganizationRelation; -import com.moral.entity.OrganizationRelationExample; -@Mapper -public interface OrganizationRelationMapper extends BaseMapper<OrganizationRelation, OrganizationRelationExample, Integer> { +public interface OrganizationRelationMapper extends BaseMapper<OrganizationRelation> { } \ No newline at end of file diff --git a/src/main/java/com/moral/mapper/UserMapper.java b/src/main/java/com/moral/mapper/UserMapper.java index 4e611a6..d8af37d 100644 --- a/src/main/java/com/moral/mapper/UserMapper.java +++ b/src/main/java/com/moral/mapper/UserMapper.java @@ -1,7 +1,7 @@ package com.moral.mapper; import com.moral.entity.auth.AuthUser; -import org.apache.ibatis.annotations.Mapper; +//import org.apache.ibatis.annotations.Mapper; import org.springframework.stereotype.Repository; //@Mapper diff --git a/src/main/java/com/moral/service/DeviceService.java b/src/main/java/com/moral/service/DeviceService.java index 4e0da7e..b0f9d49 100644 --- a/src/main/java/com/moral/service/DeviceService.java +++ b/src/main/java/com/moral/service/DeviceService.java @@ -3,9 +3,15 @@ import java.util.List; import java.util.Map; +import com.moral.entity.Device; + public interface DeviceService { Map<String, Object> getDeviceStatesByAccount(Map<String, Object> parameters); List<Map<String, Object>> getSensorsByDevice(String mac); + + void saveOrUpdateDevice(Device device); + + List<Device> getInstallDevicesByOperateUser(Integer uid, Integer pageIndex, Integer pageSize); } diff --git a/src/main/java/com/moral/service/OperateUserService.java b/src/main/java/com/moral/service/OperateUserService.java index 42b4845..8c24053 100644 --- a/src/main/java/com/moral/service/OperateUserService.java +++ b/src/main/java/com/moral/service/OperateUserService.java @@ -7,5 +7,9 @@ public interface OperateUserService { List<OperateUser> getUserList(String mobile); + + OperateUser mobileLogin(String mobile, String password); + + OperateUser updatePassword(Integer uid, String password, String newPassword); } diff --git a/src/main/java/com/moral/service/impl/AccountServiceImpl.java b/src/main/java/com/moral/service/impl/AccountServiceImpl.java index 7d414c8..4993b3c 100644 --- a/src/main/java/com/moral/service/impl/AccountServiceImpl.java +++ b/src/main/java/com/moral/service/impl/AccountServiceImpl.java @@ -18,10 +18,11 @@ import com.moral.common.exception.BusinessException; import com.moral.entity.Account; -import com.moral.entity.AccountExample; import com.moral.mapper.AccountMapper; import com.moral.service.AccountService; import com.moral.service.OrganizationService; + +import tk.mybatis.mapper.entity.Example; @Service public class AccountServiceImpl implements AccountService { @@ -35,9 +36,9 @@ @Override public Map<String, Object> screenLogin(Map<String, Object> parameters) { Map<String, Object> result = new HashMap<String, Object>(); - AccountExample example = new AccountExample(); + Example example = new Example(Account.class); String password = md5((String) parameters.get("account")); - example.or().andAccountNameEqualTo((String) parameters.get("account")).andPasswordEqualTo(password); + example.or().andEqualTo("accountName",parameters.get("account")).andEqualTo("password",password); List<Account> accounts = accountMapper.selectByExample(example); if (isEmpty(accounts) || accounts.size() != 1) { result.put("msg", "���������������������������������"); @@ -56,15 +57,15 @@ @Override public List<Account> getAccountLists(String accountName, String password) { - AccountExample example = new AccountExample(); - example.or().andAccountNameEqualTo(accountName).andPasswordEqualTo(password); + Example example = new Example(Account.class); + example.or().andEqualTo("accountName",accountName).andEqualTo("password",password); return accountMapper.selectByExample(example); } @Override public List<Account> getAccountList(String accountName) { - AccountExample example = new AccountExample(); - example.or().andAccountNameEqualTo(accountName); + Example example = new Example(Account.class); + example.or().andEqualTo("accountName",accountName); return accountMapper.selectByExample(example); } diff --git a/src/main/java/com/moral/service/impl/DeviceServiceImpl.java b/src/main/java/com/moral/service/impl/DeviceServiceImpl.java index 828e58d..b21b0af 100644 --- a/src/main/java/com/moral/service/impl/DeviceServiceImpl.java +++ b/src/main/java/com/moral/service/impl/DeviceServiceImpl.java @@ -1,5 +1,6 @@ package com.moral.service.impl; +import java.util.Date; import java.util.HashMap; import java.util.List; import java.util.Map; @@ -7,10 +8,17 @@ import javax.annotation.Resource; import org.springframework.stereotype.Service; +import org.springframework.util.ObjectUtils; +import com.github.pagehelper.PageHelper; +import com.moral.common.exception.BusinessException; +import com.moral.common.util.ValidateUtil; +import com.moral.entity.Device; import com.moral.mapper.DeviceMapper; import com.moral.service.AccountService; import com.moral.service.DeviceService; + +import tk.mybatis.mapper.entity.Example; @Service public class DeviceServiceImpl implements DeviceService { @@ -53,4 +61,34 @@ return deviceMapper.getSensorsByDevice(mac); } + @Override + public void saveOrUpdateDevice(Device device) { + ValidateUtil.notNull(device, "������������������"); + ValidateUtil.notEmpty(device.getMac(), "������������������"); + Example example = new Example(Device.class); + example.or().andEqualTo("mac",device.getMac()); + List<Device> devices = deviceMapper.selectByExample(example); + Date operateDate = new Date(); + device.setInstallTime(operateDate); + if (ObjectUtils.isEmpty(devices)) { + device.setCreateTime(operateDate); + device.setState("4"); + deviceMapper.insertSelective(device); + }else if (devices.size() > 1) { + throw new BusinessException("���������������������������������������"); + }else { + device.setId(devices.get(0).getId()); + deviceMapper.updateByPrimaryKeySelective(device); + } + } + + @Override + public List<Device> getInstallDevicesByOperateUser(Integer uid, Integer pageIndex, Integer pageSize) { + Example example = new Example(Device.class); + example.or().andEqualTo("operateUserId",uid); + PageHelper.startPage(pageIndex, pageSize); + List<Device> devices = deviceMapper.selectByExample(example); + return devices; + } + } diff --git a/src/main/java/com/moral/service/impl/HistoryServiceImpl.java b/src/main/java/com/moral/service/impl/HistoryServiceImpl.java index 394a69c..e20f449 100644 --- a/src/main/java/com/moral/service/impl/HistoryServiceImpl.java +++ b/src/main/java/com/moral/service/impl/HistoryServiceImpl.java @@ -22,7 +22,6 @@ import javax.annotation.Resource; -import org.springframework.beans.factory.annotation.Autowired; import org.springframework.data.mongodb.core.MongoTemplate; import org.springframework.data.mongodb.core.aggregation.Aggregation; import org.springframework.data.mongodb.core.aggregation.AggregationResults; diff --git a/src/main/java/com/moral/service/impl/OperateUserServiceImpl.java b/src/main/java/com/moral/service/impl/OperateUserServiceImpl.java index b8a83d9..f574667 100644 --- a/src/main/java/com/moral/service/impl/OperateUserServiceImpl.java +++ b/src/main/java/com/moral/service/impl/OperateUserServiceImpl.java @@ -5,11 +5,15 @@ import javax.annotation.Resource; import org.springframework.stereotype.Service; +import org.springframework.util.ObjectUtils; +import com.moral.common.exception.BusinessException; +import com.moral.common.util.Crypto; import com.moral.entity.OperateUser; -import com.moral.entity.OperateUserExample; import com.moral.mapper.OperateUserMapper; import com.moral.service.OperateUserService; + +import tk.mybatis.mapper.entity.Example; @Service public class OperateUserServiceImpl implements OperateUserService { @@ -19,9 +23,36 @@ @Override public List<OperateUser> getUserList(String mobile) { - OperateUserExample example = new OperateUserExample(); - example.or().andMobileEqualTo(mobile); + Example example = new Example(OperateUser.class); + example.or().andEqualTo("mobile", mobile); return operateUserMapper.selectByExample(example); } + @Override + public OperateUser mobileLogin(String mobile, String password) { + Example example = new Example(OperateUser.class); + example.or().andEqualTo("mobile", mobile).andEqualTo("password", Crypto.md5(password)); + List<OperateUser> operateUsers = operateUserMapper.selectByExample(example); + if (ObjectUtils.isEmpty(operateUsers) || operateUsers.size() > 1) { + throw new BusinessException("������������������������,���������������"); + }else { + OperateUser operateUser = operateUsers.get(0); + operateUser.setPassword(password); + return operateUser; + } + } + + @Override + public OperateUser updatePassword(Integer uid, String password, String newPassword) { + OperateUser operateUser = operateUserMapper.selectByPrimaryKey(uid); + if (ObjectUtils.isEmpty(operateUser) || !Crypto.md5(password).equals(operateUser.getPassword())) { + throw new BusinessException("���������������,���������������������"); + }else { + operateUser.setPassword(Crypto.md5(newPassword)); + operateUserMapper.updateByPrimaryKeySelective(operateUser); + operateUser.setPassword(newPassword); + return operateUser; + } + } + } diff --git a/src/main/java/com/moral/service/impl/OrganizationServiceImpl.java b/src/main/java/com/moral/service/impl/OrganizationServiceImpl.java index c572a32..a262729 100644 --- a/src/main/java/com/moral/service/impl/OrganizationServiceImpl.java +++ b/src/main/java/com/moral/service/impl/OrganizationServiceImpl.java @@ -12,10 +12,11 @@ import com.moral.entity.Organization; import com.moral.entity.OrganizationRelation; -import com.moral.entity.OrganizationRelationExample; import com.moral.mapper.OrganizationMapper; import com.moral.mapper.OrganizationRelationMapper; import com.moral.service.OrganizationService; + +import tk.mybatis.mapper.entity.Example; @Service public class OrganizationServiceImpl implements OrganizationService { @@ -30,8 +31,8 @@ public Set<Integer> getChildOrganizationIds(Integer orgId){ Set<Integer> orgIds = new HashSet<Integer>(); orgIds.add(orgId); - OrganizationRelationExample example = new OrganizationRelationExample(); - example.or().andParentIdEqualTo(orgId); + Example example = new Example(OrganizationRelation.class); + example.or().andEqualTo("parentId",orgId); Organization organization = organizationMapper.selectByPrimaryKey(orgId); if (IS_DELETE_FALSE.equals(organization.getIsDelete())) { List<OrganizationRelation> organizationRelations = organizationRelationMapper.selectByExample(example); diff --git a/src/main/resources/application.yml b/src/main/resources/application.yml index 6eaebf7..aa91078 100644 --- a/src/main/resources/application.yml +++ b/src/main/resources/application.yml @@ -59,8 +59,8 @@ data: mongodb: - uri: mongodb://47.96.26.152:27017/monitor + uri: mongodb://47.96.171.62:27017/monitor -mybatis: - mapper-locations: classpath*:/mapper/*Mapper.xml - type-aliases-package: com.moral.entity \ No newline at end of file +#mybatis: +# mapper-locations: classpath*:/mapper/*Mapper.xml +# type-aliases-package: com.moral.entity \ No newline at end of file diff --git a/src/main/resources/mapper/AccountMapper.xml b/src/main/resources/mapper/AccountMapper.xml index 6279878..8545989 100644 --- a/src/main/resources/mapper/AccountMapper.xml +++ b/src/main/resources/mapper/AccountMapper.xml @@ -13,281 +13,6 @@ <result column="create_time" jdbcType="TIMESTAMP" property="createTime" /> <result column="expire_time" jdbcType="TIMESTAMP" property="expireTime" /> </resultMap> - <sql id="Example_Where_Clause"> - <where> - <foreach collection="oredCriteria" item="criteria" separator="or"> - <if test="criteria.valid"> - <trim prefix="(" prefixOverrides="and" suffix=")"> - <foreach collection="criteria.criteria" item="criterion"> - <choose> - <when test="criterion.noValue"> - and ${criterion.condition} - </when> - <when test="criterion.singleValue"> - and ${criterion.condition} #{criterion.value} - </when> - <when test="criterion.betweenValue"> - and ${criterion.condition} #{criterion.value} and #{criterion.secondValue} - </when> - <when test="criterion.listValue"> - and ${criterion.condition} - <foreach close=")" collection="criterion.value" item="listItem" open="(" separator=","> - #{listItem} - </foreach> - </when> - </choose> - </foreach> - </trim> - </if> - </foreach> - </where> - </sql> - <sql id="Update_By_Example_Where_Clause"> - <where> - <foreach collection="example.oredCriteria" item="criteria" separator="or"> - <if test="criteria.valid"> - <trim prefix="(" prefixOverrides="and" suffix=")"> - <foreach collection="criteria.criteria" item="criterion"> - <choose> - <when test="criterion.noValue"> - and ${criterion.condition} - </when> - <when test="criterion.singleValue"> - and ${criterion.condition} #{criterion.value} - </when> - <when test="criterion.betweenValue"> - and ${criterion.condition} #{criterion.value} and #{criterion.secondValue} - </when> - <when test="criterion.listValue"> - and ${criterion.condition} - <foreach close=")" collection="criterion.value" item="listItem" open="(" separator=","> - #{listItem} - </foreach> - </when> - </choose> - </foreach> - </trim> - </if> - </foreach> - </where> - </sql> - <sql id="Base_Column_List"> - id, account_name, password, organization_id, email, mobile, weixin, is_delete, create_time, - expire_time - </sql> - <select id="selectByExample" parameterType="com.moral.entity.AccountExample" resultMap="BaseResultMap"> - select - <if test="distinct"> - distinct - </if> - <include refid="Base_Column_List" /> - from account - <if test="_parameter != null"> - <include refid="Example_Where_Clause" /> - </if> - <if test="orderByClause != null"> - order by ${orderByClause} - </if> - </select> - <select id="selectByPrimaryKey" parameterType="java.lang.Integer" resultMap="BaseResultMap"> - select - <include refid="Base_Column_List" /> - from account - where id = #{id,jdbcType=INTEGER} - </select> - <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer"> - delete from account - where id = #{id,jdbcType=INTEGER} - </delete> - <delete id="deleteByExample" parameterType="com.moral.entity.AccountExample"> - delete from account - <if test="_parameter != null"> - <include refid="Example_Where_Clause" /> - </if> - </delete> - <insert id="insert" parameterType="com.moral.entity.Account"> - insert into account (id, account_name, password, - organization_id, email, mobile, - weixin, is_delete, create_time, - expire_time) - values (#{id,jdbcType=INTEGER}, #{accountName,jdbcType=VARCHAR}, #{password,jdbcType=VARCHAR}, - #{organizationId,jdbcType=INTEGER}, #{email,jdbcType=VARCHAR}, #{mobile,jdbcType=VARCHAR}, - #{weixin,jdbcType=VARCHAR}, #{isDelete,jdbcType=CHAR}, #{createTime,jdbcType=TIMESTAMP}, - #{expireTime,jdbcType=TIMESTAMP}) - </insert> - <insert id="insertSelective" parameterType="com.moral.entity.Account"> - insert into account - <trim prefix="(" suffix=")" suffixOverrides=","> - <if test="id != null"> - id, - </if> - <if test="accountName != null"> - account_name, - </if> - <if test="password != null"> - password, - </if> - <if test="organizationId != null"> - organization_id, - </if> - <if test="email != null"> - email, - </if> - <if test="mobile != null"> - mobile, - </if> - <if test="weixin != null"> - weixin, - </if> - <if test="isDelete != null"> - is_delete, - </if> - <if test="createTime != null"> - create_time, - </if> - <if test="expireTime != null"> - expire_time, - </if> - </trim> - <trim prefix="values (" suffix=")" suffixOverrides=","> - <if test="id != null"> - #{id,jdbcType=INTEGER}, - </if> - <if test="accountName != null"> - #{accountName,jdbcType=VARCHAR}, - </if> - <if test="password != null"> - #{password,jdbcType=VARCHAR}, - </if> - <if test="organizationId != null"> - #{organizationId,jdbcType=INTEGER}, - </if> - <if test="email != null"> - #{email,jdbcType=VARCHAR}, - </if> - <if test="mobile != null"> - #{mobile,jdbcType=VARCHAR}, - </if> - <if test="weixin != null"> - #{weixin,jdbcType=VARCHAR}, - </if> - <if test="isDelete != null"> - #{isDelete,jdbcType=CHAR}, - </if> - <if test="createTime != null"> - #{createTime,jdbcType=TIMESTAMP}, - </if> - <if test="expireTime != null"> - #{expireTime,jdbcType=TIMESTAMP}, - </if> - </trim> - </insert> - <select id="countByExample" parameterType="com.moral.entity.AccountExample" resultType="java.lang.Integer"> - select count(*) from account - <if test="_parameter != null"> - <include refid="Example_Where_Clause" /> - </if> - </select> - <update id="updateByExampleSelective" parameterType="map"> - update account - <set> - <if test="record.id != null"> - id = #{record.id,jdbcType=INTEGER}, - </if> - <if test="record.accountName != null"> - account_name = #{record.accountName,jdbcType=VARCHAR}, - </if> - <if test="record.password != null"> - password = #{record.password,jdbcType=VARCHAR}, - </if> - <if test="record.organizationId != null"> - organization_id = #{record.organizationId,jdbcType=INTEGER}, - </if> - <if test="record.email != null"> - email = #{record.email,jdbcType=VARCHAR}, - </if> - <if test="record.mobile != null"> - mobile = #{record.mobile,jdbcType=VARCHAR}, - </if> - <if test="record.weixin != null"> - weixin = #{record.weixin,jdbcType=VARCHAR}, - </if> - <if test="record.isDelete != null"> - is_delete = #{record.isDelete,jdbcType=CHAR}, - </if> - <if test="record.createTime != null"> - create_time = #{record.createTime,jdbcType=TIMESTAMP}, - </if> - <if test="record.expireTime != null"> - expire_time = #{record.expireTime,jdbcType=TIMESTAMP}, - </if> - </set> - <if test="_parameter != null"> - <include refid="Update_By_Example_Where_Clause" /> - </if> - </update> - <update id="updateByExample" parameterType="map"> - update account - set id = #{record.id,jdbcType=INTEGER}, - account_name = #{record.accountName,jdbcType=VARCHAR}, - password = #{record.password,jdbcType=VARCHAR}, - organization_id = #{record.organizationId,jdbcType=INTEGER}, - email = #{record.email,jdbcType=VARCHAR}, - mobile = #{record.mobile,jdbcType=VARCHAR}, - weixin = #{record.weixin,jdbcType=VARCHAR}, - is_delete = #{record.isDelete,jdbcType=CHAR}, - create_time = #{record.createTime,jdbcType=TIMESTAMP}, - expire_time = #{record.expireTime,jdbcType=TIMESTAMP} - <if test="_parameter != null"> - <include refid="Update_By_Example_Where_Clause" /> - </if> - </update> - <update id="updateByPrimaryKeySelective" parameterType="com.moral.entity.Account"> - update account - <set> - <if test="accountName != null"> - account_name = #{accountName,jdbcType=VARCHAR}, - </if> - <if test="password != null"> - password = #{password,jdbcType=VARCHAR}, - </if> - <if test="organizationId != null"> - organization_id = #{organizationId,jdbcType=INTEGER}, - </if> - <if test="email != null"> - email = #{email,jdbcType=VARCHAR}, - </if> - <if test="mobile != null"> - mobile = #{mobile,jdbcType=VARCHAR}, - </if> - <if test="weixin != null"> - weixin = #{weixin,jdbcType=VARCHAR}, - </if> - <if test="isDelete != null"> - is_delete = #{isDelete,jdbcType=CHAR}, - </if> - <if test="createTime != null"> - create_time = #{createTime,jdbcType=TIMESTAMP}, - </if> - <if test="expireTime != null"> - expire_time = #{expireTime,jdbcType=TIMESTAMP}, - </if> - </set> - where id = #{id,jdbcType=INTEGER} - </update> - <update id="updateByPrimaryKey" parameterType="com.moral.entity.Account"> - update account - set account_name = #{accountName,jdbcType=VARCHAR}, - password = #{password,jdbcType=VARCHAR}, - organization_id = #{organizationId,jdbcType=INTEGER}, - email = #{email,jdbcType=VARCHAR}, - mobile = #{mobile,jdbcType=VARCHAR}, - weixin = #{weixin,jdbcType=VARCHAR}, - is_delete = #{isDelete,jdbcType=CHAR}, - create_time = #{createTime,jdbcType=TIMESTAMP}, - expire_time = #{expireTime,jdbcType=TIMESTAMP} - where id = #{id,jdbcType=INTEGER} - </update> <select id="getRoleNameByAccountId" resultType="map"> SELECT diff --git a/src/main/resources/mapper/DeviceMapper.xml b/src/main/resources/mapper/DeviceMapper.xml index d9ff9bf..9f49de0 100644 --- a/src/main/resources/mapper/DeviceMapper.xml +++ b/src/main/resources/mapper/DeviceMapper.xml @@ -20,381 +20,6 @@ <result column="monitor_point_id" jdbcType="INTEGER" property="monitorPointId" /> <result column="device_version_id" jdbcType="INTEGER" property="deviceVersionId" /> </resultMap> - <sql id="Example_Where_Clause"> - <!-- - WARNING - @mbggenerated - This element is automatically generated by MyBatis Generator, do not modify. - This element was generated on Wed Nov 29 16:17:59 CST 2017. - --> - <where> - <foreach collection="oredCriteria" item="criteria" separator="or"> - <if test="criteria.valid"> - <trim prefix="(" prefixOverrides="and" suffix=")"> - <foreach collection="criteria.criteria" item="criterion"> - <choose> - <when test="criterion.noValue"> - and ${criterion.condition} - </when> - <when test="criterion.singleValue"> - and ${criterion.condition} #{criterion.value} - </when> - <when test="criterion.betweenValue"> - and ${criterion.condition} #{criterion.value} and #{criterion.secondValue} - </when> - <when test="criterion.listValue"> - and ${criterion.condition} - <foreach close=")" collection="criterion.value" item="listItem" open="(" separator=","> - #{listItem} - </foreach> - </when> - </choose> - </foreach> - </trim> - </if> - </foreach> - </where> - </sql> - <sql id="Update_By_Example_Where_Clause"> - <!-- - WARNING - @mbggenerated - This element is automatically generated by MyBatis Generator, do not modify. - This element was generated on Wed Nov 29 16:17:59 CST 2017. - --> - <where> - <foreach collection="example.oredCriteria" item="criteria" separator="or"> - <if test="criteria.valid"> - <trim prefix="(" prefixOverrides="and" suffix=")"> - <foreach collection="criteria.criteria" item="criterion"> - <choose> - <when test="criterion.noValue"> - and ${criterion.condition} - </when> - <when test="criterion.singleValue"> - and ${criterion.condition} #{criterion.value} - </when> - <when test="criterion.betweenValue"> - and ${criterion.condition} #{criterion.value} and #{criterion.secondValue} - </when> - <when test="criterion.listValue"> - and ${criterion.condition} - <foreach close=")" collection="criterion.value" item="listItem" open="(" separator=","> - #{listItem} - </foreach> - </when> - </choose> - </foreach> - </trim> - </if> - </foreach> - </where> - </sql> - <sql id="Base_Column_List"> - <!-- - WARNING - @mbggenerated - This element is automatically generated by MyBatis Generator, do not modify. - This element was generated on Wed Nov 29 16:17:59 CST 2017. - --> - id, name, address, longitude, latitude, mac, operate_user_id, state, create_time, - install_time, monitor_point_id, device_version_id - </sql> - <select id="selectByExample" parameterType="com.moral.entity.DeviceExample" resultMap="BaseResultMap"> - <!-- - WARNING - @mbggenerated - This element is automatically generated by MyBatis Generator, do not modify. - This element was generated on Wed Nov 29 16:17:59 CST 2017. - --> - select - <if test="distinct"> - distinct - </if> - <include refid="Base_Column_List" /> - from device - <if test="_parameter != null"> - <include refid="Example_Where_Clause" /> - </if> - <if test="orderByClause != null"> - order by ${orderByClause} - </if> - </select> - <select id="selectByPrimaryKey" parameterType="java.lang.Integer" resultMap="BaseResultMap"> - <!-- - WARNING - @mbggenerated - This element is automatically generated by MyBatis Generator, do not modify. - This element was generated on Wed Nov 29 16:17:59 CST 2017. - --> - select - <include refid="Base_Column_List" /> - from device - where id = #{id,jdbcType=INTEGER} - </select> - <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer"> - <!-- - WARNING - @mbggenerated - This element is automatically generated by MyBatis Generator, do not modify. - This element was generated on Wed Nov 29 16:17:59 CST 2017. - --> - delete from device - where id = #{id,jdbcType=INTEGER} - </delete> - <delete id="deleteByExample" parameterType="com.moral.entity.DeviceExample"> - <!-- - WARNING - @mbggenerated - This element is automatically generated by MyBatis Generator, do not modify. - This element was generated on Wed Nov 29 16:17:59 CST 2017. - --> - delete from device - <if test="_parameter != null"> - <include refid="Example_Where_Clause" /> - </if> - </delete> - <insert id="insert" parameterType="com.moral.entity.Device"> - <!-- - WARNING - @mbggenerated - This element is automatically generated by MyBatis Generator, do not modify. - This element was generated on Wed Nov 29 16:17:59 CST 2017. - --> - insert into device (id, name, address, - longitude, latitude, mac, - operate_user_id, state, create_time, - install_time, monitor_point_id, device_version_id - ) - values (#{id,jdbcType=INTEGER}, #{name,jdbcType=VARCHAR}, #{address,jdbcType=VARCHAR}, - #{longitude,jdbcType=REAL}, #{latitude,jdbcType=REAL}, #{mac,jdbcType=VARCHAR}, - #{operateUserId,jdbcType=INTEGER}, #{state,jdbcType=CHAR}, #{createTime,jdbcType=TIMESTAMP}, - #{installTime,jdbcType=TIMESTAMP}, #{monitorPointId,jdbcType=INTEGER}, #{deviceVersionId,jdbcType=INTEGER} - ) - </insert> - <insert id="insertSelective" parameterType="com.moral.entity.Device"> - <!-- - WARNING - @mbggenerated - This element is automatically generated by MyBatis Generator, do not modify. - This element was generated on Wed Nov 29 16:17:59 CST 2017. - --> - insert into device - <trim prefix="(" suffix=")" suffixOverrides=","> - <if test="id != null"> - id, - </if> - <if test="name != null"> - name, - </if> - <if test="address != null"> - address, - </if> - <if test="longitude != null"> - longitude, - </if> - <if test="latitude != null"> - latitude, - </if> - <if test="mac != null"> - mac, - </if> - <if test="operateUserId != null"> - operate_user_id, - </if> - <if test="state != null"> - state, - </if> - <if test="createTime != null"> - create_time, - </if> - <if test="installTime != null"> - install_time, - </if> - <if test="monitorPointId != null"> - monitor_point_id, - </if> - <if test="deviceVersionId != null"> - device_version_id, - </if> - </trim> - <trim prefix="values (" suffix=")" suffixOverrides=","> - <if test="id != null"> - #{id,jdbcType=INTEGER}, - </if> - <if test="name != null"> - #{name,jdbcType=VARCHAR}, - </if> - <if test="address != null"> - #{address,jdbcType=VARCHAR}, - </if> - <if test="longitude != null"> - #{longitude,jdbcType=REAL}, - </if> - <if test="latitude != null"> - #{latitude,jdbcType=REAL}, - </if> - <if test="mac != null"> - #{mac,jdbcType=VARCHAR}, - </if> - <if test="operateUserId != null"> - #{operateUserId,jdbcType=INTEGER}, - </if> - <if test="state != null"> - #{state,jdbcType=CHAR}, - </if> - <if test="createTime != null"> - #{createTime,jdbcType=TIMESTAMP}, - </if> - <if test="installTime != null"> - #{installTime,jdbcType=TIMESTAMP}, - </if> - <if test="monitorPointId != null"> - #{monitorPointId,jdbcType=INTEGER}, - </if> - <if test="deviceVersionId != null"> - #{deviceVersionId,jdbcType=INTEGER}, - </if> - </trim> - </insert> - <select id="countByExample" parameterType="com.moral.entity.DeviceExample" resultType="java.lang.Integer"> - <!-- - WARNING - @mbggenerated - This element is automatically generated by MyBatis Generator, do not modify. - This element was generated on Wed Nov 29 16:17:59 CST 2017. - --> - select count(*) from device - <if test="_parameter != null"> - <include refid="Example_Where_Clause" /> - </if> - </select> - <update id="updateByExampleSelective" parameterType="map"> - <!-- - WARNING - @mbggenerated - This element is automatically generated by MyBatis Generator, do not modify. - This element was generated on Wed Nov 29 16:17:59 CST 2017. - --> - update device - <set> - <if test="record.id != null"> - id = #{record.id,jdbcType=INTEGER}, - </if> - <if test="record.name != null"> - name = #{record.name,jdbcType=VARCHAR}, - </if> - <if test="record.address != null"> - address = #{record.address,jdbcType=VARCHAR}, - </if> - <if test="record.longitude != null"> - longitude = #{record.longitude,jdbcType=REAL}, - </if> - <if test="record.latitude != null"> - latitude = #{record.latitude,jdbcType=REAL}, - </if> - <if test="record.mac != null"> - mac = #{record.mac,jdbcType=VARCHAR}, - </if> - <if test="record.operateUserId != null"> - operate_user_id = #{record.operateUserId,jdbcType=INTEGER}, - </if> - <if test="record.state != null"> - state = #{record.state,jdbcType=CHAR}, - </if> - <if test="record.createTime != null"> - create_time = #{record.createTime,jdbcType=TIMESTAMP}, - </if> - <if test="record.installTime != null"> - install_time = #{record.installTime,jdbcType=TIMESTAMP}, - </if> - <if test="record.monitorPointId != null"> - monitor_point_id = #{record.monitorPointId,jdbcType=INTEGER}, - </if> - <if test="record.deviceVersionId != null"> - device_version_id = #{record.deviceVersionId,jdbcType=INTEGER}, - </if> - </set> - <if test="_parameter != null"> - <include refid="Update_By_Example_Where_Clause" /> - </if> - </update> - <update id="updateByExample" parameterType="map"> - <!-- - WARNING - @mbggenerated - This element is automatically generated by MyBatis Generator, do not modify. - This element was generated on Wed Nov 29 16:17:59 CST 2017. - --> - update device - set id = #{record.id,jdbcType=INTEGER}, - name = #{record.name,jdbcType=VARCHAR}, - address = #{record.address,jdbcType=VARCHAR}, - longitude = #{record.longitude,jdbcType=REAL}, - latitude = #{record.latitude,jdbcType=REAL}, - mac = #{record.mac,jdbcType=VARCHAR}, - operate_user_id = #{record.operateUserId,jdbcType=INTEGER}, - state = #{record.state,jdbcType=CHAR}, - create_time = #{record.createTime,jdbcType=TIMESTAMP}, - install_time = #{record.installTime,jdbcType=TIMESTAMP}, - monitor_point_id = #{record.monitorPointId,jdbcType=INTEGER}, - device_version_id = #{record.deviceVersionId,jdbcType=INTEGER} - <if test="_parameter != null"> - <include refid="Update_By_Example_Where_Clause" /> - </if> - </update> - <update id="updateByPrimaryKeySelective" parameterType="com.moral.entity.Device"> - <!-- - WARNING - @mbggenerated - This element is automatically generated by MyBatis Generator, do not modify. - This element was generated on Wed Nov 29 16:17:59 CST 2017. - --> - update device - <set> - <if test="name != null"> - name = #{name,jdbcType=VARCHAR}, - </if> - <if test="address != null"> - address = #{address,jdbcType=VARCHAR}, - </if> - <if test="longitude != null"> - longitude = #{longitude,jdbcType=REAL}, - </if> - <if test="latitude != null"> - latitude = #{latitude,jdbcType=REAL}, - </if> - <if test="mac != null"> - mac = #{mac,jdbcType=VARCHAR}, - </if> - <if test="operateUserId != null"> - operate_user_id = #{operateUserId,jdbcType=INTEGER}, - </if> - <if test="state != null"> - state = #{state,jdbcType=CHAR}, - </if> - <if test="createTime != null"> - create_time = #{createTime,jdbcType=TIMESTAMP}, - </if> - <if test="installTime != null"> - install_time = #{installTime,jdbcType=TIMESTAMP}, - </if> - <if test="monitorPointId != null"> - monitor_point_id = #{monitorPointId,jdbcType=INTEGER}, - </if> - <if test="deviceVersionId != null"> - device_version_id = #{deviceVersionId,jdbcType=INTEGER}, - </if> - </set> - where id = #{id,jdbcType=INTEGER} - </update> - <update id="updateByPrimaryKey" parameterType="com.moral.entity.Device"> - <!-- - WARNING - @mbggenerated - This element is automatically generated by MyBatis Generator, do not modify. - This element was generated on Wed Nov 29 16:17:59 CST 2017. - --> - update device - set name = #{name,jdbcType=VARCHAR}, - address = #{address,jdbcType=VARCHAR}, - longitude = #{longitude,jdbcType=REAL}, - latitude = #{latitude,jdbcType=REAL}, - mac = #{mac,jdbcType=VARCHAR}, - operate_user_id = #{operateUserId,jdbcType=INTEGER}, - state = #{state,jdbcType=CHAR}, - create_time = #{createTime,jdbcType=TIMESTAMP}, - install_time = #{installTime,jdbcType=TIMESTAMP}, - monitor_point_id = #{monitorPointId,jdbcType=INTEGER}, - device_version_id = #{deviceVersionId,jdbcType=INTEGER} - where id = #{id,jdbcType=INTEGER} - </update> <select id="getDeviceStatesByAccount" resultType="map"> SELECT COUNT( d.state ) count, diff --git a/src/main/resources/mapper/OperateUserMapper.xml b/src/main/resources/mapper/OperateUserMapper.xml index b9dc0e9..37a87c8 100644 --- a/src/main/resources/mapper/OperateUserMapper.xml +++ b/src/main/resources/mapper/OperateUserMapper.xml @@ -14,293 +14,4 @@ <result column="create_time" property="createTime" jdbcType="TIMESTAMP" /> <result column="expire_time" property="expireTime" jdbcType="TIMESTAMP" /> </resultMap> - <sql id="Example_Where_Clause" > - <where > - <foreach collection="oredCriteria" item="criteria" separator="or" > - <if test="criteria.valid" > - <trim prefix="(" suffix=")" prefixOverrides="and" > - <foreach collection="criteria.criteria" item="criterion" > - <choose > - <when test="criterion.noValue" > - and ${criterion.condition} - </when> - <when test="criterion.singleValue" > - and ${criterion.condition} #{criterion.value} - </when> - <when test="criterion.betweenValue" > - and ${criterion.condition} #{criterion.value} and #{criterion.secondValue} - </when> - <when test="criterion.listValue" > - and ${criterion.condition} - <foreach collection="criterion.value" item="listItem" open="(" close=")" separator="," > - #{listItem} - </foreach> - </when> - </choose> - </foreach> - </trim> - </if> - </foreach> - </where> - </sql> - <sql id="Update_By_Example_Where_Clause" > - <where > - <foreach collection="example.oredCriteria" item="criteria" separator="or" > - <if test="criteria.valid" > - <trim prefix="(" suffix=")" prefixOverrides="and" > - <foreach collection="criteria.criteria" item="criterion" > - <choose > - <when test="criterion.noValue" > - and ${criterion.condition} - </when> - <when test="criterion.singleValue" > - and ${criterion.condition} #{criterion.value} - </when> - <when test="criterion.betweenValue" > - and ${criterion.condition} #{criterion.value} and #{criterion.secondValue} - </when> - <when test="criterion.listValue" > - and ${criterion.condition} - <foreach collection="criterion.value" item="listItem" open="(" close=")" separator="," > - #{listItem} - </foreach> - </when> - </choose> - </foreach> - </trim> - </if> - </foreach> - </where> - </sql> - <sql id="Base_Column_List" > - id, job_number, name, password, organization_id, mobile, email, weixin, is_delete, - create_time, expire_time - </sql> - <select id="selectByExample" resultMap="BaseResultMap" parameterType="com.moral.entity.OperateUserExample" > - select - <if test="distinct" > - distinct - </if> - <include refid="Base_Column_List" /> - from operate_user - <if test="_parameter != null" > - <include refid="Example_Where_Clause" /> - </if> - <if test="orderByClause != null" > - order by ${orderByClause} - </if> - </select> - <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Integer" > - select - <include refid="Base_Column_List" /> - from operate_user - where id = #{id,jdbcType=INTEGER} - </select> - <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer" > - delete from operate_user - where id = #{id,jdbcType=INTEGER} - </delete> - <delete id="deleteByExample" parameterType="com.moral.entity.OperateUserExample" > - delete from operate_user - <if test="_parameter != null" > - <include refid="Example_Where_Clause" /> - </if> - </delete> - <insert id="insert" parameterType="com.moral.entity.OperateUser" > - insert into operate_user (id, job_number, name, - password, organization_id, mobile, - email, weixin, is_delete, - create_time, expire_time) - values (#{id,jdbcType=INTEGER}, #{jobNumber,jdbcType=VARCHAR}, #{name,jdbcType=VARCHAR}, - #{password,jdbcType=VARCHAR}, #{organizationId,jdbcType=INTEGER}, #{mobile,jdbcType=VARCHAR}, - #{email,jdbcType=VARCHAR}, #{weixin,jdbcType=VARCHAR}, #{isDelete,jdbcType=CHAR}, - #{createTime,jdbcType=TIMESTAMP}, #{expireTime,jdbcType=TIMESTAMP}) - </insert> - <insert id="insertSelective" parameterType="com.moral.entity.OperateUser" > - insert into operate_user - <trim prefix="(" suffix=")" suffixOverrides="," > - <if test="id != null" > - id, - </if> - <if test="jobNumber != null" > - job_number, - </if> - <if test="name != null" > - name, - </if> - <if test="password != null" > - password, - </if> - <if test="organizationId != null" > - organization_id, - </if> - <if test="mobile != null" > - mobile, - </if> - <if test="email != null" > - email, - </if> - <if test="weixin != null" > - weixin, - </if> - <if test="isDelete != null" > - is_delete, - </if> - <if test="createTime != null" > - create_time, - </if> - <if test="expireTime != null" > - expire_time, - </if> - </trim> - <trim prefix="values (" suffix=")" suffixOverrides="," > - <if test="id != null" > - #{id,jdbcType=INTEGER}, - </if> - <if test="jobNumber != null" > - #{jobNumber,jdbcType=VARCHAR}, - </if> - <if test="name != null" > - #{name,jdbcType=VARCHAR}, - </if> - <if test="password != null" > - #{password,jdbcType=VARCHAR}, - </if> - <if test="organizationId != null" > - #{organizationId,jdbcType=INTEGER}, - </if> - <if test="mobile != null" > - #{mobile,jdbcType=VARCHAR}, - </if> - <if test="email != null" > - #{email,jdbcType=VARCHAR}, - </if> - <if test="weixin != null" > - #{weixin,jdbcType=VARCHAR}, - </if> - <if test="isDelete != null" > - #{isDelete,jdbcType=CHAR}, - </if> - <if test="createTime != null" > - #{createTime,jdbcType=TIMESTAMP}, - </if> - <if test="expireTime != null" > - #{expireTime,jdbcType=TIMESTAMP}, - </if> - </trim> - </insert> - <select id="countByExample" parameterType="com.moral.entity.OperateUserExample" resultType="java.lang.Integer" > - select count(*) from operate_user - <if test="_parameter != null" > - <include refid="Example_Where_Clause" /> - </if> - </select> - <update id="updateByExampleSelective" parameterType="map" > - update operate_user - <set > - <if test="record.id != null" > - id = #{record.id,jdbcType=INTEGER}, - </if> - <if test="record.jobNumber != null" > - job_number = #{record.jobNumber,jdbcType=VARCHAR}, - </if> - <if test="record.name != null" > - name = #{record.name,jdbcType=VARCHAR}, - </if> - <if test="record.password != null" > - password = #{record.password,jdbcType=VARCHAR}, - </if> - <if test="record.organizationId != null" > - organization_id = #{record.organizationId,jdbcType=INTEGER}, - </if> - <if test="record.mobile != null" > - mobile = #{record.mobile,jdbcType=VARCHAR}, - </if> - <if test="record.email != null" > - email = #{record.email,jdbcType=VARCHAR}, - </if> - <if test="record.weixin != null" > - weixin = #{record.weixin,jdbcType=VARCHAR}, - </if> - <if test="record.isDelete != null" > - is_delete = #{record.isDelete,jdbcType=CHAR}, - </if> - <if test="record.createTime != null" > - create_time = #{record.createTime,jdbcType=TIMESTAMP}, - </if> - <if test="record.expireTime != null" > - expire_time = #{record.expireTime,jdbcType=TIMESTAMP}, - </if> - </set> - <if test="_parameter != null" > - <include refid="Update_By_Example_Where_Clause" /> - </if> - </update> - <update id="updateByExample" parameterType="map" > - update operate_user - set id = #{record.id,jdbcType=INTEGER}, - job_number = #{record.jobNumber,jdbcType=VARCHAR}, - name = #{record.name,jdbcType=VARCHAR}, - password = #{record.password,jdbcType=VARCHAR}, - organization_id = #{record.organizationId,jdbcType=INTEGER}, - mobile = #{record.mobile,jdbcType=VARCHAR}, - email = #{record.email,jdbcType=VARCHAR}, - weixin = #{record.weixin,jdbcType=VARCHAR}, - is_delete = #{record.isDelete,jdbcType=CHAR}, - create_time = #{record.createTime,jdbcType=TIMESTAMP}, - expire_time = #{record.expireTime,jdbcType=TIMESTAMP} - <if test="_parameter != null" > - <include refid="Update_By_Example_Where_Clause" /> - </if> - </update> - <update id="updateByPrimaryKeySelective" parameterType="com.moral.entity.OperateUser" > - update operate_user - <set > - <if test="jobNumber != null" > - job_number = #{jobNumber,jdbcType=VARCHAR}, - </if> - <if test="name != null" > - name = #{name,jdbcType=VARCHAR}, - </if> - <if test="password != null" > - password = #{password,jdbcType=VARCHAR}, - </if> - <if test="organizationId != null" > - organization_id = #{organizationId,jdbcType=INTEGER}, - </if> - <if test="mobile != null" > - mobile = #{mobile,jdbcType=VARCHAR}, - </if> - <if test="email != null" > - email = #{email,jdbcType=VARCHAR}, - </if> - <if test="weixin != null" > - weixin = #{weixin,jdbcType=VARCHAR}, - </if> - <if test="isDelete != null" > - is_delete = #{isDelete,jdbcType=CHAR}, - </if> - <if test="createTime != null" > - create_time = #{createTime,jdbcType=TIMESTAMP}, - </if> - <if test="expireTime != null" > - expire_time = #{expireTime,jdbcType=TIMESTAMP}, - </if> - </set> - where id = #{id,jdbcType=INTEGER} - </update> - <update id="updateByPrimaryKey" parameterType="com.moral.entity.OperateUser" > - update operate_user - set job_number = #{jobNumber,jdbcType=VARCHAR}, - name = #{name,jdbcType=VARCHAR}, - password = #{password,jdbcType=VARCHAR}, - organization_id = #{organizationId,jdbcType=INTEGER}, - mobile = #{mobile,jdbcType=VARCHAR}, - email = #{email,jdbcType=VARCHAR}, - weixin = #{weixin,jdbcType=VARCHAR}, - is_delete = #{isDelete,jdbcType=CHAR}, - create_time = #{createTime,jdbcType=TIMESTAMP}, - expire_time = #{expireTime,jdbcType=TIMESTAMP} - where id = #{id,jdbcType=INTEGER} - </update> </mapper> \ No newline at end of file diff --git a/src/main/resources/mapper/OrganizationMapper.xml b/src/main/resources/mapper/OrganizationMapper.xml index aa64439..bb995d4 100644 --- a/src/main/resources/mapper/OrganizationMapper.xml +++ b/src/main/resources/mapper/OrganizationMapper.xml @@ -16,323 +16,5 @@ <result column="expire_time" property="expireTime" jdbcType="TIMESTAMP" /> <result column="description" property="description" jdbcType="VARCHAR" /> </resultMap> - <sql id="Example_Where_Clause" > - <where > - <foreach collection="oredCriteria" item="criteria" separator="or" > - <if test="criteria.valid" > - <trim prefix="(" suffix=")" prefixOverrides="and" > - <foreach collection="criteria.criteria" item="criterion" > - <choose > - <when test="criterion.noValue" > - and ${criterion.condition} - </when> - <when test="criterion.singleValue" > - and ${criterion.condition} #{criterion.value} - </when> - <when test="criterion.betweenValue" > - and ${criterion.condition} #{criterion.value} and #{criterion.secondValue} - </when> - <when test="criterion.listValue" > - and ${criterion.condition} - <foreach collection="criterion.value" item="listItem" open="(" close=")" separator="," > - #{listItem} - </foreach> - </when> - </choose> - </foreach> - </trim> - </if> - </foreach> - </where> - </sql> - <sql id="Update_By_Example_Where_Clause" > - <where > - <foreach collection="example.oredCriteria" item="criteria" separator="or" > - <if test="criteria.valid" > - <trim prefix="(" suffix=")" prefixOverrides="and" > - <foreach collection="criteria.criteria" item="criterion" > - <choose > - <when test="criterion.noValue" > - and ${criterion.condition} - </when> - <when test="criterion.singleValue" > - and ${criterion.condition} #{criterion.value} - </when> - <when test="criterion.betweenValue" > - and ${criterion.condition} #{criterion.value} and #{criterion.secondValue} - </when> - <when test="criterion.listValue" > - and ${criterion.condition} - <foreach collection="criterion.value" item="listItem" open="(" close=")" separator="," > - #{listItem} - </foreach> - </when> - </choose> - </foreach> - </trim> - </if> - </foreach> - </where> - </sql> - <sql id="Base_Column_List" > - id, name, rank, province_code, city_code, area_code, address, telephone, email, is_delete, - create_time, expire_time, description - </sql> - <select id="selectByExample" resultMap="BaseResultMap" parameterType="com.moral.entity.OrganizationExample" > - select - <if test="distinct" > - distinct - </if> - <include refid="Base_Column_List" /> - from organization - <if test="_parameter != null" > - <include refid="Example_Where_Clause" /> - </if> - <if test="orderByClause != null" > - order by ${orderByClause} - </if> - </select> - <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Integer" > - select - <include refid="Base_Column_List" /> - from organization - where id = #{id,jdbcType=INTEGER} - </select> - <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer" > - delete from organization - where id = #{id,jdbcType=INTEGER} - </delete> - <delete id="deleteByExample" parameterType="com.moral.entity.OrganizationExample" > - delete from organization - <if test="_parameter != null" > - <include refid="Example_Where_Clause" /> - </if> - </delete> - <insert id="insert" parameterType="com.moral.entity.Organization" > - insert into organization (id, name, rank, - province_code, city_code, area_code, - address, telephone, email, - is_delete, create_time, expire_time, - description) - values (#{id,jdbcType=INTEGER}, #{name,jdbcType=VARCHAR}, #{rank,jdbcType=INTEGER}, - #{provinceCode,jdbcType=INTEGER}, #{cityCode,jdbcType=INTEGER}, #{areaCode,jdbcType=INTEGER}, - #{address,jdbcType=VARCHAR}, #{telephone,jdbcType=VARCHAR}, #{email,jdbcType=VARCHAR}, - #{isDelete,jdbcType=CHAR}, #{createTime,jdbcType=TIMESTAMP}, #{expireTime,jdbcType=TIMESTAMP}, - #{description,jdbcType=VARCHAR}) - </insert> - <insert id="insertSelective" parameterType="com.moral.entity.Organization" > - insert into organization - <trim prefix="(" suffix=")" suffixOverrides="," > - <if test="id != null" > - id, - </if> - <if test="name != null" > - name, - </if> - <if test="rank != null" > - rank, - </if> - <if test="provinceCode != null" > - province_code, - </if> - <if test="cityCode != null" > - city_code, - </if> - <if test="areaCode != null" > - area_code, - </if> - <if test="address != null" > - address, - </if> - <if test="telephone != null" > - telephone, - </if> - <if test="email != null" > - email, - </if> - <if test="isDelete != null" > - is_delete, - </if> - <if test="createTime != null" > - create_time, - </if> - <if test="expireTime != null" > - expire_time, - </if> - <if test="description != null" > - description, - </if> - </trim> - <trim prefix="values (" suffix=")" suffixOverrides="," > - <if test="id != null" > - #{id,jdbcType=INTEGER}, - </if> - <if test="name != null" > - #{name,jdbcType=VARCHAR}, - </if> - <if test="rank != null" > - #{rank,jdbcType=INTEGER}, - </if> - <if test="provinceCode != null" > - #{provinceCode,jdbcType=INTEGER}, - </if> - <if test="cityCode != null" > - #{cityCode,jdbcType=INTEGER}, - </if> - <if test="areaCode != null" > - #{areaCode,jdbcType=INTEGER}, - </if> - <if test="address != null" > - #{address,jdbcType=VARCHAR}, - </if> - <if test="telephone != null" > - #{telephone,jdbcType=VARCHAR}, - </if> - <if test="email != null" > - #{email,jdbcType=VARCHAR}, - </if> - <if test="isDelete != null" > - #{isDelete,jdbcType=CHAR}, - </if> - <if test="createTime != null" > - #{createTime,jdbcType=TIMESTAMP}, - </if> - <if test="expireTime != null" > - #{expireTime,jdbcType=TIMESTAMP}, - </if> - <if test="description != null" > - #{description,jdbcType=VARCHAR}, - </if> - </trim> - </insert> - <select id="countByExample" parameterType="com.moral.entity.OrganizationExample" resultType="java.lang.Integer" > - select count(*) from organization - <if test="_parameter != null" > - <include refid="Example_Where_Clause" /> - </if> - </select> - <update id="updateByExampleSelective" parameterType="map" > - update organization - <set > - <if test="record.id != null" > - id = #{record.id,jdbcType=INTEGER}, - </if> - <if test="record.name != null" > - name = #{record.name,jdbcType=VARCHAR}, - </if> - <if test="record.rank != null" > - rank = #{record.rank,jdbcType=INTEGER}, - </if> - <if test="record.provinceCode != null" > - province_code = #{record.provinceCode,jdbcType=INTEGER}, - </if> - <if test="record.cityCode != null" > - city_code = #{record.cityCode,jdbcType=INTEGER}, - </if> - <if test="record.areaCode != null" > - area_code = #{record.areaCode,jdbcType=INTEGER}, - </if> - <if test="record.address != null" > - address = #{record.address,jdbcType=VARCHAR}, - </if> - <if test="record.telephone != null" > - telephone = #{record.telephone,jdbcType=VARCHAR}, - </if> - <if test="record.email != null" > - email = #{record.email,jdbcType=VARCHAR}, - </if> - <if test="record.isDelete != null" > - is_delete = #{record.isDelete,jdbcType=CHAR}, - </if> - <if test="record.createTime != null" > - create_time = #{record.createTime,jdbcType=TIMESTAMP}, - </if> - <if test="record.expireTime != null" > - expire_time = #{record.expireTime,jdbcType=TIMESTAMP}, - </if> - <if test="record.description != null" > - description = #{record.description,jdbcType=VARCHAR}, - </if> - </set> - <if test="_parameter != null" > - <include refid="Update_By_Example_Where_Clause" /> - </if> - </update> - <update id="updateByExample" parameterType="map" > - update organization - set id = #{record.id,jdbcType=INTEGER}, - name = #{record.name,jdbcType=VARCHAR}, - rank = #{record.rank,jdbcType=INTEGER}, - province_code = #{record.provinceCode,jdbcType=INTEGER}, - city_code = #{record.cityCode,jdbcType=INTEGER}, - area_code = #{record.areaCode,jdbcType=INTEGER}, - address = #{record.address,jdbcType=VARCHAR}, - telephone = #{record.telephone,jdbcType=VARCHAR}, - email = #{record.email,jdbcType=VARCHAR}, - is_delete = #{record.isDelete,jdbcType=CHAR}, - create_time = #{record.createTime,jdbcType=TIMESTAMP}, - expire_time = #{record.expireTime,jdbcType=TIMESTAMP}, - description = #{record.description,jdbcType=VARCHAR} - <if test="_parameter != null" > - <include refid="Update_By_Example_Where_Clause" /> - </if> - </update> - <update id="updateByPrimaryKeySelective" parameterType="com.moral.entity.Organization" > - update organization - <set > - <if test="name != null" > - name = #{name,jdbcType=VARCHAR}, - </if> - <if test="rank != null" > - rank = #{rank,jdbcType=INTEGER}, - </if> - <if test="provinceCode != null" > - province_code = #{provinceCode,jdbcType=INTEGER}, - </if> - <if test="cityCode != null" > - city_code = #{cityCode,jdbcType=INTEGER}, - </if> - <if test="areaCode != null" > - area_code = #{areaCode,jdbcType=INTEGER}, - </if> - <if test="address != null" > - address = #{address,jdbcType=VARCHAR}, - </if> - <if test="telephone != null" > - telephone = #{telephone,jdbcType=VARCHAR}, - </if> - <if test="email != null" > - email = #{email,jdbcType=VARCHAR}, - </if> - <if test="isDelete != null" > - is_delete = #{isDelete,jdbcType=CHAR}, - </if> - <if test="createTime != null" > - create_time = #{createTime,jdbcType=TIMESTAMP}, - </if> - <if test="expireTime != null" > - expire_time = #{expireTime,jdbcType=TIMESTAMP}, - </if> - <if test="description != null" > - description = #{description,jdbcType=VARCHAR}, - </if> - </set> - where id = #{id,jdbcType=INTEGER} - </update> - <update id="updateByPrimaryKey" parameterType="com.moral.entity.Organization" > - update organization - set name = #{name,jdbcType=VARCHAR}, - rank = #{rank,jdbcType=INTEGER}, - province_code = #{provinceCode,jdbcType=INTEGER}, - city_code = #{cityCode,jdbcType=INTEGER}, - area_code = #{areaCode,jdbcType=INTEGER}, - address = #{address,jdbcType=VARCHAR}, - telephone = #{telephone,jdbcType=VARCHAR}, - email = #{email,jdbcType=VARCHAR}, - is_delete = #{isDelete,jdbcType=CHAR}, - create_time = #{createTime,jdbcType=TIMESTAMP}, - expire_time = #{expireTime,jdbcType=TIMESTAMP}, - description = #{description,jdbcType=VARCHAR} - where id = #{id,jdbcType=INTEGER} - </update> + </mapper> \ No newline at end of file diff --git a/src/main/resources/mapper/OrganizationRelationMapper.xml b/src/main/resources/mapper/OrganizationRelationMapper.xml index 4af8ead..7794fba 100644 --- a/src/main/resources/mapper/OrganizationRelationMapper.xml +++ b/src/main/resources/mapper/OrganizationRelationMapper.xml @@ -6,176 +6,4 @@ <result column="parent_id" property="parentId" jdbcType="INTEGER" /> <result column="child_id" property="childId" jdbcType="INTEGER" /> </resultMap> - <sql id="Example_Where_Clause" > - <where > - <foreach collection="oredCriteria" item="criteria" separator="or" > - <if test="criteria.valid" > - <trim prefix="(" suffix=")" prefixOverrides="and" > - <foreach collection="criteria.criteria" item="criterion" > - <choose > - <when test="criterion.noValue" > - and ${criterion.condition} - </when> - <when test="criterion.singleValue" > - and ${criterion.condition} #{criterion.value} - </when> - <when test="criterion.betweenValue" > - and ${criterion.condition} #{criterion.value} and #{criterion.secondValue} - </when> - <when test="criterion.listValue" > - and ${criterion.condition} - <foreach collection="criterion.value" item="listItem" open="(" close=")" separator="," > - #{listItem} - </foreach> - </when> - </choose> - </foreach> - </trim> - </if> - </foreach> - </where> - </sql> - <sql id="Update_By_Example_Where_Clause" > - <where > - <foreach collection="example.oredCriteria" item="criteria" separator="or" > - <if test="criteria.valid" > - <trim prefix="(" suffix=")" prefixOverrides="and" > - <foreach collection="criteria.criteria" item="criterion" > - <choose > - <when test="criterion.noValue" > - and ${criterion.condition} - </when> - <when test="criterion.singleValue" > - and ${criterion.condition} #{criterion.value} - </when> - <when test="criterion.betweenValue" > - and ${criterion.condition} #{criterion.value} and #{criterion.secondValue} - </when> - <when test="criterion.listValue" > - and ${criterion.condition} - <foreach collection="criterion.value" item="listItem" open="(" close=")" separator="," > - #{listItem} - </foreach> - </when> - </choose> - </foreach> - </trim> - </if> - </foreach> - </where> - </sql> - <sql id="Base_Column_List" > - id, parent_id, child_id - </sql> - <select id="selectByExample" resultMap="BaseResultMap" parameterType="com.moral.entity.OrganizationRelationExample" > - select - <if test="distinct" > - distinct - </if> - <include refid="Base_Column_List" /> - from organization_relation - <if test="_parameter != null" > - <include refid="Example_Where_Clause" /> - </if> - <if test="orderByClause != null" > - order by ${orderByClause} - </if> - </select> - <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Integer" > - select - <include refid="Base_Column_List" /> - from organization_relation - where id = #{id,jdbcType=INTEGER} - </select> - <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer" > - delete from organization_relation - where id = #{id,jdbcType=INTEGER} - </delete> - <delete id="deleteByExample" parameterType="com.moral.entity.OrganizationRelationExample" > - delete from organization_relation - <if test="_parameter != null" > - <include refid="Example_Where_Clause" /> - </if> - </delete> - <insert id="insert" parameterType="com.moral.entity.OrganizationRelation" > - insert into organization_relation (id, parent_id, child_id - ) - values (#{id,jdbcType=INTEGER}, #{parentId,jdbcType=INTEGER}, #{childId,jdbcType=INTEGER} - ) - </insert> - <insert id="insertSelective" parameterType="com.moral.entity.OrganizationRelation" > - insert into organization_relation - <trim prefix="(" suffix=")" suffixOverrides="," > - <if test="id != null" > - id, - </if> - <if test="parentId != null" > - parent_id, - </if> - <if test="childId != null" > - child_id, - </if> - </trim> - <trim prefix="values (" suffix=")" suffixOverrides="," > - <if test="id != null" > - #{id,jdbcType=INTEGER}, - </if> - <if test="parentId != null" > - #{parentId,jdbcType=INTEGER}, - </if> - <if test="childId != null" > - #{childId,jdbcType=INTEGER}, - </if> - </trim> - </insert> - <select id="countByExample" parameterType="com.moral.entity.OrganizationRelationExample" resultType="java.lang.Integer" > - select count(*) from organization_relation - <if test="_parameter != null" > - <include refid="Example_Where_Clause" /> - </if> - </select> - <update id="updateByExampleSelective" parameterType="map" > - update organization_relation - <set > - <if test="record.id != null" > - id = #{record.id,jdbcType=INTEGER}, - </if> - <if test="record.parentId != null" > - parent_id = #{record.parentId,jdbcType=INTEGER}, - </if> - <if test="record.childId != null" > - child_id = #{record.childId,jdbcType=INTEGER}, - </if> - </set> - <if test="_parameter != null" > - <include refid="Update_By_Example_Where_Clause" /> - </if> - </update> - <update id="updateByExample" parameterType="map" > - update organization_relation - set id = #{record.id,jdbcType=INTEGER}, - parent_id = #{record.parentId,jdbcType=INTEGER}, - child_id = #{record.childId,jdbcType=INTEGER} - <if test="_parameter != null" > - <include refid="Update_By_Example_Where_Clause" /> - </if> - </update> - <update id="updateByPrimaryKeySelective" parameterType="com.moral.entity.OrganizationRelation" > - update organization_relation - <set > - <if test="parentId != null" > - parent_id = #{parentId,jdbcType=INTEGER}, - </if> - <if test="childId != null" > - child_id = #{childId,jdbcType=INTEGER}, - </if> - </set> - where id = #{id,jdbcType=INTEGER} - </update> - <update id="updateByPrimaryKey" parameterType="com.moral.entity.OrganizationRelation" > - update organization_relation - set parent_id = #{parentId,jdbcType=INTEGER}, - child_id = #{childId,jdbcType=INTEGER} - where id = #{id,jdbcType=INTEGER} - </update> </mapper> \ No newline at end of file diff --git a/src/test/java/com/moral/MybatisConfig.java b/src/test/java/com/moral/MybatisConfig.java new file mode 100644 index 0000000..0ebce67 --- /dev/null +++ b/src/test/java/com/moral/MybatisConfig.java @@ -0,0 +1,23 @@ +package com.moral; + +import java.util.Properties; + +import org.springframework.context.annotation.Bean; +import org.springframework.context.annotation.Configuration; + +import com.github.pagehelper.PageHelper; + +@Configuration +public class MybatisConfig { + @Bean + public PageHelper pageHelper(){ + PageHelper pageHelper = new PageHelper(); + Properties properties = new Properties(); + properties.setProperty("offsetAsPageNum","true"); + properties.setProperty("rowBoundsWithCount","true"); + properties.setProperty("reasonable","true"); + properties.setProperty("dialect","mysql"); //������mysql������������������ + pageHelper.setProperties(properties); + return pageHelper; + } +} \ No newline at end of file -- Gitblit v1.8.0