org.springframework.core.convert.converter.Converter<\/code>, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u043f\u043e\u043c\u043e\u0433\u0430\u0435\u0442 \u043d\u0430\u043c \u0432 \u043e\u0442\u043e\u0431\u0440\u0430\u0436\u0435\u043d\u0438\u0438 ID’ \u043f\u0440\u0435\u0434\u043c\u0435\u0442\u043e\u0432 \u0432 \u043d\u0430\u0441\u0442\u043e\u044f\u0449\u0438\u0445 \u0441\u0443\u0431\u044a\u0435\u043a\u0442\u0430\u0445 \u0432 \u0431\u0430\u0437\u0435 \u0434\u0430\u043d\u043d\u044b\u0445.<\/p>\n ![](\"https:\/\/habrastorage.org\/files\/266\/a3f\/e38\/266a3fe3814a45a9bd4cc69fb035698c.png\"\/)
<\/a>
\u0411\u044b\u043b\u0438 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u044b \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0435 \u0442\u0435\u0445\u043d\u043e\u043b\u043e\u0433\u0438\u0438:<\/p>\n\n- Spring 4.1.7.RELEASE<\/li>\n
- Hibernate Core 4.3.10.Final<\/li>\n
- validation-api 1.1.0.Final<\/li>\n
- hibernate-validator 5.1.3.Final<\/li>\n
- MySQL Server 5.6<\/li>\n
- Maven 3<\/li>\n
- JDK 1.7<\/li>\n
- NetBeans 8.0.2<\/li>\n<\/ul>\n
\u041f\u0440\u0438\u0441\u0442\u0443\u043f\u0438\u043c.<\/p>\n
\u0428\u0430\u0433 1: \u0421\u043e\u0437\u0434\u0430\u0434\u0438\u043c \u0441\u0445\u0435\u043c\u0443 \u0434\u043b\u044f \u043e\u0442\u043d\u043e\u0448\u0435\u043d\u0438\u044f \u043c\u043d\u043e\u0433\u0438\u0435-\u043a\u043e-\u043c\u043d\u043e\u0433\u0438\u043c \u0441 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435\u043c JOIN table<\/h4>\n
![](\"https:\/\/habrastorage.org\/files\/f43\/b7c\/c5f\/f43b7cc5f2f54776a4e1531f38bbd4e1.png\"\/)
<\/p>\n
APP_USER<\/b>: \u0421\u043e\u0434\u0435\u0440\u0436\u0438\u0442 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435\u0439. \u041f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c \u043c\u043e\u0436\u0435\u0442 \u0438\u043c\u0435\u0442\u044c \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u043f\u0440\u043e\u0444\u0438\u043b\u0435\u0439 [USER,ADMIN,DBA].
USER_PROFILE<\/b>: \u0421\u043e\u0434\u0435\u0440\u0436\u0438\u0442 \u043f\u0440\u043e\u0444\u0438\u043b\u0438 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435\u0439. \u041f\u0440\u043e\u0444\u0438\u043b\u044c \u043c\u043e\u0436\u0435\u0442 \u0431\u044b\u0442\u044c \u0441\u0432\u044f\u0437\u0430\u043d \u0441 \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u0438\u043c\u0438 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f\u043c\u0438.
APP_USER_USER_PROFILE<\/b>: \u042d\u0442\u043e \u0441\u043e\u0435\u0434\u0438\u043d\u044f\u044e\u0449\u0430\u044f \u0442\u0430\u0431\u043b\u0438\u0446\u0430, \u043a\u043e\u0442\u043e\u0440\u0430\u044f \u0441\u0432\u044f\u0437\u044b\u0432\u0430\u0435\u0442 \u0442\u0430\u0431\u043b\u0438\u0446\u044b APP_USER \u0438 USER_PROFILE \u0441 \u043e\u0442\u043d\u043e\u0448\u0435\u043d\u0438\u0435\u043c \u043c\u043d\u043e\u0433\u0438\u0435-\u043a\u043e-\u043c\u043d\u043e\u0433\u0438\u043c.<\/p>\n
\u0412 \u0434\u0435\u043c\u043e\u043d\u0441\u0442\u0440\u0430\u0446\u0438\u043e\u043d\u043d\u044b\u0445 \u0446\u0435\u043b\u044f\u0445, \u043c\u044b \u0431\u0443\u0434\u0435\u043c \u043e\u0431\u0441\u0443\u0436\u0434\u0430\u0442\u044c \u043e\u0442\u043d\u043e\u0448\u0435\u043d\u0438\u0435 \u043c\u043d\u043e\u0433\u0438\u0435-\u043a\u043e-\u043c\u043d\u043e\u0433\u0438\u043c \u0432 \u043e\u0434\u043d\u043e\u043d\u0430\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u043d\u043e\u0439 \u0443\u0441\u0442\u0430\u043d\u043e\u0432\u043a\u0435 [\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c \u0441 \u043f\u0440\u043e\u0444\u0438\u043b\u0435\u043c \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f] \u0432 \u044d\u0442\u043e\u043c \u043f\u0440\u0438\u043c\u0435\u0440\u0435.<\/p>\n
\u0421\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u0442\u0430\u0431\u043b\u0438\u0446 \u0438 \u0434\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445<\/b><\/p>\n\ncreate table APP_USER ( id BIGINT NOT NULL AUTO_INCREMENT, sso_id VARCHAR(30) NOT NULL, password VARCHAR(100) NOT NULL, first_name VARCHAR(30) NOT NULL, last_name VARCHAR(30) NOT NULL, email VARCHAR(30) NOT NULL, PRIMARY KEY (id), UNIQUE (sso_id) ); create table USER_PROFILE( id BIGINT NOT NULL AUTO_INCREMENT, type VARCHAR(30) NOT NULL, PRIMARY KEY (id), UNIQUE (type) ); CREATE TABLE APP_USER_USER_PROFILE ( user_id BIGINT NOT NULL, user_profile_id BIGINT NOT NULL, PRIMARY KEY (user_id, user_profile_id), CONSTRAINT FK_APP_USER FOREIGN KEY (user_id) REFERENCES APP_USER (id), CONSTRAINT FK_USER_PROFILE FOREIGN KEY (user_profile_id) REFERENCES USER_PROFILE (id) ); \/* Populate USER_PROFILE Table *\/ INSERT INTO USER_PROFILE(type) VALUES ('USER'); INSERT INTO USER_PROFILE(type) VALUES ('ADMIN'); INSERT INTO USER_PROFILE(type) VALUES ('DBA'); commit; <\/code><\/pre>\n <\/div>\n<\/div>\n
<\/p>\n
\u0428\u0430\u0433 2: \u0421\u043e\u0437\u0434\u0430\u0435\u043c \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u0443 \u043a\u0430\u0442\u0430\u043b\u043e\u0433\u0430<\/h4>\n
\u0424\u0438\u043d\u0430\u043b\u044c\u043d\u0430\u044f \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u0430 \u043f\u0440\u043e\u0435\u043a\u0442\u0430 \u0431\u0443\u0434\u0435\u0442 \u0432\u044b\u0433\u043b\u044f\u0434\u0435\u0442\u044c \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u043c \u043e\u0431\u0440\u0430\u0437\u043e\u043c.<\/p>\n
![](\"https:\/\/habrastorage.org\/files\/f21\/d25\/3f6\/f21d253f6eae4b259d6cfbd5f5d2d5aa.png\"\/)
<\/p>\n
\u0428\u0430\u0433 3: \u041e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0435 pom.xml, \u0447\u0442\u043e\u0431\u044b \u0432\u043a\u043b\u044e\u0447\u0438\u0442\u044c \u043d\u0443\u0436\u043d\u044b\u0435 \u0437\u0430\u0432\u0438\u0441\u0438\u043c\u043e\u0441\u0442\u0438<\/h4>\n
<\/p>\n
pom.xml<\/b><\/p>\n\n<project xsi:schemaLocation="http:\/\/maven.apache.org\/POM\/4.0.0 http:\/\/maven.apache.org\/xsd\/maven-4.0.0.xsd" xmlns="http:\/\/maven.apache.org\/POM\/4.0.0" xmlns:xsi="http:\/\/www.w3.org\/2001\/XMLSchema-instance"> <modelVersion>4.0.0<\/modelVersion> <groupId>com.websystique.springmvc<\/groupId> <artifactId>SpringMVCHibernateManyToManyCRUDExample<\/artifactId> <packaging>war<\/packaging> <version>1.0.0<\/version> <name>SpringMVCHibernateManyToManyCRUDExample<\/name> <properties> <springframework.version>4.1.7.RELEASE<\/springframework.version> <hibernate.version>4.3.10.Final<\/hibernate.version> <mysql.connector.version>5.1.31<\/mysql.connector.version> <\/properties> <dependencies> <!-- Spring --> <dependency> <groupId>org.springframework<\/groupId> <artifactId>spring-core<\/artifactId> <version>${springframework.version}<\/version> <\/dependency> <dependency> <groupId>org.springframework<\/groupId> <artifactId>spring-web<\/artifactId> <version>${springframework.version}<\/version> <\/dependency> <dependency> <groupId>org.springframework<\/groupId> <artifactId>spring-webmvc<\/artifactId> <version>${springframework.version}<\/version> <\/dependency> <dependency> <groupId>org.springframework<\/groupId> <artifactId>spring-tx<\/artifactId> <version>${springframework.version}<\/version> <\/dependency> <dependency> <groupId>org.springframework<\/groupId> <artifactId>spring-orm<\/artifactId> <version>${springframework.version}<\/version> <\/dependency> <!-- Hibernate --> <dependency> <groupId>org.hibernate<\/groupId> <artifactId>hibernate-core<\/artifactId> <version>${hibernate.version}<\/version> <\/dependency> <!-- jsr303 validation --> <dependency> <groupId>javax.validation<\/groupId> <artifactId>validation-api<\/artifactId> <version>1.1.0.Final<\/version> <\/dependency> <dependency> <groupId>org.hibernate<\/groupId> <artifactId>hibernate-validator<\/artifactId> <version>5.1.3.Final<\/version> <\/dependency> <!-- MySQL --> <dependency> <groupId>mysql<\/groupId> <artifactId>mysql-connector-java<\/artifactId> <version>${mysql.connector.version}<\/version> <\/dependency> <!-- Servlet+JSP+JSTL --> <dependency> <groupId>javax.servlet<\/groupId> <artifactId>javax.servlet-api<\/artifactId> <version>3.1.0<\/version> <\/dependency> <dependency> <groupId>javax.servlet.jsp<\/groupId> <artifactId>javax.servlet.jsp-api<\/artifactId> <version>2.3.1<\/version> <\/dependency> <dependency> <groupId>javax.servlet<\/groupId> <artifactId>jstl<\/artifactId> <version>1.2<\/version> <\/dependency> <\/dependencies> <build> <pluginManagement> <plugins> <plugin> <groupId>org.apache.maven.plugins<\/groupId> <artifactId>maven-war-plugin<\/artifactId> <version>2.4<\/version> <configuration> <warSourceDirectory>src\/main\/webapp<\/warSourceDirectory> <warName>SpringMVCHibernateManyToManyCRUDExample<\/warName> <failOnMissingWebXml>false<\/failOnMissingWebXml> <\/configuration> <\/plugin> <\/plugins> <\/pluginManagement> <finalName>SpringMVCHibernateManyToManyCRUDExample<\/finalName> <\/build> <\/project> <\/code><\/pre>\n <\/div>\n<\/div>\n
<\/p>\n
\u0428\u0430\u0433 4: \u041f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043a\u0430 \u043c\u043e\u0434\u0435\u043b\u044c\u043d\u044b\u0445 \u043a\u043b\u0430\u0441\u0441\u043e\u0432<\/h4>\n
<\/p>\n
\u043a\u043b\u0430\u0441\u0441 User<\/b><\/p>\n\npackage com.websystique.springmvc.model; import java.util.HashSet; import java.util.Set; import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.FetchType; import javax.persistence.GeneratedValue; import javax.persistence.GenerationType; import javax.persistence.Id; import javax.persistence.JoinColumn; import javax.persistence.JoinTable; import javax.persistence.ManyToMany; import javax.persistence.Table; import org.hibernate.validator.constraints.NotEmpty; @Entity @Table(name="APP_USER") public class User { @Id @GeneratedValue(strategy=GenerationType.IDENTITY) private Integer id; @NotEmpty @Column(name="SSO_ID", unique=true, nullable=false) private String ssoId; @NotEmpty @Column(name="PASSWORD", nullable=false) private String password; @NotEmpty @Column(name="FIRST_NAME", nullable=false) private String firstName; @NotEmpty @Column(name="LAST_NAME", nullable=false) private String lastName; @NotEmpty @Column(name="EMAIL", nullable=false) private String email; @NotEmpty @ManyToMany(fetch = FetchType.LAZY) @JoinTable(name = "APP_USER_USER_PROFILE", joinColumns = { @JoinColumn(name = "USER_ID") }, inverseJoinColumns = { @JoinColumn(name = "USER_PROFILE_ID") }) private Set<UserProfile> userProfiles = new HashSet<UserProfile>(); public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } public String getSsoId() { return ssoId; } public void setSsoId(String ssoId) { this.ssoId = ssoId; } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; } public String getFirstName() { return firstName; } public void setFirstName(String firstName) { this.firstName = firstName; } public String getLastName() { return lastName; } public void setLastName(String lastName) { this.lastName = lastName; } public String getEmail() { return email; } public void setEmail(String email) { this.email = email; } public Set<UserProfile> getUserProfiles() { return userProfiles; } public void setUserProfiles(Set<UserProfile> userProfiles) { this.userProfiles = userProfiles; } @Override public int hashCode() { final int prime = 31; int result = 1; result = prime * result + ((id == null) ? 0 : id.hashCode()); result = prime * result + ((ssoId == null) ? 0 : ssoId.hashCode()); return result; } @Override public boolean equals(Object obj) { if (this == obj) return true; if (obj == null) return false; if (!(obj instanceof User)) return false; User other = (User) obj; if (id == null) { if (other.id != null) return false; } else if (!id.equals(other.id)) return false; if (ssoId == null) { if (other.ssoId != null) return false; } else if (!ssoId.equals(other.ssoId)) return false; return true; } @Override public String toString() { return "User [id=" + id + ", ssoId=" + ssoId + ", password=" + password + ", firstName=" + firstName + ", lastName=" + lastName + ", email=" + email + "]"; } } <\/code><\/pre>\n <\/div>\n<\/div>\n
\u041f\u043e\u0441\u043c\u043e\u0442\u0440\u0438\u0442\u0435, \u043a\u0430\u043a \u0441\u0432\u043e\u0439\u0441\u0442\u0432\u043e userProfiles \u0430\u043d\u043d\u043e\u0442\u0438\u0440\u0443\u0435\u0442\u0441\u044f c \u00ab\u043c\u043d\u043e\u0433\u0438\u0435-\u043a\u043e-\u043c\u043d\u043e\u0433\u0438\u043c\u00bb.<\/p>\n
@ManyToMany<\/code> \u0443\u043a\u0430\u0437\u044b\u0432\u0430\u0435\u0442, \u0447\u0442\u043e \u0435\u0441\u0442\u044c \u043e\u0442\u043d\u043e\u0448\u0435\u043d\u0438\u0435 \u043c\u043d\u043e\u0433\u0438\u0435-\u043a\u043e-\u043c\u043d\u043e\u0433\u0438\u043c \u043c\u0435\u0436\u0434\u0443 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435\u043c \u0438 \u043f\u0440\u043e\u0444\u0438\u043b\u0435\u043c \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f. \u041f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c \u043c\u043e\u0436\u0435\u0442 \u0438\u043c\u0435\u0442\u044c \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u043f\u0440\u043e\u0444\u0438\u043b\u0435\u0439 [USER, ADMIN, DBA], \u0432 \u0442\u043e \u0432\u0440\u0435\u043c\u044f \u043a\u0430\u043a, \u043f\u0440\u043e\u0444\u0438\u043b\u044c \u043c\u043e\u0436\u0435\u0442 \u043f\u0440\u0438\u043d\u0430\u0434\u043b\u0435\u0436\u0430\u0442\u044c \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u0438\u043c \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f\u043c.@JoinTable<\/code> \u043f\u043e\u043a\u0430\u0437\u044b\u0432\u0430\u0435\u0442, \u0447\u0442\u043e \u0435\u0441\u0442\u044c \u0441\u0441\u044b\u043b\u043e\u0447\u043d\u0430\u044f \u0442\u0430\u0431\u043b\u0438\u0446\u0430, \u043a\u043e\u0442\u043e\u0440\u0430\u044f \u0441\u043e\u0435\u0434\u0438\u043d\u044f\u0435\u0442 \u0434\u0432\u0435 \u0442\u0430\u0431\u043b\u0438\u0446\u044b, \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044f \u043e\u0433\u0440\u0430\u043d\u0438\u0447\u0435\u043d\u0438\u044f \u0432\u043d\u0435\u0448\u043d\u0438\u0445 \u043a\u043b\u044e\u0447\u0435\u0439 \u043a \u0438\u0445 \u043f\u0435\u0440\u0432\u0438\u0447\u043d\u044b\u043c. \u042d\u0442\u0430 \u0430\u043d\u043d\u043e\u0442\u0430\u0446\u0438\u044f \u0432 \u043e\u0441\u043d\u043e\u0432\u043d\u043e\u043c \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442\u0441\u044f \u043d\u0430 \u0441\u0442\u043e\u0440\u043e\u043d\u0435 \u0432\u043b\u0430\u0434\u0435\u044e\u0449\u0435\u0439 \u043e\u0442\u043d\u043e\u0448\u0435\u043d\u0438\u0439. joinColumns<\/code> \u0441\u0441\u044b\u043b\u0430\u0435\u0442\u0441\u044f \u043a \u0438\u043c\u0435\u043d\u0438 \u0441\u0442\u043e\u043b\u0431\u0446\u0430 \u043d\u0430 \u0432\u043b\u0430\u0434\u0435\u044e\u0449\u0435\u0439 \u0441\u0442\u043e\u0440\u043e\u043d\u0435 (ID \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f), \u0430 \u043e\u0431\u0440\u0430\u0442\u043d\u0430\u044f joinColumns<\/code> \u043e\u0442\u043d\u043e\u0441\u0438\u0442\u0441\u044f \u043a \u043a\u043e\u043b\u043e\u043d\u043a\u0435 \u043e\u0431\u0440\u0430\u0442\u043d\u043e\u0439 \u0441\u0442\u043e\u0440\u043e\u043d\u044b \u043e\u0442\u043d\u043e\u0448\u0435\u043d\u0438\u044f (ID \u0438 \u043f\u0440\u043e\u0444\u0438\u043b\u044c \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f). \u041f\u0435\u0440\u0432\u0438\u0447\u043d\u044b\u0439 \u043a\u043b\u044e\u0447 \u044d\u0442\u043e\u0439 \u0441\u043e\u0435\u0434\u0438\u043d\u044f\u044e\u0449\u0435\u0439 \u0442\u0430\u0431\u043b\u0438\u0446\u044b \u0435\u0441\u0442\u044c \u0441\u043e\u0447\u0435\u0442\u0430\u043d\u0438\u0435 USER_ID \u0438 USER_PROFILE_ID.<\/p>\n \u00ab\u041b\u0435\u043d\u0438\u0432\u0430\u044f \u0437\u0430\u0433\u0440\u0443\u0437\u043a\u0430\u00bb<\/b><\/p>\n
![](\"https:\/\/habrastorage.org\/files\/108\/e8f\/0ce\/108e8f0cea1c405fa802a48b59a73d96.png\"\/)
<\/div>\n<\/div>\n![](\"https:\/\/habrastorage.org\/files\/bf4\/8bc\/17e\/bf48bc17e4be47c0b15488636820d81f.png\"\/)
<\/div>\n<\/div>\n![](\"https:\/\/habrastorage.org\/files\/e79\/578\/ed5\/e79578ed57d449d8a8f21ae0443728ad.png\"\/)
<\/div>\n<\/div>\n