Spring Data JPAによるデータアクセス徹底入門 #jsug

ͦͷଞͷ4QSJOHؔ࿈τϨʔχϯάҰཡ ‫ݚ‬म໊ ೔਺ Spring Web 4೔ؒ Spring MVCͷ‫͔ૅج‬ΒԠ༻·Ͱ 2೔ؒ Spring Bootͷ‫͔ૅج‬ΒԠ༻·Ͱ Spring Boot Developer Spring Cloud Services 3೔ؒ આ໌ Spring CloudʹΑΔMicroservices ։ൃ 8 (C) CASAREAL, Inc. All rights reserved.

9.

https://www.casareal.co.jp/ls/service/eventseminar/lineup/fs171130

10.

ᶃ +1"4QSJOH%BUB+1"ͱ͸ʁ ᶄ +1"ΤϯςΟςΟͷঢ়ଶ؅ཧ ᶅ +BWB1FSTJTUFODF2VFSZ-BOHVBHF +12- ᶆ ϦϨʔγϣϯͱ/ ໰୊ରࡦ ᶇ %#੡඼‫ݻ‬༗‫ػ‬ೳͷར༻ ᶈ 4QSJOH%BUB+1"ͷར༻ ᶉ 4QSJOH#PPUར༻࣌ͷ஫ҙ఺ ᶊ +1"͸ʮ࢖͑Δʯͷ͔ʁ 10 (C) CASAREAL, Inc. All rights reserved.

11.

ᶃ +1"4QSJOH%BUB+1"ͱ͸ʁ ᶄ +1"ΤϯςΟςΟͷঢ়ଶ؅ཧ ᶅ +BWB1FSTJTUFODF2VFSZ-BOHVBHF +12- ᶆ ϦϨʔγϣϯͱ/ ໰୊ରࡦ ᶇ %#੡඼‫ݻ‬༗‫ػ‬ೳͷར༻ ᶈ 4QSJOH%BUB+1"ͷར༻ ᶉ 4QSJOH#PPUར༻࣌ͷ஫ҙ఺ ᶊ +1"͸ʮ࢖͑Δʯͷ͔ʁ 11 (C) CASAREAL, Inc. All rights reserved.

12.

13.

14.

15.

16.

17.

4QSJOH%BUB+1"Λ࢖͓͏ ▸ 4QSJOH#PPUͷ৔߹ <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-data-jpa</artifactId> </dependency> 17 (C) CASAREAL, Inc. All rights reserved.

18.

4QSJOH%BUB+1"Λ࢖͓͏ ▸ ඇ4QSJOH#PPUͷ৔߹ <dependency> <groupId>org.springframework.data</groupId> <artifactId>spring-data-jpa</artifactId> <version>2.0.1.RELEASE</version> </dependency> <dependency> <groupId>org.hibernate</groupId> <artifactId>hibernate-entitymanager</artifactId> <version>5.2.12.Final</version> </dependency> 18 (C) CASAREAL, Inc. All rights reserved.

19.

42-ϩάͷग़ྗ͸ඞਢʂ ▸ τϥϒϧγϡʔςΟϯάͰॏཁʂ ▸ 4QSJOH#PPUɿBQQMJDBUJPOQSPQFSUJFTʹԼ‫ه‬Λઃఆ logging.level.org.hibernate.SQL=debug logging.level.org.hibernate.type.descriptor.sql.BasicBinder=\ trace ▸ ඇ4QSJOH#PPUɿMPHCBDLYNMʹԼ‫ه‬Λઃఆ <logger name="org.hibernate.SQL" level="DEBUG" /> <logger name="org.hibernate.type.descriptor.sql.BasicBinder" level="TRACE" /> ※hibernate.show_sql=trueͩͱϩάͷϑΥʔϚοτΛࢦఆͰ͖ͳ͍ͷͰ͜ΕΒͷํ๏͕Φεεϝ (C) CASAREAL, Inc. All rights reserved. 19

20.

42-ϩάΛಡΈ΍͘͢͢Δ ▸ վߦ΍Πϯσϯτ͕ೖΔΑ͏ʹͳΔ ▸ 4QSJOH#PPUɿBQQMJDBUJPOQSPQFSUJFTʹԼ‫ه‬Λઃఆ spring.jpa.properties.hibernate.format_sql=true ▸ ඇ4QSJOH#PPUɿ+BWB$POpHʹԼ‫ه‬Λ‫ه‬ड़ ▸ IUUQTHJUIVCDPN.BTBUPTIJ5BEBTQSJOHGPSTQSJOHCPPUCMPCNBTUFS TQSJOHTSDNBJOKBWBDPNFYBNQMFQFSTJTUFODFDPOpH +QB$POpHKBWB- 20 (C) CASAREAL, Inc. All rights reserved.

https://github.com/MasatoshiTada/spring-for-spring-boot/blob/master/01-spring/src/main/java/com/example/persistence/config/JpaConfig.java#L31

21.

ᶃ +1"4QSJOH%BUB+1"ͱ͸ʁ ᶄ +1"ΤϯςΟςΟͷঢ়ଶ؅ཧ ᶅ +BWB1FSTJTUFODF2VFSZ-BOHVBHF +12- ᶆ ϦϨʔγϣϯͱ/ ໰୊ରࡦ ᶇ %#੡඼‫ݻ‬༗‫ػ‬ೳͷར༻ ᶈ 4QSJOH%BUB+1"ͷར༻ ᶉ 4QSJOH#PPUར༻࣌ͷ஫ҙ఺ ᶊ +1"͸ʮ࢖͑Δʯͷ͔ʁ 21 (C) CASAREAL, Inc. All rights reserved.

22.

23.

24.

25.

26.

27.

28.

&OUJUZ.BOBHFSͷϝιου ϝιου આ໌ find() ओΩʔ‫ࡧݕ‬ persist() 1݅ͷӬଓԽ remove() 1݅ͷ࡟আ merge() ӬଓԽίϯςΩετ؅ཧԼʹ͢Δ detach() ӬଓԽίϯςΩετ؅ཧ֎ʹ͢Δ flush() มߋΛDB΁൓ө clear() ӬଓԽίϯςΩετΛΫϦΞ refresh() ΤϯςΟςΟͷ಺༰ΛDB࠷৽ʹ্ॻ͖ 28 (C) CASAREAL, Inc. All rights reserved.

29.

˒ॏཁ˒ΤϯςΟςΟͷঢ়ଶભҠ ӬଓԽίϯςΩετ persist() /&8 ঢ়ଶ detach() clear() %&5"$)&% ঢ়ଶ ."/"(&% ঢ়ଶ remove() merge() detach() clear() 3&.07&% ঢ়ଶ find() JPQL flush() refresh() flush() 29 (C) CASAREAL, Inc. All rights reserved.

30.

ओΩʔ‫ࡧݕ‬ ▸ ‫ج‬ຊతʹશϑΟʔϧυʹ૬౰͢Δྻ͕‫͞ࡧݕ‬ΕΔ EntityManager em = …; // ୈ1Ҿ਺ʹΤϯςΟςΟΫϥεɺୈ2Ҿ਺ʹओΩʔ஋ Product product = em.find(Product.class, 1); select product0_.id as id1_5_0_, product0_.category_id as category4_5_0_, product0_.name as name2_5_0_, product0_.price as price3_5_0_, product0_.vendor_id as vendor_i5_5_0_ from product product0_ where product0_.id=? (C) CASAREAL, Inc. All rights reserved. ͜ΜͳSQL͕ ൃߦ͞ΕΔ 30

31.

௥Ճ ▸ ‫ج‬ຊతʹશϑΟʔϧυ͕*/4&35͞ΕΔ ▸ */4&35͠ͳ͍ϑΟʔϧυʹ͸!5SBOTJFOUΛ෇Ճ͢Δ Product product = new Product(“Ε͍ͧ͏͜”, 100000L); em.persist(product); insert into product (category_id, name, price, vendor_id, id) values (?, ?, ?, ?, ?) 31 (C) CASAREAL, Inc. All rights reserved.

32.

ߋ৽ ▸ ."/"(&%ঢ়ଶͷΤϯςΟςΟʹTFUUFSͰ஋Λ ߋ৽ˠ൓ө // find()Ͱ‫͢ࡧݕ‬ΔͱMANAGEDঢ়ଶ Product product = em.find(Product.class, 1); // ஋ͷߋ৽ product.setName("ߋ৽‫ޙ‬ͷ໊લ"); // ߋ৽ͷ൓ө(ίϛοτͰ΋OK) em.flush(); 32 (C) CASAREAL, Inc. All rights reserved.

33.

ߋ৽ select … from product product0_ where product0_.id=? binding parameter [1] as [INTEGER] - [1] update product set category_id=?, name=?, price=?, vendor_id=? where id=? binding parameter [1] as [INTEGER] - [1] binding parameter [2] as [VARCHAR] - [ߋ৽‫ޙ‬ͷ໊લ] binding parameter [3] as [BIGINT] - [100000] binding parameter [4] as [INTEGER] - [1] binding parameter [5] as [INTEGER] - [1] 33 (C) CASAREAL, Inc. All rights reserved.

34.

NFSHF ʹΑΔߋ৽ ▸ OFXͨ͠ΤϯςΟςΟΛNFSHF ͢Δ Product product = new Product(); product.setId(1); product.setName(“ߋ৽‫ޙ‬ͷ໊લ"); // merge()Ͱ΋ߋ৽Ͱ͖Δ em.merge(product); em.flush(); 34 (C) CASAREAL, Inc. All rights reserved.

35.

NFSHF ʹΑΔߋ৽ ▸ 4&-&$5จʴ61%"5&จ͕ൃߦ͞ΕΔ select … from product product0_ where product0_.id=? binding parameter [1] as [INTEGER] - [1] update product set category_id=?, name=?, price=?, vendor_id=? where id=? binding parameter [1] as [INTEGER] - [null] binding parameter [2] as [VARCHAR] - [ߋ৽‫ޙ‬ͷ໊લ] binding parameter [3] as [BIGINT] - [null] binding parameter [4] as [INTEGER] - [null] binding parameter [5] as [INTEGER] - [1] 35 (C) CASAREAL, Inc. All rights reserved.

36.

NFSHF ͷམͱ݀͠ ▸ Ҿ਺ΤϯςΟςΟͷίϐʔ͕࡞ΒΕɺͦΕ͕໭ Γ஋͔ͭ."/"(&%ঢ়ଶʹͳΔ ▸ Ҿ਺ࣗମ͸."/"(&%ঢ়ଶʹͳΒͳ͍ͷͰ஫ҙ Product mergedProduct = em.merge(product); // ໭Γ஋͸MANAGEDঢ়ଶ assertTrue(em.contains(mergedProduct)); // Ҿ਺ͷঢ়ଶ͸มΘΒͳ͍ assertFalse(em.contains(product)); 36 (C) CASAREAL, Inc. All rights reserved.

37.

࡟আ ▸ ."/"(&%ঢ়ଶͷΤϯςΟςΟΛSFNPWF ͢Δ // find()Ͱ‫͢ࡧݕ‬ΔͱMANAGEDঢ়ଶ Product product = em.find(Product.class, 30); // REMOVEDঢ়ଶʹ͢Δ em.remove(product); // ߋ৽ͷ൓ө(ίϛοτͰ΋OK) em.flush(); 37 (C) CASAREAL, Inc. All rights reserved.

38.

࡟আ select … from product product0_ where product0_.id=? binding parameter [1] as [INTEGER] - [30] delete from product where id=? binding parameter [1] as [INTEGER] - [30] 38 (C) CASAREAL, Inc. All rights reserved.

39.

࡟আͷΩϟϯηϧ ▸ EFUBDI ·ͨ͸DMFBS Ͱ%&5"$)&%ঢ়ଶʹ͢Δ // find()Ͱ‫͢ࡧݕ‬ΔͱMANAGEDঢ়ଶ Product product = em.find(Product.class, 30); // REMOVEDঢ়ଶʹ͢Δ em.remove(product); // DETACHEDঢ়ଶʹ͢Δ em.detach(product); // DETACHEDঢ়ଶͳͷͰDBʹ൓ө͞Εͳ͍ em.flush(); 39 (C) CASAREAL, Inc. All rights reserved.

40.

41.

ᶃ +1"4QSJOH%BUB+1"ͱ͸ʁ ᶄ +1"ΤϯςΟςΟͷঢ়ଶ؅ཧ ᶅ +BWB1FSTJTUFODF2VFSZ-BOHVBHF +12- ᶆ ϦϨʔγϣϯͱ/ ໰୊ରࡦ ᶇ %#੡඼‫ݻ‬༗‫ػ‬ೳͷར༻ ᶈ 4QSJOH%BUB+1"ͷར༻ ᶉ 4QSJOH#PPUར༻࣌ͷ஫ҙ఺ ᶊ +1"͸ʮ࢖͑Δʯͷ͔ʁ 41 (C) CASAREAL, Inc. All rights reserved.

42.

43.

[beta]

‫ج‬ຊతͳ࢖͍ํ
▸ ୯Ұ‫ࡧݕ‬
TypedQuery<Product> query = em.createQuery(
"SELECT p FROM Product p WHERE p.id = :id",
Product.class);
query.setParameter("id", 1);
Product product = query.getSingleResult();

▸ ෳ਺‫ࡧݕ‬
TypedQuery<Product> query = em.createQuery(
"SELECT p FROM Product p WHERE p.id <= :maxId"
+ " ORDER BY p.id", Product.class);
query.setParameter("maxId", 5);
List<Product> list = query.getResultList();
43
(C) CASAREAL, Inc. All rights reserved.

44.

࣮ߦ͢Δͱ42-ʹ຋༁͞ΕΔ ▸ ͲΜͳ42-͕ൃߦ͞ΕΔ͔͸+1"࢓༷Ͱະఆٛ ʹ‫׬‬શʹ࣮૷ґଘʢԼ‫ه‬͸)JCFSOBUFͷྫʣ select product0_.id as id1_5_, product0_.category_id as category4_5_, product0_.name as name2_5_, product0_.price as price3_5_, product0_.vendor_id as vendor_i5_5_ from product product0_ where product0_.id=? (C) CASAREAL, Inc. All rights reserved. 44

45.

+12-ͷ‫ج‬ຊจ๏ SELECT ࣝผม਺ FROM ΤϯςΟςΟ໊ [AS] ࣝผม਺ WHERE ࣝผม਺.ϓϩύςΟ໊ <= :ύϥϝʔλ໊ ▸ ࣝผม਺ʹΤϯςΟςΟͷผ໊ʢඞਢʣ ▸ ΤϯςΟςΟ໊΍ϓϩύςΟ໊͸ɺ େจࣈখจࣈΛ‫۠ʹີݫ‬ผ͢ΔͷͰ஫ҙʂ ▸ 4&-&$5౳͸۠ผ͠ͳ͍͕େจࣈͷํ͕ؒҧ͑ʹ͍͘ 45 (C) CASAREAL, Inc. All rights reserved.

46.

ίϯετϥΫλࣜ ▸ ඇΤϯςΟςΟͳΫϥεʹ΋ϚοϐϯάՄೳ ▸ ओͳ༻్͸ू‫ܭ‬ SELECT new com.example.demo.dto.CountDto( od.product.id, COUNT(od)) FROM OrderDetail od GROUP BY od.product.id ύοέʔδ໊෇͖ͳͷ͕ਏ͍ʜ 46 (C) CASAREAL, Inc. All rights reserved.

47.

ͦͷଞͷ+12-Ͱग़དྷΔ͜ͱᶃ ▸ ݁߹ʢ*//&3+0*/ɺ-&'5065&3+0*/ɻৄࡉ͸‫ޙ‬ ड़ʣ ▸ #&58&&/ɺ*/ɺ-*,&ɺ&9*454ɺ"--ɺ"/:ɺ$"4& ▸ (3061#:ɺ)"7*/( ▸ ू‫਺ؔܭ‬ʢ."9 ɺ.*/ ɺ$06/5 ɺ46. ɺ "7( ͷͭʣ ▸ ෭໰߹ͤʢ8)&3&۟ͱ)"7*/(۟ͰͷΈʣ 47 (C) CASAREAL, Inc. All rights reserved.

48.

ͦͷଞͷ+12-Ͱग़དྷΔ͜ͱᶄ ▸ จࣈྻؔ਺ʢ$0/$"5 ɺ46#453*/( ɺ53*. ɺ -08&3 ɺ611&3 ɺ-&/(5) ɺ-0$"5& ʣ ▸ ࢉज़ؔ਺ʢ"#4 ɺ4235 ɺ.0% ɺ4*;& ɺ */%&9 ʣ ▸ ೔࣌ؔ਺ʢ$633&/5@%"5&ɺ$633&/5@5*.&ɺ $633&/5@5*.&45".1ʣ ▸ %#‫ݻ‬༗ؔ਺ͷ‫ͼݺ‬ग़͠ʢ‫ޙ‬ड़ʣ 48 (C) CASAREAL, Inc. All rights reserved.

49.

50.

51.

ᶃ +1"4QSJOH%BUB+1"ͱ͸ʁ ᶄ +1"ΤϯςΟςΟͷঢ়ଶ؅ཧ ᶅ +BWB1FSTJTUFODF2VFSZ-BOHVBHF +12- ᶆ ϦϨʔγϣϯͱ/ ໰୊ରࡦ ᶇ %#੡඼‫ݻ‬༗‫ػ‬ೳͷར༻ ᶈ 4QSJOH%BUB+1"ͷར༻ ᶉ 4QSJOH#PPUར༻࣌ͷ஫ҙ఺ ᶊ +1"͸ʮ࢖͑Δʯͷ͔ʁ 51 (C) CASAREAL, Inc. All rights reserved.

52.

[beta]

ϦϨʔγϣϯΛද‫͢ݱ‬Δ
▸ !0OF5P0OF
▸ !0OF5P.BOZ
▸ !.BOZ5P0OF
▸ !.BOZ5P.BOZ

@Entity
public class Product {
…
@ManyToOne
@JoinColumn(name="vendor_id")
private Vendor vendor;
}
@Entity
public class Vendor {
…
}

52
(C) CASAREAL, Inc. All rights reserved.

53.

ϑΣονͱ͸ ▸ ͋ΔΤϯςΟςΟΛಡΈࠐΜͩ࣌ɺϦϨʔγϣϯઌ ͷΤϯςΟςΟΛ͍ͭಡΈࠐΉ͔ ᶃ &"(&3ϑΣονɿଈ࣌ಡΈࠐΈ ▸ ಉ࣌ʹಡΈࠐΉʢ)JCFSOBUFͩͱ+0*/ɺ&DMJQTF-JOLͩͱ 4&-&$5จ͕ෳ਺ಉ࣌ʹൃߦʣ ᶄ -";:ϑΣονɿ஗ԆಡΈࠐΈ ▸ ඞཁʹͳͬͨ࣌ʢHFUUFS͕‫ݺ‬͹Εͨ࣌ʣʹಡΈࠐΉ 53 (C) CASAREAL, Inc. All rights reserved.

54.

[beta]

ϑΣονͷࢦఆํ๏
▸ !9YY5P9YYͷGFUDIଐੑʹࢦఆ͢Δ
▸ !9YY5P.BOZˠσϑΥϧτͰ-";:
▸ !9YY5P0OFˠσϑΥϧτͰ&"(&3
@Entity
public class Product {
…
@ManyToOne(fetch = FetchType.LAZY)
@JoinColumn(name="vendor_id")
private Vendor vendor;
}
54
(C) CASAREAL, Inc. All rights reserved.

55.

[beta]

-";:ϑΣονͷྫ
@Entity public class Product {
@ManyToOne(fetch = FetchType.LAZY)
private Vendor vendor;
}
Product p = em.find(Product.class, 1);
Vendor v = p.getVendor();
String n = v.getName() // ͜͜Ͱ΋SELECT

2ճ
SELECT

select (ྻলུ) from product product0_
where product0_.id=?
select (ྻলུ) from vendor vendor0_
where vendor0_.id=?
55
(C) CASAREAL, Inc. All rights reserved.

56.

-";:ϑΣονͷ஫ҙ఺ ▸ ӬଓԽίϯςΩετഁ‫ޙغ‬ʢ㲈τϥϯβΫγϣϯ ऴྃ‫ޙ‬ʣʹϑΣον͢Δͱྫ֎͕ൃੜ͢Δ em.getTransaction().begin(); Product p = em.find(Product.class, 1); em.getTransaction().rollback(); Vendor v = p.getVendor(); String n = v.getName(); // ͜͜Ͱྫ֎ൃੜ 56 (C) CASAREAL, Inc. All rights reserved.

57.

&"(&3ϑΣονͷྫ @Entity public class Product { @ManyToOne(fetch = FetchType.EAGER) private Vendor vendor; } 1ճͷΈ SELECT Product p = em.find(Product.class, 1); Vendor v = p.getVendor(); // ‫ʹط‬ಡΈࠐΈࡁΈ select (ྻলུ) from product product0_ left outer join vendor vendor2_ on product0_.vendor_id=vendor2_.id where product0_.id=? 57 (C) CASAREAL, Inc. All rights reserved.

58.

[beta]

ϑΣον͸‫ج‬ຊ-";:ʂ
▸ &"(&3ʹ͢Δͱෆཁͳσʔλ·ͰಡΈࠐΉ͔Β
▸ !0OF5P.BOZͰେྔͷσʔλΛಡΈࠐΉͱ͔‫ڪ‬ා
ʢʹ/ ໰୊ʣ

▸ -";:͔Β&"(&3ʹಈతʹมߋ͍ͨ͠৔߹͸ɺ
+12-ͷ+0*/'&5$)จΛར༻͢Δ

58
(C) CASAREAL, Inc. All rights reserved.

59.

[beta]

/ ໰୊͕‫͜ى‬Δྫ
// order_summary΁ͷSELECT͕ൃߦ͞ΕΔʢ1ճʣ
List<OrderSummary> list = em.createQuery(
"SELECT os FROM OrderSummary os",OrderSummary.class)
.getResultList();
for (OrderSummary os : list) {
// ·ͩorder_detail͸ಡΈࠐ·Ε͍ͯͳ͍
System.out.println(os);
for (OrderDetail od : os.getOrderDetailList()) {
// ͜͜Ͱorder_detail΁ͷSELECT͕ൃߦ͞ΕΔ(Nճ)
System.out.println(od);
}
}
59
(C) CASAREAL, Inc. All rights reserved.

60.

[beta]

୯ͳΔ+0*/͸ҙຯ͕ͳ͍
// order_summary΁ͷSELECT͕ൃߦ͞ΕΔʢ1ճʣ
List<OrderSummary> list = em.createQuery(
"SELECT os FROM OrderSummary os" +
" JOIN os.orderDetailList", OrderSummary.class)
.getResultList();
for (OrderSummary os : list) {
// ·ͩorder_detail͸ಡΈࠐ·Ε͍ͯͳ͍
System.out.println(os);
for (OrderDetail od : os.getOrderDetailList()) {
// ͜͜Ͱorder_detail΁ͷSELECT͕ൃߦ͞ΕΔ(Nճ)
System.out.println(od);
}
}
(C) CASAREAL, Inc. All rights reserved.

60

61.

୯ͳΔ+0*/͸ҙຯ͕ͳ͍ select ordersumma0_.id as id1_3_, ordersumma0_.customer_id as customer3_3_, ordersumma0_.order_timestamp as order_ti2_3_ from order_summary ordersumma0_ inner join order_detail orderdetai1_ on ordersumma0_.id=orderdetai1_.summary_id where ordersumma0_.id=? JOINͯ͠Δ͚Ͳ order_summaryͷྻ ͔͠औಘͯ͠ͳ͍ 61 (C) CASAREAL, Inc. All rights reserved.

62.

[beta]

+0*/'&5$)จͰղܾʂʁ
▸ -";:ʹͳ͍ͬͯΔϦϨʔγϣϯΛಈతʹ&"(&3
ʹมߋͯ͘͠ΕΔ
// order_summary΁ͷSELECT͕ൃߦ͞ΕΔʢ1ճʣ
List<OrderSummary> list = em.createQuery(
"SELECT os FROM OrderSummary os" +
" JOIN FETCH os.orderDetailList" +
, OrderSummary.class)
.getResultList();

62
(C) CASAREAL, Inc. All rights reserved.

63.

+0*/'&5$)จͰղܾʂʁ select ordersumma0_.id as id1_3_0_, orderdetai1_.id as id1_2_1_, ordersumma0_.customer_id as customer3_3_0_, ordersumma0_.order_timestamp as order_ti2_3_0_, orderdetai1_.amount as amount2_2_1_, orderdetai1_.product_id as product_3_2_1_, orderdetai1_.summary_id as summary_4_2_0__, orderdetai1_.id as id1_2_0__ from order_summary ordersumma0_ inner join order_detail orderdetai1_ on ordersumma0_.id=orderdetai1_.summary_id where ordersumma0_.id=? JOINͯ͠ શྻऔಘ 63 (C) CASAREAL, Inc. All rights reserved.

64.

දࣔ͢Δͱɾɾɾ OrderSummary{id=1, orderTimestamp=2017-04-01T10:00} OrderDetail{id=1, amount=2} OrderDetail{id=2, amount=2} OrderDetail{id=3, amount=2} OrderSummary{id=1, orderTimestamp=2017-04-01T10:00} OrderDetail{id=1, amount=2} OrderDetail{id=2, amount=2} OrderDetail{id=3, amount=2} OrderSummary{id=1, orderTimestamp=2017-04-01T10:00} OrderDetail{id=1, amount=2} OrderDetail{id=2, amount=2} OrderDetail{id=3, amount=2} OrderSummary{id=2, orderTimestamp=2017-04-01T10:00} OrderDetail{id=4, amount=2} OrderDetail{id=5, amount=2} ɾɾɾ ಉ͡σʔλ͕ Կճ΋ʂʁ 64 (C) CASAREAL, Inc. All rights reserved.

65.

[beta]

+0*/'&5$) %*45*/$5Ͱղܾʂ
// order_summary΁ͷSELECT͕ൃߦ͞ΕΔʢ1ճʣ
List<OrderSummary> list = em.createQuery(
"SELECT DISTINCT os FROM OrderSummary os" +
" JOIN FETCH os.orderDetailList" +
, OrderSummary.class)
.getResultList();

65
(C) CASAREAL, Inc. All rights reserved.

66.

+0*/'&5$) %*45*/$5Ͱղܾʂ select distinct ordersumma0_.id as id1_3_0_, distinct͕෇͕͘ orderdetai1_.id as id1_2_1_, ordersumma0_.customer_id as customer3_3_0_, SQLͷ݁Ռ͸ ordersumma0_.order_timestamp as order_ti2_3_0_, orderdetai1_.amount as amount2_2_1_, ͜ͷ৔߹͸ಉ͡ orderdetai1_.product_id as product_3_2_1_, orderdetai1_.summary_id as summary_4_2_0__, orderdetai1_.id as id1_2_0__ from order_summary ordersumma0_ inner join order_detail orderdetai1_ on ordersumma0_.id=orderdetai1_.summary_id where ordersumma0_.id=? 66 (C) CASAREAL, Inc. All rights reserved.

67.

දࣔ͢Δͱɾɾɾ OrderSummary{id=1, orderTimestamp=2017-04-01T10:00} OrderDetail{id=3, amount=2} OrderDetail{id=1, amount=2} OrderDetail{id=2, amount=2} OrderSummary{id=2, orderTimestamp=2017-04-01T10:00} OrderDetail{id=5, amount=2} OrderDetail{id=6, amount=2} OrderDetail{id=4, amount=2} OrderSummary{id=9, orderTimestamp=2017-04-01T10:00} OrderSummary{id=7, orderTimestamp=2017-04-01T10:00} OrderSummary{id=6, orderTimestamp=2017-04-01T10:00} OrderSummary{id=5, orderTimestamp=2017-04-01T10:00} OrderSummary{id=4, orderTimestamp=2017-04-01T10:00} OrderSummary{id=3, orderTimestamp=2017-04-01T10:00} OrderSummary{id=8, orderTimestamp=2017-04-01T10:00} OrderSummary{id=10, orderTimestamp=2017-04-01T10:00} σʔλͷॏෳ͕ ແ͘ͳͬͨʂ 67 (C) CASAREAL, Inc. All rights reserved.

68.

69.

ωετͨ͠+0*/'&5$) ▸ )JCFSOBUFͰͷΈΤΠϦΞεΛ෇͚Δ͜ͱ͕ग़དྷ Δ // order_summaryɺorder_detailɺproduct͕JOIN͞ΕΔ OrderSummary orderSummary = em.createQuery( "SELECT os FROM OrderSummary os" + " JOIN FETCH os.orderDetailList od" + ΤΠϦΞε " JOIN FETCH od.product p" + " WHERE os.id = :id", OrderSummary.class) .setParameter("id", 1) .getSingleResult(); 69 (C) CASAREAL, Inc. All rights reserved.

70.

ωετͨ͠+0*/'&5$) select ordersumma0_.id as id1_3_0_, orderdetai1_.id as id1_2_1_, product2_.id as id1_4_2_, ordersumma0_.customer_id as customer3_3_0_, ordersumma0_.order_timestamp as order_ti2_3_0_, orderdetai1_.amount as amount2_2_1_, orderdetai1_.product_id as product_3_2_1_, orderdetai1_.summary_id as summary_4_2_0__, orderdetai1_.id as id1_2_0__, product2_.category_id as category4_4_2_, product2_.name as name2_4_2_, product2_.price as price3_4_2_, product2_.vendor_id as vendor_i5_4_2_ from order_summary ordersumma0_ inner join order_detail orderdetai1_ on ordersumma0_.id=orderdetai1_.summary_id inner join product product2_ on orderdetai1_.product_id=product2_.id where ordersumma0_.id=? 3ͭͷදΛ JOINͯ͠ શྻऔಘ 70 (C) CASAREAL, Inc. All rights reserved.

71.

[beta]

·ͱΊ
▸ 'FUDI5ZQF͸-";:Λࢦఆ͠Α͏ʂ
▸ +0*/'&5$)จ %*45*/$5۟Ͱ/ ໰୊Λղ
ܾͰ͖Δʂ
▸ ωετͨ͠+0*/'&5$)͸)JCFSOBUFͷΈʂ

71
(C) CASAREAL, Inc. All rights reserved.

72.

<খ‫>ࢭٳ‬ઈࢍɺࣾһืूதʂ ▸ ޷͖ͳٕज़Λੈʹ޿Ί͍ͨ ਓʂ ▸ 4QSJOHɺJ04‫ืٸ‬ ▸ ։ൃҎ֎ͷखஈͰ ٕज़ʹؔΘΓ͍ͨਓʂ ▸ ຖ೔ఆ࣌Ͱ‫ؼ‬Γ͍ͨਓʂ https://www.casareal.co.jp/recruit/jobs/ ls_teacher.php ▸ ϗϫΠτ‫͢Ͱۀا‬ 72 (C) CASAREAL, Inc. All rights reserved.

https://www.casareal.co.jp/recruit/jobs/ls_teacher.php

73.

https://www.casareal.co.jp/ls/service/shinjinseminar/course01

74.

ᶃ +1"4QSJOH%BUB+1"ͱ͸ʁ ᶄ +1"ΤϯςΟςΟͷঢ়ଶ؅ཧ ᶅ +BWB1FSTJTUFODF2VFSZ-BOHVBHF +12- ᶆ ϦϨʔγϣϯͱ/ ໰୊ରࡦ ᶇ %#੡඼‫ݻ‬༗‫ػ‬ೳͷར༻ ᶈ 4QSJOH%BUB+1"ͷར༻ ᶉ 4QSJOH#PPUར༻࣌ͷ஫ҙ఺ ᶊ +1"͸ʮ࢖͑Δʯͷ͔ʁ 74 (C) CASAREAL, Inc. All rights reserved.

75.

76.

ωΠςΟϒ42▸ Ϛοϐϯάઌ͸ඞͣΤϯςΟςΟΫϥε ▸ ‫ج‬ຊతʹશྻͷ4&-&$5͕ඞཁ ▸ δΣωϦΫε͕࢖͑ͳ͍ Query query = em.createNativeQuery( "select id, name, price, vendor_id" + " from product where id = :id", Product.class); query.setParameter("id", 1); Product product = (Product) query.getSingleResult(); 76 (C) CASAREAL, Inc. All rights reserved.

77.

[beta]

ΤϯςΟςΟʹϚοϐϯά͠ͳ͍ํ๏
▸ ໭Γ஋Λ0CKFDU<>ʹ͢Δ
Query query = em.createNativeQuery(
"select id, name from product where id = :id");
query.setParameter("id", 1);
// 0൪໨͕idɺ1൪໨͕name
Object[] objs = (Object[]) query.getSingleResult();
Integer productId = (Integer) objs[0];
String productName = (String) objs[1];

Ωϟετ͕ඞཁ
77
(C) CASAREAL, Inc. All rights reserved.

78.

79.

!4RM3FTVMU4FU.BQQJOH @Entity @SqlResultSetMapping( name = "product_id_name", // ‫ͼݺͰޙ‬ग़࣌͢ͷ໊લ classes = { @ConstructorResult(targetClass = ProductDto.class, columns = { @ColumnResult(name = "id"), @ColumnResult(name = "name") } ΤϯςΟςΟΫϥεʹ ) } ෇Ճ͢Δ͜ͱʹ஫ҙ ) public class Product { … } ※@SqlResultSetMappingsΛར༻͢Ε͹ɺෳ਺ͷ@SqlResultSetMappingΛࢦఆՄೳ (C) CASAREAL, Inc. All rights reserved. 79

80.

[beta]

!4RM3FTVMU4FU.BQQJOH
public class ProductDto {
ΤϯςΟςΟͰͳ͍
private Integer id;
private String name;
೚ҙͷΫϥε
public ProductDto(Integer id, String name) { … }
}
Query query = em.createNativeQuery(
"select id, name from product where id = :id",
"product_id_name"); // @SqlResultSetMappingͷnameଐੑ
query.setParameter("id", 1);
ProductDto productDto =
(ProductDto) query.getSingleResult();

80
(C) CASAREAL, Inc. All rights reserved.

81.

[beta]

+12-͔Βͷ%#‫ݻ‬༗ؔ਺‫ͼݺ‬ग़͠
▸ '6/$5*0/ ؔ਺໊ Ҿ਺ Ҿ਺ ʜ
// H2 DatabaseͷLEFTؔ਺Λར༻
TypedQuery<Product> query = em.createQuery(
"SELECT p FROM Product p"
+ " WHERE FUNCTION('LEFT', p.name, 2) = 'ύϚ'",
Product.class);
List<Product> productList = query.getResultList();

81
(C) CASAREAL, Inc. All rights reserved.

82.

ετΞυϓϩγʔδϟ ▸ DSFBUF4UPSFE1SPDFEVSF2VFSZ StoredProcedureQuery query = em.createStoredProcedureQuery("ϓϩγʔδϟ໊", ΤϯςΟςΟ.class); query.setParameter("ύϥϝʔλ໊", ύϥϝʔλ஋); List<ΤϯςΟςΟ> list = (List<ΤϯςΟςΟ>) query.getResultList(); ※ετΞυϓϩγʔδϟʹৄ͘͠ͳ͍ͨΊචऀ͸ະ‫͢Ͱূݕ‬ɻͥͻࢼͯ͠ϑΟʔυόοΫ͍ͩ͘͞ʂ 82 (C) CASAREAL, Inc. All rights reserved.

83.

84.

85.

86.

ᶃ +1"4QSJOH%BUB+1"ͱ͸ʁ ᶄ +1"ΤϯςΟςΟͷঢ়ଶ؅ཧ ᶅ +BWB1FSTJTUFODF2VFSZ-BOHVBHF +12- ᶆ ϦϨʔγϣϯͱ/ ໰୊ରࡦ ᶇ %#੡඼‫ݻ‬༗‫ػ‬ೳͷར༻ ᶈ 4QSJOH%BUB+1"ͷར༻ ᶉ 4QSJOH#PPUར༻࣌ͷ஫ҙ఺ ᶊ +1"͸ʮ࢖͑Δʯͷ͔ʁ 86 (C) CASAREAL, Inc. All rights reserved.

87.

4QSJOH%BUB+1"ͷԼ४උ ▸ -PDBM$POUBJOFS&OUJUZ.BOBHFS'BDUPSZ#FBO Λ#FBOఆٛ ▸ &OUJUZ.BOBHFS'BDUPSZ͕ࣗಈͰ#FBOͱͳΔ ▸ 4QSJOH#PPUͰ͸ఆٛࡁΈ ▸ ৄࡉ͸੿ஶʮ4QSJOHGPS4QSJOH#PPUʯ΁ ▸ IUUQTTQFBLFSEFDLDPNNBTBUPTIJUBEBTQSJOHGPS TQSJOHCPPUOVNCFSKTVH 87 (C) CASAREAL, Inc. All rights reserved.

https://speakerdeck.com/masatoshitada/spring-for-spring-boot-number-jsug#57

88.

89.

3FQPTJUPSZΠϯλϑΣʔε ▸ +QB3FQPTJUPSZΛ‫ܧ‬ঝͨ͠ΠϯλϑΣʔεΛ࡞ Δ͚ͩͰɺ‫ج‬ຊతͳ$36%ॲཧ͸࡞੒‫ྃ׬‬ public interface ProductRepository extends JpaRepository<Product, Integer> { // த͸ۭͰOK } ※@RepositoryΞϊςʔγϣϯ͸ඞཁ͋Γ·ͤΜ 89 (C) CASAREAL, Inc. All rights reserved.

90.

+QB3FQPTJUPSZͷओͳϝιου ▸ HFU0OF JE pOE#Z*E JE pOE"MM pOE"MM TPSU pOE"MM JET pOE"MM QBHFBCMF ▸ TBWF FOUJUZ ˞௥Ճ΋ߋ৽΋Մೳ ▸ EFMFUF#Z*E JE EFMFUF FOUJUZ ▸ DPVOU FYJTUT#Z*E JE 4QSJOH%BUBͰϝιου໊͕ େ෯ʹมߋ͞ΕͨͷͰ஫ҙʂ 90 (C) CASAREAL, Inc. All rights reserved.

91.

3FQPTJUPSZΠϯλϑΣʔεͷར༻ @Service public class ProductService { private final ProductRepository repo; @Autowired // ϓϩΩγ͕࡞ΒΕͯDI͞ΕΔ public ProductService(ProductRepository repo) { this.repo = repo; } } @Transactional public void insert(Product product) { repo.save(product); } ※@AutowiredΞϊςʔγϣϯ͸Spring 4.3Ҏ߱Ͱ͸লུՄೳ ʢίϯετϥΫλ͕1͚ͭͩͷ৔߹ͷΈʣ (C) CASAREAL, Inc. All rights reserved. 91

92.

[beta]

!2VFSZ
▸ 3FQPTJUPSZΠϯλϑΣʔεʹɺ೚ҙͷ+12-Λ࣮
ߦ͢ΔϝιουΛ௥ՃͰ͖Δ
▸ OBUJWF2VFSZUSVFͱ͢Ε͹ωΠςΟϒ42-΋ॻ͚Δ
public interface ProductRepository
extends JpaRepository<Product, Integer> {
@Query("SELECT p FROM Product p JOIN FETCH p.vendor"
+ " WHERE p.id = :id")
Product findByIdJoinFetch(@Param("id") Integer id);
}
92
(C) CASAREAL, Inc. All rights reserved.

93.

[beta]

!.PEJGZJOH
▸ !2VFSZͰ61%"5&จ΍%&-&5&จΛࢦఆͨ͠
৔߹͸ඞཁ
public interface ProductRepository
extends JpaRepository<Product, Integer> {
@Modifying
@Query("UPDATE Product p SET p.name = :name"
+ " WHERE p.id = :id")
void updateName(@Param("name") String name,
@Param("id") Integer id);
}
93
(C) CASAREAL, Inc. All rights reserved.

94.

[beta]

!-PDL
▸ -PDL.PEF5ZQFΛࢦఆָͯ͠‫؍‬తϩοΫɾ൵‫؍‬
తϩοΫΛࢦఆՄೳ
public interface ProductRepository
extends JpaRepository<Product, Integer> {
@Lock(LockModeType.PESSIMISTIC_READ)
@Query("SELECT p FROM Product p JOIN FETCH p.vendor"
+ " WHERE p.id = :id")
Product findByIdJoinFetch(@Param("id") Integer id);
}
※ϩοΫͷৄࡉ͸Լ‫ࢀه‬র
https://www.slideshare.net/masatoshitada7/jpa20140518-ccc-r15-jjug-ccc
(C) CASAREAL, Inc. All rights reserved.

94

https://www.slideshare.net/masatoshitada7/jpa20140518-ccc-r15-jjug-ccc

95.

[beta]

!&OUJUZ(SBQI
▸ &OUJUZ(SBQIΛར༻ͨ͠ಈతͳϑΣονͷมߋ
͕Մೳ
public interface ProductRepository
extends JpaRepository<Product, Integer> {
@EntityGraph("άϥϑ໊")
@Query("SELECT p FROM Product p JOIN FETCH p.vendor"
+ " WHERE p.id = :id")
Product findByIdJoinFetch(@Param("id") Integer id);
}
※ΤϯςΟςΟάϥϑͷৄࡉ͸Լ‫ࢀه‬র
https://blog.ik.am/entries/350

95
(C) CASAREAL, Inc. All rights reserved.

https://blog.ik.am/entries/350

96.

[beta]

ϝιου໊͔Βͷ+12-ࣗಈੜ੒
▸ ϧʔϧʹैͬͯϝιου໊Λ‫ه‬ड़͢Ε͹ɺ
!2VFSZͰ+12-Λ‫ه‬ड़͢Δඞཁͳ͠
public interface ProductRepository
extends JpaRepository<Product, Integer> {
// nameʹҾ਺ͷจࣈྻ͕‫·ؚ‬Ε͍ͯΔ΋ͷΛ‫͢ࡧݕ‬Δ
List<Product> findByNameContaining(String keyword);
}

96
(C) CASAREAL, Inc. All rights reserved.

97.

ϝιου໊͔Βͷ+12-ࣗಈੜ੒ select product0_.id as id1_4_, product0_.category_id as category4_4_, product0_.name as name2_4_, product0_.price as price3_4_, product0_.vendor_id as vendor_i5_4_ from product product0_ where product0_.name like ? binding parameter [1] as [VARCHAR] - [%ύϚ%] 97 (C) CASAREAL, Inc. All rights reserved.

98.

ϝιου໊ʹ࢖͑ΔΩʔϫʔυʢҰ෦ʣ ▸ "OE 0S #FUXFFO -FTT5IBO -FTT5IBO&RVBM -JLF /PU-JLF 4UBSUJOH8JUI &OEJOH8JUI $POUBJOJOH 0SEFS#Z ʜ ▸ ৄࡉ͸ϦϑΝϨϯεࢀর ▸ IUUQTEPDTTQSJOHJPTQSJOHEBUBKQBEPDT DVSSFOUSFGFSFODFIUNMKQBRVFSZ NFUIPETRVFSZDSFBUJPO 98 (C) CASAREAL, Inc. All rights reserved.

https://docs.spring.io/spring-data/jpa/docs/current/reference/html/#jpa.query-methods.query-creation

99.

‫ڞ‬௨ඇνΣοΫྫ֎΁ͷม‫׵‬ ▸ +1"Ͱൃੜͨ͠ྫ֎͸%BUB"DDFTT&YDFQUJPO ͷαϒΫϥεʹม‫͞׵‬ΕΔ ▸ ͲΜͳσʔλΞΫηεٕज़Λ࢖͍ͬͯΔ͔Λ্Ґ૚ʹ ҙࣝͤ͞ͳ͍ %BUB"DDFTT&YDFQUJPO %BUB*OUFHSJUZ7JPMBUJPO &YDFQUJPO #BE4RM(SBNNBS &YDFQUJPO ɾɾɾ 99 (C) CASAREAL, Inc. All rights reserved.

100.

‫ࠪ؂‬ରԠ ▸ ࡞੒ऀɺ࡞੒೔࣌ɺߋ৽ऀɺߋ৽೔࣌Λࣗಈత ʹ%#ʹอଘͰ͖Δ @Entity public class Hoge { @CreatedBy String createdUser; @CreatedDate LocalDateTime createdDate; @LastModifiedBy String modifiedUser; @LastModifiedDate LocalDateTime lastModifiedDate; } 100 (C) CASAREAL, Inc. All rights reserved.

101.

[beta]

‫ࠪ؂‬ରԠʹඞཁͳઃఆ
Spring Security͔Β
@Component
Ϣʔβʔ໊Λऔಘͯ͠΋OK
public class MyAuditorAware
implements AuditorAware<String> {
@Override
public Optional<String> getCurrentAuditor() {
return Optional.of("user01");}
}
@SpringBootApplication
@EnableJpaAuditing(auditorAwareRef = "myAuditorAware")
public class SpringDataJpaDaitokaiApplication { … }
101
(C) CASAREAL, Inc. All rights reserved.

102.

[beta]

‫ࠪ؂‬ରԠʹඞཁͳઃఆʢ͖ͭͮʣ
▸ TSDNBJOSFTPVSDFT.&5"*/'PSNYNMʹԼ‫ه‬Λ‫ه‬ड़
▸ ύεͱϑΝΠϧ໊Λ͜Εʹ͢ΔͱɺࣗಈͰಡΈࠐ·ΕΔ
<entity-mappings>
<persistence-unit-metadata>
<persistence-unit-defaults>
<entity-listeners>
<entity-listener
class="org.springframework.data.jpa.domain.support.AuditingEntityListene
r" />
</entity-listeners>
</persistence-unit-defaults>
</persistence-unit-metadata>
</entity-mappings>
102
(C) CASAREAL, Inc. All rights reserved.

103.

%BUFBOE5JNF"1* +43 ରԠ ▸ +TS+QB$POWFSUFSTΫϥε ▸ -PDBM%BUFΫϥεͳͲͷ"UUSJCVUF$POWFSUFS͕͋Β͔ ͡Ίఏ‫͞ڙ‬Ε͍ͯΔ ▸ TFU1BDLBHF5P4DBO ͳͲͰ PSHTQSJOHGSBNFXPSLEBUBKQBDPOWFSUUISFFUFOύ οέʔδΛࢦఆ͢Ε͹0, ▸ 4QSJOH#PPUͰ͸"VUP$POpHVSBUJPOର৅ʹͳ͍ͬͯΔ 103 (C) CASAREAL, Inc. All rights reserved.

104.

105.

106.

ᶃ +1"4QSJOH%BUB+1"ͱ͸ʁ ᶄ +1"ΤϯςΟςΟͷঢ়ଶ؅ཧ ᶅ +BWB1FSTJTUFODF2VFSZ-BOHVBHF +12- ᶆ ϦϨʔγϣϯͱ/ ໰୊ରࡦ ᶇ %#੡඼‫ݻ‬༗‫ػ‬ೳͷར༻ ᶈ 4QSJOH%BUB+1"ͷར༻ ᶉ 4QSJOH#PPUར༻࣌ͷ஫ҙ఺ ᶊ +1"͸ʮ࢖͑Δʯͷ͔ʁ 106 (C) CASAREAL, Inc. All rights reserved.

107.

0QFO*O7JFX͕σϑΥϧτ ▸ &OUJUZ.BOBHFSͷϥΠϑαΠΫϧ͕Ϗϡʔ·Ͱͱ ͳ͍ͬͯΔʢʹϏϡʔͰͷ-B[ZϑΣονՄೳʣ 4QSJOH#PPUͷσϑΥϧτ ௨ৗͷ4QSJOH 7JFX $POUSPMMFS 4FSWJDF 3FQPTJUPSZ http://docs.spring.io/spring-boot/docs/1.5.4.RELEASE/reference/htmlsingle/#boot-features-jpa-inweb-environment (C) CASAREAL, Inc. All rights reserved. 107

http://docs.spring.io/spring-boot/docs/1.5.4.RELEASE/reference/htmlsingle/#boot-features-jpa-in-web-environment

108.

109.

[beta]

/BNJOH4USBUFHZ
▸ 4QSJOH1IZTJDBM/BNJOH4USBUFHZ͕σϑΥϧ
τͰద༻ࡁΈ
▸ Ωϟϝϧέʔε㲗εωʔΫέʔεͷ૬‫ޓ‬ม‫׵‬͸ࣗಈͰ
ߦΘΕΔ
@Entity public class Hoge {
// Spring BootͰ͸@Columnෆཁ
@Column(name=“foo_bar”) String fooBar;
}
http://docs.spring.io/spring-boot/docs/1.5.4.RELEASE/reference/htmlsingle/#howto-configurehibernate-naming-strategy
(C) CASAREAL, Inc. All rights reserved.

109

http://docs.spring.io/spring-boot/docs/1.5.4.RELEASE/reference/htmlsingle/#howto-configure-hibernate-naming-strategy

110.

/BNJOH4USBUFHZͷมߋํ๏ ▸ BQQMJDBUJPOQSPQFSUJFTʹԼ‫ه‬ͷ‫ه‬ड़Λ௥Ճ spring.jpa.hibernate.naming.physical-strategy=StrategyΫϥεͷFQCN spring.jpa.hibernate.naming.implicit-strategy=StrategyΫϥεͷFQCN 110 (C) CASAREAL, Inc. All rights reserved.

111.

[beta]

!&OUJUZ4DBO
▸ ΤϯςΟςΟΫϥεͷύοέʔδ΍ɺ$POWFSUFS
ΫϥεͷύοέʔδΛࢦఆ
▸ +BWB$POpHΫϥεʹ෇Ճ͢Δ
@SpringBootApplication
@EntityScan(basePackages = {
"com.example.demo.persistence.entity",
"org.springframework.data.jpa.convert.threeten"})
public class SpringDataJpaDaitokaiApplication { … }
http://docs.spring.io/spring-boot/docs/1.5.4.RELEASE/reference/htmlsingle/#howto-separate-entitydefinitions-from-spring-configuration
(C) CASAREAL, Inc. All rights reserved.

111

http://docs.spring.io/spring-boot/docs/1.5.4.RELEASE/reference/htmlsingle/#howto-separate-entity-definitions-from-spring-configuration

112.

ᶃ +1"4QSJOH%BUB+1"ͱ͸ʁ ᶄ +1"ΤϯςΟςΟͷঢ়ଶ؅ཧ ᶅ +BWB1FSTJTUFODF2VFSZ-BOHVBHF +12- ᶆ ϦϨʔγϣϯͱ/ ໰୊ରࡦ ᶇ %#੡඼‫ݻ‬༗‫ػ‬ೳͷར༻ ᶈ 4QSJOH%BUB+1"ͷར༻ ᶉ 4QSJOH#PPUར༻࣌ͷ஫ҙ఺ ᶊ +1"͸ʮ࢖͑Δʯͷ͔ʁ 112 (C) CASAREAL, Inc. All rights reserved.

113.

114.

115.

116.

ඞಡࢿྉ ▸ ͸·Δʂ+1"ʢॳֶऀ޲͚ϥΠτ൛ʣ !TVLF@NBTB ▸ IUUQTXXXTMJEFTIBSFOFUNBTBUPTIJUBEBKQB ▸ ͸·Δʂ+1" !NBLJOH͞Μ ▸ IUUQTXXXTMJEFTIBSFOFUNBLJOHYKQB ▸ +1"ͷಉ࣮࣌ߦ੍‫ͱޚ‬ϩοΫ !TVLF@NBTB ▸ IUUQTXXXTMJEFTIBSFOFUNBTBUPTIJUBEBKQBDDDSKKVH DDD ▸ !PQFOHM@͞Μͷ2JJUB‫ࣄه‬Ұ࿈ ▸ IUUQRJJUBDPNPQFOHMJUFNTGGBFDC 116 (C) CASAREAL, Inc. All rights reserved.

117.

ϦϑΝϨϯε ▸ 5FSBTPMVOB։ൃΨΠυϥΠϯ ▸ IUUQUFSBTPMVOBPSHHJUIVCJPHVJEFMJOF3&-&"4&KB "SDIJUFDUVSF*O%FUBJM%BUB"DDFTT%FUBJM%BUB"DDFTT+QBIUNM ▸ 4QSJOH%BUB+1" ▸ IUUQTEPDTTQSJOHJPTQSJOHEBUBKQBEPDTDVSSFOUSFGFSFODFIUNM ▸ )JCFSOBUF6TFS(VJEF ▸ IUUQEPDTKCPTTPSHIJCFSOBUFPSNVTFSHVJEFIUNM@TJOHMF )JCFSOBUF@6TFS@(VJEFIUNM ▸ +1" +43 ▸ IUUQTKDQPSHBCPVU+BWBDPNNVOJUZQSPDFTTpOBMKTSJOEFYIUNM 117 (C) CASAREAL, Inc. All rights reserved.

118.

Spring Data JPAによるデータアクセス徹底入門 #jsug

tada

関連スライド

最新の6.0で学ぶ！初めてのひとのためのSpring Security

詳解Springトランザクション -初級から上級まで- #jsug

Java ORマッパー選定のポイント #jsug

プロになるためのSpring上級知識 #jsug

今こそ知りたいSpring DI x AOP #jsug

基礎からのOAuth 2.0とSpring Security 5.1による実装 #jsug

各ページのテキスト