50分で分かるSpring Data JPA/spring-data-jpa-in-50min

by Masatoshi Tada

Slide 1

Slide 1 text

Slide 2

Slide 2 text

Slide 3

Slide 3 text

Slide 4

Slide 4 text

Slide 5

Slide 5 text

Slide 6

Slide 6 text

Slide 7

Slide 7 text

Slide 8

Slide 8 text

Slide 9

Slide 9 text

Slide 10

Slide 10 text

Slide 11

Slide 11 text

Slide 12

Slide 12 text

Slide 13

Slide 13 text

Slide 14

Slide 14 text

Slide 15

Slide 15 text

Slide 16

Slide 16 text

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

Slide 17

Slide 17 text

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

Slide 18

Slide 18 text

Slide 19

Slide 19 text

Slide 20

Slide 20 text

Slide 21

Slide 21 text

Slide 22

Slide 22 text

Slide 23

Slide 23 text

Slide 24

Slide 24 text

Slide 25

Slide 25 text

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

Slide 26

Slide 26 text

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

Slide 27

Slide 27 text

(C) CASAREAL, Inc. All rights reserved. ओΩʔݕࡧ 27 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=? ͜ΜͳSQL͕  ൃߦ͞ΕΔ

Slide 28

Slide 28 text

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

Slide 29

Slide 29 text

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

Slide 30

Slide 30 text

(C) CASAREAL, Inc. All rights reserved. ߋ৽ 30 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]

Slide 31

Slide 31 text

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

Slide 32

Slide 32 text

(C) CASAREAL, Inc. All rights reserved. NFSHF ʹΑΔߋ৽ 32 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] ▸ 4&-&$5จʴ61%"5&จ͕ൃߦ͞ΕΔ

Slide 33

Slide 33 text

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

Slide 34

Slide 34 text

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

Slide 35

Slide 35 text

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

Slide 36

Slide 36 text

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

Slide 37

Slide 37 text

Slide 38

Slide 38 text

Slide 39

Slide 39 text

Slide 40

Slide 40 text

(C) CASAREAL, Inc. All rights reserved. جຊతͳ࢖͍ํ 40 TypedQuery query = em.createQuery( "SELECT p FROM Product p WHERE p.id = :id", Product.class); query.setParameter("id", 1); Product product = query.getSingleResult(); TypedQuery query = em.createQuery( "SELECT p FROM Product p WHERE p.id <= :maxId" + " ORDER BY p.id", Product.class); query.setParameter("maxId", 5); List list = query.getResultList(); ▸ ୯Ұݕࡧ ▸ ෳ਺ݕࡧ

Slide 41

Slide 41 text

(C) CASAREAL, Inc. All rights reserved. ࣮ߦ͢Δͱ42-ʹ຋༁͞ΕΔ 41 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=? ▸ ͲΜͳ42-͕ൃߦ͞ΕΔ͔͸+1"࢓༷Ͱະఆٛ  ʹ׬શʹ࣮૷ґଘʢԼه͸)JCFSOBUFͷྫʣ

Slide 42

Slide 42 text

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

Slide 43

Slide 43 text

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

Slide 44

Slide 44 text

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

Slide 45

Slide 45 text

(C) CASAREAL, Inc. All rights reserved. ͦͷଞͷ+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ʣ ▸ %#ݻ༗ؔ਺ͷݺͼग़͠ʢޙड़ʣ 45

Slide 46

Slide 46 text

Slide 47

Slide 47 text

Slide 48

Slide 48 text

Slide 49

Slide 49 text

(C) CASAREAL, Inc. All rights reserved. ϦϨʔγϣϯΛදݱ͢Δ ▸ !0OF5P0OF ▸ !0OF5P.BOZ ▸ !.BOZ5P0OF ▸ !.BOZ5P.BOZ 49 @Entity public class Product { … @ManyToOne @JoinColumn(name="vendor_id") private Vendor vendor; } @Entity public class Vendor { … }

Slide 50

Slide 50 text

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

Slide 51

Slide 51 text

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

Slide 52

Slide 52 text

(C) CASAREAL, Inc. All rights reserved. -";:ϑΣονͷྫ 52 select (ྻলུ) from product product0_ where product0_.id=? select (ྻলུ) from vendor vendor0_ where vendor0_.id=? @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

Slide 53

Slide 53 text

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

Slide 54

Slide 54 text

(C) CASAREAL, Inc. All rights reserved. &"(&3ϑΣονͷྫ 54 @Entity public class Product { @ManyToOne(fetch = FetchType.EAGER) private Vendor vendor; } 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=? 1ճͷΈ SELECT

Slide 55

Slide 55 text

Slide 56

Slide 56 text

(C) CASAREAL, Inc. All rights reserved. /໰୊͕ى͜Δྫ 56 // order_summary΁ͷSELECT͕ൃߦ͞ΕΔʢ1ճʣ List 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); } }

Slide 57

Slide 57 text

(C) CASAREAL, Inc. All rights reserved. ୯ͳΔ+0*/͸ҙຯ͕ͳ͍ 57 // order_summary΁ͷSELECT͕ൃߦ͞ΕΔʢ1ճʣ List 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); } }

Slide 58

Slide 58 text

(C) CASAREAL, Inc. All rights reserved. ୯ͳΔ+0*/͸ҙຯ͕ͳ͍ 58 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ͷྻ  ͔͠औಘͯ͠ͳ͍

Slide 59

Slide 59 text

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

Slide 60

Slide 60 text

(C) CASAREAL, Inc. All rights reserved. +0*/'&5$)จͰղܾʂʁ 60 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ͯ͠  શྻऔಘ

Slide 61

Slide 61 text

(C) CASAREAL, Inc. All rights reserved. දࣔ͢Δͱɾɾɾ 61 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} ɾɾɾ ಉ͡σʔλ͕  Կճ΋ʂʁ

Slide 62

Slide 62 text

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

Slide 63

Slide 63 text

(C) CASAREAL, Inc. All rights reserved. +0*/'&5$)%*45*/$5Ͱղܾʂ 63 select distinct 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=? distinct͕෇͕͘  SQLͷ݁Ռ͸  ͜ͷ৔߹͸ಉ͡

Slide 64

Slide 64 text

(C) CASAREAL, Inc. All rights reserved. දࣔ͢Δͱɾɾɾ 64 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} σʔλͷॏෳ͕  ແ͘ͳͬͨʂ

Slide 65

Slide 65 text

Slide 66

Slide 66 text

(C) CASAREAL, Inc. All rights reserved. // 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(); ωετͨ͠+0*/'&5$) ▸ )JCFSOBUFͰͷΈΤΠϦΞεΛ෇͚Δ͜ͱ͕ग़དྷ Δ 66 ΤΠϦΞε

Slide 67

Slide 67 text

(C) CASAREAL, Inc. All rights reserved. ωετͨ͠+0*/'&5$) 67 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ͯ͠  શྻऔಘ

Slide 68

Slide 68 text

Slide 69

Slide 69 text

Slide 70

Slide 70 text

Slide 71

Slide 71 text

(C) CASAREAL, Inc. All rights reserved. ωΠςΟϒ42- ▸ Ϛοϐϯάઌ͸ඞͣΤϯςΟςΟΫϥε ▸ جຊతʹશྻͷ4&-&$5͕ඞཁ ▸ δΣωϦΫε͕࢖͑ͳ͍ 71 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();

Slide 72

Slide 72 text

(C) CASAREAL, Inc. All rights reserved. ΤϯςΟςΟʹϚοϐϯά͠ͳ͍ํ๏ ▸ ໭Γ஋Λ0CKFDU<>ʹ͢Δ 72 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]; Ωϟετ͕ඞཁ

Slide 73

Slide 73 text

Slide 74

Slide 74 text

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

Slide 75

Slide 75 text

(C) CASAREAL, Inc. All rights reserved. !4RM3FTVMU4FU.BQQJOH 75 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(); public class ProductDto { private Integer id; private String name; public ProductDto(Integer id, String name) { … } } ΤϯςΟςΟͰͳ͍  ೚ҙͷΫϥε

Slide 76

Slide 76 text

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

Slide 77

Slide 77 text

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

Slide 78

Slide 78 text

Slide 79

Slide 79 text

Slide 80

Slide 80 text

Slide 81

Slide 81 text

Slide 82

Slide 82 text

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

Slide 83

Slide 83 text

Slide 84

Slide 84 text

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

Slide 85

Slide 85 text

Slide 86

Slide 86 text

(C) CASAREAL, Inc. All rights reserved. 3FQPTJUPSZΠϯλϑΣʔεͷར༻ 86 @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͚ͭͩͷ৔߹ͷΈʣ

Slide 87

Slide 87 text

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

Slide 88

Slide 88 text

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

Slide 89

Slide 89 text

(C) CASAREAL, Inc. All rights reserved. !-PDL ▸ -PDL.PEF5ZQFΛࢦఆָͯ͠؍తϩοΫɾ൵؍ తϩοΫΛࢦఆՄೳ 89 public interface ProductRepository extends JpaRepository { @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

Slide 90

Slide 90 text

(C) CASAREAL, Inc. All rights reserved. !&OUJUZ(SBQI ▸ &OUJUZ(SBQIΛར༻ͨ͠ಈతͳϑΣονͷมߋ ͕Մೳ 90 public interface ProductRepository extends JpaRepository { @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

Slide 91

Slide 91 text

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

Slide 92

Slide 92 text

(C) CASAREAL, Inc. All rights reserved. ϝιου໊͔Βͷ+12-ࣗಈੜ੒ 92 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] - [%ύϚ%]

Slide 93

Slide 93 text

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

Slide 94

Slide 94 text

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

Slide 95

Slide 95 text

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

Slide 96

Slide 96 text

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

Slide 97

Slide 97 text

Slide 98

Slide 98 text

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

Slide 99

Slide 99 text

Slide 100

Slide 100 text

Slide 101

Slide 101 text

Slide 102

Slide 102 text

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

Slide 103

Slide 103 text

Slide 104

Slide 104 text

(C) CASAREAL, Inc. All rights reserved. /BNJOH4USBUFHZ ▸ 4QSJOH1IZTJDBM/BNJOH4USBUFHZ͕σϑΥϧ τͰద༻ࡁΈ ▸ Ωϟϝϧέʔε㲗εωʔΫέʔεͷ૬ޓม׵͸ࣗಈͰ ߦΘΕΔ 104 @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-conﬁgure- hibernate-naming-strategy

Slide 105

Slide 105 text

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

Slide 106

Slide 106 text

(C) CASAREAL, Inc. All rights reserved. !&OUJUZ4DBO ▸ ΤϯςΟςΟΫϥεͷύοέʔδ΍ɺ$POWFSUFS ΫϥεͷύοέʔδΛࢦఆ ▸ +BWB$POpHΫϥεʹ෇Ճ͢Δ 106 @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-entity- deﬁnitions-from-spring-conﬁguration

Slide 107

Slide 107 text

Slide 108

Slide 108 text

Slide 109

Slide 109 text

Slide 110

Slide 110 text

Slide 111

Slide 111 text

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

Slide 112

Slide 112 text

(C) CASAREAL, Inc. All rights reserved. ϦϑΝϨϯε ▸ 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 112