springboot整合springjpa

首先我们引入jar
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
        </dependency>

 

配置数据源
spring.datasource.url=jdbc:mysql://ip:port/geex
spring.datasource.username=
spring.datasource.password=
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
model
package com.tzp.springjpa.model;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;

@Table(name = "user")
@Entity(name = "users")
public class UserEntity {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Integer id;

    @Column(name = "name")
    private String name;

    @Column(name = "age")
    private Integer age;

    public Integer getId() {
        return id;
    }

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

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public Integer getAge() {
        return age;
    }

    public void setAge(Integer age) {
        this.age = age;
    }

}
dao
package com.tzp.springjpa.dao;

import org.springframework.data.jpa.repository.JpaRepository;

import com.tzp.springjpa.model.UserEntity;

public interface UserDao extends JpaRepository<UserEntity, Integer>{
}
controller
package com.tzp.springjpa.controller;

import java.util.Optional;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import com.tzp.springjpa.dao.UserDao;
import com.tzp.springjpa.model.UserEntity;

@RestController
public class IndexController {

    @Autowired
    private UserDao userDao;
    
    @RequestMapping("/jpaIndex")
    public Object jpaIndex(UserEntity user) {
        userDao.saveAndFlush(user);
        Optional<UserEntity> optional = userDao.findById(user.getId());
        UserEntity userEntity = optional.get();
        return userEntity == null?"存储数据失败！":userEntity;
    }
}

 

SRE实战 互联网时代守护先锋，助力企业售后服务体系运筹帷幄！一键直达领取阿里云限量特价优惠。 
 
扫码关注我们
微信号：SRE实战
拒绝背锅 运筹帷幄