SpringBoot中Mybatis和Redis的使用

Mybatis的使用

• 项目结构

• 第一步导入依赖：

<dependencies>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-web</artifactId>
    </dependency>

    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-test</artifactId>
        <scope>test</scope>
    </dependency>

    <dependency>
        <groupId>org.projectlombok</groupId>
        <artifactId>lombok</artifactId>
        <version>1.18.6</version>
    </dependency>

    <dependency>
        <groupId>org.mybatis.spring.boot</groupId>
        <artifactId>mybatis-spring-boot-starter</artifactId>
        <version>2.0.0</version>
    </dependency>

    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
    </dependency>

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

    <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>druid</artifactId>
        <version>1.1.10</version>
    </dependency>


</dependencies>

• 第二步：修改SpringBoot配置文件application.yml

spring:
  datasource:
    url: jdbc:mysql://localhost:3306/springboot?serverTimezone=GMT%2B8
    username: root
    password: 123
    driver-class-name: com.mysql.cj.jdbc.Driver
    type: com.alibaba.druid.pool.DruidDataSource

• 第三步：创建实体bean User类

@Data
@AllArgsConstructor
@NoArgsConstructor
public class User {
    private Integer id;
    private String name;
    private Integer age;
}

• 第四步：创建Dao接口,使用mybatis注解

@Mapper
public interface UserDao {

    /**
     * 增加用户
     * @param user
     */
    @Insert("insert into user(name,age) value(#{name},#{age})")
    public void save(User user);

    /**
     * 修改用户
     * @param user
     */
    @Update("update user set name=#{name},age=#{age} where id=#{id}")
    void update(User user);

    /**
     * 根据id删除
     * @param id
     */
    @Delete("delete from user where id=#{id}")
    void delete(Integer id);

    /**
     * 查询所有用户
     * @return
     */
    @Select("select * from user")
    List<User> getAll();


    /**
     * 查询单个用户
     * @param id
     * @return
     */
    @Select("select * from user where id=#{id}")
    User getOne(Integer id);

}

• 第五步：创建Service接口：

public interface UserService {
    public void save(User user);
    void update(User user);
    void delete(Integer id);
    List<User> getAll();
    User getOne(Integer id);
}

• 第六步：创建Service实现类

@Service
public class UserServiceImpl implements UserService {
    @Autowired
    UserDao userDao;

    @Override
    public void save(User user) {
        userDao.save(user);
    }

    @Override
    public void update(User user) {
        userDao.update(user);
    }

    @Override
    public void delete(Integer id) {
        userDao.delete(id);
    }

    @Override
    public List<User> getAll() {
        List<User> all = userDao.getAll();
        return all;
    }

    @Override
    public User getOne(Integer id) {
        User one = userDao.getOne(id);
        return one;
    }
}

• 第七步：创建Controller：

@RestController
@RequestMapping("/user")
public class UserController {
    @Autowired
    UserService userService;

    @GetMapping("/")
    public List<User> getAll(){
       return userService.getAll();
    }

    @GetMapping("/{id}")
    public User getOne(@PathVariable("id") Integer id){
        return userService.getOne(id);
    }
    @PostMapping("/")
    public Map save(@RequestBody User user){
        userService.save(user);
        Map map=new HashMap();
        map.put("success",true);
        map.put("meassge","增加成功");
        return map;
    }

    @DeleteMapping("/{id}")
    public Map delete(@PathVariable("id") Integer id){
        userService.delete(id);
        Map map=new HashMap();
        map.put("success",true);
        map.put("meassge","删除成功");
        return map;
    }

    @PutMapping("/")
    public Map update(@RequestBody User user){
        userService.update(user);
        Map map=new HashMap();
        map.put("success",true);
        map.put("meassge","修改成功");
        return map;
    }



}

• 第八步：修改SpringBoot程序主启动类，增加扫描dao接口：

@SpringBootApplication
@MapperScan("com.offcn.springbootmybatis.dao")
public class SprimngbootMybatisApplication {

    public static void main(String[] args) {
        SpringApplication.run(SprimngbootMybatisApplication.class, args);
    }

}

SpringBoot使用Redis

SpringBoot使用Redis十分简单。

• 首先开启远程Redis远程连接，可以远程访问
• 第一步:添加启动器(增加依赖)：
  
• 第二部，修改配置文件：