java onetomany_spring-data-jpa ----OneToMany 一对多

packagexyz.ytfs.entity;importorg.springframework.test.context.ContextConfiguration;import javax.persistence.*;importjava.util.HashSet;importjava.util.Set;/*** @Classname Customer

* @Description TODO(客户的实体类)

* @Date 2020/5/8 23:20

* @Created by ytfs*/@Entity

@Table(name= "cst_customer")public classCustomer {/*** CREATE TABLE `cst_linkman` (

* `lkm_id` bigint(32) NOT NULL AUTO_INCREMENT COMMENT '联系人编号(主键)',

* `lkm_name` varchar(16) DEFAULT NULL COMMENT '联系人姓名',

* `lkm_gender` char(1) DEFAULT NULL COMMENT '联系人性别',

* `lkm_phone` varchar(16) DEFAULT NULL COMMENT '联系人办公电话',

* `lkm_mobile` varchar(16) DEFAULT NULL COMMENT '联系人手机',

* `lkm_email` varchar(64) DEFAULT NULL COMMENT '联系人邮箱',

* `lkm_position` varchar(16) DEFAULT NULL COMMENT '联系人职位',

* `lkm_memo` varchar(512) DEFAULT NULL COMMENT '联系人备注',

* `lkm_cust_id` bigint(32) NOT NULL COMMENT '客户id(外键)',

* PRIMARY KEY (`lkm_id`),

* KEY `FK_cst_linkman_lkm_cust_id` (`lkm_cust_id`),

* CONSTRAINT `FK_cst_linkman_lkm_cust_id` FOREIGN KEY (`lkm_cust_id`) REFERENCES `cst_customer` (`cust_id`) ON DELETE NO ACTION ON UPDATE NO ACTION

* ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;*/@Id

@GeneratedValue(strategy=GenerationType.IDENTITY)

@Column(name= "cust_id")privateLong custId;

@Column(name= "cust_name")privateString custName;

@Column(name= "cust_source")privateString custSource;

@Column(name= "cust_industry")privateString custIndustry;

@Column(name= "cust_level")privateString custLevel;

@Column(name= "cust_address")privateString custAddress;

@Column(name= "cust_phone")privateString custPhone;/*表达一对多的关系*/

/*** * 使用注解的形式配置多表关系

* 1.声明关系

* @OneToMany : 配置一对多关系

* targetEntity :对方对象的字节码对象

* 2.配置外键(中间表)

* @JoinColumn : 配置外键

* name:外键字段名称

* referencedColumnName:参照的主表的主键字段名称

*

* *在客户实体类上(一的一方)添加了外键了配置,所以对于客户而言,也具备了维护外键的作用*/

//@OneToMany(targetEntity = LinkMan.class)//@JoinColumn(name = "lkm_cust_id", referencedColumnName = "cust_id")

/*** 放弃外键维护权

* mappedBy:对方配置关系的属性名称\ 这里就是值得LinkMan中Customer对象得变量名称

* cascade : 配置级联(可以配置到设置多表的映射关系的注解上)

* CascadeType.all : 所有

* MERGE :更新

* PERSIST :保存

* REMOVE :删除

*

* fetch : 配置关联对象的加载方式

* EAGER :立即加载

* LAZY :延迟加载*/@OneToMany(mappedBy= "customer", cascade = CascadeType.ALL, fetch =FetchType.LAZY)private Set linkMans = new HashSet<>();publicLong getCustId() {returncustId;

}public voidsetCustId(Long custId) {this.custId =custId;

}publicString getCustName() {returncustName;

}public voidsetCustName(String custName) {this.custName =custName;

}publicString getCustSource() {returncustSource;

}public voidsetCustSource(String custSource) {this.custSource =custSource;

}publicString getCustIndustry() {returncustIndustry;

}public voidsetCustIndustry(String custIndustry) {this.custIndustry =custIndustry;

}publicString getCustLevel() {returncustLevel;

}public voidsetCustLevel(String custLevel) {this.custLevel =custLevel;

}publicString getCustAddress() {returncustAddress;

}public voidsetCustAddress(String custAddress) {this.custAddress =custAddress;

}publicString getCustPhone() {returncustPhone;

}public voidsetCustPhone(String custPhone) {this.custPhone =custPhone;

}public SetgetLinkMans() {returnlinkMans;

}public void setLinkMans(SetlinkMans) {this.linkMans =linkMans;

}

@OverridepublicString toString() {return "Customer{" +

"custId=" + custId +

", custName='" + custName + '\'' +

", custSource='" + custSource + '\'' +

", custIndustry='" + custIndustry + '\'' +

", custLevel='" + custLevel + '\'' +

", custAddress='" + custAddress + '\'' +

", custPhone='" + custPhone + '\'' +

'}';

}

}

Spring Boot Starter Data JPA 通过使用 JpaRepository 和 QueryDSL 等工具可以方便地进行多表联查。 下面是一个简单的示例,假设我们有两个实体类 User 和 Order,它们之间存在一对多的关系,即一个用户可以有多个订单。 首先,我们需要定义实体类: ``` @Entity public class User { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) private Long id; private String name; @OneToMany(mappedBy = "user") private List<Order> orders; // getters and setters } @Entity public class Order { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) private Long id; private String orderNo; @ManyToOne private User user; // getters and setters } ``` 其中,User 与 Order 之间的关系通过 @OneToMany 和 @ManyToOne 注解来定义。 然后,我们可以通过 JpaRepository 中的方法来进行多表联查,如下所示: ``` @Repository public interface UserRepository extends JpaRepository<User, Long> { @Query("SELECT u FROM User u LEFT JOIN FETCH u.orders o WHERE u.id = :userId") User findUserWithOrders(@Param("userId") Long userId); } ``` 这里使用了 JPQL 查询语句,通过 LEFT JOIN FETCH 来实现多表联查,同时使用 @Param 注解来定义参数。 最后,我们可以在 Service 层中调用 UserRepository 中的方法来获取多表联查的结果,如下所示: ``` @Service public class UserService { @Autowired private UserRepository userRepository; public User findUserWithOrders(Long userId) { return userRepository.findUserWithOrders(userId); } } ``` 这样,我们就可以方便地进行多表联查操作了。
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值