springboot配置yml文件第一讲

最新推荐文章于 2024-04-21 18:41:21 发布

原创最新推荐文章于 2024-04-21 18:41:21 发布 · 380 阅读

0 ·

CC 4.0 BY-SA版权

springboot 专栏收录该内容

13 篇文章

订阅专栏

本文详细介绍了如何使用Spring Boot和JPA自动生成数据库表的过程。通过配置application.yml文件，实现了Book实体类到数据库中t_book表的映射，并成功自动生成了所需的数据库结构。

配置yml文件，整了两天，终于能自动生成数据库表了，记录一下

启动类：

package com.java1234;

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
public class HelloWorldApplication {

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

}

Book实体类

package com.java1234.entity;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.Table;

@Entity
@Table(name="t_book")
public class Book {

	@Id //主键
	@GeneratedValue  //自增
	private Integer id;
	
	@Column(length=100)
	private String bookName;
	
	@Column(length=100)
	private String author;
	public Integer getId() {
		return id;
	}
	public void setId(Integer id) {
		this.id = id;
	}
	public String getBookName() {
		return bookName;
	}
	public void setBookName(String bookName) {
		this.bookName = bookName;
	}
	public String getAuthor() {
		return author;
	}
	public void setAuthor(String author) {
		this.author = author;
	}
	
	
}

application.yml

server:
  port: 8080
  servlet.context-path: /
 
spring:
   datasource:
      driver-class-name: com.mysql.cj.jdbc.Driver
      url: jdbc:mysql://localhost:3306/db_bo?useSSL=false&serverTimezone=GMT
      username: root
      password: '000'
   jpa:
       hibernate:
         ddl-auto: update
       properties:
         hibernate: 
           dialect: org.hibernate.dialect.MySQL5Dialect
       show-sql: true
       open-in-view: false

生成的数据表如下：