第JPA如何設(shè)置表名和實(shí)體名,表字段與實(shí)體字段的對應(yīng)目錄JPA設(shè)置表名和實(shí)體名,表字段與實(shí)體字段的對應(yīng)JPA數(shù)據(jù)庫表實(shí)體命名規(guī)則perties寫法

JPA設(shè)置表名和實(shí)體名,表字段與實(shí)體字段的對應(yīng)

首先你的jpaProperties配置項(xiàng)中要有

propkey="hibernate.hbm2ddl.auto"update/prop

這樣就可以直接有對象映射為表結(jié)構(gòu)，實(shí)現(xiàn)面向?qū)ο笙驍?shù)據(jù)庫轉(zhuǎn)化。

實(shí)體的名字可以和表名字不一樣，字段名字和實(shí)體的名字也可以不一樣。

packagecom.shiroweb.entitys;

importjava.util.Date;

importjavax.persistence.Column;

importjavax.persistence.Entity;

importjavax.persistence.GeneratedValue;

importjavax.persistence.GenerationType;

importjavax.persistence.Id;

importjavax.persistence.Table;

@Entity

@Table(name="shiro_user")//設(shè)置數(shù)據(jù)庫中表名字

publicclassShiroUser{

@GeneratedValue(strategy=GenerationType.IDENTITY)

privateLongid;

@Column(name="USER_NAME")span//設(shè)置數(shù)據(jù)庫中字段名字，也可以設(shè)置長度，是否為空等屬性/span

privateStringusername;

@Column(name="PASS_WORD")

privateStringpassword;

@Column(name="CREATE_DATE")

privateDatecreateDate;

@Column(name="USER_ID")

privateStringuserId;

publicStringgetUserId(){

returnuserId;

publicvoidsetUserId(StringuserId){

this.userId=userId;

publicLonggetId(){

returnid;

publicvoidsetId(Longid){

this.id=id;

publicStringgetUsername(){

returnusername;

publicvoidsetUsername(Stringusername){

this.username=username;

publicStringgetPassword(){

returnpassword;

publicvoidsetPassword(Stringpassword){

this.password=password;

publicDategetCreateDate(){

returncreateDate;

publicvoidsetCreateDate(DatecreateDate){

this.createDate=createDate;

}

JPA數(shù)據(jù)庫表實(shí)體命名規(guī)則

Unknowncolumn'user0_.create_time'in'fieldlist'

數(shù)據(jù)庫，表字段命名是駝峰命名法（createTime）,Springdatajpa在操作表的時(shí)候，生成的sql語句中卻是create_time,表字段不對照，

Springdatajpa基于hibernate-core-5.2.16.final.jar

這是由于jpa中hibernate的字段全名策略引起的，默認(rèn)是SpringPhysicalNamingStrategy，在hibernate的包：org.hibernate.boot.model.naming中有一堆的命名策略，當(dāng)然也可以實(shí)現(xiàn)

PhysicalNamingStrategy自定義實(shí)現(xiàn)。

perties寫法

1、無修改命名

spring.jpa.hibernate.naming.physical-strategy=org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl

2、遇到大寫字母加”_”的命名

spring.jpa.hibernate.naming.physical-strateg