SpringDataJPA是Spring Data的一個(gè)子項(xiàng)目荤懂，通過提供基于JPA的Repository極大的減少了JPA作為數(shù)據(jù)訪問方案的代碼量，你僅僅需要編寫一個(gè)接口集成下SpringDataJPA內(nèi)部定義的接口即可完成簡單的CRUD操作硫眨。
前言
本篇文章引導(dǎo)你通過Spring Boot，Spring Data JPA和MySQL實(shí)現(xiàn)many-to-many關(guān)聯(lián)映射撩笆。
準(zhǔn)備
- JDK 1.8 或更高版本
- Maven 3 或更高版本
- MySQL Server 5.6
技術(shù)棧
- Spring Data JPA
- Spring Boot
- MySQL
目錄結(jié)構(gòu)
[圖片上傳失敗...(image-6352f3-1520077140162)]
父pom.xml
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>cn.merryyou</groupId>
<artifactId>jpa-example</artifactId>
<version>1.0-SNAPSHOT</version>
<modules>
<module>one-to-one-foreignkey</module>
<module>one-to-one-primarykey</module>
<module>one-to-many</module>
<module>many-to-many</module>
<module>many-to-many-extra-columns</module>
</modules>
<packaging>pom</packaging>
<dependencyManagement>
<dependencies>
<dependency>
<groupId>io.spring.platform</groupId>
<artifactId>platform-bom</artifactId>
<version>Brussels-SR6</version>
<type>pom</type>
<scope>import</scope>
</dependency>
</dependencies>
</dependencyManagement>
</project>
多對多關(guān)聯(lián)映射
目錄結(jié)構(gòu)
[圖片上傳失敗...(image-e4badc-1520077140162)]
pom.xml
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<parent>
<artifactId>jpa-example</artifactId>
<groupId>cn.merryyou</groupId>
<version>1.0-SNAPSHOT</version>
</parent>
<modelVersion>4.0.0</modelVersion>
<artifactId>many-to-many</artifactId>
<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<java.version>1.8</java.version>
</properties>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
</plugin>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-compiler-plugin</artifactId>
<version>3.6.1</version>
<configuration>
<source>1.8</source>
<target>1.8</target>
</configuration>
</plugin>
</plugins>
</build>
</project>
多對多關(guān)聯(lián)
book.id 和 publisher.id 多對多關(guān)聯(lián)表book_publisher
db.sql
CREATE DATABASE IF NOT EXISTS `jpa_manytomany`;
USE `jpa_manytomany`;
--
-- Table structure for table `book`
--
DROP TABLE IF EXISTS `book`;
CREATE TABLE `book` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;
--
-- Table structure for table `publisher`
--
DROP TABLE IF EXISTS `publisher`;
CREATE TABLE `publisher` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;
--
-- Table structure for table `book_publisher`
--
DROP TABLE IF EXISTS `book_publisher`;
CREATE TABLE `book_publisher` (
`book_id` int(10) unsigned NOT NULL,
`publisher_id` int(10) unsigned NOT NULL,
PRIMARY KEY (`book_id`,`publisher_id`),
KEY `fk_bookpublisher_publisher_idx` (`publisher_id`),
CONSTRAINT `fk_bookpublisher_book` FOREIGN KEY (`book_id`) REFERENCES `book` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `fk_bookpublisher_publisher` FOREIGN KEY (`publisher_id`) REFERENCES `publisher` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
實(shí)體類
Book
@Entity
public class Book {
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
private int id;
private String name;
@ManyToMany(cascade = CascadeType.MERGE)
@JoinTable(name = "book_publisher", joinColumns = @JoinColumn(name = "book_id", referencedColumnName = "id"), inverseJoinColumns = @JoinColumn(name = "publisher_id", referencedColumnName = "id"))
private Set<Publisher> publishers = new HashSet<>();
public Book() {
}
public Book(String name) {
this.name = name;
}
public Book(String name, Set<Publisher> publishers) {
this.name = name;
this.publishers = publishers;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public Set<Publisher> getPublishers() {
return publishers;
}
public void setPublishers(Set<Publisher> publishers) {
this.publishers = publishers;
}
@Override
public String toString() {
String result = String.format(
"Book [id=%d, name='%s']%n",
id, name);
if (publishers != null) {
for (Publisher publisher : publishers) {
result += String.format(
"Publisher[id=%d, name='%s']%n",
publisher.getId(), publisher.getName());
}
}
return result;
}
}
Publisher
@Entity
public class Publisher {
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
private int id;
private String name;
@ManyToMany(mappedBy = "publishers")
private Set<Book> books = new HashSet<>();
public Publisher(){
}
public Publisher(String name){
this.name = name;
}
public Publisher(String name, Set<Book> books){
this.name = name;
this.books = books;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public Set<Book> getBooks() {
return books;
}
public void setBooks(Set<Book> books) {
this.books = books;
}
@Override
public String toString() {
String result = String.format(
"Publisher [id=%d, name='%s']%n",
id, name);
if (books != null) {
for(Book book : books) {
result += String.format(
"Book[id=%d, name='%s']%n",
book.getId(), book.getName());
}
}
return result;
}
}
@Table聲明此對象映射到數(shù)據(jù)庫的數(shù)據(jù)表捺球，通過它可以為實(shí)體指定表(talbe),目錄(Catalog)和schema的名字缸浦。該注釋不是必須的夕冲，如果沒有則系統(tǒng)使用默認(rèn)值(實(shí)體的短類名)。@Id聲明此屬性為主鍵裂逐。該屬性值可以通過應(yīng)該自身創(chuàng)建歹鱼，但是Hibernate推薦通過Hibernate生成-
@GeneratedValue指定主鍵的生成策略。- TABLE：使用表保存id值
- IDENTITY：identitycolumn
- SEQUENCR ：sequence
- AUTO：根據(jù)數(shù)據(jù)庫的不同使用上面三個(gè)
@Column聲明該屬性與數(shù)據(jù)庫字段的映射關(guān)系卜高。@ManyToMany多對多關(guān)聯(lián)關(guān)系@JoinColumn指定關(guān)聯(lián)的字段@JoinTable參考
Spring Data JPA Repository
BookRepository
public interface BookRepository extends JpaRepository<Book, Integer> {
}
PublisherRepository
public interface PublisherRepository extends JpaRepository<Publisher, Integer> {
}
Spring Data JPA包含了一些內(nèi)置的Repository弥姻，實(shí)現(xiàn)了一些常用的方法：findone，findall掺涛，save等庭敦。
application.yml
spring:
datasource:
url: jdbc:mysql://localhost/jpa_manytomany
username: root
password: admin
driver-class-name: com.mysql.jdbc.Driver
jpa:
show-sql: true
properties:
hibernate:
enable_lazy_load_no_trans: true
BookRepositoryTest
@RunWith(SpringRunner.class)
@SpringBootTest
@Slf4j
public class BookRepositoryTest {
@Autowired
private BookRepository bookRepository;
@Autowired
private PublisherRepository publisherRepository;
@Test
public void saveTest() throws Exception {
Publisher publisherA = new Publisher("Publisher One");
Publisher publisherB = new Publisher("Publisher Two");
Book bookA = new Book("Book One");
bookA.setPublishers(new HashSet<Publisher>() {{
add(publisherA);
add(publisherB);
}});
bookRepository.save(bookA);
}
@Test
public void saveTest1() throws Exception{
Publisher publisher = publisherRepository.findOne(24);
Book bookA = new Book("Book Two");
bookA.getPublishers().add(publisher);
bookRepository.save(bookA);
}
@Test
public void saveTest2() throws Exception{
Book two = bookRepository.findOne(18);
Publisher publisher = publisherRepository.findOne(25);
two.getPublishers().add(publisher);
bookRepository.save(two);
}
@Test
public void findPublisherTest() throws Exception{
Publisher publisher = publisherRepository.findOne(24);
Set<Book> books = publisher.getBooks();
for(Book book: books){
log.info(book.getName()+"..."+book.getId());
}
Assert.assertNotNull(publisher);
Assert.assertNotNull(publisher.getName());
}
@Test
public void findAllTest() throws Exception {
for (Book book : bookRepository.findAll()) {
log.info(book.toString());
}
}
@Test
public void findBookTest() throws Exception{
Book book = bookRepository.findOne(16);
Set<Publisher> publishers = book.getPublishers();
for(Publisher publisher: publishers){
log.info(publisher.getName()+"..."+publisher.getId());
}
Assert.assertNotNull(book);
Assert.assertNotNull(book.getName());
}
}
代碼下載
從我的 github 中下載，https://github.com/longfeizheng/jpa-example/tree/master/many-to-many
??????關(guān)注微信小程序java架構(gòu)師歷程
上下班的路上無聊嗎薪缆？還在看小說秧廉、新聞嗎？不知道怎樣提高自己的技術(shù)嗎拣帽？來吧這里有你需要的java架構(gòu)文章疼电，1.5w+的java工程師都在看，你還在等什么减拭？
