W@`WFpϥMATLABƮwidߡA`NpƮwiܡA]tsWBקPRC
²aAMATLAB g ODBC MƮwiޱA]Ҧ SQL ROF쪺\AMATLAB ]gѤUF SQL ROӰC~AMATLAB Ʈwuc]ѤFt~@ǩROAƮwiקC
bե`ҴѪdҫeAAHʪ覡ӳ]w DSNAбNƨӷW dsnScore02 쥻m score02.mdbCPɦbHUdҤACbiƮwseAڭ̷|N score01.mdb e score02.mdbAHקK]hӽdҵ{XᶶǤPAyұoGMѴyz@PpC
Aڭ̨Ӭݬݦpg SQL ROӷsW@ƨƮwCUoӽdҡANsW@mWujOvơA SQL ROO
INSERT INTO score (studentID, studentName, final) VALUES (''00'', ''jO'', 100)
{XpUC
ѩڭ̨èSwC@쪺ȡAҥHo쪺ȷ|ѸƮwҳ]ww]ȩҨNApGoǸƮwSw]ȡAMATLAB ^ӪƴN|X{ NaNC
ۡAڭ̨Ӭݬݦpg SQL ROӭקƮwCUoӽdҡANҦҤơ]final ^jε 80 PǡAզ 100 A SQL ROO
UPDATE score SET final=100 WHERE final>=80
{XpUC
bWzdҤA|ӤHҦZ]final ^Qקאּ 100 C
ڭ̤]iwgSQL ROӧRơCUoӽdҡANҦҤơ]final ^p 80 PǡARA SQL ROO
DELETE FROM score WHERE final<80
{XpUC
bWzdҤAƮw 12 ơAgLRAuѤU 5 ơC
~ASQL RO]iHΨӲͤ@ӸƪA]bUoӽdҤAڭ̪ͤ@ӷsƪAMihⵧơAMƪܦbùWAdҦpUC
`̫@ӽdҡAO@Ӥ㪺dҡA\pUG
- ŪJ score02.mdb score ƪ
- pC@Ӿǥͪ`ZA@~H 30%A[WҦZ]midterm ^H 30%AA[Wҡ]final ^ZH 40%C
- NC@ӾǥͪZeƮw overall C
- N̫ᦨZpGg@ӺAHKǥͬݡC
bdҪlXAڭ̤wg[JjqѡA]A{Ӹ`AdҦpUC
ұo쪺pUA䤤̫@NOpXӪZC

MATLAB{]pGig