SpringBoot 集成 JPA 根据实体类自动生成表（mysql）

墨蓝 2022-02-16 00:19 566阅读 0赞

### SpringBoot 集成 JPA 根据实体类自动生成表（mysql） ###

刚知道 JPA 可以根据实体类，生成数据库表，特此记录

**pom 配置：**

<parent>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-parent</artifactId>
            <version>2.1.4.RELEASE</version>
            <relativePath/> 
        </parent>
    
        <properties>
            <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
            <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
            <java.version>1.8</java.version>
        </properties>
    
        <dependencies>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-data-jpa</artifactId>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-web</artifactId>
            </dependency>
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>8.0.13</version>
                <scope>runtime</scope>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-test</artifactId>
                <scope>test</scope>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-devtools</artifactId>
                <optional>true</optional>
            </dependency>
        </dependencies>
    
        <build>
            <plugins>
                <plugin>
                    <groupId>org.springframework.boot</groupId>
                    <artifactId>spring-boot-maven-plugin</artifactId>
                    <configuration>
                        <fork>true</fork>
                    </configuration>
                </plugin>
            </plugins>
        </build>

**开始配置：**

spring.datasource.url=jdbc:mysql://localhost:3306/test?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8&useSSL=true
    spring.datasource.username=root
    spring.datasource.password=root
    spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
    
    spring.jpa.database=mysql
    spring.jpa.show-sql=true
    spring.jpa.hibernate.ddl-auto=update
    spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQL5Dialect

需要先配置数据库连接，然后创建实体类 UserInfo：

package com.xiaopengwei.sprngboot.entity;
    
    import javax.persistence.*;
    import java.io.Serializable;
    import java.util.List;
    
    @Entity
    public class UserInfo implements Serializable { 
    
        @Id
        @GeneratedValue
        private Integer uid;
    
        @Column(unique =true)
    
        /** * 账户名 */
        private String username;
    
        /** * 名称（昵称或者真实姓名，不同系统不同定义） */
        private String name;
    
        /** * 密码 */
        private String password;
    
        /** * 加密密码的盐 */
        private String salt;
    
        /** * 用户状态： * 0: 创建未认证（比如没有激活，没有输入验证码等等）--等待验证的用户; * 1: 正常状态; * 2: 用户被锁定. */
        private byte state;
    
        /** * 立即从数据库中进行加载数据; * 一个用户具有多个角色; */
        @ManyToMany(fetch= FetchType.EAGER)
        @JoinTable(name = "SysUserRole", joinColumns = {  @JoinColumn(name = "uid") }, inverseJoinColumns ={ @JoinColumn(name = "roleId") })
        private List<SysRole> roleList;
    
        public Integer getUid() { 
            return uid;
        }
    
        public void setUid(Integer uid) { 
            this.uid = uid;
        }
    
        public String getUsername() { 
            return username;
        }
    
        public void setUsername(String username) { 
            this.username = username;
        }
    
        public String getName() { 
            return name;
        }
    
        public void setName(String name) { 
            this.name = name;
        }
    
        public String getPassword() { 
            return password;
        }
    
        public void setPassword(String password) { 
            this.password = password;
        }
    
        public String getSalt() { 
            return salt;
        }
    
        public void setSalt(String salt) { 
            this.salt = salt;
        }
    
        public byte getState() { 
            return state;
        }
    
        public void setState(byte state) { 
            this.state = state;
        }
    
        public List<SysRole> getRoleList() { 
            return roleList;
        }
    
        public void setRoleList(List<SysRole> roleList) { 
            this.roleList = roleList;
        }
    
        /** * 密码盐 * 重新对盐重新进行了定义，用户名+salt，这样就更加不容易被破解 * * @return java.lang.String * @author XiaoPengwei.com */
        public String getCredentialsSalt(){ 
            return this.username+this.salt;
        }
    
    }