目录
一、整合mysql
1、在pom中导入依赖
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.25</version>
</dependency>
2、在application.yml文件中编写配置
spring: #mysql配置 datasource: username: root password: admin driver-class-name: com.mysql.jdbc.Driver url: jdbc:mysql://localhost:3306/数据库名称?useSSL=false&useUnicode=true&characterEncoding=UTF8&serverTimezone=GMT
- username: 数据库的用户名
- password: 数据库的密码
- driver-class-name: mysql的驱动(这里是5.7版本,8.0版本是com.mysql.cj.jdbc.Driver)
- url:mysql的url
二、整合MyBatisPlus
1、在pom中导入依赖
<!--mybatisPlus依赖-->
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.2.0</version>
</dependency>
2、在application.yml文件中编写配置
mybatis-plus: configuration: log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
- log-impl: 进行日志配置
3、在启动类下添加扫描包注解@MapperScan("com.qi.mapper")
注意: 圈起来的这里的建包不能用com.qi.mapper, 要用com/qi/mapper
4、mapper.xml内容
- namespace: mapper.xml文件对应的Mapper接口的位置
- id: Mapper接口中定义的方法的名称
- parameterType: Mapper接口中定义的方法的参数的类型
- resultType: Mapper接口中定义的方法的返回值的类型
<?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="com.qi.mapper.UserMapper">
<select id="getById" parameterType="int" resultType="com.qi.entity.User">
SELECT * FROM user WHERE id=#{id}
</select>
</mapper>
5、配置分页插件
package com.qi.config;
import com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
@Configuration
public class MyBatisPlusConfig {
@Bean
public PaginationInterceptor paginationInterceptor(){
PaginationInterceptor paginationInterceptor = new PaginationInterceptor();
return paginationInterceptor;
}
}
三、读取yml配置文件数据
1、创建实体类读取
1、导入支持@ConfigurationProperties注解的依赖
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-configuration-processor</artifactId>
<version>2.6.3</version>
</dependency>
2、查看yml文件里的参数进行调用 ,我配置文件下的自定义参数如下所示
server:
port: 8080
spring:
mqtt:
username: admin
password: public
host-url: tcp://127.0.0.1:1883
client-id: mqtt-demo${random.value}
topic: topic/demo
3、新建一个实体类,来调用这些参数
注意:
- @ConfigurationProperties注解好像要放在config包下,不然会有红波浪线
- prefix里的内容是在yml文件中的前缀
- xxx-yyy好像可以映射为xxxYyy
- 要放进Bean用@Component注解来放在Bean容器内
我这里使用lombok来自动生成Setting和Getting方法
package com.qi.mqtt.config;
import lombok.Data;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.stereotype.Component;
@Component
@Data
@ConfigurationProperties(prefix = "spring.mqtt")
public class MqttProperties {
private String username;
private String password;
private String hostUrl;
private String clientId;
private String topic;
}
3、使用这个类里的参数,直接把实体类注入进来,然后get就可以了
package com.qi.mqtt.controller;
import com.qi.mqtt.config.MqttProperties;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RestController;
@RestController
public class MQTTController {
@Autowired
private MqttProperties mqttProperties;
@GetMapping("test")
public void MQTTtest(){
String username = mqttProperties.getUsername();
String clientId = mqttProperties.getClientId();
System.out.println(username); // admin
System.out.println(clientId); // mqtt-demoec3ad25ebfc378540196775a6b07f209
}
}
2、在普通类中定义
通过@Value()注解来赋值
注意:
- 不要用static修饰参数,不然注解不起作用
package com.qi.mqtt.controller;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RestController;
@RestController
public class MQTTController {
@Value("${spring.mqtt.username}")
String username;
@Value("${spring.mqtt.client-id}")
String clientId;
@GetMapping("test")
public void MQTTtest(){
System.out.println(username); // admin
System.out.println(clientId); // mqtt-demoec3ad25ebfc378540196775a6b07f209
}
}
四、开启定时任务
1、首先在启动类上添加@EnableScheduling来开启定时任务
@SpringBootApplication
@MapperScan("com.inspur.mapper")
@EnableScheduling
public class LightDemoApp {
public static void main(String[] args) {
SpringApplication.run(LightDemoApp.class, args);
}
}
二、在想要开启定时任务的地方添加 @Scheduled()注解, cron的值是怎样的定时任务,我这里是每10分钟执行一次,这样定时任务就完成了
在线Cron表达式生成器通过这个生成器,您可以在线生成任务调度比如Quartz的Cron表达式,对Quartz Cron 表达式的可视化双向解析和生成.https://cron.qqe2.com/
@Scheduled(cron = "0 0/10 * * * ? ")
@GetMapping("/getDevice")
public Result getDevice(){
return deviceService.getDevice();
}
五、整合MongoDB
1、导入pom依赖
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-mongodb</artifactId>
</dependency>
注意:
- 要先导入<parent>不然可能有jar包重复
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.1.5.RELEASE</version>
</parent>
2、yml中进行mongo的配置,因为我的mongo没有设账号、密码,所以不需要
spring:
data:
mongodb:
host: 127.0.0.1 // Mongo数据库的ip
port: 27017 // 端口号 默认为27017
database: light_demo // 数据库的名称
3、注入MongoTemplate, 进行编写就可以了
六、整合Minio
1、导入pom依赖,minion需要依赖okhttp,所以也需要导入okhttp依赖。
<!-- https://mvnrepository.com/artifact/io.minio/minio -->
<dependency>
<groupId>io.minio</groupId>
<artifactId>minio</artifactId>
<version>8.0.3</version>
</dependency>
<!-- https://mvnrepository.com/artifact/com.squareup.okhttp3/okhttp -->
<dependency>
<groupId>com.squareup.okhttp3</groupId>
<artifactId>okhttp</artifactId>
<version>4.9.3</version>
</dependency>