![\"\"](\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/04\/20250418100257-6802235172933.png\")
<\/p>\n\u6709\u65f6\u6211\u4eec\u5728\u67e5\u8be2\u67d0\u4e2a\u5b9e\u4f53\u7684\u65f6\u5019，\u7ed9\u5b9a\u7684\u6761\u4ef6\u662f\u4e0d\u56fa\u5b9a\u7684，\u8fd9\u65f6\u5c31\u9700\u8981\u52a8\u6001\u6784\u5efa\u76f8\u5e94\u7684\u67e5\u8be2\u8bed\u53e5，\u5728Spring Data JPA\u4e2d\u53ef\u4ee5\u901a\u8fc7JpaSpecificationExecutor\u63a5\u53e3\u67e5\u8be2\u3002\u76f8\u6bd4JPQL,\u5176\u4f18\u52bf\u662f\u7c7b\u578b\u5b89\u5168,\u66f4\u52a0\u7684\u9762\u5411\u5bf9\u8c61\u3002<\/p>\n
import java.util.List;<\/p>\n
import org.springframework.data.domain.Page;
\nimport org.springframework.data.domain.Pageable;
\nimport org.springframework.data.domain.Sort;
\nimport org.springframework.data.jpa.domain.Specification;<\/p>\n
\/**
\n *JpaSpecificationExecutor\u4e2d\u5b9a\u4e49\u7684\u65b9\u6cd5\u5217\u8868
\n **\/
\n public interface JpaSpecificationExecutor<T> {
\n \/\/ \u6839\u636e\u6761\u4ef6\u67e5\u8be2\u4e00\u4e2a\u5bf9\u8c61
\n T findOne(Specification<T> spec);
\n \/\/ \u6839\u636e\u6761\u4ef6\u67e5\u8be2\u96c6\u5408
\n List<T> findAll(Specification<T> spec);
\n \/\/ \u6839\u636e\u6761\u4ef6\u5206\u9875\u67e5\u8be2
\n Page<T> findAll(Specification<T> spec, Pageable pageable);
\n \/\/ \u6392\u5e8f\u67e5\u8be2
\n List<T> findAll(Specification<T> spec, Sort sort);
\n \/\/ \u7edf\u8ba1\u67e5\u8be2
\n long count(Specification<T> spec);
\n}<\/p>\n
\u5bf9\u4e8eJpaSpecificationExecutor，\u8fd9\u4e2a\u63a5\u53e3\u57fa\u672c\u662f\u56f4\u7ed5\u7740Specification\u63a5\u53e3\u6765\u5b9a\u4e49\u7684\u3002\u6211\u4eec\u53ef\u4ee5\u7b80\u5355\u7684\u7406\u89e3\u4e3a，Specification\u6784\u9020\u7684\u5c31\u662f\u67e5\u8be2\u6761\u4ef6\u3002<\/p>\n
Specification\u63a5\u53e3\u4e2d\u53ea\u5b9a\u4e49\u4e86\u5982\u4e0b\u4e00\u4e2a\u65b9\u6cd5：<\/p>\n
\/\/\u6784\u9020\u67e5\u8be2\u6761\u4ef6
\n \/**
\n *root：Root\u63a5\u53e3，\u4ee3\u8868\u67e5\u8be2\u7684\u6839\u5bf9\u8c61，\u53ef\u4ee5\u901a\u8fc7root\u83b7\u53d6\u5b9e\u4f53\u4e2d\u7684\u5c5e\u6027
\n *query：\u4ee3\u8868\u4e00\u4e2a\u9876\u5c42\u67e5\u8be2\u5bf9\u8c61，\u7528\u6765\u81ea\u5b9a\u4e49\u67e5\u8be2\u65b9\u5f0f（\u4e00\u822c\u4e0d\u7528）
\n *cb：\u7528\u6765\u6784\u5efa\u67e5\u8be2，\u6b64\u5bf9\u8c61\u91cc\u5c01\u88c5\u6709\u5f88\u591a\u67e5\u8be2\u6761\u4ef6\u65b9\u6cd5
\n **\/
\n public Predicate toPredicate(Root<T> root, CriteriaQuery<?> query, CriteriaBuilder cb);<\/p>\n
src\\\\main\\\\java\\\\top\\\\onefine\\\\dao\\\\CustomerDao.java：<\/p>\n
package top.onefine.dao;<\/p>\n
import org.springframework.data.jpa.repository.JpaRepository;
\nimport org.springframework.data.jpa.repository.JpaSpecificationExecutor;
\nimport top.onefine.domain.Customer;<\/p>\n
public interface CustomerDao extends JpaRepository<Customer, Long>, JpaSpecificationExecutor<Customer> {
\n}<\/p>\n
src\\\\test\\\\java\\\\top\\\\onefine\\\\dao\\\\CustomerDaoTest.java：<\/p>\n
package top.onefine.dao;<\/p>\n
import org.junit.Test;
\nimport org.junit.runner.RunWith;
\nimport org.springframework.beans.factory.annotation.Autowired;
\nimport org.springframework.data.domain.Page;
\nimport org.springframework.data.domain.PageRequest;
\nimport org.springframework.data.domain.Pageable;
\nimport org.springframework.data.domain.Sort;
\nimport org.springframework.data.jpa.domain.Specification;
\nimport org.springframework.test.context.ContextConfiguration;
\nimport org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
\nimport top.onefine.domain.Customer;<\/p>\n
import javax.persistence.criteria.*;<\/p>\n
import java.util.List;<\/p>\n
import static org.junit.Assert.*;<\/p>\n
@RunWith(SpringJUnit4ClassRunner.class)
\n@ContextConfiguration(locations = "classpath:applicationContext.xml")
\npublic class CustomerDaoTest {<\/p>\n
@SuppressWarnings("All")
\n @Autowired
\n private CustomerDao customerDao;<\/p>\n
\/**
\n * \u5355\u6761\u4ef6\u7cbe\u786e\u67e5\u8be2demo\u2014\u2014\u81ea\u5b9a\u4e49\u67e5\u8be2\u6761\u4ef6
\n * 1. \u5b9e\u73b0Specification\u63a5\u53e3，\u9700\u8981\u63d0\u4f9b\u7684\u6cdb\u578b\u662f\u67e5\u8be2\u7684\u5bf9\u8c61\u7c7b\u578b
\n * 2. \u5b9e\u73b0\u63a5\u53e3\u4e2d\u7684toPredicate\u65b9\u6cd5，\u7528\u4e8e\u6784\u9020\u67e5\u8be2\u6761\u4ef6
\n * 3. \u9700\u8981\u501f\u52a9\u65b9\u6cd5\u53c2\u6570\u4e2d\u7684\u4e24\u4e2a\u53c2\u6570
\n * – Root： \u83b7\u53d6\u9700\u8981\u67e5\u8be2\u7684\u5bf9\u8c61\u5c5e\u6027
\n * – CriteriaBuilder：\u7528\u4e8e\u6784\u9020\u67e5\u8be2\u6761\u4ef6，\u5185\u90e8\u5c01\u88c5\u4e86\u5f88\u591a\u7684\u67e5\u8be2\u6761\u4ef6（\u6a21\u7cca\u5339\u914d，\u7cbe\u51c6\u5339\u914d）
\n *\/
\n @Test
\n public void testFindOne() {
\n \/\/ \u533f\u540d\u5185\u90e8\u7c7b
\n\/\/ Specification<Customer> specification = new Specification<Customer>() {
\n\/\/ @Override
\n\/\/ public Predicate toPredicate(Root<Customer> root, CriteriaQuery<?> criteriaQuery, CriteriaBuilder criteriaBuilder) {
\n\/\/ \/\/ \u6839\u636e\u5ba2\u6237\u540d\u79f0\u67e5\u8be2
\n\/\/ \/\/ 1. \u83b7\u53d6\u6bd4\u8f83\u7684\u5c5e\u6027
\n\/\/ Path<Object> custName = root.get("custName"); \/\/ Root\u5bf9\u8c61\u4e2d\u83b7\u53d6\u7528\u4e8e\u6bd4\u8f83\u7684\u5c5e\u6027\u540d\u79f0
\n\/\/ \/\/ 2. \u6784\u9020\u67e5\u8be2\u6761\u4ef6 select * from cst_customer where cust_name = "one fine"
\n\/\/ \/\/ equal\u8868\u793a\u8fdb\u884c\u7cbe\u51c6\u5339\u914d，\u7b2c\u4e00\u4e2a\u53c2\u6570\u8868\u793a\u9700\u8981\u6bd4\u8f83\u7684\u5c5e\u6027（Path\u5bf9\u8c61），\u7b2c\u4e8c\u4e2a\u53c2\u6570\u8868\u793a\u6bd4\u8f83\u5c5e\u6027\u7684\u53d6\u503c
\n\/\/ @SuppressWarnings("")
\n\/\/ Predicate predicate = criteriaBuilder.equal(custName, "one fine");\/\/ CriteriaBuilder\u5bf9\u8c61\u4e2d\u6784\u9020\u67e5\u8be2\u65b9\u5f0f
\n\/\/ return predicate;
\n\/\/ }
\n\/\/ };
\n\/\/ Customer customer = customerDao.findOne(specification);<\/p>\n
\/\/ Lambda\u7b80\u5316
\n Customer customer = customerDao.findOne((root, criteriaQuery, criteriaBuilder) -> criteriaBuilder.equal(root.get("custName"), "one fine"));
\n System.out.println(customer);
\n }<\/p>\n
\/** \u591a\u6761\u4ef6\u7cbe\u786e\u67e5\u8be2demo\u2014\u2014\u6839\u636e\u5ba2\u6237\u540d\u548c\u5ba2\u6237\u6240\u5c5e\u884c\u4e1a\u67e5\u8be2
\n *\/
\n @Test
\n public void testFindOne_() {
\n Customer customer = customerDao.findOne((root, criteriaQuery, criteriaBuilder) -> {
\n \/\/ 1. \u6784\u9020\u5ba2\u6237\u540d\u7684\u7cbe\u51c6\u5339\u914d\u67e5\u8be2
\n Predicate predicate1 = criteriaBuilder.equal(root.get("custName"), "one fine");
\n \/\/ 2. \u6784\u9020\u6240\u5c5e\u884c\u4e1a\u7684\u7cbe\u51c6\u5339\u914d\u67e5\u8be2
\n Predicate predicate2 = criteriaBuilder.equal(root.get("custIndustry"), "\u8f6f\u4ef6");
\n \/\/ 3. \u5c06\u4ee5\u4e0a\u4e24\u4e2a\u67e5\u8be2\u8054\u7cfb\u8d77\u6765：\u7ec4\u5408
\n \/\/ – \u4e0e\u5173\u7cfb：and \u4ea4\u96c6
\n \/\/ – \u6216\u5173\u7cfb：or \u5e76\u96c6
\n return criteriaBuilder.and(predicate1, predicate2);
\n });
\n System.out.println(customer);
\n }<\/p>\n
\/**
\n * \u6a21\u7cca\u5339\u914d，\u6839\u636e\u5ba2\u6237\u540d\u79f0\u6a21\u7cca\u5339\u914d，\u8fd4\u56de\u5ba2\u6237\u5217\u8868
\n * – equal：\u76f4\u63a5\u5f97\u5230Path\u5bf9\u8c61（\u5c5e\u6027），\u7136\u540e\u8fdb\u884c\u6bd4\u8f83\u5373\u53ef
\n * – gt, lt, ge, le, like…：\u5f97\u5230Path\u5bf9\u8c61，\u6839\u636ePath\u6307\u5b9a\u9700\u8981\u6bd4\u8f83\u7684\u53c2\u6570\u7c7b\u578b，\u518d\u53bb\u8fdb\u884c\u6bd4\u8f83
\n * \u6307\u5b9a\u53c2\u6570\u7c7b\u578b: path.as(\u7c7b\u578b\u7684\u5b57\u8282\u7801\u5bf9\u8c61)
\n *\/
\n @Test
\n public void testFindAll() {
\n\/\/ Specification<Customer> specification = new Specification<Customer>() {
\n\/\/ @Override
\n\/\/ public Predicate toPredicate(Root<Customer> root, CriteriaQuery<?> criteriaQuery, CriteriaBuilder criteriaBuilder) {
\n\/\/ Path<Object> custName = root.get("custName");
\n\/\/ Expression<String> custNameExpression = custName.as(String.class);
\n\/\/ @SuppressWarnings("")
\n\/\/ Predicate predicate = criteriaBuilder.like(custNameExpression, "one fine"); \/\/ \u67e5\u8be2\u65b9\u5f0f：\u6a21\u7cca\u5339\u914d
\n\/\/ return predicate;
\n\/\/ }
\n\/\/ };
\n\/\/ List<Customer> customers = customerDao.findAll(specification);<\/p>\n
\/\/ List<Customer> customers = customerDao.findAll((Root<Customer> root, CriteriaQuery<?> criteriaQuery, CriteriaBuilder criteriaBuilder) ->
\n\/\/ criteriaBuilder.like(root.get("custName").as(String.class), "one fine"));
\n List<Customer> customers = customerDao.findAll((root, criteriaQuery, criteriaBuilder) ->
\n criteriaBuilder.like(root.get("custName").as(String.class), "%fine%")); \/\/ \u5305\u542b"fine"\u7684
\n for (Customer customer : customers)
\n System.out.println(customer);
\n }<\/p>\n
\/**
\n * \u6392\u5e8f
\n *\/
\n @Test
\n public void testFindAll_desc() {<\/p>\n
\/\/ \u521b\u5efa\u6392\u5e8f\u5bf9\u8c61
\n \/\/ \u7b2c\u4e00\u4e2a\u53c2\u6570：\u6392\u5e8f\u7684\u987a\u5e8f
\n \/\/ – Sort.Direction.DESC \u5012\u5e8f
\n \/\/ – Sort.Direction.ASC \u5347\u5e8f
\n \/\/ \u7b2c\u4e8c\u4e2a\u53c2\u6570：\u6392\u5e8f\u7684\u5c5e\u6027\u540d\u79f0
\n Sort sort = new Sort(Sort.Direction.DESC, "custId"); \/\/ \u67e5\u8be2\u7ed3\u679c\u6309\u7167id\u5012\u5e8f
\n \/\/ \u6dfb\u52a0\u6392\u5e8f
\n List<Customer> customers = customerDao.findAll((root, criteriaQuery, criteriaBuilder) ->
\n criteriaBuilder.like(root.get("custName").as(String.class), "one fine"), sort);
\n for (Customer customer : customers)
\n System.out.println(customer);
\n }<\/p>\n
\/**
\n * \u5206\u9875\u67e5\u8be2
\n * – findAll(Specification, Pageable) \u5e26\u6761\u4ef6\u7684\u5206\u9875
\n * – findAll(Pageable) \u4e0d\u5e26\u6761\u4ef6\u7684\u5206\u9875
\n * \u8fd4\u56dePage\u5bf9\u8c61，\u662fSpringDataJPA\u5c01\u88c5\u597d\u7684pageBean\u5bf9\u8c61，\u53ef\u4ee5\u4ece\u4e2d\u83b7\u53d6\u5230\u6570\u636e\u5217\u8868\u548c\u603b\u6761\u6570\u7b49
\n *\/
\n @Test
\n public void testFindAll_page() {
\n Specification<Customer> specification = null; \/\/ \u65e0\u67e5\u8be2\u6761\u4ef6
\n \/\/ Pageable：\u5206\u9875\u53c2\u6570
\n \/\/ PageRequest\u5bf9\u8c61\u662fPageable\u63a5\u53e3\u7684\u5b9e\u73b0\u7c7b
\n \/\/ – \u7b2c\u4e00\u4e2a\u53c2\u6570：\u67e5\u8be2\u7684\u9875\u7801（\u4ece0\u5f00\u59cb）
\n \/\/ – \u7b2c\u4e8c\u4e2a\u53c2\u6570：\u6bcf\u9875\u67e5\u8be2\u7684\u8bb0\u5f55\u6761\u6570<\/p>\n
Pageable pageable = new PageRequest(1, 2); \/\/ \u7b2c2\u9875（0\u5f00\u59cb\u7f16\u53f7），\u6bcf\u9875\u663e\u793a2\u4e2a\u6570\u636e<\/p>\n
Page<Customer> customerPage = customerDao.findAll(specification, pageable); \/\/ \u65e0\u67e5\u8be2\u6761\u4ef6
\n System.out.println("" + customerPage.getTotalElements() + "\\\\n" + \/\/ \u8bb0\u5f55\u603b\u6570
\n "" + customerPage.getTotalPages() + "\\\\n" + \/\/ \u603b\u9875\u6570
\n "" + customerPage.getSize() + "\\\\n" + \/\/ \u5206\u9875\u5927\u5c0f
\n "" + customerPage.getContent()); \/\/ \u7ed3\u679c\u5217\u8868<\/p>\n
}<\/p>\n
\/**
\n * \u7edf\u8ba1\u67e5\u8be2
\n *\/
\n @Test
\n public void testCount() {<\/p>\n
long count = customerDao.count((root, criteriaQuery, criteriaBuilder) ->
\n criteriaBuilder.like(root.get("custName").as(String.class), "%fine")); \/\/ \u4ee5"fine"\u7ed3\u675f\u7684
\n System.out.println(count);
\n }
\n}<\/p>\n
<\/p>\n
\u6570\u636e\u5e93\u4e2d\u591a\u8868\u4e4b\u95f4\u5b58\u5728\u7740\u4e09\u79cd\u5173\u7cfb，\u5982\u56fe\u6240\u793a\u3002<\/p>\n
![\"\"](\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/04\/20250418100257-68022351908d3.png\")
<\/p>\n
\u4ece\u56fe\u53ef\u4ee5\u770b\u51fa，\u7cfb\u7edf\u8bbe\u8ba1\u7684\u4e09\u79cd\u5b9e\u4f53\u5173\u7cfb\u5206\u522b\u4e3a：\u591a\u5bf9\u591a\u3001\u4e00\u5bf9\u591a\u548c\u4e00\u5bf9\u4e00(\u4e00\u822c\u4e0d\u4f7f\u7528)\u5173\u7cfb\u3002\u6ce8\u610f：\u4e00\u5bf9\u591a\u5173\u7cfb\u53ef\u4ee5\u770b\u4e3a\u4e24\u79cd： \u5373\u4e00\u5bf9\u591a，\u591a\u5bf9\u4e00；\u6240\u4ee5\u8bf4\u56db\u79cd\u66f4\u7cbe\u786e\u3002<\/p>\n
\u4e00\u5bf9\u591a\u5173\u7cfb\u4e2d：\u4e60\u60ef\u5c06\u4e00\u7684\u4e00\u65b9\u79f0\u4f5c\u4e3b\u8868，\u5c06\u591a\u7684\u4e00\u65b9\u79f0\u4e4b\u4e3a\u4ece\u8868\u3002\u7528\u5916\u952e\u63cf\u8ff0\u8fd9\u79cd\u5173\u7cfb，\u9700\u8981\u5728\u4ece\u8868\u4e2d\u65b0\u5efa\u4e00\u4e2a\u5c5e\u6027\u4f5c\u4e3a\u5916\u952e，\u5176\u53d6\u503c\u6765\u6e90\u4e8e\u4e3b\u8868\u7684\u4e3b\u952e\u3002<\/p>\n
\u591a\u5bf9\u591a\u5173\u7cfb\u4e2d：\u7528\u4e2d\u95f4\u8868（\u7b2c\u4e09\u7ae0\u8868）\u6765\u63cf\u8ff0\u8fd9\u79cd\u5173\u7cfb，\u4e2d\u95f4\u8868\u4e2d\u81f3\u5c11\u5e94\u8be5\u7531\u4e24\u4e2a\u5b57\u6bb5\u7ec4\u6210，\u8fd9\u4e24\u4e2a\u5b57\u6bb5\u4f5c\u4e3a\u5916\u952e\u6307\u5411\u4e24\u5f20\u8868\u7684\u4e3b\u952e，\u4e14\u8fd9\u4e24\u4e2a\u5b57\u6bb5\u53c8\u7ec4\u6210\u4e86\u8054\u5408\u4e3b\u952e\u3002<\/p>\n
\u660e\u786e： \u8fd9\u91cc\u53ea\u6d89\u53ca\u5b9e\u9645\u5f00\u53d1\u4e2d\u5e38\u7528\u7684\u5173\u8054\u5173\u7cfb，\u4e00\u5bf9\u591a\u548c\u591a\u5bf9\u591a\u3002\u800c\u4e00\u5bf9\u4e00\u7684\u60c5\u51b5，\u5728\u5b9e\u9645\u5f00\u53d1\u4e2d\u51e0\u4e4e\u4e0d\u7528\u3002<\/p>\n
\u5b9e\u4f53\u7c7b\u4e2d\u7684\u5173\u7cfb：<\/p>\n
\u5728\u5b9e\u9645\u5f00\u53d1\u4e2d，\u6211\u4eec\u6570\u636e\u5e93\u7684\u8868\u96be\u514d\u4f1a\u6709\u76f8\u4e92\u7684\u5173\u8054\u5173\u7cfb，\u5728\u64cd\u4f5c\u8868\u7684\u65f6\u5019\u5c31\u6709\u53ef\u80fd\u4f1a\u6d89\u53ca\u5230\u591a\u5f20\u8868\u7684\u64cd\u4f5c\u3002\u800c\u5728\u8fd9\u79cd\u5b9e\u73b0\u4e86ORM\u601d\u60f3\u7684\u6846\u67b6\u4e2d（\u5982JPA），\u53ef\u4ee5\u8ba9\u6211\u4eec\u901a\u8fc7\u64cd\u4f5c\u5b9e\u4f53\u7c7b\u5c31\u5b9e\u73b0\u5bf9\u6570\u636e\u5e93\u8868\u7684\u64cd\u4f5c\u3002\u6240\u4ee5\u4eca\u5929\u6211\u4eec\u7684\u5b66\u4e60\u91cd\u70b9\u662f：\u638c\u63e1\u914d\u7f6e\u5b9e\u4f53\u4e4b\u95f4\u7684\u5173\u8054\u5173\u7cfb\u3002<\/p>\n
\u7b2c\u4e00\u6b65：\u9996\u5148\u786e\u5b9a\u4e24\u5f20\u8868\u4e4b\u95f4\u7684\u5173\u7cfb\u3002<\/p>\n
\u5982\u679c\u5173\u7cfb\u786e\u5b9a\u9519\u4e86，\u540e\u9762\u505a\u7684\u6240\u6709\u64cd\u4f5c\u5c31\u90fd\u4e0d\u53ef\u80fd\u6b63\u786e\u3002 \u7b2c\u4e8c\u6b65：\u5728\u6570\u636e\u5e93\u4e2d\u5b9e\u73b0\u4e24\u5f20\u8868\u7684\u5173\u7cfb（\u7528\u5916\u952e\u6216\u4e2d\u95f4\u8868\u63cf\u8ff0）<\/p>\n
\u7b2c\u4e09\u6b65：\u5728\u5b9e\u4f53\u7c7b\u4e2d\u63cf\u8ff0\u51fa\u4e24\u4e2a\u5b9e\u4f53\u7684\u5173\u7cfb（\u5b9e\u4f53\u7c7b\u7684\u5305\u542b\u5173\u7cfb）<\/p>\n
\u7b2c\u56db\u6b65：\u914d\u7f6e\u51fa\u5b9e\u4f53\u7c7b\u548c\u6570\u636e\u5e93\u8868\u7684\u5173\u7cfb\u6620\u5c04（\u91cd\u70b9）<\/p>\n
\u6211\u4eec\u91c7\u7528\u7684\u793a\u4f8b\u4e3a\u5ba2\u6237\u548c\u8054\u7cfb\u4eba\u3002<\/p>\n
\u5ba2\u6237：\u6307\u7684\u662f\u4e00\u5bb6\u516c\u53f8，\u6211\u4eec\u8bb0\u4e3aA\u3002<\/p>\n
\u8054\u7cfb\u4eba：\u6307\u7684\u662fA\u516c\u53f8\u4e2d\u7684\u5458\u5de5\u3002<\/p>\n
\u5728\u4e0d\u8003\u8651\u517c\u804c\u7684\u60c5\u51b5\u4e0b，\u516c\u53f8\u548c\u5458\u5de5\u7684\u5173\u7cfb\u5373\u4e3a\u4e00\u5bf9\u591a\u3002\u5373\u4e00\u4e2a\u5ba2\u6237\u5177\u6709\u591a\u4e2a\u8054\u7cfb\u4eba，\u4e00\u4e2a\u8054\u7cfb\u4eba\u4ece\u5c5e\u4e8e\u4e00\u5bb6\u516c\u53f8\u3002<\/p>\n
\u5728\u4e00\u5bf9\u591a\u5173\u7cfb\u4e2d，\u6211\u4eec\u4e60\u60ef\u628a\u4e00\u7684\u4e00\u65b9\u79f0\u4e4b\u4e3a\u4e3b\u8868，\u628a\u591a\u7684\u4e00\u65b9\u79f0\u4e4b\u4e3a\u4ece\u8868\u3002\u5728\u6570\u636e\u5e93\u4e2d\u5efa\u7acb\u4e00\u5bf9\u591a\u7684\u5173\u7cfb，\u9700\u8981\u4f7f\u7528\u6570\u636e\u5e93\u7684\u5916\u952e\u7ea6\u675f\u3002<\/p>\n
\u4ec0\u4e48\u662f\u5916\u952e？ \u6307\u7684\u662f\u4ece\u8868\u4e2d\u6709\u4e00\u5217，\u53d6\u503c\u53c2\u7167\u4e3b\u8868\u7684\u4e3b\u952e，\u8fd9\u4e00\u5217\u5c31\u662f\u5916\u952e\u3002<\/p>\n
\u4e00\u5bf9\u591a\u6570\u636e\u5e93\u5173\u7cfb\u7684\u5efa\u7acb，\u5982\u4e0b\u56fe\u6240\u793a：![\"\"](\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/04\/20250418100257-68022351a0727.png\")
\u00a0 \u00a0<\/p>\n
\u8fd9\u91cc\u4e00\u5bf9\u591a\u7684\u6817\u5b50\u4e2d，\u4e3b\u8868\u662f\u5ba2\u6237\u8868，\u4ece\u8868\u662f\u8054\u7cfb\u4eba\u8868（\u9700\u8981\u6dfb\u52a0\u5916\u952e）\u3002<\/p>\n
\/*\u521b\u5efa\u5ba2\u6237\u8868*\/
\nCREATE TABLE cst_customer (
\n cust_id bigint(32) NOT NULL AUTO_INCREMENT COMMENT '\u5ba2\u6237\u7f16\u53f7(\u4e3b\u952e)',
\n cust_name varchar(32) NOT NULL COMMENT '\u5ba2\u6237\u540d\u79f0(\u516c\u53f8\u540d\u79f0)',
\n cust_source varchar(32) DEFAULT NULL COMMENT '\u5ba2\u6237\u4fe1\u606f\u6765\u6e90',
\n cust_industry varchar(32) DEFAULT NULL COMMENT '\u5ba2\u6237\u6240\u5c5e\u884c\u4e1a',
\n cust_level varchar(32) DEFAULT NULL COMMENT '\u5ba2\u6237\u7ea7\u522b',
\n cust_address varchar(128) DEFAULT NULL COMMENT '\u5ba2\u6237\u8054\u7cfb\u5730\u5740',
\n cust_phone varchar(64) DEFAULT NULL COMMENT '\u5ba2\u6237\u8054\u7cfb\u7535\u8bdd',
\n PRIMARY KEY (`cust_id`)
\n) ENGINE=InnoDB AUTO_INCREMENT=94 DEFAULT CHARSET=utf8;<\/p>\n
\/*\u521b\u5efa\u8054\u7cfb\u4eba\u8868*\/
\nCREATE TABLE cst_linkman (
\n lkm_id bigint(32) NOT NULL AUTO_INCREMENT COMMENT '\u8054\u7cfb\u4eba\u7f16\u53f7(\u4e3b\u952e)',
\n lkm_name varchar(16) DEFAULT NULL COMMENT '\u8054\u7cfb\u4eba\u59d3\u540d',
\n lkm_gender char(1) DEFAULT NULL COMMENT '\u8054\u7cfb\u4eba\u6027\u522b',
\n lkm_phone varchar(16) DEFAULT NULL COMMENT '\u8054\u7cfb\u4eba\u529e\u516c\u7535\u8bdd',
\n lkm_mobile varchar(16) DEFAULT NULL COMMENT '\u8054\u7cfb\u4eba\u624b\u673a',
\n lkm_email varchar(64) DEFAULT NULL COMMENT '\u8054\u7cfb\u4eba\u90ae\u7bb1',
\n lkm_position varchar(16) DEFAULT NULL COMMENT '\u8054\u7cfb\u4eba\u804c\u4f4d',
\n lkm_memo varchar(512) DEFAULT NULL COMMENT '\u8054\u7cfb\u4eba\u5907\u6ce8',
\n lkm_cust_id bigint(32) NOT NULL COMMENT '\u5ba2\u6237id(\u5916\u952e)',
\n PRIMARY KEY (`lkm_id`),
\n KEY `FK_cst_linkman_lkm_cust_id` (`lkm_cust_id`),
\n 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
\n) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;<\/p>\n
\u8981\u70b9： \u5ba2\u6237：\u5728\u5ba2\u6237\u7684\u5b9e\u4f53\u7c7b\u4e2d\u5305\u542b\u4e00\u4e2a\u8054\u7cfb\u4eba\u7684\u96c6\u5408 \u8054\u7cfb\u4eba：\u5728\u8054\u7cfb\u4eba\u7684\u5b9e\u4f53\u7c7b\u4e2d\u5305\u542b\u6709\u4e00\u4e2a\u5ba2\u6237\u7684\u5bf9\u8c61<\/p>\n
\u5728\u5b9e\u4f53\u7c7b\u4e2d，\u7531\u4e8e\u5ba2\u6237\u662f\u5c11\u7684\u4e00\u65b9，\u5b83\u5e94\u8be5\u5305\u542b\u591a\u4e2a\u8054\u7cfb\u4eba，\u6240\u4ee5\u5b9e\u4f53\u7c7b\u8981\u4f53\u73b0\u51fa\u5ba2\u6237\u4e2d\u6709\u591a\u4e2a\u8054\u7cfb\u4eba\u7684\u4fe1\u606f，\u4ee3\u7801\u5982\u4e0b<\/p>\n
package top.onefine.domain;<\/p>\n
import lombok.*;<\/p>\n
import javax.persistence.*;
\nimport java.util.HashSet;
\nimport java.util.Set;<\/p>\n
\/**
\n * 1. \u5b9e\u4f53\u7c7b\u548c\u8868\u7684\u6620\u5c04\u5173\u7cfb
\n * -@Eitity
\n * -@Table
\n * 2. \u7c7b\u4e2d\u5c5e\u6027\u548c\u6570\u636e\u5e93\u8868\u4e2d\u5b57\u6bb5\u7684\u6620\u5c04\u5173\u7cfb
\n * -@Id \u4e3b\u952e
\n * -@GeneratedValue \u4e3b\u952e\u751f\u6210\u7b56\u7565
\n * -@Column
\n *\/
\n@Entity
\n@Table(name = "cst_customer")
\n@Data \/\/ \u4f7f\u7528@Getter\u548c@Setter，\u4f46\u662f\u8981\u81ea\u5df1\u751f\u6210toString\u65b9\u6cd5
\n\/\/@Getter
\n\/\/@Setter
\n@NoArgsConstructor
\npublic class Customer {
\n @Id
\n @GeneratedValue(strategy = GenerationType.IDENTITY)
\n @Column(name = "cust_id")
\n private Long custId;
\n @Column(name = "cust_address")
\n private String custAddress;
\n @Column(name = "cust_industry")
\n private String custIndustry;
\n @Column(name = "cust_level")
\n private String custLevel;
\n @Column(name = "cust_name")
\n private String custName;
\n @Column(name = "cust_phone")
\n private String custPhone;
\n @Column(name = "cust_source")
\n private String custSource;<\/p>\n
\/\/ \u914d\u7f6e\u5ba2\u6237\u548c\u8054\u7cfb\u4eba\u4e4b\u95f4\u7684\u5173\u7cfb（\u4e00\u5bf9\u591a\u5173\u7cfb）
\n \/*
\n \u4f7f\u7528\u6ce8\u89e3\u7684\u5f62\u5f0f\u914d\u7f6e\u591a\u8868\u5173\u7cfb：
\n 1. \u58f0\u660e\u5173\u7cfb
\n – @OneToMany：\u914d\u7f6e\u4e00\u5bf9\u591a\u5173\u7cfb
\n targetEntity：\u5bf9\u65b9\u5bf9\u8c61\u7684\u5b57\u8282\u7801\u5bf9\u8c61
\n 2. \u914d\u7f6e\u5916\u952e（\u6216\u4e2d\u95f4\u8868）
\n – @JoinColumn：\u914d\u7f6e\u5916\u952e
\n name：\u4ece\u8868 \u5916\u952e\u5b57\u6bb5\u540d\u79f0
\n referencedColumnName：\u53c2\u7167\u7684 \u4e3b\u8868 \u7684\u4e3b\u952e\u5b57\u6bb5\u540d\u79f0<\/p>\n
\u6ce8：\u5728\u5ba2\u6237\u5b9e\u4f53\u7c7b\u4e0a（\u4e00\u7684\u4e00\u65b9）\u6dfb\u52a0\u4e86\u5916\u952e\u7684\u914d\u7f6e，\u6240\u4ee5\u5bf9\u4e8e\u5ba2\u6237\u800c\u8a00，\u4e5f\u5177\u5907\u4e86\u7ef4\u62a4\u5916\u952e\u7684\u4f5c\u7528<\/p>\n
*\/
\n @OneToMany(targetEntity = LinkMan.class)
\n @JoinColumn(name = "lkm_cust_id", referencedColumnName = "cust_id")
\n \/*
\n \u653e\u5f03\u5916\u952e\u7ef4\u62a4\u6743
\n mappedBy: \u5bf9\u65b9\u914d\u7f6e\u5173\u7cfb\u7684\u5c5e\u6027\u540d\u79f0
\n \u8868\u793a\u53c2\u7167\u5bf9\u65b9\u7684\u5c5e\u6027\u6765\u505a
\n *\/
\n\/\/ @OneToMany(mappedBy = "customer")
\n private Set<LinkMan> linkMans = new HashSet<>();<\/p>\n
\/\/ \u4e00\u5b9a\u8981\u81ea\u5df1\u5199，\u4e0d\u8981\u4f7f\u7528lombok\u63d0\u4f9b\u7684
\n\/\/ @Override
\n\/\/ public String toString() {
\n\/\/ return "Customer{" +
\n\/\/ "custId=" + custId +
\n\/\/ ", custAddress='" + custAddress + '\\\\'' +
\n\/\/ ", custIndustry='" + custIndustry + '\\\\'' +
\n\/\/ ", custLevel='" + custLevel + '\\\\'' +
\n\/\/ ", custName='" + custName + '\\\\'' +
\n\/\/ ", custPhone='" + custPhone + '\\\\'' +
\n\/\/ ", custSource='" + custSource + '\\\\'' +
\n\/\/ ", linkMans=" + linkMans +
\n\/\/ '}';
\n\/\/ }
\n}<\/p>\n
\u7531\u4e8e\u8054\u7cfb\u4eba\u662f\u591a\u7684\u4e00\u65b9，\u5728\u5b9e\u4f53\u7c7b\u4e2d\u8981\u4f53\u73b0\u51fa，\u6bcf\u4e2a\u8054\u7cfb\u4eba\u53ea\u80fd\u5bf9\u5e94\u4e00\u4e2a\u5ba2\u6237，\u4ee3\u7801\u5982\u4e0b：<\/p>\n
package top.onefine.domain;<\/p>\n
import lombok.Data;
\nimport lombok.NoArgsConstructor;<\/p>\n
import javax.persistence.*;<\/p>\n
@Entity
\n@Table(name = "cst_linkman")
\n@Data
\n@NoArgsConstructor
\npublic class LinkMan {
\n @Id
\n @GeneratedValue(strategy = GenerationType.IDENTITY)
\n @Column(name = "lkm_id")
\n private Long lkmId; \/\/ \u8054\u7cfb\u4eba\u7f16\u53f7
\n @Column(name = "lkm_name")
\n private String lkmName; \/\/ \u8054\u7cfb\u4eba\u59d3\u540d
\n @Column(name = "lkm_gender")
\n private String lkmGender; \/\/ \u8054\u7cfb\u4eba\u6027\u522b \/\/ \u5bf9\u5e94\u6570\u636e\u5e93\u8868\u4e2d\u5b57\u6bb5char(1)
\n @Column(name = "lkm_phone")
\n private String lkmPhone; \/\/ \u8054\u7cfb\u4eba\u529e\u516c\u7535\u8bdd
\n @Column(name = "lkm_mobile")
\n private String lkmMobile; \/\/ \u8054\u7cfb\u4eba\u624b\u673a
\n @Column(name = "lkm_email")
\n private String lkmEmail; \/\/ \u8054\u7cfb\u4eba\u90ae\u7bb1
\n @Column(name = "lkm_position")
\n private String lkmPosition; \/\/ \u8054\u7cfb\u4eba\u804c\u4f4d
\n @Column(name = "lkm_memo")
\n private String lkmMemo; \/\/ \u8054\u7cfb\u4eba\u5907\u6ce8<\/p>\n
\/\/ \u914d\u7f6e\u8054\u7cfb\u4eba\u5230\u5ba2\u6237\u7684\u591a\u5bf9\u4e00\u5173\u7cfb
\n \/*
\n \u4f7f\u7528\u6ce8\u89e3\u7684\u5f62\u5f0f\u914d\u7f6e\u591a\u5bf9\u4e00\u5173\u7cfb
\n 1. \u914d\u7f6e\u8868\u5173\u7cfb
\n – @ManyToOne：\u914d\u7f6e\u591a\u5bf9\u4e00\u5173\u7cfb
\n targetEntity：\u5bf9\u65b9\u5bf9\u8c61\u7684\u5b57\u8282\u7801\u5bf9\u8c61
\n 2. \u914d\u7f6e\u5916\u952e（\u6216\u4e2d\u95f4\u8868）<\/p>\n
\u6ce8：\u914d\u7f6e\u5916\u952e\u7684\u8fc7\u7a0b，\u914d\u7f6e\u5230\u4e86\u591a\u7684\u4e00\u65b9，\u5c31\u4f1a\u5728\u591a\u7684\u4e00\u65b9\u7ef4\u62a4\u5916\u952e
\n *\/
\n @ManyToOne(targetEntity = Customer.class)
\n @JoinColumn(name = "lkm_cust_id", referencedColumnName = "cust_id")
\n private Customer customer;
\n}<\/p>\n
pom.xml：<\/p>\n
<?xml version="1.0" encoding="UTF-8"?>
\n<project xmlns="http:\/\/maven.apache.org\/POM\/4.0.0"
\n xmlns:xsi="http:\/\/www.w3.org\/2001\/XMLSchema-instance"
\n xsi:schemaLocation="http:\/\/maven.apache.org\/POM\/4.0.0 http:\/\/maven.apache.org\/xsd\/maven-4.0.0.xsd">
\n <modelVersion>4.0.0<\/modelVersion><\/p>\n
<groupId>top.onefine<\/groupId>
\n <artifactId>jpa_day3_one2mant<\/artifactId>
\n <version>1.0-SNAPSHOT<\/version>
\n <packaging>jar<\/packaging><\/p>\n
<properties>
\n <project.build.sourceEncoding>UTF-8<\/project.build.sourceEncoding>
\n<!– <project.hibernate.version>5.4.14.Final<\/project.hibernate.version>–>
\n<!– <project.hibernate.version>5.0.7.Final<\/project.hibernate.version>–>
\n <project.hibernate.version>5.1.17.Final<\/project.hibernate.version>
\n <project.spring.version>5.2.5.RELEASE<\/project.spring.version>
\n <project.slf4j.version>1.7.30<\/project.slf4j.version>
\n <project.log4j.version>1.2.17<\/project.log4j.version>
\n <project.c3p0.version>0.9.5.5<\/project.c3p0.version>
\n <project.mysql.version>8.0.19<\/project.mysql.version>
\n <\/properties><\/p>\n
<dependencies>
\n <!– https:\/\/mvnrepository.com\/artifact\/junit\/junit –>
\n <dependency>
\n <groupId>junit<\/groupId>
\n <artifactId>junit<\/artifactId>
\n <version>4.13<\/version>
\n <scope>test<\/scope>
\n <\/dependency><\/p>\n
<!– \u4ee5\u4e0b\u4e24\u4e2a\u662fspring aop\u76f8\u5173\u7684\u5750\u6807 –>
\n <!– https:\/\/mvnrepository.com\/artifact\/org.aspectj\/aspectjweaver –>
\n <dependency>
\n <groupId>org.aspectj<\/groupId>
\n <artifactId>aspectjweaver<\/artifactId>
\n<!– <version>1.9.5<\/version>–>
\n <version>1.6.8<\/version>
\n <\/dependency><\/p>\n
<!– https:\/\/mvnrepository.com\/artifact\/org.springframework\/spring-aop –>
\n <dependency>
\n <groupId>org.springframework<\/groupId>
\n <artifactId>spring-aop<\/artifactId>
\n <version>${project.spring.version}<\/version>
\n <\/dependency><\/p>\n
<!– https:\/\/mvnrepository.com\/artifact\/org.springframework\/spring-context –>
\n <dependency>
\n <groupId>org.springframework<\/groupId>
\n <artifactId>spring-context<\/artifactId>
\n <version>${project.spring.version}<\/version>
\n <\/dependency><\/p>\n
<!– https:\/\/mvnrepository.com\/artifact\/org.springframework\/spring-context-support –>
\n <dependency>
\n <groupId>org.springframework<\/groupId>
\n <artifactId>spring-context-support<\/artifactId>
\n <version>${project.spring.version}<\/version>
\n <\/dependency><\/p>\n
<!– spring\u5bf9orm\u6846\u67b6\u7684\u652f\u6301\u5305 –>
\n <!– https:\/\/mvnrepository.com\/artifact\/org.springframework\/spring-orm –>
\n <dependency>
\n <groupId>org.springframework<\/groupId>
\n <artifactId>spring-orm<\/artifactId>
\n <version>${project.spring.version}<\/version>
\n <\/dependency><\/p>\n
<!– https:\/\/mvnrepository.com\/artifact\/org.springframework\/spring-beans –>
\n <dependency>
\n <groupId>org.springframework<\/groupId>
\n <artifactId>spring-beans<\/artifactId>
\n <version>${project.spring.version}<\/version>
\n <\/dependency><\/p>\n
<!– https:\/\/mvnrepository.com\/artifact\/org.springframework\/spring-core –>
\n <dependency>
\n <groupId>org.springframework<\/groupId>
\n <artifactId>spring-core<\/artifactId>
\n <version>${project.spring.version}<\/version>
\n <\/dependency><\/p>\n
<!– https:\/\/mvnrepository.com\/artifact\/org.hibernate\/hibernate-core –>
\n <dependency>
\n <groupId>org.hibernate<\/groupId>
\n <artifactId>hibernate-core<\/artifactId>
\n <version>${project.hibernate.version}<\/version>
\n <\/dependency><\/p>\n
<!– https:\/\/mvnrepository.com\/artifact\/org.hibernate\/hibernate-entitymanager –>
\n <dependency>
\n <groupId>org.hibernate<\/groupId>
\n <artifactId>hibernate-entitymanager<\/artifactId>
\n <version>${project.hibernate.version}<\/version>
\n <\/dependency><\/p>\n
<!– https:\/\/mvnrepository.com\/artifact\/org.hibernate\/hibernate-validator –>
\n <dependency>
\n <groupId>org.hibernate<\/groupId>
\n <artifactId>hibernate-validator<\/artifactId>
\n <!– <version>6.1.4.Final<\/version>–>
\n <version>5.4.3.Final<\/version>
\n <\/dependency><\/p>\n
<!– https:\/\/mvnrepository.com\/artifact\/log4j\/log4j –>
\n <dependency>
\n <groupId>log4j<\/groupId>
\n <artifactId>log4j<\/artifactId>
\n <version>${project.log4j.version}<\/version>
\n <\/dependency><\/p>\n
<!– https:\/\/mvnrepository.com\/artifact\/org.slf4j\/slf4j-api –>
\n <dependency>
\n <groupId>org.slf4j<\/groupId>
\n <artifactId>slf4j-api<\/artifactId>
\n <version>${project.slf4j.version}<\/version>
\n <\/dependency><\/p>\n
<!– https:\/\/mvnrepository.com\/artifact\/org.slf4j\/slf4j-log4j12 –>
\n <dependency>
\n <groupId>org.slf4j<\/groupId>
\n <artifactId>slf4j-log4j12<\/artifactId>
\n <version>${project.slf4j.version}<\/version>
\n <scope>test<\/scope>
\n <\/dependency><\/p>\n
<!– https:\/\/mvnrepository.com\/artifact\/com.mchange\/c3p0 –>
\n <dependency>
\n <groupId>com.mchange<\/groupId>
\n <artifactId>c3p0<\/artifactId>
\n <version>${project.c3p0.version}<\/version>
\n <\/dependency><\/p>\n
<!– https:\/\/mvnrepository.com\/artifact\/mysql\/mysql-connector-java –>
\n <!– Mysql and MariaDB –>
\n <dependency>
\n <groupId>mysql<\/groupId>
\n <artifactId>mysql-connector-java<\/artifactId>
\n <version>${project.mysql.version}<\/version>
\n <\/dependency><\/p>\n
<!– spring data jpa \u7684\u5750\u6807 –>
\n <!– https:\/\/mvnrepository.com\/artifact\/org.springframework.data\/spring-data-jpa –>
\n <dependency>
\n <groupId>org.springframework.data<\/groupId>
\n <artifactId>spring-data-jpa<\/artifactId>
\n <!– <version>2.2.6.RELEASE<\/version>–>
\n <!– <version>1.9.0.RELEASE<\/version>–>
\n <version>1.11.23.RELEASE<\/version>
\n <\/dependency><\/p>\n
<!– spring \u63d0\u4f9b\u7684\u5355\u5143\u6d4b\u8bd5\u7684\u5750\u6807 –>
\n <!– https:\/\/mvnrepository.com\/artifact\/org.springframework\/spring-test –>
\n <dependency>
\n <groupId>org.springframework<\/groupId>
\n <artifactId>spring-test<\/artifactId>
\n <version>${project.spring.version}<\/version>
\n <scope>test<\/scope>
\n <\/dependency><\/p>\n
<!– \u4ee5\u4e0b\u4e24\u4e2a spring data jpa\u5fc5\u987b\u5bfc\u5165\u7684\u5750\u6807 –>
\n <!– https:\/\/mvnrepository.com\/artifact\/javax.el\/javax.el-api –>
\n <dependency>
\n <groupId>javax.el<\/groupId>
\n <artifactId>javax.el-api<\/artifactId>
\n <version>2.2.4<\/version>
\n <\/dependency><\/p>\n
<!– https:\/\/mvnrepository.com\/artifact\/org.glassfish.web\/javax.el –>
\n <dependency>
\n <groupId>org.glassfish.web<\/groupId>
\n <artifactId>javax.el<\/artifactId>
\n <version>2.2.4<\/version>
\n <\/dependency><\/p>\n
<!– https:\/\/mvnrepository.com\/artifact\/org.projectlombok\/lombok –>
\n <dependency>
\n <groupId>org.projectlombok<\/groupId>
\n <artifactId>lombok<\/artifactId>
\n <version>1.18.12<\/version>
\n <scope>provided<\/scope>
\n <\/dependency><\/p>\n
<\/dependencies><\/p>\n
<\/project><\/p>\n
src\\\\main\\\\resources\\\\applicationContext.xml：<\/p>\n
<?xml version="1.0" encoding="UTF-8"?>
\n<beans xmlns="http:\/\/www.springframework.org\/schema\/beans"
\n xmlns:xsi="http:\/\/www.w3.org\/2001\/XMLSchema-instance"
\n xmlns:aop="http:\/\/www.springframework.org\/schema\/aop"
\n xmlns:context="http:\/\/www.springframework.org\/schema\/context"
\n xmlns:jdbc="http:\/\/www.springframework.org\/schema\/jdbc"
\n xmlns:tx="http:\/\/www.springframework.org\/schema\/tx"
\n xmlns:jpa="http:\/\/www.springframework.org\/schema\/data\/jpa"
\n xmlns:task="http:\/\/www.springframework.org\/schema\/task"
\n xsi:schemaLocation="
\nhttp:\/\/www.springframework.org\/schema\/beans http:\/\/www.springframework.org\/schema\/beans\/spring-beans.xsd
\nhttp:\/\/www.springframework.org\/schema\/aop http:\/\/www.springframework.org\/schema\/aop\/spring-aop.xsd
\nhttp:\/\/www.springframework.org\/schema\/context http:\/\/www.springframework.org\/schema\/context\/spring-context.xsd
\nhttp:\/\/www.springframework.org\/schema\/jdbc http:\/\/www.springframework.org\/schema\/jdbc\/spring-jdbc.xsd
\nhttp:\/\/www.springframework.org\/schema\/tx http:\/\/www.springframework.org\/schema\/tx\/spring-tx.xsd
\nhttp:\/\/www.springframework.org\/schema\/data\/jpa
\nhttp:\/\/www.springframework.org\/schema\/data\/jpa\/spring-jpa.xsd"><\/p>\n
<!– spring \u548c spring data jpa \u7684\u914d\u7f6e –>
\n <!– 1. \u521b\u5efaentityManagerFactory\u5bf9\u8c61\u4ea4\u7ed9spring\u5bb9\u5668\u7ba1\u7406 –>
\n <bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
\n <!– \u914d\u7f6e\u6570\u636e\u6e90 –>
\n <property name="dataSource" ref="dataSource"\/><\/p>\n
<!– \u914d\u7f6e\u626b\u63cf\u7684\u5305\u2014\u2014\u5b9e\u4f53\u7c7b\u6240\u5728\u7684\u5305 –>
\n <property name="packagesToScan" value="top.onefine.domain"\/><\/p>\n
<!– \u914d\u7f6ejpa\u7684\u5b9e\u73b0\u5382\u5bb6 –>
\n <property name="persistenceProvider">
\n <bean class="org.hibernate.jpa.HibernatePersistenceProvider"\/>
\n <\/property><\/p>\n
<!– JPA\u7684\u4f9b\u5e94\u5546\u9002\u914d\u5668 –>
\n <property name="jpaVendorAdapter">
\n <bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">
\n <!– \u914d\u7f6e\u662f\u5426\u81ea\u52a8\u521b\u5efa\u6570\u636e\u5e93\u8868，\u8fd9\u91ccfalse –>
\n <property name="generateDdl" value="false"\/>
\n <!– \u6307\u5b9a\u6570\u636e\u5e93\u7c7b\u578b –>
\n <property name="database" value="MYSQL"\/>
\n <!– \u914d\u7f6e\u6570\u636e\u5e93\u65b9\u8a00，\u5373\u6570\u636e\u5e93\u652f\u6301\u7684\u7279\u6709\u8bed\u6cd5 –>
\n <property name="databasePlatform" value="org.hibernate.dialect.MySQLDialect"\/>
\n <!– \u914d\u7f6e\u662f\u5426\u663e\u793asql\u8bed\u53e5，\u9ed8\u8ba4\u5728\u63a7\u5236\u53f0 –>
\n <property name="showSql" value="true"\/>
\n <\/bean>
\n <\/property><\/p>\n
<!– \u914d\u7f6ejpa\u7684\u65b9\u8a00，\u9ad8\u7ea7\u7279\u6027 –>
\n <property name="jpaDialect">
\n <bean class="org.springframework.orm.jpa.vendor.HibernateJpaDialect"\/>
\n <\/property><\/p>\n
<!– \u6ce8\u5165jpa\u7684\u914d\u7f6e\u4fe1\u606f
\n \u52a0\u8f7djpa\u7684\u57fa\u672c\u914d\u7f6e\u4fe1\u606f\u548cjpa\u5b9e\u73b0\u65b9\u5f0f（\u5982hibernate）\u7684\u914d\u7f6e\u4fe1\u606f
\n hibernate.hbm2ddl.auto: \u81ea\u52a8\u521b\u5efa\u6570\u636e\u5e93\u8868
\n create: \u6bcf\u6b21\u90fd\u4ece\u65b0\u521b\u5efa\u6570\u636e\u5e93\u8868
\n update: \u6709\u8868\u4e0d\u4f1a\u91cd\u65b0\u521b\u5efa，\u6ca1\u6709\u8868\u4f1a\u91cd\u65b0\u521b\u5efa\u8868
\n –>
\n <property name="jpaProperties">
\n <props>
\n <prop key="hibernate.hbm2ddl.auto">create<\/prop><!– \u6682\u65f6 –>
\n <\/props>
\n <\/property>
\n <\/bean><\/p>\n
<!– 2. \u521b\u5efa\u6570\u636e\u5e93\u8fde\u63a5\u6c60 –>
\n <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
\n <!– \u8fde\u63a5\u53c2\u6570 –>
\n <property name="driverClass" value="com.mysql.cj.jdbc.Driver" \/>
\n <property name="jdbcUrl" value="jdbc:mysql:\/\/127.0.0.1:3306\/study_eesy?serverTimezone=UTC" \/>
\n <property name="user" value="root" \/>
\n <property name="password" value="963123" \/><\/p>\n
<!– \u8fde\u63a5\u6c60\u53c2\u6570 –>
\n <property name="initialPoolSize" value="5" \/>
\n <property name="maxPoolSize" value="8" \/>
\n <property name="checkoutTimeout" value="3000" \/>
\n <\/bean><\/p>\n
<!– 3. \u6574\u5408spring dataJpa
\n dao\u63a5\u53e3\u6240\u5728\u5305
\n –>
\n <jpa:repositories base-package="top.onefine.dao"
\n transaction-manager-ref="transactionManager"
\n entity-manager-factory-ref="entityManagerFactory" \/><\/p>\n
<!– 4. \u914d\u7f6e\u4e8b\u52a1\u7ba1\u7406\u5668 –>
\n <bean id="transactionManager" class="org.springframework.orm.jpa.JpaTransactionManager">
\n <property name="entityManagerFactory" ref="entityManagerFactory" \/>
\n <\/bean><\/p>\n
<!– 4.txAdvice–>
\n <tx:advice id="txAdvice" transaction-manager="transactionManager">
\n <tx:attributes>
\n <tx:method name="save*" propagation="REQUIRED"\/>
\n <tx:method name="insert*" propagation="REQUIRED"\/>
\n <tx:method name="update*" propagation="REQUIRED"\/>
\n <tx:method name="delete*" propagation="REQUIRED"\/>
\n <tx:method name="get*" read-only="true"\/>
\n <tx:method name="find*" read-only="true"\/>
\n <tx:method name="*" propagation="REQUIRED"\/>
\n <\/tx:attributes>
\n <\/tx:advice><\/p>\n
<!– 5.aop–>
\n <aop:config>
\n <aop:pointcut id="pointcut" expression="execution(* top.onefine.service.*.*(..))" \/>
\n <aop:advisor advice-ref="txAdvice" pointcut-ref="pointcut" \/>
\n <\/aop:config><\/p>\n
<!– 5. \u914d\u7f6e\u58f0\u660e\u5f0f\u4e8b\u52a1 –><\/p>\n
<!– 6. \u914d\u7f6e\u5305\u626b\u63cf –>
\n <context:component-scan base-package="top.onefine" \/>
\n<\/beans><\/p>\n
src\\\\main\\\\java\\\\top\\\\onefine\\\\dao\\\\CustomerDao.java：<\/p>\n
package top.onefine.dao;<\/p>\n
import org.springframework.data.jpa.repository.JpaRepository;
\nimport org.springframework.data.jpa.repository.JpaSpecificationExecutor;
\nimport top.onefine.domain.Customer;<\/p>\n
public interface CustomerDao extends JpaRepository<Customer, Long>, JpaSpecificationExecutor<Customer> {
\n}<\/p>\n
src\\\\main\\\\java\\\\top\\\\onefine\\\\dao\\\\LinkManDao.java：<\/p>\n
package top.onefine.dao;<\/p>\n
import org.springframework.data.jpa.repository.JpaRepository;
\nimport org.springframework.data.jpa.repository.JpaSpecificationExecutor;
\nimport top.onefine.domain.LinkMan;<\/p>\n
\/**
\n * \u8054\u7cfb\u4ebadao\u63a5\u53e3
\n *\/
\npublic interface LinkManDao extends JpaRepository<LinkMan, Long>, JpaSpecificationExecutor<LinkMan> {
\n}<\/p>\n
@OneToMany:
\n \u4f5c\u7528：\u5efa\u7acb\u4e00\u5bf9\u591a\u7684\u5173\u7cfb\u6620\u5c04
\n \u5c5e\u6027：
\n targetEntityClass：\u6307\u5b9a\u591a\u7684\u591a\u65b9\u7684\u7c7b\u7684\u5b57\u8282\u7801
\n mappedBy：\u6307\u5b9a\u4ece\u8868\u5b9e\u4f53\u7c7b\u4e2d\u5f15\u7528\u4e3b\u8868\u5bf9\u8c61\u7684\u540d\u79f0\u3002
\n cascade：\u6307\u5b9a\u8981\u4f7f\u7528\u7684\u7ea7\u8054\u64cd\u4f5c
\n fetch：\u6307\u5b9a\u662f\u5426\u91c7\u7528\u5ef6\u8fdf\u52a0\u8f7d
\n orphanRemoval：\u662f\u5426\u4f7f\u7528\u5b64\u513f\u5220\u9664<\/p>\n
@ManyToOne
\n \u4f5c\u7528：\u5efa\u7acb\u591a\u5bf9\u4e00\u7684\u5173\u7cfb
\n \u5c5e\u6027：
\n targetEntityClass：\u6307\u5b9a\u4e00\u7684\u4e00\u65b9\u5b9e\u4f53\u7c7b\u5b57\u8282\u7801
\n cascade：\u6307\u5b9a\u8981\u4f7f\u7528\u7684\u7ea7\u8054\u64cd\u4f5c
\n fetch：\u6307\u5b9a\u662f\u5426\u91c7\u7528\u5ef6\u8fdf\u52a0\u8f7d
\n optional：\u5173\u8054\u662f\u5426\u53ef\u9009\u3002\u5982\u679c\u8bbe\u7f6e\u4e3afalse，\u5219\u5fc5\u987b\u59cb\u7ec8\u5b58\u5728\u975e\u7a7a\u5173\u7cfb\u3002<\/p>\n
@JoinColumn
\n\u4f5c\u7528：\u7528\u4e8e\u5b9a\u4e49\u4e3b\u952e\u5b57\u6bb5\u548c\u5916\u952e\u5b57\u6bb5\u7684\u5bf9\u5e94\u5173\u7cfb\u3002
\n\u5c5e\u6027：
\nname：\u6307\u5b9a\u5916\u952e\u5b57\u6bb5\u7684\u540d\u79f0
\nreferencedColumnName：\u6307\u5b9a\u5f15\u7528\u4e3b\u8868\u7684\u4e3b\u952e\u5b57\u6bb5\u540d\u79f0
\nunique：\u662f\u5426\u552f\u4e00\u3002\u9ed8\u8ba4\u503c\u4e0d\u552f\u4e00
\nnullable：\u662f\u5426\u5141\u8bb8\u4e3a\u7a7a\u3002\u9ed8\u8ba4\u503c\u5141\u8bb8\u3002
\ninsertable：\u662f\u5426\u5141\u8bb8\u63d2\u5165\u3002\u9ed8\u8ba4\u503c\u5141\u8bb8\u3002
\nupdatable：\u662f\u5426\u5141\u8bb8\u66f4\u65b0\u3002\u9ed8\u8ba4\u503c\u5141\u8bb8\u3002
\ncolumnDefinition：\u5217\u7684\u5b9a\u4e49\u4fe1\u606f\u3002<\/p>\n
package top.onefine.dao;<\/p>\n
import org.junit.Test;
\nimport org.junit.runner.RunWith;
\nimport org.springframework.beans.factory.annotation.Autowired;<\/p>\n
import org.springframework.test.annotation.Rollback;
\nimport org.springframework.test.context.ContextConfiguration;
\nimport org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
\nimport org.springframework.transaction.annotation.Transactional;
\nimport top.onefine.domain.Customer;
\nimport top.onefine.domain.LinkMan;<\/p>\n
@SuppressWarnings("All")
\n@RunWith(SpringJUnit4ClassRunner.class)
\n@ContextConfiguration(locations = "classpath:applicationContext.xml")
\npublic class One2ManyTest {<\/p>\n
@Autowired
\n private CustomerDao customerDao;<\/p>\n
@Autowired
\n private LinkManDao linkManDao;<\/p>\n
\/**
\n * \u4fdd\u5b58\u4e00\u4e2a\u5ba2\u6237，\u4fdd\u5b58\u4e00\u4e2a\u8054\u7cfb\u4eba
\n *\/
\n @Test
\n @Transactional \/\/ \u914d\u7f6e\u4e8b\u52a1
\n @Rollback(value = false) \/\/ \u8bbe\u7f6e\u4e0d\u81ea\u52a8\u56de\u6eda
\n public void testAdd() {
\n Customer customer = new Customer();
\n customer.setCustName("\u6d4b\u8bd5");
\n customer.setCustLevel("\u91cd\u8981");
\n LinkMan linkMan = new LinkMan();
\n linkMan.setLkmName("one fine");<\/p>\n
customerDao.save(customer);
\n linkManDao.save(linkMan);
\n }
\n}<\/p>\n
\u6548\u679c：<\/p>\n
Hibernate: alter table cst_linkman drop foreign key FKh9yp1nql5227xxcopuxqx2e7q
\nHibernate: drop table if exists cst_customer
\nHibernate: drop table if exists cst_linkman
\nHibernate: create table cst_customer (cust_id bigint not null auto_increment, cust_address varchar(255), cust_industry varchar(255), cust_level varchar(255), cust_name varchar(255), cust_phone varchar(255), cust_source varchar(255), primary key (cust_id))
\nHibernate: create table cst_linkman (lkm_id bigint not null auto_increment, lkm_email varchar(255), lkm_gender varchar(255), lkm_memo varchar(255), lkm_mobile varchar(255), lkm_name varchar(255), lkm_phone varchar(255), lkm_position varchar(255), lkm_cust_id bigint, primary key (lkm_id))
\nHibernate: alter table cst_linkman add constraint FKh9yp1nql5227xxcopuxqx2e7q foreign key (lkm_cust_id) references cst_customer (cust_id)
\nHibernate: insert into cst_customer (cust_address, cust_industry, cust_level, cust_name, cust_phone, cust_source) values (?, ?, ?, ?, ?, ?)
\nHibernate: insert into cst_linkman (lkm_cust_id, lkm_email, lkm_gender, lkm_memo, lkm_mobile, lkm_name, lkm_phone, lkm_position) values (?, ?, ?, ?, ?, ?, ?, ?)<\/p>\n
2 \u914d\u7f6e\u4e86\u5ba2\u6237\u5230\u8054\u7cfb\u4eba\u7684\u5173\u7cfb：<\/p>\n
@SuppressWarnings("All")
\n@RunWith(SpringJUnit4ClassRunner.class)
\n@ContextConfiguration(locations = "classpath:applicationContext.xml")
\npublic class One2ManyTest {<\/p>\n
@Autowired
\n private CustomerDao customerDao;<\/p>\n
@Autowired
\n private LinkManDao linkManDao;<\/p>\n
\/**
\n * \u4fdd\u5b58\u4e00\u4e2a\u5ba2\u6237，\u4fdd\u5b58\u4e00\u4e2a\u8054\u7cfb\u4eba
\n *\/
\n @Test
\n @Transactional \/\/ \u914d\u7f6e\u4e8b\u52a1
\n @Rollback(value = false) \/\/ \u8bbe\u7f6e\u4e0d\u81ea\u52a8\u56de\u6eda
\n public void testAdd() {
\n Customer customer = new Customer();
\n customer.setCustName("\u6d4b\u8bd5");
\n customer.setCustLevel("\u91cd\u8981");
\n LinkMan linkMan = new LinkMan();
\n linkMan.setLkmName("one fine");
\n \/*
\n \u914d\u7f6e\u4e86\u5ba2\u6237\u5230\u8054\u7cfb\u4eba\u7684\u5173\u7cfb：
\n \u4ece\u5ba2\u6237\u7684\u89d2\u5ea6\u4e0a，\u53d1\u9001\u4e24\u6761insert\u8bed\u53e5，\u53d1\u9001\u4e00\u6761\u66f4\u65b0\u8bed\u53e5\u66f4\u65b0\u6570\u636e\u5e93（\u66f4\u65b0\u5916\u952e）
\n \u7531\u4e8e\u914d\u7f6e\u4e86\u5ba2\u6237\u5230\u8054\u7cfb\u4eba\u7684\u5173\u7cfb：\u5ba2\u6237\u53ef\u4ee5\u5bf9\u5916\u952e\u8fdb\u884c\u7ef4\u62a4
\n *\/
\n customer.getLinkMans().add(linkMan);<\/p>\n
customerDao.save(customer);
\n linkManDao.save(linkMan);
\n }<\/p>\n
}<\/p>\n
\u6548\u679c<\/p>\n
Hibernate: alter table cst_linkman drop foreign key FKh9yp1nql5227xxcopuxqx2e7q
\nHibernate: drop table if exists cst_customer
\nHibernate: drop table if exists cst_linkman
\nHibernate: create table cst_customer (cust_id bigint not null auto_increment, cust_address varchar(255), cust_industry varchar(255), cust_level varchar(255), cust_name varchar(255), cust_phone varchar(255), cust_source varchar(255), primary key (cust_id))
\nHibernate: create table cst_linkman (lkm_id bigint not null auto_increment, lkm_email varchar(255), lkm_gender varchar(255), lkm_memo varchar(255), lkm_mobile varchar(255), lkm_name varchar(255), lkm_phone varchar(255), lkm_position varchar(255), lkm_cust_id bigint, primary key (lkm_id))
\nHibernate: alter table cst_linkman add constraint FKh9yp1nql5227xxcopuxqx2e7q foreign key (lkm_cust_id) references cst_customer (cust_id)
\nHibernate: insert into cst_customer (cust_address, cust_industry, cust_level, cust_name, cust_phone, cust_source) values (?, ?, ?, ?, ?, ?)
\nHibernate: insert into cst_linkman (lkm_cust_id, lkm_email, lkm_gender, lkm_memo, lkm_mobile, lkm_name, lkm_phone, lkm_position) values (?, ?, ?, ?, ?, ?, ?, ?)
\nHibernate: update cst_linkman set lkm_cust_id=? where lkm_id=?<\/p>\n
3 \u914d\u7f6e\u4e86\u8054\u7cfb\u4eba\u5230\u5ba2\u6237\u7684\u5173\u7cfb：<\/p>\n
@SuppressWarnings("All")
\n@RunWith(SpringJUnit4ClassRunner.class)
\n@ContextConfiguration(locations = "classpath:applicationContext.xml")
\npublic class One2ManyTest {<\/p>\n
@Autowired
\n private CustomerDao customerDao;<\/p>\n
@Autowired
\n private LinkManDao linkManDao;<\/p>\n
\/**
\n * \u4fdd\u5b58\u4e00\u4e2a\u5ba2\u6237，\u4fdd\u5b58\u4e00\u4e2a\u8054\u7cfb\u4eba
\n *\/
\n @Test
\n @Transactional \/\/ \u914d\u7f6e\u4e8b\u52a1
\n @Rollback(value = false) \/\/ \u8bbe\u7f6e\u4e0d\u81ea\u52a8\u56de\u6eda
\n public void testAdd() {
\n Customer customer = new Customer();
\n customer.setCustName("\u6d4b\u8bd5");
\n customer.setCustLevel("\u91cd\u8981");
\n LinkMan linkMan = new LinkMan();
\n linkMan.setLkmName("one fine");
\n \/*
\n \u914d\u7f6e\u8054\u7cfb\u4eba\u5230\u5ba2\u6237\u7684\u5173\u7cfb（\u591a\u5bf9\u4e00）
\n \u53ea\u53d1\u9001\u4e86\u4e24\u6761insert\u8bed\u53e5：\u7531\u4e8e\u914d\u7f6e\u4e86\u8054\u7cfb\u4eba\u5230\u5ba2\u6237\u7684\u6620\u5c04\u5173\u7cfb（\u591a\u5bf9\u4e00）
\n *\/
\n linkMan.setCustomer(customer);<\/p>\n
customerDao.save(customer);
\n linkManDao.save(linkMan);
\n }<\/p>\n
}<\/p>\n
\u6548\u679c：<\/p>\n
Hibernate: alter table cst_linkman drop foreign key FKh9yp1nql5227xxcopuxqx2e7q
\nHibernate: drop table if exists cst_customer
\nHibernate: drop table if exists cst_linkman
\nHibernate: create table cst_customer (cust_id bigint not null auto_increment, cust_address varchar(255), cust_industry varchar(255), cust_level varchar(255), cust_name varchar(255), cust_phone varchar(255), cust_source varchar(255), primary key (cust_id))
\nHibernate: create table cst_linkman (lkm_id bigint not null auto_increment, lkm_email varchar(255), lkm_gender varchar(255), lkm_memo varchar(255), lkm_mobile varchar(255), lkm_name varchar(255), lkm_phone varchar(255), lkm_position varchar(255), lkm_cust_id bigint, primary key (lkm_id))
\nHibernate: alter table cst_linkman add constraint FKh9yp1nql5227xxcopuxqx2e7q foreign key (lkm_cust_id) references cst_customer (cust_id)
\nHibernate: insert into cst_customer (cust_address, cust_industry, cust_level, cust_name, cust_phone, cust_source) values (?, ?, ?, ?, ?, ?)
\nHibernate: insert into cst_linkman (lkm_cust_id, lkm_email, lkm_gender, lkm_memo, lkm_mobile, lkm_name, lkm_phone, lkm_position) values (?, ?, ?, ?, ?, ?, ?, ?)<\/p>\n
4 \u53cc\u5411\u7ed1\u5b9a：<\/p>\n
@SuppressWarnings("All")
\n@RunWith(SpringJUnit4ClassRunner.class)
\n@ContextConfiguration(locations = "classpath:applicationContext.xml")
\npublic class One2ManyTest {<\/p>\n
@Autowired
\n private CustomerDao customerDao;<\/p>\n
@Autowired
\n private LinkManDao linkManDao;<\/p>\n
\/**
\n * \u4fdd\u5b58\u4e00\u4e2a\u5ba2\u6237，\u4fdd\u5b58\u4e00\u4e2a\u8054\u7cfb\u4eba
\n *\/
\n @Test
\n @Transactional \/\/ \u914d\u7f6e\u4e8b\u52a1
\n @Rollback(value = false) \/\/ \u8bbe\u7f6e\u4e0d\u81ea\u52a8\u56de\u6eda
\n public void testAdd() {
\n Customer customer = new Customer();
\n customer.setCustName("\u6d4b\u8bd5");
\n customer.setCustLevel("\u91cd\u8981");
\n LinkMan linkMan = new LinkMan();
\n linkMan.setLkmName("one fine");<\/p>\n
\/*
\n \u7531\u4e8e\u4e00\u7684\u4e00\u65b9\u53ef\u4ee5\u7ef4\u62a4\u5916\u952e，\u4f1a\u53d1\u9001\u4e00\u6761\u591a\u4f59update\u8bed\u53e5
\n \u89e3\u51b3\u6b64\u95ee\u9898，\u53ea\u9700\u8981\u5728\u4e00\u7684\u4e00\u65b9\u653e\u5f03\u7ef4\u62a4\u6743\u5373\u53ef
\n @OneToMany(mappedBy = "customer")
\n *\/
\n customer.getLinkMans().add(linkMan); \/\/ \u53d1\u9001\u4e00\u6761update\u8bed\u53e5
\n linkMan.setCustomer(customer);<\/p>\n
customerDao.save(customer);
\n linkManDao.save(linkMan);
\n }
\n}<\/p>\n
\u76f4\u63a5\u6267\u884c：<\/p>\n
![\"\"](\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/04\/20250418100257-68022351b5354.png\")
<\/p>\n
\u8fd9\u91cc\u8e29\u4e86\u4e2a\u5751：<\/p>\n
\u5728\u8fdb\u884c\u4e00\u5bf9\u591a\u914d\u7f6e\u540e，\u5728\u6d4b\u8bd5\u65b9\u6cd5\u4e2d\u5c1d\u8bd5\u4f7f\u7528\u83b7\u53d6\u4e00\u65b9\u4fe1\u606f，\u7ed3\u679c\u51fa\u73b0\u4e86\u5185\u5b58\u6ea2\u51fa\u7684\u9519\u8bef\u3002<\/p>\n
\u603b\u7ed3\u4e00\u4e0b\u539f\u56e0\u4ee5\u53ca\u89e3\u51b3\u65b9\u6848：<\/p>\n
\u539f\u56e0\u4e00：\u4e3a\u4e86\u65b9\u4fbf\u770b\u4fe1\u606f,\u5728\u4e24\u7c7b\u4e2d\u5206\u522b\u91cd\u5199\u4e86 toString \u65b9\u6cd5,\u5bfc\u81f4\u67e5\u8be2\u52a0\u8f7d\u65f6\u4e24\u7c7b\u5728\u4e92\u76f8\u8c03\u7528\u5bf9\u65b9\u7684toString,\u5f62\u6210\u9012\u5f52,\u9020\u6210\u5185\u5b58\u6ea2\u51fa\u3002 \u89e3\u51b3\u65b9\u6848： \u5728 toString \u65b9\u6cd5\u4e2d\u4efb\u610f\u4e00\u65b9\u53bb\u9664\u6253\u5370\u7684\u5bf9\u65b9\u4fe1\u606f\u3002<\/p>\n
\u539f\u56e0\u4e8c： \u4e3a\u4e86\u7f16\u5199\u65b9\u4fbf\u7b80\u6d01，\u4ee3\u7801\u66f4\u52a0\u4f18\u96c5，\u4f7f\u7528\u4e86 lombok \u63d2\u4ef6\u4e2d\u7684@Data\u4ee5\u53ca@ToString\u6ce8\u89e3\u6765\u6807\u6ce8\u7c7b，\u8ba9 lombok \u6765\u4ee3\u66ff\u751f\u6210 gettet\/setter \u4ee5\u53ca toString，\u4f46\u662f lombok \u5728\u751f\u6210\u65f6\u4f1a\u51fa\u73b0\u5faa\u73af\u6bd4\u8f83\u4e24\u7c7b\u4e2d\u7684 hashcode，\u5bfc\u81f4\u5185\u5b58\u6ea2\u51fa\u3002 \u89e3\u51b3\u65b9\u6848： \u4e0d\u8981\u4f7f\u7528 lombok ，\u81ea\u5df1\u624b\u5199\u3002<\/p>\n
\u53c2\u8003： https:\/\/blog.csdn.net\/weixin_43464964\/article\/details\/90669843<\/p>\n
\u66f4\u6539：src\\\\main\\\\java\\\\top\\\\onefine\\\\domain\\\\Customer.java<\/p>\n
package top.onefine.domain;<\/p>\n
import lombok.*;<\/p>\n
import javax.persistence.*;
\nimport java.util.HashSet;
\nimport java.util.Set;<\/p>\n
\/**
\n * 1. \u5b9e\u4f53\u7c7b\u548c\u8868\u7684\u6620\u5c04\u5173\u7cfb
\n * -@Eitity
\n * -@Table
\n * 2. \u7c7b\u4e2d\u5c5e\u6027\u548c\u6570\u636e\u5e93\u8868\u4e2d\u5b57\u6bb5\u7684\u6620\u5c04\u5173\u7cfb
\n * -@Id \u4e3b\u952e
\n * -@GeneratedValue \u4e3b\u952e\u751f\u6210\u7b56\u7565
\n * -@Column
\n *\/
\n@Entity
\n@Table(name = "cst_customer")
\n\/\/@Data \/\/ \u4f7f\u7528@Getter\u548c@Setter，\u4f46\u662f\u8981\u81ea\u5df1\u751f\u6210toString\u65b9\u6cd5
\n@Getter
\n@Setter
\n@NoArgsConstructor
\npublic class Customer {
\n @Id
\n @GeneratedValue(strategy = GenerationType.IDENTITY)
\n @Column(name = "cust_id")
\n private Long custId;
\n @Column(name = "cust_address")
\n private String custAddress;
\n @Column(name = "cust_industry")
\n private String custIndustry;
\n @Column(name = "cust_level")
\n private String custLevel;
\n @Column(name = "cust_name")
\n private String custName;
\n @Column(name = "cust_phone")
\n private String custPhone;
\n @Column(name = "cust_source")
\n private String custSource;<\/p>\n
\/\/ \u914d\u7f6e\u5ba2\u6237\u548c\u8054\u7cfb\u4eba\u4e4b\u95f4\u7684\u5173\u7cfb（\u4e00\u5bf9\u591a\u5173\u7cfb）
\n \/*
\n \u4f7f\u7528\u6ce8\u89e3\u7684\u5f62\u5f0f\u914d\u7f6e\u591a\u8868\u5173\u7cfb：
\n 1. \u58f0\u660e\u5173\u7cfb
\n – @OneToMany：\u914d\u7f6e\u4e00\u5bf9\u591a\u5173\u7cfb
\n targetEntity：\u5bf9\u65b9\u5bf9\u8c61\u7684\u5b57\u8282\u7801\u5bf9\u8c61
\n 2. \u914d\u7f6e\u5916\u952e（\u6216\u4e2d\u95f4\u8868）
\n – @JoinColumn：\u914d\u7f6e\u5916\u952e
\n name：\u4ece\u8868 \u5916\u952e\u5b57\u6bb5\u540d\u79f0
\n referencedColumnName：\u53c2\u7167\u7684 \u4e3b\u8868 \u7684\u4e3b\u952e\u5b57\u6bb5\u540d\u79f0<\/p>\n
\u6ce8：\u5728\u5ba2\u6237\u5b9e\u4f53\u7c7b\u4e0a（\u4e00\u7684\u4e00\u65b9）\u6dfb\u52a0\u4e86\u5916\u952e\u7684\u914d\u7f6e，\u6240\u4ee5\u5bf9\u4e8e\u5ba2\u6237\u800c\u8a00，\u4e5f\u5177\u5907\u4e86\u7ef4\u62a4\u5916\u952e\u7684\u4f5c\u7528<\/p>\n
*\/
\n @OneToMany(targetEntity = LinkMan.class)
\n @JoinColumn(name = "lkm_cust_id", referencedColumnName = "cust_id")
\n \/*
\n \u653e\u5f03\u5916\u952e\u7ef4\u62a4\u6743
\n mappedBy: \u5bf9\u65b9\u914d\u7f6e\u5173\u7cfb\u7684\u5c5e\u6027\u540d\u79f0
\n \u8868\u793a\u53c2\u7167\u5bf9\u65b9\u7684\u5c5e\u6027\u6765\u505a
\n *\/
\n\/\/ @OneToMany(mappedBy = "customer")
\n private Set<LinkMan> linkMans = new HashSet<>();<\/p>\n
\/\/ \u4e00\u5b9a\u8981\u81ea\u5df1\u5199，\u4e0d\u8981\u4f7f\u7528lombok\u63d0\u4f9b\u7684
\n @Override
\n public String toString() {
\n return "Customer{" +
\n "custId=" + custId +
\n ", custAddress='" + custAddress + '\\\\'' +
\n ", custIndustry='" + custIndustry + '\\\\'' +
\n ", custLevel='" + custLevel + '\\\\'' +
\n ", custName='" + custName + '\\\\'' +
\n ", custPhone='" + custPhone + '\\\\'' +
\n ", custSource='" + custSource + '\\\\'' +
\n ", linkMans=" + linkMans +
\n '}';
\n }
\n}<\/p>\n
\u91cd\u65b0\u6267\u884c，\u6548\u679c：<\/p>\n
Hibernate: alter table cst_linkman drop foreign key FKh9yp1nql5227xxcopuxqx2e7q
\nHibernate: drop table if exists cst_customer
\nHibernate: drop table if exists cst_linkman
\nHibernate: create table cst_customer (cust_id bigint not null auto_increment, cust_address varchar(255), cust_industry varchar(255), cust_level varchar(255), cust_name varchar(255), cust_phone varchar(255), cust_source varchar(255), primary key (cust_id))
\nHibernate: create table cst_linkman (lkm_id bigint not null auto_increment, lkm_email varchar(255), lkm_gender varchar(255), lkm_memo varchar(255), lkm_mobile varchar(255), lkm_name varchar(255), lkm_phone varchar(255), lkm_position varchar(255), lkm_cust_id bigint, primary key (lkm_id))
\nHibernate: alter table cst_linkman add constraint FKh9yp1nql5227xxcopuxqx2e7q foreign key (lkm_cust_id) references cst_customer (cust_id)
\nHibernate: insert into cst_customer (cust_address, cust_industry, cust_level, cust_name, cust_phone, cust_source) values (?, ?, ?, ?, ?, ?)
\nHibernate: insert into cst_linkman (lkm_cust_id, lkm_email, lkm_gender, lkm_memo, lkm_mobile, lkm_name, lkm_phone, lkm_position) values (?, ?, ?, ?, ?, ?, ?, ?)
\nHibernate: update cst_linkman set lkm_cust_id=? where lkm_id=?<\/p>\n
\u901a\u8fc7\u4fdd\u5b58\u7684\u6848\u4f8b，\u6211\u4eec\u53ef\u4ee5\u53d1\u73b0\u5728\u8bbe\u7f6e\u4e86\u53cc\u5411\u5173\u7cfb\u4e4b\u540e，\u4f1a\u53d1\u9001\u4e24\u6761insert\u8bed\u53e5，\u4e00\u6761\u591a\u4f59\u7684update\u8bed\u53e5，\u90a3\u6211\u4eec\u7684\u89e3\u51b3\u662f\u601d\u8def\u5f88\u7b80\u5355，\u5c31\u662f\u4e00\u7684\u4e00\u65b9\u653e\u5f03\u7ef4\u62a4\u6743，\u5728src\\\\main\\\\java\\\\top\\\\onefine\\\\domain\\\\Customer.java\u4e2d：<\/p>\n
\/\/ \u653e\u5f03\u5916\u952e\u7ef4\u62a4\u6743\u7684\u914d\u7f6e\u5c06\u5982\u4e0b\u914d\u7f6e\u6539\u4e3a
\n\/\/ @OneToMany(targetEntity = LinkMan.class)
\n\/\/ @JoinColumn(name = "lkm_cust_id", referencedColumnName = "cust_id")
\n \/*
\n \u653e\u5f03\u5916\u952e\u7ef4\u62a4\u6743
\n mappedBy: \u5bf9\u65b9\u914d\u7f6e\u5173\u7cfb\u7684\u5c5e\u6027\u540d\u79f0
\n \u8868\u793a\u53c2\u7167\u5bf9\u65b9\u7684\u5c5e\u6027\u6765\u505a
\n *\/
\n \/\/ \u8bbe\u7f6e\u4e3a
\n @OneToMany(mappedBy = "customer")
\n private Set<LinkMan> linkMans = new HashSet<>();<\/p>\n
\u91cd\u65b0\u6267\u884c\u6548\u679c：<\/p>\n
Hibernate: alter table cst_linkman drop foreign key FKh9yp1nql5227xxcopuxqx2e7q
\nHibernate: drop table if exists cst_customer
\nHibernate: drop table if exists cst_linkman
\nHibernate: create table cst_customer (cust_id bigint not null auto_increment, cust_address varchar(255), cust_industry varchar(255), cust_level varchar(255), cust_name varchar(255), cust_phone varchar(255), cust_source varchar(255), primary key (cust_id))
\nHibernate: create table cst_linkman (lkm_id bigint not null auto_increment, lkm_email varchar(255), lkm_gender varchar(255), lkm_memo varchar(255), lkm_mobile varchar(255), lkm_name varchar(255), lkm_phone varchar(255), lkm_position varchar(255), lkm_cust_id bigint, primary key (lkm_id))
\nHibernate: alter table cst_linkman add constraint FKh9yp1nql5227xxcopuxqx2e7q foreign key (lkm_cust_id) references cst_customer (cust_id)
\nHibernate: insert into cst_customer (cust_address, cust_industry, cust_level, cust_name, cust_phone, cust_source) values (?, ?, ?, ?, ?, ?)
\nHibernate: insert into cst_linkman (lkm_cust_id, lkm_email, lkm_gender, lkm_memo, lkm_mobile, lkm_name, lkm_phone, lkm_position) values (?, ?, ?, ?, ?, ?, ?, ?)<\/p>\n
@Autowired
\nprivate CustomerDao customerDao;<\/p>\n
@Test
\n@Transactional
\n@Rollback(false)\/\/\u8bbe\u7f6e\u4e3a\u4e0d\u56de\u6eda
\npublic void testDelete() {
\ncustomerDao.delete(1l);
\n}<\/p>\n
\u5220\u9664\u64cd\u4f5c\u7684\u8bf4\u660e\u5982\u4e0b：<\/p>\n
\u5220\u9664\u4ece\u8868\u6570\u636e：\u53ef\u4ee5\u968f\u65f6\u4efb\u610f\u5220\u9664\u3002<\/p>\n<\/li>\n
\u5220\u9664\u4e3b\u8868\u6570\u636e：<\/p>\n
\u6709\u4ece\u8868\u6570\u636e 1\u3001\u5728\u9ed8\u8ba4\u60c5\u51b5\u4e0b，\u5b83\u4f1a\u628a\u5916\u952e\u5b57\u6bb5\u7f6e\u4e3anull，\u7136\u540e\u5220\u9664\u4e3b\u8868\u6570\u636e\u3002\u5982\u679c\u5728\u6570\u636e\u5e93\u7684\u8868 \u7ed3\u6784\u4e0a，\u5916\u952e\u5b57\u6bb5\u6709\u975e\u7a7a\u7ea6\u675f，\u9ed8\u8ba4\u60c5\u51b5\u5c31\u4f1a\u62a5\u9519\u4e86\u3002 2\u3001\u5982\u679c\u914d\u7f6e\u4e86\u653e\u5f03\u7ef4\u62a4\u5173\u8054\u5173\u7cfb\u7684\u6743\u5229，\u5219\u4e0d\u80fd\u5220\u9664（\u4e0e\u5916\u952e\u5b57\u6bb5\u662f\u5426\u5141\u8bb8\u4e3anull， \u6ca1\u6709\u5173\u7cfb）\u56e0\u4e3a\u5728\u5220\u9664\u65f6，\u5b83\u6839\u672c\u4e0d\u4f1a\u53bb\u66f4\u65b0\u4ece\u8868\u7684\u5916\u952e\u5b57\u6bb5\u4e86\u3002 3\u3001\u5982\u679c\u8fd8\u60f3\u5220\u9664，\u4f7f\u7528\u7ea7\u8054\u5220\u9664\u5f15\u7528<\/p>\n
\u6ca1\u6709\u4ece\u8868\u6570\u636e\u5f15\u7528：\u968f\u4fbf\u5220<\/p>\n<\/li>\n<\/ul>\n
\u5728\u5b9e\u9645\u5f00\u53d1\u4e2d，\u7ea7\u8054\u5220\u9664\u8bf7\u614e\u7528！(\u5728\u4e00\u5bf9\u591a\u7684\u60c5\u51b5\u4e0b)<\/p>\n
\u7ea7\u8054\u64cd\u4f5c：\u6307\u64cd\u4f5c\u4e00\u4e2a\u5bf9\u8c61\u540c\u65f6\u64cd\u4f5c\u5b83\u7684\u5173\u8054\u5bf9\u8c61\u3002\u6709\u7ea7\u8054\u5220\u9664\u3001\u7ea7\u8054\u66f4\u65b0\u3001\u7ea7\u8054\u6dfb\u52a0\u2026<\/p>\n
\u4f7f\u7528\u65b9\u6cd5：\u53ea\u9700\u8981\u5728\u64cd\u4f5c\u4e3b\u4f53\u7684\u5b9e\u4f53\u7c7b\u4e0a\u6dfb\u52a0\u7ea7\u8054\u5c5e\u6027\u2014\u2014\u9700\u8981\u6dfb\u52a0\u5230\u591a\u8868\u6620\u5c04\u5173\u7cfb\u7684\u6ce8\u89e3\u4e0a，\u5373\u6ce8\u89e3\u4e0a\u914d\u7f6ecascade（\u4f5c\u7528：\u914d\u7f6e\u7ea7\u8054）<\/p>\n
\u6ce8\u610f\u533a\u5206\u64cd\u4f5c\u4e3b\u4f53<\/p>\n
\/**
\n * cascade:\u914d\u7f6e\u7ea7\u8054\u64cd\u4f5c
\n * CascadeType.MERGE\u7ea7\u8054\u66f4\u65b0
\n * CascadeType.PERSIST\u7ea7\u8054\u4fdd\u5b58：
\n * CascadeType.REFRESH \u7ea7\u8054\u5237\u65b0：
\n * CascadeType.REMOVE\u7ea7\u8054\u5220\u9664：
\n * CascadeType.ALL\u5305\u542b\u4ee5\u4e0a\u6240\u6709
\n *\/
\n@OneToMany(mappedBy="customer",cascade=CascadeType.ALL)<\/p>\n
src\\\\main\\\\resources\\\\applicationContext.xml\u4e2d：<\/p>\n
<bean>
\n <property name="jpaProperties">
\n <props>
\n <prop key="hibernate.hbm2ddl.auto">update<\/prop>
\n <\/props>
\n <\/property>
\n <\/bean><\/p>\n
src\\\\main\\\\java\\\\top\\\\onefine\\\\domain\\\\Customer.java\u4e2d：<\/p>\n
\/*
\n \u653e\u5f03\u5916\u952e\u7ef4\u62a4\u6743
\n mappedBy: \u5bf9\u65b9\u914d\u7f6e\u5173\u7cfb\u7684\u5c5e\u6027\u540d\u79f0
\n \u8868\u793a\u53c2\u7167\u5bf9\u65b9\u7684\u5c5e\u6027\u6765\u505a<\/p>\n
cascade:\u914d\u7f6e\u7ea7\u8054\u64cd\u4f5c，\u53ef\u4ee5\u914d\u7f6e\u5230\u8bbe\u7f6e\u591a\u8868\u7684\u6620\u5c04\u5173\u7cfb\u7684\u6ce8\u89e3\u4e0a
\n * CascadeType.MERGE\u7ea7\u8054\u66f4\u65b0
\n * CascadeType.PERSIST\u7ea7\u8054\u4fdd\u5b58：
\n * CascadeType.REFRESH \u7ea7\u8054\u5237\u65b0：
\n * CascadeType.REMOVE\u7ea7\u8054\u5220\u9664：
\n * CascadeType.ALL\u5305\u542b\u4ee5\u4e0a\u6240\u6709，\u63a8\u8350\u914d\u7f6e
\n *\/
\n @OneToMany(mappedBy = "customer", cascade = CascadeType.ALL)
\n private Set<LinkMan> linkMans = new HashSet<>();<\/p>\n
\/\/ \u7ea7\u8054\u6dfb\u52a0：\u4fdd\u5b58\u4e00\u4e2a\u5ba2\u6237\u7684\u540c\u65f6，\u4fdd\u5b58\u8be5\u5ba2\u6237\u7684\u6240\u6709\u8054\u7cfb\u4eba
\n \/\/ \u9700\u8981\u5728\u64cd\u4f5c\u4e3b\u4f53\u7684\u5b9e\u4f53\u7c7b\u4e0a，\u914d\u7f6ecasacde\u5c5e\u6027
\n @Test
\n @Transactional \/\/ \u914d\u7f6e\u4e8b\u52a1
\n @Rollback(false) \/\/ \u4e0d\u81ea\u52a8\u56de\u6eda
\n public void testCascadeAdd() {
\n Customer customer = new Customer();
\n customer.setCustName("\u767e\u5ea61");
\n LinkMan linkMan1 = new LinkMan();
\n linkMan1.setLkmName("\u5c0f\u738b1");
\n LinkMan linkMan2 = new LinkMan();
\n linkMan2.setLkmName("\u5c0f\u738b2");<\/p>\n
customer.getLinkMans().add(linkMan1);
\n customer.getLinkMans().add(linkMan2);
\n linkMan1.setCustomer(customer);
\n linkMan2.setCustomer(customer);<\/p>\n
customerDao.save(customer); \/\/ \u64cd\u4f5c\u7684\u4e3b\u4f53\u662fCustomer
\n }<\/p>\n
\u6548\u679c：<\/p>\n
Hibernate: insert into cst_customer (cust_address, cust_industry, cust_level, cust_name, cust_phone, cust_source) values (?, ?, ?, ?, ?, ?)
\nHibernate: insert into cst_linkman (lkm_cust_id, lkm_email, lkm_gender, lkm_memo, lkm_mobile, lkm_name, lkm_phone, lkm_position) values (?, ?, ?, ?, ?, ?, ?, ?)
\nHibernate: insert into cst_linkman (lkm_cust_id, lkm_email, lkm_gender, lkm_memo, lkm_mobile, lkm_name, lkm_phone, lkm_position) values (?, ?, ?, ?, ?, ?, ?, ?)<\/p>\n
\u7ea7\u8054\u5220\u9664：<\/p>\n
\/\/ \u7ea7\u8054\u5220\u9664：\u5220\u96642\u53f7\u5ba2\u6237（\u4e0a\u4e2a\u7ea7\u8054\u6dfb\u52a0\u6dfb\u52a0\u7684\u6570\u636e）\u7684\u540c\u65f6，\u5220\u96642\u53f7\u5ba2\u6237\u7684\u6240\u6709\u8054\u7cfb\u4eba
\n \/\/ \u9700\u8981\u5728\u64cd\u4f5c\u4e3b\u4f53\u7684\u5b9e\u4f53\u7c7b\u4e0a，\u914d\u7f6ecasacde\u5c5e\u6027
\n @Test
\n @Transactional \/\/ \u914d\u7f6e\u4e8b\u52a1
\n @Rollback(false) \/\/ \u4e0d\u81ea\u52a8\u56de\u6eda
\n public void testCascadeRemove() {
\n \/\/ 1. \u67e5\u8be2\u5ba2\u6237
\n Customer customer = customerDao.findOne(2L);
\n \/\/ 2. \u5220\u96642\u53f7\u5ba2\u6237
\n customerDao.delete(customer);
\n }<\/p>\n
\u6548\u679c：<\/p>\n
Hibernate: select customer0_.cust_id as cust_id1_0_0_, customer0_.cust_address as cust_add2_0_0_, customer0_.cust_industry as cust_ind3_0_0_, customer0_.cust_level as cust_lev4_0_0_, customer0_.cust_name as cust_nam5_0_0_, customer0_.cust_phone as cust_pho6_0_0_, customer0_.cust_source as cust_sou7_0_0_ from cst_customer customer0_ where customer0_.cust_id=?
\nHibernate: select linkmans0_.lkm_cust_id as lkm_cust9_1_0_, linkmans0_.lkm_id as lkm_id1_1_0_, linkmans0_.lkm_id as lkm_id1_1_1_, linkmans0_.lkm_cust_id as lkm_cust9_1_1_, linkmans0_.lkm_email as lkm_emai2_1_1_, linkmans0_.lkm_gender as lkm_gend3_1_1_, linkmans0_.lkm_memo as lkm_memo4_1_1_, linkmans0_.lkm_mobile as lkm_mobi5_1_1_, linkmans0_.lkm_name as lkm_name6_1_1_, linkmans0_.lkm_phone as lkm_phon7_1_1_, linkmans0_.lkm_position as lkm_posi8_1_1_ from cst_linkman linkmans0_ where linkmans0_.lkm_cust_id=?
\nHibernate: delete from cst_linkman where lkm_id=?
\nHibernate: delete from cst_linkman where lkm_id=?
\nHibernate: delete from cst_customer where cust_id=?<\/p>\n
\u91c7\u7528\u7684\u793a\u4f8b\u4e3a\u7528\u6237\u548c\u89d2\u8272\u3002<\/p>\n
\u7528\u6237：\u6307\u7684\u662f\u54b1\u4eec\u73ed\u7684\u6bcf\u4e00\u4e2a\u540c\u5b66\u3002<\/p>\n<\/li>\n
\u89d2\u8272：\u6307\u7684\u662f\u54b1\u4eec\u73ed\u540c\u5b66\u7684\u8eab\u4efd\u4fe1\u606f\u3002<\/p>\n<\/li>\n<\/ul>\n
\u6bd4\u5982A\u540c\u5b66，\u5b83\u662f\u6211\u7684\u5b66\u751f，\u5176\u4e2d\u6709\u4e2a\u8eab\u4efd\u5c31\u662f\u5b66\u751f，\u8fd8\u662f\u5bb6\u91cc\u7684\u5b69\u5b50，\u90a3\u4e48\u4ed6\u8fd8\u6709\u4e2a\u8eab\u4efd\u662f\u5b50\u5973\u3002<\/p>\n
\u540c\u65f6B\u540c\u5b66，\u5b83\u4e5f\u5177\u6709\u5b66\u751f\u548c\u5b50\u5973\u7684\u8eab\u4efd\u3002<\/p>\n
\u90a3\u4e48\u4efb\u4f55\u4e00\u4e2a\u540c\u5b66\u90fd\u53ef\u80fd\u5177\u6709\u591a\u4e2a\u8eab\u4efd\u3002\u540c\u65f6\u5b66\u751f\u8fd9\u4e2a\u8eab\u4efd\u53ef\u4ee5\u88ab\u591a\u4e2a\u540c\u5b66\u6240\u5177\u6709\u3002<\/p>\n
\u6240\u4ee5\u6211\u4eec\u8bf4，\u7528\u6237\u548c\u89d2\u8272\u4e4b\u95f4\u7684\u5173\u7cfb\u662f\u591a\u5bf9\u591a\u3002<\/p>\n
\u5206\u6790\u6b65\u9aa4：<\/p>\n
1.\u660e\u786e\u8868\u5173\u7cfb：\u591a\u5bf9\u591a\u5173\u7cfb 2.\u786e\u5b9a\u8868\u5173\u7cfb（\u63cf\u8ff0 \u5916\u952e|\u4e2d\u95f4\u8868）：\u4e2d\u95f4\u95f4\u8868 3.\u7f16\u5199\u5b9e\u4f53\u7c7b，\u518d\u5b9e\u4f53\u7c7b\u4e2d\u63cf\u8ff0\u8868\u5173\u7cfb（\u5305\u542b\u5173\u7cfb）<\/p>\n
4.\u914d\u7f6e\u6620\u5c04\u5173\u7cfb<\/p>\n
\u591a\u5bf9\u591a\u7684\u8868\u5173\u7cfb\u5efa\u7acb\u9760\u7684\u662f\u4e2d\u95f4\u8868，\u5176\u4e2d\u7528\u6237\u8868\u548c\u4e2d\u95f4\u8868\u7684\u5173\u7cfb\u662f\u4e00\u5bf9\u591a，\u89d2\u8272\u8868\u548c\u4e2d\u95f4\u8868\u7684\u5173\u7cfb\u4e5f\u662f\u4e00\u5bf9\u591a，\u5982\u4e0b\u56fe\u6240\u793a：<\/p>\n
![\"\"](\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/04\/20250418100257-68022351e29c8.png\")
<\/p>\n
\u4e00\u4e2a\u7528\u6237\u53ef\u4ee5\u5177\u6709\u591a\u4e2a\u89d2\u8272，\u6240\u4ee5\u5728\u7528\u6237\u5b9e\u4f53\u7c7b\u4e2d\u5e94\u8be5\u5305\u542b\u591a\u4e2a\u89d2\u8272\u7684\u4fe1\u606f，\u4ee3\u7801\u5982\u4e0b：<\/p>\n
package top.onefine.domain;<\/p>\n
import lombok.Getter;
\nimport lombok.Setter;<\/p>\n
import javax.persistence.*;
\nimport java.util.HashSet;
\nimport java.util.Set;<\/p>\n
@Entity
\n@Table(name = "sys_user")
\n@Getter
\n@Setter
\npublic class User {
\n @Id
\n @GeneratedValue(strategy = GenerationType.IDENTITY)
\n @Column(name = "user_id")
\n private Long userId;
\n @Column(name = "user_name")
\n private String userName;
\n @Column(name = "user_age")
\n private Integer age;<\/p>\n
\/\/ \u914d\u7f6e\u7528\u6237\u5230\u89d2\u8272\u7684\u591a\u5bf9\u591a\u5173\u7cfb
\n \/**
\n * \u914d\u7f6e\u591a\u5bf9\u591a\u7684\u6620\u5c04\u5173\u7cfb
\n * 1. \u58f0\u660e\u8868\u5173\u7cfb\u7684\u914d\u7f6e
\n * @ ManyToMany(targetEntity = Role.class) \/\/ \u591a\u5bf9\u591a
\n * targetEntity \u4ee3\u8868\u5bf9\u65b9\u7684\u5b9e\u4f53\u7c7b\u5b57\u8282\u7801
\n * 2. \u914d\u7f6e\u4e2d\u95f4\u8868（\u5305\u542b\u4e24\u4e2a\u5916\u952e）
\n * @ JoinTable
\n * name \u914d\u7f6e\u4e2d\u95f4\u8868\u540d\u79f0
\n * joinColumns\u7684\u6570\u7ec4 \u914d\u7f6e\u5f53\u524d\u5bf9\u8c61\u5728\u4e2d\u95f4\u8868\u7684\u5916\u952e
\n * @ JoinColumn
\n * name\u5916\u952e\u540d
\n * referencedColumnName\u53c2\u7167\u4e3b\u8868\u7684\u4e3b\u952e\u540d
\n * inverseJoinColumns\u7684\u6570\u7ec4 \u914d\u7f6e\u5bf9\u65b9\u5bf9\u8c61\u5728\u4e2d\u95f4\u8868\u7684\u5916\u952e
\n * @ JoinColumn
\n * name\u5916\u952e\u540d
\n * referencedColumnName\u53c2\u7167\u4e3b\u8868\u7684\u4e3b\u952e\u540d
\n *\/
\n @ManyToMany(targetEntity = Role.class)
\n @JoinTable(name = "sys_user_role", \/\/ \u914d\u7f6e\u4e2d\u95f4\u8868\u540d\u79f0
\n joinColumns = {@JoinColumn(name = "sys_user_id", referencedColumnName = "user_id")}, \/\/ \u914d\u7f6e\u5f53\u524d\u5bf9\u8c61\u5728\u4e2d\u95f4\u8868\u4e2d\u7684\u5916\u952e，name\u968f\u4fbf，referencedColumnName\u53c2\u7167\u5f53\u524d\u5bf9\u8c61\u4e3b\u952e
\n inverseJoinColumns = {@JoinColumn(name = "sys_role_id", referencedColumnName = "role_id")} \/\/ \u914d\u7f6e\u5bf9\u65b9\u5bf9\u8c61\u5728\u4e2d\u95f4\u8868\u7684\u5916\u952e，name\u968f\u4fbf，referencedColumnName\u53c2\u7167\u5f53\u524d\u5bf9\u8c61\u4e3b\u952e
\n )
\n private Set<Role> roles = new HashSet<>();<\/p>\n
@Override
\n public String toString() {
\n return "User{" +
\n "userId=" + userId +
\n ", userName='" + userName + '\\\\'' +
\n ", age=" + age +
\n '}';
\n }
\n}<\/p>\n
package top.onefine.domain;<\/p>\n
import lombok.Getter;
\nimport lombok.Setter;<\/p>\n
import javax.persistence.*;
\nimport java.util.HashSet;
\nimport java.util.Set;<\/p>\n
@Entity
\n@Table(name = "sys_role")
\n@Getter
\n@Setter
\npublic class Role {
\n @Id
\n @GeneratedValue(strategy = GenerationType.IDENTITY)
\n @Column(name = "role_id")
\n private Long roleId;
\n @Column(name = "role_name")
\n private String roleName;<\/p>\n
\/\/ \u914d\u7f6e\u89d2\u8272\u5230\u7528\u6237\u7684\u591a\u5bf9\u591a\u5173\u7cfb
\n @ManyToMany(targetEntity = User.class) \/\/ \u58f0\u660e\u591a\u5bf9\u591a\u7684\u5173\u7cfb
\n @JoinTable(name = "sys_user_role", \/\/ \u914d\u7f6e\u4e2d\u95f4\u8868\u540d\u79f0
\n joinColumns = {@JoinColumn(name = "sys_role_id", referencedColumnName = "role_id")}, \/\/ \u914d\u7f6e\u5f53\u524d\u5bf9\u8c61\u5728\u4e2d\u95f4\u8868\u4e2d\u7684\u5916\u952e，name\u968f\u4fbf，referencedColumnName\u53c2\u7167\u5f53\u524d\u5bf9\u8c61\u4e3b\u952e
\n inverseJoinColumns = {@JoinColumn(name = "sys_user_id", referencedColumnName = "user_id")} \/\/ \u914d\u7f6e\u5bf9\u65b9\u5bf9\u8c61\u5728\u4e2d\u95f4\u8868\u7684\u5916\u952e，name\u968f\u4fbf，referencedColumnName\u53c2\u7167\u5f53\u524d\u5bf9\u8c61\u4e3b\u952e
\n )
\n \/\/ \u653e\u5f03\u4e3b\u952e\u7ef4\u62a4\u6743
\n\/\/ @ManyToMany(mappedBy = "roles")
\n private Set<User> users = new HashSet<>();<\/p>\n
@Override
\n public String toString() {
\n return "User{" +
\n "roleId=" + roleId +
\n ", roleName='" + roleName + '\\\\'' +
\n '}';
\n }
\n}<\/p>\n
@ManyToMany \u00a0\u00a0 \u00a0\u4f5c\u7528：\u7528\u4e8e\u6620\u5c04\u591a\u5bf9\u591a\u5173\u7cfb \u00a0\u00a0 \u00a0\u5c5e\u6027： \u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0cascade：\u914d\u7f6e\u7ea7\u8054\u64cd\u4f5c\u3002 \u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0fetch：\u914d\u7f6e\u662f\u5426\u91c7\u7528\u5ef6\u8fdf\u52a0\u8f7d\u3002 \u00a0 \u00a0 \u00a0\u00a0 \u00a0targetEntity：\u914d\u7f6e\u76ee\u6807\u7684\u5b9e\u4f53\u7c7b\u3002\u6620\u5c04\u591a\u5bf9\u591a\u7684\u65f6\u5019\u4e0d\u7528\u5199\u3002<\/p>\n
@JoinTable \u00a0 \u00a0 \u4f5c\u7528：\u9488\u5bf9\u4e2d\u95f4\u8868\u7684\u914d\u7f6e \u00a0 \u00a0 \u5c5e\u6027： \u00a0 \u00a0 \u00a0\u00a0 \u00a0nam：\u914d\u7f6e\u4e2d\u95f4\u8868\u7684\u540d\u79f0 \u00a0 \u00a0 \u00a0\u00a0 \u00a0joinColumns：\u4e2d\u95f4\u8868\u7684\u5916\u952e\u5b57\u6bb5\u5173\u8054\u5f53\u524d\u5b9e\u4f53\u7c7b\u6240\u5bf9\u5e94\u8868\u7684\u4e3b\u952e\u5b57\u6bb5\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0 \u00a0inverseJoinColumn：\u4e2d\u95f4\u8868\u7684\u5916\u952e\u5b57\u6bb5\u5173\u8054\u5bf9\u65b9\u8868\u7684\u4e3b\u952e\u5b57\u6bb5 \u00a0 \u00a0 \u00a0\u00a0 \u00a0 @JoinColumn \u00a0 \u00a0 \u4f5c\u7528：\u7528\u4e8e\u5b9a\u4e49\u4e3b\u952e\u5b57\u6bb5\u548c\u5916\u952e\u5b57\u6bb5\u7684\u5bf9\u5e94\u5173\u7cfb\u3002 \u00a0 \u00a0 \u5c5e\u6027： \u00a0 \u00a0 \u00a0\u00a0 \u00a0name：\u6307\u5b9a\u5916\u952e\u5b57\u6bb5\u7684\u540d\u79f0 \u00a0 \u00a0 \u00a0\u00a0 \u00a0referencedColumnName：\u6307\u5b9a\u5f15\u7528\u4e3b\u8868\u7684\u4e3b\u952e\u5b57\u6bb5\u540d\u79f0 \u00a0 \u00a0 \u00a0\u00a0 \u00a0unique：\u662f\u5426\u552f\u4e00\u3002\u9ed8\u8ba4\u503c\u4e0d\u552f\u4e00 \u00a0 \u00a0 \u00a0\u00a0 \u00a0nullable：\u662f\u5426\u5141\u8bb8\u4e3a\u7a7a\u3002\u9ed8\u8ba4\u503c\u5141\u8bb8\u3002 \u00a0 \u00a0 \u00a0\u00a0 \u00a0insertable：\u662f\u5426\u5141\u8bb8\u63d2\u5165\u3002\u9ed8\u8ba4\u503c\u5141\u8bb8\u3002 \u00a0 \u00a0 \u00a0\u00a0 \u00a0updatable：\u662f\u5426\u5141\u8bb8\u66f4\u65b0\u3002\u9ed8\u8ba4\u503c\u5141\u8bb8\u3002 \u00a0 \u00a0 \u00a0\u00a0 \u00a0columnDefinition：\u5217\u7684\u5b9a\u4e49\u4fe1\u606f\u3002<\/p>\n
src\\\\main\\\\resources\\\\applicationContext.xml\u4e2d：<\/p>\n
<bean>
\n<property name="jpaProperties">
\n <props>
\n <prop key="hibernate.hbm2ddl.auto">create<\/prop>
\n <\/props>
\n <\/property>
\n<\/bean><\/p>\n
src\\\\main\\\\java\\\\top\\\\onefine\\\\dao\\\\UserDao.java：<\/p>\n
package top.onefine.dao;<\/p>\n
import org.springframework.data.jpa.repository.JpaRepository;
\nimport org.springframework.data.jpa.repository.JpaSpecificationExecutor;
\nimport top.onefine.domain.User;<\/p>\n
public interface UserDao extends JpaRepository<User, Long>, JpaSpecificationExecutor<User> {
\n}<\/p>\n
src\\\\main\\\\java\\\\top\\\\onefine\\\\dao\\\\RoleDao.java：<\/p>\n
package top.onefine.dao;<\/p>\n
import org.springframework.data.jpa.repository.JpaRepository;
\nimport org.springframework.data.jpa.repository.JpaSpecificationExecutor;
\nimport top.onefine.domain.Role;<\/p>\n
public interface RoleDao extends JpaRepository<Role, Long>, JpaSpecificationExecutor<Role> {
\n}<\/p>\n
\u6817\u5b501：<\/p>\n
package top.onefine.test;<\/p>\n
import org.junit.Test;
\nimport org.junit.runner.RunWith;
\nimport org.springframework.beans.factory.annotation.Autowired;
\nimport org.springframework.test.annotation.Rollback;
\nimport org.springframework.test.context.ContextConfiguration;
\nimport org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
\nimport org.springframework.transaction.annotation.Transactional;
\nimport top.onefine.dao.RoleDao;
\nimport top.onefine.dao.UserDao;
\nimport top.onefine.domain.Role;
\nimport top.onefine.domain.User;<\/p>\n
@SuppressWarnings("All")
\n@RunWith(SpringJUnit4ClassRunner.class)
\n@ContextConfiguration(locations = "classpath:applicationContext.xml")
\npublic class Many2ManyTest {<\/p>\n
@Autowired
\n private UserDao userDao;<\/p>\n
@Autowired
\n private RoleDao roleDao;<\/p>\n
\/\/ \u4fdd\u5b58\u4e00\u4e2a\u7528\u6237，\u4fdd\u5b58\u4e00\u4e2a\u89d2\u8272
\n @Test
\n @Transactional
\n @Rollback(false)
\n public void testAdd() {
\n User user = new User();
\n user.setUserName("one fine");
\n Role role = new Role();
\n role.setRoleName("Java \u5de5\u7a0b\u5e08");<\/p>\n
userDao.save(user);
\n roleDao.save(role);
\n }
\n}<\/p>\n
\u7ed3\u679c：<\/p>\n
Hibernate: alter table sys_user_role drop foreign key FK1ef5794xnbirtsnudta6p32on
\nHibernate: alter table sys_user_role drop foreign key FKsbjvgfdwwy5rfbiag1bwh9x2b
\nHibernate: drop table if exists sys_role
\nHibernate: drop table if exists sys_user
\nHibernate: drop table if exists sys_user_role
\nHibernate: create table sys_role (role_id bigint not null auto_increment, role_name varchar(255), primary key (role_id))
\nHibernate: create table sys_user (user_id bigint not null auto_increment, user_age integer, user_name varchar(255), primary key (user_id))
\nHibernate: create table sys_user_role (sys_user_id bigint not null, sys_role_id bigint not null, primary key (sys_role_id, sys_user_id))
\nHibernate: alter table sys_user_role add constraint FK1ef5794xnbirtsnudta6p32on foreign key (sys_role_id) references sys_role (role_id)
\nHibernate: alter table sys_user_role add constraint FKsbjvgfdwwy5rfbiag1bwh9x2b foreign key (sys_user_id) references sys_user (user_id)
\nHibernate: insert into sys_user (user_age, user_name) values (?, ?)
\nHibernate: insert into sys_role (role_name) values (?)<\/p>\n
\u6817\u5b502：<\/p>\n
\/\/ \u4fdd\u5b58\u4e00\u4e2a\u7528\u6237，\u4fdd\u5b58\u4e00\u4e2a\u89d2\u8272
\n @Test
\n @Transactional
\n @Rollback(false)
\n public void testAdd() {
\n User user = new User();
\n user.setUserName("one fine");
\n Role role = new Role();
\n role.setRoleName("Java \u5de5\u7a0b\u5e08");<\/p>\n
\/\/ \u914d\u7f6e\u7528\u6237\u5230\u89d2\u8272\u5173\u7cfb，\u53ef\u4ee5\u5bf9\u4e2d\u95f4\u8868\u4e2d\u7684\u6570\u636e\u8fdb\u884c\u7ef4\u62a4
\n user.getRoles().add(role);<\/p>\n
userDao.save(user);
\n roleDao.save(role);
\n }<\/p>\n
\u7ed3\u679c：<\/p>\n
Hibernate: alter table sys_user_role drop foreign key FK1ef5794xnbirtsnudta6p32on
\nHibernate: alter table sys_user_role drop foreign key FKsbjvgfdwwy5rfbiag1bwh9x2b
\nHibernate: drop table if exists sys_role
\nHibernate: drop table if exists sys_user
\nHibernate: drop table if exists sys_user_role
\nHibernate: create table sys_role (role_id bigint not null auto_increment, role_name varchar(255), primary key (role_id))
\nHibernate: create table sys_user (user_id bigint not null auto_increment, user_age integer, user_name varchar(255), primary key (user_id))
\nHibernate: create table sys_user_role (sys_user_id bigint not null, sys_role_id bigint not null, primary key (sys_role_id, sys_user_id))
\nHibernate: alter table sys_user_role add constraint FK1ef5794xnbirtsnudta6p32on foreign key (sys_role_id) references sys_role (role_id)
\nHibernate: alter table sys_user_role add constraint FKsbjvgfdwwy5rfbiag1bwh9x2b foreign key (sys_user_id) references sys_user (user_id)
\nHibernate: insert into sys_user (user_age, user_name) values (?, ?)
\nHibernate: insert into sys_role (role_name) values (?)
\nHibernate: insert into sys_user_role (sys_user_id, sys_role_id) values (?, ?)<\/p>\n
\u6817\u5b503：<\/p>\n
@Test
\n @Transactional
\n @Rollback(false)
\n public void testAdd() {
\n User user = new User();
\n user.setUserName("one fine");
\n Role role = new Role();
\n role.setRoleName("Java \u5de5\u7a0b\u5e08");<\/p>\n
\/\/ \u914d\u7f6e\u89d2\u8272\u5230\u7528\u6237\u5173\u7cfb，\u53ef\u4ee5\u5bf9\u4e2d\u95f4\u8868\u4e2d\u7684\u6570\u636e\u8fdb\u884c\u7ef4\u62a4
\n role.getUsers().add(user);<\/p>\n
userDao.save(user);
\n roleDao.save(role);
\n }<\/p>\n
\u6548\u679c：<\/p>\n
Hibernate: alter table sys_user_role drop foreign key FK1ef5794xnbirtsnudta6p32on
\nHibernate: alter table sys_user_role drop foreign key FKsbjvgfdwwy5rfbiag1bwh9x2b
\nHibernate: drop table if exists sys_role
\nHibernate: drop table if exists sys_user
\nHibernate: drop table if exists sys_user_role
\nHibernate: create table sys_role (role_id bigint not null auto_increment, role_name varchar(255), primary key (role_id))
\nHibernate: create table sys_user (user_id bigint not null auto_increment, user_age integer, user_name varchar(255), primary key (user_id))
\nHibernate: create table sys_user_role (sys_user_id bigint not null, sys_role_id bigint not null, primary key (sys_role_id, sys_user_id))
\nHibernate: alter table sys_user_role add constraint FK1ef5794xnbirtsnudta6p32on foreign key (sys_role_id) references sys_role (role_id)
\nHibernate: alter table sys_user_role add constraint FKsbjvgfdwwy5rfbiag1bwh9x2b foreign key (sys_user_id) references sys_user (user_id)
\nHibernate: insert into sys_user (user_age, user_name) values (?, ?)
\nHibernate: insert into sys_role (role_name) values (?)
\nHibernate: insert into sys_user_role (sys_role_id, sys_user_id) values (?, ?)<\/p>\n
\u6817\u5b504：<\/p>\n
\/\/ \u4fdd\u5b58\u4e00\u4e2a\u7528\u6237，\u4fdd\u5b58\u4e00\u4e2a\u89d2\u8272
\n @Test
\n @Transactional
\n @Rollback(false)
\n public void testAdd() {
\n User user = new User();
\n user.setUserName("one fine");
\n Role role = new Role();
\n role.setRoleName("Java \u5de5\u7a0b\u5e08");<\/p>\n
\/\/ \u914d\u7f6e\u7528\u6237\u5230\u89d2\u8272\u5173\u7cfb，\u53ef\u4ee5\u5bf9\u4e2d\u95f4\u8868\u4e2d\u7684\u6570\u636e\u8fdb\u884c\u7ef4\u62a41:1
\n user.getRoles().add(role);<\/p>\n
\/\/ \u914d\u7f6e\u89d2\u8272\u5230\u7528\u6237\u5173\u7cfb，\u53ef\u4ee5\u5bf9\u4e2d\u95f4\u8868\u4e2d\u7684\u6570\u636e\u8fdb\u884c\u7ef4\u62a41:1
\n role.getUsers().add(user);<\/p>\n
userDao.save(user);
\n roleDao.save(role);
\n }<\/p>\n
\u6267\u884c\u629b\u51fa\u5f02\u5e38，\u4e3b\u952e\u51b2\u7a81：<\/p>\n
![\"\"](\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/04\/20250418100257-68022351f39b3.png\")
<\/p>\n
![\"\"](\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/04\/20250418100258-68022352705ce.png\")
<\/p>\n
\u5728\u591a\u5bf9\u591a（\u4fdd\u5b58）\u4e2d，\u5982\u679c\u53cc\u5411\u90fd\u8bbe\u7f6e\u5173\u7cfb，\u610f\u5473\u7740\u53cc\u65b9\u90fd\u7ef4\u62a4\u4e2d\u95f4\u8868，\u90fd\u4f1a\u5f80\u4e2d\u95f4\u8868\u63d2\u5165\u6570\u636e，\u4e2d\u95f4\u8868\u76842\u4e2a\u5b57\u6bb5\u53c8\u4f5c\u4e3a\u8054\u5408\u4e3b\u952e，\u6240\u4ee5\u62a5\u9519，\u4e3b\u952e\u91cd\u590d，\u89e3\u51b3\u4fdd\u5b58\u5931\u8d25\u7684\u95ee\u9898：\u53ea\u9700\u8981\u5728\u4efb\u610f\u4e00\u65b9\u653e\u5f03\u5bf9\u4e2d\u95f4\u8868\u7684\u7ef4\u62a4\u6743\u5373\u53ef，\u63a8\u8350\u5728\u88ab\u52a8\u7684\u4e00\u65b9\u653e\u5f03，\u88ab\u9009\u62e9\u7684\u653e\u5f03，\u8fd9\u91cc\u662f\u89d2\u8272\u88ab\u7528\u6237\u9009\u62e9，\u6240\u4ee5\u89d2\u8272\u653e\u5f03\u7ef4\u62a4\u6743，\u914d\u7f6e\u5982\u4e0b：<\/p>\n
\/\/ \/\/ \u914d\u7f6e\u89d2\u8272\u5230\u7528\u6237\u7684\u591a\u5bf9\u591a\u5173\u7cfb
\n\/\/ @ManyToMany(targetEntity = User.class) \/\/ \u58f0\u660e\u591a\u5bf9\u591a\u7684\u5173\u7cfb
\n\/\/ @JoinTable(name = "sys_user_role", \/\/ \u914d\u7f6e\u4e2d\u95f4\u8868\u540d\u79f0
\n\/\/ joinColumns = {@JoinColumn(name = "sys_role_id", referencedColumnName = "role_id")}, \/\/ \u914d\u7f6e\u5f53\u524d\u5bf9\u8c61\u5728\u4e2d\u95f4\u8868\u4e2d\u7684\u5916\u952e，name\u968f\u4fbf，referencedColumnName\u53c2\u7167\u5f53\u524d\u5bf9\u8c61\u4e3b\u952e
\n\/\/ inverseJoinColumns = {@JoinColumn(name = "sys_user_id", referencedColumnName = "user_id")} \/\/ \u914d\u7f6e\u5bf9\u65b9\u5bf9\u8c61\u5728\u4e2d\u95f4\u8868\u7684\u5916\u952e，name\u968f\u4fbf，referencedColumnName\u53c2\u7167\u5f53\u524d\u5bf9\u8c61\u4e3b\u952e
\n\/\/ )
\n \/\/ \u653e\u5f03\u4e3b\u952e\u7ef4\u62a4\u6743，\u89e3\u51b3\u4fdd\u5b58\u4e2d\u4e3b\u952e\u51b2\u7a81\u7684\u95ee\u9898
\n @ManyToMany(mappedBy = "roles")
\n private Set<User> users = new HashSet<>();<\/p>\n
\u91cd\u65b0\u6267\u884c，\u6548\u679c：<\/p>\n
Hibernate: alter table sys_user_role drop foreign key FK1ef5794xnbirtsnudta6p32on
\nHibernate: alter table sys_user_role drop foreign key FKsbjvgfdwwy5rfbiag1bwh9x2b
\nHibernate: drop table if exists sys_role
\nHibernate: drop table if exists sys_user
\nHibernate: drop table if exists sys_user_role
\nHibernate: create table sys_role (role_id bigint not null auto_increment, role_name varchar(255), primary key (role_id))
\nHibernate: create table sys_user (user_id bigint not null auto_increment, user_age integer, user_name varchar(255), primary key (user_id))
\nHibernate: create table sys_user_role (sys_user_id bigint not null, sys_role_id bigint not null, primary key (sys_user_id, sys_role_id))
\nHibernate: alter table sys_user_role add constraint FK1ef5794xnbirtsnudta6p32on foreign key (sys_role_id) references sys_role (role_id)
\nHibernate: alter table sys_user_role add constraint FKsbjvgfdwwy5rfbiag1bwh9x2b foreign key (sys_user_id) references sys_user (user_id)
\nHibernate: insert into sys_user (user_age, user_name) values (?, ?)
\nHibernate: insert into sys_role (role_name) values (?)
\nHibernate: insert into sys_user_role (sys_user_id, sys_role_id) values (?, ?)<\/p>\n
src\\\\main\\\\java\\\\top\\\\onefine\\\\domain\\\\User.java\u4e2d：<\/p>\n
@ManyToMany(targetEntity = Role.class, cascade = CascadeType.ALL)
\n @JoinTable(name = "sys_user_role", \/\/ \u914d\u7f6e\u4e2d\u95f4\u8868\u540d\u79f0
\n joinColumns = {@JoinColumn(name = "sys_user_id", referencedColumnName = "user_id")}, \/\/ \u914d\u7f6e\u5f53\u524d\u5bf9\u8c61\u5728\u4e2d\u95f4\u8868\u4e2d\u7684\u5916\u952e，name\u968f\u4fbf，referencedColumnName\u53c2\u7167\u5f53\u524d\u5bf9\u8c61\u4e3b\u952e
\n inverseJoinColumns = {@JoinColumn(name = "sys_role_id", referencedColumnName = "role_id")} \/\/ \u914d\u7f6e\u5bf9\u65b9\u5bf9\u8c61\u5728\u4e2d\u95f4\u8868\u7684\u5916\u952e，name\u968f\u4fbf，referencedColumnName\u53c2\u7167\u5f53\u524d\u5bf9\u8c61\u4e3b\u952e
\n )
\n private Set<Role> roles = new HashSet<>();<\/p>\n
src\\\\test\\\\java\\\\top\\\\onefine\\\\test\\\\Many2ManyTest.java\u4e2d：<\/p>\n
\/\/ \u6d4b\u8bd5\u7ea7\u8054\u6dfb\u52a0：\u4fdd\u5b58\u4e00\u4e2a\u7528\u6237\u7684\u540c\u65f6\u4fdd\u5b58\u7528\u6237\u7684\u5173\u8054\u89d2\u8272
\n @Test
\n @Transactional
\n @Rollback(false)
\n public void testCasCadeAdd() {
\n User user = new User();
\n user.setUserName("one fine");
\n Role role = new Role();
\n role.setRoleName("Java \u5de5\u7a0b\u5e08");<\/p>\n
\/\/ \u914d\u7f6e\u7528\u6237\u5230\u89d2\u8272\u5173\u7cfb，\u53ef\u4ee5\u5bf9\u4e2d\u95f4\u8868\u4e2d\u7684\u6570\u636e\u8fdb\u884c\u7ef4\u62a4
\n user.getRoles().add(role);<\/p>\n
\/\/ \u914d\u7f6e\u89d2\u8272\u5230\u7528\u6237\u5173\u7cfb，\u53ef\u4ee5\u5bf9\u4e2d\u95f4\u8868\u4e2d\u7684\u6570\u636e\u8fdb\u884c\u7ef4\u62a4
\n role.getUsers().add(user);<\/p>\n
userDao.save(user);
\n }<\/p>\n
\u6548\u679c：<\/p>\n
Hibernate: alter table sys_user_role drop foreign key FK1ef5794xnbirtsnudta6p32on
\nHibernate: alter table sys_user_role drop foreign key FKsbjvgfdwwy5rfbiag1bwh9x2b
\nHibernate: drop table if exists sys_role
\nHibernate: drop table if exists sys_user
\nHibernate: drop table if exists sys_user_role
\nHibernate: create table sys_role (role_id bigint not null auto_increment, role_name varchar(255), primary key (role_id))
\nHibernate: create table sys_user (user_id bigint not null auto_increment, user_age integer, user_name varchar(255), primary key (user_id))
\nHibernate: create table sys_user_role (sys_user_id bigint not null, sys_role_id bigint not null, primary key (sys_user_id, sys_role_id))
\nHibernate: alter table sys_user_role add constraint FK1ef5794xnbirtsnudta6p32on foreign key (sys_role_id) references sys_role (role_id)
\nHibernate: alter table sys_user_role add constraint FKsbjvgfdwwy5rfbiag1bwh9x2b foreign key (sys_user_id) references sys_user (user_id)
\nHibernate: insert into sys_user (user_age, user_name) values (?, ?)
\nHibernate: insert into sys_role (role_name) values (?)
\nHibernate: insert into sys_user_role (sys_user_id, sys_role_id) values (?, ?)<\/p>\n
src\\\\main\\\\resources\\\\applicationContext.xml\u4e2d：<\/p>\n
<bean>
\n<property name="jpaProperties">
\n <props>
\n <prop key="hibernate.hbm2ddl.auto">update<\/prop>
\n <\/props>
\n<\/property>
\n<\/bean><\/p>\n
\u7ea7\u8054\u5220\u9664：<\/p>\n
\/\/ \u6d4b\u8bd5\u7ea7\u8054\u5220\u9664：\u5220\u9664id\u4e3a1\u7684\u5ba2\u6237（\u4e0a\u4e2a\u6817\u5b50\u4fdd\u5b58\u7684\u6570\u636e），\u540c\u65f6\u5220\u9664\u4ed6\u7684\u5173\u8054\u5bf9\u8c61
\n\/**
\n * \u5220\u9664\u64cd\u4f5c
\n * \u5728\u591a\u5bf9\u591a\u7684\u5220\u9664\u65f6，\u53cc\u5411\u7ea7\u8054\u5220\u9664\u6839\u672c\u4e0d\u80fd\u914d\u7f6e
\n * \u7981\u7528
\n *\u5982\u679c\u914d\u4e86\u7684\u8bdd，\u5982\u679c\u6570\u636e\u4e4b\u95f4\u6709\u76f8\u4e92\u5f15\u7528\u5173\u7cfb，\u53ef\u80fd\u4f1a\u6e05\u7a7a\u6240\u6709\u6570\u636e
\n *\/
\n @Test
\n @Transactional
\n @Rollback(false)
\n public void testCasCadeRemove() {
\n \/\/ 1. \u67e5\u8be2\u5ba2\u62371
\n User user = userDao.findOne(1L);
\n \/\/ 2. \u5220\u9664\u5ba2\u62371
\n userDao.delete(user);
\n }<\/p>\n
\u6548\u679c：<\/p>\n
Hibernate: select user0_.user_id as user_id1_1_0_, user0_.user_age as user_age2_1_0_, user0_.user_name as user_nam3_1_0_ from sys_user user0_ where user0_.user_id=?
\nHibernate: select roles0_.sys_user_id as sys_user1_2_0_, roles0_.sys_role_id as sys_role2_2_0_, role1_.role_id as role_id1_0_1_, role1_.role_name as role_nam2_0_1_ from sys_user_role roles0_ inner join sys_role role1_ on roles0_.sys_role_id=role1_.role_id where roles0_.sys_user_id=?
\nHibernate: delete from sys_user_role where sys_user_id=?
\nHibernate: delete from sys_role where role_id=?
\nHibernate: delete from sys_user where user_id=?<\/p>\n
\u5bf9\u8c61\u5bfc\u822a\u67e5\u8be2\u5373\u901a\u8fc7\u4e00\u4e2a\u5bf9\u8c61，\u67e5\u8be2\u6b64\u5bf9\u8c61\u5173\u8054\u7684\u6240\u6709\u5bf9\u8c61\u3002<\/p>\n
\u5bf9\u8c61\u56fe\u5bfc\u822a\u68c0\u7d22\u65b9\u5f0f\u662f\u6839\u636e\u5df2\u7ecf\u52a0\u8f7d\u7684\u5bf9\u8c61，\u5bfc\u822a\u5230\u4ed6\u7684\u5173\u8054\u5bf9\u8c61\u3002\u5b83\u5229\u7528\u7c7b\u4e0e\u7c7b\u4e4b\u95f4\u7684\u5173\u7cfb\u6765\u68c0\u7d22\u5bf9\u8c61\u3002\u4f8b\u5982：\u6211\u4eec\u901a\u8fc7ID\u67e5\u8be2\u65b9\u5f0f\u67e5\u51fa\u4e00\u4e2a\u5ba2\u6237，\u53ef\u4ee5\u8c03\u7528Customer\u7c7b\u4e2d\u7684getLinkMans()\u65b9\u6cd5\u6765\u83b7\u53d6\u8be5\u5ba2\u6237\u7684\u6240\u6709\u8054\u7cfb\u4eba\u3002\u5bf9\u8c61\u5bfc\u822a\u67e5\u8be2\u7684\u4f7f\u7528\u8981\u6c42\u662f：\u4e24\u4e2a\u5bf9\u8c61\u4e4b\u95f4\u5fc5\u987b\u5b58\u5728\u5173\u8054\u5173\u7cfb\u3002<\/p>\n
\u67e5\u8be2\u4e00\u4e2a\u5ba2\u6237，\u83b7\u53d6\u8be5\u5ba2\u6237\u4e0b\u7684\u6240\u6709\u8054\u7cfb\u4eba \u00a0<\/p>\n
@Autowired
\nprivate CustomerDao customerDao;<\/p>\n
@Test
\n\/\/\u7531\u4e8e\u662f\u5728java\u4ee3\u7801\u4e2d\u6d4b\u8bd5，\u4e3a\u4e86\u89e3\u51b3no session\u95ee\u9898，\u5c06\u64cd\u4f5c\u914d\u7f6e\u5230\u540c\u4e00\u4e2a\u4e8b\u52a1\u4e2d
\n@Transactional
\npublic void testFind() {
\nCustomer customer = customerDao.findOne(5l);
\nSet<LinkMan> linkMans = customer.getLinkMans();\/\/\u5bf9\u8c61\u5bfc\u822a\u67e5\u8be2
\nfor(LinkMan linkMan : linkMans) {
\n System.out.println(linkMan);
\n}
\n}<\/p>\n
\u67e5\u8be2\u4e00\u4e2a\u8054\u7cfb\u4eba，\u83b7\u53d6\u8be5\u8054\u7cfb\u4eba\u7684\u6240\u6709\u5ba2\u6237<\/p>\n
@Autowired
\nprivate LinkManDao linkManDao;<\/p>\n
@Test
\npublic void testFind() {
\nLinkMan linkMan = linkManDao.findOne(4l);
\nCustomer customer = linkMan.getCustomer(); \/\/\u5bf9\u8c61\u5bfc\u822a\u67e5\u8be2
\nSystem.out.println(customer);
\n}<\/p>\n
\u5bf9\u8c61\u5bfc\u822a\u67e5\u8be2\u7684\u95ee\u9898\u5206\u6790<\/p>\n
\u95ee\u98981：\u6211\u4eec\u67e5\u8be2\u5ba2\u6237\u65f6，\u8981\u4e0d\u8981\u628a\u8054\u7cfb\u4eba\u67e5\u8be2\u51fa\u6765？<\/p>\n
\u5206\u6790：\u5982\u679c\u6211\u4eec\u4e0d\u67e5\u7684\u8bdd，\u5728\u7528\u7684\u65f6\u5019\u8fd8\u8981\u81ea\u5df1\u5199\u4ee3\u7801，\u8c03\u7528\u65b9\u6cd5\u53bb\u67e5\u8be2\u3002\u5982\u679c\u6211\u4eec\u67e5\u51fa\u6765\u7684，\u4e0d\u4f7f\u7528\u65f6\u53c8\u4f1a\u767d\u767d\u7684\u6d6a\u8d39\u4e86\u670d\u52a1\u5668\u5185\u5b58\u3002<\/p>\n
\u89e3\u51b3：\u91c7\u7528\u5ef6\u8fdf\u52a0\u8f7d\u7684\u601d\u60f3\u3002\u901a\u8fc7\u914d\u7f6e\u7684\u65b9\u5f0f\u6765\u8bbe\u5b9a\u5f53\u6211\u4eec\u5728\u9700\u8981\u4f7f\u7528\u65f6，\u53d1\u8d77\u771f\u6b63\u7684\u67e5\u8be2\u3002<\/p>\n
\u914d\u7f6e\u65b9\u5f0f：<\/p>\n
\/**
\n * \u5728\u5ba2\u6237\u5bf9\u8c61\u7684@OneToMany\u6ce8\u89e3\u4e2d\u6dfb\u52a0fetch\u5c5e\u6027
\n * FetchType.EAGER：\u7acb\u5373\u52a0\u8f7d
\n * FetchType.LAZY：\u5ef6\u8fdf\u52a0\u8f7d
\n *\/
\n@OneToMany(mappedBy="customer",fetch=FetchType.EAGER)
\nprivate Set<LinkMan> linkMans = new HashSet<>(0);<\/p>\n
\u95ee\u98982：\u6211\u4eec\u67e5\u8be2\u8054\u7cfb\u4eba\u65f6，\u8981\u4e0d\u8981\u628a\u5ba2\u6237\u67e5\u8be2\u51fa\u6765？<\/p>\n
\u5206\u6790：\u4f8b\u5982：\u67e5\u8be2\u8054\u7cfb\u4eba\u8be6\u60c5\u65f6，\u80af\u5b9a\u4f1a\u770b\u770b\u8be5\u8054\u7cfb\u4eba\u7684\u6240\u5c5e\u5ba2\u6237\u3002\u5982\u679c\u6211\u4eec\u4e0d\u67e5\u7684\u8bdd，\u5728\u7528\u7684\u65f6\u5019\u8fd8\u8981\u81ea\u5df1\u5199\u4ee3\u7801，\u8c03\u7528\u65b9\u6cd5\u53bb\u67e5\u8be2\u3002\u5982\u679c\u6211\u4eec\u67e5\u51fa\u6765\u7684\u8bdd，\u4e00\u4e2a\u5bf9\u8c61\u4e0d\u4f1a\u6d88\u8017\u592a\u591a\u7684\u5185\u5b58\u3002\u800c\u4e14\u591a\u6570\u60c5\u51b5\u4e0b\u6211\u4eec\u90fd\u662f\u8981\u4f7f\u7528\u7684\u3002<\/p>\n
\u89e3\u51b3： \u91c7\u7528\u7acb\u5373\u52a0\u8f7d\u7684\u601d\u60f3\u3002\u901a\u8fc7\u914d\u7f6e\u7684\u65b9\u5f0f\u6765\u8bbe\u5b9a，\u53ea\u8981\u67e5\u8be2\u4ece\u8868\u5b9e\u4f53，\u5c31\u628a\u4e3b\u8868\u5b9e\u4f53\u5bf9\u8c61\u540c\u65f6\u67e5\u51fa\u6765<\/p>\n
\u914d\u7f6e\u65b9\u5f0f<\/p>\n
\/**
\n * \u5728\u8054\u7cfb\u4eba\u5bf9\u8c61\u7684@ManyToOne\u6ce8\u89e3\u4e2d\u6dfb\u52a0fetch\u5c5e\u6027
\n * FetchType.EAGER：\u7acb\u5373\u52a0\u8f7d
\n * FetchType.LAZY：\u5ef6\u8fdf\u52a0\u8f7d
\n *\/
\n@ManyToOne(targetEntity=Customer.class,fetch=FetchType.EAGER)
\n@JoinColumn(name="cst_lkm_id",referencedColumnName="cust_id")
\nprivate Customer customer;<\/p>\n
src\\\\main\\\\java\\\\top\\\\onefine\\\\domain\\\\Customer.java：<\/p>\n
package top.onefine.domain;<\/p>\n
import lombok.*;<\/p>\n
import javax.persistence.*;
\nimport java.util.HashSet;
\nimport java.util.Set;<\/p>\n
\/**
\n * 1. \u5b9e\u4f53\u7c7b\u548c\u8868\u7684\u6620\u5c04\u5173\u7cfb
\n * -@Eitity
\n * -@Table
\n * 2. \u7c7b\u4e2d\u5c5e\u6027\u548c\u6570\u636e\u5e93\u8868\u4e2d\u5b57\u6bb5\u7684\u6620\u5c04\u5173\u7cfb
\n * -@Id \u4e3b\u952e
\n * -@GeneratedValue \u4e3b\u952e\u751f\u6210\u7b56\u7565
\n * -@Column
\n *\/
\n@Entity
\n@Table(name = "cst_customer")
\n@Getter
\n@Setter
\n@NoArgsConstructor
\npublic class Customer {
\n @Id
\n @GeneratedValue(strategy = GenerationType.IDENTITY)
\n @Column(name = "cust_id")
\n private Long custId;
\n @Column(name = "cust_address")
\n private String custAddress;
\n @Column(name = "cust_industry")
\n private String custIndustry;
\n @Column(name = "cust_level")
\n private String custLevel;
\n @Column(name = "cust_name")
\n private String custName;
\n @Column(name = "cust_phone")
\n private String custPhone;
\n @Column(name = "cust_source")
\n private String custSource;<\/p>\n
\/\/ \u914d\u7f6e\u5ba2\u6237\u548c\u8054\u7cfb\u4eba\u4e4b\u95f4\u7684\u5173\u7cfb（\u4e00\u5bf9\u591a\u5173\u7cfb）
\n \/*
\n \u4f7f\u7528\u6ce8\u89e3\u7684\u5f62\u5f0f\u914d\u7f6e\u591a\u8868\u5173\u7cfb：
\n 1. \u58f0\u660e\u5173\u7cfb
\n – @OneToMany：\u914d\u7f6e\u4e00\u5bf9\u591a\u5173\u7cfb
\n targetEntity：\u5bf9\u65b9\u5bf9\u8c61\u7684\u5b57\u8282\u7801\u5bf9\u8c61
\n 2. \u914d\u7f6e\u5916\u952e（\u6216\u4e2d\u95f4\u8868）
\n – @JoinColumn：\u914d\u7f6e\u5916\u952e
\n name：\u4ece\u8868 \u5916\u952e\u5b57\u6bb5\u540d\u79f0
\n referencedColumnName：\u53c2\u7167\u7684 \u4e3b\u8868 \u7684\u4e3b\u952e\u5b57\u6bb5\u540d\u79f0<\/p>\n
\u6ce8：\u5728\u5ba2\u6237\u5b9e\u4f53\u7c7b\u4e0a（\u4e00\u7684\u4e00\u65b9）\u6dfb\u52a0\u4e86\u5916\u952e\u7684\u914d\u7f6e，\u6240\u4ee5\u5bf9\u4e8e\u5ba2\u6237\u800c\u8a00，\u4e5f\u5177\u5907\u4e86\u7ef4\u62a4\u5916\u952e\u7684\u4f5c\u7528<\/p>\n
*\/
\n\/\/ @OneToMany(targetEntity = LinkMan.class)
\n\/\/ @JoinColumn(name = "lkm_cust_id", referencedColumnName = "cust_id")
\n \/*
\n \u653e\u5f03\u5916\u952e\u7ef4\u62a4\u6743
\n mappedBy: \u5bf9\u65b9\u914d\u7f6e\u5173\u7cfb\u7684\u5c5e\u6027\u540d\u79f0
\n \u8868\u793a\u53c2\u7167\u5bf9\u65b9\u7684\u5c5e\u6027\u6765\u505a<\/p>\n
cascade:\u914d\u7f6e\u7ea7\u8054\u64cd\u4f5c，\u53ef\u4ee5\u914d\u7f6e\u5230\u8bbe\u7f6e\u591a\u8868\u7684\u6620\u5c04\u5173\u7cfb\u7684\u6ce8\u89e3\u4e0a
\n * CascadeType.MERGE\u7ea7\u8054\u66f4\u65b0
\n * CascadeType.PERSIST\u7ea7\u8054\u4fdd\u5b58：
\n * CascadeType.REFRESH \u7ea7\u8054\u5237\u65b0：
\n * CascadeType.REMOVE\u7ea7\u8054\u5220\u9664：
\n * CascadeType.ALL\u5305\u542b\u4ee5\u4e0a\u6240\u6709，\u63a8\u8350\u914d\u7f6e<\/p>\n
fetch:\u914d\u7f6e\u5173\u8054\u5bf9\u8c61\u7684\u52a0\u8f7d\u65b9\u5f0f
\n FetchType.EAGER \u7acb\u5373\u52a0\u8f7d — \u4e0d\u63a8\u8350
\n FetchType.LAZY \u5ef6\u8fdf\u52a0\u8f7d — \u9ed8\u8ba4
\n *\/
\n @OneToMany(mappedBy = "customer", cascade = CascadeType.ALL\/*, fetch = FetchType.EAGER*\/)
\n private Set<LinkMan> linkMans = new HashSet<>();<\/p>\n
\/\/ \u6ce8\u610f\u4e0d\u542b\u96c6\u5408
\n @Override
\n public String toString() {
\n return "Customer{" +
\n "custId=" + custId +
\n ", custAddress='" + custAddress + '\\\\'' +
\n ", custIndustry='" + custIndustry + '\\\\'' +
\n ", custLevel='" + custLevel + '\\\\'' +
\n ", custName='" + custName + '\\\\'' +
\n ", custPhone='" + custPhone + '\\\\'' +
\n ", custSource='" + custSource + '\\\\'' +
\n '}';
\n }
\n}<\/p>\n
src\\\\main\\\\java\\\\top\\\\onefine\\\\domain\\\\LinkMan.java：<\/p>\n
package top.onefine.domain;<\/p>\n
import lombok.*;<\/p>\n
import javax.persistence.*;<\/p>\n
@Entity
\n@Table(name = "cst_linkman")
\n\/\/@Data
\n@Getter
\n@Setter
\n\/\/@ToString
\n@NoArgsConstructor
\npublic class LinkMan {
\n @Id
\n @GeneratedValue(strategy = GenerationType.IDENTITY)
\n @Column(name = "lkm_id")
\n private Long lkmId; \/\/ \u8054\u7cfb\u4eba\u7f16\u53f7
\n @Column(name = "lkm_name")
\n private String lkmName; \/\/ \u8054\u7cfb\u4eba\u59d3\u540d
\n @Column(name = "lkm_gender")
\n private String lkmGender; \/\/ \u8054\u7cfb\u4eba\u6027\u522b \/\/ \u5bf9\u5e94\u6570\u636e\u5e93\u8868\u4e2d\u5b57\u6bb5char(1)
\n @Column(name = "lkm_phone")
\n private String lkmPhone; \/\/ \u8054\u7cfb\u4eba\u529e\u516c\u7535\u8bdd
\n @Column(name = "lkm_mobile")
\n private String lkmMobile; \/\/ \u8054\u7cfb\u4eba\u624b\u673a
\n @Column(name = "lkm_email")
\n private String lkmEmail; \/\/ \u8054\u7cfb\u4eba\u90ae\u7bb1
\n @Column(name = "lkm_position")
\n private String lkmPosition; \/\/ \u8054\u7cfb\u4eba\u804c\u4f4d
\n @Column(name = "lkm_memo")
\n private String lkmMemo; \/\/ \u8054\u7cfb\u4eba\u5907\u6ce8<\/p>\n
\/\/ \u914d\u7f6e\u8054\u7cfb\u4eba\u5230\u5ba2\u6237\u7684\u591a\u5bf9\u4e00\u5173\u7cfb
\n \/*
\n \u4f7f\u7528\u6ce8\u89e3\u7684\u5f62\u5f0f\u914d\u7f6e\u591a\u5bf9\u4e00\u5173\u7cfb
\n 1. \u914d\u7f6e\u8868\u5173\u7cfb
\n – @ManyToOne：\u914d\u7f6e\u591a\u5bf9\u4e00\u5173\u7cfb
\n targetEntity：\u5bf9\u65b9\u5bf9\u8c61\u7684\u5b57\u8282\u7801\u5bf9\u8c61
\n 2. \u914d\u7f6e\u5916\u952e（\u6216\u4e2d\u95f4\u8868）<\/p>\n
\u6ce8：\u914d\u7f6e\u5916\u952e\u7684\u8fc7\u7a0b，\u914d\u7f6e\u5230\u4e86\u591a\u7684\u4e00\u65b9，\u5c31\u4f1a\u5728\u591a\u7684\u4e00\u65b9\u7ef4\u62a4\u5916\u952e<\/p>\n
fetch:\u914d\u7f6e\u5173\u8054\u5bf9\u8c61\u7684\u52a0\u8f7d\u65b9\u5f0f
\n FetchType.EAGER \u7acb\u5373\u52a0\u8f7d — \u9ed8\u8ba4
\n FetchType.LAZY \u5ef6\u8fdf\u52a0\u8f7d
\n *\/
\n @ManyToOne(targetEntity = Customer.class\/*, fetch = FetchType.LAZY*\/)
\n @JoinColumn(name = "lkm_cust_id", referencedColumnName = "cust_id")
\n private Customer customer;<\/p>\n
\/\/ \u6ce8\u610f\u4e0d\u542bcustomer
\n @Override
\n public String toString() {
\n return "LinkMan{" +
\n "lkmId=" + lkmId +
\n ", lkmName='" + lkmName + '\\\\'' +
\n ", lkmGender='" + lkmGender + '\\\\'' +
\n ", lkmPhone='" + lkmPhone + '\\\\'' +
\n ", lkmMobile='" + lkmMobile + '\\\\'' +
\n ", lkmEmail='" + lkmEmail + '\\\\'' +
\n ", lkmPosition='" + lkmPosition + '\\\\'' +
\n ", lkmMemo='" + lkmMemo + '\\\\'' +
\n '}';
\n }
\n}<\/p>\n
src\\\\test\\\\java\\\\top\\\\onefine\\\\dao\\\\ObjectQueryTest.java：<\/p>\n
package top.onefine.dao;<\/p>\n
import org.junit.Test;
\nimport org.junit.runner.RunWith;
\nimport org.springframework.beans.factory.annotation.Autowired;
\nimport org.springframework.test.annotation.Rollback;
\nimport org.springframework.test.context.ContextConfiguration;
\nimport org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
\nimport org.springframework.transaction.annotation.Transactional;
\nimport top.onefine.domain.Customer;
\nimport top.onefine.domain.LinkMan;<\/p>\n
import java.util.Set;<\/p>\n
@SuppressWarnings("All")
\n@RunWith(SpringJUnit4ClassRunner.class)
\n@ContextConfiguration(locations = "classpath:applicationContext.xml")
\npublic class ObjectQueryTest {<\/p>\n
@Autowired
\n private CustomerDao customerDao;<\/p>\n
@Autowired
\n private LinkManDao linkManDao;<\/p>\n
@Test
\n @Transactional \/\/ \u89e3\u51b3：could not initialize proxy – no Session \u95ee\u9898
\n public void testQuery1() {
\n \/\/ 1. \u67e5\u8be2\u5ba2\u6237
\n Customer user = customerDao.getOne(3L); \/\/ \u5ef6\u8fdf\u52a0\u8f7d
\n \/\/ 2. \u5bf9\u8c61\u5bfc\u822a\u67e5\u8be2，\u67e5\u8be2\u6b64\u5ba2\u6237\u4e0b\u7684\u6240\u6709\u8054\u7cfb\u4eba
\n Set<LinkMan> linkMans = user.getLinkMans();
\n for (LinkMan linkMan : linkMans) {
\n System.out.println(linkMan);
\n }
\n }<\/p>\n
\/**
\n * \u4e00\u7684\u4e00\u65b9
\n * \u6ce8\u610f：\u5bf9\u8c61\u5bfc\u822a\u67e5\u8be2 \u9ed8\u8ba4\u4f7f\u7528\u7684\u662f\u5ef6\u8fdf\u52a0\u8f7d \u7684\u5f62\u5f0f\u67e5\u8be2\u7684
\n * \u8c03\u7528getLinkMans\u65b9\u6cd5\u5e76\u4e0d\u4f1a\u7acb\u5373\u53d1\u9001\u67e5\u8be2，\u800c\u662f\u5728\u4f7f\u7528\u5173\u8054\u5bf9\u8c61\u7684\u65f6\u5019\u624d\u4f1a\u67e5\u8be2，\u6240\u4ee5\u662f\u5ef6\u8fdf\u52a0\u8f7d！
\n *
\n * \u82e5\u9700\u8981\u5c06\u5ef6\u8fdf\u52a0\u8f7d\u6539\u4e3a\u7acb\u5373\u52a0\u8f7d（\u4e0d\u63a8\u8350\u4f7f\u7528），\u9700\u8981\u4fee\u6539\u914d\u7f6e Customer\u4e2d\u8bbe\u7f6e
\n * fetch,\u9700\u8981\u914d\u7f6e\u5230\u591a\u8868\u6620\u5c04\u5173\u7cfb\u7684\u6ce8\u89e3\u4e0a
\n *\/
\n @Test
\n @Transactional \/\/ \u89e3\u51b3：could not initialize proxy – no Session \u95ee\u9898
\n public void testQuery2() {
\n \/\/ 1. \u67e5\u8be2\u5ba2\u6237
\n Customer user = customerDao.findOne(3L); \/\/ \u7acb\u5373\u52a0\u8f7d
\n \/\/ 2. \u5bf9\u8c61\u5bfc\u822a\u67e5\u8be2，\u67e5\u8be2\u6b64\u5ba2\u6237\u4e0b\u7684\u6240\u6709\u8054\u7cfb\u4eba
\n Set<LinkMan> linkMans = user.getLinkMans();
\n\/\/ System.out.println(linkMans.size());
\n System.out.println(linkMans);
\n }<\/p>\n
\/\/ \u4ece\u8054\u7cfb\u4eba\u5bf9\u8c61\u5bfc\u822a\u67e5\u8be2\u6240\u5c5e\u5ba2\u6237
\n \/** \u591a\u7684\u4e00\u65b9
\n * \u6ce8\u610f：\u5bf9\u8c61\u5bfc\u822a\u67e5\u8be2 \u9ed8\u8ba4\u4f7f\u7528\u7684\u662f\u7acb\u5373\u52a0\u8f7d \u7684\u5f62\u5f0f\u67e5\u8be2\u7684
\n * \u8c03\u7528getCustomer\u65b9\u6cd5\u4f1a\u7acb\u5373\u53d1\u9001\u67e5\u8be2
\n *
\n * \u82e5\u9700\u8981\u5c06\u5ef6\u8fdf\u52a0\u8f7d\u6539\u4e3a\u7acb\u5373\u52a0\u8f7d（\u4e0d\u63a8\u8350\u4f7f\u7528），\u9700\u8981\u4fee\u6539\u914d\u7f6e LinkMan\u4e2d\u8bbe\u7f6e
\n * fetch,\u9700\u8981\u914d\u7f6e\u5230\u591a\u8868\u6620\u5c04\u5173\u7cfb\u7684\u6ce8\u89e3\u4e0a
\n *\/
\n @Test
\n @Transactional \/\/ \u89e3\u51b3：could not initialize proxy – no Session \u95ee\u9898
\n public void testQuery3() {
\n \/\/ 1. \u67e5\u8be2\u8054\u7cfb\u4eba
\n LinkMan linkMan = linkManDao.findOne(4L);
\n assert linkMan != null;
\n \/\/ 2. \u5bf9\u8c61\u5bfc\u822a\u67e5\u8be2，\u67e5\u8be2\u6b64\u8054\u7cfb\u4eba\u5bf9\u5e94\u7684\u5ba2\u6237
\n Customer customer = linkMan.getCustomer();<\/p>\n
System.out.println(customer);
\n }
\n}<\/p>\n
\u5176\u4ed6\u4e0d\u53d8，\u53c2\u7167\u7b2c\u4e09\u7ae0： src\\\\main\\\\java\\\\top\\\\onefine\\\\dao\\\\CustomerDao.java src\\\\main\\\\java\\\\top\\\\onefine\\\\dao\\\\LinkManDao.java src\\\\main\\\\resources\\\\applicationContext.xml pom.xml<\/p>\n
\u603b\u7ed3：<\/p>\n
\u5bf9\u8c61\u5bfc\u822a\u67e5\u8be2：\u67e5\u8be2\u4e00\u4e2a\u5bf9\u8c61\u7684\u540c\u65f6，\u901a\u8fc7\u6b64\u5bf9\u8c61\u67e5\u8be2\u4ed6\u7684\u5173\u8054\u5bf9\u8c61<\/p>\n
\u4ece\u4e00\u65b9\u67e5\u8be2\u591a\u65b9；\u9ed8\u8ba4：\u4f7f\u7528\u5ef6\u8fdf\u52a0\u8f7d，\u52a1\u5fc5<\/p>\n<\/li>\n
\u4ece\u591a\u65b9\u67e5\u8be2\u4e00\u65b9；\u9ed8\u8ba4：\u4f7f\u7528\u7acb\u5373\u52a0\u8f7d<\/p>\n<\/li>\n<\/ul>\n
\/**
\n * Specification\u7684\u591a\u8868\u67e5\u8be2
\n *\/
\n@Test
\npublic void testFind() {
\nSpecification<LinkMan> spec = new Specification<LinkMan>() {
\npublic Predicate toPredicate(Root<LinkMan> root, CriteriaQuery<?> query, CriteriaBuilder cb) {
\n\/\/Join\u4ee3\u8868\u94fe\u63a5\u67e5\u8be2，\u901a\u8fc7root\u5bf9\u8c61\u83b7\u53d6
\n\/\/\u521b\u5efa\u7684\u8fc7\u7a0b\u4e2d，\u7b2c\u4e00\u4e2a\u53c2\u6570\u4e3a\u5173\u8054\u5bf9\u8c61\u7684\u5c5e\u6027\u540d\u79f0，\u7b2c\u4e8c\u4e2a\u53c2\u6570\u4e3a\u8fde\u63a5\u67e5\u8be2\u7684\u65b9\u5f0f（left，inner，right）
\n\/\/JoinType.LEFT : \u5de6\u5916\u8fde\u63a5,JoinType.INNER：\u5185\u8fde\u63a5,JoinType.RIGHT：\u53f3\u5916\u8fde\u63a5
\nJoin<LinkMan, Customer> join = root.join("customer",JoinType.INNER);
\nreturn cb.like(join.get("custName").as(String.class),"\u4f20\u667a\u64ad\u5ba21");
\n}
\n};
\nList<LinkMan> list = linkManDao.findAll(spec);
\nfor (LinkMan linkMan : list) {
\nSystem.out.println(linkMan);
\n}
\n}<\/p><\/p>\n","protected":false},"excerpt":{"rendered":"
\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb3k\u6b21\uff0c\u70b9\u8d5e19\u6b21\uff0c\u6536\u85cf24\u6b21\u3002\u5728\u5b9e\u9645\u5f00\u53d1\u4e2d\uff0c\u6211\u4eec\u6570\u636e\u5e93\u7684\u8868\u96be\u514d\u4f1a\u6709\u76f8\u4e92\u7684\u5173\u8054\u5173\u7cfb\uff0c\u5728\u64cd\u4f5c\u8868\u7684\u65f6\u5019\u5c31\u6709\u53ef\u80fd\u4f1a\u6d89\u53ca\u5230\u591a\u5f20\u8868\u7684\u64cd\u4f5c\u3002\u6709\u65f6\u6211\u4eec\u5728\u67e5\u8be2\u67d0\u4e2a\u5b9e\u4f53\u7684\u65f6\u5019\uff0c\u7ed9\u5b9a\u7684\u6761\u4ef6\u662f\u4e0d\u56fa\u5b9a\u7684\uff0c\u8fd9\u65f6\u5c31\u9700\u8981\u52a8\u6001\u6784\u5efa\u76f8\u5e94\u7684\u67e5\u8be2\u8bed\u53e5\uff0c\u5728Spring Data JPA\u4e2d\u53ef\u4ee5\u901a\u8fc7JpaSpecificationExecutor\u63a5\u53e3\u67e5\u8be2\u3002\u591a\u5bf9\u591a\u5173\u7cfb\u4e2d\uff1a\u7528\u4e2d\u95f4\u8868\uff08\u7b2c\u4e09\u7ae0\u8868\uff09\u6765\u63cf\u8ff0\u8fd9\u79cd\u5173\u7cfb\uff0c\u4e2d\u95f4\u8868\u4e2d\u81f3\u5c11\u5e94\u8be5\u7531\u4e24\u4e2a\u5b57\u6bb5\u7ec4\u6210\uff0c\u8fd9\u4e24\u4e2a\u5b57\u6bb5\u4f5c\u4e3a\u5916\u952e\u6307\u5411\u4e24\u5f20\u8868\u7684\u4e3b\u952e\uff0c\u4e14\u8fd9\u4e24\u4e2a\u5b57\u6bb5\u53c8\u7ec4\u6210\u4e86\u8054\u5408\u4e3b\u952e\u3002\u5728\u4e00\u5bf9\u591a\u5173\u7cfb\u4e2d\uff0c\u6211\u4eec\u4e60\u60ef\u628a\u4e00\u7684\u4e00\u65b9\u79f0\u4e4b\u4e3a\u4e3b\u8868\uff0c\u628a\u591a\u7684\u4e00\u65b9\u79f0\u4e4b\u4e3a\u4ece\u8868\u3002_jpa specification\u591a\u8868\u67e5\u8be2<\/p>\n","protected":false},"author":2,"featured_media":10559,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[99,100,43],"topic":[],"class_list":["post-10566","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-server","tag-java","tag-100","tag-43"],"yoast_head":"\n