Springboot整合Mybatis实现简单CRUD

目录

1.开发环境

2首先创建一个springboot项目

3.项目结构

3.1添加数据

3.2查询数据

3.3修改数据：

3.4删除数据：

---

附上项目代码Githup地址：https://github.com/liuxianzhi/springboot

1.开发环境

windows-10

springboot-2.0.5

maven-3.5.4

mysql-8.0.11

jdk-8

 

2首先创建一个springboot项目

 

 

 

3.项目结构

实体类User.java

package com.demo.entity;
import org.springframework.stereotype.Component;

@Component
public class User {
    private Integer id;
    private String username;
    private String password;

    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;
    }

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

 Dao层UserMapper.java

package com.demo.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;

import com.demo.entity.User;

import java.util.List;

@Repository
@Mapper
public interface UserMapper {
    User getUserById(Integer id);

    List<User> listAll();

    void addUser(User user);

    boolean updateUser(User user);

    boolean deleteUser(Integer id);

}

Service层以及实现类

package com.demo.service;


import com.demo.entity.User;

import java.util.List;

public interface UserService {
    User getUserById(Integer id);

    List<User> listAll();

    void addUser(User user);

    boolean updateUser(User user);

    boolean deleteUser(Integer id);
}

package com.demo.service.impl;

import com.demo.entity.User;
import com.demo.mapper.UserMap