当然首先要有对应实体和数据库
创建class user
然后去usermapper声明一个方法
List<User> listAll();
然后去写出resource的mapper-usermapper.xml写出这个sql
<?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.mpdemo.mapper.UserMapper">
<select id="listAll" resultType="com.example.mpdemo.entity.User">
select * from t_user
</select>
</mapper>
然后使用这个方法
@GetMapping("/testxml")
public List<User> selectAll(){
return userMapper.listAll();
}