java实现jpa_java通过JPA进行数据库操作的实例详解

今天给大家介绍一下如何SpringBoot中连接Mysql数据库，并使用JPA进行数据库的相关操作。

今天给大家介绍一下如何SpringBoot中连接Mysql数据库，并使用JPA进行数据库的相关操作。

步骤一：在pom.xml文件中添加MYSQl和JPA的相关Jar包依赖，具体添加位置在dependencies中，具体添加的内容如下所示。

org.springframework.boot

spring-boot-starter-web

org.springframework.boot

spring-boot-starter-data-jpa

mysql

mysql-connector-java

org.apache.poi

poi

3.11

步骤二：在application.properties配置文件中加入数据库的相关配置，配置信息如下所示。spring.datasource.url = jdbc:mysql://localhost:3306/webtest

spring.datasource.username = root

spring.datasource.password = 220316

spring.datasource.driverClassName = com.mysql.jdbc.Driver

# Specify the DBMS

spring.jpa.database = MYSQL

# Show or not log for each sql query

spring.jpa.show-sql = true

# Hibernate ddl auto (create, create-drop, update)

spring.jpa.hibernate.ddl-auto = update

# Naming strategy

spring.jpa.hibernate.naming-strategy = org.hibernate.cfg.ImprovedNamingStrategy

# stripped before adding them to the entity manager)

spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.MySQL5Dialect

这里给大家解释一下：webtest代表数据库名称、root是用户名、220316是密码

步骤三：编写数据库操作的实体类，实体类具体信息如下所示：package example.entity;

import javax.persistence.*;

import javax.validation.constraints.NotNull;

import java.math.BigDecimal;

import java.util.Date;

@Entity

@Table(name = "user")

public class User {

@Id

@GeneratedValue(strategy = GenerationType.AUTO)

private int id;

@Column(name = "name", nullable = true, length = 30)

private String name;

@Column(name = "height", nullable = true, length = 10)

private int height;

@Column(name = "sex", nullable = true, length = 2)

private char sex;

@Temporal(TemporalType.DATE)

private Date birthday;

@Temporal(Temp