1.引入依赖和yml基本配置:
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>
spring:
datasource:
driver-class-name: com.mysql.jdbc.Driver
username: root
password: zt140406?
url: jdbc:mysql://localhost:3306/sell?characterEncoding=utf-8&useSSL=false
jpa:
# 在控制台打印SQL
show-sql: true
# 自动更新或者穿件数据表结构
hibernate:
ddl-auto: update
2.编写实体类(bean)和数据表进行映射
package com.zhangtai.dataobject;
import lombok.Data;
import org.hibernate.annotations.DynamicUpdate;
import javax.persistence.*;
import java.util.Date;
@Entity //告诉JPA这是一个实体类(和数据表映射的类)
@Table(name = "product_category")//指定对应的表,如果省略,则和类名对应:product_category
@DynamicUpdate//动态更新时间
public class ProductCategory {
@Id //主键
@GeneratedValue(strategy = GenerationType.IDENTITY) //自增主键
@ Column(name="category_id",length=50) //指定对应的列,如果省略,默认列明就是属性名驼峰转为下划线 category_id
private Integer categoryId;
/*类目名称*/
private String categoryName;
/*类目编号*/
private Integer categoryType;
private Date createTime;
private Date updateTime;
}
3.编写Dao接口来操作实体类对应的数据表
package com.zhangtai.repository;
import com.zhangtai.dataobject.ProductCategory;
import org.springframework.data.jpa.repository.JpaRepository;
import java.util.List;
/**
* Created by lenovo on 2018/12/21.
* ProductCategory:类型
* Integer:主键类型
*/
public interface ProductCategoryRepository extends JpaRepository<ProductCategory,Integer>{
List<ProductCategory> findByCategoryTypeIn(List<Integer>categoryTypeList);
}