SpringBoot H2數(shù)據(jù)庫

package com.nhooo.controller;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.DeleteMapping;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RestController;
import com.nhooo.model.Student;
import com.nhooo.service.StudentService;
//creating RestController
@RestController
public class StudentController 
{
    //自動(dòng)裝配 StudentService 類
    @Autowired
    StudentService studentService;
    //創(chuàng)建從數(shù)據(jù)庫檢索所有學(xué)生詳細(xì)信息的get映射
    @GetMapping("/student")
    private List<Student> getAllStudent() 
    {
        return studentService.getAllStudent();
    }
    //創(chuàng)建檢索特定學(xué)生詳細(xì)信息的get映射
    @GetMapping("/student/{id}")
    private Student getStudent(@PathVariable("id") int id) 
    {
        return studentService.getStudentById(id);
    }
    //創(chuàng)建刪除映射，刪除特定的學(xué)生
    @DeleteMapping("/student/{id}")
    private void deleteStudent(@PathVariable("id") int id) 
    {
        studentService.delete(id);
    }
    //創(chuàng)建在數(shù)據(jù)庫中發(fā)布學(xué)生詳細(xì)信息的post映射
    @PostMapping("/student")
    private int saveStudent(@RequestBody Student student) 
    {
    studentService.saveOrUpdate(student);
    return student.getId();
    }
}

package com.nhooo.service;
import java.util.ArrayList;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.nhooo.model.Student;
import com.nhooo.repository.StudentRepository;
@Service
public class StudentService 
{
    @Autowired
    StudentRepository studentRepository;
    //獲取所有學(xué)生記錄
    public List<Student> getAllStudent() 
    {
    List<Student> students = new ArrayList<Student>();
    studentRepository.findAll().forEach(student -> students.add(student));
    return students;
    }
    //獲取特定記錄
    public Student getStudentById(int id) 
    {
    return studentRepository.findById(id).get();
    }
    public void saveOrUpdate(Student student) 
    {
    studentRepository.save(student);
    }
    //刪除特定記錄
    public void delete(int id) 
    {
    studentRepository.deleteById(id);
    }
}

package com.nhooo.repository;
import org.springframework.data.repository.CrudRepository;
import com.nhooo.model.Student;
public interface StudentRepository extends CrudRepository<Student, Integer>
{
}

spring.datasource.url=jdbc:h2:mem:nhooo
spring.datasource.driverClassName=org.h2.Driver
spring.datasource.username=sa
spring.datasource.password=
spring.jpa.database-platform=org.hibernate.dialect.H2Dialect
#啟用H2
consolespring.h2.console.enabled=true

package com.nhooo;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
@SpringBootApplication
public class SpringBootH2DatabaseExampleApplication 
{
    public static void main(String[] args) 
    {
        SpringApplication.run(SpringBootH2DatabaseExampleApplication.class, args);
    }
}

{
    "id": "001",
    "age": "23",
    "name": "Amit",
    "email": "amit@yahoo.co.in"
}

{"id": "002","age": "24","name": "Vadik","email": "vadik@yahoo.co.in"
} 
{
    "id": "003",
    "age": "21",
    "name": "Prateek",
    "email": "prateek@yahoo.co.in"
} 
{
    "id": "004",
    "age": "25",
    "name": "Harsh",
    "email": "harsh@yahoo.co.in"
} 
{
    "id": "005",
    "age": "24",
    "name": "Swarit",
    "email": "Swarit@yahoo.co.in"
}