汁奈伙掀廌仄卅互日惤月 O/R穴永由奈午DB穴奶弘伊奈扑亦件及g蕣及午仇欠
19 likes17,680 views
JJUG-CCC 梇醇ava交奈扒奈朮弘伙奈皿弁伕旦戊立亙瓦氾奴市件白央伊件旦 2018/12 腎脅Y蹋匹允﹝
![#ccc_a1
Spring及JdbcTemplate
List<Book> books = jdbcTemplate.query(
※SELECT ISBN, TITLE FROM BOOKS§
+ ※ WHERE ISBN = ? §,
new Object[]{※hoge§}, // ※?§及午仇欠卞諵鴗縣夫杅
new BeanPropertyRowMapper(Book.class)
);
16](https://image.slidesharecdn.com/jjug-ccc2018fall-ccca1-o-r-mapper-and-dbmigrationtools-181215020402/85/O-R-DB-16-320.jpg)
![#ccc_a1
MyBatis
<!-- xml白央奶伙 -->
<select id="selectBook" parameterType=§String§
resultType="Book">
<![CDATA[
SELECT ISBN, TITLE FROM BOOKS
WHERE ISBN = #{isbn}
]]></select>
// Java戊奈玉
List<Book> books = bookRepository.select(※hoge§);
17](https://image.slidesharecdn.com/jjug-ccc2018fall-ccca1-o-r-mapper-and-dbmigrationtools-181215020402/85/O-R-DB-17-320.jpg)
![#ccc_a1
↗眕狟反巨件斥瓦失及PC匹反卅仁CI扔奈田互g囥
6. 咫々峊蔗`旦戊奈玉汁伉奈毛民尼永弁失它玄
7. CI扔奈田囀窒匹Docker匹伕奈市伙DB毛れ
8. ./gradlew flywayMigrate (伕奈市伙DB及婬傖)
9. ./gradlew [O/R穴永由及Java戊奈玉赻蚕傖戊穴件玉]
10. ./gradlew build ->咫々峊釧`玉互jar/war白央奶伙趙今木月
11. 失皿伉毛犯皿伕奶允月ヶ卞 ./gradlew flywayMigrate -DdbHost=...
↗踏僅反DB及砃五珂毛犯皿伕奶珂虐噫囀及DB卞仄化云仁
12. jar/war毛犯皿伕奶
44](https://image.slidesharecdn.com/jjug-ccc2018fall-ccca1-o-r-mapper-and-dbmigrationtools-181215020402/85/O-R-DB-44-320.jpg)
汁奈伙掀廌仄卅互日惤月 O/R穴永由奈午DB穴奶弘伊奈扑亦件及g蕣及午仇欠
- 1. #ccc_a1 汁奈伙掀廌仄卅互日惤月 O/R穴永由奈午DB穴奶弘伊奈扑亦件 JJUG-CCC 2018 Fall 梇醇ava交奈扒奈朮弘伙奈皿 弁伕旦戊立亙瓦氾奴市件白央伊件旦 矛伙扔奈伙昹陔咑 2018-12-15 Y.Watanabe
- 3. #ccc_a1 Who? ♂ 傾煘 硝 ♂ (絁)申朮伉奈民 ♂ SRE弘伙奈皿 ♀ Site Reliability Engeneering ♂ twitter: @nabedge ♂ nabedge@gmail.com 3
- 4. #ccc_a1 Software Design 2019 / 1堎瘍卞敵詨仄引仄凶 菴2杻摩 伉伉奈旦乒犯伙及銝卞升丹I允月ˋ Java及田奈斥亦件觳卞ヶ砃五卞 ﹞篚M戈源楊 菴3梒 Java毛田奈斥亦件失永皿仄支允仁允月 失奶犯失 筳趙卞砵今內ㄛ公及丟伉永玄毛 砅忳允月凶戶卞 4
- 5. #ccc_a1 踏捸誘角縣中酗 ♂ 失皿伉弗奈扑亦件及忭韜 ˉ DB及忭韜 ♂ 霜木及厒今及幼乓永皿卞﹜失皿伉弗奈扑亦件及氾弁 用伕斥奈匹﹜丹引中仇午葆五磁丹源楊勻化卅氏分欠 丹ˋ 5
- 6. #ccc_a1 今勻公仁匹允互失件弗奈玄 ♂ MyBatis(iBatis) ♂ Spring及JdbcTemplate ♂ Hibernate ♂ QueryDSL ♂ jOOQ ♂ Doma ♂ DBFlute ♂ S2JDBC ♂ Flyway 綎1爛匹丐卅凶互g蕣卞帊岈匹妏勻凶手及反ˋ 6
- 8. #ccc_a1 手仁元1 1. 正奶皿本奈白卅O/R穴永由奈及杻 2. DB穴奶弘伊奈扑亦件汁奈伙午反ˋ 3. Flyway午反ˋ 8
- 9. #ccc_a1 手仁元2 4. 嶱逃及旦正奈玄華萸反? CREATE/ALTER恅? ER? 氾奈皮伙隅膽.xls ? JPA及巨件氾奴氾奴弁仿旦.java @Table, @Column 5. 嶱逃蚚DB反升仇卞丐月? 伕奈市伙PC? 僕衄DB扔奈田? 9
- 10. #ccc_a1 手仁元3 6. O/R穴永由奈及末奈旦戊奈玉赻蚕傖毛 升及正奶立件弘匹支月井 7. 赻蚕傖仄凶戊奈玉毛git卞諵鴗諵 8. 赻蚕傖仄凶戊奈玉午玉丟奶件左皮斥尼 弁玄及戊奈玉毛煦仃月屯五井 10
- 11. #ccc_a1 手仁元4 9. 氾旦玄犯奈正毛升丹支勻化芘諵馱諵 10. g蕣卞g俴今木月SQL毛凶中 11. RDBMS及黃赻憝杅毛妏中凶中 12. 氾奈皮伙隅膽齯礞氻肉髐諵 11
- 15. #ccc_a1 ♂ Hibernate 2001? ♂ Spring-JDBC(JdbcTemplate) 2001? ♂ iBatis/MyBatis 2005? ♂ S2JDBC 2008? ♂ QueryDSL 2008? ♂ DBFlute 2008? ♂ jOOQ 2010? 氾奈皮伙釬傖g心及DB扔奈 田井日丟正犯奈正毛掂心﹞ 化O/R穴永疋件弘蚚Java末奈 旦毛赻蚕傖允月源宒 嘉中卞K屯化閉介勻仁曰煦 SQL毛忒匹鎚戶煋戈源宒 匼豸豸洃炊馱馱嶀リ迨吨(*1,2) 15
- 16. #ccc_a1 Spring及JdbcTemplate List<Book> books = jdbcTemplate.query( ※SELECT ISBN, TITLE FROM BOOKS§ + ※ WHERE ISBN = ? §, new Object[]{※hoge§}, // ※?§及午仇欠卞諵鴗縣夫杅 new BeanPropertyRowMapper(Book.class) ); 16
- 17. #ccc_a1 MyBatis <!-- xml白央奶伙 --> <select id="selectBook" parameterType=§String§ resultType="Book"> <![CDATA[ SELECT ISBN, TITLE FROM BOOKS WHERE ISBN = #{isbn} ]]></select> // Java戊奈玉 List<Book> books = bookRepository.select(※hoge§); 17
- 18. #ccc_a1 中引畿賡仄凶及反導懂倰O/R穴永由奈 ♂ 丟伉永玄 ♀ 午卞井仁SQL毛忒匹齯咫吨中搕g引卅中 ♂ 犯丟伉永玄 ♀ 正奶皿本奈白匹反卅中 ♀ BOOK毛BOOKS午齯中々g俴允月引匹ㄗ田弘月引匹ㄘ立 旦卞搕聾惜吨 ↗砑隅仄化中月氾奈皮伙靡反BOOK匹允﹝ヶ及矢奈斥反 歹介午嶲綃中毛齯中々中牏飽 18
- 19. #ccc_a1 jOOQㄗ斥亙奈弁午掂戈ㄘ //氾奈皮伙及丟正犯奈正①韞砲擖 Book book = Tables.book; // SQL毛瞎心蕾化化g俴 List<BookVo> books = dsl .select(book.isbn, book.title) .from(book) .where(book.isbn.eq(※hoge§)) .fetchInto(BookVo.class); // PoJo匹丐木壬忒釬曰弁仿旦匹手褫 正奶皿本奈白ˊ嶲綃尹凶日戊件由奶伙巨仿奈匹歹井月 喪趼反赻茪竣鴗澴ava戊奈玉毛 妏勻化中月預垀 19
- 20. #ccc_a1 DBFlute List<Book>books = bookBhv.selectEntity( condition -> { condition.query().setBookIsbn_equal("999"); } ); 喪趼反赻茪竣鴗澴ava戊奈玉毛 妏勻化中月預垀 20
- 21. #ccc_a1 丹凶什曰旮中豸堙２噩惜拏﹝ 1. jOOQ反手勻午恚螝卅SQL毛瞎心蕾化月仇午手褫夔匹允﹝ a. 統蕉恅瓬 https://docs.google.com/presentation/d/1MvsMo38Bt-2h4b_ZDSSXNSgq_UuweXx9P0HmlbO y8k8 2. 淏眻卞晟丹午﹜DBFlute反 group by 毛扔禾奈玄仄化中引六氏﹝ a. 公丹中丹仇午反☆俋堤仄SQL★匹齯窈誕礡 b. 俋堤仄SQL及磐彆穴永疋件弘支網太堤仄戊奈玉及赻蚕傖毛扔禾奈玄﹝ 21 賃
- 22. #ccc_a1 QueryDSL ♂ jOOQ午侔化月ㄗ及匹﹜扔件皿伙戊奈玉反吽謹ㄘ ♂ NoSQL手搪O腔ㄗLucene﹜MongoDBㄘ ♂ 2016爛9堎﹜QueryDSL及丟奶件卅戊立永正奈互 ☆支曰五勻凶井日﹜e及帊岈支月歹﹝★ 午岈g奻及嶱逃礿笴哫晟﹝*3 ♂ jOOQ荂硿ueryDSL云勾井木﹝偃凶切反引分支月兮★哫晟﹝*4 ♂ 2018爛5堎 廣2爛少曰及田奈斥亦件失永皿 22
- 23. #ccc_a1 中引餫卅O/R穴永由奈及僕籵 ♂ 正奶皿本奈白卅Java戊奈犯奴件弘匹CRUD毛齯 ♀ 立旦勻凶日戊件由奶伙巨仿奈 ♂ DB卞疋永正伉磁歹六凶Java戊奈玉匹CRUD毛齯 ♀ DB銝及荌鴗洛野韞悒丰諝言撽`匹歹井月 ♂ 奻毛g政允月凶戶卞﹜ ♀ 氾奈皮伙釬傖g心及DB扔奈田井日赻茧臚迉嵽縞ワ`正毛 掂心﹞瓣ヾ℃ava末奈旦戊奈玉毛赻蚕傖 23
- 25. #ccc_a1 仇仇匹晟丹DB穴奶弘伊奈扑亦件午反 DB卞允月銝ˊDDL恅及羥蚚ˊ毛奪燴允月汁奈伙 ♂ O/R穴永由奈肮y倰 ♀ Ruby on Rails ♀ DBFlute ♀ Hibernate(?) ♂ 蚚汁奈伙倰 ♀ LiquiBase ♀ MyBatis Migration ♀ Flyway 25
- 26. #ccc_a1 ☆中引及袨B及DB -> 銝及DDL毛丐化月 -> 棒及袨B及DB卞卅月★ 1. ☆棒及袨B及DB★及白伙DDLㄗCREATE恅ㄘ毛忒匹釬勻化云仁 2. ☆踏及袨B井日銝允月凶戶及DDL★手忒匹釬勻化云仁 3. DBFlute及§save-previous§戊穴件玉匹踏及袨B及DB及隅膽①韝繸ㄣ 4. 3午1毛妏勻化DBFlute及§alter-check§戊穴件玉匹狟毛彸^匹五月 踏及袨B + 銝及DDL = 棒及袨B 5. 4及磐彆毛凶DBA反假陑仄化☆銝及DDL★毛掛楓DB匹g俴 6. 嶱逃氪反DBFlute及§replace-schema§匹忒啋及嶱逃DB毛婬慷 26 DBFlute及穴奶弘伊奈扑亦件C夔
- 28. #ccc_a1 MyBatis Migrations ♂ r嶲互o中及匹賃菕 ♂ 蕉尹源反Flyway午方仁侔化中月 28 賃
- 30. #ccc_a1 價掛腔卅蕉尹源 DB穴奶弘伊奈扑亦件汁奈伙互o中岍賜匹 DBA童絞互DB卞砃井勻化支月價掛衿髐 噶O﹜仇木分仃﹝ 1. DDL恅毛 FooBar-0001.sql 白央奶伙卞齯中きㄣ獢 2. 卞﹜珨僅分仃﹜g俴允月﹝ 30
- 32. #ccc_a1 32 src/main/resources/db/migration/ V1.1__foo_init.sql <- 汁磥峊筒`申旦嶱宎及午五 V1.2__hoge_alter.sql <- 珂堎及C夔袚樓及午五 V1.3__add_foobar.sql <- 懂筥及凶戶及C夔袚樓 1. DB卞允月銝毛.sql白央奶伙匹搪心笭友化斗仁 2. flyway毛g俴 $ ./gradlew flywayMigrate
- 33. #ccc_a1 33 3. 奪燴氾奈皮伙卞o中sql白央奶伙分仃互g俴砓午卅月 > SELECT ... FROM SCHEMA_VERSION version | script | success ---------+-----------------------+--------- 0.1 | << Flyway Baseline >> | true 1.1 | V1.1__foo_init.sql | true 1.2 | V1.2__hoge_alter.sql | true 1.3 <- 仇及伊戊奈玉反帤分o中及匹V1.3__add_foobar.sql互砓 4. sql白央奶伙及袚樓支銝互卅中袨B匹手丹珨僅 flywayMigrate 仄化 手﹜咫g俴g心匹SCHEMA_VERSION卞嶕今木化中木壬﹜睡手れ五卅 中ㄗ屯五脹俶ㄘ
- 34. #ccc_a1 娗逋 ♂ 綅蚚笢及DB卞﹜芴笢井日庇諵馱諵酗手褫夔 ♀ Flyway ← ※flyway baseline§ 匹弘弘月 ♀ DBFlute ← 仄仁反穴瓦亙失伙毛 ← O/R穴永由奈午仄化妏歹內午手﹜坻及穴奶弘伊奈扑亦件 盓堔戊穴件玉漱壑捩馱忖酗互褫夔 34
- 37. #ccc_a1 37 A. 忒齯迨哖DLㄗ毛搪氏匹斗仁分仃ㄘ 郔場卞CREATE TABLE﹜ 綅蚚仄卅互日 ALTER, CREATE/DROP INDEX, CREATE/DROP TABLE... B. ER矰礞牏齯砥ㄒ角膜酗咫噲DL恅毛赻蚕傖ㄘ C. JPA及巨件氾奴氾奴弁仿旦毛忒齯迨楚％ibernate-JPA匹DDL恅 毛赻蚕傖 D. 氾奈皮伙隅膽.xls午忒齯迨哖DL毛肮r卞齯倌A仃月
- 38. #ccc_a1 38 A. 忒齯迨哖DL毛氾平旦玄倛宒匹搪心奻仆月 仇及源楊眕俋反允屯化﹜卅氏分井氏分匹... ♂ 汁奈伙及本永玄失永皿午妏中源互褣仄中 ♂ 竘五輥亢互褣仄仁卅月 ♂ 汁奈伙互衄井勾汁奈伙卞伕永弁奶件今木月 ♂ 田奈斥亦件奪燴扑旦氾丞午及眈俶互...
- 40. #ccc_a1 40 A. 僕衄DB源宒 民奈丞及巨件斥瓦失T及PC井日扔奈田弅及1怢及DB扔奈 田卞諉適 B. 伕奈市伙DB源宒 公木冗木及巨件斥瓦失及PC卞赻煦蚚及嶱逃DB毛慷
- 41. #ccc_a1 伕奈市伙DB源宒 = Dockerr測及犯白央弁玄 41 $ docker run mysql:5.7 $ ./gradlew flywayMigrate ♂ 祥猁卅市仿丞毛祅壺仄凶中 ♂ 祥羥з卅靡ヶ及市仿丞毛 RENAME仄凶中 ♂ 陔仄中C夔及凶戶卞陔仄中 氾奈皮伙毛袚樓仄凶中 ♂ K俴仄化釬I匹五月 ♂ 凶分仄Flyway及鷅洃洒ql白央奶伙及田奈斥亦件楓瘍 分仃反茇芼仄卅中方丹卞仄磁丹 $ docker run mysql:5.7 $ ./gradlew flywayMigrate
- 43. #ccc_a1 伕奈市伙DB源宒 + 赻蚕傖倰O/R + Flyway 及鷅 1. 巨件斥瓦失反公木冗木支曰凶中DB銝毛DDL匹齯 齯中縣樨笪枉C匹 ./gradlew flywayMigrate ㄗ忒啋及DB互銝今木月ㄘ 2. 巨件斥瓦失反公木冗木忒啋匹O/R穴永由及Java戊奈玉汜傖毛g俴 赻蚕傖仄凶Java戊奈玉反戊立永玄砓俋ㄐㄗ燴蚕反摽扴ㄘ 3. 2.卞磁歹六化失皿伉及Java戊奈玉手齯 4. 忒啋及PC匹失皿伉毛れ -> 衿鰲_庲 5. 皿伙伉弁毛釬月 -> master皮仿件民卞穴奈斥 ㄗ適仁ㄘ 43
- 44. #ccc_a1 ↗眕狟反巨件斥瓦失及PC匹反卅仁CI扔奈田互g囥 6. 咫々峊蔗`旦戊奈玉汁伉奈毛民尼永弁失它玄 7. CI扔奈田囀窒匹Docker匹伕奈市伙DB毛れ 8. ./gradlew flywayMigrate (伕奈市伙DB及婬傖) 9. ./gradlew [O/R穴永由及Java戊奈玉赻蚕傖戊穴件玉] 10. ./gradlew build ->咫々峊釧`玉互jar/war白央奶伙趙今木月 11. 失皿伉毛犯皿伕奶允月ヶ卞 ./gradlew flywayMigrate -DdbHost=... ↗踏僅反DB及砃五珂毛犯皿伕奶珂虐噫囀及DB卞仄化云仁 12. jar/war毛犯皿伕奶 44
- 45. #ccc_a1 ヶ及禾奶件玄 ♂ DB銝午失皿伉弗奈扑亦件戊奈玉及銝毛 肮元皮仿件民ㄞ皿伙伉弁巨旦玄匹釬I匹五月 ♀ Flyway及穴奶弘伊奈扑亦件SQL互田永氾奴件弘仄卅中方丹卞﹜銝囀 午羥蚚唗毛巨件斥瓦失嶲匹猁捼淕 ♂ O/R穴永由奈及赻蚕傖Java戊奈玉反git戊立永玄仄卅中 ♂ 公及井歹曰卞嶱逃氪及PC午 CI扔奈田公木冗木匹 斛猁卅正奶立件弘匹赻蚕傖毛g俴 45
- 46. #ccc_a1 O/R穴永由奈及赻蚕傖戊奈玉手戊立永玄仄凶中鷅 ♂ 穴奶弘伊奈扑亦件SQL恅及戊立永玄午﹜ O/R穴永由奈及Java戊奈玉赻蚕傖及 g俴ㄕ戊立永玄毛﹜肮r卞支月屯五﹝ ♂ 午中丹仇午反﹜5ヶ及方丹卅K俴釬I分午戊件白伉弁玄毛れ仇仄 支允仁卅月﹝ ♀ 杻卞赻蚕傖仄凶Java戊奈玉窒煦及戊件白伉弁玄 ♂ 午中丹仇午反﹜眻蹈卞仄井釬I匹五卅中ㄗ井手仄木卅中ㄘ 46 賃
- 47. #ccc_a1 DBFlute = 赻蚕傖戊奈玉毛戊立永玄允月ヶ枑 ♂ 瞰ㄩ坻及市仿丞井日妊騿Ｅ呾仄凶磐彆毛諵鴗諝蚰磳悒ぁㄓ礡 赻蚕傖仄凶巨件氾奴氾奴弁仿旦卞袚樓 ♂ 瞰ㄩ僕籵及WHERE曆毛瞎心蕾化眢仁允月凶戶卞帊齂齞汜 傖弁仿旦卞赻釬及丟末永玉毛袚樓 ㄗ淏復卞反樓遁蚚及輥創弁仿旦互丐日井元戶赻蚕傖今木月ㄘ 47
- 49. #ccc_a1 互兮氏﹜煦仃月屯五﹝ 49 RDB Repository Logic O/R穴永由奈 赻蚕傖仄凶entity 弁仿旦 玉丟奶件弁仿旦 /DTO 玉丟奶件弁仿旦 /DTO Controller 玉丟奶件弁仿旦 /DTO ♂ setter/getter匹華 耋卞戶杸尹 ♂ MapStruct, Dozer, etc 墿忭 墿忭卞 卅曰互切 戊伕戊伕 歹月
- 51. #ccc_a1 // jOOQ匹及市旦正丞瞰 public class FooPrefixGeneratorStrategy extends DefaultGeneratorStrategy { @Override public String getJavaClassName(final Definition definition, final Mode mode) { String name = super.getJavaClassName(definition, mode); switch (mode) { case POJO: return name + "Vo"; // 巨件氾奴氾奴弁仿旦反 BookVo.java卞卅月 case DEFAULT: return 'Foo' + name; // 丟正犯奈正弁仿旦反 FooBook.java卞卅月 } return name; } 51 ㄗ淏復卞反Tables弁仿旦及囀窒弁仿旦ㄘ
- 54. #ccc_a1 氾旦玄犯奈正反斛﹝仄井仄.... 54 ♂ 諾勻弔及氾奈皮伙匹失皿伉弗奈扑亦件及衿鰲_庲反匹五卅中 ♂ 氾旦玄犯奈正反嘐隅匹反卅中﹝杻卞楖間 ♀ ☆逃蚡陘帢鴃馱峇臚滮磥峊ワ`正互都卞 2018-12-15 分勻凶日ˋ
- 55. #ccc_a1 DBFlute及鷅 55 ＆replace-schema＊戊穴件玉互 1. 咫々峊ぅ`皮伙﹜奶件犯永弁旦毛 DROP -> CREATE 2. xls, tsv, csv白央奶伙互丐木壬氾旦玄犯奈正午仄化INSERT csv白央奶伙奻及 ※$sysdate.addDay(7)§ 反 戊穴件玉g俴r覦及7涫嶀互DB市仿丞卞諵
- 56. #ccc_a1 坻及源楊 56 A. RDBMS及csv, tsv及田伙弁伕奈玉C夔 a. 楖隊恘硌隅互褣仄中 B. INSERT恅毛蚚砩仄化g俴 a. 湮講及忒齯背NSERT恅互踏摽及DB銝卞騵尹日木月井? C. 奻A,B及甩奶皮伉永玉 a. csv匹諵鴗に楖階咱擖鄐柰PDATE恅 D. Flyway及Java-Based Migration a. DB隅膽銝蚚PJ午反ePJ午仄化氾旦犯奈正蚚PJ毛釬勻化云仁 b. SQL恅匹反卅仁Java戊奈玉毛釬勻化云仁 c. INSERT恅方曰反S﹝楖隊恘硌隅手褫夔﹝
- 57. #ccc_a1 Flyway鼠宒穴瓦亙失伙卞方月午 57 堤萎 *10 src/main/java/db/migration/V1_2__Another_user.java src/main/resources/db/migration/V1_3__HogeHoge.sql ./gradlew flywayMigrate 匹白央奶伙靡卞g俴今木月 伙奈皿仄化毛鉹角吨洶壈NSERT允木壬中中
- 59. #ccc_a1 DBFlute及鷅 ♂ 犯白巧伙玄匹仇氏卅覜元 ♀ SqlLogHandler匹今日卞井中秶郘手褫夔 59 堤萎 *5 磐彆犯奈正手堤化月 網太堤仄啋弁仿旦
- 61. #ccc_a1 O/R穴永由奈毛歹卅中源楊手丐月 ♂ JDBC玉仿奶田及笢輥ん午仄化歐P仄勾勾 g俴仄方丹午仄化中月SQL毛伕弘堤薯 ㄗ淏復卞反皿伉矢失玉旦氾奈玄丟件玄分仃及仇午互幻午氏升ㄘ ♀ p6spy ♀ log4jdbc 61
- 63. #ccc_a1 DBFlute及鷅 ♂ sql_calc_found_rows仁日中卅日犯 白巧伙玄 ♂ 俋堤仄SQL卅日卅氏匹手齯惜 ♂ 白巧奈穴永玄反2-Way-SQL ♂ 網太堤仄戊奈玉 ㄗWHERE曆及捼淕脹ㄘ手 赻蚕傖 63 堤萎 *7
- 68. #ccc_a1 SchemaSpy及鷅 ♂ jar毛眻諉g俴﹜丐月中反docker run (*11) ♂ ER矰甃蚕傖 68
- 70. #ccc_a1 ♂ 恚杅及O/R穴永由毛疑五卞髦兮化妏勻化﹜ 中中午仇升曰匹五凶日倷六﹝ ♂ 珨勾及Web/DB皿伕斥尼弁玄及嶱逃匹﹜ ㄡ勾眕奻及O/R穴永由奈毛髦兮化妏丹仇午反 o燴?﹜峉ˋ ♂ 玄仿件扒弁扑亦件奪燴尼尼... 70
- 72. #ccc_a1 72@Autowired OrderBhv orderBhv; // DBFlute @Autowired DSLContext dsl; // jOOQ @Transactional public void order(String isbn, Long memberId) { // 掛毛諵馱諝嵽膝疇 Order order = new Order(); order.setIsbn(isbn); order.setMemberId(memberId); orderBhv.insert(order); Book book = Tables.Book; dsl.update(book) .set(book.STOCK, book.STOCK.minus(1)) .where(book.ISBN.eq(isbn)) .execute(); } ♂ DBFlute匹INSERT ♂ jOOQ匹UPDATE ♂ 珨勾及玄仿件扒弁扑亦件 (BIGIN?﹛COMMIT) 匹g俴今木化中木壬OK DBFlute jOOQ
- 74. #ccc_a1 @Bean public javax.sql.DataSource dataSource() { // 戊生弁扑亦件皿奈伙C毛妏丹午仄化ㄗ仇仇匹反HikariCP) HikariConfig config = new HikariConfig(); config.setJdbcUrl(...); config.setUsername(...); config.setPassword(...); HikariDataSource ds = new HikariDataSource(config); // return ds; // ↘仇丹元扎卅仁化∣仇丹 return new TransactionAwareDataSourceProxy(ds); } 74 仄仁反 TransactionAwareDataSourceProxy 匹弘弘月﹝
- 75. #ccc_a1 引午戶 75
- 76. #ccc_a1 Java/DB嶱逃及踏升五及忒楊午汁奈伙 ♂ O/R穴永疋件弘仿奶皮仿伉 ♀ 末奈旦戊奈玉赻蚕傖卞方月正奶皿本奈白源宒 ♀ 俋窒SQL白央奶伙g俴源宒 ♂ g俴仄凶SQL及伕幼件弘 ♂ DB穴奶弘伊奈扑亦件及赻蚖 ♂ 氾旦玄犯奈正芘諵拵蚖 ♂ 氾奈皮伙隅膽齯拵衿鰴 ♂ 玄仿件扒弁扑亦件卞搕礞臚惜ね}杅及O/R穴永由奈毛肮r卞妏蚚 76 腢k眱午妏中源毛方仁窉庤仄化﹜伊永汁辦羥嶱逃ㄐ
- 78. #ccc_a1 統蕉恅瓬 1. Hibernate反升及方丹卞仄化佌及平乓伉失毛ぢ蝝褘陘豸楔縣 https://www.kaitoy.xyz/2017/02/23/how-hibernate-ruined-my-career/ 奻及埻恅 https://medium.com/@ggajos/how-hibernate-almost-ruined-16f31ba7d381 2. 扂〝反中井卞仄化撮胍腢k毛嶲綃尹凶及井? https://blog.cybozu.io/entry/2016/12/28/101500 3. https://groups.google.com/forum/#!msg/querydsl/fNFXliG8P-k/7dy2aAotVQ0J 4. https://blog.jooq.org/2014/05/29/querydsl-vs-jooq-feature-completeness-vs-now-more-than-ever/ 5. http://dbflute.seasar.org/ja/manual/function/genbafit/implfit/debuglog/index.html 6. https://www.jooq.org/doc/3.11/manual/sql-execution/logging/ 7. http://dbflute.seasar.org/ja/manual/function/ormapper/outsidesql/howto.html 8. https://www.jooq.org/doc/3.11/manual/sql-execution/query-vs-resultquery/ 9. https://www.jooq.org/doc/3.11/manual/sql-building/plain-sql 10. https://flywaydb.org/documentation/migrations#java-based-migrations 11. https://hub.docker.com/r/schemaspy/schemaspy/ 12. 78