¤W¤@¸`»¡¦W¤F¦p¦ó¨Ï¥ÎMATLAB¹ï¸ê®Æ®w¶i¦æ¬d¸ß¡A¥»¸`±N»¡©ú¦p¦ó¹ï¸ê®Æ®w¶i¦æ§ïÅÜ¡A¥]§t·s¼W¡B×§ï»P§R°£¡C
²³æ¦a»¡¡AMATLAB ¯à°÷¸g¥Ñ ODBC ©M¹ï¹ï¸ê®Æ®w¶i¦æ¾Þ±±¡A¦]¦¹©Ò¦³ SQL ©R¥O¯à¹F¨ìªº¥\¯à¡AMATLAB ¤]³£¯à¸g¥Ñ¤U¹F SQL ©R¥O¨Ó°µ¨ì¡C¦¹¥~¡AMATLAB ªº¸ê®Æ®w¤u¨ã½c¤]´£¨Ñ¤F¥t¥~¤@¨Ç©R¥O¡A¯à°÷¹ï¸ê®Æ®w¶i¦æ×§ï¡C
¦b¹Á¸Õ¥»¸`©Ò´£¨Ñªº½d¨Ò«e¡A§A¥²¶·¥ý¥H¤â°Êªº¤è¦¡¨Ó³]©w DSN¡A½Ð±N¸ê®Æ¨Ó·½¦WºÙ dsnScore02 «ü¨ì¥»¾÷¦ì¸mªº score02.mdb¡C¦P®É¦b¥H¤Uªº½d¨Ò¤¤¡A¨C¦¸¦b¶i¦æ¸ê®Æ®w¦s¨ú«e¡A§ÚÌ·|±N score01.mdb ªº¤º®e«þ¨©¨ì score02.mdb¡A¥HÁ×§K¦]¬°¦hÓ½d¨Òµ{¦¡½Xªº°õ¦æ¥ý«á¶¶§Ç¤£¦P¡A³y¦¨©Ò±oµ²ªG©M¥»®Ñ´yz¤£¤@Pªº±¡ªp¡C
º¥ý¡A§Ų́Ӭݬݦp¦ó¸g¥Ñ SQL ©R¥O¨Ó·s¼W¤@µ§¸ê®Æ¨ì¸ê®Æ®wªº¡C¤U±³oÓ½d¨Ò¡A±N·s¼W¤@µ§©m¦W¬°¡u¤j¤O¤ô¤â¡vªº¸ê®Æ¡A¹ïÀ³ªº SQL ©R¥O¬O
INSERT INTO score (studentID, studentName, final) VALUES (''00'', ''¤j¤O¤ô¤â'', 100)
µ{¦¡½X¦p¤U¡C
¥Ñ©ó§Ų́èS¦³«ü©w¨C¤@ÓÄæ¦ìªºÈ¡A©Ò¥H³o¨ÇÄæ¦ìªºÈ·|¥Ñ¸ê®Æ®w·íªì©Ò³]©wªºÄæ¦ì¹w³]ȩҨú¥N¡A¦pªG³o¨Ç¸ê®Æ®wÄæ¦ì¨S¦³¹w³]È¡AMATLAB §ì¦^¨Óªº¸ê®Æ´N·|¥X²{ NaN¡C
±µµÛ¡A§Ų́Ӭݬݦp¦ó¸g¥Ñ SQL ©R¥O¨Ó×§ï¸ê®Æ®w¡C¤U±³oÓ½d¨Ò¡A±N©Ò¦³´Á¥½¦Ò¤À¼Æ¡]final Äæ¦ì¡^¤j©ó©Îµ¥©ó 80 ¤Àªº¦P¾Ç¡Aª½±µ½Õ¦¨ 100 ¤À¡A¹ïÀ³ªº SQL ©R¥O¬O
UPDATE score SET final=100 WHERE final>=80
µ{¦¡½X¦p¤U¡C
¦b¤Wz½d¨Ò¤¤¡A¦³¥|Ó¤Hªº´Á¥½¦Ò¦¨ÁZ¡]final Äæ¦ì¡^³Qקאּ 100 ¤À¡C
§Ṳ́]¥i¤w¸g¥ÑSQL ©R¥O¨Ó§R°£¸ê®Æ¡C¤U±³oÓ½d¨Ò¡A±N©Ò¦³´Á¥½¦Ò¤À¼Æ¡]final Äæ¦ì¡^¤p©ó 80 ¤Àªº¦P¾Ç¡Aª½±µ§R°£¡A¹ïÀ³ªº SQL ©R¥O¬O
DELETE FROM score WHERE final<80
µ{¦¡½X¦p¤U¡C
¦b¤Wz½d¨Ò¤¤¡Aì¥ý¸ê®Æ®w¦³ 12 µ§¸ê®Æ¡A¸g¹L§R°£«á¡A¥u³Ñ¤U 5 µ§¸ê®Æ¡C
¦¹¥~¡ASQL ©R¥O¤]¥i¥H¥Î¨Ó²£¥Í¤@Ó¸ê®Æªí¡A¦]¦¹¦b¤U±³oÓ½d¨Ò¤¤¡A§Ú̪½±µ²£¥Í¤@Ó·sªº¸ê®Æªí¡AµM«á¶ñ¶i¥h¨âµ§¸ê®Æ¡AµM«á§â¸ê®Æªíªº¸ê®ÆÅã¥Ü¦b¿Ã¹õ¤W¡A½d¨Ò¦p¤U¡C
¥»¸`ªº³Ì«á¤@Ó½d¨Ò¡A¬O¤@Ó¤ñ¸û§¹¾ãªº½d¨Ò¡A¨ä¥\¯à¦p¤U¡G
- Ū¤J score02.mdb ªº score ¸ê®Æªí
- pºâ¨C¤@Ӿǥͪº´Á¥½Á`¦¨ÁZ¡Aµ¥©ó§@·~¥§¡¼¥H 30%¡A¥[¤W´Á¤¤¦Ò¦¨ÁZ¡]midterm Äæ¦ì¡^¼¥H 30%¡A¦A¥[¤W´Á¥½¦Ò¡]final Äæ¦ì¡^¦¨ÁZ¼¥H 40%¡C
- ±N¨C¤@Ӿǥͪº´Á¥½¦¨ÁZ°e¨ì¸ê®Æ®wªº overall Äæ¦ì¡C
- ±N³Ì«á¦¨ÁZpºâµ²ªG¼g¦¨¤@Óºô¶¡A¥H«K¤½¥¬µ¹¾Ç¥Í¬Ý¡C
¦b¥»½d¨Òªºì©l½X¡A§Ṳ́w¸g¥[¤J¤j¶qµù¸Ñ¡A¦]¦¹¤£¦A»¡©úµ{¦¡²Ó¸`¡A½d¨Ò¦p¤U¡C
©Ò±o¨ìªººô¶¦p¤U¡A¨ä¤¤³Ì«á¤@ª½¦æ´N¬Opºâ¥X¨Óªº´Á¥½¦¨ÁZ¡C

MATLABµ{¦¡³]p¡G¶i¶¥½g