[B! DAO] aritekuã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

ariteku id:ariteku

DAOã«é–¢ã™ã‚‹aritekuã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (8)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

ç‹¬æ–ã¨åè¦‹ã«ã‚ˆã‚‹Struts2ã§ã®DBã‚¢ã‚¯ã‚»ã‚¹ã®å®šçŸ³ - yamagu Wiki*
æ³¨æ„ï¼šæœ€æ–°ã®æƒ…å ±ã«ã¤ã„ã¦ã¯2007-12-07ã‚‚ãŠèªã¿ãã ã•ã„ã€‚ æ¦‚è¦: Struts2ã§ã¯ã€ActionFormãªã©ã‚’ç”¨ã„ãªãã¦ã‚‚Formã‚’æ‰‹è»½ã«åˆ©ç”¨ã™ã‚‹ä»•çµ„ã¿ãŒç”¨æ„ã•ã‚Œã¦ã„ã‚‹ã€‚ãŸã¨ãˆã°ã€http://bar/foo.action?id=0001ã¨ã„ã†ãƒªã‚¯ã‚¨ã‚¹ãƒˆã¯ã€Strutsã§ã¯ã€Œfoo.actionã®setId("0001")ã‚’å‘¼ã¶ã€ã¨ã„ã£ãŸå‡¦ç†ã¨ã—ã¦å®Ÿè¡Œã•ã‚Œã€person.account.id=0123ã§ã‚ã‚Œã°ã€Œfoo.actionã®getPerson().getAccount().setId("0123")ã‚’å‘¼ã¶ã€ãŒå®Ÿè¡Œã•ã‚Œã‚‹ã¨ã„ã£ãŸå…·åˆã ã€‚ ã—ã‹ã—ã€ãã‚Œã‚’ãƒ™ã‚¿ã«å®Ÿè£…ã—ã¦ã—ã¾ã†ã¨ã€ActionãŒSetterã‚„Getterã ã‚‰ã‘ã«ãªã£ã¦ã—ã¾ã„ã€DAOã‚„ã‚‰ä½•ã‚„ã‚‰ã¨ã”ã¡ã‚ƒã¾ãœã«ãªã£ã¦ã—ã¾ã†ã€‚ãã“ã§ã€ModelDrivenã‚’ä½¿ã£ã¦Actionã¨ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«ã®åˆ†é›¢ã‚’å›³ã‚‹ã®ãŒè‰¯ã•ãã†ã ã€‚ ç”¨
ariteku 2011/08/30
struts2

DAO
ãƒªãƒ³ã‚¯
ã‚µãƒ«ã§ã‚‚ã‚ã‹ã‚‹ é€†å¼•ããƒ‡ã‚¶ã‚¤ãƒ³ãƒ‘ã‚¿ãƒ¼ãƒ³ã€€ç¬¬3ç« é€†å¼•ãã‚«ã‚¿ãƒã‚°ã€€J2EEç·¨ã€€Facadeï¼ˆãƒ•ã‚¡ã‚µãƒ¼ï¾„ï¾žï¼‰
ã‚¤ãƒ³ãƒˆãƒãƒ€ã‚¯ã‚·ãƒ§ãƒ³ ã¿ãªã•ã‚“ã®ã‚µãƒ¼ãƒ–ãƒ¬ãƒƒãƒˆï¼ˆStrutsã‚’ä½¿ç”¨ã—ã¦ã„ã‚‹å ´åˆã¯ã‚¢ã‚¯ã‚·ãƒ§ãƒ³ã‚¯ãƒ©ã‚¹ï¼‰ã®è¡Œæ•°ã¯ã€å¹³å‡ã©ã‚Œãã‚‰ã„ã§ã—ã‚‡ã†ã‹ï¼Ÿ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¢ã‚¯ã‚»ã‚¹ã‚„æ¥å‹™å‡¦ç†ãªã©ã€ã™ã¹ã¦ã®å‡¦ç†ã‚’ã‚µãƒ¼ãƒ–ãƒ¬ãƒƒãƒˆã«è©°ã‚è¾¼ã‚‚ã†ã¨ã—ã¦ã€ã‚ã£ã¨ã„ã†é–“ã«1000è¡Œã‚’è¶Šã™ã‚ˆã†ãªã€Œå¤ªã£ãŸã‚µãƒ¼ãƒ–ãƒ¬ãƒƒãƒˆã€ã‚’ä½œã£ã¦ã—ã¾ã£ãŸã“ã¨ã‚ã‚Šã¾ã›ã‚“ã‹ï¼Ÿ ã‚µãƒ¼ãƒ–ãƒ¬ãƒƒãƒˆã‚’åˆã‚ã¦æ›¸ã„ãŸã¨ãã¯ç†è€…ã‚‚ãã†ã§ã—ãŸã€‚ ã“ã®ã‚ˆã†ãªã€Œé•·ãã€ã€Œã™ã¹ã¦ã®å‡¦ç†ãŒå…¥ã£ãŸã€ã‚µãƒ¼ãƒ–ãƒ¬ãƒƒãƒˆã®ã“ã¨ã‚’ã™ã¹ã¦ã®ã“ã¨ã‚’è¡Œã†é”æ³•ã®ã‚ˆã†ãªã‚µãƒ¼ãƒ–ãƒ¬ãƒƒãƒˆã¨ã„ã†ã“ã¨ã§ã€Œãƒžã‚¸ãƒƒã‚¯ã‚µãƒ¼ãƒ–ãƒ¬ãƒƒãƒˆã€ã¨å‘¼ã³ã¾ã™ã€‚ ãƒžã‚¸ãƒƒã‚¯ã‚µãƒ¼ãƒ–ãƒ¬ãƒƒãƒˆã¯ä¿å®ˆã‚„æ©Ÿèƒ½æ‹¡å¼µãŒé›£ã—ã„ã®ã¯ã‚‚ã¡ã‚ã‚“ã®ã“ã¨ã€ã€Œã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒæä¾›ã™ã‚‹æ©Ÿèƒ½ã€ã‚’æŠŠæ¡ã™ã‚‹ã“ã¨ãŒé›£ã—ããªã‚‹ã¨ã„ã†å¼Šå®³ãŒã‚ã‚Šã¾ã™ã€‚ æ©Ÿèƒ½ã‚’æŠŠæ¡ã§ããªã„ã¨ã€Œã‚ã®æ©Ÿèƒ½ã£ã¦ã©ã“ã«ã‚ã£ãŸã£ã‘ï¼Ÿã€ã¨ã„ã†çŠ¶æ³ã‚’ç”Ÿã¿å‡ºã—ãŒã¡ã«ãªã‚Šã¾ã™ã€‚ ãã®ã‚ˆã†ãªçŠ¶æ³ã‚’é¿ã‘ã‚‹ãŸã‚ã«ã‚‚ã€ã€Œã‚µãƒ¼ãƒ“ã‚¹ã‚’æ
ariteku 2011/08/23
java

dao
ãƒªãƒ³ã‚¯
ã€ŽJAVA:Daoã¨ã‹å‘¼ã°ã‚Œã‚‹ã‚„ã¤ã®åŸºæœ¬å½¢(MySQLç”¨)ã€
æš‡ã¤ã¶ã—ã§ä½œã£ãŸã®ã§ãƒ¡ãƒ¢ã€‚ ä¾‹å¤–å‡¦ç†ã¨ã‹ã‚‚ã£ã¨ã¤ãã‚‰ãªãã‚ƒã ã‚ã§ã™ãã€‚ ã¾ã‚ã‚„ã£ã¤ã‘ãªã®ã§ã€ã“ã‚“ãªã‚‚ã‚“ã§ã—ã‚‡ã†ã€‚ ã“ã‚Œã‚’ç¶™æ‰¿ã—ã¦ã„ã‚ã„ã‚ã™ã‚Œã°ã„ã„ã¨æ€ã„ã¾ã™ã€‚ ----------------------------------------------- package dao; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; /** * ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ç‚ºã®ã‚¯ãƒ©ã‚¹ã€‚ * MySQLç”¨ * ä½¿ã£ãŸå¾Œã¯Close()ã—ã¾ã—ã‚‡
ariteku 2011/08/19
dao

java
ãƒªãƒ³ã‚¯
DTOãƒ»DAOãƒ‘ã‚¿ãƒ¼ãƒ³ã®ãƒ¡ãƒªãƒƒãƒˆã‚’ä½“é¨“ã—ã‚ˆã†
ç°¡æ˜“åœ¨åº«ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ã®ä½œæˆï¼ˆ2ï¼‰ ç°¡æ˜“åœ¨åº«ã‚·ã‚¹ãƒ†ãƒ âˆ’ updateStock.php ç¶šã„ã¦ã€updateStock.phpã®ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã‚’ã®ãžã„ã¦ã¿ã¾ã—ã‚‡ã†ã€‚ 1Â Â Â <?php 2 3Â Â Â require_once("It em.php"); 4Â Â Â require_once("It emDao.php"); 5 6Â Â Â $it emÂ =Â newÂ It em(); 7Â Â Â $it em_daoÂ =Â newÂ It emDao(); 8 9Â Â Â #ãƒ•ã‚©ãƒ¼ãƒ å€¤ã®å–å¾—ã€‚addslashes()ã§SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã‚’é˜²ã 10Â Â $it em->setId(addslashes($_POST["id"])); 11Â Â $it em->setName(addslashes($_POST["name"])); 12Â Â $it em->setDetail(addslashes($_POST["detail"]))
ariteku 2011/08/19
dao
ãƒªãƒ³ã‚¯
djUnit
Latest version 0.8.6 for Eclipse 3.2, 3.3, 3.4, 3.5 [2011/10/17] Version 0.8.6 for Eclipse 3.2, 3.3, 3.4, 3.5 Released.[2011/10/17] [0.8.6] Changed a exception handler of djUnit class loader. [Fixed bug] Mojibake of djUnit class loader message. [Fixed bug] SWT's "no more handles" occurs. [Fixed bug] Coverage target line(finally clause) bug with asm1.5.x. Bytecode process was improved. Version 0.8.
ariteku 2011/08/16
java

DAO
ãƒªãƒ³ã‚¯
ç¾å ´ã§ä½¿ãˆã‚‹Hibernate | ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã®åºƒå ´
1.ã¯ã˜ã‚ã« ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºã‚·ã‚¹ãƒ†ãƒ ã®ã‚ˆã†ãªå¤§é‡ã®æƒ…å ±ç®¡ç†ã‚’è¡Œã†ã‚·ã‚¹ãƒ†ãƒ ã«ãŠã„ã¦ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚·ã‚¹ãƒ†ãƒ ã¯å¿…é ˆã§ã™ã€‚ç¾åœ¨ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚·ã‚¹ãƒ†ãƒ ã«ã¯ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹(RDBMS)ä»¥å¤–ã«ã‚‚ã€XML ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚„ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆæŒ‡å‘ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨é¸æŠžè‚¢ã‚‚å¢—ãˆã¦ã„ã¾ã™ã€‚ã—ã‹ã—ã€æ—¢å˜ãƒªã‚½ãƒ¼ã‚¹ã®å†åˆ©ç”¨ã‚„ä½¿ã„å‹æ‰‹ã€æ€§èƒ½ã€è£½å“ã®ãƒ–ãƒ©ãƒ³ãƒ‰ç‰ã‚’è€ƒæ…®ã™ã‚‹ã¨ã€RDBMS ãŒé¸æŠžã•ã‚Œã‚‹ã“ã¨ãŒå¤šã„ã¨æ€ã„ã¾ã™ã€‚ Java å´ã®ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã¨ã€RDBMS å´ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’å¯¾å¿œä»˜ã‘ã¦ç›¸äº’ã«å¤‰æ›ã™ã‚‹ã“ã¨ã‚’ O/R ãƒžãƒƒãƒ”ãƒ³ã‚°ã¨è¨€ã„ã¾ã™ã€‚Java ã§ã¯ O/R ãƒžãƒƒãƒ”ãƒ³ã‚°ã«é–¢ã™ã‚‹å‡¦ç†ã¯ã€DataAccessObject (DAO) ãƒ‘ã‚¿ãƒ¼ãƒ³ [3] ã«ã‚ˆã£ã¦å±€æ‰€åŒ–ã—ã€ DAO å†…ã§ JDBC ã«ã‚ˆã£ã¦ RDBMS ã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã‚ˆã†ãªè¨è¨ˆãŒã‚ˆãä½¿ã‚ã‚Œã¾ã™ï¼ˆå›³ 1-1ï¼‰ã€‚ JDBC ã‚’ä½¿ã£ãŸ O/R ãƒžãƒƒãƒ”ãƒ³ã‚°ã¯ã€å˜èª¿
ariteku 2011/08/16
DAO

java
ãƒªãƒ³ã‚¯
ã‚µãƒ«ã§ã‚‚ã‚ã‹ã‚‹ é€†å¼•ããƒ‡ã‚¶ã‚¤ãƒ³ãƒ‘ã‚¿ãƒ¼ãƒ³ã€€ç¬¬3ç« é€†å¼•ãã‚«ã‚¿ãƒã‚°ã€€J2EEç·¨ã€€DAOï¼ˆData Access Objectï¼‰
ã‚¤ãƒ³ãƒˆãƒãƒ€ã‚¯ã‚·ãƒ§ãƒ³ ç§ãŸã¡ãŒä½œã‚‹ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ã»ã¨ã‚“ã©ã¯ã€ã©ã“ã‹ã§æ°¸ç¶šçš„ãªãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã†ã“ã¨ã«ãªã‚Šã¾ã™ã€‚ ãã®ãƒ‡ãƒ¼ã‚¿ã®ä¿å˜å…ˆã¯ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚„ãƒ†ã‚ã‚¹ãƒˆãƒ•ã‚¡ã‚¤ãƒ«ã€ä»–ã‚·ã‚¹ãƒ†ãƒ ãªã©ã«ãªã‚‹ã§ã—ã‚‡ã†ã€‚ ãã—ã¦ä¿å˜ã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ã¸ã®ã‚¢ã‚¯ã‚»ã‚¹ã§ä½¿ç”¨ã™ã‚‹APIã¯ã€ä¿å˜å…ˆã«ã‚ˆã£ã¦å¤‰ã‚ã£ã¦ã„ãã¾ã™ã€‚ ä¾‹ãˆã°ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã ã¨JDBCã‚’ä½¿ç”¨ã—ã¾ã™ã€‚ ãƒ•ã‚¡ã‚¤ãƒ«ã ã¨java.ioãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã‚ãŸã‚Šã‚’ä½¿ç”¨ã—ãŸã‚Šã—ã¾ã™ã€‚ ã¾ãŸã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã¿ã«ç„¦ç‚¹ã‚’å½“ã¦ã¦ã¿ã¦ã‚‚ã€ãƒ™ãƒ³ãƒ€ã‚„ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«ã‚ˆã£ã¦ç™ºè¡Œã™ã‚‹SQLæ–‡ã‚’å¤‰ãˆãªã‘ã‚Œã°ãªã‚Šã¾ã›ã‚“ã€‚ ãƒ•ã‚¡ã‚¤ãƒ«ã«æ°¸ç¶šçš„ãªãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã—ã¦ã„ã¦ã€ãã®ä¿å˜å…ˆãŒãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«å¤‰æ›´ã•ã‚ŒãŸã¨ãã®ã“ã¨ã‚’æƒ³åƒã—ã¦ãã ã•ã„ã€‚ ãƒ“ã‚¸ãƒã‚¹ãƒã‚¸ãƒƒã‚¯ï¼ˆæ¥å‹™ãƒã‚¸ãƒƒã‚¯ï¼‰ã®ä¸ã«ãƒ‡ãƒ¼ã‚¿ã‚¢ã‚¯ã‚»ã‚¹ã«ã¾ã¤ã‚ã‚‹ã‚³ãƒ¼ãƒ‰ã‚’æ›¸ã„ã¦ã„ã‚‹å ´åˆã€ä¿å˜å…ˆã®å¤‰æ›´ãŒå®¹æ˜“ã§ã¯ã‚ã‚Šã¾ã›ã‚“ï¼ˆåŒæ§˜ã®ã“ã¨ãŒã€ãƒ‡ãƒ¼ã‚¿ãƒ™
ariteku 2011/08/16
DAO

java
ãƒªãƒ³ã‚¯
DAOãƒ‘ã‚¿ãƒ¼ãƒ³ã®ãƒ‡ãƒ¡ãƒªãƒƒãƒˆã‚’è£œã†ã€ŒDataAccessMethodãƒ‘ã‚¿ãƒ¼ãƒ³ã€
DAOãƒ‘ã‚¿ãƒ¼ãƒ³ã¯ã€ä¼æ¥å‘ã‘ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã§åˆ©ç”¨ã•ã‚Œã‚‹éžå¸¸ã«å„ªã‚ŒãŸãƒ‡ã‚¶ã‚¤ãƒ³ãƒ‘ã‚¿ãƒ¼ãƒ³ã§ã™ãŒã€å¤šãã®ã‚¯ãƒ©ã‚¹ã‚„ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ã‚¤ã‚¹ã‚’å®šç¾©ã™ã‚‹å¿…è¦ãŒã‚ã‚‹ã¨ã„ã†ãƒ‡ãƒ¡ãƒªãƒƒãƒˆãŒã‚ã‚Šã¾ã™ã€‚ãã“ã§æœ¬ç¨¿ã§ã¯ã€GoFã®TemplateMethodãƒ‘ã‚¿ãƒ¼ãƒ³ã‚’ãƒ™ãƒ¼ã‚¹ã—ãŸDataAccessMethodãƒ‘ã‚¿ãƒ¼ãƒ³ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ã“ã‚Œã‚’ç”¨ã„ã‚‹ã¨ã€é€šå¸¸ã®DAOãƒ‘ã‚¿ãƒ¼ãƒ³ã«æ¯”ã¹ã¦ã‚¯ãƒ©ã‚¹æ•°ãŒæ¿€æ¸›ã—ã¾ã™ã€‚ ã¯ã˜ã‚ã« CJ2EEã®DataAccessObjectãƒ‘ã‚¿ãƒ¼ãƒ³ã¯ã€ä¼æ¥å‘ã‘ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã§åˆ©ç”¨ã•ã‚Œã‚‹éžå¸¸ã«å„ªã‚ŒãŸãƒ‡ã‚¶ã‚¤ãƒ³ãƒ‘ã‚¿ãƒ¼ãƒ³ã§ã™ã€‚ã“ã‚Œã‚’åˆ©ç”¨ã™ã‚‹ã“ã¨ã«ã‚ˆã‚Šã€æŸ”è»Ÿãªã‚·ã‚¹ãƒ†ãƒ ã‚’æ§‹ç¯‰ã™ã‚‹ã“ã¨ãŒå¯èƒ½ã¨ãªã‚Šã¾ã™ã€‚æœ‰åãªãƒ‘ã‚¿ãƒ¼ãƒ³ãªã®ã§ã€å¤šãã®æ–¹ã¯ã“ã®ãƒ‘ã‚¿ãƒ¼ãƒ³ã‚’ä½¿ã£ãŸè¨è¨ˆï¼é–‹ç™ºã«æºã‚ã£ãŸçµŒé¨“ãŒã‚ã‚‹ã®ã§ã¯ãªã„ã‹ã¨æ€ã„ã¾ã™ã€‚ ã—ã‹ã—ã€DataAccessObjectãƒ‘ã‚¿ãƒ¼ãƒ³ã‚’ä½¿ã£ãŸé–‹ç™ºã¯å¤šãã®ã‚¯ãƒ©ã‚¹ã‚„ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ã‚¤ã‚¹ã‚’å®šç¾©ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ã“ã‚Œã¯ã€Da
ariteku 2011/08/10
DAO

java
ãƒªãƒ³ã‚¯
1