spring-boot2（使用mysql）

end for time

已于 2022-03-05 19:47:17 修改

阅读量806

点赞数 1

分类专栏： java 文章标签： spring mysql java

于 2022-02-20 18:46:00 首次发布

本文链接：https://blog.csdn.net/qq_36767214/article/details/123025479

版权

java 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

官方文档

一.pom添加数据库依赖

二.添加数据库配置application.yaml

一.pom添加数据库依赖

mysql的版本可以自己加定义限制，只需要添加<version>定义就行

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

二.添加数据库配置application.yaml

需要设置服务器时区

spring:
  datasource:
    url: jdbc:mysql://localhost:3306/wordpress?serverTimezone=GMT%2B8
    username: root
    password: xxxxx
    driver-class-name: com.mysql.cj.jdbc.Driver

三.编写dao层repository

注意点：定义和repository底层一样的方法时会报错，需要找解决办法

package com.bllon.boot.dao;

import com.bllon.boot.domain.Posts;
import org.springframework.data.jpa.repository.JpaRepository;

public interface PostsRepository extends JpaRepository<Posts, Long> {

}

四.编写Entity实体

package com.bllon.boot.domain;

import javax.persistence.*;
import java.io.Serializable;

@Entity
@Table(name = "wordpress_posts")
public class Posts implements Serializable {

    private static final long serialVersionUID = 1L;

    @Id
    @GeneratedValue
    @Column(name = "ID")
    private Long id;

    @Column(name = "post_title")
    private String title;

    @Column(name = "post_content")
    private String content;

    public Posts() {
        super();
    }

    public Posts(String title, String content) {
        super();
        this.title = title;
        this.content = content;
    }

    public Long getId() {
        return id;
    }

    public String getTitle() {
        return this.title;
    }

    public String getContent() {
        return this.content;
    }
}

五.controller层应用

注意点：需要添加注解@Autowired，不然无法引入repository

package com.bllon.boot.controller;

import com.bllon.boot.dao.PostsRepository;
import com.bllon.boot.domain.Posts;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import java.util.ArrayList;
import java.util.List;
import java.util.Optional;

@RestController
public class HelloController {

    @Autowired
    private PostsRepository postsRepository;

    @RequestMapping("/hello")
    public String Handle01() {
        return "Hello, spring boot 2!";
    }

    @RequestMapping("/allPost")
    public List<Posts> Posts() {
        List<Posts> list = new ArrayList<Posts>();
        list = postsRepository.findAll();
        return list;
    }

    @RequestMapping("/post")
    public Optional<Posts> Posts(Long id) {
        Optional<Posts> posts = postsRepository.findById(id);
        return posts;
    }
}