6、数据库的具体操作

1. 查询女生操作
1. 创建GirlController

package com.girl;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;

/**
 * Created by sunnyangzs on 2018/3/26.
 */
@RestController
public class GirlController {

    @Autowired
    private GirlsRepository girlsRepository;


    @GetMapping(value="/girls")
    public List<Girl> girlList(){
        return girlsRepository.findAll();
    }
}

 

1

package com.girl;

2

3

import org.springframework.beans.factory.annotation.Autowired;

4

import org.springframework.stereotype.Controller;

5

import org.springframework.web.bind.annotation.GetMapping;

6

import org.springframework.web.bind.annotation.RestController;

7

8

import java.util.List;

9

10

/**

11

 * Created by sunnyangzs on 2018/3/26.

12

 */

13

@RestController

14

public class GirlController {

15

16

    @Autowired

17

    private GirlsRepository girlsRepository;

18

19

20

    @GetMapping(value="/girls")

21

    public List<Girl> girlList(){

22

        return girlsRepository.findAll();

23

    }

24

}

25
2. 创建接口GirlsRepository继承JpaRepository<主类名称，主键Id的类型>

package com.girl;

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

/**
 * Created by sunnyangzs on 2018/3/26.
 */
public interface GirlsRepository extends JpaRepository<Girl,Integer> {

}

 

1

package com.girl;

2

3

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

4

5

/**

6

 * Created by sunnyangzs on 2018/3/26.

7

 */

8

public interface GirlsRepository extends JpaRepository<Girl,Integer> {

9

10

}

11
3. 在Controller当中操作数据库

@RestController
public class GirlController {

    @Autowired
    private GirlsRepository girlsRepository;


    @GetMapping(value="/girls")
    public List<Girl> girlList(){
        return girlsRepository.findAll();
    }
}

 

1

@RestController

2

public class GirlController {

3

4

    @Autowired

5

    private GirlsRepository girlsRepository;

6

7

8

    @GetMapping(value="/girls")

9

    public List<Girl> girlList(){

10

        return girlsRepository.findAll();

11

    }

12

}
2. 新增女生操作
1. 主要是在Controller当中添加操作函数

    /**
     * 添加女生
      * @param cupSize
     * @param age
     * @return
     */
    @PostMapping(value = "/girls")
    public Girl addGirl(@RequestParam("cupSize") String cupSize,
                          @RequestParam("age") Integer age){
        Girl girl = new Girl();
        girl.setAge(age);
        girl.setCupSize(cupSize);
        return girlsRepository.save(girl);

    }

 

1

    /**

2

     * 添加女生

3

      * @param cupSize

4

     * @param age

5

     * @return

6

     */

7

    @PostMapping(value = "/girls")

8

    public Girl addGirl(@RequestParam("cupSize") String cupSize,

9

                          @RequestParam("age") Integer age){

10

        Girl girl = new Girl();

11

        girl.setAge(age);

12

        girl.setCupSize(cupSize);

13

        return girlsRepository.save(girl);

14

15

    }

3. 通过id查询一个女生

    /**
     * 查询一个女生
     * @param id
     * @return
     */
    @GetMapping(value="/girls/{id}")
    public Girl findOneGirl(@PathVariable("id") Integer id){
        return girlsRepository.findOne(id);
    }

1

 

1

    /**

2

     * 查询一个女生

3

     * @param id

4

     * @return

5

     */

6

    @GetMapping(value="/girls/{id}")

7

    public Girl findOneGirl(@PathVariable("id") Integer id){

8

        return girlsRepository.findOne(id);

9

    }
4. 更新

/**
     * 更新一个女生的信息
     * @param id
     * @param cupSize
     * @param age
     * @return
     */
    @PutMapping("/girls/{id}")
    public Girl updateGirl(@PathVariable("id") Integer id,
                        @RequestParam(value="cupSize",required = false) String cupSize,
                        @RequestParam(value="age",required = false) Integer age
    ){
            Girl girl = new Girl();
            girl.setId(id);
            girl.setCupSize(cupSize);
            girl.setAge(age);

            return girlsRepository.save(girl);
    }

1

19

 

1

/**

2

     * 更新一个女生的信息

3

     * @param id

4

     * @param cupSize

5

     * @param age

6

     * @return

7

     */

8

    @PutMapping("/girls/{id}")

9

    public Girl updateGirl(@PathVariable("id") Integer id,

10

                        @RequestParam(value="cupSize",required = false) String cupSize,

11

                        @RequestParam(value="age",required = false) Integer age

12

    ){

13

            Girl girl = new Girl();

14

            girl.setId(id);

15

            girl.setCupSize(cupSize);

16

            girl.setAge(age);

17

18

            return girlsRepository.save(girl);

19

    }
5. 删除

    @DeleteMapping("/girls/{id}")
    public void girlDelete(@PathVariable("id") Integer id){
        girlsRepository.delete(id);
    }

1

 

1

    @DeleteMapping("/girls/{id}")

2

    public void girlDelete(@PathVariable("id") Integer id){

3

        girlsRepository.delete(id);

4

    }
6. 查询扩展
1. 通过年龄查询女生列表
1. 首先扩展接口

package com.girl;

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

        import java.util.List;

/**
 * Created by sunnyangzs on 2018/3/26.
 */
public interface GirlsRepository extends JpaRepository<Girl,Integer> {

        public List<Girl> findByAge(Integer age);

}

1

15

 

1

package com.girl;

2

3

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

4

5

        import java.util.List;

6

7

/**

8

 * Created by sunnyangzs on 2018/3/26.

9

 */

10

public interface GirlsRepository extends JpaRepository<Girl,Integer> {

11

12

        public List<Girl> findByAge(Integer age);

13

14

}

15
2. 然后添加查询函数

    //通过年龄查询女生列表
    @GetMapping("/girls/age/{age}")
    public List<Girl> findGirlsByAge(@PathVariable("age") Integer age){
        return girlsRepository.findByAge(age);
    }

1

 

1

    //通过年龄查询女生列表

2

    @GetMapping("/girls/age/{age}")

3

    public List<Girl> findGirlsByAge(@PathVariable("age") Integer age){

4

        return girlsRepository.findByAge(age);

5

    }
7. 完

来自为知笔记(Wiz)