idea中 spring boot 整合jpa 实现创建表操作

一.springboot的JPA

   jPA顾名思义就是Java Persistence API的意思，是JDK 5.0注解或XML描述对象－关系表的映射关系，并将运行期的实体对象持久化到数据库中。

类似于hibernate一样，将实体类属性通过面向对象的思想转化成数据表字段的映射功能。

二.新建项目：10-jpa-demo-01

2.1 编写pom文件

 <!-- springBoot的启动器 -->
    <dependency>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-web</artifactId>
    </dependency>
    <!-- springBoot的启动器 -->
    <dependency>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-data-jpa</artifactId>
    </dependency>
    <!-- mysql -->
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
    </dependency>
    <!-- druid连接池 -->
    <dependency>
      <groupId>com.alibaba</groupId>
      <artifactId>druid</artifactId>
      <version>1.1.10</version>
    </dependency>

 

2.2  编写UserRePository

package com.ljf.spring.boot.demo.jpa.controller;

import com.ljf.spring.boot.demo.jpa.model.Users;
import org.springframework.data.jpa.repository.JpaRepository;

/**
 * @ClassName: UserRepository
 * @Description:  参数一 T :当前需要映射的实体
 *  *             参数二 ID :当前映射的实体中的ID的类型
 * @Author: liujianfu
 * @Date: 2020/08/09 15:41:21
 * @Version: V1.0
 **/
public interface UserRespository extends JpaRepository<Users,Integer> {
}

2.3 编写实体映射类

package com.ljf.spring.boot.demo.jpa.model;

import javax.persistence.*;

/**
 * @ClassName: Users
 * @Description: TODO
 * @Author: liujianfu
 * @Date: 2020/08/09 15:43:21
 * @Version: V1.0
 **/
@Entity
@Table(name="t_users")
public class Users {
    @Id
    @GeneratedValue(strategy=GenerationType.IDENTITY)
    @Column(name="id")
    private Integer id;

    @Column(name="u_name")
    private String name;

    @Column(name="u_age")
    private Integer age;

    @Column(name="u_address")
    private String address;

    public Integer getId() {
        return id;
    }

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

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public Integer getAge() {
        return age;
    }

    public void setAge(Integer age) {
        this.age = age;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }
}

2.4 配置文件：resource下面的内容

#spring的数据库连接
spring.datasource.driverClassName=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/test_db?serverTimezone=UTC
spring.datasource.username=root
spring.datasource.password=root
#ali的线程池
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.jpa.hibernate.ddl-auto=update
spring.jpa.show-sql=true

2.5 启动类

package com.ljf.spring.boot.demo.jpa;

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

/**
 * Hello world!
 *
 */
@SpringBootApplication
public class AppStart
{
    public static void main( String[] args )
    {
        SpringApplication.run(AppStart.class, args);
        System.out.println( "Hello World!" );
    }
}

2.6 查看数据表