springboot整合mybatis纯注解

项目结构

首先我们先创建一个项目这里用的是创建的快捷方式

然后

接着

再接着

最后

创建一张user表,具体的建表语句就不写了

创建对应的实体类，并提供get,set方法

private Integer id;
private String username;
private String password;
private String address;
private String phone;

public Integer getId() {
    return id;
}

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

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 getAddress() {
    return address;
}

public void setAddress(String address) {
    this.address = address;
}

public String getPhone() {
    return phone;
}

public void setPhone(String phone) {
    this.phone = phone;
}

@Override
public String toString() {
    return "User{" +
            "id=" + id +
            ", username='" + username + '\'' +
            ", password='" + password + '\'' +
            ", address='" + address + '\'' +
            ", phone='" + phone + '\'' +
            '}';
}

创建mapper接口（持久层dao）
@Mapper注解的的作用

1:为了把mapper这个DAO交給Spring管理
2:为了不再写mapper映射文件

@Repository
@Mapper
public interface UserDao {

@Select("SELECT * FROM USER")
List<User> findAll();

}
最后在application.properties/application.yml核心配置文件中配置数据源

spring.datasource.driverClassName=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf8
spring.datasource.username=root
spring.datasource.password=123123
最后我们写个controller来测试一下

@Controller
public class UserContrller {

@Autowired
private UserDao userDao;

@RequestMapping("/findAll")
@ResponseBody
public List<User> findAll(){
    List<User> list = userDao.findAll();
    return list;
}

}
最后启动引导类，一定要记住在引导类上加@MapperScan扫描mapper接口的所在包

@SpringBootApplication
@MapperScan(basePackages = “com.itheima.spring_demo.dao”)
public class SpringDemoApplication {

public static void main(String[] args) {

	SpringApplication.run(SpringDemoApplication.class, args);
}

}