[B! ADO] babydaemonsã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

babydaemons id:babydaemons

ADOã«é–¢ã™ã‚‹babydaemonsã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (10)

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

ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã®é«˜é€ŸåŒ–
ã“ã®é€£è¼‰ã§ã¯ã€Javaã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ã‚¢ã‚¯ã‚»ã‚¹APIã§ã‚ã‚‹ã€ŒJDBCã€ã®æ©Ÿèƒ½ã‚’ã€ã‚µãƒ³ãƒ—ãƒ«ã‚³ãƒ¼ãƒ‰ã‚’äº¤ãˆã¦è§£èª¬ã—ã¦ã„ãã¾ã™ã€‚ã¾ãŸã€J2EEã«ãŠã‘ã‚‹JDBCã®ä½ç½®ä»˜ã‘ã‚„ã€JDBCã‚’åˆ©ç”¨ã™ã‚‹ã•ã¾ã–ã¾ãªãƒ†ã‚¯ãƒŽãƒã‚¸ã«ã¤ã„ã¦ã‚‚è§£èª¬ã—ã¦ã„ãäºˆå®šã§ã™ã€‚å‰æçŸ¥è˜ã¨ã—ã¦ã¯ã€Javaã¨ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«é–¢ã™ã‚‹ãƒ™ãƒ¼ã‚·ãƒƒã‚¯ãªçŸ¥è˜ãŒã‚ã‚Œã°ååˆ†ã§ã™ã€‚ ç¬¬2å›žã€ŒJDBCã«ã‚ˆã‚‹DBã¸ã®æŽ¥ç¶šã¨æ¤œç´¢ã®å®Ÿè¡Œã€ã§ã¯ã€selectæ–‡ã®å®Ÿè¡Œã‚’ã€ãã—ã¦ç¬¬3å›žã€ŒJDBCã«ã‚ˆã‚‹æ›´æ–°å‡¦ç†ã®å®Ÿè¡Œã€ã§ã¯ã€DDLæ–‡ã‚„DMLæ–‡ã®å®Ÿè¡Œã‚’å–ã‚Šä¸Šã’ã¾ã—ãŸã€‚ç¬¬4å›žã®ä»Šå›žã¯ã€SQLæ–‡ã‚’ãƒ—ãƒªã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ã™ã‚‹ãƒ—ãƒªãƒšã‚¢ãƒ‰ãƒ»ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã®åˆ©ç”¨æ–¹æ³•ã€ãã—ã¦ã€ã‚¹ãƒˆã‚¢ãƒ‰ãƒ»ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã®å®Ÿè¡Œæ–¹æ³•ã‚’ç´¹ä»‹ã—ã¾ã—ã‚‡ã†ã€‚ ãƒ—ãƒªãƒšã‚¢ãƒ‰ãƒ»ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã‚’åˆ©ç”¨ã™ã‚‹ ãƒ—ãƒªãƒšã‚¢ãƒ‰ãƒ»ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã¨ã¯ ã“ã“ã§ã¯ã€SQLæ–‡ã‚’ãƒ—ãƒªã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ã™ã‚‹ãŸã‚ã«ä½¿ç”¨ã™ã‚‹ãƒ—ãƒªãƒšã‚¢ãƒ‰ãƒ»ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã«ã¤ã„
babydaemons 2010/03/03
Java

JDBC

DB

Tutorial

prepareStatement

Command Object

ADO

ADO.NET
ãƒªãƒ³ã‚¯
MDBã®ãƒ†ãƒ¼ãƒ–ãƒ«åä¸€è¦§å–å¾— - ã™ã±ã„ã ãƒ¼æ—¥è¨˜ã€‚
ã‚‹ã³ã¾ã®ã‚½ãƒ¼ã‚¹ã‚’å‚è€ƒã« MSDNã§ADOã®ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã‚’æŽ¢ã—ã¦ãã¦ãªã‚“ã¨ã‹ require 'win32ole' filename = "mdbã®ãƒ•ã‚¡ã‚¤ãƒ«å" connection= WIN32OLE.new("ADODB.Connection") connstr = "DRIVER={Microsoft Access Driver (*.mdb)};Dbq=#{filename}" connection.Open(connstr) catalog= WIN32OLE.new("ADOX.Catalog") catalog.ActiveConnection = connection tables = catalog.Tables for i in 0...tables.Count puts tables.It em(i).Name end connection.close
babydaemons 2009/12/10
ã‚„ã£ã±ã‚Šã€ADODB.Connectionã—ã‹ãªã„ã®ã‹ï¼Ÿï¼Ÿ

Ruby

mdb

Access

WIN32OLE

ADO
ãƒªãƒ³ã‚¯
Rubyã§ACCESS MDBã‚¢ã‚¯ã‚»ã‚¹ - AOFGã®æ—¥è¨˜
http://jp.rubyist.net/magazine/?0005-Win32OLE ã‚’å‚è€ƒã«ã—ã¦ã€Rubyã‹ã‚‰MDBã®æ“ä½œã‚’è©¦ã—ãŸã€‚ ãã®éš›ã€æ°—ã¥ã„ãŸã®ã ãŒã€ä¸Šã®ãƒšãƒ¼ã‚¸ã®each_recordã®æœ€åˆã®ifç¯€ãŒä½•ã‹ãŠã‹ã—ã„ã¨æ€ã†ã€‚ self.MoveFirstã‚ˆã‚Šå¾Œã«ã‚„ã‚‹ãªã‚‰ã¾ã ã—ã‚‚ã€each_recordãŒç¾åœ¨å‚ç…§ä¸ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ä½ç½®ã«ä¾å˜ã™ã‚‹çµæžœã«ãªã£ã¦ã—ã¾ã†ã€‚ (each_recordã‚’äºŒå›žç¶šã‘ã¦å‘¼ã³å‡ºã—ãŸéš›ã®å‹•ä½œãŒæã‚‰ãæœŸå¾…é€šã‚Šã§ãªã„) ãŒã€ä½•ã‚‚ãªã„ã¨ã€ãƒ¬ã‚³ãƒ¼ãƒ‰ãŒç„¡ã„æ™‚ã¨ã‹INSERTæ–‡ã®å¾Œã¨ã‹ã«ã‚¨ãƒ©ãƒ¼ã«ãªã‚‹ã¿ãŸã„ãªã®ã§ã€EOF or BOF ã§ãªã EOF and BOFã¨ã—ãŸã‚‰è‰¯ã„ã‹ã‚‚ã—ã‚Œãªã„ã€‚ ã§ã‚‚ã€Rubyã®ç‰¹ç•°ãƒ¡ã‚½ãƒƒãƒ‰ã¯é¢ç™½ã„ãªã€ã¨æ€ã†ã€‚ ãã‚Œã‚’ä½¿ã£ã¦ã€startADOã‚’æ¬¡ã®ã‚ˆã†ã«ã™ã‚‹ã¨ä½¿ã„ã‚„ã™ã„ã¨æ€ã†ã€‚ def startADO filename cn = WIN32
babydaemons 2009/12/10
ã†ãƒ¼ã‚“ã€ADODB.Connectionã¯ä½¿ã„ãŸããªã„ãªãƒ¼ã€‚æœ€çµ‚æ‰‹æ®µã ã€‚

Ruby

mdb

Access

Windows

ActiveX

ADO
ãƒªãƒ³ã‚¯
VBScript/Database - Take's Wiki
babydaemons 2007/08/10
Computing

Database

ADO
ãƒªãƒ³ã‚¯
ä¸‰æµå›ASP:ADO CSVæŽ¥ç¶š å‹æ‰‹ã«åž‹ã‚’æ±ºã‚ã‚“ãªã‚ˆãƒ»ãƒ»ãƒ»
ä»Šå›žã€ADOã®CSVæŽ¥ç¶šã§ã„ã‚ã„ã‚ã¨ã‚„ã£ã¦ã¿ãŸã‘ã©ã€ã§ããªã‹ã£ãŸã€ãã‚“ãªãŠè©±ã§ã™ã€‚ ã§ã€è§£æ±ºã—ãŸã®ãŒâ†“ [No.102 ADO CSVæŽ¥ç¶š schema.iniã‚’ä½¿ã„åž‹ã‚’è¨å®šã—ã¦ã¿ãŸ] ã§ã€schema.iniã«åž‹ã‚’æŒ‡å®šã—ã¦èªã¿è¾¼ã‚€ã“ã¨ãŒã§ãã‚‹ã¿ãŸã„ã§ã™ã€‚ â€»å›žç”ã‚’é€Ÿãã»ã—ã„äººã¯ã€ä¸‹èªã¾ãªã„ã§ã€No.102ã®schema.iniã®æ–¹æ³•ãŒã„ã„ã§ã™ã‚ˆã€‚ æœ¬æ–‡(ç™ºè¡Œå†…å®¹) ã“ã‚“ã«ã¡ã¯ã€ä¸‰æµãƒ—ãƒã‚°ãƒ©ãƒžãƒ¼ã®ï¼«ï½…ï½Žï¼“ã§ã™ã€‚ ä»Šå›žã¯ã€ ADOã®CSVæŽ¥ç¶šã®è‡ªå‹•ã§æ±ºã¾ã£ã¦ã—ã¾ã†ãƒ‡ãƒ¼ã‚¿ã®åž‹ã«ã¤ã„ã¦å°‘ã€…ã€‚ ã§ã‚‚ã€è§£æ±ºã—ãªã‹ã£ãŸã‚Šãƒ»ãƒ»ãƒ» ã„ã¤ã‚‚ã®ä¸‰æµçš„ãªã‚¢ãƒ—ãƒãƒ¼ãƒãªã®ã§ã€å®Ÿéš›ã¯ã‚¢ãƒ¬ãƒ³ã‚¸ã—ã¦ä½¿ã£ã¦ãã ã•ã„ã€‚ â€»ä¸€éƒ¨ã§ã‚‚å‚è€ƒã«ãªã‚Œã°ã„ã„ã‚“ã ã‘ã©ãƒ»ãƒ»ãƒ» /* * ï¼‘ï¼Žä»Šå›žã®ã‚ãƒƒã‚«ã‚± */ No.080 Microsoft Text Driver (*.txt; *.csv) ã§æŽ¥ç¶šã—ã¦ã¿ãŸ http://www.ke
babydaemons 2007/05/30
Computing

Database

ADO
ãƒªãƒ³ã‚¯
accessclub.jpÂ -Â ã“ã®ã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã¯è²©å£²ç”¨ã§ã™ï¼Â -Â ã‚¢ã‚¯ã‚»ã‚¹ã‚¯ãƒ©ãƒ– ãƒªã‚½ãƒ¼ã‚¹ãŠã‚ˆã³æƒ…å ±
babydaemons 2007/05/15
Computing

Database

ADO
ãƒªãƒ³ã‚¯
ASP ãƒšãƒ¼ã‚¸ã‹ã‚‰ã‚¹ãƒˆã‚¢ãƒ‰ ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£SQL Serverå®Ÿè¡Œã™ã‚‹ - Internet Information Services
ã“ã®è¨˜äº‹ã§ã¯ã€ã‚¹ãƒˆã‚¢ãƒ‰ ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£SQL Serverå®Ÿè¡Œã—ã€Active Server Pages (ASP) ãƒšãƒ¼ã‚¸ã‹ã‚‰ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ãƒ¼ã‚’ä½¿ç”¨ã™ã‚‹æ–¹æ³•ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚ å…ƒã®è£½å“ãƒãƒ¼ã‚¸ãƒ§ãƒ³:ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆ ã‚¤ãƒ³ãƒ•ã‚©ãƒ¡ãƒ¼ã‚·ãƒ§ãƒ³ ã‚µãƒ¼ãƒ“ã‚¹ å…ƒã® KB ç•ªå·: 300488 æ¦‚è¦ ã“ã®è¨˜äº‹ã§ã¯ã€ASP ãƒšãƒ¼ã‚¸ã§ ActiveX ãƒ‡ãƒ¼ã‚¿ ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆ (ADO) ã‚’ä½¿ç”¨ã™ã‚‹æ‰‹é †ã«ã¤ã„ã¦ç†è§£ã—ã¦ã„ã‚‹ã“ã¨ã‚’å‰æã¨ã—ã¦ã„ã¾ã™ã€‚ ã‚¹ãƒ†ãƒƒãƒ— ãƒã‚¤ ã‚¹ãƒ†ãƒƒãƒ—ã®ä¾‹ ã‚¯ã‚¨ãƒª ã‚¢ãƒŠãƒ©ã‚¤ã‚¶ãƒ¼ã§æ¬¡ã®ã‚¯ã‚¨ãƒªSQL Serverå®Ÿè¡Œã™ã‚‹ã‹ã€Pubs ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«å¯¾ã—ã¦SQL Server Management Studioã—ã¾ã™ã€‚ CREATE proc MyProc ( @price smallint, @out smallint OUTPUT ) AS Select @out = count(*) from ti
babydaemons 2007/03/06
Computing

Database

ADO
ãƒªãƒ³ã‚¯
accessclub.jpÂ -Â ã“ã®ã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã¯è²©å£²ç”¨ã§ã™ï¼Â -Â ã‚¢ã‚¯ã‚»ã‚¹ã‚¯ãƒ©ãƒ– ãƒªã‚½ãƒ¼ã‚¹ãŠã‚ˆã³æƒ…å ±
This webpage was generated by the domain owner using Sedo Domain Parking. Disclaimer: Sedo maintains no relationship with third party advertisers. Reference to any specific service or trade mark is not controlled by Sedo nor does it constitute or imply its association, endorsement or recommendation.
babydaemons 2007/03/06
Computing

Database

ADO
ãƒªãƒ³ã‚¯
VB6.0 ADO
ç¦å²¡ å¯¿å’Œ FUKUOKAï¼ŒToshikazu å¯Œå£«é€šSSL OLE DBã¯ï¼Œâ€œæ±Žç”¨â€ãƒ‡ãƒ¼ã‚¿ã‚¢ã‚¯ã‚»ã‚¹ãƒ‘ãƒ©ãƒ€ã‚¤ãƒ ã‚’å°Žå…¥ã™ã‚‹ä½Žæ°´æº–ã®æ–°ã—ã„ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ã‚¤ã‚¹ã§ã™ï¼Žã™ãªã‚ã¡ï¼ŒOLE DBã¯ISAMï¼ŒJetï¼Œãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ã‚½ãƒ¼ã‚¹ã«é™å®šã•ã‚Œãšï¼Œå½¢å¼ã‚„è¨˜æ†¶æ–¹æ³•ã«ã‚‚é–¢ä¿‚ãªãä»»æ„ã®ãƒ‡ãƒ¼ã‚¿åž‹ã‚’å‡¦ç†ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ï¼Žå®Ÿéš›ï¼Œã“ã®æ±Žç”¨æ€§ã¯ï¼ŒExcelã®è¡¨è¨ˆç®—ã‚½ãƒ•ãƒˆï¼Œãƒ†ã‚ã‚¹ãƒˆãƒ•ã‚¡ã‚¤ãƒ«ï¼ŒMicrosoft Exchange ãªã©ã®ã‚°ãƒ«ãƒ¼ãƒ—ã‚¦ã‚§ã‚¢ï¼Œã¾ãŸã¯ï¼ŒActiveXã‚µãƒ¼ãƒãƒ¼ãªã©ã®ãƒ“ã‚¸ãƒã‚¹ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã«å˜åœ¨ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ã«ã‚‚ã‚¢ã‚¯ã‚»ã‚¹ã§ãã‚‹ã¨è¨€ã†ã“ã¨ã‚’æ„å‘³ã—ã¦ã„ã¾ã™ï¼Ž Visual Basic Version 6.0ã§ã¯ï¼ŒOLE DBã¨ã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚° ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ã‚¤ã‚¹ã® ADO ã‚’ä»‹ã—ã¦OLE DBã®ãƒ•ãƒ¬ã‚ã‚·ãƒ“ãƒªãƒ†ã‚£ã‚’åˆ©ç”¨ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ï¼Žã¾ãŸï¼Œç‹¬è‡ªã®OLE DBãƒ—ãƒãƒã‚¤ãƒ€ã‚’ä½œæˆã™ã‚‹ã“ã¨ã‚‚ã§ãã¾ã™ï¼Ž ADO
babydaemons 2007/03/05
Computing

Database

ADO
ãƒªãƒ³ã‚¯
ï¼ ITï¼šWebã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«æ½œã‚€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ãƒ›ãƒ¼ãƒ«ï¼ˆ2ï¼‰- Page1
é¡§å®¢ãƒ‡ãƒ¼ã‚¿ãŒã™ã¹ã¦ç›—ã¾ã‚Œã‚‹ï¼Ÿï¼ï½žOSã‚„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ã®æ”»æ’ƒï½žï¼šWebã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«æ½œã‚€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ãƒ›ãƒ¼ãƒ«ï¼ˆ2ï¼‰ï¼ˆ1/2 ãƒšãƒ¼ã‚¸ï¼‰ â€»ã”æ³¨æ„ ä»–ç¤¾ãŠã‚ˆã³ä»–çµ„ç¹”ã®Webã‚µã‚¤ãƒˆãªã©ã¸ã®ãƒãƒ¼ãƒˆã‚¹ã‚ãƒ£ãƒ³ãŠã‚ˆã³ãƒ‡ãƒ¼ã‚¿ã®å–å¾—ãªã©ã®è¡Œç‚ºã§å¾—ãŸæƒ…å ±ã‚’ä¾µå…¥ãªã©ã«æ‚ªç”¨ã™ã‚‹ã‹ã€ã¾ãŸã¯åŒã˜ç›®çš„ã‚’æŒã¤ç¬¬ä¸‰è€…ã«æä¾›ã—ãŸæ™‚ç‚¹ã§é•æ³•ã¨ãªã‚Šã¾ã™ã€‚ã”æ³¨æ„ãã ã•ã„ã€‚ æœ¬ç¨¿ã®å†…å®¹ã‚’æ¤œè¨¼ã™ã‚‹å ´åˆã¯ã€å¿…ãšå½±éŸ¿ã‚’åŠã¼ã•ãªã„é™ã‚‰ã‚ŒãŸç’°å¢ƒä¸‹ã§è¡Œã£ã¦ä¸‹ã•ã„ã€‚ ã¾ãŸã€æœ¬ç¨¿ã‚’åˆ©ç”¨ã—ãŸè¡Œç‚ºã«ã‚ˆã‚‹å•é¡Œã«é–¢ã—ã¾ã—ã¦ã¯ã€ç†è€…ãŠã‚ˆã³æ ªå¼ä¼šç¤¾ã‚¢ãƒƒãƒˆãƒžãƒ¼ã‚¯ãƒ»ã‚¢ã‚¤ãƒ†ã‚£ã¯ä¸€åˆ‡è²¬ä»»ã‚’è² ã„ã‹ãã¾ã™ã€‚ã”äº†æ‰¿ãã ã•ã„ã€‚ ã€Œç¬¬1å›ž ã‚µãƒ¼ãƒã®ãƒ•ã‚¡ã‚¤ãƒ«ãŒä¸¸è¦‹ãˆï¼Ÿï¼ã€ã§ã¯ã€ã€ŒForceful Browsingï¼ˆå¼·åˆ¶çš„ãƒ–ãƒ©ã‚¦ã‚ºï¼‰ã€ã‚„ã€ŒPath Traversalï¼ˆãƒ‘ã‚¹ã®ä¹—ã‚Šè¶Šãˆï¼‰ã€ã«ã‚ˆã£ã¦ã€ä»»æ„ã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’èªã¿å‡ºã•ã‚Œã¦ã—ã¾ã†å±é™ºæ€§ã«ã¤ã„ã¦ç´¹ä»‹ã—ãŸã€‚ ä»Šå›žã¯ã€Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§
babydaemons 2007/02/15
Computing

Database

ADO
ãƒªãƒ³ã‚¯
1