SpringBoot 與 JPA

印度阿三17 2019-12-12

展開全文

實現(xiàn)數(shù)據(jù)的增刪改查

?1.導入依賴

<!--  引入mysql需要的依賴  -->
    <dependency>  
            <groupId>mysql</groupId>  
            <artifactId>mysql-connector-java</artifactId>  
   </dependency>  
    <!--  引入spring data jpa需要的依賴  -->
    <dependency>  
            <groupId>org.springframework.boot</groupId>  
            <artifactId>spring-boot-starter-data-jpa</artifactId>  
   </dependency>

2.?創(chuàng)建src/main/resource下的application.yml文件

##數(shù)據(jù)庫四大連接參數(shù)
spring:
  datasource:
    driver-class-name: com.mysql.jdbc.Driver
    url: jdbc:mysql:///springbootjpa
    username: root
    password: 123
##jpa表的生成策略
  jpa:
    hibernate:
      ddl-auto: update

3.創(chuàng)建Grade實體類

@Entity
public class Grade {
    @Id
    @GeneratedValue(strategy= GenerationType.AUTO)
    private Integer grade_id;
    private String grade_name;

    public Integer getGrade_id() {
        return grade_id;
    }

    public void setGrade_id(Integer grade_id) {
        this.grade_id = grade_id;
    }

    public String getGrade_name() {
        return grade_name;
    }

    public void setGrade_name(String grade_name) {
        this.grade_name = grade_name;
    }
}

4.?創(chuàng)建dao層

/**
 * CrudRepository<實體，主鍵數(shù)據(jù)類型>
 */
@Repository
public interface IGradeMapper extends CrudRepository<Grade,Integer> {
}

5.?創(chuàng)建service層接口

public interface IGradeService {
    public Grade insertGrade(Grade grade);


    public Grade updateGrade(Grade grade);

    public void deleteGrade(Integer id);


    public Iterable<Grade> getAll();
}

6.創(chuàng)建service實現(xiàn)類

@Service("iGradeService")
public class IGradeServcieImpl implements IGradeService {
    @Resource
    private IGradeMapper iGradeMapper;


    @Override
    public Grade insertGrade(Grade grade) {
        return iGradeMapper.save(grade);
    }

    @Override
    public Grade updateGrade(Grade grade) {
        return iGradeMapper.save(grade);
    }

    @Override
    public void deleteGrade(Integer id) {
        iGradeMapper.delete(id);

    }

    @Override
    public Iterable<Grade> getAll() {
        return iGradeMapper.findAll();
    }

}

7.?創(chuàng)建controller層

@RestController
@RequestMapping("/IGradeController")
public class IGradeController {
    @Resource
    private IGradeService iGradeService;

    //新增數(shù)據(jù)
    @RequestMapping("/insertGrade")
    public Grade insertGrade(){
        Grade grade=new Grade();
        grade.setGrade_name("S1");
        return iGradeService.insertGrade(grade);
    }

    @RequestMapping("/updateGrade")
    public Grade updateGrade(){
        Grade grade=new Grade();
        grade.setGrade_id(1);
        grade.setGrade_name("S2");
        return iGradeService.updateGrade(grade);
    }

    @RequestMapping("/deleteGrade")
    public void deleteGrade(){

        iGradeService.deleteGrade(1);
    }

    @RequestMapping("/getAllGrade")
    public Iterable<Grade> getAllGrade(){
       return  iGradeService.getAll();
    }
}

8.創(chuàng)建StartSpringBoot測試類

@SpringBootApplication
public class StartSpringBoot {
    public static void main(String[] args) {
        SpringApplication.run(StartSpringBoot.class,args);
    }
}

9.瀏覽器測試