SpringBoot+Vue实现用户管理（三）

创建SpringBoot项目

idea创建SpringBoot项目



目录结构

编写mysql
配置application.yml分别添加数据库连接、jpa、port

spring:datasource:url: jdbc:mysql://localhost:3306/demo01?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghaiusername: rootpassword: 123456driver-class-name: com.mysql.cj.jdbc.Driverjpa:show-sql: trueproperties:hibernate:format_sql: true
server:port: 8181


创建用户实体类

package com.xf.demo.entity;import lombok.Data;import javax.persistence.Entity;
import javax.persistence.Id;/*** @author xfgg*/
@Entity
@Data
public class User {@Id /**主键*/private Integer id;private String username;private String usersex;
}

创建UserRepository

package com.xf.demo.repository;import com.xf.demo.entity.User;
import org.springframework.data.jpa.repository.JpaRepository;public interface UserRepository extends JpaRepository<User,Integer> {
}

编写Test类

package com.xf.demo;import com.xf.demo.repository.UserRepository;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;@SpringBootTest
class DemoApplicationTests {@Autowiredprivate UserRepository userRepository;@Testvoid findAll() {System.out.println(userRepository.findAll());}}

没有数据因为还没添加

添加数据

这里建立一个UserController返回json数据

package com.xf.demo.controller;import com.xf.demo.entity.User;
import com.xf.demo.repository.UserRepository;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;import java.util.List;@RestController
@RequestMapping("/user")
public class UserController {@Autowiredprivate UserRepository userRepository;@GetMapping("findAll")List<User> findAll(){return userRepository.findAll();}
}