Springboot 整合jpa的使用

spring:
  datasource:
    url: jdbc:mysql://192.168.3.193/jpa
    username: root
    password: shiye
    driver-class-name: com.mysql.jdbc.Driver
  jpa:
    hibernate:
      ddl-auto: update  # 更新或者穿件数据库表
    show-sql: true  #打印sql

package com.shi.data.model;

import javax.persistence.*;

//使用JPA注解配置映射关系
@Entity//标识这是一个实体对象
@Table(name = "tbl_user")//和数据库中的表名进行对应
public class User {

    @Id //这是一个主键
    @GeneratedValue(strategy = GenerationType.IDENTITY)//自增主键
    private Integer id;

    @Column(name = "last_name" ,length = 50)//列名和属性名一一对应
    private String lastName;

    @Column(name = "email",length = 50)
    private String email;

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getLastName() {
        return lastName;
    }

    public void setLastName(String lastName) {
        this.lastName = lastName;
    }

    public String getEmail() {
        return email;
    }

    public void setEmail(String email) {
        this.email = email;
    }
}

package com.shi.data.respository;

import com.shi.data.model.User;
import org.springframework.data.jpa.repository.JpaRepository;

//继承 JpaRepository 来完成基本的 crud操作
public interface UserRespository  extends JpaRepository<User,Integer>{



}

package com.shi.data.controller;

import com.shi.data.model.User;
import com.shi.data.respository.UserRespository;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RestController;

@RestController
public class JpaController {

    @Autowired
    UserRespository userRespository;

    //根据id查询单个用户
    @GetMapping("/user/{id}")
    public User getUser(@PathVariable("id") Integer id){
        User one = userRespository.findOne(id);
        return one;
    }

    //添加用户
    @GetMapping("/user")
    public User saveUser(User user){
        User one = userRespository.save(user);
        return one;
    }

}