Sql代码

1. – MySQL dump 10.13  Distrib 5.1.55, for Win32 (ia32)
2. –
3. – Host: localhost    Database: hibernate_demo
4. – ——————————————————
5. – Server version   5.1.55-community
7. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10. /*!40101 SET NAMES utf8 */;
11. /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12. /*!40103 SET TIME_ZONE=’+00:00′ */;
13. /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE=’NO_AUTO_VALUE_ON_ZERO’ */;
16. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
18. –
19. – Table structure for table `address`
20. –
22. DROP TABLE IF EXISTS `address`;
23. /*!40101 SET @saved_cs_client     = @@character_set_client */;
24. /*!40101 SET character_set_client = utf8 */;
25. CREATE TABLE `address` (
26.   `addressId` int(11) NOT NULL AUTO_INCREMENT,
27.   `item` varchar(30) NOT NULL,
28.   PRIMARY KEY (`addressId`)
29. ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
30. /*!40101 SET character_set_client = @saved_cs_client */;
32. –
33. – Dumping data for table `address`
34. –
36. LOCK TABLES `address` WRITE;
37. /*!40000 ALTER TABLE `address` DISABLE KEYS */;
38. INSERT INTO `address` VALUES (1,’item1′),(2,’item2′);
39. /*!40000 ALTER TABLE `address` ENABLE KEYS */;
40. UNLOCK TABLES;
42. –
43. – Table structure for table `jointable`
44. –
46. DROP TABLE IF EXISTS `jointable`;
47. /*!40101 SET @saved_cs_client     = @@character_set_client */;
48. /*!40101 SET character_set_client = utf8 */;
49. CREATE TABLE `jointable` (
50.   `pid` int(11) DEFAULT NULL,
51.   `aid` int(11) DEFAULT NULL,
52.   KEY `join_person_fk` (`pid`),
53.   KEY `join_address_fk` (`aid`)
54. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
55. /*!40101 SET character_set_client = @saved_cs_client */;
57. –
58. – Dumping data for table `jointable`
59. –
61. LOCK TABLES `jointable` WRITE;
62. /*!40000 ALTER TABLE `jointable` DISABLE KEYS */;
63. INSERT INTO `jointable` VALUES (1,1),(1,2);
64. /*!40000 ALTER TABLE `jointable` ENABLE KEYS */;
65. UNLOCK TABLES;
67. –
68. – Table structure for table `person`
69. –
71. DROP TABLE IF EXISTS `person`;
72. /*!40101 SET @saved_cs_client     = @@character_set_client */;
73. /*!40101 SET character_set_client = utf8 */;
74. CREATE TABLE `person` (
75.   `id` int(11) NOT NULL AUTO_INCREMENT,
76.   `name` varchar(30) NOT NULL,
77.   `age` int(11) NOT NULL,
78.   PRIMARY KEY (`id`)
79. ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
80. /*!40101 SET character_set_client = @saved_cs_client */;
82. –
83. – Dumping data for table `person`
84. –
86. LOCK TABLES `person` WRITE;
87. /*!40000 ALTER TABLE `person` DISABLE KEYS */;
88. INSERT INTO `person` VALUES (1,’zhaoyunpeng’,10);
89. /*!40000 ALTER TABLE `person` ENABLE KEYS */;
90. UNLOCK TABLES;
91. /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
93. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
94. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
95. /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
96. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
97. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
98. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
99. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
101. – Dump completed on 2012-08-17  0:17:14

Java代码

1. package com.zyp.examples;
3. import javax.persistence.Column;
4. import javax.persistence.Entity;
5. import javax.persistence.GeneratedValue;
6. import javax.persistence.GenerationType;
7. import javax.persistence.Id;
8. import javax.persistence.Table;
10. import org.hibernate.annotations.GenericGenerator;
12. /**
13. * Address entity. @author MyEclipse Persistence Tools
14. */
15. @Entity
16. @Table(name=”address”)
17. public class Address implements java.io.Serializable {
19.     private static final long serialVersionUID = 5136081851186696459L;
21.     // Fields
22.     @Id
23.     @GenericGenerator(name=”incrementGenerator”,strategy=”increment”)
24.     @GeneratedValue(generator=”incrementGenerator”, strategy=GenerationType.IDENTITY)
25.     @Column(name=”addressId”)
26.     private Integer addressId;
28.     @Column(name=”item”)
29.     private String item;
31.     // Constructors
33.     /** default constructor */
34.     public Address() {
35.     }
37.     /** full constructor */
38.     public Address(String item) {
39.         this.item = item;
40.     }
42.     // Property accessors
44.     public Integer getAddressId() {
45.         return this.addressId;
46.     }
48.     public void setAddressId(Integer addressId) {
49.         this.addressId = addressId;
50.     }
52.     public String getItem() {
53.         return this.item;
54.     }
56.     public void setItem(String item) {
57.         this.item = item;
58.     }
60. }

Java代码

1. package com.zyp.examples;
3. import java.util.HashSet;
4. import java.util.Set;
6. import javax.persistence.CascadeType;
7. import javax.persistence.Column;
8. import javax.persistence.Entity;
9. import javax.persistence.FetchType;
10. import javax.persistence.GeneratedValue;
11. import javax.persistence.GenerationType;
12. import javax.persistence.Id;
13. import javax.persistence.JoinColumn;
14. import javax.persistence.JoinTable;
15. import javax.persistence.OneToMany;
16. import javax.persistence.Table;
18. import org.hibernate.annotations.Fetch;
19. import org.hibernate.annotations.FetchMode;
20. import org.hibernate.annotations.GenericGenerator;
22. /**
23. * Person entity. @author MyEclipse Persistence Tools
24. */
26. @Entity
27. @Table(name=”person”)
28. public class Person implements java.io.Serializable {
30.     // Fields
31.     private static final long serialVersionUID = -5910642968209679728L;
33.     @Id
34.     @GenericGenerator(name=”incrementGenerator”,strategy=”increment”)
35.     @GeneratedValue(generator=”incrementGenerator”, strategy=GenerationType.IDENTITY)
36.     @Column(name=”id”)
37.     private Integer id;
39.     @Column(name=”name”, nullable=false)
40.     private String name;
42.     @Column(name=”age”, nullable=false)
43.     private Integer age;
45.     @OneToMany(targetEntity=Address.class, fetch=FetchType.EAGER, cascade=CascadeType.ALL)
46.     @Fetch(FetchMode.SELECT)
47.     @JoinTable(joinColumns=@JoinColumn(name=”pid”, nullable=true),
48.             name=”jointable”, inverseJoinColumns=@JoinColumn(name=”aid”))
49.     private Set<Address> address = new HashSet<Address>();
51.     // Constructors
53.     /** default constructor */
54.     public Person() {
55.     }
58.     // Property accessors
60.     public Integer getId() {
61.         return this.id;
62.     }
64.     public void setId(Integer id) {
65.         this.id = id;
66.     }
68.     public String getName() {
69.         return this.name;
70.     }
72.     public void setName(String name) {
73.         this.name = name;
74.     }
76.     public Integer getAge() {
77.         return this.age;
78.     }
80.     public void setAge(Integer age) {
81.         this.age = age;
82.     }
85.     public Set<Address> getAddress() {
86.         return address;
87.     }
90.     public void setAddress(Set<Address> address) {
91.         this.address = address;
92.     }
95. }

Java代码

1. package com.zyp.examples;
3. import java.util.HashSet;
4. import java.util.Set;
6. import org.hibernate.Session;
8. public class HibernateTest {
10.     public static void main(String[] args) {
12.         //级联添加
13. //      addByPerson();
15.         //级联删除
16.         deleteByPerson();
17.     }
19.     public static void deleteByPerson()
20.     {
21.         Session session = HibernateUtil.getSessionFactory().openSession();
22.         session.beginTransaction();
23.         session.delete(session.load(Person.class, new Integer(1)));
24.         session.getTransaction().commit();
25.     }
27.     public static void addByPerson()
28.     {
29.         Address a1 = new Address();
30.         a1.setItem(“item1″);
31.         Address a2 = new Address();
32.         a2.setItem(“item2″);
34.         Set<Address> address = new HashSet<Address>();
35.         address.add(a1);
36.         address.add(a2);
38.         Person p = new Person();
39.         p.setAge(10);
40.         p.setName(“zhaoyunpeng”);
41.         p.setAddress(address);
43.         Session session = HibernateUtil.getSessionFactory().openSession();
44.         session.beginTransaction();
45.         session.save(p);
46.         session.getTransaction().commit();
48.     }
50. }

• hibernate_annotation_1ton_jointable_single.rar (5.7 MB)
• 下载次数: 7

本文链接地址: Hibernate Annotation 基于连接表的单向一对多关联http://www.hongyanliren.com/2014m11/20233.html

相关文章

• sql语句里的limit使用方法
• gethibernatetemplate的find方法大全
• hibernate gethibernatetemplate的find方法使用方法
• hibernate4整合spring3事务问题
• spring+strtus+hibernate+struts2中的设计模式
• HQL语句大全hibernate
• unexpected token异常
• Hibernate HQL like 语句的用法 模糊查询