SpringBoot2 MyBatis集成RabbitMQ消息队列

在Spring Boot 2中集成MyBatis和RabbitMQ消息队列，你需要完成以下几个步骤：

1. 添加依赖

在你的pom.xml文件中添加以下依赖：

<!-- Spring Boot Starter Web -->
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-web</artifactId>
</dependency>

<!-- Spring Boot Starter MyBatis -->
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-mybatis</artifactId>
</dependency>

<!-- Spring Boot Starter RabbitMQ -->
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-amqp</artifactId>
</dependency>

2. 配置RabbitMQ

在application.yml或application.properties文件中配置RabbitMQ连接信息：

spring:
  rabbitmq:
    host: localhost
    port: 5672
    username: guest
    password: guest
    virtual-host: /

3. 创建RabbitMQ配置类

创建一个配置类，用于初始化RabbitMQ的连接工厂和消息模板：

@Configuration
public class RabbitMQConfig {

    @Bean
    public ConnectionFactory connectionFactory() {
        CachingConnectionFactory connectionFactory = new CachingConnectionFactory();
        connectionFactory.setHost("localhost");
        connectionFactory.setPort(5672);
        connectionFactory.setUsername("guest");
        connectionFactory.setPassword("guest");
        connectionFactory.setVirtualHost("/");
        return connectionFactory;
    }

    @Bean
    public RabbitTemplate rabbitTemplate() {
        return new RabbitTemplate(connectionFactory());
    }
}

4. 创建MyBatis配置类

创建一个配置类，用于初始化MyBatis的SqlSessionFactory和Mapper扫描器：

@Configuration
@MapperScan("com.example.demo.mapper")
public class MyBatisConfig {

    @Bean
    public SqlSessionFactory sqlSessionFactory(DataSource dataSource) throws Exception {
        SqlSessionFactoryBean factoryBean = new SqlSessionFactoryBean();
        factoryBean.setDataSource(dataSource);
        return factoryBean.getObject();
    }
}

5. 创建消息生产者

创建一个生产者类，用于发送消息到RabbitMQ队列：

@Service
public class MessageProducer {

    @Autowired
    private RabbitTemplate rabbitTemplate;

    public void sendMessage(String exchange, String routingKey, Object message) {
        rabbitTemplate.convertAndSend(exchange, routingKey, message);
    }
}

6. 创建消息消费者

创建一个消费者类，用于从RabbitMQ队列接收消息并处理：

@Service
public class MessageConsumer {

    @RabbitListener(queues = "myQueue")
    public void receiveMessage(String message) {
        System.out.println("Received message: " + message);
        // 处理消息的逻辑
    }
}

7. 创建Mapper接口和映射文件

创建一个Mapper接口，用于定义数据库操作方法：

public interface UserMapper {
    User getUserById(Long id);
}

创建一个映射文件UserMapper.xml，用于定义SQL语句和映射关系：

<?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.example.demo.mapper.UserMapper">
    <select id="getUserById" resultType="com.example.demo.entity.User">
        SELECT * FROM user WHERE id = #{id}
    </select>
</mapper>

8. 创建实体类

创建一个实体类User，用于映射数据库表：

public class User {
    private Long id;
    private String name;
    private Integer age;

    // 省略getter和setter方法
}

现在你已经成功地在Spring Boot 2中集成了MyBatis和RabbitMQ消息队列。你可以根据实际需求进行相应的调整和扩展。