芯が強い人になるESTJ-A

# springboot--application.yml基本配置&数据库mysql搭配

IT開発 Tags: 无标签 阅读: 267

springboot配置简单,直接用application.yml最好

yml语法,空格2个,冒号后面空格1个。不空,报错!!!

server:
  port: 8081
  servlet:
    context-path: /luckymoney

limit:
  minMoney: 0.01
  maxMoney: 9999
  description: 最少要发${limit.minMoney}元,最多${limit.maxMoney}元

spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://127.0.0.1:3306/luckymoney?characterEncoding=utf-8
    username: root
    password: passw@rd
  jpa:
    hibernate:
      ddl-auto: create
    show-sql: true

Luckymoney.java 类如何和mysql数据库通信

注意,不要引入错误的包!!!

package com.imooc.luckymoneyspringboot;

import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import java.math.BigDecimal;

/**
 * author:xuwen
 * Created on 2021/5/6
 */
@Entity
public class Luckymoney {
    @Id
    @GeneratedValue
    private Integer id;
    private BigDecimal money;
    private String producer;
    private String consumer;

    //无参空方法
    public Luckymoney(){}

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public BigDecimal getMoney() {
        return money;
    }

    public void setMoney(BigDecimal money) {
        this.money = money;
    }

    public String getProducer() {
        return producer;
    }

    public void setProducer(String producer) {
        this.producer = producer;
    }

    public String getConsumer() {
        return consumer;
    }

    public void setConsumer(String consumer) {
        this.consumer = consumer;
    }
}

截图参考:
截屏2021-05-06 21.23.30.jpg

准备mysql数据库,我新建了一个luckymoney库,luckymoney的表。

截屏2021-05-06 22.11.44.jpg

新建了一个LuckymoneyRespository的接口

package com.imooc.luckymoneyspringboot;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.data.jpa.repository.JpaRepository;


//继承,JpaRepository,实体类,id类型
public interface LuckmoneyRepository extends JpaRepository<Luckymoney, Integer>{


}

在luckymoneyController类中写

package com.imooc.luckymoneyspringboot;

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

import java.util.List;

/**
 * author:xuwen
 * Created on 2021/5/6
 */
@RestController
public class LuckymoneyController {

    @Autowired
    private LuckmoneyRepository repository;
/**
 * 获取红包列表,查询数据库
 */
    @GetMapping("/luckymoneys")
    public List<Luckymoney> list(){
        return repository.findAll();
    }

}

结果:
截屏2021-05-06 22.13.34.jpg