spring boot 整合 mybatis 添加、查询

1、创建数据库 java-test

2、新建表 users

CREATE TABLE `users` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `age` tinyint NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8

3、mod.xml 文件添加整合信息

		<!--  	springBoot整合 mybatis 模板	-->
		<dependency>
			<groupId>org.mybatis.spring.boot</groupId>
			<artifactId>mybatis-spring-boot-starter</artifactId>
			<version>1.1.1</version>
		</dependency>

4、application.yml 文件添加配置信息

spring:
  datasource:
    url: jdbc:mysql://localhost:3306/java-test
    password: root
    username: root
    driver-class-name: com.mysql.jdbc.Driver

5、添加代码

@RestController
public class UserService {

    @Autowired
    private UserMapper userMapper;
    
    @RequestMapping("/mybatisFindById")
    public UserEntity mybatisFindById(Integer id) {
        return userMapper.selectByUserId(id);
    }


    @RequestMapping("/mybatisInsert")
    public String mybatisInsert(String userName, Integer age) {
        int insert = userMapper.insertUser(userName,age);
        if(insert > 0){
            return "success";
        }
        return "Fail";
    }

}

6、添加 UserMapper

public class UserEntity {
    private String userName;
    private Integer age;
    private Integer id;

    public UserEntity( Integer id, String userName, Integer age ){
        this.userName = userName;
        this.age = age;
        this.id = id;
    }

    public UserEntity( String userName, Integer age ){
        this.userName = userName;
        this.age = age;
    }

    public String getUserName() {
        return userName;
    }

    public Integer getAge(){
        return age;
    }

    public Integer getId() {
        return id;
    }

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

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

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