1
а MVC ࢎᄬঁᇻຯຎૻՍࢬϕԄᇶᏤ௲ᏢѳѠीϐࣴز
Design and Study of an Interactive Streaming Remote Vision for
Computer-Assisted Instruction Platform by Using MVC
Techniques
݅ߪؼ** ܴ҅*
ύ୯ЎϯεᏢၗૻᆅس হמೌᏢଣၗૻᆅسᖱৣ
Ǻ
ivan_0629@yahoo.com.tw
Ǻ
cmchang@cc.hwh.edu.tw
1 ტء֮ਢطᇖܗขسഏઝᄎՕറسፖറᠲૠขسΔૠټጠΚψᚨشᇷறץ։࣫ऄ൶ಘᎸ তඒᑇᖂհᜎயေ۷ፖઔߒΫאਬഏ՛၏ᠦඒᖂጻࠏωΖNSC 94-2815-C-146 -006 ΩS
ᄔा
ҁፕЎޑҞࣁගٮԴৣϷᏢғϐ໔ϕޑ ጕᇶշ௲ᏢسǴ่ӝҞനࢬՉޑຎૻՍࢬǴ ၲډջਔጕҬፋޑфૈǴ٠ଛӝၗၲډጕ ႣऊǵᆅޑфૈǴёගϲ௲ৣ௲Ꮲࠔ፦ϷჹᏢ ғୢᚒזೲှเ৩Ǵคၸ Face by Face ջё ၲډᚈӛྎ೯ҬፋǴᏢғҭёၸҁسளޕ௲ৣ ࢂցԖޜǴԶܭጕගрୢᚒǴԖჴࣁ௲Ꮲޑ ঁჴҔޑ e-learning سǶServerᆄॄೢ ActiveX Control ΠၩǴ٠ගٮ
Սࢬ࣬ᜢୖኧ(ჴᡏ IP)ǴჴᇻᆄՍࢬ୍ܺǶServer ᆄ߾ࢎԖ Tomcat ᆛ।՛ܺᏔǶа MySQL ࢎس ၗǴ٠ճҔ MySQL-Connector ٰ٬ JSP ᆛ।ૈ Ӹڗ MySQL ၗϣޑၗǶ ҁسኳԄࢂа MVC ࢎᄬ܌ࡌᄬрٰޑس Ǵϩޑϡҹа view ࣁЬǴController ॄೢ ှញٰԾ٬Ҕޣޑ InputȐᗖዬϷྖႵȑǴ٠೯ޕ
Model܈ View բޑׯᡂǶModel ॄೢᔈҔำԄ
ЬाޑՉࣁᆶၗᓯӸޑӦБǴၗޑҽࢂ ၸ JDBC բࣁྎ೯ޑᐏኺǴ٠ճҔ JavaBean բࣁس ϡҹǴԋࣁঁԖਏჴҔޑسǶ ᜢᗖຒǺMVCǵຎૻՍࢬǵe-learningǵActiveX ControlǵTomcatǵJDBCǶ
Abstract
Interdynamic assisting in order to offer teacher and student on-line assisted instruction is for the goal of this thesis, Streaming of Video Data to combine most popular one at present, reach the on-line function that talks immediately, and cooperate with the database to reach the functions of on-line making an appointment , management ,etc. , can improve teacher's teaching quality and answer the way to student's question fast , can be reached the two-way
communication and talked through Face by Face, students can also learn through this system whether the teacher is free !, and then putting forward the question on-linly, it is a useful e-learning system on the teaching to have in fact.
In fact, Server end is responsible for ActiveX Control download, the relevant parameter (entity IP ) that and offer bunch to flow, realize carrying bunch and flowing and serving far. Server end has Tomcat webpage server to withstand. Erect the systematic database with MySQL, and make use of MYSQL-Connector to enable JSP webpage to deposit and withdraw DATA in MySQL database.
This systematic way is with the system built and constructed out of MVC structure, represent some components and rely mainly on view, Controller is responsible for explaining Input from user (keyboard and Genius mouse), and tell Model or View to do the proper change. Model is responsible for the place where the behavior and materials with main application program store, the part of the database is as the bridge communicating through JDBC, and utilize JavaBean to become an effective and practical system as the systematic component.
Keywords: MVCǵStreaming of Video Dataǵ
e-learningǵActiveX ControlǵTomcatǵJDBCǶ
1.
ق
߈ԃٰᆛၡ௲ᏢޑᔈҔВڙډख़ຎǴ٬ள e-learning೬ᡏᅿᜪΨຫٰຫӭǶᆛሞᆛၡӧ௲ػᔈ ҔޑሽॶϞς७ڙख़ຎǴ௲ػႝᆉύЈܭ҇ ୯ 89 ԃೕჄǴගрၗૻ௲ػᕴᙔკǴځύჹܭว ᆛၡᏢಞϩΨुۓΑวीฝǶԶȨࡌᄬӄ҇ ᆛၡ௲ػǴࡌҥಖيᏢಞޑޗȩ߾ࢂࡷᏯ 2008 ୯ৎวख़ᗺीฝޑѤεЬືϐ\8^Ƕ ᙖҗႝတᆛၡᏢಞǴӧ௲ᏢޣᆶᏢಞޣϷ௲Ꮲ ൞ᡏȐπڀȑ໔ౢғϕԄᏢಞၸำޑѸाచҹǶᆛၡ൞ϟനεޑᓬᗺǴࢂڀԖঁձ܄ǵҬϕ܄ǵᡫ ࢲ܄ᆶӭኬ܄[1]ǶѬׯᡂΑӧڰۓޑਔ໔ӦᗺǴа ࣁൂᡏፐޑ௲ᏢኳԄᆶൂޑ௲Ꮲᕉ ნǴ٬௲ৣکᏢғय़ᖏᅿӄཥޑ௲ᏢኳԄ\3^ǵ ᏢಞࡘᆢǵӵՖၸᆛሞᆛၡၲԋפ൨Ծρ܌ሡा ޑၗૻکૈᙖҗႝတᆛሞᆛၡᘉܫڀԖ܄ ޑӭ൞ᡏ܄ޑسѦǴ׳׆ఈૈࡌҥǵֹԋ࣬ၨ Ϟسόኬޑӭ൞ᡏᘉܫسфૈǶᖐٯǺז ೲ၌ቹТၗύ܌ڀԖޑቹႽǴޔௗ൩٬Ҕޣ܌ ाኘܫޑΓǵ٣ǵނਔޑϪΕǴߦӭ൞ᡏኘ ܫسૈڀԖ׳ӭБߡεޑ܄ૈǴ٠Ъૈᙖ җᆅޣǵа٬ҔޣаϷ٬Ҕޣϐ໔όӕ ज़ޑᆅǴٰज़ڋঁόӕيϩϐ٬Ҕޣ܌ᏱԖ όӕޑسҞϐ٬Ҕज़Ǵঁࢳޑϩᆅ ڋǶӆޣǴӧӭ൞ᡏኞܫسύǴቚጕፕ фૈǴБߡ٬Ҕޣӧፕύջਔගр٬Ҕسа ϷۓسޑӚᅿୢᚒǴӵԜǴ׳ૈᡣسᆅޣ БߡΑှрسޑલഐǴаБߡ׳ཥǵׯ๓سǴ ٬س׳уֹ๓ǴаӝЯ٬Ҕޣሡ\2^ǶጕᏢ ಞࢂᅿᏢಞޣၸᆛሞᆛၡޑ൞ϟǴջਔЪזೲ ӦՉԾךᏢಞϷЬᏢಞޑБԄǶᏢಞޑӦᗺό ज़ܭ௲࠻ǴҭόӆҗԴৣ܌ЬᏤǶጕᏢಞᗦ֖Ծ ךᏢಞکЬᏢಞޑཀ఼ӧϣǴᏢಞޣѸሡЬᏢ ಞǴճҔጕᏢಞޑᕉნǴၲԋঁΓޑޕࡌᄬ܈ πբᕮਏޑගܹ\5^Ƕ ՠࢂຎૻӕϯΠǴᓎቨܰڙज़ڋԶ٬ளᆛ ၡࠔ፦ᒡೲࡋၸᄌǴԶᏤठ௲Ꮲࠔ፦ό٫Ǵٯ ӵǺቹႽೲࡋόӕǵᖂॣᒡᆶቹႽόૈӕਔ ၲǴӢԜࣴزճҔጕ܄ೕჄޑၮᆉٰှ،ᆛၡ ຎૻቨᓎሡǶ
2.
ࣴزБݤᆶࢬำ
ҁس௦Ҕ MVC ࢎᄬǴჹܭ ModelǵViewǵ Control֡ϩ໒ࡌǴView ϩܰܭϩ໒׳ཥᆢៈǴ Model ޑӸڗ֡ၸ Control ϡҹჴࡼӸڗӧଌ Կ ViewǴჹၗӼӄԖ࣬ჹޑޑӼӄ܄Ǵӵკ 1 ܌ҢǶӢԜ MVC ࢎᄬࢂᅿቶݱ௦Ҕޑीኬ ԄǶځҞޑࢂӧࢎᄬଯϕ܄ᔈҔسਔޑঁؼ ӳޑ೬ᡏࢎᄬ\7^ǴЬाᢀۺջࢂஒ٬Ҕޣࣚय़ک ځ܌ೀޑၗϩᚆ໒ٰ\4^Ƕ 1) ModelǺӧWeb-baseύޑModelεӭж߄ٿ ϩǴхࡴسރᄊϷၗکೕ߾ޑ Չϡҹ\5^Ƕ 2) ViewǺջࣁᆶ٬Ҕޣྎ೯ޑϕϟय़Ǵॄ ೢᡉҢModel ύޑၗǴΨ൩ࢂஒၗຎ ϯޑևǶ 3) ControllerǺନΑॄೢௗڙکೀ٬Ҕޣޑ ϕѦ׳х֖ΑᔈҔسӵՖӣᔈ٬Ҕޣ ޑᡄᒠ[8]ǴӢԜڀԖRequest ޑ Dispatcher фૈǶ!! ऩаJ2EE ѳѠբࣁMVCࢎᄬϐჴѳѠǴ߾Java Server PageࣁViewჴϐж߄[10]ǵServeletᜪ
ձуDispatcherᜪձ߾ࣁController ϐჴϐж߄
\4^ǴԶJavaBeans ܈Enterprise JavaBeans߾ࢂModel ჴϐж߄[5] [8] [10]Ǵӵკ 2܌ҢǶ ! კ 3!K3FF ӭቫԄޑࢎᄬ!! ԶҁፕЎޑҞࣁගٮԴৣϷᏢғϐ໔ϕޑ ጕᇶշسǴ่ӝҞനࢬՉޑຎૻՍࢬǴၲډջ ਔጕҬፋޑфૈǴ٠ଛӝၗၲډጕႣऊǵ ᆅޑфૈǴёගϲ௲ৣ௲Ꮲࠔ፦ϷჹᏢғୢᚒ זೲှเ৩Ǵคၸ Face by Faceջёၲډᚈ ӛྎ೯ҬፋǴᏢғҭёၸҁسளޕ௲ৣࢂցԖ ޜǴԶܭጕගрୢᚒǴԖჴࣁ௲ᏢޑঁԖ ҔޑسǴӧMVCࢎᄬΠीԜ௲ᏢѳѠǴӢԜ ࣴزࢎᄬϷՉᡯǴӵკ3܌ҢǶ! კ 4!ࣴزࢎᄬϷՉᡯ! วسᚉ! MVCࢎᄬፕ! سຑᆶፓ! سၮբϩ! ࣴز่݀! ࣴزᐒᆶҞޑ!
ӢԜҁࣴزճҔSWOTϩMVCࢎᄬΠϐس ᓬӍ༈ǴᆶεϩҞᇟقASPǵPHP໒วрٰޑ WebᔈҔٰբКၨǴӵ߄ 1 ܌ҢǶ ߄ 1 MVCࢎᄬϐSWOTϩ ᚌႨ)Strength*! ٭Ⴈ)Weakness*! 1. View ݙܭฝय़ ीǴόੋၗᆶᡄ ᒠೀ 2. Model ϡҹπբϩπ మཱǴόܰབష 3. Controllerᆢៈ View ᆶ Model ٿޣϐ໔ ޑᐱҥ܄ቚу 4. ำԄዸమධǴܰঅׯ 5. ቚำԄቸ܄Ϸӆճ Ҕ܄ 1. ΟቫϩܴǴՠำԄፄ ᚇࡋቚу 3/ኳࠠکຎკޑᝄϩ ᚆёૈ٬ளፓ၂֚ᜤ ٤! ᖲᄎ)Pqqpsuvojuz*! ౡ)Uisfbu*! 2/ MVC ቫόӕޑ ᔈҔǴёख़ፄ٬ҔǶ! 3/ Ԗ ճ ܭ ೯ ၸ π ำ ϯǵπڀϯ㰗ғᆅ ำԄዸ! 2/жዸЎҹቚӭǴᆅό ܰǴӢԜǴำԄीৣ ჹܭЎҹޑᆅሡा ᗺЈࡘ! ! Ъࣁᕇளၨ٫ޑᆛၡຎૻቨᓎሡǴࣴز٬Ҕ ጕ܄ೕჄޑၮᆉǴӃஒ،ᡂኧᓎၰύТࢤዴҥ (
X
ijǴi=1,2…, n.Ǵj=1, 2…, k) ǴаҞԄ ޑനεॶ (Max.∑
X
ij Ǵi=1,2…, n.Ǵj=1, 2…, k) ǴฅԶЬाޑज़ڋԄǺ∑
= = 1 1 i i ijX
=1, j=1, 2…, k.∑
ii==11X
ij*
1
/
)
(
1
≤
−
+
i
P
d
P
, i=1,2…,n. ijX
=0, 1. i=1, 2…, n.Ǵj=1, 2…, k ᇥܴǺҞڄኧ∑
X
ij ჴሞࢂᔕҞ ڄኧǴӢࣁ∑
X
ij =NǶ௦ҔԜҞڄԄޑҞޑ ࢂࣁΑၸጕ܄ೕჄǴрᅈىӚᅿᓎၰᓎቨज़ڋ ޑϪപТࢤኧǶനεϪപТࢤኧ߾ࢂၸᅌሀቚ നεǴёϪപТࢤኧаϷ௦Ҕጕ܄ೕჄှԶளǶ ӢԜҁᇻຯຎૻाଌS
j1ǴS
j2Ǵ…S
jw w ঁᆛၡຎૻТࢤǴ೭٤ТࢤԿϿ p+(p
1─p)/d , p+(p
2─p)/d , …p+(p
w─p)/d ७ቹТТࢤਔ໔ԿϿ рԛǶ3.
سфૈᆶࢎᄬ
3.1 سࢎᄬ კ 4 سࢎᄬკ Ӣޑႝတᇶշ௲ᏢǴᒿᆛၡጲࠁวǴ ςᅌᅌᙯӛᆛၡຬ൞ᡏϯ[2]Ǵԋࣁᆛၡ௲ᏢسǴ ᆛၡ௲Ꮲޑ٬ҔޣёаکϩණӧШࣚόӕӦ ޑ٬ҔޣӅӕᏢಞǴϕ࣬ࣴǴԶό߳ज़ܭ࠾ ഈޑ௲ᏢᕉნύǶ௲ৣکᆅޣΨёᙖҗᆛၡ໒ܫ ԄᕉნǴཥቚکঅׯ௲ϣǴ٬௲Ꮲϣ׳Ԗቸ ܄ǶၸຎૻՍࢬջਔמೌǴᏢғΨ൩ࢂ٬Ҕޣᆶ ௲ৣϐ໔ǴၸጕջਔᇟॣբፐޑံமǴΨё аᙖԜسբЈᡫޑҬࢬǴӢԜҁسࢎᄬკӵ კ 4 ܌ҢǶ ҁࣴز௦Ҕ Java ำԄᇟقڀԖၠѳѠϷЍජ ނҹᏤӛޑ܄[3] [4] [6] [8]ǴբࣁԜسޑ໒วำ ԄǴගٮԴৣϷᏢғϐ໔ϕޑጕᇶշ௲Ꮲس Ǵ่ӝҞനࢬՉޑຎૻՍࢬǴၲډջਔጕҬ ፋޑфૈǴ٠ଛӝၗၲډጕႣऊǵᆅޑ фૈǴӢԜҁسຎૻฯᡏၮբচࢎᄬӵკ 2 ܌ ҢǴၸ Sever ᆄຎૻୖኧޑሀǴᏢғёᙖҗຎ ૻՍࢬҗጕቹॣ௲ᏢǴᙖҗё٣ӃႣᒵϐຎૻՍࢬฝय़ǴբࣁፐࡕϐጕᇶᏤ௲ᏢǶ ӢԜᏢਠӧᏤΕ e-Learning ϐǴѸሡӃԖ e-Learning ޑౣǺόѝࢂஒፐำϣܫډᆛၡ ǴΨόѝࢂЇཥޑၗૻࣽמ܈ࡌঁᏢಞѳ ѠǴ൩ૈֹԋǶѸӣᘜᏢಞޑҁ፦Ǵ٩ԜѺ ԜᇻຯጕᏢಞࢎᄬǴሡीޑ௲аϷᆅ БԄ[8]Ƕӵკ 5 ܌ҢǶ კ 5 ຎૻฯᡏၮբচࢎᄬ 3.2 سჴբ 3.2.1ຎૻᒡচ dz
ClientᆄǺ२ӃाԖЍජ ActiveX מೌޑ Web BrowserǴωૈ٬Ҕ ActiveX Control ϡҹǶ٬Ҕޣ
ёၸ Web BrowserǴޔௗӧ Home Page ᒧڗ܌ ाޑ୍ܺҞǴԜਔ Server ᆄ൩ஒ܌ჹᔈډޑ
ActiveX ControlΠၩډ Client ᆄՉ[5] [12]Ƕ ServerᆄǺServer ᆄᆶ Windows ࣁѳѠǴ Server
ԏډ Client ᆄޑፎਔǴServer ᆄॄೢ ActiveX
ControlΠၩǴ٠ගٮՍࢬ࣬ᜢୖኧǴჴᇻᆄՍࢬ ୍ܺǶ 3.3 سฝय़ ҁᇻຯຎૻՍࢬϕԄᇶᏤ௲ᏢѳѠǴऩԴৣ གྷᏹբӼး೬ᡏޑᡯ๏ᏢғॺᏢಞǴԜਔǴჹܭ ᏹբฝय़ޑԴৣߡԖӭᅿБԄёаගٮฝय़๏Ꮲ ғǶҗόӕϐဦฦΕрǴߡёᆶԴৣጕӕ ܈ޣߚӕՉᇻຯ௲ᏢǴфૈӈϩࣁуΕ (a)Ǵӈ߄(b)Ǵӵკ 6 سฦΕฝय़܌ҢǶ ฦΕسЬฝय़ࡕǴځфૈӈ߄х֖Դৣӈ߄ (a)ǵӕᏢӈ߄(b)!ǵঁΓၗ׳ཥ(c)!ǵϦวѲ/ অׯ(d)!ǵႣऊ၌(e)фૈǴ٠ЪӧѓୁЬฝय़ ǴёᆶᏢғ܈ޣԴৣႣऊਔ໔ǵԛϷਔࢤǴӵ კ 8!سЬฝय़܌ҢǶ! ! ᗺᒧႣऊࡕǴջрკ 7 Client ᆄຎૻʏॣૻ Սࢬຎืय़ϯǴऩԖጕԖΓջрԜฝय़ǴᆶᏢ ғጕբϕԄޑፐࡕᇶᏤ௲ᏢǶ Ӣ௨ހᜢ߯Ǵ܌аკ 8 ӧΠ।Ǵаჴሞጕ բࣁҁፕЎسևฝय़Ƕ კ 6 ฦΕฝय़ კ 7 سЬฝय़
4.
่ፕᆶࡌ
ҁࣴزࣁᕇளၨ٫ޑᆛၡຎૻቨᓎሡǴࣴز ٬Ҕጕ܄ೕჄޑၮᆉٰှ،ᆛၡຎૻӕϯ௲Ꮲ ޑલഐǴၸԜᄽᆉݤዴჴᕇளගܹΑӕᒡຎ ૻޑࠔ፦Ǵ٠Ъа MVC চࢎᄬԜаᇻຯ௲Ꮲѳ ѠǴ٬ӚسၮբೕჄϷஒٰسۯ՜Бय़ᕇள кϩޑֹ๓ۯঅׯޜ໔Ƕ ӢԜҁࣴزჴᡍวाӵՖܹسϐф ૈǴନԵቾຎૻᓸᕭϐמೌѦǴ२ӃനЬाԵቾמ ೌϩ٬ҔޣᆄϷ Server ᆄϐ໔ޑᆛၡфکᓎ Ƕӧளޕᚈӛᇟॣຎᓎᒡϐख़ाϡનǴයࡑ ۳ࡕёаஒځߕуسϐύǴаబуǵቚமس ᘉܫԄϐӭϡǴ׳׆ᏇԖϺૈஒԜسϐी ኳԄᘉкܭځдϐѳѠ܈ᔈҔǶୖԵЎ
[1]ቅࡌֻǵ҇Ӽǵഋల࣓ǵቅሎ, ȸᔈҔܭጕ ᏢಞϐբЎץ᎙س,ȹ2004 ԃѠᆛሞᆛ ၡࣴ(TANET 2004), pp. 118-123, 2004. [2] ࡹ ᑊ ǵ ݅ ࡌ Ҧ , ȸ ᔈ Ҕ ܭ ᆛ ၡ ௲ Ꮲ ޑ Web-based ጕ᎙ڔπڀ,ȹ2001 ԃѠᆛሞ ᆛၡࣴ(TANET 2001), pp. 215-219, 2001. [3] ܴ݅݊,”ӧ J2EE ѳѠޑᔈҔسύǴуΕග ٮ Web Services фૈϐࣴزᆶी,ȹ ಃΜѤ ۛނҹᏤӛמೌϷᔈҔࣴ, pp. 545-549, 2003. [4] ᖙۺ݅ǵᒘᖄᅽǵШᐵ,” ᔈҔीኬԄаჴ բ MVC ࢎᄬ,ȹಃΜѤۛނҹᏤӛמೌϷᔈҔ ࣴ, pp.185-192, 2003. [5] ൫,” ٬Ҕ MVC ीኬԄٰीᆛ।ޑ ӝғނၗૻس,ȹύচεᏢၗૻπำࣴز܌ᅺ γፕЎ,PP.1-5,2004. [6] ܴౘ,” ᇻຯᅱܭрԋᇙำϐᔈҔ,ȹ ୯ ҥ మ ε Ꮲ Κ ᐒ ఓ π ำ ࣴ ز ܌ ᅺ γ ፕ Ў,PP.1-5,2004. [7] ՉࡹଣǴࡷᏯ 2008Ǻ୯ৎวख़ᗺीฝȐ2002- 2007ȑǴhttp://www.cepd.gov.tw/2008/index.htmǴ ҇୯ 91 ԃǶ [8]ᛕ ᛕ ޑ ઝ ஏ ୷ Ӧ Ǵ http://www.kenming.idv.tw/index.php?blog=5&m =20041107[9]Nicholas Kassem and the Enterprise Team “Designing Enterprise Applications with the J2EE Platform, Second Edition”, Version 1.0 ,Sun Microsystems, Inc., 2000
[10] Gunjan Samtani and Dimple Sadhwani, “EAI and Web Services-Easier Enterprise Application Integration?”,
http://www.webservicesarchitect.com/content/artic les/samtani01.asp ,October 17,2001
[11] Web Services Description Language (WSDL) 1.1 http://www.w3.org/TR/wsdl
[12] G. Booch, J. Rumbaugh, and I. Jacobson, The Unified Modeling Language User Guide, Addison Wesley, 2000.