<generator class="native"/>有什么作用__hnyufushan@qq.com

 
inverse常用于一对多双向关联关系中。
以Student(学生)和Class(班级)为例,它们之间的关系为一对多的关系,即一个学生只能属于一个班级,一个班级可以包含多个学

生。
学生类定义代码:
Class Student{
  private int id;
  private String name;
  private Class class;
  //省略getter()和setter()方法
}
班级类定义代码:
Class Class{
  private int id;
  private String name;
  private Set students = new HashSet();
  //省略getter()和setter()方法
}
Student类的映射文件:
<class name="Student" table="STUDENT">
   <id name="id" type="int" column="ID">
      <generator class="native" />  
   </id>
   <property name="name" type="string" column="NAME" />
   <many-to-one name="class" column="CLASS_ID" class="Class" cascade="save-update" /> 
</class>
Class类的映射文件:
<class name="Class" table="CLASS">
   <id name="id" type="int" column="ID">
     <generator class="native" />  
   </id>
   <property name="name" type="string" column="NAME" />
   <set name="students" table="STUDENT" cascade="save-update" inverse="false">
     <key column="CLASS_ID" />
     <one-to-many class="Student" />
   </set>
</class>
希望你能对这两个映射文件所表达的数据库模式有正确的认识。即STUDENT表中存在一个名为CLASS_ID的字段,它和CLASS表中的ID字段是主外键关系。那个inverse属性就是用来规定是由谁(Student或Class)来维护这个主外键关系的。
inverse的默认值为false。
在处理逻辑代码中,如下:
Class c1 = new Class();
c1.setName("一班");
Student s1 = new Student();
Student s2 = new Student();
s1.setName("Jason");
s2.setName("Tom");
c1.getStudents().add(s1);
c2.getStudents().add(s2);
s1.setClass(c1);
s2.setClass(c1);   //注释1
session.save(c1);
上面的代码会使Hibernate执行五条SQL语句,其中前三条是insert插入语句,后两条是update更新语句。插入就不用说了,那么为什么还要有更新语句呢?这是因为Class类映射文件的<set>元素中指定了inverse="false",这就告之Hibernate:STUDENT表与CLASS表的主外键关系是由Class类来维护的。当执行save后,执行了三条insert语句,这三条语句中的后两条是插入到STUDENT表的,它们的CLASS_ID字段是通过s1.getClass().getID()取出的,假如我将上面“注释1”处修改为s2.setClass(c2);(c2是另一个Class对象,可能是持久化对象),这样,主外键关系不就乱了吗。为了保证主外键关系,Hibernate在这种情况下会再执行两条update语句来更改STUDENT表中两个新插入记录的CLASS_ID字段,当然,这时CLASS_ID字段的取值是从c1对象中直接取得,而不再是s1.getClass().getID()方式了。
如果我们将Class类映射文件的<set>元素中的inverse属性修改为true,这就是告诉Hibernate:Class类不维护主外键关系了,这个任务就交给了Student类。于是,我们再执行上面的代码,Hibernate就会只执行三条insert语句,而不会执行任何update语句。因为Hibernate会通过Student类的s1.getClass().getID()和s2.getClass().getID()来确定CLASS_ID字段的值。
故,为了节省数据库资源,省却不必要的update语句,我们一般建议在一对多双向关联关系中,将一方的inverse属性设置为true,即将主外键的关系交由多方来维护。
打个比方:在一个公司中,是老板认识所有的员工容易,还是所有员工认识老板容易?
我是一个Hibernate的初学者,前两天刚刚研究了一下inverse属性,有所心得。写了这么多东西,希望能对你有所帮助。
package com.kucun.data.entity; import javax.persistence.CascadeType; import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.FetchType; import javax.persistence.Id; import javax.persistence.JoinColumn; import javax.persistence.ManyToOne; import javax.persistence.Table; /** * 产品组件关联类 * @author Administrator * */ @Entity @Table(name="chanpin_zujian") public class Chanpin_zujian { @Id private Integer id; // 关联到产品 @ManyToOne(fetch = FetchType.LAZY) @JoinColumn(name = "chanpin_id") private Chanpin chanpin; // 关联到组件 @ManyToOne(fetch = FetchType.LAZY) @JoinColumn(name = "zujian_id") private Zujian zujian; // 关联到板材 @ManyToOne(fetch = FetchType.LAZY) @JoinColumn(name = "bancai_id") private Bancai bancai; private Double one_howmany; public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } public Chanpin getChanpin() { return chanpin; } public void setChanpin(Chanpin chanpin) { this.chanpin = chanpin; } public Zujian getZujian() { return zujian; } public void setZujian(Zujian zujian) { this.zujian = zujian; } public Bancai getBancai() { return bancai; } public void setBancai(Bancai bancai) { this.bancai = bancai; } public Double getOne_howmany() { return one_howmany; } public void setOne_howmany(Double one_howmany) { this.one_howmany = one_howmany; } public Chanpin_zujian() { super(); // TODO Auto-generated constructor stub } } package com.kucun.data.entity; import java.util.Date; import java.util.List; import javax.persistence.CascadeType; import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.FetchType; import javax.persistence.Id; import javax.persistence.ManyToMany; import javax.persistence.OneToMany; import javax.persistence.Table; import javax.persistence.UniqueConstraint; /** * 订单 * @author Administrator * */ @Entity @Table(name="dingdan", uniqueConstraints = { @UniqueConstraint(columnNames = "number") }) public class Dingdan { @Id private Integer id; //订单号 private String number; private Date xiadan; private Date jiaohuo; @OneToMany( mappedBy = "dingdan", cascade = CascadeType.ALL, fetch = FetchType.LAZY, orphanRemoval = true ) private List<Dingdan_chanpin> dingdan_chanpins; // 优化订单与订单组件关联 @OneToMany( mappedBy = "dingdan", cascade = CascadeType.ALL, fetch = FetchType.LAZY, orphanRemoval = true ) private List<Dingdan_chanpin_zujian> dingdan_chanpins_zujians; public Date getXiadan() { return xiadan; } public void setXiadan(Date xiadan) { this.xiadan = xiadan; } public Date getJiaohuo() { return jiaohuo; } public void setJiaohuo(Date jiaohuo) { this.jiaohuo = jiaohuo; } public List<Dingdan_chanpin_zujian> getDingdan_chanpins_zujians() { return dingdan_chanpins_zujians; } public void setDingdan_chanpins_zujians(List<Dingdan_chanpin_zujian> dingdan_chanpins_zujians) { this.dingdan_chanpins_zujians = dingdan_chanpins_zujians; } public List<Dingdan_chanpin> getDingdan_chanpins() { return dingdan_chanpins; } public void setDingdan_chanpins(List<Dingdan_chanpin> dingdan_chanpins) { this.dingdan_chanpins = dingdan_chanpins; } public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } public String getNumber() { return number; } public void setNumber(String number) { this.number = number; } public Dingdan(Integer id, String number) { super(); this.id = id; this.number = number; } public Dingdan() { super(); // TODO Auto-generated constructor stub } } package com.kucun.data.entity; import javax.persistence.CascadeType; import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.FetchType; import javax.persistence.Id; import javax.persistence.JoinColumn; import javax.persistence.ManyToOne; import javax.persistence.Table; /** * 订单和产品关联 * @author Administrator * */ @Entity @Table(name="dingdan_chanpin") public class Dingdan_chanpin { @Id private Integer id; //产品信息 @ManyToOne(fetch = FetchType.LAZY) @JoinColumn(name = "dingdan_id") // 指 private Dingdan dingdan; @ManyToOne(fetch = FetchType.LAZY) @JoinColumn(name = "chanpin_id") // 指 private Chanpin chanpin; private Integer shuliang;//产品数量; public Chanpin getChanpin() { return chanpin; } public void setChanpin(Chanpin chanpin) { this.chanpin = chanpin; } public Integer getShuliang() { return shuliang; } public void setShuliang(Integer shuliang) { this.shuliang = shuliang; } public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } public Dingdan getDingdan() { return dingdan; } public void setDingdan(Dingdan dingdan) { this.dingdan = dingdan; } public Chanpin getChanping() { return chanpin; } public void setChanping(Chanpin chanping) { this.chanpin = chanping; } } package com.kucun.data.entity; import javax.persistence.CascadeType; import javax.persistence.Entity; import javax.persistence.FetchType; import javax.persistence.Id; import javax.persistence.JoinColumn; import javax.persistence.ManyToOne; /** * 一个订单中的产品组件订购板材数量 * @author Administrator * */ @Entity public class Dingdan_chanpin_zujian { @Id private Integer id; @ManyToOne(fetch = FetchType.LAZY) @JoinColumn(name = "dingdan_id") // 指定外键列 private Dingdan dingdan; @ManyToOne(fetch = FetchType.LAZY) @JoinColumn(name = "chanpin_zujian_id") // 指定外键列 private Chanpin_zujian zujian; // 修改为单数形式 //板材 @ManyToOne(cascade = CascadeType.ALL, fetch = FetchType.LAZY) @JoinColumn(name = "bancai_id") private Bancai bancai; //订购数 private Integer shuliang ; public Dingdan_chanpin_zujian() { super(); // TODO Auto-generated constructor stub } public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } public Dingdan getDingdan() { return dingdan; } public void setDingdan(Dingdan dingdan) { this.dingdan = dingdan; } public Bancai getBancai() { return bancai; } public void setBancai(Bancai bancai) { this.bancai = bancai; } public Chanpin_zujian getZujian() { return zujian; } public void setZujian(Chanpin_zujian zujian) { this.zujian = zujian; } public Integer getShuliang() { return shuliang; } public void setShuliang(Integer shuliang) { this.shuliang = shuliang; } } package com.kucun.data.entity; public interface EntityBasis { Integer getId(); } package com.kucun.data.entity; import com.fasterxml.jackson.core.JsonProcessingException; import com.fasterxml.jackson.databind.ObjectMapper; /** * 通信类 * @author Administrator * */ public class Information { private static final ObjectMapper mapper = new ObjectMapper(); private Integer Status ; private String text; private Object data; public Integer getStatus() { return Status; } public void setStatus(Integer status) { Status = status; } public String getText() { return text; } public void setText(String text) { this.text = text; } public Object getData() { return data; } public void setData(Object data) { this.data = data; } public Information(Integer status, String text, Object data) { super(); Status = status; this.text = text; this.data = data; } @SuppressWarnings({"unchecked","rawtypes"}) public Information(Integer status, String text, String data, Class T) throws Exception { super(); Status = status; this.text = text; this.data = fromJson(data,T); } public Information() { super(); // TODO Auto-generated constructor stub } public String DataJson() throws JsonProcessingException { // Java对象转JSON return mapper.writeValueAsString(this); } @SuppressWarnings("unchecked") public <T> T fromJson(String json, Class<T> clazz) throws Exception { data= mapper.readValue(json, clazz); return (T) data; } public static Information NewSuccess(Object data) { return new Information(200, "success", data); } public static Information NewSuccess(String data) { return new Information(200, "success", data); } public static Information Newfail(Integer status,String text,Object data) { return new Information(status, "success", data); } } package com.kucun.data.entity; import java.util.Date; import javax.persistence.Entity; import javax.persistence.Id; import javax.persistence.ManyToOne; @Entity public class Jinhuo { @Id private Integer id; @ManyToOne private Dingdan dingdan; @ManyToOne private Chanpin chanpin; @ManyToOne private Zujian zujian; @ManyToOne private Bancai bancai; private Integer shuliang; private Date date; @ManyToOne private User user; public Jinhuo(Integer id, Dingdan dingdan, Chanpin chanpin, Zujian zujian, Bancai bancai, Integer shuliang, Date date, User user) { super(); this.id = id; this.dingdan = dingdan; this.chanpin = chanpin; this.zujian = zujian; this.bancai = bancai; this.shuliang = shuliang; this.date = date; this.user = user; } public Jinhuo() { super(); // TODO Auto-generated constructor stub } public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } public Dingdan getDingdan() { return dingdan; } public void setDingdan(Dingdan dingdan) { this.dingdan = dingdan; } public Chanpin getChanpin() { return chanpin; } public void setChanpin(Chanpin chanpin) { this.chanpin = chanpin; } public Zujian getZujian() { return zujian; } public void setZujian(Zujian zujian) { this.zujian = zujian; } public Bancai getBancai() { return bancai; } public void setBancai(Bancai bancai) { this.bancai = bancai; } public Integer getShuliang() { return shuliang; } public void setShuliang(Integer shuliang) { this.shuliang = shuliang; } public Date getDate() { return date; } public void setDate(Date date) { this.date = date; } public User getUser() { return user; } public void setUser(User user) { this.user = user; } } package com.kucun.data.entity; import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.FetchType; import javax.persistence.Id; import javax.persistence.JoinColumn; import javax.persistence.ManyToOne; import javax.persistence.OneToOne; /** * 库存 * @author Administrator * */ @Entity public class Kucun { @Id private Integer id; private Long shuliang; @OneToOne(fetch = FetchType.LAZY) // 正确映射 Bancai 实体 @JoinColumn(name = "bancai_id", referencedColumnName = "id") private Bancai bancai; public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } public Bancai getBancai() { return bancai; } public void setBancai(Bancai bancai) { this.bancai = bancai; } public Long getShuliang() { return shuliang; } public void setShuliang(Long shuliang) { this.shuliang = shuliang; } public Kucun(Integer id, Bancai bancai, Long shuliang) { super(); this.id = id; this.bancai = bancai; this.shuliang = shuliang; } public Kucun() { super(); // TODO Auto-generated constructor stub } } package com.kucun.data.entity; import java.util.List; import javax.persistence.Entity; import javax.persistence.Id; import javax.persistence.ManyToMany; import javax.persistence.OneToMany; import javax.persistence.Table; import javax.persistence.UniqueConstraint; import com.fasterxml.jackson.annotation.JsonIgnore; import com.fasterxml.jackson.annotation.JsonIgnoreProperties; /** * 木皮 * @author Administrator * */ @Entity @Table(name="caizhi", uniqueConstraints = { @UniqueConstraint(columnNames = "name") }) @JsonIgnoreProperties({"hibernateLazyInitializer", "handler"}) public class Mupi extends SimpleEntity { /** * 是否有油漆 */ private Boolean you; // 添加 OneToMany 映射 @OneToMany(mappedBy = "mupi1") // 指向 Bancai 中的 mupi1 字段 @JsonIgnore private List<Bancai> bancaisForMupi1; @OneToMany(mappedBy = "mupi2") // 指向 Bancai 中的 mupi2 字段 @JsonIgnore private List<Bancai> bancaisForMupi2; public List<Bancai> getBancaisForMupi1() { return bancaisForMupi1; } public void setBancaisForMupi1(List<Bancai> bancaisForMupi1) { this.bancaisForMupi1 = bancaisForMupi1; } public List<Bancai> getBancaisForMupi2() { return bancaisForMupi2; } public void setBancaisForMupi2(List<Bancai> bancaisForMupi2) { this.bancaisForMupi2 = bancaisForMupi2; } public Mupi() { super(); } public Boolean getYou() { return you; } public void setYou(Boolean you) { this.you = you; } } package com.kucun.data.entity; import javax.persistence.Column; import javax.persistence.GeneratedValue; import javax.persistence.GenerationType; import javax.persistence.Id; import javax.persistence.MappedSuperclass; @MappedSuperclass public abstract class SimpleEntity { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) private Integer id; @Column(nullable = false, unique = true) private String name; 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; } // Getters and Setters... } package com.kucun.data.entity; import java.util.Objects; import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.GeneratedValue; import javax.persistence.GenerationType; import javax.persistence.Id; import javax.persistence.Table; import com.fasterxml.jackson.databind.ObjectMapper; /** * 用户 * @author Administrator * */ @Entity @Table(name="user") public class User implements EntityBasis{ @Id @GeneratedValue(strategy = GenerationType.IDENTITY) private Integer id; /** * 名字 */ @Column(nullable=false) private String name; /** * 账号 */ @Column(nullable=false) private String andy; /** * 密码 */ @Column(nullable=false) private String pass; /** * 权限 */ @Column(nullable=false) private int role; public User() { super(); } public User(int id, String name, String andy, String pass) { super(); this.id = id; this.name = name; this.andy = andy; this.pass = pass; } public Integer getId() { return id; } public void setId(int id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } public String getAndy() { return andy; } public void setAndy(String andy) { this.andy = andy; } public String getPass() { return pass; } public void setPass(String pass) { this.pass = pass; } public int getRole() { System.out.println(role); return role; } public void setRole(int role) { this.role = role; } @Override public String toString() { return "{id:" + id + ", name:" + name + ", andy:" + andy + ", pass:" + pass + ", role:" + role + "}"; } @Override public boolean equals(Object o) { if (this == o) return true; if (o == null || getClass() != o.getClass()) return false; User user = (User) o; return Objects.equals(id, user.id) && Objects.equals(name, user.name) && Objects.equals(andy, user.andy)&& Objects.equals(role, user.role); //添加所有属性比较 } @Override public int hashCode() { return Objects.hash(id, name, andy,pass,role); } } package com.kucun.data.entity; import java.util.List; import javax.persistence.CascadeType; import javax.persistence.Entity; import javax.persistence.FetchType; import javax.persistence.Id; import javax.persistence.OneToMany; @Entity public class Zujian extends SimpleEntity{ // 反向关联到产品组件 @OneToMany( mappedBy = "zujian", cascade = CascadeType.ALL, fetch = FetchType.LAZY ) private List<Chanpin_zujian> chanpins; public List<Chanpin_zujian> getChanpins() { return chanpins; } public void setChanpins(List<Chanpin_zujian> chanpins) { this.chanpins = chanpins; } } package com.kucun.data.entity; import java.lang.annotation.Annotation; import javax.persistence.CascadeType; import javax.persistence.Entity; import javax.persistence.FetchType; import javax.persistence.Id; import javax.persistence.JoinColumn; import javax.persistence.ManyToOne; import javax.persistence.OneToOne; import javax.persistence.Table; import com.fasterxml.jackson.annotation.JsonBackReference; import com.fasterxml.jackson.annotation.JsonManagedReference; /** * 板材 * @author Administrator * */ @Entity @Table(name="bancai") public class Bancai implements Entity { @Id private int id; @ManyToOne(cascade = CascadeType.ALL, fetch = FetchType.LAZY) @JoinColumn(name = "caizhi_id") // @JsonManagedReference // 标记为“主”关联方 private Caizhi caizhi; @ManyToOne(cascade = CascadeType.ALL, fetch = FetchType.LAZY) @JoinColumn(name = "mupi1_id") private Mupi mupi1; @ManyToOne(cascade = CascadeType.ALL, fetch = FetchType.LAZY) @JoinColumn(name = "mupi2_id") private Mupi mupi2; private Double houdu; @OneToOne(cascade = CascadeType.ALL, fetch = FetchType.LAZY) @JoinColumn(name = "kucun_id", referencedColumnName = "id") private Kucun kucun; public Kucun getKucun() { return kucun; } public void setKucun(Kucun kucun) { this.kucun = kucun; } public Integer getId() { return id; } public void setId(int id) { this.id = id; } public Caizhi getCaizhi() { return caizhi; } public void setCaizhi(Caizhi caizhi) { this.caizhi = caizhi; } public Mupi getMupi1() { return mupi1; } public void setMupi1(Mupi mupi1) { this.mupi1 = mupi1; } public Mupi getMupi2() { return mupi2; } public void setMupi2(Mupi mupi2) { this.mupi2 = mupi2; } public Double getHoudu() { return houdu; } public void setHoudu(Double houdu) { this.houdu = houdu; } public Bancai(int id, Caizhi caizhi, Mupi mupi1, Mupi mupi2, Double houdu) { super(); this.id = id; this.caizhi = caizhi; this.mupi1 = mupi1; this.mupi2 = mupi2; this.houdu = houdu; } public Bancai() { super(); } @Override public Class<? extends Annotation> annotationType() { // TODO Auto-generated method stub return null; } @Override public String name() { // TODO Auto-generated method stub return null; } } package com.kucun.data.entity; import java.util.List; import javax.persistence.Entity; import javax.persistence.Id; import javax.persistence.OneToMany; import javax.persistence.Table; import javax.persistence.UniqueConstraint; import com.fasterxml.jackson.annotation.JsonIgnore; import com.fasterxml.jackson.annotation.JsonIgnoreProperties; /** * 板材材质 * @author Administrator * */ @Entity @Table(name="caizhi", uniqueConstraints = { @UniqueConstraint(columnNames = "name") }) @JsonIgnoreProperties({"hibernateLazyInitializer", "handler"}) public class Caizhi extends SimpleEntity{ @OneToMany(mappedBy="caizhi") @JsonIgnore private List<Bancai> bancais; public Caizhi() { super(); } // 添加反向关联维护方法 public void addBancai(Bancai bancai) { bancais.add(bancai); bancai.setCaizhi(this); } // 添加移除方法 public void removeBancai(Bancai bancai) { bancais.remove(bancai); bancai.setCaizhi(null); } public List<Bancai> getBancais() { return bancais; } public void setBancais(List<Bancai> bancais) { this.bancais = bancais; } } package com.kucun.data.entity; import java.util.List; import javax.persistence.CascadeType; import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.FetchType; import javax.persistence.Id; import javax.persistence.JoinColumn; import javax.persistence.JoinTable; import javax.persistence.OneToMany; import javax.persistence.Table; import javax.persistence.UniqueConstraint; /** * 产品类 * @author Administrator * */ @Entity @Table(name="chanpin", uniqueConstraints = { @UniqueConstraint(columnNames = "bianhao") }) public class Chanpin { @Id private Integer id; // 关联订单产品 @OneToMany( mappedBy = "chanpin", cascade = CascadeType.ALL, fetch = FetchType.LAZY ) private List<Dingdan_chanpin> dingdans; private String bianhao; @OneToMany( mappedBy = "chanpin", cascade = CascadeType.ALL, fetch = FetchType.LAZY, orphanRemoval = true ) private List<Chanpin_zujian> zujians; // 添加/移除组件的辅助方法 public void addZujian(Chanpin_zujian zujian) { zujians.add(zujian); zujian.setChanpin(this); } public void removeZujian(Chanpin_zujian zujian) { zujians.remove(zujian); zujian.setChanpin(null); } // 添加/移除组件的辅助方法 public void addDingdan(Dingdan_chanpin dingdan) { dingdans.add(dingdan); dingdan.setChanpin(this); } public void removeDingdan(Dingdan_chanpin dingdian) { dingdans.remove(dingdian); dingdian.setChanpin(null); } public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } public List<Dingdan_chanpin> getDingdans() { return dingdans; } public void setDingdans(List<Dingdan_chanpin> dingdans) { this.dingdans = dingdans; } public String getBianhao() { return bianhao; } public void setBianhao(String bianhao) { this.bianhao = bianhao; } public List<Chanpin_zujian> getZujians() { return zujians; } public void setZujians(List<Chanpin_zujian> zujians) { this.zujians = zujians; } public Chanpin(Integer id, List<Dingdan_chanpin> dingdians, String bianhao, List<Chanpin_zujian> zujians) { super(); this.id = id; this.dingdans = dingdians; this.bianhao = bianhao; this.zujians = zujians; } public Chanpin() { super(); // TODO Auto-generated constructor stub } } package com.kucun.dataDo; import java.util.List; import org.springframework.data.jpa.repository.JpaRepository; import org.springframework.stereotype.Repository; import com.kucun.data.entity.Chanpin; //ChanpinRepository.java @Repository public interface ChanpinRepository extends JpaRepository<Chanpin, Integer> { boolean existsByBianhao(String bianhao); List<Chanpin> findByBianhao(String bianhao); } package com.kucun.dataDo; import java.util.Optional; import org.springframework.data.jpa.repository.JpaRepository; import org.springframework.stereotype.Repository; import com.kucun.data.entity.Chanpin; import com.kucun.data.entity.Chanpin_zujian; import com.kucun.data.entity.Dingdan; //ChanpinRepository.java //ChanpinZujianRepository.java @Repository public interface ChanpinZujianRepository extends JpaRepository<Chanpin_zujian, Integer> { boolean existsByChanpin_IdAndZujian_Id(Integer chanpinid, Integer zujianid); Chanpin_zujian findByChanpin_IdAndZujian_Id(Integer chanpinid, Integer zujianid); } package com.kucun.dataDo; import java.util.List; import org.springframework.data.jpa.repository.JpaRepository; import org.springframework.stereotype.Repository; import com.kucun.data.entity.Chanpin; import com.kucun.data.entity.Dingdan_chanpin; //DingdanChanpinRepository.java @Repository public interface DingdanChanpinRepository extends JpaRepository<Dingdan_chanpin, Integer> { boolean existsByDingdan_IdAndChanpin_Id(Integer dingdanid, Integer chanpinid); List<Dingdan_chanpin> findByChanpin_Id(Integer id); } package com.kucun.dataDo; import org.springframework.data.jpa.repository.JpaRepository; import org.springframework.stereotype.Repository; import com.kucun.data.entity.Chanpin; import com.kucun.data.entity.Dingdan_chanpin_zujian; //ChanpinRepository.java //DingdanChanpinZujianRepository.java @Repository public interface DingdanChanpinZujianRepository extends JpaRepository<Dingdan_chanpin_zujian, Integer> { boolean existsByDingdan_IdAndZujian_Id(Integer dingdanid, Integer chanpin_zujianid); } package com.kucun.dataDo; import java.util.List; import org.springframework.data.jpa.repository.JpaRepository; import org.springframework.data.jpa.repository.Query; import org.springframework.data.repository.query.Param; import org.springframework.stereotype.Repository; import com.kucun.data.entity.Dingdan; import com.kucun.data.entity.DTO.DingdanKucunDTO; @Repository public interface DingdanRepository extends JpaRepository<Dingdan, Integer> { boolean existsByNumber(String number); // // // // 自定义查询:获取订单及相关库存信息 // @Query("SELECT new com.kucun.data.dto.OrderInventoryDTO(" + // "d.id, d.number, dc.id, cp.bianhao, b.id, b.houdu, c.name, k.shuliang) " + // "FROM Dingdan d " + // "JOIN d.dingdan_chanpins dc " + // "JOIN dc.chanping cp " + // "JOIN cp.zujians cz " + // "JOIN cz.bancai b " + // "JOIN b.caizhi c " + // "JOIN b.kucun k " + // "WHERE d.id = :orderId") // List<DingdanKucunDTO> findInventoryByOrderId(@Param("orderId") Integer orderId); //订单号查询 @Query("SELECT DISTINCT d FROM Dingdan d " + "WHERE d.number = :number") Dingdan findByNumberWithFullDetails(@Param("number") String number); } package com.kucun.dataDo; import org.springframework.data.jpa.repository.JpaRepository; import com.kucun.data.entity.Chanpin; import com.kucun.data.entity.Kucun; //ChanpinRepository.java public interface KucunRepository extends JpaRepository<Kucun, Integer> { } package com.kucun.dataDo; import org.springframework.data.jpa.repository.JpaRepository; import org.springframework.data.repository.CrudRepository; import org.springframework.stereotype.Repository; import com.kucun.data.entity.Mupi; @Repository public interface MupiRepository extends JpaRepository<Mupi,Integer>{ } package com.kucun.dataDo; import java.util.List; import org.springframework.data.jpa.repository.JpaRepository; import org.springframework.data.jpa.repository.Query; import org.springframework.data.repository.CrudRepository; import org.springframework.data.repository.query.Param; import org.springframework.stereotype.Repository; import com.kucun.data.entity.User; @Repository public interface UserRepository extends JpaRepository<User, Long> { // 登录 @Query(value="select * from user where andy=:andy and pass=:pass",nativeQuery = true) User GetUsers(@Param(value="andy")String andy, @Param("pass")String pass); @Query(value="select * from user where andy=:andy",nativeQuery = true) User findByAndy(@Param(value="andy")String andy); } package com.kucun.dataDo; import org.springframework.data.jpa.repository.JpaRepository; import org.springframework.stereotype.Repository; import com.kucun.data.entity.Chanpin; import com.kucun.data.entity.Zujian; //ChanpinRepository.java @Repository public interface ZujianRepository extends JpaRepository<Zujian, Integer> { boolean existsByName(String name); } package com.kucun.dataDo; import java.util.List; import java.util.Optional; import org.springframework.data.jpa.repository.JpaRepository; import org.springframework.data.jpa.repository.Query; import org.springframework.data.repository.CrudRepository; import org.springframework.data.repository.query.Param; import org.springframework.stereotype.Repository; import com.kucun.data.entity.Bancai; import com.kucun.data.entity.DTO.BancaiDTO; @Repository public interface BancaiRepository extends JpaRepository<Bancai, Integer> { @Query("SELECT b FROM Bancai b " + "JOIN b.caizhi c " + "JOIN b.mupi1 m1 " + "JOIN b.mupi2 m2 " + "WHERE c.name = :caizhiName " + "AND m1.name = :mupi1Name " + "AND m2.name = :mupi2Name") List<Bancai> findComplexJoin(@Param("caizhiName") String caizhiName, @Param("mupi1Name") String mupi1Name, @Param("mupi2Name") String mupi2Name); @Query("SELECT COUNT(b) FROM Bancai b " + "JOIN b.caizhi c " + "JOIN b.mupi1 m1 " + "JOIN b.mupi2 m2 " + "WHERE c.id = :caizhiid " + "AND m1.id = :mupi1id " + "AND m2.id = :mupi2id") Integer findComplexidCOUNT(@Param("caizhiid") Integer caizhiid, @Param("mupi1id") Integer mupi1id, @Param("mupi2id") Integer mupi2id); // 使用JOIN FETCH预加载所有关联 @Query("SELECT b FROM Bancai b " + "LEFT JOIN FETCH b.caizhi " + "LEFT JOIN FETCH b.mupi1 " + "LEFT JOIN FETCH b.mupi2 " + "WHERE b.id = :id") Optional<Bancai> findFullDetailById(@Param("id") Integer id); // 获取板材及其关联的所有木皮信息(包括mupi1和mupi2) @Query("SELECT b, c, m1, m2 FROM Bancai b " + "JOIN b.caizhi c " + "JOIN b.mupi1 m1 " + "JOIN b.mupi2 m2 " + "WHERE b.id = :id") List<Object[]> findFullAssociations(@Param("id") Integer id); // 批量获取多个板材的完整信息 @Query("SELECT b FROM Bancai b " + "LEFT JOIN FETCH b.caizhi " + "LEFT JOIN FETCH b.mupi1 " + "LEFT JOIN FETCH b.mupi2 " + "WHERE b.id IN :ids") List<Bancai> findBatchDetails(@Param("ids") List<Integer> ids); // 批量获取所有板材的完整信息 @Query("SELECT b FROM Bancai b " + "LEFT JOIN FETCH b.caizhi " + "LEFT JOIN FETCH b.mupi1 " + "LEFT JOIN FETCH b.mupi2 " ) List<Bancai> findBatchALLDetails(); // 批量获取多个板材的完整信息 @Query("SELECT b FROM Bancai b " + "LEFT JOIN FETCH b.caizhi " + "LEFT JOIN FETCH b.mupi1 " + "LEFT JOIN FETCH b.mupi2 " + "WHERE b.houdu IN :hou") List<Bancai> findBatchHoudu(@Param("hou") List<Double> hou); @Query("SELECT b FROM Bancai b " + "LEFT JOIN FETCH b.caizhi " + "LEFT JOIN FETCH b.mupi1 " + "LEFT JOIN FETCH b.mupi2 " + "LEFT JOIN FETCH b.kucun " + "WHERE b.id = :id") Optional<Bancai> findByIdWithAssociations(@Param("id") int id); @Query("SELECT b FROM Bancai b " + "LEFT JOIN FETCH b.caizhi " + "LEFT JOIN FETCH b.mupi1 " + "LEFT JOIN FETCH b.mupi2 " + "LEFT JOIN FETCH b.kucun ") List<Bancai> findByAllWithAssociations(); } package com.kucun.dataDo; import org.springframework.data.jpa.repository.JpaRepository; import org.springframework.data.repository.CrudRepository; import org.springframework.stereotype.Repository; import com.kucun.data.entity.Caizhi; @Repository public interface CaizhiRepository extends JpaRepository<Caizhi, Integer> { } 创建api输出全部数据 ,下级类只输出id,结构不变 ,下级类还是对象
06-10
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 2.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd"> <hibernate-mapping package="com.smics.apps.etst.domain.admin"> <class name="GroupFields"> <id name="id"> <generator class="native"/> </id> <property name="fieldsName" length='255'/> <property name="employeeNo" length='60'/> <property name="createDate" /> <property name="createdBy" length='60'/> </class> <class name="ReasonCode"> <id name="id"> <generator class="native"/> </id> <property name="codeType" length='20'/> <property name="smicTermCode" length='255'/> <property name="custCode" length='60'/> <property name="custTermCode" length='255'/> <property name="description" length='500'/> <property name="createDate" /> <property name="createdBy" length='60'/> </class> <class name="ResponserDept"> <id name="id"> <generator class="native"/> </id> <property name="orgId" length='255'/> <property name="deptName" length='255'/> <property name="secName" length='255'/> <property name="magrId" length='10'/> <property name="costCode" length='20'/> <property name="pieVerify" length='20'/> <property name="pieSite" length='20'/> <property name="createDate" /> <property name="createdBy" length='60'/> </class> <query name="findGroupByMember"><![CDATA[ from GroupFields g where g.employeeNo = ? ]]></query> <query name="findCccByMagrId"><![CDATA[ from ResponserDept g where g.magrId = ? ]]></query> <query name="findResponserDeptByOrgId"><![CDATA[ from ResponserDept g where g.orgId = ? ]]></query> <query name="findResDeptByDeptSec"><![CDATA[ from ResponserDept g where g.deptName = ? and g.secName = ? ]]></query> <query name="findResSecByDept"><![CDATA[ from ResponserDept g where g.deptName = ? ]]></query> <query name="findReasonCodeByCodeType"><![CDATA[ from ReasonCode r where r.codeType = ? ]]></query> </hibernate-mapping>
最新发布
08-29
你提供的这个 `hibernate-mapping` 文件是 Hibernate 的映射文件,用于将 Java 实体类(如 `GroupFields`、`ReasonCode`、`ResponserDept`)**映射到数据库表结构**,并定义了查询语句。 --- ## ✅ 映射文件结构分析 ### 根节点 ```xml <hibernate-mapping package="com.smics.apps.etst.domain.admin"> ``` - 指定了这些类所在的包名:`com.smics.apps.etst.domain.admin`。 - 所有 `<class>` 标签中 `name` 属性只需写类名即可。 --- ## 📦 实体类映射分析 ### 1. **GroupFields** ```xml <class name="GroupFields"> <id name="id"> <generator class="native"/> </id> <property name="fieldsName" length='255'/> <property name="employeeNo" length='60'/> <property name="createDate" /> <property name="createdBy" length='60'/> </class> ``` - 映射到数据库表(默认为 `GROUP_FIELDS`)。 - 包含字段: - `id`:主键,自增(`native` 表示使用数据库自增机制) - `fieldsName`:字段名(长度 255) - `employeeNo`:员工编号(长度 60) - `createDate`:创建时间(无长度限制) - `createdBy`:创建人(长度 60) --- ### 2. **ReasonCode** ```xml <class name="ReasonCode"> <id name="id"> <generator class="native"/> </id> <property name="codeType" length='20'/> <property name="smicTermCode" length='255'/> <property name="custCode" length='60'/> <property name="custTermCode" length='255'/> <property name="description" length='500'/> <property name="createDate" /> <property name="createdBy" length='60'/> </class> ``` - 映射到数据库表(默认为 `REASON_CODE`)。 - 包含字段: - `codeType`:代码类型(长度 20) - `smicTermCode`:SMIC 术语代码(长度 255) - `custCode`:客户代码(长度 60) - `custTermCode`:客户术语代码(长度 255) - `description`:描述(长度 500) - `createDate`:创建时间 - `createdBy`:创建人 --- ### 3. **ResponserDept** ```xml <class name="ResponserDept"> <id name="id"> <generator class="native"/> </id> <property name="orgId" length='255'/> <property name="deptName" length='255'/> <property name="secName" length='255'/> <property name="magrId" length='10'/> <property name="costCode" length='20'/> <property name="pieVerify" length='20'/> <property name="pieSite" length='20'/> <property name="createDate" /> <property name="createdBy" length='60'/> </class> ``` - 映射到数据库表(默认为 `RESPONSER_DEPT`)。 - 包含字段: - `orgId`:组织 ID(长度 255) - `deptName`:部门名称(长度 255) - `secName`:科室名称(长度 255) - `magrId`:主管 ID(长度 10) - `costCode`:成本中心代码(长度 20) - `pieVerify`:是否需要 PIE 验证(长度 20) - `pieSite`:站点(长度 20) - `createDate`:创建时间 - `createdBy`:创建人 --- ## 🔍 查询语句(NamedQuery) Hibernate 支持通过 `<query>` 标签定义命名查询(NamedQuery),这些查询可以在代码中通过名称调用。 ### 示例: ```xml <query name="findGroupByMember"><![CDATA[ from GroupFields g where g.employeeNo = ? ]]></query> ``` 在 Java 代码中可以这样调用: ```java List result = findByNamedQuery("findGroupByMember", empNo); ``` --- ## 📋 常用命名查询列表 | 查询名称 | HQL 语句 | 说明 | |----------|----------|------| | `findGroupByMember` | `from GroupFields g where g.employeeNo = ?` | 根据员工编号查找分组 | | `findCccByMagrId` | `from ResponserDept g where g.magrId = ?` | 根据主管 ID 查找成本中心 | | `findResponserDeptByOrgId` | `from ResponserDept g where g.orgId = ?` | 根据组织 ID 查找响应部门 | | `findResDeptByDeptSec` | `from ResponserDept g where g.deptName = ? and g.secName = ?` | 根据部门和科室查找响应部门 | | `findResSecByDept` | `from ResponserDept g where g.deptName = ?` | 根据部门查找科室 | | `findReasonCodeByCodeType` | `from ReasonCode r where r.codeType = ?` | 根据代码类型查找原因码 | --- ## ✅ 总结 | 类名 | 数据库表 | 主要字段 | |------|----------|----------| | `GroupFields` | `GROUP_FIELDS` | `id`, `fieldsName`, `employeeNo`, `createDate`, `createdBy` | | `ReasonCode` | `REASON_CODE` | `id`, `codeType`, `smicTermCode`, `custCode`, `description` | | `ResponserDept` | `RESPONSER_DEPT` | `id`, `orgId`, `deptName`, `secName`, `magrId`, `costCode` | --- ##
评论 2
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值