MyBatis与SpringBoot整合案例（一）

导入依赖

<dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <!--引入springboot-mybatis的依赖 -->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.1.1</version>
        </dependency>
        <!--MySQL的依赖-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.32</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-tomcat</artifactId>
        </dependency>
        <!-- 引入springboot-mybatis的依赖 -->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.1.1</version>
        </dependency>

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

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.32</version>
        </dependency>
        <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>
            <exclusions>
                <exclusion>
                    <groupId>org.junit.vintage</groupId>
                    <artifactId>junit-vintage-engine</artifactId>
                </exclusion>
            </exclusions>
        </dependency>
    </dependencies>

配置文件

spring:
  datasource:
    username: root #必须以空格间隔
    password: 123
    url: jdbc:mysql:///invoicingsystem
    driver-class-name: com.mysql.jdbc.Driver
  profiles:
    active: test
  thymeleaf:
    cache: false
    encoding: UTF-8


mybatis:
  mapper-locations: mapper/*.xml

数据表

 

 实体类

public class User {
    private Integer uid;
    private String userName;
    private String password;
    private String realName;

    public Integer getUid() {
        return uid;
    }

    public void setUid(Integer uid) {
        this.uid = uid;
    }

    public String getUserName() {
        return userName;
    }

    public void setUserName(String userName) {
        this.userName = userName;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public String getRealName() {
        return realName;
    }

    public void setRealName(String realName) {
        this.realName = realName;
    }

}

Dao层

import java.util.List;
@Repository("userdao")
public interface UserDao {

    //查看
    List<User> getAll();
}

Service层

public interface UserService {
    //查看
    List<User> getAll();
}

ServiceImpl层

@Service("userservice")
public class UserServiceImpl implements UserService {
    @Resource(name = "userdao")
    private UserDao userDao;

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

Controller

@Controller
public class ViewController {

    @RequestMapping("/ssIndex")
    public String toIndex(Model model){
        model.addAttribute("username","张三");
        model.addAttribute("sex",0);
        return "index";
    }
}

运行结果