数据库操作

红太狼 2022-06-05 09:38 334阅读 0赞

*  配置配置文件
 *  建表利用jpa特性
 *  增删改查

# 配置配置文件 #

<dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-data-jpa</artifactId>
    </dependency>
    
    <dependency>
        <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
    </dependency>
    
    </dependencies>

# 建表（利用jpa特性） #

配置配置文件：  
![这里写图片描述][SouthEast]

![这里写图片描述][SouthEast 1]  
新建实体类：

package com.imooc;
    
    
    import javax.persistence.Entity;
    import javax.persistence.GeneratedValue;
    import javax.persistence.Id;
    
    @Entity
    public class Girl { 
    
        @Id
        @GeneratedValue
        private Integer id;
    
        private String cupSize;
    
        private Integer age;
    
        public Integer getId() {
            return id;
        }
    
        public void setId(Integer id) {
            this.id = id;
        }
    
        public Integer getAge() {
            return age;
        }
    
        public void setAge(Integer age) {
            this.age = age;
        }
    
        public String getCupSize() {
            return cupSize;
        }
    
        public void setCupSize(String cupSize) {
            this.cupSize = cupSize;
        }
    }

# 增删改查 #

package com.imooc;
    
    import org.springframework.data.jpa.repository.JpaRepository;
    
    import java.util.List;
    
    public interface GirlRepository extends JpaRepository<Girl, Integer> { 
    
        public List<Girl> findByAge(Integer age);
    }

package com.imooc;
    
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.web.bind.annotation.*;
    
    import java.util.List;
    
    /** * Created by liqia on 2017/11/23. */
    @RestController
    public class GirlController { 
    
        @Autowired
        private GirlRepository girlRepository;
    
        /* * 查询列表 * */
        @GetMapping(value = "/girls")
        public List<Girl> girlList(){
            return girlRepository.findAll();
        }
    
        /* * 添加一条记录 * */
        @PostMapping(value = "/girlAdd")
        public Girl girlAdd(@RequestParam("cupSize") String cupSize, @RequestParam("age") Integer age){
            Girl girl = new Girl();
            girl.setAge(age);
            girl.setCupSize(cupSize);
    
            return girlRepository.save(girl);
        }
    
        /* * 查询一条记录 * */
        @GetMapping(value = "/girls/{id}")
        public Girl getGirl(@PathVariable("id") Integer id){
            return girlRepository.findOne(id);
        }
    
        /* * 更新一条记录 * */
        @PutMapping(value = "/girls/{id}")
        public void girlUpdate(@PathVariable("id") Integer id,
                               @RequestParam("cupSize") String cupSize,
                               @RequestParam("age") Integer age){
            Girl girl = new Girl();
            girl.setId(id);
            girl.setCupSize(cupSize);
            girl.setAge(age);
    
            girlRepository.save(girl);
        }
    
    
        @DeleteMapping(value = "/girls/{id}")
        public void girlDelete(@PathVariable("id") Integer id){
            girlRepository.delete(id);
        }
    
        /* * 根据年龄查，girlRepository中添加对应接口，接口名按规定方式命名 * */
        @GetMapping(value = "girls/age/{age}")
        public List<Girl> girlListByAge(@PathVariable("age") Integer age){
            return girlRepository.findByAge(age);
        }
    
    }

[SouthEast]: /images/20220605/22376c77116044bda3a9064547a40989.png
[SouthEast 1]: /images/20220605/36d79828a4ad4a729b27e6820c54ce55.png