springboot整合mybatis

上次继了解了一下JPA的整合，怎么少得了最流行的mybatis的呢。我个人也是mybatis的忠实粉。现在来看看如何整合。

1.添加必须的依赖

<!-- mybatis -->
<dependency>
   <groupId>org.mybatis.spring.boot</groupId>
   <artifactId>mybatis-spring-boot-starter</artifactId>
       <version>1.3.2</version>
</dependency>
<dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>6.0.6</version>
</dependency>

记得在启动类添加

@SpringBootApplication
@MapperScan("yick.demo.springboot.dao")
public class SpringbootMybatis01Application {

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

}

UserDao类

package yick.demo.springboot.dao;

import java.util.List;

import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;

import yick.demo.springboot.entity.User;

public interface UserDao {

    @Select("select * from user where id=#{id}")
    User findById(String id);

    @Select({ "<script>", "select * from user where " + "<if test='name!=null'>" + " name=#{name}" + "</if>",
            "</script>" })
    List<User> findList(User user);

    @Insert(value = { "insert into user(id,name,age) values(#{id},#{name},#{age})" })
    Integer insert(User user);
}

User类

package yick.demo.springboot.entity;

public class User {

   private String name;

   private Integer age;

   private String id;

   public User() {
   }

   public User(String id, String name, int age) {
       this.id = id;
       this.name = name;
       this.age = age;
   }

   public String getName() {
       return name;
   }

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

   public Integer getAge() {
       return age;
   }

   public void setAge(Integer age) {
       this.age = age;
   }

   public String getId() {
       return id;
   }

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

UserService类

package yick.demo.springboot.service;

import java.util.List;

import yick.demo.springboot.entity.User;

public interface UserService {

   public User findById(String id);

   public List<User> findList(User user);

   public Integer insert(User user);

}

UserController类

package yick.demo.springboot.web;

import java.util.List;
import java.util.UUID;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RestController;

import com.alibaba.fastjson.JSON;

import yick.demo.springboot.entity.User;
import yick.demo.springboot.service.UserService;

@RestController
public class UserController {

    @Autowired
    private UserService userService;

    @GetMapping(value = "info/{id}")
    public String info(@PathVariable String id) {
        User user = userService.findById(id);
        return JSON.toJSONString(user);
    }

    @GetMapping(value = "list")
    public String list(User user) {

        List<User> list = userService.findList(user);
        return JSON.toJSONString(list);
    }

    @GetMapping(value = "add")
    public String add(User user) {
        user.setId(UUID.randomUUID().toString());
        Integer result = userService.insert(user);
        return JSON.toJSONString(result);
    }
}

是不是相当简单，另外mybatis的一些语法以及xml映射可以自己去尝试。这里就不多解了。

有你的支持，我会更努力哦！！！.jpg