设备表

zhangzeli

2021-11-01 a84646cd786e555d4020411f4f670d6ebb0a4b8c

设备表

 xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/controller/EquipmentController.java

New file
@@ -0,0 +1,78 @@
package cn.exrick.xboot.your.controller;

import cn.exrick.xboot.core.common.utils.PageUtil;
import cn.exrick.xboot.core.common.utils.ResultUtil;
import cn.exrick.xboot.core.common.vo.PageVo;
import cn.exrick.xboot.core.common.vo.Result;
import cn.exrick.xboot.your.entity.Equipment;
import cn.exrick.xboot.your.service.IEquipmentService;
import cn.hutool.core.util.StrUtil;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
import org.springframework.transaction.annotation.Transactional;

import java.util.List;

/**
 * @author zhangzeli
 */
@Slf4j
@RestController
@Api(tags = "设备表表管理接口")
@RequestMapping("/xboot/equipment")
@Transactional
public class EquipmentController {

    @Autowired
    private IEquipmentService iEquipmentService;

    @RequestMapping(value = "/get/{id}", method = RequestMethod.GET)
    @ApiOperation(value = "通过id获取")
    public Result<Equipment> get(@PathVariable String id) {

        Equipment equipment = iEquipmentService.getById(id);
        return new ResultUtil<Equipment>().setData(equipment);
    }

    @RequestMapping(value = "/getAll", method = RequestMethod.GET)
    @ApiOperation(value = "获取全部数据")
    public Result<List<Equipment>> getAll() {

        List<Equipment> list = iEquipmentService.list();
        return new ResultUtil<List<Equipment>>().setData(list);
    }

    @RequestMapping(value = "/getByPage", method = RequestMethod.GET)
    @ApiOperation(value = "分页获取")
    public Result<IPage<Equipment>> getByPage(String carId,PageVo page) {
        QueryWrapper<Equipment> wrapper = new QueryWrapper<>();
        wrapper.like("car_id",carId);
        IPage<Equipment> data = iEquipmentService.page(PageUtil.initMpPage(page),wrapper);
        return new ResultUtil<IPage<Equipment>>().setData(data);
    }

    @RequestMapping(value = "/insertOrUpdate", method = RequestMethod.POST)
    @ApiOperation(value = "编辑或更新数据")
    public Result<Equipment> saveOrUpdate(Equipment equipment) {

        if (iEquipmentService.saveOrUpdate(equipment)) {
            return new ResultUtil<Equipment>().setData(equipment);
        }
        return new ResultUtil<Equipment>().setErrorMsg("操作失败");
    }

    @RequestMapping(value = "/delByIds", method = RequestMethod.POST)
    @ApiOperation(value = "批量通过id删除")
    public Result<Object> delAllByIds(@RequestParam String[] ids) {

        for (String id : ids) {
            iEquipmentService.removeById(id);
        }
        return ResultUtil.success("批量通过id删除数据成功");
    }
}

 xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/entity/Equipment.java

New file
@@ -0,0 +1,49 @@
package cn.exrick.xboot.your.entity;

import cn.exrick.xboot.core.base.XbootBaseEntity;
import com.baomidou.mybatisplus.annotation.TableName;
import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import org.hibernate.annotations.DynamicInsert;
import org.hibernate.annotations.DynamicUpdate;
import org.springframework.format.annotation.DateTimeFormat;

import javax.persistence.Entity;
import javax.persistence.Table;
import java.util.Date;

/**
 * @author Exrick
 */
@Data
@Entity
@DynamicInsert
@DynamicUpdate
@Table(name = "t_equipment")
@TableName("t_equipment")
@ApiModel(value = "设备表")
public class Equipment extends XbootBaseEntity {

    private static final long serialVersionUID = 1L;

    @ApiModelProperty(value = "0:车机 1:摄像机 2:抓拍机 3:pad")
    private int type;

    @ApiModelProperty(value = "编号")
    private String code;

    @ApiModelProperty(value = "状态 0:正常  1:停用")
    private int status;

    @ApiModelProperty(value = "关联车辆id")
    private String carId;

    @ApiModelProperty(value = "ip地址")
    private String ip;

    @ApiModelProperty(value = "端口号")
    private String port;

}

 xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/mapper/EquipmentMapper.java

New file
@@ -0,0 +1,14 @@
package cn.exrick.xboot.your.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import cn.exrick.xboot.your.entity.Equipment;

import java.util.List;

/**
 * 设备表表数据处理层
 * @author zhangzeli
 */
public interface EquipmentMapper extends BaseMapper<Equipment> {

}

 xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/service/IEquipmentService.java

New file
@@ -0,0 +1,14 @@
package cn.exrick.xboot.your.service;

import com.baomidou.mybatisplus.extension.service.IService;
import cn.exrick.xboot.your.entity.Equipment;

import java.util.List;

/**
 * 设备表表接口
 * @author zhangzeli
 */
public interface IEquipmentService extends IService<Equipment> {

}

 xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/serviceimpl/IEquipmentServiceImpl.java

New file
@@ -0,0 +1,26 @@
package cn.exrick.xboot.your.serviceimpl;

import cn.exrick.xboot.your.mapper.EquipmentMapper;
import cn.exrick.xboot.your.entity.Equipment;
import cn.exrick.xboot.your.service.IEquipmentService;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.util.ArrayList;
import java.util.List;

/**
 * 设备表表接口实现
 * @author zhangzeli
 */
@Slf4j
@Service
@Transactional
public class IEquipmentServiceImpl extends ServiceImpl<EquipmentMapper, Equipment> implements IEquipmentService {

    @Autowired
    private EquipmentMapper equipmentMapper;
}

 xboot-modules/xboot-your/src/main/resources/mapper/EquipmentMapper.xml

New file
@@ -0,0 +1,5 @@
<?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="cn.exrick.xboot.your.mapper.EquipmentMapper">

</mapper>