±???í¨1y·????ˉàà?÷/·t???÷?á11μ?ì?μ?2￠?áo?????μ?êμ?ê?é??￡?ìá3?á??ùóú?ˉàà?÷/·t???÷?á11í?é??????μí3μ??ù±?éè??????￡??òòa?ééüá??μí3?÷1|?ü?￡?é?°êy?Y?aμ?éè??￡?×???ì???á?ó? ASP??ê?oíSql Server 2000?a·￠í?é??????μí3ê±μ?êy?Y?a·??ê??ê?oí?ˉì?í?ò3??×÷??ê?,2￠??3?á?2?·?êμ??′ú???￡í¨1y???μí3￡?ê1?§éú?éò?·?±?μ??úD￡?°í?é???DDí?é??????￡??B/S?á11μ??μí3ê1ó?ASP?a·￠ó???￡?Sql Server 2000×÷?aêy?Y?a?￡?μí3óD????μ?°2è?D?oí??o?μ?D??ü?￡?÷òaóD?ì???￠?ìê|?￠?§éúèyààó??§?￡?í?§???÷òa1|?ü°üà¨￡oó??§μ????￠??è?D??￠???¤?￠?ìê|ìá3??a??éê???￠?§éú?????￠2é?ˉ??3ì?à1?D??￠?￠??±í′òó??￡·t???÷???÷òa?úèY°üà¨￡oó??§1üàí?￠?ìê|1üàí?￠?§éú1üàí?￠è·è?éê???￠?òμ￥????￡¨ò?ê??ˉ?a?÷￡?×??ˉ?a?¨￡?D??￠·￠2??￠?òμ￥ó?×?o?2é?ˉ?￠??±í′òó?μè
±?????????è???￡o
μú1?? D÷ ?? 1
1.1 ??ìa±3?° 1
1.2 ?μí3???? 1
1.3 ?a·￠1¤???ééü 2
1.3.1 ASP ?ò?é 2
1.3.2 SQL Server 2000?ò?é 4
μú2?? ?ì??1üàí?μí3Dè?ó·??? 6
2.1 ??????ê? 6
2.1.1 ?μí3??±ê 6
2.1.2 ?a·￠???? 6
2.1.3 D??￠?èê? 6
2.2 ?ùóúB/S?á11μ?·?°?éè?? 7
2.3 ó??§Dè?óμ÷2é 8
2.4 ?μí3?éDDD?·??? 8
μú3?? ?μí3·????°êy?Y?á11éè?? 10
3.1 êy?Yá÷3ì·??? 10
3.2 ?μí31|?ü??ê? 11
3.3 ?μí31|?ü?á11í? 12
3.4 êy?Y?á11éè?? 12
3.4.1 ????êy?Y?á11éè?? 12
3.4.2 ???-?á11éè?? 13
3.4.3 ??àí?á11éè?? 16
3.5 êy?Y?a±íéè?? 17
3.5.1 ?§éúD??￠±í(studentInfo±í)éè?? 17
3.5.2 ?ìê|D??￠±í(teacherInfo±í)éè?? 17
3.5.3 רòμD??￠±í(specialFieldInfo±í)éè?? 18
3.5.4 °à??D??￠±í(classInfo±í)éè?? 18
3.5.5 °à??±?DT??3ìD??￠±í(classCourseInfo±í)éè?? 18
3.5.6 רòμ??DT??3ìD??￠±í(publicCourseInfo±í)éè?? 19
3.5.7 °à??±?DT??3ìé???D??￠±í(classCourseTeach±í)éè?? 19
3.5.8 רòμ??DT??3ìé???D??￠±í(publicCourseTeach±í)éè?? 20
3.5.9 ?§éú????D??￠±í(studentSelectCourseInfo±í)éè?? 20
3.5.10 ?§éú3é?¨D??￠±í(scoreInfo±í)éè?? 20
μú4?? ?μí3?÷òa1|?ü?ê??éè?? 21
4.1 ?μí3μ???μ?êμ?? 21
4.2 ?§éúD??￠1üàí?￡?éμ?êμ?? 21
4.3 ?ìê|D??￠1üàí?￡?éμ?êμ?? 22
4.4 ??3ìD??￠1üàí?￡?éμ?êμ?? 22
4.4.1 °à??±?D???3ììí?ó1|?üμ?êμ?? 22
4.4.2 רòμ??DT??3ììí?ó1|?üμ?êμ?? 24
4.5 ??3ì????1|?üμ?êμ?? 25
4.6 ?§éú????1|?üμ?êμ?? 25
4.7 3é?¨1üàí1|?üμ?êμ?? 26
4.7.1 ?ìê|ìí?ó?§éú3é?¨1|?üμ?êμ?? 26
4.7.2 ?§éú2é?ˉ??è?3é?¨1|?üμ?êμ?? 29
μú5?? ?ì??1üàí?μí3??DDμ÷ê? 30
5.1 ??DD 30
5.2 2aê? 30
5.2.1 2aê?μ???μ? 30
5.2.2 2aê?μ?×??ò 30
5.2.3 2aê?μ?·?·¨ 31
5.2.4 2aê?ó?ày 31
×ü?áó??1í? 32
2??????× 33
oó?? 34
????(?′3ìDò) 1
?ì1 ?μí3μ????￡?é′ú??(checkLogin.asp) 1
?ì2 ?§éúD??￠ìí?ó1|?ü′ú??(studentInfoAdd.asp) 2
?ì3 ?§éúD??￠2é?ˉ1|?ü′ú??(studentInfoManage.asp) 3
?ì4 ?§éúD??￠2é?′?°DT??1|?ü′ú??(studentInfoDetail.asp) 8
?ì5 ?§éúD??￠é?3y1|?@@ìDò′ú??(studentInfoDel.asp) 12
?ì6 ?ìê|D??￠1üàíáD±í1|?@@ìDò′ú??(teacherInfoManage.asp) 12
?ì7 °à??±?DT??3ììí?ó1|?@@ìDò′ú??(classCourseInfoAdd.asp) 16
?ì8 °à??±?DT??3ì????D??￠ìí?ó1|?@@ìDò′ú??(classCourseTeachAdd.asp) 20
?ì9 ?§éú????1|?@@ìDò′ú??(courseSelect.asp) 21
?ì10 ?ìê|ìí?ó?§éú3é?¨1|?@@ìDò′ú??(scoreInfoAdd.asp) 24
?ì11 ?§éú3é?¨2é?ˉ1|?@@ìDò′ú??(scoreInfoQuery.asp) 28