使用idea新建spingboot+mybatis项目

废话不多说，步骤如下

1、新建springboot项目，具体步骤可参考我之前的博客。注意选择插件的过程选择如下三个，web、mysql、mybatis。

 

 

2、添加相关的包路径，具体如下图所示

3、application.properties配置文件中添加如下信息

mybatis.type-aliases-package=com.mywork.springboot_mybatisdemo.entity

spring.datasource.driverClassName = com.mysql.jdbc.Driver
spring.datasource.url = jdbc:mysql://localhost:3306/jdy?useUnicode=true&characterEncoding=utf-8
spring.datasource.username = test
spring.datasource.password = 1

其中第一行表示需要扫描的实体的宝路径，其他为mysql的连接设置。

4、在启动类添加扫描mapper的注释，如下

@MapperScan("com.mywork.springboot_mybatisdemo.dao")

5、编写dao层类如下

package com.mywork.springboot_mybatisdemo.dao;

import com.mywork.springboot_mybatisdemo.entity.User;
import org.apache.ibatis.annotations.Select;

/**
 * @Desc
 * @Author lililiang
 * @Date 2017/10/18 22:35
 **/

@Mapper
public interface UserDao {
    @Select("select * from sys_user")
    public User selectAll();
}

编写entity如下

package com.mywork.springboot_mybatisdemo.entity;

/**
 * @Desc
 * @Author lililiang
 * @Date 2017/10/18 22:36
 **/
public class User {

    private String userName;
    private String password;

    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;
    }
}
编写controller如下

package com.mywork.springboot_mybatisdemo.controller;

import com.mywork.springboot_mybatisdemo.dao.UserDao;
import com.mywork.springboot_mybatisdemo.entity.User;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import java.util.ArrayList;
import java.util.List;

/**
 * @Desc
 * @Author lililiang
 * @Date 2017/10/18 22:39
 **/
@RestController
public class UserController {

    @Autowired
    private UserDao userDao;

    @RequestMapping(value = "selectall")
    public void selectAll(){
        List<User> user = userDao.selectAll();
        for (User u: user) {
            System.out.println(u.getUserName()+">>>>>"+u.getPassword());
        }
    }
}
（@Autowired部分会有错误提示，可以忽略）

6、启动项目,访问地址，控制台打印出数据库中查询的信息