Springboot 完美整合 JPA

引入依赖

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
        </dependency>

properties文件配置信息

 jpa:
    database: mysql
    database-platform: org.hibernate.dialect.MySQL5InnoDBDialect
    hibernate:
      ddl-auto: update
    show-sql: true
   

Java代码

• dao层

package com.study.dao;

import com.study.entity.User;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.stereotype.Component;

/**
 * User 实体类 也称PO
 * Integer  实体类主键类型
 * @author honor
 */
@Component
public interface UserRepository extends JpaRepository<User,Integer>, JpaSpecificationExecutor<User>{

}

• service

package com.study.service;

import com.study.entity.User;

/**
 * @author honor
 */
public interface UserService {
    public User save(User user);
    public User update(User user);
    public User selectUserById(Integer id);
    public void delete(Integer id);
    public void deleteBatch(User user);
    public User findById(Integer id);
}

package com.study.service.impl;

import com.study.dao.UserRepository;
import com.study.entity.User;
import com.study.service.UserService;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;
import java.util.Optional;

/**
 * @author honor
 */
@Service
public class UserServiceImpl implements UserService {
    @Resource
    private UserRepository userRepository;
    @Override
    public User save(User user) {
        return userRepository.save(user);
    }

    @Override
    public User update(User user) {
        return  userRepository.save(user);
    }

    @Override
    public User selectUserById(Integer id) {
        return userRepository.getOne(id);
    }

    @Override
    public void delete(Integer id) {
        userRepository.deleteById(id);

    }

    @Override
    public void deleteBatch(User user) {
         userRepository.delete(user);
    }

    @Override
    public User findById(Integer id) {
        Optional<User> user = userRepository.findById(id);
        return   user.get();
    }
}

• controller

package com.study.controller;

import com.study.entity.User;
import com.study.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RestController;

/**
 * @author honor
 */
@RestController
public class UserController {
    @Autowired
    private UserService userService;



    @GetMapping("findById")
    public User findById(int id){
      return   userService.findById(id);
    }
}

测试结果