天天看点

Hibernate @ManyToMany -- 2

Class Person
           
@ManyToMany 
public Set<Bank> getBankSet() {
  return bankSet;
}
           
Class Bank
           
@ManyToMany(mappedBy="bankSet")
public Set<Person> getPersonSet() {
  return personSet;
}
           
CREATE TABLE `bank` (
  `id` varchar(32) NOT NULL,
  `createDate` datetime DEFAULT NULL,
  `modifyDate` datetime DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `person` (
  `id` varchar(32) NOT NULL,
  `createDate` datetime DEFAULT NULL,
  `modifyDate` datetime DEFAULT NULL,
  `age` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `person_bank` (
  `personSet_id` varchar(32) NOT NULL,
  `bankSet_id` varchar(32) NOT NULL,
  PRIMARY KEY (`personSet_id`,`bankSet_id`),
  KEY `FKE699F0E6747D6B54` (`bankSet_id`),
  KEY `FKE699F0E6D0B93DC6` (`personSet_id`),
  CONSTRAINT `FKE699F0E6D0B93DC6` FOREIGN KEY (`personSet_id`) REFERENCES `person` (`id`),
  CONSTRAINT `FKE699F0E6747D6B54` FOREIGN KEY (`bankSet_id`) REFERENCES `bank` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
           

继续阅读