JavaRush ã®åŠçã®äŸ¿å®ãå³ããããããã°ã©ãã³ã°ã®æãéèŠãªãããã¯ã«é¢ããè¬çŸ©ãšèšäºãåéããããšã«ããŸããã11 çªç®ã®ã»ã¬ã¯ã·ã§ã³ã¯ãããŒã¿ããŒã¹ãš SQL ã¯ãšãªèšèªã«é¢ãããã®ã§ããããã¬ã€ãã§ã¯èšäºã®èŠç¹ãç°¡åã«èª¬æããŠããããªã³ã¯ãã¯ãªãã¯ãããšãé¢å¿ã®ãããããã¯ã«ã€ããŠè©³ããç¥ãããšãã§ããŸããã³ã¬ã¯ã·ã§ã³ãããã¯ããŒã¯ã«è¿œå ããå¿
èŠãªãšãã«æ»ã£ãŠãã ããã
èšäºãšè¬æŒ
ãã®èšäºã§ã¯ãJava ã§ã®ããŒã¿ããŒã¹æäœã®åºæ¬ãš SQL èšèªã®æŠèŠã«ç¹åããçãã·ãªãŒãºãéå§ããŸããå€ãã®ããã°ã©ã ã¯ãæ
å ±ã®åŠçãšå€æŽãããã³æ
å ±ãææ°ã®ç¶æ
ã«ä¿ã€ã®ã«å¿ããã§ããããŒã¿ã¯ããã°ã©ã ããžãã¯ã®éåžžã«éèŠãªéšåã§ãããããå€ãã®å ŽåãããŒã¿çšã«å¥ã®ã¹ãã¬ãŒãžãå²ãåœãŠãããŸããããŒã¿ã¯ãç¹å¥ãªã¯ãšãªèšèªã§ãã SQL (Structured Query Language) ã䜿çšããŠã¢ã¯ã»ã¹ããã³å€æŽãããŸãããã®èšäºã¯ãããŒã¿ããŒã¹ã䜿ãå§ããã°ããã®å Žåã«åœ¹ç«ã¡ãŸãã
ããã¹ãã®ãã® 2 çªç®ã®éšå㯠SQL ã®æŠèŠã«ã€ããŠã§ããããã§èè
ã¯ã蚌åžååŒæãšãã¥ã¬ãŒã¿ã®äœæãäŸã«ãããŒã¿ããŒã¹ãš SQL ã®åäœåçãåæãç¶ããŸãã
ç¬èªã®ããŒããã©ãªãª ãããžã§ã¯ãã®äœæã«é¢ãã倧èŠæš¡ãªèšäºã·ãªãŒãºãåœç¶ã®ããšãªããã圌ã¯ããã°ã©ããŒãæäœããããŸããŸãªãã¯ãããžãŒãç解ããŠããŸããããŒã¿ããŒã¹ãš SQL èšèªãå«ãŸããŸããèšäºã®çµæãšããŠé»å ±ããããäœæãããŸãã
2 çªç®ã®éšåã§ã¯ãèè
ã¯å®è·µã«çŠç¹ãåœãŠãŸãããMySQL ã®ã€ã³ã¹ããŒã«ããã®èšèªã§ã®æåã®è¡ã®èšè¿°ãæåã®ããŒã¿ããŒã¹ã®äœæã«é¢ããã¬ã€ãã³ã¹ãæäŸããŸããæåŸã«ã¯å®¿é¡ãåºãŸãã
ããŒã¿ããŒã¹åæã® 3 çªç®ã®éšåã§ã¯ãèè
㯠SELECT æŒç®åãWHEREãORDER BYãGROUP BY ãã©ã¡ãŒã¿ãŒã«ã€ããŠèª¬æããŸããæåŸã«ã¯ããããŸã§ãšåæ§ã«å®¿é¡ãåŸ
ã£ãŠããŸãã
ååã瀺ãããã«ã第 4 éšå
šäœã¯å®¿é¡ã®åæã«åœãŠãããŸããèªãããšããå§ãããŸãããã®ã¿ã¹ã¯ã¯èå³æ·±ãã®ã§ãå®è¡ããŠã¿ããšããã§ãããã
第 5 éšã§ã¯ãæ¥ç¶ãšçµåã®çš®é¡ã«ã€ããŠèª¬æãã1 察å€ã1 察 1ãå€å¯Ÿå€ããã®ä»ã®æŠå¿µã«ã€ããŠèª¬æããŸãã
ããŒã¿ããŒã¹ã«é¢ãããã®æåŸã®èšäºã§ã¯ãæåŸã®å®¿é¡ã«ã€ããŠèª¬æããŸããäžçŽã¬ãã«ã®é¢æ¥ã察象ãšããŠããã®ã§èå³æ·±ãã§ããã€ãŸãããã®ã¿ã¹ã¯ã®åŸããã§ã«é¢æ¥ã«è¡ãããšãã§ãããªã¬ãŒã·ã§ãã« ããŒã¿ããŒã¹ã«é¢é£ããå
容ã®å°ãªããšãäžéšã«åæ Œããããšãã§ããŸãã
SQL ãåããŠåŠã¶ã®ã«é©ããæžç±ã¯æ°å€ããããŸããããã®æçš¿ã®èè
ã¯ãSQL. ã¬ã·ãéãã¢ã³ãœããŒã»ã¢ãªããèããã®æ¬ã®ç¹åŸŽã¯ãSQL ãåºæ¬ã¬ãã«ã§åŠç¿ããããšã«å ããŠãäžåºŠã«è€æ°ã®ããŒã¿ããŒã¹ã«æ
£ãããããã®ã¯ãšãªãã©ã®ããã«ç°ãªãããç¹å®ã®ããŒã¿ããŒã¹ã®ç¹åŸŽãäœããç解ã§ããããšã§ãã
Lukas Eder ã®èšäºãæ¹å€ãããã®ãæäŸããŸãããã®èšäºã¯ãããŒã¿ããŒã¹ãš SQL ã«ã€ããŠã®äžè¬çãªç解ãšãDBMS ã®å®è·µçµéšããã人åãã«èšèšãããŠããŸããããã§ã¯ãã¡ã¿ããŒã¿ (ã€ãŸããå¶çŽ) ãšã¯ãšãªèªäœã«ã®ã¿åºã¥ããŠå®è£
ã§ãã 5 ã€ã®ç°¡åãªæé©åã«ã€ããŠèª¬æããŸãã
ããŒã 2 ã§ã¯ãEXISTS ãµãã¯ãšãªå
ã®ãæå³ã®ãªããè¿°èªãšå°åœ±ãåé€ããæ¹æ³ã«ã€ããŠåŠã³ãŸãã
ãã®èšäºã® 3 çªç®ã®éšåã§ã¯ãè¿°èªãšèšŒæå¯èœãªç©ºã®ã»ããã®ããŒãžã«ã€ããŠèª¬æããŸãã
4 çªç®ã®éšåã§ã¯ãCHECK ãšäžå¿
èŠãªååž°çµåã®å¶éã«ã€ããŠèª¬æããŸãã
èšäºã®æåŸã®éšåã§ã¯ããªããžã§ã¯ãã®ããã·ã¥ãªã©ã®æé©åã«ã€ããŠèª¬æããŸãã
ããã¯ãšã³ãéçºãšããã°ããŒã¿ã®ãã¬ã³ããè¿œã£ãŠãã人ãªããããæ°å¹Žã® NoSQL ããŒã¿ããŒã¹ã«é¢ãã話é¡ã«ãã§ã«æ°ã¥ããŠããã§ãããããã®èšäºã§ã¯ããããããªãããŒã¿ããŒã¹ãäœæãããã®ããã©ã®ãããªåé¡ã解決ããã®ãããããŠãªãããã»ã©å€ãã®ç°ãªãããŒã¿ããŒã¹ãçªç¶å¿
èŠã«ãªã£ãã®ãã«ã€ããŠèª¬æããŸãã
ãããããå¹æç㪠SQL ã¯ãšãªãäœæããããã«åŠã¶ããšãã§ããæãéèŠãªããšã¯ãã€ã³ããã¯ã¹äœæã§ãããããããã®ããåŸãã® 2 äœã¯ãå€ãã® SQL ã¯ã©ã€ã¢ã³ããããŒã¿ããŒã¹ã«å€ãã®ãäžå¿
èŠã ãå¿
èŠãªäœæ¥ããèŠæ±ããŠãããšããç¥èã§ãããããäœã§ãããã«ã€ããŠã¯ããã®èšäºã§èª¬æããŸãã
ããŒã¿ããŒã¹ãäœæããRest ã¢ããªã±ãŒã·ã§ã³ã«æ¥ç¶ããæ¹æ³ã«é¢ããäžé£ã®èšäºã
æåŸã®ããŒãã§ã¯ãã³ã³ãã¥ãŒã¿ãŒã« PostgresSQL ããŒã¿ããŒã¹ãã€ã³ã¹ããŒã«ããæ¹æ³ãpgAdmin ã§ããŒã¿ããŒã¹ãäœæããæ¹æ³ãããã³ãã®ããŒã¿ããŒã¹å
ã®ããŒãã«ãæåããã³ããã°ã©ã ã§äœæããã³åé€ããæ¹æ³ãåŠã³ãŸããããã®ããŒãã§ã¯ãèè
ã¯èªè
ã«ããã®ããŒã¿ããŒã¹ãšããŒãã«ã®æäœæ¹æ³ãåŠç¿ã§ããããã«ããã°ã©ã ãæžãçŽãããå§ããŸãã
ãã®èšäºã§ã¯ãèè
ãæè¡é¢æ¥ã®éèŠãªãããã¯ã® 1 ã€ã§ããããŒã¿ããŒã¹ã«ã€ããŠè©±ããŸããæãäžè¬çãªè³ªåãæ€èšããå
容ãæ·±ãæãäžããããšãªãããããã«çããããšããŸãã
Hibernate ã¯ãããã°ã©ããŒã®äœæ¥ã楜ã«ããããã«çºæããããã¬ãŒã ã¯ãŒã¯ã§ããéè€ããã³ãŒããæé€ãããªãœãŒã¹ã®ç®¡çã«å¿
èŠãªã³ãŒããé衚瀺ã«ããŠããšã©ãŒãæžãããŸããHibernate ã䜿çšããããšã§ãéçºè
ã¯ã¢ããªã±ãŒã·ã§ã³ã®ããžãã¹ ããžãã¯ã«éäžã§ããŸããåºæ¬çã«ãHibernate ã¯ã¢ããªã±ãŒã·ã§ã³ãããŒã¿ããŒã¹ã«æ¥ç¶ãããšãã«ã¢ããã¿ãŒãšããŠæ©èœããŸãããã®ãã¬ãŒã ã¯ãŒã¯ã®éèŠãšãã©ã®ãããªãããžã§ã¯ãã«å¿
èŠã«ãªããã«ã€ããŠã®èšäºããèªã¿ãã ããã
åç»
Java éçºã¯ããã¯ãšã³ããšåãé¢ããªãé¢ä¿ã«ãããŸãããããŠããã¯ãšã³ãã¯ããŒã¿ããŒã¹ã§ããããŒã¿ããŒã¹ã«é¢ããããšã質åãããå¯èœæ§ã®ããæè¡é¢æ¥ã§åé¡ã«çŽé¢ããããªãå Žåã¯ããã® Podlodka Backend Crew ããŒã¿ããŒã¹ ãã¹ã ã€ã³ã¿ãã¥ãŒ ã¹ããªãŒã ãã芧ãã ãããããŒã¿ããŒã¹ã®æäœçè«ãšãSQLãNoSQLãNewSQL ãªã©ã®æãäžè¬çãªããŒã¿ããŒã¹ããšã«å
·äœçãªæè¡ãœãªã¥ãŒã·ã§ã³ãåŠã³ãŸãã
MongoDB DBMS ã䜿çšã㊠IntelliJ IDEA ãããžã§ã¯ããã¢ããŸã³ ãŠã§ã ãµãŒãã¹ ã¯ã©ãŠãã«æ¥ç¶ããã«ã¯ãIDE ã®ã¹ãã«ã ãã§ã¯ååã§ã¯ãããŸãããéçºç°å¢ã«å ããŠãåæãŸãã¯éåæã® MongoDB ãã©ã€ããŒãMongoClient ã¯ã©ã€ã¢ã³ãã®æäœæ¹æ³ãããã³ã³ã¬ã¯ã·ã§ã³ã®æäœæ¹æ³ãåŠç¿ããå¿
èŠããããŸãããã®ãããªã§ã¯ãããŒã¿ããŒã¹ã Java ãããžã§ã¯ãã«æ¥ç¶ããããã«å¿
èŠãªãã¹ãŠã®æé ã説æããŸãããããªã®äžã®èª¬æã«ã¯ãIntelliJ IDEA ã®ãããžã§ã¯ã ã³ãŒããžã®ãªã³ã¯ããããŸãã
ã·ãªãŒãºã®ä»ã®çŽ æ: |
|
GO TO FULL VERSION