logService
2024-09-06 16:27:52
vpackage org.linlinjava.litemall.admin.service; import org.apache.shiro.SecurityUtils;
import org.apache.shiro.subject.Subject;
import org.linlinjava.litemall.core.util.IpUtil;
import org.linlinjava.litemall.db.domain.LitemallAdmin;
import org.linlinjava.litemall.db.domain.LitemallLog;
import org.linlinjava.litemall.db.service.LitemallLogService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;
import org.springframework.web.context.request.RequestContextHolder;
import org.springframework.web.context.request.ServletRequestAttributes; import javax.servlet.http.HttpServletRequest; /**
* 这里的日志类型设计成四种（当然开发者需要可以自己扩展）
* 一般日志：用户觉得需要查看的一般操作日志，建议是默认的日志级别
* 安全日志：用户安全相关的操作日志，例如登录、删除管理员
* 订单日志：用户交易相关的操作日志，例如订单发货、退款
* 其他日志：如果以上三种不合适，可以选择其他日志，建议是优先级最低的日志级别
* <p>
* 当然可能很多操作是不需要记录到数据库的，例如编辑商品、编辑广告品之类。
*/
@Component
public class LogHelper {
public static final Integer LOG_TYPE_GENERAL = 0;
public static final Integer LOG_TYPE_AUTH = 1;
public static final Integer LOG_TYPE_ORDER = 2;
public static final Integer LOG_TYPE_OTHER = 3; @Autowired
private LitemallLogService logService; public void logGeneralSucceed(String action) {
logAdmin(LOG_TYPE_GENERAL, action, true, "", "");
} public void logGeneralSucceed(String action, String result) {
logAdmin(LOG_TYPE_GENERAL, action, true, result, "");
} public void logGeneralFail(String action, String error) {
logAdmin(LOG_TYPE_GENERAL, action, false, error, "");
} public void logAuthSucceed(String action) {
logAdmin(LOG_TYPE_AUTH, action, true, "", "");
} public void logAuthSucceed(String action, String result) {
logAdmin(LOG_TYPE_AUTH, action, true, result, "");
} public void logAuthFail(String action, String error) {
logAdmin(LOG_TYPE_AUTH, action, false, error, "");
} public void logOrderSucceed(String action) {
logAdmin(LOG_TYPE_ORDER, action, true, "", "");
} public void logOrderSucceed(String action, String result) {
logAdmin(LOG_TYPE_ORDER, action, true, result, "");
} public void logOrderFail(String action, String error) {
logAdmin(LOG_TYPE_ORDER, action, false, error, "");
} public void logOtherSucceed(String action) {
logAdmin(LOG_TYPE_OTHER, action, true, "", "");
} public void logOtherSucceed(String action, String result) {
logAdmin(LOG_TYPE_OTHER, action, true, result, "");
} public void logOtherFail(String action, String error) {
logAdmin(LOG_TYPE_OTHER, action, false, error, "");
} public void logAdmin(Integer type, String action, Boolean succeed, String result, String comment) {
LitemallLog log = new LitemallLog(); Subject currentUser = SecurityUtils.getSubject();
if (currentUser != null) {
LitemallAdmin admin = (LitemallAdmin) currentUser.getPrincipal();
if (admin != null) {
log.setAdmin(admin.getUsername());
} else {
log.setAdmin("匿名用户");
}
} else {
log.setAdmin("匿名用户");
} HttpServletRequest request =
((ServletRequestAttributes) RequestContextHolder.getRequestAttributes()).getRequest();
if (request != null) {
log.setIp(IpUtil.getIpAddr(request));
} log.setType(type);
log.setAction(action);
log.setStatus(succeed);
log.setResult(result);
log.setComment(comment);
logService.add(log);
} }
package org.linlinjava.litemall.db.service; import com.github.pagehelper.PageHelper;
import org.linlinjava.litemall.db.dao.LitemallLogMapper;
import org.linlinjava.litemall.db.domain.LitemallAd;
import org.linlinjava.litemall.db.domain.LitemallLog;
import org.linlinjava.litemall.db.domain.LitemallLogExample;
import org.springframework.stereotype.Service;
import org.springframework.util.StringUtils; import javax.annotation.Resource;
import java.time.LocalDateTime;
import java.util.List; @Service
public class LitemallLogService {
@Resource
private LitemallLogMapper logMapper; public void deleteById(Integer id) {
logMapper.logicalDeleteByPrimaryKey(id);
} public void add(LitemallLog log) {
log.setAddTime(LocalDateTime.now());
log.setUpdateTime(LocalDateTime.now());
logMapper.insertSelective(log);
} public List<LitemallLog> querySelective(String name, Integer page, Integer size, String sort, String order) {
LitemallLogExample example = new LitemallLogExample();
LitemallLogExample.Criteria criteria = example.createCriteria(); if (!StringUtils.isEmpty(name)) {
criteria.andAdminLike("%" + name + "%");
}
criteria.andDeletedEqualTo(false); if (!StringUtils.isEmpty(sort) && !StringUtils.isEmpty(order)) {
example.setOrderByClause(sort + " " + order);
} PageHelper.startPage(page, size);
return logMapper.selectByExample(example);
}
}
package org.linlinjava.litemall.db.dao; import java.util.List;
import org.apache.ibatis.annotations.Param;
import org.linlinjava.litemall.db.domain.LitemallLog;
import org.linlinjava.litemall.db.domain.LitemallLogExample; public interface LitemallLogMapper {
/**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
long countByExample(LitemallLogExample example); /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
int deleteByExample(LitemallLogExample example); /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
int deleteByPrimaryKey(Integer id); /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
int insert(LitemallLog record); /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
int insertSelective(LitemallLog record); /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
LitemallLog selectOneByExample(LitemallLogExample example); /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
LitemallLog selectOneByExampleSelective(@Param("example") LitemallLogExample example, @Param("selective") LitemallLog.Column ... selective); /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
List<LitemallLog> selectByExampleSelective(@Param("example") LitemallLogExample example, @Param("selective") LitemallLog.Column ... selective); /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
List<LitemallLog> selectByExample(LitemallLogExample example); /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
LitemallLog selectByPrimaryKeySelective(@Param("id") Integer id, @Param("selective") LitemallLog.Column ... selective); /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
LitemallLog selectByPrimaryKey(Integer id); /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
LitemallLog selectByPrimaryKeyWithLogicalDelete(@Param("id") Integer id, @Param("andLogicalDeleted") boolean andLogicalDeleted); /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
int updateByExampleSelective(@Param("record") LitemallLog record, @Param("example") LitemallLogExample example); /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
int updateByExample(@Param("record") LitemallLog record, @Param("example") LitemallLogExample example); /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
int updateByPrimaryKeySelective(LitemallLog record); /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
int updateByPrimaryKey(LitemallLog record); /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
int logicalDeleteByExample(@Param("example") LitemallLogExample example); /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
int logicalDeleteByPrimaryKey(Integer id);
}
package org.linlinjava.litemall.db.domain; import java.time.LocalDateTime;
import java.util.ArrayList;
import java.util.Arrays; public class LitemallLog {
/**
* This field was generated by MyBatis Generator.
* This field corresponds to the database table litemall_log
*
* @mbg.generated
*/
public static final Boolean IS_DELETED = Deleted.IS_DELETED.value(); /**
* This field was generated by MyBatis Generator.
* This field corresponds to the database table litemall_log
*
* @mbg.generated
*/
public static final Boolean NOT_DELETED = Deleted.NOT_DELETED.value(); /**
*
* This field was generated by MyBatis Generator.
* This field corresponds to the database column litemall_log.id
*
* @mbg.generated
*/
private Integer id; /**
*
* This field was generated by MyBatis Generator.
* This field corresponds to the database column litemall_log.admin
*
* @mbg.generated
*/
private String admin; /**
*
* This field was generated by MyBatis Generator.
* This field corresponds to the database column litemall_log.ip
*
* @mbg.generated
*/
private String ip; /**
*
* This field was generated by MyBatis Generator.
* This field corresponds to the database column litemall_log.type
*
* @mbg.generated
*/
private Integer type; /**
*
* This field was generated by MyBatis Generator.
* This field corresponds to the database column litemall_log.action
*
* @mbg.generated
*/
private String action; /**
*
* This field was generated by MyBatis Generator.
* This field corresponds to the database column litemall_log.status
*
* @mbg.generated
*/
private Boolean status; /**
*
* This field was generated by MyBatis Generator.
* This field corresponds to the database column litemall_log.result
*
* @mbg.generated
*/
private String result; /**
*
* This field was generated by MyBatis Generator.
* This field corresponds to the database column litemall_log.comment
*
* @mbg.generated
*/
private String comment; /**
*
* This field was generated by MyBatis Generator.
* This field corresponds to the database column litemall_log.add_time
*
* @mbg.generated
*/
private LocalDateTime addTime; /**
*
* This field was generated by MyBatis Generator.
* This field corresponds to the database column litemall_log.update_time
*
* @mbg.generated
*/
private LocalDateTime updateTime; /**
*
* This field was generated by MyBatis Generator.
* This field corresponds to the database column litemall_log.deleted
*
* @mbg.generated
*/
private Boolean deleted; /**
* This method was generated by MyBatis Generator.
* This method returns the value of the database column litemall_log.id
*
* @return the value of litemall_log.id
*
* @mbg.generated
*/
public Integer getId() {
return id;
} /**
* This method was generated by MyBatis Generator.
* This method sets the value of the database column litemall_log.id
*
* @param id the value for litemall_log.id
*
* @mbg.generated
*/
public void setId(Integer id) {
this.id = id;
} /**
* This method was generated by MyBatis Generator.
* This method returns the value of the database column litemall_log.admin
*
* @return the value of litemall_log.admin
*
* @mbg.generated
*/
public String getAdmin() {
return admin;
} /**
* This method was generated by MyBatis Generator.
* This method sets the value of the database column litemall_log.admin
*
* @param admin the value for litemall_log.admin
*
* @mbg.generated
*/
public void setAdmin(String admin) {
this.admin = admin;
} /**
* This method was generated by MyBatis Generator.
* This method returns the value of the database column litemall_log.ip
*
* @return the value of litemall_log.ip
*
* @mbg.generated
*/
public String getIp() {
return ip;
} /**
* This method was generated by MyBatis Generator.
* This method sets the value of the database column litemall_log.ip
*
* @param ip the value for litemall_log.ip
*
* @mbg.generated
*/
public void setIp(String ip) {
this.ip = ip;
} /**
* This method was generated by MyBatis Generator.
* This method returns the value of the database column litemall_log.type
*
* @return the value of litemall_log.type
*
* @mbg.generated
*/
public Integer getType() {
return type;
} /**
* This method was generated by MyBatis Generator.
* This method sets the value of the database column litemall_log.type
*
* @param type the value for litemall_log.type
*
* @mbg.generated
*/
public void setType(Integer type) {
this.type = type;
} /**
* This method was generated by MyBatis Generator.
* This method returns the value of the database column litemall_log.action
*
* @return the value of litemall_log.action
*
* @mbg.generated
*/
public String getAction() {
return action;
} /**
* This method was generated by MyBatis Generator.
* This method sets the value of the database column litemall_log.action
*
* @param action the value for litemall_log.action
*
* @mbg.generated
*/
public void setAction(String action) {
this.action = action;
} /**
* This method was generated by MyBatis Generator.
* This method returns the value of the database column litemall_log.status
*
* @return the value of litemall_log.status
*
* @mbg.generated
*/
public Boolean getStatus() {
return status;
} /**
* This method was generated by MyBatis Generator.
* This method sets the value of the database column litemall_log.status
*
* @param status the value for litemall_log.status
*
* @mbg.generated
*/
public void setStatus(Boolean status) {
this.status = status;
} /**
* This method was generated by MyBatis Generator.
* This method returns the value of the database column litemall_log.result
*
* @return the value of litemall_log.result
*
* @mbg.generated
*/
public String getResult() {
return result;
} /**
* This method was generated by MyBatis Generator.
* This method sets the value of the database column litemall_log.result
*
* @param result the value for litemall_log.result
*
* @mbg.generated
*/
public void setResult(String result) {
this.result = result;
} /**
* This method was generated by MyBatis Generator.
* This method returns the value of the database column litemall_log.comment
*
* @return the value of litemall_log.comment
*
* @mbg.generated
*/
public String getComment() {
return comment;
} /**
* This method was generated by MyBatis Generator.
* This method sets the value of the database column litemall_log.comment
*
* @param comment the value for litemall_log.comment
*
* @mbg.generated
*/
public void setComment(String comment) {
this.comment = comment;
} /**
* This method was generated by MyBatis Generator.
* This method returns the value of the database column litemall_log.add_time
*
* @return the value of litemall_log.add_time
*
* @mbg.generated
*/
public LocalDateTime getAddTime() {
return addTime;
} /**
* This method was generated by MyBatis Generator.
* This method sets the value of the database column litemall_log.add_time
*
* @param addTime the value for litemall_log.add_time
*
* @mbg.generated
*/
public void setAddTime(LocalDateTime addTime) {
this.addTime = addTime;
} /**
* This method was generated by MyBatis Generator.
* This method returns the value of the database column litemall_log.update_time
*
* @return the value of litemall_log.update_time
*
* @mbg.generated
*/
public LocalDateTime getUpdateTime() {
return updateTime;
} /**
* This method was generated by MyBatis Generator.
* This method sets the value of the database column litemall_log.update_time
*
* @param updateTime the value for litemall_log.update_time
*
* @mbg.generated
*/
public void setUpdateTime(LocalDateTime updateTime) {
this.updateTime = updateTime;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public void andLogicalDeleted(boolean deleted) {
setDeleted(deleted ? Deleted.IS_DELETED.value() : Deleted.NOT_DELETED.value());
} /**
* This method was generated by MyBatis Generator.
* This method returns the value of the database column litemall_log.deleted
*
* @return the value of litemall_log.deleted
*
* @mbg.generated
*/
public Boolean getDeleted() {
return deleted;
} /**
* This method was generated by MyBatis Generator.
* This method sets the value of the database column litemall_log.deleted
*
* @param deleted the value for litemall_log.deleted
*
* @mbg.generated
*/
public void setDeleted(Boolean deleted) {
this.deleted = deleted;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
@Override
public String toString() {
StringBuilder sb = new StringBuilder();
sb.append(getClass().getSimpleName());
sb.append(" [");
sb.append("Hash = ").append(hashCode());
sb.append(", IS_DELETED=").append(IS_DELETED);
sb.append(", NOT_DELETED=").append(NOT_DELETED);
sb.append(", id=").append(id);
sb.append(", admin=").append(admin);
sb.append(", ip=").append(ip);
sb.append(", type=").append(type);
sb.append(", action=").append(action);
sb.append(", status=").append(status);
sb.append(", result=").append(result);
sb.append(", comment=").append(comment);
sb.append(", addTime=").append(addTime);
sb.append(", updateTime=").append(updateTime);
sb.append(", deleted=").append(deleted);
sb.append("]");
return sb.toString();
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
@Override
public boolean equals(Object that) {
if (this == that) {
return true;
}
if (that == null) {
return false;
}
if (getClass() != that.getClass()) {
return false;
}
LitemallLog other = (LitemallLog) that;
return (this.getId() == null ? other.getId() == null : this.getId().equals(other.getId()))
&& (this.getAdmin() == null ? other.getAdmin() == null : this.getAdmin().equals(other.getAdmin()))
&& (this.getIp() == null ? other.getIp() == null : this.getIp().equals(other.getIp()))
&& (this.getType() == null ? other.getType() == null : this.getType().equals(other.getType()))
&& (this.getAction() == null ? other.getAction() == null : this.getAction().equals(other.getAction()))
&& (this.getStatus() == null ? other.getStatus() == null : this.getStatus().equals(other.getStatus()))
&& (this.getResult() == null ? other.getResult() == null : this.getResult().equals(other.getResult()))
&& (this.getComment() == null ? other.getComment() == null : this.getComment().equals(other.getComment()))
&& (this.getAddTime() == null ? other.getAddTime() == null : this.getAddTime().equals(other.getAddTime()))
&& (this.getUpdateTime() == null ? other.getUpdateTime() == null : this.getUpdateTime().equals(other.getUpdateTime()))
&& (this.getDeleted() == null ? other.getDeleted() == null : this.getDeleted().equals(other.getDeleted()));
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
@Override
public int hashCode() {
final int prime = 31;
int result = 1;
result = prime * result + ((getId() == null) ? 0 : getId().hashCode());
result = prime * result + ((getAdmin() == null) ? 0 : getAdmin().hashCode());
result = prime * result + ((getIp() == null) ? 0 : getIp().hashCode());
result = prime * result + ((getType() == null) ? 0 : getType().hashCode());
result = prime * result + ((getAction() == null) ? 0 : getAction().hashCode());
result = prime * result + ((getStatus() == null) ? 0 : getStatus().hashCode());
result = prime * result + ((getResult() == null) ? 0 : getResult().hashCode());
result = prime * result + ((getComment() == null) ? 0 : getComment().hashCode());
result = prime * result + ((getAddTime() == null) ? 0 : getAddTime().hashCode());
result = prime * result + ((getUpdateTime() == null) ? 0 : getUpdateTime().hashCode());
result = prime * result + ((getDeleted() == null) ? 0 : getDeleted().hashCode());
return result;
} /**
* This enum was generated by MyBatis Generator.
* This enum corresponds to the database table litemall_log
*
* @mbg.generated
*/
public enum Deleted {
NOT_DELETED(new Boolean("0"), "未删除"),
IS_DELETED(new Boolean("1"), "已删除"); /**
* This field was generated by MyBatis Generator.
* This field corresponds to the database table litemall_log
*
* @mbg.generated
*/
private final Boolean value; /**
* This field was generated by MyBatis Generator.
* This field corresponds to the database table litemall_log
*
* @mbg.generated
*/
private final String name; /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
Deleted(Boolean value, String name) {
this.value = value;
this.name = name;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Boolean getValue() {
return this.value;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Boolean value() {
return this.value;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public String getName() {
return this.name;
}
} /**
* This enum was generated by MyBatis Generator.
* This enum corresponds to the database table litemall_log
*
* @mbg.generated
*/
public enum Column {
id("id", "id", "INTEGER", false),
admin("admin", "admin", "VARCHAR", true),
ip("ip", "ip", "VARCHAR", false),
type("type", "type", "INTEGER", true),
action("action", "action", "VARCHAR", true),
status("status", "status", "BIT", true),
result("result", "result", "VARCHAR", true),
comment("comment", "comment", "VARCHAR", true),
addTime("add_time", "addTime", "TIMESTAMP", false),
updateTime("update_time", "updateTime", "TIMESTAMP", false),
deleted("deleted", "deleted", "BIT", false); /**
* This field was generated by MyBatis Generator.
* This field corresponds to the database table litemall_log
*
* @mbg.generated
*/
private static final String BEGINNING_DELIMITER = "`"; /**
* This field was generated by MyBatis Generator.
* This field corresponds to the database table litemall_log
*
* @mbg.generated
*/
private static final String ENDING_DELIMITER = "`"; /**
* This field was generated by MyBatis Generator.
* This field corresponds to the database table litemall_log
*
* @mbg.generated
*/
private final String column; /**
* This field was generated by MyBatis Generator.
* This field corresponds to the database table litemall_log
*
* @mbg.generated
*/
private final boolean isColumnNameDelimited; /**
* This field was generated by MyBatis Generator.
* This field corresponds to the database table litemall_log
*
* @mbg.generated
*/
private final String javaProperty; /**
* This field was generated by MyBatis Generator.
* This field corresponds to the database table litemall_log
*
* @mbg.generated
*/
private final String jdbcType; /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public String value() {
return this.column;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public String getValue() {
return this.column;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public String getJavaProperty() {
return this.javaProperty;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public String getJdbcType() {
return this.jdbcType;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
Column(String column, String javaProperty, String jdbcType, boolean isColumnNameDelimited) {
this.column = column;
this.javaProperty = javaProperty;
this.jdbcType = jdbcType;
this.isColumnNameDelimited = isColumnNameDelimited;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public String desc() {
return this.getEscapedColumnName() + " DESC";
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public String asc() {
return this.getEscapedColumnName() + " ASC";
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public static Column[] excludes(Column ... excludes) {
ArrayList<Column> columns = new ArrayList<>(Arrays.asList(Column.values()));
if (excludes != null && excludes.length > 0) {
columns.removeAll(new ArrayList<>(Arrays.asList(excludes)));
}
return columns.toArray(new Column[]{});
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public String getEscapedColumnName() {
if (this.isColumnNameDelimited) {
return new StringBuilder().append(BEGINNING_DELIMITER).append(this.column).append(ENDING_DELIMITER).toString();
} else {
return this.column;
}
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public String getAliasedEscapedColumnName() {
return this.getEscapedColumnName();
}
}
}
package org.linlinjava.litemall.db.domain; import java.time.LocalDateTime;
import java.util.ArrayList;
import java.util.List; public class LitemallLogExample {
/**
* This field was generated by MyBatis Generator.
* This field corresponds to the database table litemall_log
*
* @mbg.generated
*/
protected String orderByClause; /**
* This field was generated by MyBatis Generator.
* This field corresponds to the database table litemall_log
*
* @mbg.generated
*/
protected boolean distinct; /**
* This field was generated by MyBatis Generator.
* This field corresponds to the database table litemall_log
*
* @mbg.generated
*/
protected List<Criteria> oredCriteria; /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public LitemallLogExample() {
oredCriteria = new ArrayList<Criteria>();
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public void setOrderByClause(String orderByClause) {
this.orderByClause = orderByClause;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public String getOrderByClause() {
return orderByClause;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public void setDistinct(boolean distinct) {
this.distinct = distinct;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public boolean isDistinct() {
return distinct;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public List<Criteria> getOredCriteria() {
return oredCriteria;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public void or(Criteria criteria) {
oredCriteria.add(criteria);
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
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 litemall_log
*
* @mbg.generated
*/
public LitemallLogExample orderBy(String orderByClause) {
this.setOrderByClause(orderByClause);
return this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public LitemallLogExample orderBy(String ... orderByClauses) {
StringBuffer sb = new StringBuffer();
for (int i = 0; i < orderByClauses.length; i++) {
sb.append(orderByClauses[i]);
if (i < orderByClauses.length - 1) {
sb.append(" , ");
}
}
this.setOrderByClause(sb.toString());
return this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
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 litemall_log
*
* @mbg.generated
*/
protected Criteria createCriteriaInternal() {
Criteria criteria = new Criteria(this);
return criteria;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public void clear() {
oredCriteria.clear();
orderByClause = null;
distinct = false;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public static Criteria newAndCreateCriteria() {
LitemallLogExample example = new LitemallLogExample();
return example.createCriteria();
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public LitemallLogExample when(boolean condition, IExampleWhen then) {
if (condition) {
then.example(this);
}
return this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public LitemallLogExample when(boolean condition, IExampleWhen then, IExampleWhen otherwise) {
if (condition) {
then.example(this);
} else {
otherwise.example(this);
}
return this;
} /**
* This class was generated by MyBatis Generator.
* This class corresponds to the database table litemall_log
*
* @mbg.generated
*/
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;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andIdEqualToColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("id = ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andIdNotEqualTo(Integer value) {
addCriterion("id <>", value, "id");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andIdNotEqualToColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("id <> ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andIdGreaterThan(Integer value) {
addCriterion("id >", value, "id");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andIdGreaterThanColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("id > ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andIdGreaterThanOrEqualTo(Integer value) {
addCriterion("id >=", value, "id");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andIdGreaterThanOrEqualToColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("id >= ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andIdLessThan(Integer value) {
addCriterion("id <", value, "id");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andIdLessThanColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("id < ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andIdLessThanOrEqualTo(Integer value) {
addCriterion("id <=", value, "id");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andIdLessThanOrEqualToColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("id <= ").append(column.getEscapedColumnName()).toString());
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 andAdminIsNull() {
addCriterion("`admin` is null");
return (Criteria) this;
} public Criteria andAdminIsNotNull() {
addCriterion("`admin` is not null");
return (Criteria) this;
} public Criteria andAdminEqualTo(String value) {
addCriterion("`admin` =", value, "admin");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andAdminEqualToColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("`admin` = ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andAdminNotEqualTo(String value) {
addCriterion("`admin` <>", value, "admin");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andAdminNotEqualToColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("`admin` <> ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andAdminGreaterThan(String value) {
addCriterion("`admin` >", value, "admin");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andAdminGreaterThanColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("`admin` > ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andAdminGreaterThanOrEqualTo(String value) {
addCriterion("`admin` >=", value, "admin");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andAdminGreaterThanOrEqualToColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("`admin` >= ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andAdminLessThan(String value) {
addCriterion("`admin` <", value, "admin");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andAdminLessThanColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("`admin` < ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andAdminLessThanOrEqualTo(String value) {
addCriterion("`admin` <=", value, "admin");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andAdminLessThanOrEqualToColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("`admin` <= ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andAdminLike(String value) {
addCriterion("`admin` like", value, "admin");
return (Criteria) this;
} public Criteria andAdminNotLike(String value) {
addCriterion("`admin` not like", value, "admin");
return (Criteria) this;
} public Criteria andAdminIn(List<String> values) {
addCriterion("`admin` in", values, "admin");
return (Criteria) this;
} public Criteria andAdminNotIn(List<String> values) {
addCriterion("`admin` not in", values, "admin");
return (Criteria) this;
} public Criteria andAdminBetween(String value1, String value2) {
addCriterion("`admin` between", value1, value2, "admin");
return (Criteria) this;
} public Criteria andAdminNotBetween(String value1, String value2) {
addCriterion("`admin` not between", value1, value2, "admin");
return (Criteria) this;
} public Criteria andIpIsNull() {
addCriterion("ip is null");
return (Criteria) this;
} public Criteria andIpIsNotNull() {
addCriterion("ip is not null");
return (Criteria) this;
} public Criteria andIpEqualTo(String value) {
addCriterion("ip =", value, "ip");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andIpEqualToColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("ip = ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andIpNotEqualTo(String value) {
addCriterion("ip <>", value, "ip");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andIpNotEqualToColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("ip <> ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andIpGreaterThan(String value) {
addCriterion("ip >", value, "ip");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andIpGreaterThanColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("ip > ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andIpGreaterThanOrEqualTo(String value) {
addCriterion("ip >=", value, "ip");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andIpGreaterThanOrEqualToColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("ip >= ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andIpLessThan(String value) {
addCriterion("ip <", value, "ip");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andIpLessThanColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("ip < ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andIpLessThanOrEqualTo(String value) {
addCriterion("ip <=", value, "ip");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andIpLessThanOrEqualToColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("ip <= ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andIpLike(String value) {
addCriterion("ip like", value, "ip");
return (Criteria) this;
} public Criteria andIpNotLike(String value) {
addCriterion("ip not like", value, "ip");
return (Criteria) this;
} public Criteria andIpIn(List<String> values) {
addCriterion("ip in", values, "ip");
return (Criteria) this;
} public Criteria andIpNotIn(List<String> values) {
addCriterion("ip not in", values, "ip");
return (Criteria) this;
} public Criteria andIpBetween(String value1, String value2) {
addCriterion("ip between", value1, value2, "ip");
return (Criteria) this;
} public Criteria andIpNotBetween(String value1, String value2) {
addCriterion("ip not between", value1, value2, "ip");
return (Criteria) this;
} public Criteria andTypeIsNull() {
addCriterion("`type` is null");
return (Criteria) this;
} public Criteria andTypeIsNotNull() {
addCriterion("`type` is not null");
return (Criteria) this;
} public Criteria andTypeEqualTo(Integer value) {
addCriterion("`type` =", value, "type");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andTypeEqualToColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("`type` = ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andTypeNotEqualTo(Integer value) {
addCriterion("`type` <>", value, "type");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andTypeNotEqualToColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("`type` <> ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andTypeGreaterThan(Integer value) {
addCriterion("`type` >", value, "type");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andTypeGreaterThanColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("`type` > ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andTypeGreaterThanOrEqualTo(Integer value) {
addCriterion("`type` >=", value, "type");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andTypeGreaterThanOrEqualToColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("`type` >= ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andTypeLessThan(Integer value) {
addCriterion("`type` <", value, "type");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andTypeLessThanColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("`type` < ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andTypeLessThanOrEqualTo(Integer value) {
addCriterion("`type` <=", value, "type");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andTypeLessThanOrEqualToColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("`type` <= ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andTypeIn(List<Integer> values) {
addCriterion("`type` in", values, "type");
return (Criteria) this;
} public Criteria andTypeNotIn(List<Integer> values) {
addCriterion("`type` not in", values, "type");
return (Criteria) this;
} public Criteria andTypeBetween(Integer value1, Integer value2) {
addCriterion("`type` between", value1, value2, "type");
return (Criteria) this;
} public Criteria andTypeNotBetween(Integer value1, Integer value2) {
addCriterion("`type` not between", value1, value2, "type");
return (Criteria) this;
} public Criteria andActionIsNull() {
addCriterion("`action` is null");
return (Criteria) this;
} public Criteria andActionIsNotNull() {
addCriterion("`action` is not null");
return (Criteria) this;
} public Criteria andActionEqualTo(String value) {
addCriterion("`action` =", value, "action");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andActionEqualToColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("`action` = ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andActionNotEqualTo(String value) {
addCriterion("`action` <>", value, "action");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andActionNotEqualToColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("`action` <> ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andActionGreaterThan(String value) {
addCriterion("`action` >", value, "action");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andActionGreaterThanColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("`action` > ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andActionGreaterThanOrEqualTo(String value) {
addCriterion("`action` >=", value, "action");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andActionGreaterThanOrEqualToColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("`action` >= ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andActionLessThan(String value) {
addCriterion("`action` <", value, "action");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andActionLessThanColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("`action` < ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andActionLessThanOrEqualTo(String value) {
addCriterion("`action` <=", value, "action");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andActionLessThanOrEqualToColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("`action` <= ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andActionLike(String value) {
addCriterion("`action` like", value, "action");
return (Criteria) this;
} public Criteria andActionNotLike(String value) {
addCriterion("`action` not like", value, "action");
return (Criteria) this;
} public Criteria andActionIn(List<String> values) {
addCriterion("`action` in", values, "action");
return (Criteria) this;
} public Criteria andActionNotIn(List<String> values) {
addCriterion("`action` not in", values, "action");
return (Criteria) this;
} public Criteria andActionBetween(String value1, String value2) {
addCriterion("`action` between", value1, value2, "action");
return (Criteria) this;
} public Criteria andActionNotBetween(String value1, String value2) {
addCriterion("`action` not between", value1, value2, "action");
return (Criteria) this;
} public Criteria andStatusIsNull() {
addCriterion("`status` is null");
return (Criteria) this;
} public Criteria andStatusIsNotNull() {
addCriterion("`status` is not null");
return (Criteria) this;
} public Criteria andStatusEqualTo(Boolean value) {
addCriterion("`status` =", value, "status");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andStatusEqualToColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("`status` = ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andStatusNotEqualTo(Boolean value) {
addCriterion("`status` <>", value, "status");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andStatusNotEqualToColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("`status` <> ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andStatusGreaterThan(Boolean value) {
addCriterion("`status` >", value, "status");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andStatusGreaterThanColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("`status` > ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andStatusGreaterThanOrEqualTo(Boolean value) {
addCriterion("`status` >=", value, "status");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andStatusGreaterThanOrEqualToColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("`status` >= ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andStatusLessThan(Boolean value) {
addCriterion("`status` <", value, "status");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andStatusLessThanColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("`status` < ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andStatusLessThanOrEqualTo(Boolean value) {
addCriterion("`status` <=", value, "status");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andStatusLessThanOrEqualToColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("`status` <= ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andStatusIn(List<Boolean> values) {
addCriterion("`status` in", values, "status");
return (Criteria) this;
} public Criteria andStatusNotIn(List<Boolean> values) {
addCriterion("`status` not in", values, "status");
return (Criteria) this;
} public Criteria andStatusBetween(Boolean value1, Boolean value2) {
addCriterion("`status` between", value1, value2, "status");
return (Criteria) this;
} public Criteria andStatusNotBetween(Boolean value1, Boolean value2) {
addCriterion("`status` not between", value1, value2, "status");
return (Criteria) this;
} public Criteria andResultIsNull() {
addCriterion("`result` is null");
return (Criteria) this;
} public Criteria andResultIsNotNull() {
addCriterion("`result` is not null");
return (Criteria) this;
} public Criteria andResultEqualTo(String value) {
addCriterion("`result` =", value, "result");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andResultEqualToColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("`result` = ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andResultNotEqualTo(String value) {
addCriterion("`result` <>", value, "result");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andResultNotEqualToColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("`result` <> ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andResultGreaterThan(String value) {
addCriterion("`result` >", value, "result");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andResultGreaterThanColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("`result` > ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andResultGreaterThanOrEqualTo(String value) {
addCriterion("`result` >=", value, "result");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andResultGreaterThanOrEqualToColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("`result` >= ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andResultLessThan(String value) {
addCriterion("`result` <", value, "result");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andResultLessThanColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("`result` < ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andResultLessThanOrEqualTo(String value) {
addCriterion("`result` <=", value, "result");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andResultLessThanOrEqualToColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("`result` <= ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andResultLike(String value) {
addCriterion("`result` like", value, "result");
return (Criteria) this;
} public Criteria andResultNotLike(String value) {
addCriterion("`result` not like", value, "result");
return (Criteria) this;
} public Criteria andResultIn(List<String> values) {
addCriterion("`result` in", values, "result");
return (Criteria) this;
} public Criteria andResultNotIn(List<String> values) {
addCriterion("`result` not in", values, "result");
return (Criteria) this;
} public Criteria andResultBetween(String value1, String value2) {
addCriterion("`result` between", value1, value2, "result");
return (Criteria) this;
} public Criteria andResultNotBetween(String value1, String value2) {
addCriterion("`result` not between", value1, value2, "result");
return (Criteria) this;
} public Criteria andCommentIsNull() {
addCriterion("`comment` is null");
return (Criteria) this;
} public Criteria andCommentIsNotNull() {
addCriterion("`comment` is not null");
return (Criteria) this;
} public Criteria andCommentEqualTo(String value) {
addCriterion("`comment` =", value, "comment");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andCommentEqualToColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("`comment` = ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andCommentNotEqualTo(String value) {
addCriterion("`comment` <>", value, "comment");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andCommentNotEqualToColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("`comment` <> ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andCommentGreaterThan(String value) {
addCriterion("`comment` >", value, "comment");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andCommentGreaterThanColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("`comment` > ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andCommentGreaterThanOrEqualTo(String value) {
addCriterion("`comment` >=", value, "comment");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andCommentGreaterThanOrEqualToColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("`comment` >= ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andCommentLessThan(String value) {
addCriterion("`comment` <", value, "comment");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andCommentLessThanColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("`comment` < ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andCommentLessThanOrEqualTo(String value) {
addCriterion("`comment` <=", value, "comment");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andCommentLessThanOrEqualToColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("`comment` <= ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andCommentLike(String value) {
addCriterion("`comment` like", value, "comment");
return (Criteria) this;
} public Criteria andCommentNotLike(String value) {
addCriterion("`comment` not like", value, "comment");
return (Criteria) this;
} public Criteria andCommentIn(List<String> values) {
addCriterion("`comment` in", values, "comment");
return (Criteria) this;
} public Criteria andCommentNotIn(List<String> values) {
addCriterion("`comment` not in", values, "comment");
return (Criteria) this;
} public Criteria andCommentBetween(String value1, String value2) {
addCriterion("`comment` between", value1, value2, "comment");
return (Criteria) this;
} public Criteria andCommentNotBetween(String value1, String value2) {
addCriterion("`comment` not between", value1, value2, "comment");
return (Criteria) this;
} public Criteria andAddTimeIsNull() {
addCriterion("add_time is null");
return (Criteria) this;
} public Criteria andAddTimeIsNotNull() {
addCriterion("add_time is not null");
return (Criteria) this;
} public Criteria andAddTimeEqualTo(LocalDateTime value) {
addCriterion("add_time =", value, "addTime");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andAddTimeEqualToColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("add_time = ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andAddTimeNotEqualTo(LocalDateTime value) {
addCriterion("add_time <>", value, "addTime");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andAddTimeNotEqualToColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("add_time <> ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andAddTimeGreaterThan(LocalDateTime value) {
addCriterion("add_time >", value, "addTime");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andAddTimeGreaterThanColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("add_time > ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andAddTimeGreaterThanOrEqualTo(LocalDateTime value) {
addCriterion("add_time >=", value, "addTime");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andAddTimeGreaterThanOrEqualToColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("add_time >= ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andAddTimeLessThan(LocalDateTime value) {
addCriterion("add_time <", value, "addTime");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andAddTimeLessThanColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("add_time < ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andAddTimeLessThanOrEqualTo(LocalDateTime value) {
addCriterion("add_time <=", value, "addTime");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andAddTimeLessThanOrEqualToColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("add_time <= ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andAddTimeIn(List<LocalDateTime> values) {
addCriterion("add_time in", values, "addTime");
return (Criteria) this;
} public Criteria andAddTimeNotIn(List<LocalDateTime> values) {
addCriterion("add_time not in", values, "addTime");
return (Criteria) this;
} public Criteria andAddTimeBetween(LocalDateTime value1, LocalDateTime value2) {
addCriterion("add_time between", value1, value2, "addTime");
return (Criteria) this;
} public Criteria andAddTimeNotBetween(LocalDateTime value1, LocalDateTime value2) {
addCriterion("add_time not between", value1, value2, "addTime");
return (Criteria) this;
} public Criteria andUpdateTimeIsNull() {
addCriterion("update_time is null");
return (Criteria) this;
} public Criteria andUpdateTimeIsNotNull() {
addCriterion("update_time is not null");
return (Criteria) this;
} public Criteria andUpdateTimeEqualTo(LocalDateTime value) {
addCriterion("update_time =", value, "updateTime");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andUpdateTimeEqualToColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("update_time = ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andUpdateTimeNotEqualTo(LocalDateTime value) {
addCriterion("update_time <>", value, "updateTime");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andUpdateTimeNotEqualToColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("update_time <> ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andUpdateTimeGreaterThan(LocalDateTime value) {
addCriterion("update_time >", value, "updateTime");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andUpdateTimeGreaterThanColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("update_time > ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andUpdateTimeGreaterThanOrEqualTo(LocalDateTime value) {
addCriterion("update_time >=", value, "updateTime");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andUpdateTimeGreaterThanOrEqualToColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("update_time >= ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andUpdateTimeLessThan(LocalDateTime value) {
addCriterion("update_time <", value, "updateTime");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andUpdateTimeLessThanColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("update_time < ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andUpdateTimeLessThanOrEqualTo(LocalDateTime value) {
addCriterion("update_time <=", value, "updateTime");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andUpdateTimeLessThanOrEqualToColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("update_time <= ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andUpdateTimeIn(List<LocalDateTime> values) {
addCriterion("update_time in", values, "updateTime");
return (Criteria) this;
} public Criteria andUpdateTimeNotIn(List<LocalDateTime> values) {
addCriterion("update_time not in", values, "updateTime");
return (Criteria) this;
} public Criteria andUpdateTimeBetween(LocalDateTime value1, LocalDateTime value2) {
addCriterion("update_time between", value1, value2, "updateTime");
return (Criteria) this;
} public Criteria andUpdateTimeNotBetween(LocalDateTime value1, LocalDateTime value2) {
addCriterion("update_time not between", value1, value2, "updateTime");
return (Criteria) this;
} public Criteria andDeletedIsNull() {
addCriterion("deleted is null");
return (Criteria) this;
} public Criteria andDeletedIsNotNull() {
addCriterion("deleted is not null");
return (Criteria) this;
} public Criteria andDeletedEqualTo(Boolean value) {
addCriterion("deleted =", value, "deleted");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andDeletedEqualToColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("deleted = ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andDeletedNotEqualTo(Boolean value) {
addCriterion("deleted <>", value, "deleted");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andDeletedNotEqualToColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("deleted <> ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andDeletedGreaterThan(Boolean value) {
addCriterion("deleted >", value, "deleted");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andDeletedGreaterThanColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("deleted > ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andDeletedGreaterThanOrEqualTo(Boolean value) {
addCriterion("deleted >=", value, "deleted");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andDeletedGreaterThanOrEqualToColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("deleted >= ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andDeletedLessThan(Boolean value) {
addCriterion("deleted <", value, "deleted");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andDeletedLessThanColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("deleted < ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andDeletedLessThanOrEqualTo(Boolean value) {
addCriterion("deleted <=", value, "deleted");
return (Criteria) this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andDeletedLessThanOrEqualToColumn(LitemallLog.Column column) {
addCriterion(new StringBuilder("deleted <= ").append(column.getEscapedColumnName()).toString());
return (Criteria) this;
} public Criteria andDeletedIn(List<Boolean> values) {
addCriterion("deleted in", values, "deleted");
return (Criteria) this;
} public Criteria andDeletedNotIn(List<Boolean> values) {
addCriterion("deleted not in", values, "deleted");
return (Criteria) this;
} public Criteria andDeletedBetween(Boolean value1, Boolean value2) {
addCriterion("deleted between", value1, value2, "deleted");
return (Criteria) this;
} public Criteria andDeletedNotBetween(Boolean value1, Boolean value2) {
addCriterion("deleted not between", value1, value2, "deleted");
return (Criteria) this;
}
} /**
* This class was generated by MyBatis Generator.
* This class corresponds to the database table litemall_log
*
* @mbg.generated do_not_delete_during_merge
*/
public static class Criteria extends GeneratedCriteria {
/**
* This field was generated by MyBatis Generator.
* This field corresponds to the database table litemall_log
*
* @mbg.generated
*/
private LitemallLogExample example; /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
protected Criteria(LitemallLogExample example) {
super();
this.example = example;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public LitemallLogExample example() {
return this.example;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
@Deprecated
public Criteria andIf(boolean ifAdd, ICriteriaAdd add) {
if (ifAdd) {
add.add(this);
}
return this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria when(boolean condition, ICriteriaWhen then) {
if (condition) {
then.criteria(this);
}
return this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria when(boolean condition, ICriteriaWhen then, ICriteriaWhen otherwise) {
if (condition) {
then.criteria(this);
} else {
otherwise.criteria(this);
}
return this;
} /**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
public Criteria andLogicalDeleted(boolean deleted) {
return deleted ? andDeletedEqualTo(LitemallLog.Deleted.IS_DELETED.value()) : andDeletedNotEqualTo(LitemallLog.Deleted.IS_DELETED.value());
} @Deprecated
public interface ICriteriaAdd {
/**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
Criteria add(Criteria add);
}
} /**
* This class was generated by MyBatis Generator.
* This class corresponds to the database table litemall_log
*
* @mbg.generated
*/
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);
}
} public interface ICriteriaWhen {
/**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
void criteria(Criteria criteria);
} public interface IExampleWhen {
/**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table litemall_log
*
* @mbg.generated
*/
void example(org.linlinjava.litemall.db.domain.LitemallLogExample example);
}
}
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="org.linlinjava.litemall.db.dao.LitemallLogMapper">
<resultMap id="BaseResultMap" type="org.linlinjava.litemall.db.domain.LitemallLog">
<!--
WARNING - @mbg.generated
This element is automatically generated by MyBatis Generator, do not modify.
-->
<id column="id" jdbcType="INTEGER" property="id" />
<result column="admin" jdbcType="VARCHAR" property="admin" />
<result column="ip" jdbcType="VARCHAR" property="ip" />
<result column="type" jdbcType="INTEGER" property="type" />
<result column="action" jdbcType="VARCHAR" property="action" />
<result column="status" jdbcType="BIT" property="status" />
<result column="result" jdbcType="VARCHAR" property="result" />
<result column="comment" jdbcType="VARCHAR" property="comment" />
<result column="add_time" jdbcType="TIMESTAMP" property="addTime" />
<result column="update_time" jdbcType="TIMESTAMP" property="updateTime" />
<result column="deleted" jdbcType="BIT" property="deleted" />
</resultMap>
<sql id="Example_Where_Clause">
<!--
WARNING - @mbg.generated
This element is automatically generated by MyBatis Generator, do not modify.
-->
<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 - @mbg.generated
This element is automatically generated by MyBatis Generator, do not modify.
-->
<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 - @mbg.generated
This element is automatically generated by MyBatis Generator, do not modify.
-->
id, `admin`, ip, `type`, `action`, `status`, `result`, `comment`, add_time, update_time,
deleted
</sql>
<select id="selectByExample" parameterType="org.linlinjava.litemall.db.domain.LitemallLogExample" resultMap="BaseResultMap">
<!--
WARNING - @mbg.generated
This element is automatically generated by MyBatis Generator, do not modify.
-->
select
<if test="distinct">
distinct
</if>
<include refid="Base_Column_List" />
from litemall_log
<if test="_parameter != null">
<include refid="Example_Where_Clause" />
</if>
<if test="orderByClause != null">
order by ${orderByClause}
</if>
</select>
<select id="selectByExampleSelective" parameterType="map" resultMap="BaseResultMap">
<!--
WARNING - @mbg.generated
This element is automatically generated by MyBatis Generator, do not modify.
-->
select
<if test="example.distinct">
distinct
</if>
<choose>
<when test="selective != null and selective.length > 0">
<foreach collection="selective" item="column" separator=",">
${column.aliasedEscapedColumnName}
</foreach>
</when>
<otherwise>
<include refid="Base_Column_List" />
</otherwise>
</choose>
from litemall_log
<if test="_parameter != null">
<include refid="Update_By_Example_Where_Clause" />
</if>
<if test="example.orderByClause != null">
order by ${example.orderByClause}
</if>
</select>
<select id="selectByPrimaryKey" parameterType="java.lang.Integer" resultMap="BaseResultMap">
<!--
WARNING - @mbg.generated
This element is automatically generated by MyBatis Generator, do not modify.
-->
select
<include refid="Base_Column_List" />
from litemall_log
where id = #{id,jdbcType=INTEGER}
</select>
<select id="selectByPrimaryKeyWithLogicalDelete" parameterType="map" resultMap="BaseResultMap">
<!--
WARNING - @mbg.generated
This element is automatically generated by MyBatis Generator, do not modify.
-->
select
<include refid="Base_Column_List" />
from litemall_log
where id = #{id,jdbcType=INTEGER}
and deleted =
<choose>
<when test="andLogicalDeleted">
1
</when>
<otherwise>
0
</otherwise>
</choose>
</select>
<select id="selectByPrimaryKeySelective" parameterType="map" resultMap="BaseResultMap">
<!--
WARNING - @mbg.generated
This element is automatically generated by MyBatis Generator, do not modify.
-->
select
<choose>
<when test="selective != null and selective.length > 0">
<foreach collection="selective" item="column" separator=",">
${column.aliasedEscapedColumnName}
</foreach>
</when>
<otherwise>
<include refid="Base_Column_List" />
</otherwise>
</choose>
from litemall_log
where id = #{id,jdbcType=INTEGER}
</select>
<delete id="deleteByPrimaryKey" parameterType="java.lang.Integer">
<!--
WARNING - @mbg.generated
This element is automatically generated by MyBatis Generator, do not modify.
-->
delete from litemall_log
where id = #{id,jdbcType=INTEGER}
</delete>
<delete id="deleteByExample" parameterType="org.linlinjava.litemall.db.domain.LitemallLogExample">
<!--
WARNING - @mbg.generated
This element is automatically generated by MyBatis Generator, do not modify.
-->
delete from litemall_log
<if test="_parameter != null">
<include refid="Example_Where_Clause" />
</if>
</delete>
<insert id="insert" parameterType="org.linlinjava.litemall.db.domain.LitemallLog">
<!--
WARNING - @mbg.generated
This element is automatically generated by MyBatis Generator, do not modify.
-->
<selectKey keyProperty="id" order="AFTER" resultType="java.lang.Integer">
SELECT LAST_INSERT_ID()
</selectKey>
insert into litemall_log (`admin`, ip, `type`,
`action`, `status`, `result`,
`comment`, add_time, update_time,
deleted)
values (#{admin,jdbcType=VARCHAR}, #{ip,jdbcType=VARCHAR}, #{type,jdbcType=INTEGER},
#{action,jdbcType=VARCHAR}, #{status,jdbcType=BIT}, #{result,jdbcType=VARCHAR},
#{comment,jdbcType=VARCHAR}, #{addTime,jdbcType=TIMESTAMP}, #{updateTime,jdbcType=TIMESTAMP},
#{deleted,jdbcType=BIT})
</insert>
<insert id="insertSelective" parameterType="org.linlinjava.litemall.db.domain.LitemallLog">
<!--
WARNING - @mbg.generated
This element is automatically generated by MyBatis Generator, do not modify.
-->
<selectKey keyProperty="id" order="AFTER" resultType="java.lang.Integer">
SELECT LAST_INSERT_ID()
</selectKey>
insert into litemall_log
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="admin != null">
`admin`,
</if>
<if test="ip != null">
ip,
</if>
<if test="type != null">
`type`,
</if>
<if test="action != null">
`action`,
</if>
<if test="status != null">
`status`,
</if>
<if test="result != null">
`result`,
</if>
<if test="comment != null">
`comment`,
</if>
<if test="addTime != null">
add_time,
</if>
<if test="updateTime != null">
update_time,
</if>
<if test="deleted != null">
deleted,
</if>
</trim>
<trim prefix="values (" suffix=")" suffixOverrides=",">
<if test="admin != null">
#{admin,jdbcType=VARCHAR},
</if>
<if test="ip != null">
#{ip,jdbcType=VARCHAR},
</if>
<if test="type != null">
#{type,jdbcType=INTEGER},
</if>
<if test="action != null">
#{action,jdbcType=VARCHAR},
</if>
<if test="status != null">
#{status,jdbcType=BIT},
</if>
<if test="result != null">
#{result,jdbcType=VARCHAR},
</if>
<if test="comment != null">
#{comment,jdbcType=VARCHAR},
</if>
<if test="addTime != null">
#{addTime,jdbcType=TIMESTAMP},
</if>
<if test="updateTime != null">
#{updateTime,jdbcType=TIMESTAMP},
</if>
<if test="deleted != null">
#{deleted,jdbcType=BIT},
</if>
</trim>
</insert>
<select id="countByExample" parameterType="org.linlinjava.litemall.db.domain.LitemallLogExample" resultType="java.lang.Long">
<!--
WARNING - @mbg.generated
This element is automatically generated by MyBatis Generator, do not modify.
-->
select count(*) from litemall_log
<if test="_parameter != null">
<include refid="Example_Where_Clause" />
</if>
</select>
<update id="updateByExampleSelective" parameterType="map">
<!--
WARNING - @mbg.generated
This element is automatically generated by MyBatis Generator, do not modify.
-->
update litemall_log
<set>
<if test="record.id != null">
id = #{record.id,jdbcType=INTEGER},
</if>
<if test="record.admin != null">
`admin` = #{record.admin,jdbcType=VARCHAR},
</if>
<if test="record.ip != null">
ip = #{record.ip,jdbcType=VARCHAR},
</if>
<if test="record.type != null">
`type` = #{record.type,jdbcType=INTEGER},
</if>
<if test="record.action != null">
`action` = #{record.action,jdbcType=VARCHAR},
</if>
<if test="record.status != null">
`status` = #{record.status,jdbcType=BIT},
</if>
<if test="record.result != null">
`result` = #{record.result,jdbcType=VARCHAR},
</if>
<if test="record.comment != null">
`comment` = #{record.comment,jdbcType=VARCHAR},
</if>
<if test="record.addTime != null">
add_time = #{record.addTime,jdbcType=TIMESTAMP},
</if>
<if test="record.updateTime != null">
update_time = #{record.updateTime,jdbcType=TIMESTAMP},
</if>
<if test="record.deleted != null">
deleted = #{record.deleted,jdbcType=BIT},
</if>
</set>
<if test="_parameter != null">
<include refid="Update_By_Example_Where_Clause" />
</if>
</update>
<update id="updateByExample" parameterType="map">
<!--
WARNING - @mbg.generated
This element is automatically generated by MyBatis Generator, do not modify.
-->
update litemall_log
set id = #{record.id,jdbcType=INTEGER},
`admin` = #{record.admin,jdbcType=VARCHAR},
ip = #{record.ip,jdbcType=VARCHAR},
`type` = #{record.type,jdbcType=INTEGER},
`action` = #{record.action,jdbcType=VARCHAR},
`status` = #{record.status,jdbcType=BIT},
`result` = #{record.result,jdbcType=VARCHAR},
`comment` = #{record.comment,jdbcType=VARCHAR},
add_time = #{record.addTime,jdbcType=TIMESTAMP},
update_time = #{record.updateTime,jdbcType=TIMESTAMP},
deleted = #{record.deleted,jdbcType=BIT}
<if test="_parameter != null">
<include refid="Update_By_Example_Where_Clause" />
</if>
</update>
<update id="updateByPrimaryKeySelective" parameterType="org.linlinjava.litemall.db.domain.LitemallLog">
<!--
WARNING - @mbg.generated
This element is automatically generated by MyBatis Generator, do not modify.
-->
update litemall_log
<set>
<if test="admin != null">
`admin` = #{admin,jdbcType=VARCHAR},
</if>
<if test="ip != null">
ip = #{ip,jdbcType=VARCHAR},
</if>
<if test="type != null">
`type` = #{type,jdbcType=INTEGER},
</if>
<if test="action != null">
`action` = #{action,jdbcType=VARCHAR},
</if>
<if test="status != null">
`status` = #{status,jdbcType=BIT},
</if>
<if test="result != null">
`result` = #{result,jdbcType=VARCHAR},
</if>
<if test="comment != null">
`comment` = #{comment,jdbcType=VARCHAR},
</if>
<if test="addTime != null">
add_time = #{addTime,jdbcType=TIMESTAMP},
</if>
<if test="updateTime != null">
update_time = #{updateTime,jdbcType=TIMESTAMP},
</if>
<if test="deleted != null">
deleted = #{deleted,jdbcType=BIT},
</if>
</set>
where id = #{id,jdbcType=INTEGER}
</update>
<update id="updateByPrimaryKey" parameterType="org.linlinjava.litemall.db.domain.LitemallLog">
<!--
WARNING - @mbg.generated
This element is automatically generated by MyBatis Generator, do not modify.
-->
update litemall_log
set `admin` = #{admin,jdbcType=VARCHAR},
ip = #{ip,jdbcType=VARCHAR},
`type` = #{type,jdbcType=INTEGER},
`action` = #{action,jdbcType=VARCHAR},
`status` = #{status,jdbcType=BIT},
`result` = #{result,jdbcType=VARCHAR},
`comment` = #{comment,jdbcType=VARCHAR},
add_time = #{addTime,jdbcType=TIMESTAMP},
update_time = #{updateTime,jdbcType=TIMESTAMP},
deleted = #{deleted,jdbcType=BIT}
where id = #{id,jdbcType=INTEGER}
</update>
<select id="selectOneByExample" parameterType="org.linlinjava.litemall.db.domain.LitemallLogExample" resultMap="BaseResultMap">
<!--
WARNING - @mbg.generated
This element is automatically generated by MyBatis Generator, do not modify.
-->
select
<include refid="Base_Column_List" />
from litemall_log
<if test="_parameter != null">
<include refid="Example_Where_Clause" />
</if>
<if test="orderByClause != null">
order by ${orderByClause}
</if>
limit 1
</select>
<select id="selectOneByExampleSelective" parameterType="map" resultMap="BaseResultMap">
<!--
WARNING - @mbg.generated
This element is automatically generated by MyBatis Generator, do not modify.
-->
select
<choose>
<when test="selective != null and selective.length > 0">
<foreach collection="selective" item="column" separator=",">
${column.aliasedEscapedColumnName}
</foreach>
</when>
<otherwise>
<include refid="Base_Column_List" />
</otherwise>
</choose>
from litemall_log
<if test="_parameter != null">
<include refid="Update_By_Example_Where_Clause" />
</if>
<if test="example.orderByClause != null">
order by ${example.orderByClause}
</if>
limit 1
</select>
<update id="logicalDeleteByExample" parameterType="map">
<!--
WARNING - @mbg.generated
This element is automatically generated by MyBatis Generator, do not modify.
-->
update litemall_log set deleted = 1
<if test="_parameter != null">
<include refid="Update_By_Example_Where_Clause" />
</if>
</update>
<update id="logicalDeleteByPrimaryKey" parameterType="java.lang.Integer">
<!--
WARNING - @mbg.generated
This element is automatically generated by MyBatis Generator, do not modify.
-->
update litemall_log set deleted = 1
where id = #{id,jdbcType=INTEGER}
</update>
</mapper>
CREATE TABLE `litemall_log` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`admin` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '管理员',
`ip` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '管理员地址',
`type` int(11) DEFAULT NULL COMMENT '操作分类',
`action` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '操作动作',
`status` tinyint(1) DEFAULT NULL COMMENT '操作状态',
`result` varchar(127) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '操作结果，或者成功消息，或者失败消息',
`comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '补充信息',
`add_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`deleted` tinyint(1) DEFAULT '0' COMMENT '逻辑删除',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='操作日志表';
最新文章
- SQL 从指定表筛选指定行信息 获取表行数
- User space 与 Kernel space
- Runtime消息传送
- PHP魔术变量总结
- JDK Tools - wsimport: 编译 WSDL 生成 JAX-WS 规范的 Java 类
- cxf webservice异步调用
- JavaScript 函数方法 - bind()
- php常用面试知识点
- [.NET跨平台]Jexus独立版本的便利与过程中的一些坑
- 数据分析入门——numpy类库基础知识
- xpath路径定位
- 第十一节：Bundles压缩合并js和css及原理分析
- 【angularjs】使用angularjs模拟淘宝首页-淘宝头条滚动效果
- Ubuntu16.04安装使用wps
- mysql 函数应用
- WinForm中一个窗体调用另一个窗体
- Django读取Mysql数据并显示在前端
- DRUPAL8模版命名规则
- vue-cli配置axios
- matlab中的knn函数