spring boot操作数据库

1、pom文件

<!--数据库支持-->
<dependency>
   <groupId>org.springframework.boot</groupId>
   <artifactId>spring-boot-starter-data-jpa</artifactId>
   <optional>true</optional>
</dependency>

<dependency>
   <groupId>com.oracle</groupId>
   <artifactId>ojdbc14</artifactId>
   <version>10.2.0.4.0</version>
</dependency>

2、application.yml

spring:
  profiles:
    active: dev
  datasource:
    driver-class-name: oracle.jdbc.driver.OracleDriver
    url: jdbc:oracle:thin:@127.0.0.1:1521:test
    username: test
    password: root
  jpa:
    hibernate:
      ddl-auto: create
      show-sql: true

 ddl-auto： update(有就插入，没有就创建)  create(服务启动创建) create-drop(启动时创建，停止是删掉表结构)

none(什么也不做) validate(验证类里面的属性和表结构是否一致，不一致报错)

3.实体类girl

@Entity
public class Girl {
    @Id
    private Integer id;
    private String cupSize;
    private Integer age;

    public Girl() {
    }

spring boot 会根据实体类创建对应的表

4 使用sping jpa 完成增删改查操作

findByAge(自定义方法命名有规范)

public interface GirlRepository extends JpaRepository<Girl,Integer> {
    //拓展 通过年龄来查询
    public List<Girl> findByAge(Integer age);

}

a、127.0.0.1:8081/girl/1

 /*
查询一个女孩
  */
 @GetMapping(value = "/girl/{id}")
 public Girl selectGirl(@PathVariable("id")Integer id){
     Girl save = girlRepository.findOne(id);
     return save;
 }
 /*

b、127.0.0.1:8081/girl/age/22

/*
自己修改查询的条件(按年龄查询)
 */
@GetMapping(value = "/girl/age/{age}")
public List<Girl> selectGirlByAge(@PathVariable("age")Integer age){
     girlRepository.findByAge(age);
    return girlRepository.findByAge(age);
}

c、新增

/*
新增一个女生
 */
@PostMapping(value="/girl")
public Girl addGirl(@RequestParam("cupSize")String cupSize,@RequestParam("age") Integer age,@RequestParam("id")Integer id){
   Girl girl =new Girl();
   girl.setAge(age);
    girl.setCupSize(cupSize);
    girl.setId(id);
    Girl save = girlRepository.save(girl);
    return save;
}

e、127.0.0.1:8081/girl

/*
 查询女生列表
 */
@GetMapping(value = "/girl")
public List<Girl> girlList(){
    return  girlRepository.findAll();

}

f、修改

/*
修改有个女孩
 */
@PutMapping (value = "/girl/{id}")
public Girl updateGirl(@RequestParam("cupSize")String cupSize,@RequestParam("age") Integer age,@PathVariable("id")Integer id){
    Girl girl =new Girl();
    girl.setId(id);
    girl.setCupSize(cupSize);
    girl.setAge(age);
    Girl save = girlRepository.save(girl);
    return save;
}

d、127.0.0.1:8081/girl/3

/*
删除一个女孩
 */
@DeleteMapping(value = "/girl/{id}")
public void deletGirl(@PathVariable("id")Integer id){
    Girl girl =new Girl();
    girl.setId(id);
    girlRepository.delete(girl);
}

注意的地方在映射时一定要注意PathVariable和RequestParam

PathVariable用于在url接收参数，RequestParam用于在body中接收参数

5 spring boot 事务管理

@Transactional

@RestController
public class GirlController {
    @Autowired
    private GirlRepository girlRepository;
    @Autowired
    private GirlService  girlService;
    /*
    事务管理
     */
    @PostMapping (value = "/girl/insertMany")
    public void insertMany(){
        girlService.insertMany();
    }
}

@Service
public class GirlService {
    @Autowired
    private GirlRepository girlRepository;
    @Transactional
    public void insertMany(){
        Girl a=new Girl();
        a.setAge(17);
        a.setCupSize("D");
        a.setId(4);
        girlRepository.save(a);

        Girl b=new Girl();
        b.setCupSize("GGGG");
        b.setId(5);
        b.setAge(23);
        girlRepository.save(b);

    }
}