在新建模板时,选择的是:
完成之后,目录结构设置为:
测试代码:
application.yml文件内容:
server:
port: 8081
#msql的信息
spring:
datasource:
url: jdbc:mysql://localhost:3306/xiaobai
driver-class-name: com.mysql.cj.jdbc.Driver
username: root
password: 111111
User中内容:
@Data
public class User {
private int id;
private String username;
private String nickname;
private String email;
private String address;
private String phone;
}
UserMapper:
@Mapper
public interface UserMapper {
@Select("select * from user")
List<User> findAll_z();
}
UserController:
@RestController
public class UserController {
@Autowired
private UserMapper usermapper;
@GetMapping("/")
public List<User> index(){
return usermapper.findAll_z();
}
}
在浏览器中输入:
localhost:8081
页面出现数据即可。