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/Shanghai
    username: root
    password: 123456
    driver-class-name: com.mysql.cj.jdbc.Driver
  jpa:
    show-sql: true
    properties:
      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 {
    @Autowired
    private UserRepository userRepository;
    @Test
    void 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 {
    @Autowired
    private UserRepository userRepository;
    @GetMapping("findAll")
    List<User> findAll(){
        return userRepository.findAll();
    }
}