热门标签 | HotTags
当前位置:  开发笔记 > 编程语言 > 正文

springboot实现mqtt物联网的示例代码

这篇文章主要介绍了springboot实现mqtt物联网,本文给大家介绍的非常详细,对大家的学习或工作具有一定的参考借鉴价值,需要的朋友可以参考下

Springboot整合mybatisPlus+mysql+druid+swaggerUI+ mqtt 整合mqtt整合druid整合mybatis-plus完整pom完整yml整合swaggerUi整合log4j MQTT 物联网系统基本架构本物联网系列
mqtt)

整合mqtt

 
  
   org.springframework.boot
   spring-boot-starter-integration
  
  
   org.springframework.integration
   spring-integration-stream
  
  
   org.springframework.integration
   spring-integration-mqtt
  

yml

iot:
 mqtt:
 clientId: ${random.value}
 defaultTopic: topic
 shbykjTopic: shbykj_topic
 url: tcp://127.0.0.1:1883
 username: admin
 password: admin
 completionTimeout: 3000
package com.shbykj.handle.mqtt;

import lombok.Getter;
import lombok.Setter;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.integration.annotation.IntegrationComponentScan;
import org.springframework.stereotype.Component;

/**
 * @Author: wxm
 * @Description: mqtt基础配置类
 */

@Getter
@Setter
@Component
@IntegrationComponentScan
@ConfigurationProperties(prefix = "iot.mqtt")
public class BykjMqttConfig {
 /*
 *
 * 服务地址
 */

 private String url;

 /**
 * 客户端id
 */


 private String clientId;
 /*
 *
 * 默认主题
 */

 private String defaultTopic;
 /*
 *
 * 用户名和密码*/


 private String username;

 private String password;

 /**
 * 超时时间
 */
 private int completionTimeout;
 /**
 * shbykj自定义主题
 */
 private String shbykjTopic;

}
package com.shbykj.handle.mqtt.producer;

import org.springframework.integration.annotation.MessagingGateway;
import org.springframework.integration.mqtt.support.MqttHeaders;
import org.springframework.messaging.handler.annotation.Header;

/**
 * @description rabbitmq mqtt协议网关接口
 * @date 2020/6/8 18:26
 */
@MessagingGateway(defaultRequestChannel = "iotMqttInputChannel")
public interface IotMqttGateway {

 void sendMessage2Mqtt(String data);

 void sendMessage2Mqtt(String data, @Header(MqttHeaders.TOPIC) String topic);

 void sendMessage2Mqtt(@Header(MqttHeaders.TOPIC) String topic, @Header(MqttHeaders.QOS) int qos, String payload);
}
package com.shbykj.handle.mqtt;

import org.eclipse.paho.client.mqttv3.MqttConnectOptions;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.integration.annotation.ServiceActivator;
import org.springframework.integration.channel.DirectChannel;
import org.springframework.integration.mqtt.core.DefaultMqttPahoClientFactory;
import org.springframework.integration.mqtt.core.MqttPahoClientFactory;
import org.springframework.messaging.MessageChannel;
import org.springframework.messaging.MessageHandler;
import org.springframework.messaging.MessagingException;


@Configuration
public class IotMqttProducerConfig {
 public final Logger logger = LoggerFactory.getLogger(this.getClass());


 @Autowired
 private BykjMqttConfig mqttConfig;
 /*
 *
 * MQTT连接器选项
 * *
 */


 @Bean(value = "getMqttConnectOptions")
 public MqttConnectOptions getMqttConnectOptions1() {
 MqttConnectOptions mqttCOnnectOptions= new MqttConnectOptions();
 // 设置是否清空session,这里如果设置为false表示服务器会保留客户端的连接记录,这里设置为true表示每次连接到服务器都以新的身份连接
 mqttConnectOptions.setCleanSession(true);
 // 设置超时时间 单位为秒
 mqttConnectOptions.setConnectionTimeout(mqttConfig.getCompletionTimeout());
 mqttConnectOptions.setAutomaticReconnect(true);
 mqttConnectOptions.setUserName(mqttConfig.getUsername());
 mqttConnectOptions.setPassword(mqttConfig.getPassword().toCharArray());
 mqttConnectOptions.setServerURIs(new String[]{mqttConfig.getUrl()});
 // 设置会话心跳时间 单位为秒 服务器会每隔1.5*20秒的时间向客户端发送心跳判断客户端是否在线,但这个方法并没有重连的机制
 mqttConnectOptions.setKeepAliveInterval(10);
 // 设置“遗嘱”消息的话题,若客户端与服务器之间的连接意外中断,服务器将发布客户端的“遗嘱”消息。
 //mqttConnectOptions.setWill("willTopic", WILL_DATA, 2, false);
 return mqttConnectOptions;
 }

 /**
 * mqtt工厂
 *
 * @return
 */


 @Bean
 public MqttPahoClientFactory mqttClientFactory() {
 DefaultMqttPahoClientFactory factory = new DefaultMqttPahoClientFactory();
// factory.setServerURIs(mqttConfig.getServers());
 factory.setConnectionOptions(getMqttConnectOptions1());
 return factory;

 }

 @Bean
 public MessageChannel iotMqttInputChannel() {
 return new DirectChannel();
 }

 // @Bean
// @ServiceActivator(inputChannel = "iotMqttInputChannel")
// public MessageHandler mqttOutbound() {
// MqttPahoMessageHandler messageHandler = new MqttPahoMessageHandler(mqttConfig.getClientId(), mqttClientFactory());
// messageHandler.setAsync(false);
// messageHandler.setDefaultQos(2);
// messageHandler.setDefaultTopic(mqttConfig.getDefaultTopic());
// return messageHandler;
// }
 @Bean
 @ServiceActivator(inputChannel = "iotMqttInputChannel")
 public MessageHandler handlerTest() {

 return message -> {
  try {
  String string = message.getPayload().toString();

  System.out.println(string);
  } catch (MessagingException ex) {
  ex.printStackTrace();
  logger.info(ex.getMessage());
  }
 };
 }
}
package com.shbykj.handle.mqtt;

import org.eclipse.paho.client.mqttv3.MqttConnectOptions;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.integration.annotation.ServiceActivator;
import org.springframework.integration.channel.DirectChannel;
import org.springframework.integration.core.MessageProducer;
import org.springframework.integration.mqtt.core.DefaultMqttPahoClientFactory;
import org.springframework.integration.mqtt.core.MqttPahoClientFactory;
import org.springframework.integration.mqtt.inbound.MqttPahoMessageDrivenChannelAdapter;
import org.springframework.integration.mqtt.outbound.MqttPahoMessageHandler;
import org.springframework.integration.mqtt.support.DefaultPahoMessageConverter;
import org.springframework.messaging.Message;
import org.springframework.messaging.MessageChannel;
import org.springframework.messaging.MessageHandler;
import org.springframework.messaging.MessagingException;

/**
 * @Author: xiaofu
 * @Description: 消息订阅配置
 * @date 2020/6/8 18:24
 */
@Configuration
public class IotMqttSubscriberConfig {
 public final Logger logger = LoggerFactory.getLogger(this.getClass());


 @Autowired
 private MqttReceiveHandle mqttReceiveHandle;
 @Autowired
 private BykjMqttConfig mqttConfig;
 /*
 *
 * MQTT连接器选项
 * *
 */


 @Bean(value = "getMqttConnectOptions")
 public MqttConnectOptions getMqttConnectOptions1() {
 MqttConnectOptions mqttCOnnectOptions= new MqttConnectOptions();
 // 设置是否清空session,这里如果设置为false表示服务器会保留客户端的连接记录,这里设置为true表示每次连接到服务器都以新的身份连接
 mqttConnectOptions.setCleanSession(true);
 // 设置超时时间 单位为秒
 mqttConnectOptions.setConnectionTimeout(10);
 mqttConnectOptions.setAutomaticReconnect(true);
// mqttConnectOptions.setUserName(mqttConfig.getUsername());
// mqttConnectOptions.setPassword(mqttConfig.getPassword().toCharArray());
 mqttConnectOptions.setServerURIs(new String[]{mqttConfig.getUrl()});
 // 设置会话心跳时间 单位为秒 服务器会每隔1.5*20秒的时间向客户端发送心跳判断客户端是否在线,但这个方法并没有重连的机制
 mqttConnectOptions.setKeepAliveInterval(10);
 // 设置“遗嘱”消息的话题,若客户端与服务器之间的连接意外中断,服务器将发布客户端的“遗嘱”消息。
 //mqttConnectOptions.setWill("willTopic", WILL_DATA, 2, false);
 return mqttConnectOptions;
 }
 /*
 *
 *MQTT信息通道(生产者)
 **
 */

 @Bean
 public MessageChannel iotMqttOutboundChannel() {
 return new DirectChannel();
 }
 /*

 *
 *MQTT消息处理器(生产者)
 **
 */

 @Bean
 @ServiceActivator(inputChannel = "iotMqttOutboundChannel")
 public MessageHandler mqttOutbound() {
 MqttPahoMessageHandler messageHandler = new MqttPahoMessageHandler(mqttConfig.getClientId(), mqttClientFactory());
 messageHandler.setAsync(true);
 messageHandler.setDefaultTopic(mqttConfig.getDefaultTopic());
 return messageHandler;
 }

 /*
 *
 *MQTT工厂
 **
 */
 @Bean
 public MqttPahoClientFactory mqttClientFactory() {
 DefaultMqttPahoClientFactory factory = new DefaultMqttPahoClientFactory();
// factory.setServerURIs(mqttConfig.getServers());
 factory.setConnectionOptions(getMqttConnectOptions1());
 return factory;
 }

 /*
 *
 *MQTT信息通道(消费者)
 **
 */
 @Bean
 public MessageChannel iotMqttInputChannel() {
 return new DirectChannel();
 }

 /**
 * 配置client,监听的topic
 * MQTT消息订阅绑定(消费者)
 ***/

 @Bean
 public MessageProducer inbound() {
 MqttPahoMessageDrivenChannelAdapter adapter = new MqttPahoMessageDrivenChannelAdapter(mqttConfig.getClientId(), mqttClientFactory(), mqttConfig.getDefaultTopic(), mqttConfig.getShbykjTopic());
 adapter.setCompletionTimeout(mqttConfig.getCompletionTimeout());
 adapter.setConverter(new DefaultPahoMessageConverter());
 adapter.setQos(2);
 adapter.setOutputChannel(iotMqttInputChannel());
 return adapter;
 }

 /**
 * @author wxm
 * @description 消息订阅
 * @date 2020/6/8 18:20
 */
 @Bean
 @ServiceActivator(inputChannel = "iotMqttInputChannel")

 public MessageHandler handler() {
 return new MessageHandler() {
  @Override
  public void handleMessage(Message<&#63;> message) throws MessagingException {
  //处理接收消息
  try {
   mqttReceiveHandle.handle(message);
  } catch (Exception e) {
   logger.warn("消息处理异常"+e.getMessage());
   e.printStackTrace();

  }
  }
 };
 }
}
package com.shbykj.handle.mqtt;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.shbykj.handle.common.DataCheck;
import com.shbykj.handle.common.RedisKey;
import com.shbykj.handle.common.RedisUtils;
import com.shbykj.handle.common.constants.Constants;
import com.shbykj.handle.common.model.ShbyCSDeviceEntity;
import com.shbykj.handle.common.model.sys.SysInstrument;
import com.shbykj.handle.resolve.mapper.SysInstrumentMapper;
import com.shbykj.handle.resolve.util.DateUtils;
import com.shbykj.handle.resolve.util.ShbyCSDeviceUtils;
import lombok.extern.slf4j.Slf4j;
import org.apache.commons.collections.BidiMap;
import org.apache.commons.collections.bidimap.DualHashBidiMap;
import org.apache.commons.lang3.StringUtils;
import org.eclipse.paho.client.mqttv3.IMqttDeliveryToken;
import org.eclipse.paho.client.mqttv3.MqttCallback;
import org.eclipse.paho.client.mqttv3.MqttMessage;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.integration.mqtt.support.MqttHeaders;
import org.springframework.messaging.Message;
import org.springframework.stereotype.Component;
import org.springframework.transaction.annotation.Transactional;

import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.HashMap;
import java.util.Map;

/*
 *
 * mqtt客户端消息处理类
 * **/
@Component
@Slf4j
@Transactional
public class MqttReceiveHandle implements MqttCallback {
 private static final Logger logger = LoggerFactory.getLogger(MqttReceiveHandle.class);
 @Value("${shbykj.checkCrc}")
 private boolean checkcrc;
 @Autowired
 private SysInstrumentMapper sysInstrumentMapper;
 @Autowired
 private RedisUtils redisUtils;


 public static BidiMap bidiMap = new DualHashBidiMap();
 //记录bykj协议内容
 public static Map> devMap = new HashMap();

 //记录上限数量
// public static Map ctxMap = new HashMap();
 public void handle(Message<&#63;> message) {


 try {
  logger.info("{},客户端号:{},主题:{},QOS:{},消息接收到的数据:{}", new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date()), message.getHeaders().get(MqttHeaders.ID), message.getHeaders().get(MqttHeaders.RECEIVED_TOPIC), message.getHeaders().get(MqttHeaders.RECEIVED_QOS), message.getPayload());
  //处理mqtt数据
  this.handle(message.getPayload().toString());
 } catch (Exception e) {
  e.printStackTrace();
  log.error("处理错误" + e.getMessage());
 }

 }

 private void handle(String str) throws Exception {

 boolean flag = this.dataCheck(str);
 if (flag) {

  ShbyCSDeviceEntity shbyCSDeviceEntity = ShbyCSDeviceUtils.convertToSysInstrumentEntity(str);
  String deviceNumber = shbyCSDeviceEntity.getPN();
  String smpId = shbyCSDeviceEntity.getSMP_ID();
  String smpName = shbyCSDeviceEntity.getSMP_NAME();
  String smpWt = shbyCSDeviceEntity.getSMP_WT();
  if (StringUtils.isEmpty(smpId) || StringUtils.isEmpty(smpName) || StringUtils.isEmpty(smpWt)) {
  log.error("过滤无实际作用报文信息", str);
  logger.error("过滤无实际作用报文信息", str);
  return;
  }
  //判断设备id是否存在数据库中,存在才进行数据部分处理
  //不存在就提醒需要添加设备:
  QueryWrapper wrapper = new QueryWrapper();

  wrapper.eq("number", deviceNumber);
  wrapper.eq("is_deleted", Constants.NO);
  SysInstrument sysInstrument = sysInstrumentMapper.selectOne(wrapper);
  if (null == sysInstrument) {
  log.error("碳氧仪不存在或已删除,设备号:{}", deviceNumber);
  logger.error("碳氧仪不存在或已删除,设备号:{}", deviceNumber);
  return;
  }

  try {
  //增加实时数据
  String instrumentId = sysInstrument.getId().toString();
  String realDataKey = RedisKey.CSdevice_DATA_KEY + instrumentId;

  this.redisUtils.set(realDataKey, shbyCSDeviceEntity);
  System.out.println(shbyCSDeviceEntity);
  //通讯时间
  String OnlineTime= "shbykj_mqtt:onlines:" + instrumentId;
  this.redisUtils.set(onlineTime, shbyCSDeviceEntity.getDataTime(), (long) Constants.RedisTimeOut.REAL_TIME_OUT);
  log.info("实时数据已经更新:设备主键id" + instrumentId);
  logger.info("{} 实时数据已经更新:设备主键id:{}",new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date()),instrumentId);

  } catch (Exception var1) {
  log.error("redis处理实时报文数据逻辑异常 :" + var1.getMessage());
  logger.error("redis处理实时报文数据逻辑异常 :" + var1.getMessage());

  }


 }
 }

 private boolean dataCheck(String message) {
 boolean flag = DataCheck.receiverCheck(message);
 if (!flag) {
  return false;
 } else {
  int i = message.indexOf("QN=");
  if (i <0) {
  log.warn("数据包中没有QN号码: " + message);
  logger.warn("数据包中没有QN号码: " + message);
  return false;
  } else {
  i = message.indexOf("PN=");
  if (i <0) {
   log.warn("数据包中没有PN号码: " + message);
   logger.warn("数据包中没有PN号码: " + message);
   return false;
  } else {
   if (this.checkcrc) {
   flag = DataCheck.checkCrc(message);
   if (!flag) {
    log.warn("crc校验失败: " + message);
    logger.warn("数据包中没有PN号码: " + message);
    return false;
   }
   }

   return true;
  }
  }
 }
 }


 /**
 * 连接丢失
 *
 * @param throwable
 */
 @Override
 public void connectionLost(Throwable throwable) {
 logger.warn("连接丢失-客户端:{},原因:{}", throwable.getMessage());

 }

 /**
 * 消息已到达
 *
 * @param s
 * @param mqttMessage
 * @throws Exception
 */
 @Override
 public void messageArrived(String s, MqttMessage mqttMessage) throws Exception {

 }

 /**
 * 完成消息回调
 *
 * @param iMqttDeliveryToken
 */
 @Override
 public void deliveryComplete(IMqttDeliveryToken iMqttDeliveryToken) {

 }
}

整合druid

pom

 
  com.alibaba
  druid-spring-boot-starter
  1.1.10
 

druid-bean.xml

<&#63;xml version="1.0" encoding="UTF-8"&#63;>


 
 

 
 
 
  
  com.shbykj.*.service.*.impl.*
  
 
 

 
 
 

yml

#spring
spring:
 main:
 allow-bean-definition-overriding: true
 # mysql DATABASE CONFIG
 datasource:
 druid:
 filters: stat,wall,log4j2
 continueOnError: true
 type: com.alibaba.druid.pool.DruidDataSource
 url: jdbc:mysql://localhost:3306/mqttdb&#63;useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezOne=UTC&allowPublicKeyRetrieval=true
 username: root
 password: 123456
 driver-class-name: com.mysql.jdbc.Driver
 # see https://github.com/alibaba/druid
 initialSize: 15
 minIdle: 10
 maxActive: 200
 maxWait: 60000
 timeBetweenEvictionRunsMillis: 60000
 validationQuery: SELECT 1
 testWhileIdle: true
 testOnBorrow: false
 testOnReturn: false
 poolPreparedStatements: true
 keepAlive: true
 maxPoolPreparedStatementPerConnectionSize: 50
 connectionProperties:
 druid.stat.mergeSql: true
 druid.stat.slowSqlMillis: 5000

启动类加上注解@ImportResource( locatiOns= {"classpath:druid-bean.xml"} )

在这里插入图片描述

整合mybatis-plus

pom


 
  com.baomidou
  spring-wind
  1.1.5
  
  
   com.baomidou
   mybatis-plus
  
  
 

 
  com.baomidou
  3.1.2
  mybatis-plus-boot-starter
 
 
  mysql
  mysql-connector-java
  5.1.44
 
  
 
  com.github.pagehelper
  pagehelper-spring-boot-starter
  1.2.12
 

yml

#mybatis
mybatis-plus:
 mapper-locations: classpath:/mapper/*.xml
 typeAliasesPackage: org.spring.springboot.entity
 global-config:
 #主键类型 0:"数据库ID自增", 1:"用户输入ID",2:"全局唯一ID (数字类型唯一ID)", 3:"全局唯一ID UUID";
 id-type: 3
 #字段策略 0:"忽略判断",1:"非 NULL 判断"),2:"非空判断"
 field-strategy: 2
 #驼峰下划线转换
 db-column-underline: true
 #刷新mapper 调试神器
 refresh-mapper: true
 configuration:
 map-underscore-to-camel-case: true
 cache-enabled: false

启动类注解@MapperScan({"com.shbykj.handle.resolve.mapper"})

完整pom

<&#63;xml version="1.0" encoding="UTF-8"&#63;>

 4.0.0
 
 org.springframework.boot
 spring-boot-starter-parent
 2.4.1
  
 
 com.shbykj
 handle
 0.0.1-SNAPSHOT
 handle
 Demo project for Spring Boot

 
 1.8
 

 
 
 
 
 
  org.slf4j
  slf4j-simple
  1.7.25
  compile
 
 
 
  org.springframework.boot
  spring-boot-starter-log4j2
 

 
 
  org.projectlombok
  lombok
 
 
 
  org.springframework.boot
  spring-boot-starter
  
  
   org.springframework.boot
   spring-boot-starter-logging
  
  
 
 
 
  io.springfox
  springfox-swagger-ui
  2.9.2
 

 
 
  io.springfox
  springfox-swagger2
  2.9.2
  
  
   com.google.guava
   guava
  
  
 
 
 
  com.baomidou
  spring-wind
  1.1.5
  
  
   com.baomidou
   mybatis-plus
  
  
 

 
  com.baomidou
  3.1.2
  mybatis-plus-boot-starter
 
 
  mysql
  mysql-connector-java
  5.1.44
 
 
  com.alibaba
  druid-spring-boot-starter
  1.1.10
 
 
 
  com.github.pagehelper
  pagehelper-spring-boot-starter
  1.2.12
 
 
 
  org.springframework.boot
  spring-boot-devtools
  true
  runtime
 
 
 
  com.google.code.gson
  gson
 
 
 
  org.springframework.boot
  spring-boot-starter-data-redis
 
 
 
  org.apache.commons
  commons-lang3
  3.8.1
 
 
 
 
  com.google.guava
  guava
  30.0-jre
 
 
 
  cn.hutool
  hutool-core
  5.5.0
 

 
 
  org.projectlombok
  lombok
  true
 

 
  org.springframework.boot
  spring-boot-starter-test
  test
 
 

 
 
  
  org.springframework.boot
  spring-boot-maven-plugin
  
 
 

完整yml

server:
 port: 8082
#spring
spring:
 devtools:
 restart:
 enabled: true
 main:
 allow-bean-definition-overriding: true
 # mysql DATABASE CONFIG
 datasource:
 druid:
 filters: stat,wall,log4j2
 continueOnError: true
 type: com.alibaba.druid.pool.DruidDataSource
 url: jdbc:mysql://localhost:3306/mqttdb&#63;useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezOne=UTC&allowPublicKeyRetrieval=true
 username: root
 password: 123456
 driver-class-name: com.mysql.jdbc.Driver
 # see https://github.com/alibaba/druid
 initialSize: 15
 minIdle: 10
 maxActive: 200
 maxWait: 60000
 timeBetweenEvictionRunsMillis: 60000
 validationQuery: SELECT 1
 testWhileIdle: true
 testOnBorrow: false
 testOnReturn: false
 poolPreparedStatements: true
 keepAlive: true
 maxPoolPreparedStatementPerConnectionSize: 50
 connectionProperties:
 druid.stat.mergeSql: true
 druid.stat.slowSqlMillis: 5000
shbykj:
 checkCrc: false
#mybatis
mybatis-plus:
 mapper-locations: classpath:/mapper/*.xml
 typeAliasesPackage: org.spring.springboot.entity
 global-config:
 #主键类型 0:"数据库ID自增", 1:"用户输入ID",2:"全局唯一ID (数字类型唯一ID)", 3:"全局唯一ID UUID";
 id-type: 3
 #字段策略 0:"忽略判断",1:"非 NULL 判断"),2:"非空判断"
 field-strategy: 2
 #驼峰下划线转换
 db-column-underline: true
 #刷新mapper 调试神器
 refresh-mapper: true
 configuration:
 map-underscore-to-camel-case: true
 cache-enabled: false
#logging
logging:
 config: classpath:log4j2-demo.xml

整合swaggerUi

pom


  
  io.springfox
  springfox-swagger-ui
  2.9.2
  
  
  
  
  io.swagger
  swagger-models
  1.5.21
  
  
  
  io.springfox
  springfox-swagger2
  2.9.2
  
   
   com.google.guava
   guava
   
  
  

使用

package com.shbykj.handle.web.wx;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.shbykj.handle.common.RetMsgData;
import com.shbykj.handle.common.State;
import com.shbykj.handle.common.model.sys.SysInstrument;
import com.shbykj.handle.h.service.ISysInstrumentService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiImplicitParam;
import io.swagger.annotations.ApiImplicitParams;
import io.swagger.annotations.ApiOperation;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;

/**
 * 监测点接口
 *
 * @author
 * @date 2021-01-15 16:49
 */
@RestController
@RequestMapping({"/api/wxapoint"})
@Api(
 tags = {"小程序 监测点接口"}
)
public class CSDevicesController extends BaseController {
 @Autowired
 private ISysInstrumentService sysInstrumentService;

 public CSDevicesController() {
 }

 @ApiOperation(
  value = "分页查询",
  notes = "分页查询站点信息"
 )
 @ApiImplicitParams({@ApiImplicitParam(
  name = "number",
  value = "设备编号",
  paramType = "query",
  dataType = "String"
 ), @ApiImplicitParam(
  name = "page",
  value = "页码 从1开始",
  required = false,
  dataType = "long",
  paramType = "query"
 ), @ApiImplicitParam(
  name = "size",
  value = "页数",
  required = false,
  dataType = "long",
  paramType = "query"
 )})
 @GetMapping({"/pageByNumber"})
 public RetMsgData> pageByNumber(@RequestParam(required = false) String number) {
 RetMsgData msg = new RetMsgData();

 try {
  IPage page1 = this.getPage();
  page1 = sysInstrumentService.pageByNumber(number, page1);

  msg.setData(page1);
 } catch (Exception var5) {
  msg.setState(State.RET_STATE_SYSTEM_ERROR);
  this.logger.error(var5.getMessage());
 }

 return msg;
 }
}
package com.shbykj.handle.common.model.sys;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import java.io.Serializable;
import java.util.Date;

@TableName("instrument")
@ApiModel("仪器配置表字段信息")
public class SysInstrument implements Serializable {
 private static final long serialVersiOnUID= 1L;
 @TableId(
 value = "id",
 type = IdType.AUTO
 )
 @ApiModelProperty(
 value = "id",
 name = "id",
 required = true
 )
 private Long id;
 @TableField("name")
 @ApiModelProperty(
 value = "名称 仪器名称",
 name = "name"
 )
 private String name;
 @TableField("number")
 @ApiModelProperty(
 value = "编号 仪器编号(PN)",
 name = "number"
 )
 private String number;
 @TableField("manufacturer")
 @ApiModelProperty(
 value = "生产厂商 生产厂商",
 name = "manufacturer"
 )
 private String manufacturer;
 @TableField("gmt_create")
 @ApiModelProperty(
 value = "创建时间",
 name = "gmt_create"
 )
 private Date gmtCreate;
 @TableField("gmt_modified")
 @ApiModelProperty(
 value = "更新时间",
 name = "gmt_modified"
 )
 private Date gmtModified;
 @TableField("is_deleted")
 @ApiModelProperty(
 value = "表示删除,0 表示未删除 默认0",
 name = "is_deleted"
 )
 private Integer isDeleted;
 @TableField("device_type")
 @ApiModelProperty(
 value = "设备类型(PT)",
 name = "device_type"
 )
 private String deviceType;

 public SysInstrument() {
 }

 public Long getId() {
 return this.id;
 }

 public String getName() {
 return this.name;
 }


 public String getNumber() {
 return this.number;
 }

 public String getManufacturer() {
 return this.manufacturer;
 }

 public Date getGmtCreate() {
 return this.gmtCreate;
 }

 public Date getGmtModified() {
 return this.gmtModified;
 }

 public Integer getIsDeleted() {
 return this.isDeleted;
 }

 public String getDeviceType() {
 return this.deviceType;
 }

 public void setId(final Long id) {
 this.id = id;
 }

 public void setName(final String name) {
 this.name = name;
 }


 public void setNumber(final String number) {
 this.number = number;
 }

 public void setManufacturer(final String manufacturer) {
 this.manufacturer = manufacturer;
 }

 public void setGmtCreate(final Date gmtCreate) {
 this.gmtCreate = gmtCreate;
 }

 public void setGmtModified(final Date gmtModified) {
 this.gmtModified = gmtModified;
 }

 public void setIsDeleted(final Integer isDeleted) {
 this.isDeleted = isDeleted;
 }

 public void setDeviceType(final String deviceType) {
 this.deviceType = deviceType;
 }

 

 public String toString() {
 return "SysInstrument(id=" + this.getId() + ", name=" + this.getName() + ", number=" + this.getNumber() + ", manufacturer=" + this.getManufacturer() + ", gmtCreate=" + this.getGmtCreate() + ", gmtModified=" + this.getGmtModified() + ", isDeleted=" + this.getIsDeleted() + ", deviceType=" + this.getDeviceType() + ")";
 }
}

整合log4j

https://www.jb51.net/article/152599.htm

MQTT 物联网系统基本架构

pom

<&#63;xml version="1.0" encoding="UTF-8"&#63;>

 4.0.0
 
 org.springframework.boot
 spring-boot-starter-parent
 2.4.2
  
 
 com.shbykj
 handle_mqtt
 0.0.1-SNAPSHOT
 handle_mqtt
 Demo project for Spring Boot
 
 1.8
 true
 
 
  
  
   org.springframework.boot
   spring-boot-starter-integration
  
  
   org.springframework.integration
   spring-integration-stream
  
  
   org.springframework.integration
   spring-integration-mqtt
  

 
  org.springframework.boot
  spring-boot-starter-web
  
  
   org.springframework.boot
   spring-boot-starter-logging
  
  
 
 
 
 
 
  org.slf4j
  slf4j-simple
  1.7.25
  compile
 
 
 
  org.springframework.boot
  spring-boot-starter-log4j2
 

 
 
  org.springframework.boot
  spring-boot-starter
  
  
   org.springframework.boot
   spring-boot-starter-logging
  
  
 
 
  
  io.springfox
  springfox-swagger-ui
  2.9.2
  
  
  
  
  io.swagger
  swagger-models
  1.5.21
  
  
  
  io.springfox
  springfox-swagger2
  2.9.2
  
   
   com.google.guava
   guava
   
  
  

 
 
 
  org.springframework.boot
  spring-boot-devtools
  true
  runtime
 
 
 
  com.google.code.gson
  gson
 
 
 
  org.springframework.boot
  spring-boot-starter-data-redis
 
 
 
  org.apache.commons
  commons-lang3
  3.8.1
 
 
 
 
  com.google.guava
  guava
  30.0-jre
 
 
 
  cn.hutool
  hutool-core
  5.5.0
 

 
 
  org.projectlombok
  lombok
  true
 
 
 
  commons-collections
  commons-collections
  3.2
 
 
  com.baomidou
  spring-wind
  1.1.5
  
  
   com.baomidou
   mybatis-plus
  
  
 

 
  com.baomidou
  3.1.2
  mybatis-plus-boot-starter
 
 
  mysql
  mysql-connector-java
  5.1.44
 
 
  com.alibaba
  druid-spring-boot-starter
  1.1.10
 
 
 
  com.github.pagehelper
  pagehelper-spring-boot-starter
  1.2.12
 
 
  org.springframework.boot
  spring-boot-starter-test
  test
 

 

 
 
  
  org.springframework.boot
  spring-boot-maven-plugin
  
   
   
    repackage
   
   
  
  
 

 

yml

server:
 port: 8082
iot:
 mqtt:
 clientId: ${random.value}
 defaultTopic: topic
 shbykjTopic: shbykj_topic
 url: tcp://127.0.0.1:1883
 username: admin
 password: admin
 completionTimeout: 3000
#微信小程序相关参数
shbykjWeixinAppid: wxae343ca8948f97c4
shbykjSecret: 9e168c92702efc06cb12fa22680f049a

#spring
spring:
 devtools:
 restart:
 enabled: true
 main:
 allow-bean-definition-overriding: true
 # mysql DATABASE CONFIG
 datasource:
 druid:
 filters: stat,wall,log4j2
 continueOnError: true
 type: com.alibaba.druid.pool.DruidDataSource
 url: jdbc:mysql://localhost:3306/mqttdb&#63;useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezOne=UTC&allowPublicKeyRetrieval=true
 username: root
 password: 123456
 driver-class-name: com.mysql.jdbc.Driver
 # see https://github.com/alibaba/druid
 initialSize: 15
 minIdle: 10
 maxActive: 200
 maxWait: 60000
 timeBetweenEvictionRunsMillis: 60000
 validationQuery: SELECT 1
 testWhileIdle: true
 testOnBorrow: false
 testOnReturn: false
 poolPreparedStatements: true
 keepAlive: true
 maxPoolPreparedStatementPerConnectionSize: 50
 connectionProperties:
 druid.stat.mergeSql: true
 druid.stat.slowSqlMillis: 5000

shbykj:
 checkCrc: false
#mybatis
mybatis-plus:
 mapper-locations: classpath:/mapper/*.xml
 typeAliasesPackage: org.spring.springboot.entity
 global-config:
 #主键类型 0:"数据库ID自增", 1:"用户输入ID",2:"全局唯一ID (数字类型唯一ID)", 3:"全局唯一ID UUID";
 id-type: 3
 #字段策略 0:"忽略判断",1:"非 NULL 判断"),2:"非空判断"
 field-strategy: 2
 #驼峰下划线转换
 db-column-underline: true
 #刷新mapper 调试神器
 refresh-mapper: true
 configuration:
 map-underscore-to-camel-case: true
 cache-enabled: false
 #log4j打印sql日志
 log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
#logging
logging:
 config: classpath:log4j2-demo.xml

到此这篇关于springboot 实现mqtt物联网的文章就介绍到这了,更多相关springboot 实现mqtt物联网内容请搜索以前的文章或继续浏览下面的相关文章希望大家以后多多支持!


推荐阅读
  • 本文介绍了在开发Android新闻App时,搭建本地服务器的步骤。通过使用XAMPP软件,可以一键式搭建起开发环境,包括Apache、MySQL、PHP、PERL。在本地服务器上新建数据库和表,并设置相应的属性。最后,给出了创建new表的SQL语句。这个教程适合初学者参考。 ... [详细]
  • 本文介绍了使用cacti监控mssql 2005运行资源情况的操作步骤,包括安装必要的工具和驱动,测试mssql的连接,配置监控脚本等。通过php连接mssql来获取SQL 2005性能计算器的值,实现对mssql的监控。详细的操作步骤和代码请参考附件。 ... [详细]
  • 本文介绍了如何使用php限制数据库插入的条数并显示每次插入数据库之间的数据数目,以及避免重复提交的方法。同时还介绍了如何限制某一个数据库用户的并发连接数,以及设置数据库的连接数和连接超时时间的方法。最后提供了一些关于浏览器在线用户数和数据库连接数量比例的参考值。 ... [详细]
  • Centos7.6安装Gitlab教程及注意事项
    本文介绍了在Centos7.6系统下安装Gitlab的详细教程,并提供了一些注意事项。教程包括查看系统版本、安装必要的软件包、配置防火墙等步骤。同时,还强调了使用阿里云服务器时的特殊配置需求,以及建议至少4GB的可用RAM来运行GitLab。 ... [详细]
  • 在说Hibernate映射前,我们先来了解下对象关系映射ORM。ORM的实现思想就是将关系数据库中表的数据映射成对象,以对象的形式展现。这样开发人员就可以把对数据库的操作转化为对 ... [详细]
  • 如何用UE4制作2D游戏文档——计算篇
    篇首语:本文由编程笔记#小编为大家整理,主要介绍了如何用UE4制作2D游戏文档——计算篇相关的知识,希望对你有一定的参考价值。 ... [详细]
  • 使用在线工具jsonschema2pojo根据json生成java对象
    本文介绍了使用在线工具jsonschema2pojo根据json生成java对象的方法。通过该工具,用户只需将json字符串复制到输入框中,即可自动将其转换成java对象。该工具还能解析列表式的json数据,并将嵌套在内层的对象也解析出来。本文以请求github的api为例,展示了使用该工具的步骤和效果。 ... [详细]
  • 关于我们EMQ是一家全球领先的开源物联网基础设施软件供应商,服务新产业周期的IoT&5G、边缘计算与云计算市场,交付全球领先的开源物联网消息服务器和流处理数据 ... [详细]
  • 本文介绍了高校天文共享平台的开发过程中的思考和规划。该平台旨在为高校学生提供天象预报、科普知识、观测活动、图片分享等功能。文章分析了项目的技术栈选择、网站前端布局、业务流程、数据库结构等方面,并总结了项目存在的问题,如前后端未分离、代码混乱等。作者表示希望通过记录和规划,能够理清思路,进一步完善该平台。 ... [详细]
  • XML介绍与使用的概述及标签规则
    本文介绍了XML的基本概念和用途,包括XML的可扩展性和标签的自定义特性。同时还详细解释了XML标签的规则,包括标签的尖括号和合法标识符的组成,标签必须成对出现的原则以及特殊标签的使用方法。通过本文的阅读,读者可以对XML的基本知识有一个全面的了解。 ... [详细]
  • Java验证码——kaptcha的使用配置及样式
    本文介绍了如何使用kaptcha库来实现Java验证码的配置和样式设置,包括pom.xml的依赖配置和web.xml中servlet的配置。 ... [详细]
  • 本文介绍了Android 7的学习笔记总结,包括最新的移动架构视频、大厂安卓面试真题和项目实战源码讲义。同时还分享了开源的完整内容,并提醒读者在使用FileProvider适配时要注意不同模块的AndroidManfiest.xml中配置的xml文件名必须不同,否则会出现问题。 ... [详细]
  • MyBatis多表查询与动态SQL使用
    本文介绍了MyBatis多表查询与动态SQL的使用方法,包括一对一查询和一对多查询。同时还介绍了动态SQL的使用,包括if标签、trim标签、where标签、set标签和foreach标签的用法。文章还提供了相关的配置信息和示例代码。 ... [详细]
  • r2dbc配置多数据源
    R2dbc配置多数据源问题根据官网配置r2dbc连接mysql多数据源所遇到的问题pom配置可以参考官网,不过我这样配置会报错我并没有这样配置将以下内容添加到pom.xml文件d ... [详细]
  • 20211101CleverTap参与度和分析工具功能平台学习/实践
    1.应用场景主要用于学习CleverTap的使用,该平台主要用于客户保留与参与平台.为客户提供价值.这里接触到的原因,是目前公司用到该平台的服务~2.学习操作 ... [详细]
author-avatar
Leilani-lysbp_348
这个家伙很懒,什么也没留下!
PHP1.CN | 中国最专业的PHP中文社区 | DevBox开发工具箱 | json解析格式化 |PHP资讯 | PHP教程 | 数据库技术 | 服务器技术 | 前端开发技术 | PHP框架 | 开发工具 | 在线工具
Copyright © 1998 - 2020 PHP1.CN. All Rights Reserved | 京公网安备 11010802041100号 | 京ICP备19059560号-4 | PHP1.CN 第一PHP社区 版权所有