2006-10-01ãã1ã¶æéã®è¨äºä¸è¦§
éå¤ã®ãä¾ã¯æè¿FF3ã ãã¡ãã³ã³ã®ããã¯ã¡ããã£ã¨ã ããã£ããªã¼ã¨æãã¤ã¤æãåºããã®ã ã ãããéãã®ããã£ã¨ä»æ´ãªããã«å®æã ãã¾ããå£å£«ãé ãã¸ã§ãã£ã¦ãªã«ãï¼ï¼ ããã¯ãã¦ããã æè¿ã®ç°å¢ã§ã¯DSææè ããã¦ãªãã®ã§ã ã ããæä¼ã£ã¦â¦
ãã®ï¼é±éã¡ãã£ã¨ã§ã¤ãã£ãããã°ã©ã ã 2ã¤ã®ç»é¢ã§ 2ã¤ã®ãã¡ã¤ã«ãåã込㿠3ã¤ã®ãã¼ãã«ã使ç¨ã æ¤ç´¢ãããã¼ã¿ãåºåããã¨ã VB.NET CSVã®Readerã¯ã©ã¹ãã¤ããã 使ç¨ãããã¡ã¤ã«ã®ããã¯ã¢ãããã¨ãã¯ã©ã¹ãä½ãã ãã¼ã¿ãã¼ã¹ã®æ¤ç´¢ç»é²æ´â¦
å¿ããã¯ç¶æ³ã«ãã£ã¦æç ´ãããã åæãããã¦æ®ºäººçã ã¨ã スケシï¾ï½ï½°ï¾ãããããªãã¨ãããããã¸ã§ã¯ã㯠æ¶ãã§ãããªã»ã©å¿ããã£ããããããã ãã ãããªãã«æ¦ãç²æããã£ãããããã ããã¸ã§ã¯ããæ¿æ²»çãªåã«ããè çããããããã¨ãã§ããã°â¦
æ°äººã§ãã£ã¦ãããã¾ãæéãã¨ããããã¨ãªãç¾å®ã®çµæãåºãäºã®æ¤è¨¼ã¿ãããªæè¿ãããã¾ããã 驿驿ãã¢ããã¼ã«ãããã°ã©ãã¨ãã¦ã¯æé«ã®çµæã«æçã®æé ã§ãã©ãçããããã«è¦å¡ä½å¶ãã¨ã£ã¦ããã¤ãããªä»ããã£ã¦ã ç»é¢ãã¶ã¤ã³ã¨ããã¾â¦
ãªãã¸ã§ã¯ãæåéçºãè¡ãéã«å¤§äºãªäºããã£ã¦ã 大äºãªäºãããããªããã°å¿ ç¶ã¨ãã¦ããªã¢ã«ãã£ãºã ã¯å®ç¾ã§ããã ãã®ããã«å¿ è¦ãªäºã 試è¡é¯èª¤ãçè«ç«ã¦ã¦å®è¡ãããã¨ã æåã¯ãã¡ãã失æãäºå®éãã¨ããã³ã³ãã大äºã ã¯ã©ã¹ãã¡ã½ããã®å½¹â¦
updateãinsertã¯ããèªä½ããå¦çãã§ãããå¦çã®å¼ã³åºããã§ãããããã¦ã ã¡ã½ããæ§æã¯queryToResultSetã¿ããã«å®å¦çå¼ã³åºãåã«ãªãã ï¼ã¯ã©ã¹ç·¨ï¼ (1)1ã¤ã«ä»ã1種é¡ããå½¹å²ãæããªãã¯ã©ã¹ (2) (1)ãããã¤ãã¾ã¨ãã¦ããã ãã®ã¯ã©ã¹ ã®å½¹â¦
ä»ã¾ã§ä½ã£ãã½ã¼ã¹ã¯ã©ãã¾ã§ãã£ã¦ããåå¼·ã¬ãã«ã®ããã®ãã®ã§ã å®åã«ã¯è¶³ããªãæ©è½ãããªãã updateãinsertãdeleteãªããã«ã±ã©ããªãããã Select1種é¡ã«ã¤ã1ã¯ã©ã¹ã£ã¦ã®ãç¾å®çã§ã¯ãªãããã ãããããµã³ãã«ã«ã¯ä¸ã¤çåãæ®ã£ã¦ããã(â¦
ã¡ã½ããã®ã¿ã§æ§æãããããã¤ã¯ã¾ã 夿 æ§ã®ã«ã±ã©ãããªãã åä¸ã®ã¡ã½ããããå¯ä¸ã®å½¢æ ããåããªãã®ã¯ãããã§ããã£ã¦ãã¨ã§ã ã¯ã©ã¹ãç¨æãã¦ã¿ãã ï¼ã¯ã©ã¹ç·¨ï¼ (1)1ã¤ã«ä»ã1種é¡ããå½¹å²ãæããªãã¯ã©ã¹ (2) (1)ãããã¤ãã¾ã¨ãã¦ããã â¦
ããã§åºæ¥ä¸ãã£ã以ä¸ã®ã¡ã½ããéã queryToResultSet(); createSQL(); executeQuery(); arrangesData(); ã©ã®è¾ºããããªã¢ã«ãã£ãºã ãã¨ããã¨ããqueryToResultSet()ããããã ãcreateSQL()ãã§è¿ãããSQLã¯ä½ãã¯ç¥ããªããç¥ããªãã¦ãããã ãeâ¦
æ¨æ¥ã®ã¨ã³ããªã§æ¸ãããããªãã¨ãè¸ã¾ãã¦ãµã³ãã«ãä½ã£ã¦ã¿ãäºã«ãã¾ããã ï¼ã¡ã½ããç·¨ï¼ (1)1ã¤ã«ä»ã1種é¡ããå½¹å²ãæããªãã¡ã½ãã (2) (1)ãããã¤ãå¼ã³åºãã ãã®ã¡ã½ãã è»ã¨ããã¬ãã¨ãã«ä¾ããããããªãã¸ã§ã¯ãæåã¨ã¯ãã¨ããã¡ã¿â¦
ã¢ãã©ã¼ã¯ãã¤ãæ½è±¡çãªç¾å®ããèªããªãã æ¦å¿µãªãã ããããã¼ããã¼ã ã ã£ã¨è¨ããããããããªããã å®éåé¡ä½¿ã人ãã¡ãçè§£ã«è¦ããã®ã§ããã° æä¾å´ã¯ãã¡ã£ã¨èããã¹ãã§ããã ã¦ã¼ã¶ãè¦ãããã®ããã³ãã®ä»äºãï¼ã£ã¦ãã¨ã«YesYesYesã¨â¦
ããäº æè¿ããããã¡ã½ããã¨ãã¯ã©ã¹ã®ã³ã¡ã³ããå ¨ãæ¸ããªãäºã¯ãªãã æ£ç¢ºã«ã¯è¨è¿°ããªãå½¢ã§æ¾ç½®ãããäºããªãã ãªããï¼ ã³ãããã¼ã«ãã³ã¶ã¤ã ããã§ããã ã¡ã½ããã®ã¹ã±ã«ãã³ãã³ããã§å®ç¾©ããã 1ããæ¸ããªãã¦ããããæä½éã¯åå¨ããâ¦
ä»é±ãæ©ããéææ¥ãéãã¦ãã¾ãã¾ããã å¿ããå¿ããã ãã£ãã¾ã§ä½ã£ã¦ããããã°ã©ã ã ããããã«ã¿ãã«ãªã£ããªã£ãã 2ã¶æåã«åå°ãä½ãã æ§ã ãªäºæ ã§æè¿ã¾ã§å éãã«ãªã£ã¦ããã ãããçä»ããã¨ã ã¨ã¯ãã£ã¦ãã¾ã ã客ãã確èªãããã®â¦
ã¯ã¦ãã¦ã å¹³åãªã¯ãã®ããã¸ã§ã¯ããè¨è¨ã¨ï½½ï½¹ï½¼ï¾ï½ï½°ï¾ã§å¤§å¤ãªãã¨ã«ãªãããã ã é ç®ã¦ãããããªç»é¢ã¯ããã ãã§ä½æãå°é£ã«ãªãã ãã¹ãæéãå¢ããã ( ´Ðï½)/å çï¼ 200é ç®ããã¾ããã ãããªç»é¢ãã´ãã´ããã¦ãã£ã¦ã©ã¼ãªã®ãã ã£ã¨ãã¿ãã¿â¦