Ynϥ MATLAB ӹƮwidߩέקAy{iHUCXӨBJG
- ]w DSNA MATLAB g DSN ODBC ӾޱƮwC]ШW@`^
- ϥ logintimeout Oӳ]w MATLAB biƮwsɡA̪ճsɶCҦpAڭ̥i logintimeout(5) ӳ]wɶ 5 CbճsƮwɡA@WLɶAMATLAB NͿ~TӤAisC
- ϥ database OӳsܸƮwA榡pUG
conn = database(dsn, loginName, password)
- 䤤 dsn ObBJ 1 ҳ]w DSNAloginName M passwordhOsƮwbMKXCYƮwݱbMKXAhoӰѼƳiH]wŦrCҶǦ^ܼ conn hONƮwsC
- ϥ ping OˬdƮwsAAҦp ping(conn)CoBJºOFˬdƮwsAAb@{XAiHٲC
- ϥ exec OӰ SQL ROAöǦ^ cursor AH}lơC榡pUG
cursor = exec(conn, sqlCommand)
- 䤤 conn ObBJ 3 ҳ]w ƮwsAsqlCommand hO檺 SQL ROAҶǦ^ cursor AN SQLRODηq覡Aڭ̥iHھڦDӨoҦơC
- iHϥ setdbprefs Oӳ]w^Ǹƪ榡A@O}C]w]ȡ^άOc}CAԨ᭱dҡC
- ϥ fetch OӧơAҦp cursor = fetch(cursor, 10) |10ơAñNƦsb cursor Data C
- N cursor ƶǦ MATLAB ܼơAҦpGsongData = cursor.DataC
- iHШϥ cursor ӨoUF SQL ROұo쪺ҦơC
- ̫iHϥ close O cursor θƮwsC
oXӨBJAݰ_Ӧ@cơAbھާ@ɡAëDpQCڭ̪ݤ@ӽdҡA|eiJpCbUoӽdҤAڭ̨ϥΫezBJAXsong ƪ] song01.mdb^ơCMAbզdҮɡAAϥΫe@`kӳ]w DSNAN dsnSong01 V song01.mdb mCdҦpUC
bWzdҤAcursor @ΡAŪɮɩҥΪɮСAڭ̦bUF@SQLROAiHOƤŪXpCҦpAcursor = fetch(cursor, 8) @άOg cursor 8 ơApGA@UF cursor = fetch(cursor, 2)AN|UⵧơAðO cursor CpGƶqjAڭ̤]iHUF cursor = fetch(cursor) Aɷ|NҦƥ^Aìb cursor C
b cursor conn eAA]iHb MATLAB J conn άO cursorANiHݨoӪ쩳äFǤTC
t~ڭ̥iH`NAǦ^GOb@Ӳ}CAè̷ƫAPӦPƫAAҦpƭȩΦr굥COoǸƨä]tW١AYnW١AiHϥ columnnames OALO٦ rows]Ƶơ^Bcols]Ӽơ^Bwidth]Y쪺eס^Battr]Y쪺ҦT^AdҦpUC
bWzdҤAcursor ҶǦ^ƬO}CAڭ̥iHϥ setdbprefs OAӱNǦ^Ƨ令c}CAdҦpUC]b榹dҤeAAʳ]wDSNAYN dsnScore01 VdҩҥΪƮw score01.mdbC^
bWzdҤAǦ^ܼ score O@ӵcܼơA]t 8 AC@ȫhO@Ӳ}CA]tƪ song ȡC
OWzwƤ覡AoOŦXڭ̻ݭnCڭ̬O_Ǧ^ഫ@ӵc}CACӤNO@ơAçƮwOCӤOHO֩wAڭ̩ҭnΨ쪺OO cell2structAӱN}Cഫc}CAdҦpUC
ѤWzdҥiHݥXAscoreO@Ӳ}CAOϥcell2structӶiഫAscore2wgܦO@ӵc}CA䤤C@ӤNO@ơAӥBC@ӤWٳMƮwW٤@PC
pGƶqܤjAYnb MATLAB ˵AäOܤKAiѨMDءG
- ϥMATLABu}Cs边v]Array Editor^˵CҦpLWzdҫAiHbMATLABJ open score open score2ANiH˵}CeA]iHקC
- ]iHNƼgAHKWU[ݡC
UoӽdҡAڭ̨ϥΤF@ӵ̶}o struct2html.mAiHNc}Cee{ܺAHK[ݡAdҦpUG
ҲͪspUG

HWOwƮwdߡAU@`NpƮwiקC
MATLAB{]pGig