Slide 1

Slide 1 text

4QSJOH.Z#BUJTͰ ྫ֎͕ग़ͨͱ͖Ͳ͜ΛݟΔ͔ ؔδϟό`݄౓ ϢΧΠ

Slide 2

Slide 2 text

ϢΧΠ !TZVLBJ &$αΠτ։ൃӡ༻νʔϜͷ&. +BWBΛத৺ʹஔ͖ͭͭ։ൃʹؔ͢ΔͳΜͰ΋΍Δ ʢϑϩϯτΤϯυ͔Β͸ڑ཭Λஔ͍͍ͯΔʣ ࣗݾ঺հ 2

Slide 3

Slide 3 text

ࠓ೔ͷΰʔϧ w .Z#BUJTͷΤϥʔݟͯ΋ύχΫΒͳ͍

Slide 4

Slide 4 text

.Z#BUJTͱ͸ʁ IUUQTNZCBUJTPSHNZCBUJTKBJOEFYIUNM

Slide 5

Slide 5 text

ࡶͳઆ໌ 9.-ϑΝΠϧʹॻ͍ͨ42-Λ࣮ߦͯ͘͠ΕΔπʔϧ 
 ʢͱ͍͏࢖͍ํΛ͢Δ૝ఆͰࠓ೔͸࿩͠·͢ʣ

Slide 6

Slide 6 text

ͱ͍͏ཧղͩͱྫ֎ग़ͨͱ͖ʹʮ42-࣮ߦ͍͚ͨͩ͠ͳͷʹʂʯͱͳΔ ݴ͍׵͑Δͱ ʮ42-Λ࣮ߦ͢ΔͨΊʹඞཁͳz͋Ε͜Εz΋΍ͬͯ͘ΕΔศརͳ΍ͭʯ ˠz͋Ε͜Εz͕ͲΜͳ͜ͱͳͷ͔஌͓ͬͯ͘͜ͱ͕େࣄ ˠ͜ͷล͕ؒҧ͑ͯͨΒ͜Μͳྫ֎͕ग़Δɺ͕Θ͔Δ ɹυΩϡϝϯτ΋ͪΐͬͱಡΈ΍͘͢ͳΔ͸ͣʢͨͿΜɻ͠ΒΜ͚Ͳʣ

Slide 7

Slide 7 text

େ·͔ͳॲཧͷྲྀΕ

Slide 8

Slide 8 text

ʢલఏʣࠓճ૝ఆͷ؀ڥ w +BWB w 4QSJOH#PPU w )%BUBCBTF w (SBEMF ˞؀ڥҎ֎ʹ΋ҧ͏࢖͍ํɾॻ͖ํ΋Ͱ͖·͕͢ɺ 
 ɹҰྫͱͯ͠ࢀߟʹ͍ͯͩ͘͠͞ɻ

Slide 9

Slide 9 text

αϯϓϧ ݺͼग़͠Օॴ demoMapper.get(); %FNP.BQQFSKBWB @Mapper public interface DemoMapper { List get();_ } %FNP.BQQFSYNM SELECT * FROM demo (JU)VCIUUQTHJUIVCDPNTZVLBJNZCBUJTFSSPSMFBSOJOHXJUITQSJOHCPPU

Slide 10

Slide 10 text

΍ͬͯ͘ΕΔ͜ͱ ʢΞϓϦىಈ࣌ʣ9.-Λϩʔυ .BQϑΝΠϧΛ୳͢ ύϥϝλ౉͢ɺ໭Γ஋ͷϚοϐϯά 42-Λ४උ͢Δ QSFQBSF 42-Λ࣮ߦͯ͠%#͔Β݁ՌΛड͚औΔ ΦϒδΣΫτʹ஋Λ୅ೖ ͦΕͧΕͷॲཧͰΤϥʔ͕ൃੜ͠͏Δ ίϯύΠϧΤϥʔʹͳΒͳ͍

Slide 11

Slide 11 text

9.-ϑΝΠϧΛϩʔυ w ىಈ࣌ʹ.Z#BUJT༻ʹ༻ҙͨ͠9.-ϑΝΠϧΛϩʔυ͢Δ w 9.-ΛಡΈࠐΜͰඞཁͳΫϥεͱ͔ϩʔυͯ͠Δʁ

Slide 12

Slide 12 text

ൃੜ͢Δྫ֎ͱz͋Δ͋Δz w PSHBQBDIFJCBUJTCVJMEFS#VJMEFS&YDFQUJPOʢىಈ࣌ʹൃੜʣ w 9.-ͷจ๏͕ؒҧ͑ͯΔ w 3FTVMU.BQͳͲʹࢦఆͨ͠Ϋϥε͕ؒҧ͑ͯΔʢଘࡏ͠ͳ͍ʣ

Slide 13

Slide 13 text

.BQϑΝΠϧΛ୳͢ w .BQQFSΠϯλϑΣʔεʹରԠ͢ΔYNMϑΝΠϧΛ୳͢ w σϑΥϧτͰ͸SFTPVSDFT഑Լͷ.BQQFSͱಉ͡ύε w .BQQFS͕TSDNBJODPNFYBNQMFEFNP.BQQFSͳΒ 
 SFTPVSDFNBJODPNFYBNQMFEFNP.BQQFSYNM w .BWFO΍(SBEMFͰSFTPVSDFTͷର৅Λઃఆ͢Δ͜ͱͰNBJO഑Լʹஔ͍ ͯ΋ಡΈࠐ·ΕΔΑ͏ʹมߋͰ͖Δ

Slide 14

Slide 14 text

ൃੜ͢Δྫ֎ͱz͋Δ͋Δz w PSHBQBDIFJCBUJTCJOEJOH#JOEJOH&YDFQUJPO w ϑΝΠϧͷஔ͖৔ॴؒҧ͑ͯΔ w ϑΝΠϧ໊ʢେจࣈখจࣈͱ͔΋ؚΊʣؒҧ͑ͯΔ w 3FTPVSDFͷઃఆ͕ແ͍ɺؒҧ͑ͯΔ

Slide 15

Slide 15 text

ύϥϝλΛ౉͢ w 42-ͰόΠϯυม਺ͱͯ͠ѻ͏஋Λ౉͢ w .BQQFSϝιουͷύϥϝλʹ!1BSBNΞϊςʔγϣϯΛ͚ͭͯύϥϝλ Λ౉͢ Demo getById(@Param("pk") DemoPk pk); w 42-ଆͰ͸\YYY^ \YYY^ͳͲͰύϥϝλΛड͚औΔ where pk = #{pk.value}

Slide 16

Slide 16 text

ൃੜ͢Δྫ֎ͱz͋Δ͋Δz w PSHNZCBUJTTQSJOH.Z#BUJT4ZTUFN&YDFQUJPO w DBVTFECZPSHBQBDIFJCBUJTCJOEJOH#JOEJOH&YDFQUJPO w .BQQFSͱ9.-Ͱύϥϝλ໊͕Ұகͯ͠ͳ͍ w ύϥϝλ໊ॻ͖๨Ε w !1BSBNॻ͖๨Ε

Slide 17

Slide 17 text

ൃੜ͢Δྫ֎ͱz͋Δ͋Δz w PSHNZCBUJTTQSJOH.Z#BUJT4ZTUFN&YDFQUJPO w DBVTFECZPSHBQBDIFJCBUJTSF fl FDUJPO3F fl FDUJPO&YDFQUJPO w ϓϩύςΟ͕ͳ͍ w ϓϩύςΟ໊ؒҧ͑ͯΔʢେจࣈɾখจࣈʣ w ϓϩύςΟͷ֊૚Λؒҧ͑ͯΔ

Slide 18

Slide 18 text

݁ՌΛϚοϐϯά w %#͔Βड͚औͬͨ݁ՌΛฦ٫༻ΫϥεʹϚοϐϯά͢Δ w ͜ͷྻ͸͜ͷϓϩύςΟʹೖΕΔͱ͔ w SFTVMU5ZQF΍SFTVMU.BQͷࢦఆ w SFTVMU.BQͰྻຖͷϚοϐϯάࢦఆ

Slide 19

Slide 19 text

ൃੜ͢Δྫ֎ͱz͋Δ͋Δz w PSHNZCBUJTTQSJOH.Z#BUJT4ZTUFN&YDFQUJPO w DBVTFECZPSHBQBDIFJCBUJTSF fl FDUJPO3F fl FDUJPO&YDFQUJPO w ϓϩύςΟ໊ؒҧ͑ͯΔ

Slide 20

Slide 20 text

ൃੜz͠ͳ͍zΤϥʔ w 4FMFDUͯ͠ͳ͍ྻ໊Λॻ͍͍ͯͯ΋ΤϥʔʹͳΒͳ͍ w ࣮ߦͯ͠΋֘౰ͷ߲໨ʹOVMM΍ίϯετϥΫλͷॳظ஋͕ೖΔ͚ͩ w +BWBͰೖΕ෺͸༻ҙ͚ͨ͠ͲԿ΋ೖΒͳ͔ͬͨɺΈ͍ͨͳѻ͍

Slide 21

Slide 21 text

42-Λ४උ͢Δ w ࣮ߦͷલʹ42-ΛϓϦίϯύΠϧ࣮ͯ͠ߦ४උ͢Δ w .Z#BUJTʹݶΒ͍͍ͣͩͨ͜ͷॲཧ͕͋Δ w ࢀߟKBWBTRM1SFQBSFE4UBUFNFOU

Slide 22

Slide 22 text

ൃੜ͢Δྫ֎ͱz͋Δ͋Δz w จ๏Τϥʔ͸͜ͷλΠϛϯάͩͱࢥͬͯͨΜ͚ͩͲ 
 ࠓճΑ͘Α֬͘ೝͨ͠Βҧ͏͔ͬͨʂ w ͜ͷλΠϛϯάͰΤϥʔى͜͢ํ๏ࢥ͍͔ͭͳ͔ͬͨͷͰ͍͖࣍·͢ʂ

Slide 23

Slide 23 text

42-࣮ߦͯ͠%#͔Β݁ՌΛड͚औΔ w ࣮ࡍʹ42-Λ࣮ߦ͢Δ w %BUBTPVSDFΛࢀরͯ͠%#ʹ઀ଓ w ઀ଓࣗମ͸.Z#BUJTͷൣғ֎ʢ)JLBSJ$1ͱ͔ʣ w ݁ՌΛ%#͔Βड͚औΔ w ਖ਼ৗͳͷ͔ɺҟৗͳͷ͔ w ड͚औͬͨ݁ՌΛݺͼग़͠ݩʹฦ٫Ͱ͖Δܗʹ͢Δͷ͸͜ͷޙͷॲཧɻ

Slide 24

Slide 24 text

ൃੜ͢Δྫ֎ͱz͋Δ͋Δz w %#ʹͭͳ͕Βͳ͍ɺ%#མͪͯͨɺλΠϜΞ΢τɾɾɾ w ʢ಺ଂ)Ͱ͜ͷλΠϛϯάͰى͜͢ͷ೉͘͠ͳ͍ʁʣ w PSHTQSJOHGSBNFXPSLKECD#BE4RM(SBNNBS&YDFQUJPO w 42-จ๏ޡΓ w UZQPɺ4&-&$5۟ͷΧϯϚൈ͚ɺςʔϒϧ໊ɾྻ໊ؒҧ͍ɾɾɾɾ

Slide 25

Slide 25 text

ΦϒδΣΫτʹ஋Λ୅ೖ w %#͔Βड͚औͬͨ݁ՌΛ+BWBͷΦϒδΣΫτʹ֨ೲ͢Δ w ֨ೲ͢ΔͨΊͷΠϯελϯεੜ੒ w SFTVMU.BQ͕͋Ε͹هࡌͷϚοϐϯάͰɺ 
 ͳ͚Ε͹ྻ໊ʹԊͬͨϓϩύςΟʹSF fl FDUJPOͰ஋Λ֨ೲ

Slide 26

Slide 26 text

ൃੜ͢Δྫ֎ͱz͋Δ͋Δz w PSHNZCBUJTTQSJOH.Z#BUJT4ZTUFN&YDFQUJPO w $BVTFECZPSHBQBDIFJCBUJTSF fl FDUJPO3F fl FDUJPO&YDFQUJPO w ֨ೲ͢ΔΫϥεʹద੾ͳίϯετϥΫλ͕ແ͍ w Ҿ਺ͳ͠ίϯετϥΫλ͔ɺ֨ೲ͢Δશ߲໨ͷҾ਺Λ࣋ͭίϯετϥ Ϋλ͕ଥ౰ w QSJWBUFͰ΋େৎ෉ w ίϯετϥΫλະఆٛͳΒσϑΥϧτͰҾ਺ͳ͕͠༻ҙ͞ΕΔ

Slide 27

Slide 27 text

͓·͚ɿͨ·ʹz͋Δ͋Δz w ίϯετϥΫλ΋ϓϩύςΟ΋ͪΌΜͱ͋ΔͷʹͳΜ͔஋͕͏·͍͜ͱ ೖΒͳ͍ͷͳΜͰʁʁʁ w ಛఆͷQSF fi Y͕͍ͭͨϝιου͕HFUUFS΍TFUUFSͱͯ͠ಈ͍ͯ͠·͏ w HFU JT DBOʜ w HFU)PHF \JG IPHFOVMM SFUVSOOFX)PHF ^

Slide 28

Slide 28 text

ྫʣ )PHF\ 'VHBGVHBOFX'VHB )PHF \^ HFU'VHB \ JG GVHBWBMVFOVMM SFUVSOOFX'VHB SFUVSOGVHB ^ ίϯετϥΫλʹΑΓGVHBOVMMͷ )PHFΠϯελϯε͕࡞ΒΕΔ .Z#BUJT͸GVHBʹ୅ೖ͢ΔͨΊ HFU'VHBͰऔΓग़ͨ͠ϓϩύςΟʹ ஋Λ୅ೖ͠Α͏ͱ͢Δ GVHB͸OVMMͳͷͰ৽͍͠'VHBΠϯ ελϯε͕ฦ͞ΕΔ ̏Ͱ࡞ͬͨΠϯελϯεʹ஋Λ୅ೖ )PHFGVHB͸OVMMͷ··ɾɾɾ )PHF GVHB OVMM GVHB HFU'VHB ୅ೖ

Slide 29

Slide 29 text

͍͞͝ʹ w ࠓճ঺հͨ͠Ҏ֎ʹ΋৭ΜͳΤϥʔ͕ൃੜ͠ಘΔ w ͲΜͳ͜ͱΛͲΜͳॱ൪Ͱ΍͍ͬͯΔͷ͔Λ೺Ѳ͠ͳ͕Β 
 ʮ42-͸࣮ߦͰ͖ͯΔ͔Β͜ͷล͕ؒҧ͑ͯͦ͏ʯ 
 ʮ42-ͷ࣮ߦ͢Βͯ͠ͳ͍͔Β͜͜Βล͔Βௐ΂Α͏ʯ 
 ͱ͔མͪண͍ͯߟ͑ΒΕΔΑ͏ʹͳΔͱخ͍͠Ͱ͢ʂ

Slide 30

Slide 30 text

͋Γ͕ͱ͏͍͟͝·ͨ͠ʂ