
- WebããŒã±ãã£ã³ã°
- 2021.07.25
ããã«ã¡ã¯ãããªãŒã©ã³ã¹ãšã³ãžãã¢å Œããã¯ã©ã€ã¿ãŒã®ãã(@siro3460)ã§ãã
çããã¯ãã¢ããªéçºãããããšããããŸããïŒ
ãããã°ã©ãã³ã°ã®åºç€ã¯åŠãã ãã©ãã¢ããªéçºã«ã¯ãŸã ææŠããããšããªãã»ã»ã»ããšããæ¹ãããã®ã§ã¯ãªãã§ããããã
ãã ãããã°ã©ãã³ã°åŠç¿ã®æµãã§ã¢ããªéçºãå§ããŠããŸããšã»ã»ã»éäžã§æãæ¢ãŸã£ãŠããŸã人ãçµæ§å€ãã§ããã¢ããªéçºããããšãã¯ããããªãã³ãŒãã£ã³ã°ã«ç§»ãåã«ãç°¡åã§ãããã®ã§ã¢ããªèšèšãããããšãããããã§ãïŒ
ããã§ä»åã¯ããã¢ããªéçºãã¹ã ãŒãºã«é²ããããã®ã¢ããªèšèšãã«ã€ããŠè§£èª¬ããŸãã
â»ãã¡ãã®èšäºã¯ãé£èŒèšäºã§ããååã®èšäºãèŠãŠãªãæ¹ã¯ä»¥äžããã©ããã
â é£èŒèšäºãŸãšã
ã»ããã°ã©ãã³ã°ã®åŠã³æ¹è¬åº§vol.1ãããã°ã©ãã³ã°ã楜ããã»å¹çããåŠã¶ã³ãã解説ïŒã
ã»ããã°ã©ãã³ã°ã®åŠã³æ¹è¬åº§vol.2ãããã°ã©ãã³ã°ã§æ«æããªãããã®ç®æšèšå®ã®ã³ãã
ã»ä»æ¥ããå³å®è·µå¯èœïŒåå¿è
ãåŠç¿å¹çãé£èºçã«äžæããã5ã€ã®ç§èš£ïŒ â ããã°ã©ãã³ã°ã®åŠã³æ¹è¬åº§vol.3
ã¯ããã«ãã¢ããªèšèšãããŠããå®è£ ããæ¹ãè¯ãçç±ã«ã€ããŠè§£èª¬ããŸãã
1ã€ç®ã®çç±ã¯ãéçºã®çµãããèŠããªããªã£ãŠããŸãããã§ãã
ããã°ã©ãã³ã°åŠç¿ã®æå³ããããŠãæé床å€èŠã§ãšã«ãããŸãã¯äœã£ãŠã¿ãããšããã¡ãã倧äºã§ããçŸæç¹ã®ã¹ãã«ã確èªããããšãã§ããŸãããäœãããšãåªå ããã°ããã°ã©ãã³ã°ã«éäžã§ããã®ã§ã楜ãããããããŸããããã ãäœãèšèšããã«äœãå§ããŠããŸããšããŽãŒã«ãèŠããªããªã£ãŠããŸããŸãã
äœã£ãŠãããã¡ã«æ©èœã远å ããããªã£ããããã¶ã€ã³ã«åããããŠæéãããããããŠããŸã£ããããã€ãŸã§ãã£ãŠãéçºãçµãããªããªã£ãŠããŸãã®ã§ãã
ããçšåºŠèªåã§èšèšããŠããã€ããã¯ãããããšã§ã宿ãç®æãããšãã§ããŸãã
æåããå®ç§ãç®æããŠæ©èœãã©ãã©ãå¢ããããšããããã·ã³ãã«ã§ãããã®ã§èªåã§èšèšããŠå®æãããããšã倧äºã§ãã
2ã€ç®ã®çç±ã¯ãå·¥æ°ã®èŠç©ãããã§ããçŸå Žã§èŠåŽããŠããŸãããã§ãã
èšèšãããã«éçºãå§ããŠããŸã£ãå Žåã¯ãã©ã®ãããæéãããããèŠç©ããããšãã§ããªãã§ããããã©ããŸã§éçºãé²ããããäœãã¢ããªã®å šè²ãèŠããŠããªããããæéãèŠç©ãããšãã§ããŸããã
ãäœãçµãã£ãåŸã«çµæè«ãšããŠãããæéããã£ãããšããå Žåã§ããæ©èœãèããæéãå«ããæéã«ãªã£ãŠããŸããŸãããããã®ãããæ£ç¢ºã«ã©ã®ãããéçºã«æéãããã£ãŠããã®ããææ¡ããããšãé£ããã§ãã
æ©èœãäžèЧåããç»é¢ã€ã¡ãŒãžã詳现ãªåŠçãèšèšããŠããããšã§ãåããŠãããæéãæ£ç¢ºã«æ®ãããšãã§ããã®ã§ãã
ä»åŸãšã³ãžãã¢ã»ããã°ã©ããŒãšããŠä»äºããŠããäžã§ã¯ããæ©èœãå®è£ ããããã®å·¥æ°ãèŠç©ããã¹ãã«ãããã¡ããã¡ãéèŠã§ãã
ãããžã¡ã³ããã人ããã¡ã³ããŒã®ã¹ãã«ãå®ç§ã«çè§£ããŠãããšã¯éããŸãããã©ã®ãããæéãããããããã¡ã³ããŒãšçžè«ããŠãå šäœã®ã¹ã±ãžã¥ãŒã«ã確èªããªããææ¥ã決ããŠããã®ã§ãã
ãã®ãããèªåã§æ£ç¢ºã«èŠç©ãããã¹ãã«ããªããšãèªåã§èªåã®éŠãçµããŠããŸãããšã«ãªããããŸããã
ã»ç°¡åãªèšèšãäœã£ãŠããéçºããçµéš
ã»èšèšããéçºå·¥æ°ã®äºæž¬ãç«ãŠãŠããéçºããçµéš
ã»ç«ãŠãäºæž¬ãšããã£ãæéãæ¯èŒããŠãèªåã®å®åãèŠæ¥µããŠããçµéš
ããããã¢ããªéçºãéããŠéããŠããããšã§ãæ°ããæè¡ãç°å¢ã§éçºããããšãã§ããæè»ã«å¯Ÿå¿ã§ããããã«ãªãã®ã§ãã
ã§ã¯ãã¢ããªéçºã§ã¯äœãèšèšããŠé²ããŠããã°ããã®ã§ããããã
çµè«ããèšããšãæäœé以äžãèããŠäœã£ãŠããããšãããããã§ãã
ã»ã¢ããªã®æŠèŠ
ã»æ©èœäžèЧ
ã»ç»é¢ã€ã¡ãŒãž
ã»ç»é¢é·ç§»ã€ã¡ãŒãž
ã»åŠç詳现
ä»åã¯ãããããã解説ããããã«ãç°¡åãªãã¿ã¹ã¯ç®¡çã¢ããªããããšã«è§£èª¬ããŠãããŸããã
ãŸããç°¡åã«ã¢ããªã®æŠèŠãäŒç»ããŠãããŸãã
ä»äºã§ã¢ããªéçºãããšãã¯ã¯ã©ã€ã¢ã³ãããèŠæããã¢ãªã³ã°ããŠãããŸãããèªåã§äœãå Žåã§ããç°¡åã«æŠèŠããŸãšããŠã¿ãŸãããã
ã»ç»é²ããã¿ã¹ã¯ã¯ãç»é²ãã©ãŒã ã®ããäžã«ããããŒã¿äžèЧãã確èªãã§ãã
ãã®ããã«ããŸãã¯ãã£ãããšã§ããã®ã§æŠèŠãèããŠãããŸãã
ã¢ããªã®æŠèŠãã§ããããæ©èœäžèЧãèããŠãããŸãããã
ä»åã¯ãç»é²ã»æŽæ°ã»åé€ã»ããŒã¿æ€çŽ¢ãããã¢ããªãªã®ã§ãæ©èœäžèŠ§ã¯æ¬¡ã®ããã«èããŠã¿ãŸããã
ã»ã¿ã¹ã¯ã®æŽæ°æ©èœ
ã»ã¿ã¹ã¯ã®å逿©èœ
ã»ã¿ã¹ã¯ã®æ€çŽ¢æ©èœ
ã»ã¿ã¹ã¯ã®ããŒã¿äžèŠ§è¡šç€ºæ©èœ
ãããŸã§ã§ããããæ¬¡ã«ç»é¢ãèããŠãããŸãã
ç»é¢ã€ã¡ãŒãžãèãããšãã¯ãæ¬¡ã®æµãã§èããŠããããšãããããã§ãã
ã»æ©èœåäœã§ç»é¢ãã€ã¡ãŒãžãã
ã»åãç»é¢ã§å®çŸã§ããæ©èœãããã°äœµçšãã
ãŸãã¯ãæ©èœåäœã§ç»é¢ãèããŠãããŸããä»åã¯ã以äžã®ããã«èããŠã¿ãŸããã
ã»ã¿ã¹ã¯ç»é²ç»é¢
ã»ã¿ã¹ã¯æŽæ°ã»åé€ç»é¢
ã»ã¿ã¹ã¯æ€çŽ¢ã»ããŒã¿äžèЧç»é¢
ãã ãç»é²ç»é¢ãšæŽæ°ã»åé€ç»é¢ã¯äŒŒãŠããŸãããããã®ããã«ãå¥ã ã®ç»é¢ã§äœããªããŠãããã¿ã³ã®è¡šç€º/é衚瀺ã®ã¿ã§å¯Ÿå¿ã§ããå ŽåããããŸãã
ç»é¢ãèãããšãã¯ãç»é¢åäœã§äœµçšã§ããç»é¢ããªããèããŠããããšãéèŠã§ãããããªããããŸã§èããããšãé£ããå Žåã¯ãäœããªããã§ãæåã¯æ§ããŸãããæ £ããŠããããç»é¢ã®ã€ã¡ãŒãžãããã£ãã¿ã€ãã³ã°ã§èããŠã¿ãŠãã ããã
ãããŸã§ã§ãããå®è£ ã«ç§»ãã»ã»ã»åã«ãç»é¢é·ç§»ã€ã¡ãŒãžãåºããŠããããšãããããã§ãã
å ·äœçã«ã¯ãç»é¢ã®ãã¿ã³ã»ãªã³ã¯ãªã©ãã¯ãªãã¯ãããšãã«è¡šç€ºãããç»é¢ã®åããå³ã«ããŠãããŸããããšãã°ã次ã®ããã«ç»é¢ãç·ã§ã€ãªãã§è¡šçŸããŸãã
ã©ã®ãã¿ã³ãæŒãããšãã«ãäœã®ç»é¢ã衚瀺ããããã€ã¡ãŒãžãæ¹§ããŸããããããã®ããã«ãã¢ããªãæäœãã€ã¡ãŒãžãã€ã€ç»é¢é·ç§»ãèããŠãããŸãã
ãããŸã§ã§ããããç»é¢ããšã®è©³çްãªåŠçãèããŠãããŸãã
ä»åã¯ãããŒã¿ç»é²ã»æŽæ°ã»åé€ã®æ©èœã«ã€ããŠã詳现ãªåŠçãèããŠãããŸããã
ããŒã¿æŽæ°ç³»ã®åŠçãäœããšãã¯ãå ¥åãã§ã㯠â ããŒã¿æŽæ°ãã®æµããåºæ¬ãªã®ã§ããã®ããããå«ããŠæ¬¡ã®ããã«èšèšããŠãããŸãã
â¡æŽæ°ãã¿ã³ã¯ãªãã¯æã®åŠç
1. å
¥åãã§ãã¯
1-1. ç»é¢ã®å
¥åé
ç®ã倿°ã«ã»ãã
1-2. å¿
é é
ç®ãã§ãã¯
1-2-1.æªå
¥åé
ç®æãïŒãšã©ãŒã¡ãã»ãŒãžã衚瀺ããŠåŠçãæ¢ãã
1-2-2.æªå
¥åé
ç®ç¡ãïŒåãã§ãã¯ã«é²ã
1-3. åãã§ãã¯
1-3-1.æ¥ä»ã«æ¥ä»å以å€ã®å€ãå
¥ã£ãŠããå ŽåïŒãšã©ãŒã¡ãã»ãŒãžã衚瀺ããŠåŠçãæ¢ãã
1-3-2.åäžäžèŽã®å€ãªãå ŽåïŒããŒã¿ããŒã¹æŽæ°åŠçã«é²ã
2. ããŒã¿ããŒã¹ã®ããŒã¿ãæŽæ°ãã
2-1. ããŒã¿ããŒã¹ã«çŽã¥ãIDåãç»é¢ã®å
¥åé
ç®ãåŒæ°ã«ãããŒã¿æŽæ°ããåŠçãå®è¡
2-1-1. æåããå Žåã¯ãæŽæ°å®äºã¡ãã»ãŒãžã衚瀺ããŠç»é¢ãéãã
2-1-2. 倱æããå Žåã¯ããšã©ãŒã¡ãã»ãŒãžã衚瀺
â¢åé€ãã¿ã³ã¯ãªãã¯æã®åŠç
1. åé€ç¢ºèªã¡ãã»ãŒãžã衚瀺
1-1. ãåé€åŸã¯ããŒã¿ãæ»ãããšãã§ããŸãããããŒã¿ãåé€ããŠãè¯ãã§ããããããã®ã¡ãã»ãŒãž + OK/NGã®ãã¿ã³ã衚瀺
1-1-1. OKãã¿ã³ãæŒããå Žåã¯ã2ã®ããŒã¿åé€åŠçã«ç§»å
1-1-2. NGãã¿ã³ãæŒããå Žåã¯ãåé€ç¢ºèªã¡ãã»ãŒãžãéãã
2. ããŒã¿ããŒã¹ã®ããŒã¿ãåé€ãã
2-1. ããŒã¿ããŒã¹ã«çŽã¥ãIDåãåŒæ°ã«ãããŒã¿åé€ããåŠçãå®è¡
2-1-1. æåããå Žåã¯ãåé€å®äºã¡ãã»ãŒãžã衚瀺ããŠç»é¢ãéãã
2-1-2. 倱æããå Žåã¯ããšã©ãŒã¡ãã»ãŒãžã衚瀺
ãã®ããã«ãå®è£ ãããšãã«äœãäœã£ãŠããã°ãããããããããªã¬ãã«ã§ãå ·äœçã«äœãåŠçãèšèšããŠãããŸãã
ãããŸã§èšèšãã§ããã°ãããšã¯äœã£ãŠããã ãã§ãã
èšèšããŠéçºãããšãã¯ãèŠç©ãã¹ãã«ãéããããã«ãå®è£ å®äºãŸã§ã®èŠèŸŒã¿æé + å®è£ åŸã«ããã£ãæéããã¡ã¢ããããšãããããã§ãã
ããã¹ãã§ããExcelã§ãäœã§ãæ§ããŸãããèªåã§èŠããããããªãã®ã§OKãªã®ã§ãã¡ã¢ããçãã€ããŸãããã
äºåã«äºæ³ããŠããèŠç©ããšæ¯èŒããããšã§ãèŠç©ã粟床ãã©ãã©ãäžããŠããããšãã§ããŸãã
ãŸããã¡ã¢ããŠããããšã§å®¢èгçã«èªåã®çµéšãæµ ãéšåãèŠããŠããŸãããã®äŸã§ã¯ããŒã¿ç»é²åŠçã«45åããã£ãŠããã®ã§ãDBãŸããã®ç¥èãæµ ããããããŸããã
SQLã«ã€ããŠåºç€ã埩ç¿ããããæ¬ãè²·ã£ãŠåŠç¿ãé²ããããšã§æ©ãå®è£ ã§ããããã«ãªããŸãã
ãã®ããã«ãèªåã客芳çã«åæããäœãåŠã¶ã¹ããèŠæ¥µããŠããããšãéèŠã§ããæ¯ãè¿ãã§ããããã«ããããã«ããã¡ã¢ããŠãããšè¯ããããããŸãããã
ä»åã¯ãã¢ããªéçºãã¹ã ãŒãºã«é²ããããã®èšè𿹿³ã«ã€ããŠã話ãããŸããã
æ £ããªããã¡ã¯èŠæŠãããããããŸããããèšèšããŠããã¢ããªãäœããã¹ãã«ã¯ãšãŠãéèŠã§ãã
ãã²ãèšèšããã¢ããªéçºã«ææŠããŠã¿ãŠãã ãããïŒ