実践MyBatis #kanjava

Z#BUJT ࣮ફ .

4ZTUFN"SDIJUFDU 4ZTUFN"SDIJUFDU +BWB !T@LP[BLF 8IPBN*

8IPBN*ʁ

ࠓ೔ͷ໨త https://flic.kr/p/23R1Tx

.Z#BUJTͱ͸ https://flic.kr/p/4ms8ZA

.Z#BUJTͷجຊ https://flic.kr/p/gaBFBV

࠷৽.Z#BUJT https://flic.kr/p/TeA7eF

ݱ৔ͷ޻෉ https://flic.kr/p/tKFgm

͜Ε͔Β࢝ΊΔʹ͸ https://flic.kr/p/qskbe

"HFOEB .Z#BUJTXJUI4QSJOH .Z#BUJTͷجຊ .Z#BUJTͱ͸ ݱ৔ͷ޻෉ ͜Ε͔Β࢝ΊΔʹ͸

.Z#BUJTJT 42-.BQQFS

03. .Z#BUJT NBQQJOH 42- NBQQJOH

௕͍ྺ࢙ https://flic.kr/p/egva6V

೥ J#BUJT ೥ J#BUJT ⬇ .Z#BUJT .Z#BUJT .Z#BUJT ೥ .Z#BUJT
೥ .Z#BUJT ೥ ࠷৽7FS͸ ࣌఺

ւ֎Ͱ͸͋·Γ ࢖ΘΕ͍ͯͳ͍ʁ

+)JQTUFSͬͯ.Z#BUJTαϙʔτ͠ͳ͍ͷʁ )JCFSOBUF+1"Ҏ֎αϙʔτ͠ͳ͍Αʁ ͦ͏ͳΜɻ͡Ό͋উखʹ΍ΔΘɻ νʔϜʹ+1"ͷεΩϧͳ͍ͶΜɻ ͔ͯͳΜͰ.Z#BUJTɻ ਺೥લʹࢮΜͩͱࢥͬͯͨʁ https://github.com/jhipster/generator-jhipster/issues/1252 ͷͱ͋Δձ࿩

͍ͭ࢖͏ͷʁ

ɾෳࡶͳσʔλϞσϧͷ৔߹ ɾνʔϜͷεΩϧηοτʹԠͯ͡ ɾσʔλϕʔεػೳΛϑϧ׆༻͍ͨ͠

.Z#BUJT ઃఆϑΝΠϧ 9.- .BQQFSఆٛ 9.- NBQQFST .Z#BUJTͷಈ࡞ΛΧελϚΠζ ͢ΔͨΊͷઃఆ΍ϓϩύςΟ σʔλιʔεͷઃఆ΍ϓϥάΠϯͷઃ ఆͳͲͳͲ
42-Λ9.-Ͱఆٛ͢Δɻ ʮ.Z#BUJT͸9.-Ͱ42-ॻ͔ͳ͍ ɹͱ͍͚ͳ͍ͷ͕ʙ SZʯ ͱ͔ݴΘΕΔͷ͕͜ͷϑΝΠϧ

.Z#BUJT ઃఆϑΝΠϧ 9.- .BQQFSఆٛ 9.- NBQQFST <?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd"> <configuration> <typeAliases> <package name="sample.domain"/> </typeAliases> <environments default="development"> <environment id="development"> <transactionManager type="JDBC"/> <dataSource type="POOLED"> : </dataSource> </environment> </environments> <mappers> <mapper resource="sample/mapper/CityMapper.xml"/> </mappers> </configuration> <?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="sample.mapper.CityMapper"> <select id="selectCityById" resultType="City"> select * from city where id = #{id} </select> </mapper>

.Z#BUJT ઃఆϑΝΠϧ 9.- .BQQFSఆٛ 9.- .BQQFS ΠϯλϑΣʔε NBQQFST &OUJUZ 42-ͷ݁Ռηοτͱ
Ϛοϐϯά͢Δ+BWBιʔεɻ ओʹςʔϒϧͷϨίʔυͷ ৘ใΛอ࣋͢Δɻ 42-ఆٛΛϚοϐϯά͢Δ ΠϯλϑΣʔεɻ

.Z#BUJT ઃఆϑΝΠϧ 9.- .BQQFSఆٛ 9.- .BQQFS ΠϯλϑΣʔε NBQQFST &OUJUZ public
interface CityMapper { City selectCityById(long id); } public class City { private Long id; private String name; private String state; private String country; : }

4RM4FTTJPO 'BDUPSZ #VJMFS .Z#BUJT ઃఆϑΝΠϧ 9.- 4RM4FTTJPO 'BDUPSZ 4RM4FTTJPO .BQQFSఆٛ
9.- .BQQFS ΠϯλϑΣʔε CVJME PQFO4FTTJPO HFU.BQQFS NBQQFST SFBE &OUJUZ

9.- .BQQFS ΠϯλϑΣʔε CVJME PQFO4FTTJPO HFU.BQQFS NBQQFST SFBE &OUJUZ String resource = "mybatis-config.xml"; InputStream inputStream = Resources.getResourceAsStream(resource); SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream); SqlSession session = sqlSessionFactory.openSession(); try { CityMapper mapper = session.getMapper(CityMapper.class); City city = mapper.selectCityById(1); : } finally { session.close(); }

΋ͬͱ؆୯ʹ https://flic.kr/p/pzJusn

42-͸Ξϊςʔγϣϯ Ͱ΋ॻ͚Δ

.BQQFS ΠϯλϑΣʔε &OUJUZ public interface CityMapper { @Select("select * from
city where id = #{id}") City selectCityById(long id); }

NBQQFSͷઃఆ͸ QBDLBHFࢦఆͰ͖Δ

.Z#BUJT ઃఆϑΝΠϧ 9.- <?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE configuration PUBLIC
"-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd"> <configuration> <typeAliases> <package name="sample.domain"/> </typeAliases> <environments default="development"> <environment id="development"> <transactionManager type="JDBC"/> <dataSource type="POOLED"> : </dataSource> </environment> </environments>  <mappers> <package name="sample.mapper" /> </mappers> </configuration>

4RM4FTTJPO.BOBHFS Λ࢖ͬͯ4RM4FTTJPO ͷҾ͖ճ͠Λճආʂ

9.- .BQQFS ΠϯλϑΣʔε CVJME PQFO4FTTJPO HFU.BQQFS NBQQFST SFBE &OUJUZ String resource = "mybatis-config.xml"; InputStream inputStream = Resources.getResourceAsStream(resource); SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream); SqlSessionManager session = SqlSessionManager.newInstance(sqlSessionFactory); session.startManagedSession(); try { CityMapper mapper = session.getMapper(CityMapper.class); City city = mapper.selectCityById(1); : } finally { session.close(); }

΍ͬͺΓ ΊΜͲ͏͍͘͞ʁ ??

ɾ4QSJOHͰఆٛͨ͠σʔλιʔεΛར༻Ͱ͖Δɻ ɾ4QSJOHͷτϥϯβΫγϣϯ੍ޚΛར༻Ͱ͖Δɻ ɾఆܕతͳॳظԽϩδοΫ͕ෆཁɻ ɾ4QSJOH͕ఏڙ͢ΔσʔλΞΫηεྫ֎΁ͷม׵ɻ ɾFUD

+%,1SPYZ +%,1SPYZ .BQQFS 'BDUPSZ#FBO 4RM4FTTJPO 'BDUPSZ 4RM4FTTJPO 5FNQMBUF .Z#BUJT ઃఆϑΝΠϧ
9.- .BQQFS ΠϯλϑΣʔε PQFO4FTTJPO 4RM4FTTJPO 4RM4FTTJPO 'BDUPSZ#FBO 4RM4FTTJPO 'BDUPSZ #VJMEFS SFBE CVJME

+%,1SPYZ +%,1SPYZ .BQQFS 'BDUPSZ#FBO 4RM4FTTJPO 5FNQMBUF .BQQFS ΠϯλϑΣʔε PQFO4FTTJPO 4RM4FTTJPO
4RM4FTTJPO 'BDUPSZ#FBO 4RM4FTTJPO'BDUPSZ#VJMEFS Λ༻͍ͯ4RM4FTTJPO'BDUPSZ ͷ#FBOΛੜ੒ɻ %*ίϯςφ্ʹ#FBOԽ͞Εͨ σʔλιʔεΛΠϯδΣΫγϣϯɻ 4RM4FTTJPO 'BDUPSZ 4RM4FTTJPO 'BDUPSZ #VJMEFS CVJME .Z#BUJT ઃఆϑΝΠϧ 9.- SFBE

+%,1SPYZ 4RM4FTTJPO 'BDUPSZ .Z#BUJT ઃఆϑΝΠϧ 9.- PQFO4FTTJPO 4RM4FTTJPO 4RM4FTTJPO 'BDUPSZ#FBO
4RM4FTTJPO 'BDUPSZ #VJMEFS SFBE CVJME +%,1SPYZ .BQQFS 'BDUPSZ#FBO 4RM4FTTJPO 5FNQMBUF .BQQFS ΠϯλϑΣʔε .BQQFSΦϒδΣΫτΛ ੜ੒͠ɺ%*ίϯςφʹ #FBOొ࿥ 4QSJOHͷτϥϯβΫγϣϯ؅ཧԼ Ͱ42-Λ࣮ߦ͢Δ࢓૊ΈΛఏڙɻ

ɾࣗಈίϯϑΟΪϡϨʔγϣϯʹΑͬͯɹ ɹ4RM4FTTJPO'BDUPSZ#FBO΍4RM4FTTJPO5FNQMBUF ɹͷ#FBOఆ͕ٛࣗಈղܾʂʂ

.Z#BUJTXJUI4QSJOH#PPU JT$PPMʂ https://flic.kr/p/bdCH5D

https://start.spring.io/

@Mapper public interface CityMapper { @Select("select * from city where
id = #{id}") City selectCityById(long id); } public class City { : } @SpringBootApplication public class DemoApplication implements CommandLineRunner { final private CityMapper mapper; public DemoApplication(CityMapper mapper) { this.mapper = mapper; } public static void main(String... args) { SpringApplication.run(DemoApplication.class, args); } public void run(String... args) throws Exception { City city = mapper.selectCityById(1); : } }

@Mapper public interface CityMapper { @Select("select * from city where
id = #{id}") City selectCityById(long id); } public class City { : } @SpringBootApplication public class DemoApplication implements CommandLineRunner { final private CityMapper mapper; public DemoApplication(CityMapper mapper) { this.mapper = mapper; } public static void main(String... args) { SpringApplication.run(DemoApplication.class, args); } public void run(String... args) throws Exception { City city = mapper.selectCityById(1); : } } ͨͬͨ͜Ε͚ͩʂ

"HFOEB .Z#BUJTXJUI4QSJOH .Z#BUJTͷجຊ .Z#BUJTͱ͸ ݱ৔ͷ޻෉ ͜Ε͔Β࢝ΊΔʹ͸ ͜Ε·Ͱ ͜Ε͔Β

5ZQF)BOEMFS

public interface TypeHandler<T> { void setParameter(PreparedStatement ps, int i, T
parameter, JdbcType jdbcType) throws SQLException; T getResult(ResultSet rs, String columnName) throws SQLException; T getResult(ResultSet rs, int columnIndex) throws SQLException; T getResult(CallableStatement cs, int columnIndex) throws SQLException; } ɾ1SFQBSFE4UBUFNFOUͷύϥϝʔλʔΛηοτ͢Δͱ͖ɺ ɹ͋Δ͍͸3FTVMU4FU͔Β஋Λऔಘ͢Δͱ͖ʹɺ ɹඞͣͦͷ+BWBλΠϓʹରԠ͢Δ5ZQF)BOEMFS͕࢖༻͞ΕΔɻ ɾඪ४ͷλΠϓϋϯυϥʔΛΦʔόʔϥΠυͨ͠Γɺ ɹࣗΒ࡞੒ͨ͠λΠϓϋϯυϥʔΛ࢖ͬͯະରԠ͋Δ͍͸ ɹඇඪ४ͷܕΛѻ͏͜ͱ΋Մೳɻ

ɾʙʢνϧμʣͳͲͷจࣈԽ͚ରԠ ɾ֎ࣈΛྨࣅจࣈʹม׵ 4USJOH5ZQF)BOEMFSΛΦʔόϥΠυͯ͠ ࣍ͷ໰୊ʹରॲ GPS"OESPJE

.Z#BUJT(FOFSBUPS

ιʔείʔυ .Z#BUJT(FOFSBUPS ઃఆϑΝΠϧ

ɾطଘ%#ͷϝλσʔλ͔Β.BQQFSιʔε ɹΛࣗಈੜ੒ ɾ.Z#BUJT(FOFSBUPSͷ1MVHJOΛ࡞੒ͯ͠ ɹ৭ʑʢΦϨΦϨʣͱޮ཰Խ ɾ࣌ʹ͸ຊମʹ΋खΛೖΕΔΑʂ

: public List<City> selectByNameAndState() { return query() .where() .nameEqualTo("sakai") .and()
.stateEqualTo("osaka") .orderBy("id desc") .fetch(); } ಠࣗʢΦϨΦϨʣ1MVHJOͰྲྀΕΔΑ͏ͳ"1* ͰΫΤϦΛ͔͚Δ޻෉Λͨ͠Γ͍ͯ͠·͢ɻ

ࣗಈੜ੒ιʔε͸ઈରʹ खमਖ਼͠ͳ͍͜ͱʂ

ςʔϒϧͷ ϦϨʔγϣϯ

ɾ/ʴ̍໰୊ ɾू໿ͷ୯ҐͲ͏͢Δʁ ɾෳ߹ओΩʔʹର͢Δରॲ ςʔϒϧͷϦϨʔγϣϯ؅ཧ͸େม ɾϑΣονઓུʢ&BHFSPS-B[Zʣ

7JFX΍42-ͰؤுΔʂ ͜͜Βล͸αʔϏε΍νʔϜಛੑʹԠͯ͡ ܾΊ·͠ΐ͏ʙ

ιʔείʔυ .Z#BUJT(FOFSBUPS 42-ϑΝΠϧ WJFX ɾ7JFX΋͘͠͸42-ͷ݁Ռηοτͷϝλσʔλ͔Βιʔείʔυ ɹΛࣗಈੜ੒ ɾ42-ͷ݁Ռηοτ͔Βͷࣗಈੜ੒͸ಠࣗʢΦϨΦϨʣ1MVHJO

"HFOEB .Z#BUJTXJUI4QSJOH .Z#BUJTͷجຊ .Z#BUJTͱ͸ ݱ৔ͷ޻෉ ͜Ε͔Β࢝ΊΔʹ͸ ͜Ε·Ͱ ͜Ε͔Β

+43ʹରԠͨ͠5ZQF)BOEMFS͕༻ҙ͞Ε͍ͯΔɻ ੵۃతʹऔΓࠐΜͰ͍͖͍ͨɻ

3FQPTJUPSZ

%PNBJO0CKFDU PS 4FSWJDF .BQQFS 3FQPTJUPSZ Ͱ͸ͳ͘ %PNBJO0CKFDU PS 4FSWJDF .BQQFS
͜͏͍ͨ͠

ɾ3FBDUJWF1SPHSBNNJOH ɾ&DMJQTF$PMMFDUJPOT ΫΤϦͷ݁ՌΛ4USFBNͱͯ͠ѻ͍͍ͨɻ 3Y+BWB PS3FBDUPS औΓ૊ΜͰ͍͖͍ͨʂ

http://qiita.com/opengl-8080/items/a9b5d4038f19d4813ee6

http://qiita.com/kazuki43zoo/items/ea79e206d7c2e990e478

http://www.mybatis.org/mybatis-3/ja/index.html

·ͱΊ

ɾ4QSJOH#PPUͱ࢖͏ͱָνϯ ɾطଘ%#͕͋Δ৔߹͸(FOFSBUPSͷ׆༻Λ ɾ42-ϕʔεͰγεςϜ։ൃ͍ͨ͠৔߹͸Ͳ͏ͧʂ

5IBOLZPV GPSZPVSMJTUFOJOH https://flic.kr/p/TqScXB

実践MyBatis #kanjava

実践MyBatis #kanjava

More Decks by Shinichi Kozake

Other Decks in Technology

Featured

Transcript