[B! SQL][DB] amnmaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

amnma id:amnma

SQLã¨DBã«é–¢ã™ã‚‹amnmaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (7)

${{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}}

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

tips

java

programming

DB

sql

database
ãƒªãƒ³ã‚¯
SQL Code Formatter
Click HERE to view desktop version/add-in version for ssms/vs of SQL Pretty Printer. Click HERE to try FREE ONLINE SQL beautifier, also known as Instant SQL Formatter. Instant SQL Formatter is a free online sql tidy tool, actually, it not only can beautify your sql but also can turn your formatted sql into html code, so you can post coloured sql code in your blog, forum,wiki and any website easily
amnma 2007/10/09
SQL

Tools

DB

WebService

Development
ãƒªãƒ³ã‚¯
MySQL FULLTEXT Ngram : LIKEæ¤œç´¢ã‚ˆã‚Šæ•°åå€é«˜é€Ÿãªã€ãŠæ‰‹è»½ æ—¥æœ¬èªžå…¨æ–‡æ¤œç´¢ ã«ã¤ã„ã¦ï½œblogï½œãŸãŸã¿ãƒ©ãƒœ
tatamilab.jp
amnma 2007/03/15
MySQL

DB

SQL

PerformanceTuning
ãƒªãƒ³ã‚¯
SQLã‚’ç›´æŽ¥è¨˜è¿°ã§ãã‚‹iBATISï¼ˆå‰ç·¨ï¼‰ | Think ITï¼ˆã‚·ãƒ³ã‚¯ã‚¤ãƒƒãƒˆï¼‰
çš†ã•ã‚“ã€ã“ã‚“ã«ã¡ã¯ã€‚æœ¬é€£è¼‰ã‚’æ‹…å½“ã™ã‚‹ãƒ“ãƒ¼ãƒ–ãƒ¬ã‚¤ã‚¯ã‚·ã‚¹ãƒ†ãƒ ã‚ºã®å±±ä¹‹å†…ã§ã™ã€‚ å‰å›žã€é¢å€’ãªãƒžãƒƒãƒ”ãƒ³ã‚°ä½œæ¥ã‚’è»½æ¸›ã—ã¦ãã‚Œã‚‹ãƒ„ãƒ¼ãƒ«ã¨ã—ã¦O/Rãƒžãƒƒãƒ”ãƒ³ã‚°ãƒ„ãƒ¼ãƒ«ã¨ã„ã†ã‚‚ã®ãŒã‚ã‚‹ã“ã¨ã‚’èª¬æ˜Žã—ã¾ã—ãŸã€‚ãã“ã§ä»Šå›žã‹ã‚‰ã¯ã€O/Rãƒžãƒƒãƒ”ãƒ³ã‚°ãƒ„ãƒ¼ãƒ«ã®1ã¤ã§ã‚ã‚‹ã€ŒiBATISã€ã§å®Ÿéš›ã«ã‚µãƒ³ãƒ—ãƒ«ã‚’ä½œæˆã—ã€ãã®æ©Ÿèƒ½ã‚’è¦‹ã¦ã„ãã¾ã™ã€‚ ä»Šå›žã¯ã€ã€ŒiBATISã€ã‚’åˆ©ç”¨ã™ã‚‹ä¸‹æº–å‚™ã‚’ãŠã“ãªã„ã¾ã™ã€‚ iBATISã¨ã¯ã€Apacheã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã®1ã¤ã¨ã—ã¦ASFï¼ˆApache Software Foundationï¼‰ã§é–‹ç™ºï¼ç®¡ç†ã•ã‚Œã¦ã„ã‚‹O/Rãƒžãƒƒãƒ”ãƒ³ã‚°ãƒ„ãƒ¼ãƒ«ã§ã™ã€‚2002å¹´ã«ç™ºè¡¨ã•ã‚Œã€2006å¹´7æœˆç¾åœ¨ã®æœ€æ–°ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯2.1.7ã§ã™ã€‚ iBATISã¯ã€ŒiBATIS SQL Mapsã€ã¨ã„ã†O/Rãƒžãƒƒãƒ”ãƒ³ã‚°æ©Ÿèƒ½ã¨ã€ã€ŒiBATIS DAO Frameworkã€ã¨ã„ã†DAOãƒ‘ã‚¿ãƒ¼ãƒ³ç”¨ã®ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã§æ§‹æˆã•ã‚Œã¦ã„ã¾ã™ã€‚ã€ŒiBATI
amnma 2006/12/26
DB

iBATIS

SQL
ãƒªãƒ³ã‚¯
ãƒãƒƒã‚«ãƒ¼ã®é‡‘é‰±è„ˆã€ŒSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã€ã®æ£ä½“
æœ€è¿‘ï¼Œã€ŒSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã€ã®å±é™ºæ€§ã«ã¤ã„ã¦èªžã‚‰ã‚Œã‚‹æ©Ÿä¼šãŒå¢—ãˆã¦ã„ã‚‹ãŒï¼ŒSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã®æ£ä½“ï¼Œãã®å•é¡Œç‚¹ï¼Œãã—ã¦ãã‚Œã‚’é˜²ããŸã‚ã®æ–¹ç–ã«ã¤ã„ã¦è©³ã—ãç†è§£ã—ã¦ã„ã‚‹äººã¯ã¾ã å¤šããªã„ã€‚ã“ã“ã§ã¯ï¼ŒSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã¨ã¯ä½•ã‹ã‚’æ˜Žç¢ºã«å®šç¾©ã—ï¼Œã©ã®ã‚ˆã†ã«ã—ã¦è¡Œã‚ã‚Œã‚‹ã‹ã‚’èª¬æ˜Žã—ï¼ŒSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã‹ã‚‰çµ„ç¹”ã‚’å®ˆã‚‹æ–¹æ³•ã‚’èªè€…ã«ä¼ãˆã‚‹ã“ã¨ã«ã‚ˆã£ã¦ï¼Œã“ã®çŠ¶æ³ã‚’æ”¹å–„ã—ãŸã„ã€‚ SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã¨ã¯ä½•ã‹ SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã¨ã¯ï¼Œã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«å«ã¾ã‚Œã‚‹ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ãƒ»ã‚¨ãƒ©ãƒ¼ãŒåŽŸå› ã¨ãªã£ã¦å¼•ãèµ·ã“ã•ã‚Œã‚‹ãœã„å¼±æ€§ï¼Œã¾ãŸã¯æ¬ é™¥ã§ã‚ã‚‹ã€‚SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã¯ï¼Œãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒå…¥åŠ›ã—ãŸãƒ‡ãƒ¼ã‚¿ã‚’ä½¿ã£ã¦ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒSQLã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã‚’ä½œæˆã—ï¼Œãã‚Œã‚’SQL Serverã«é€ä¿¡ã—ã¦å®Ÿè¡Œã™ã‚‹å ´åˆã«ç™ºç”Ÿã™ã‚‹ã€‚ã“ã®æ¬ é™¥ãŒåŠã¼ã™å½±éŸ¿ã¯ï¼Œã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ãƒ»ã‚¨ãƒ©ãƒ¼ã®æ€§è³ªã«ã‚ˆã£ã¦æ§˜ã€…ã§ã‚ã‚‹ã€‚ å…·ä½“çš„ã«è¨€ã†ã¨ï¼Œãã®å½±éŸ¿ã¯ï¼Œã‚¨
amnma 2006/10/06
DB

WebApplication

SQL
ãƒªãƒ³ã‚¯
CodeZineï¼šCASEå¼ã®ã‚¹ã‚¹ãƒ¡ï¼ˆå‰ç·¨ï¼‰
ã¯ã˜ã‚ã«ã€€CASEå¼ã¯ã€SQL-92ã§æ¨™æº–ã«å–ã‚Šå…¥ã‚Œã‚‰ã‚Œã¾ã—ãŸã€‚æ¯”è¼ƒçš„æ–°ã—ã„é“å…·ã§ã‚ã‚‹ãŸã‚ã‹ã€ä¾¿åˆ©ãªã‚ã‚Šã«ãã®çœŸä¾¡ãŒã‚ã¾ã‚ŠçŸ¥ã‚‰ã‚Œã¦ãŠã‚‰ãšã€åˆ©ç”¨ã•ã‚Œã¦ã„ãªã‹ã£ãŸã‚Šã€CASEå¼ã®ç°¡ç•¥ç‰ˆã§ã‚ã‚‹DECODEï¼ˆOracleï¼‰ã€IFï¼ˆMySQLï¼‰ãªã©ã®é–¢æ•°ã§ä»£ç”¨ã•ã‚Œã¦ã„ãŸã‚Šã—ã¾ã™ã€‚ã€€ã—ã‹ã—ã€ã‚¸ãƒ§ãƒ¼ãƒ»ã‚»ãƒ«ã‚³ãŒã€Žãƒ—ãƒã‚°ãƒ©ãƒžã®ãŸã‚ã®SQL ç¬¬2ç‰ˆã€ã®ä¸ã§ã€SQL-92ã§è¿½åŠ ã•ã‚ŒãŸä¸ã§æœ€ã‚‚æœ‰ç”¨ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ ã€€ã¨è¨€ã†ã‚ˆã†ã«ï¼ˆæ³¨1ï¼‰ã€CASEå¼ã‚’æ´»ç”¨ã™ã‚‹ã¨SQLã§ã§ãã‚‹ã“ã¨ã®å¹…ãŒãã£ã¨åºƒãŒã‚Šã€æ›¸ãæ–¹ã‚‚ã‚¹ãƒžãƒ¼ãƒˆã«ãªã‚Šã¾ã™ã€‚ã—ã‹ã‚‚ã€å®Ÿè£…éžä¾å˜ã®æŠ€è¡“ãªã®ã§ã‚³ãƒ¼ãƒ‰ã®æ±Žç”¨æ€§ã‚‚é«˜ã¾ã‚Šã¾ã™ã€‚ç‰¹ã«DECODEé–¢æ•°ã‚’ä½¿ã£ã¦ã„ã‚‹Oracleãƒ¦ãƒ¼ã‚¶ãƒ¼ã«ã¯ã€ãœã²CASEå¼ã¸ã®ä¹—ã‚Šæ›ãˆã‚’ãŠè–¦ã‚ã—ã¾ã™ã€‚ã€€ã“ã®ãƒ†ã‚ã‚¹ãƒˆã¯ã€ãã‚“ãªã„ã„ã“ã¨ã„ã£ã±ã„ã®CASEå¼ã®ä¾¿åˆ©ãªä½¿ã„æ–¹ã‚’ç´¹ä»‹ã™ã‚‹ã‚‚ã®ã§ã™ã€‚ ã“ã®è¨€è‘‰ã¯ã€ã€Žãƒ—ãƒã‚°ãƒ©ãƒžã®ãŸã‚ã®SQL ç¬¬2ç‰ˆã€ï¼ˆ
amnma 2006/10/05
CHECKåˆ¶ç´„ã¨ã®çµ„ã¿åˆã‚ã›ã‚‚ã§ãã‚‹

SQL

DB

Oracle

MySQL

SQLServer

DB2

PostgreSQL
ãƒªãƒ³ã‚¯
3å€¤è«–ç†ã¨NULLï¼šCodeZine
è¦ã™ã‚‹ã«ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«nullãŒ1ã¤ã§ã‚‚å«ã¾ã‚Œã¦ã„ã‚Œã°ã€ã‚¯ã‚¨ãƒªã‹ã‚‰æ£ã—ããªã„çµæžœãŒè¿”ã•ã‚Œã‚‹å¯èƒ½æ€§ãŒã‚ã‚‹ã€‚ã—ã‹ã‚‚ã€ä¸€èˆ¬çš„ã«ã¯ã€ã©ã®ã‚¯ã‚¨ãƒªã‹ã‚‰æ£ã—ããªã„çµæžœãŒè¿”ã•ã‚Œã‚‹ã®ã‹ã‚’çŸ¥ã‚‹æ–¹æ³•ã¯ãªã„ã®ã§ã€ã™ã¹ã¦ã®çµæžœãŒã‚ã‚„ã—ãè¦‹ãˆã¦ãã‚‹ã€‚nullãŒå«ã¾ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‹ã‚‰æ£ã—ã„çµæžœãŒå¾—ã‚‰ã‚Œã‚‹ã“ã¨ã¯ç¢ºä¿¡ã§ããªã„ã€‚ç†è€…ã«è¨€ã‚ã›ã‚Œã°ã€ã“ã®çŠ¶æ³ã¯ã¾ã•ã«ãŠæ‰‹ä¸Šã’ã§ã‚ã‚‹ã€‚ â€•â€•â€•â€•C.J.ãƒ‡ã‚¤ãƒˆ ã¯ã˜ã‚ã«ã€€å¤šãã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžãŒã€çœŸç†å€¤åž‹ï¼ˆBOOLåž‹ã€BOOLEANåž‹ï¼‰ã¨ã„ã†ãƒ‡ãƒ¼ã‚¿åž‹ã‚’æŒã£ã¦ã„ã¾ã™ã€‚ã‚‚ã¡ã‚ã‚“ã€SQLã«ã‚‚çœŸç†å€¤åž‹ãŒå˜åœ¨ã—ã¾ã™ã€‚ãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒç›´æŽ¥æ‰±ãˆã‚‹ãƒ‡ãƒ¼ã‚¿åž‹ã¨ã—ã¦å®šç¾©ã•ã‚ŒãŸã®ã¯SQL-99ã§ã™ãŒã€WHEREå¥ãªã©ã®æ¡ä»¶ã®è©•ä¾¡æ™‚ã«ã‚‚çœŸç†å€¤ã®æ¼”ç®—ãŒè¡Œãªã‚ã‚Œã¦ã„ã¾ã™ã€‚ã€€ã¨ã“ã‚ã§ã€æ™®é€šã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã®çœŸç†å€¤åž‹ã¨SQLã®çœŸç†å€¤åž‹ã®é•ã„ã‚’ã”å˜çŸ¥ã§ã—ã‚‡ã†ã‹ï¼Ÿ ãã‚Œã¯ã€æ™®é€šã®è¨€èªžã®çœŸç†å€¤åž‹ãŒã€trueã€fals
amnma 2006/10/02
Column

DB

SQL

Programming
ãƒªãƒ³ã‚¯
1