springboot mybatis redis项目

### Spring Boot、MyBatis和Redis整合示例项目教程

#### 配置环境准备
为了实现Spring Boot、MyBatis以及Redis的集成，首先需要创建一个新的Spring Boot项目[^3]。

<dependencies>
    <!-- MyBatis Starter -->
    <dependency>
        <groupId>org.mybatis.spring.boot</groupId>
        <artifactId>mybatis-spring-boot-starter</artifactId>
        <version>2.2.0</version>
    </dependency>

    <!-- Redis Starter -->
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-data-redis</artifactId>
    </dependency>

    <!-- MySQL Connector (或其他数据库驱动) -->
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <scope>runtime</scope>
    </dependency>
    
    <!-- Other dependencies... -->
</dependencies>

#### 数据源配置
在`application.yml`文件中定义MySQL的数据源属性：

spring:
  datasource:
    url: jdbc:mysql://localhost:3306/your_database?useSSL=false&serverTimezone=UTC
    username: root
    password: your_password
    driver-class-name: com.mysql.cj.jdbc.Driver
    
  redis:
    host: localhost
    port: 6379

#### Redis配置类
针对Redis部分，在Java代码里设置相应的Bean以便于后续的操作。这里采用的是Lettuce作为客户端库来访问Redis实例[^1]。

@Configuration
public class RedisConfig {

    @Value("${spring.redis.host}")
    private String redisHost;

    @Value("${spring.redis.port}")
    private int redisPort;

    @Bean
    public LettuceConnectionFactory lettuceConnectionFactory() {
        RedisSentinelConfiguration sentinelConfig = new RedisSentinelConfiguration()
            .master("mymaster") // 主节点名称
            .sentinel(redisHost, redisPort); // 哨兵地址
            
        return new LettuceConnectionFactory(sentinelConfig);
    }

    @Bean
    public RedisTemplate<String, Object> redisTemplate(LettuceConnectionFactory factory){
        final RedisTemplate<String, Object> template = new RedisTemplate<>();
        template.setKeySerializer(new StringRedisSerializer());
        template.setValueSerializer(new GenericJackson2JsonRedisSerializer());
        template.setConnectionFactory(factory);
        return template;
    }
}

#### MyBatis映射接口和服务层
对于持久化逻辑，则利用MyBatis提供的Mapper接口完成SQL语句封装；而业务处理则交由Service组件负责调用这些方法并返回给控制器层。

// UserMapper.java
@Mapper
public interface UserMapper {
    List<User> findAll();
}

// UserService.java
@Service
public class UserService {
  
    @Autowired
    private UserMapper userMapper;

    public List<User> getAllUsers(){
        return this.userMapper.findAll();
    }
}

#### 控制器层
最后构建RESTful API端点用于接收HTTP请求并向前端展示查询结果。

@RestController
@RequestMapping("/api/users")
public class UserController {

    @Autowired
    private UserService userService;

    @GetMapping("")
    public ResponseEntity<List<User>> getUsers() {
        try{
            List<User> users = userService.getAllUsers();
            if(users.isEmpty()){
                return new ResponseEntity<>(HttpStatus.NO_CONTENT);
            }else{
                return new ResponseEntity<>(users, HttpStatus.OK);
            }
        }catch(Exception e){
            return new ResponseEntity<>(null, HttpStatus.INTERNAL_SERVER_ERROR);
        }
    }
}