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