- 导入依赖
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.1.1</version>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
- 编写接口
@Mapper
@Repository
public interface UserMapper {
List<User> getalluser();
User getUserbyID(int id);
int addUser(User user);
int updateUser(User user);
int deleteUser(int id);
}
- 实现接口
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.example.demo.mapper.UserMapper">
<select id="getalluser" resultType="User">
select * from mybatis.user
</select>
<select id="getUserbyID" resultType="User">
select * from mybatis.user where id=#{id}
</select>
<select id="addUser" resultType="User">
insert into mybatis.user(id, name, pwd) VALUES(#{id},#{name},#{pwd})
</select>
<select id="updateUser" resultType="User">
update mybatis.user set name=#{name},pwd=#{pwd} where id=#{id}
</select>
<select id="deleteUser" parameterType="int">
delete from mybatis.user where id=#{id}
</select>
</mapper>
4.配置文件
mybatis.mapper-locations=classpath:mybatis/*.xml
mybatis.type-aliases-package=com.example.demo.pojo
5.Controller 调用
@RestController
public class UserController {
@Autowired
private UserMapper userMapper;
@GetMapping("/getalluser")
public List<User> getalluser(){
for (User user : userMapper.getalluser()) {
System.out.println(user);
}
return userMapper.getalluser();
}
}
实体类
@AllArgsConstructor
@NoArgsConstructor
@Data
public class User {
private int id;
private String name;
private String pwd;
}
