?????????

admin

???????????

????

?????

???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????

??????????????????

?????? ? ?

????????????

? ?

???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????

21???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????,???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????

????????????????????????????????????????????????????????????????????????????????????

???? ???? ???? ???? ?????

The Design and Implementation of School Management System

��used for teachers

Abstract

Students Information Management System is indispensable part of the education department. It is very important to the teaching management and decision makers. It provides a lot of convenience and improves work efficiency. However, for a long time, people used the traditional Student Information Management System. The traditional method gets many disadvantages: low efficiency, bad privacy protection, easily to make mistake. It wastes lots costs of human and financial capital, producing massive document data. These would take great difficulties for the management.

21st century is the age of information industry. Computers are the main equipments in our daily economic or social life because of the global information technology. Meanwhile, Chinese education enterprise get vigorous development: graduation rates generally improved, all kinds of school scale unceasingly expands. Traditional Students Management gets harder because of the high quantity of students. So the New Students Management should be more efficiency and standard. Using the computer can be convenient for large data increasing, deleting, updating, and operating. It has incomparable virtues that manual administration can never get: searching quickly and easily, reliability, high storage capacity, better secrecy, long service life, low cost and so on. These are inseparable from the database technology and network technology support. The Students Information Management is the school management status as one of the important tasks, the former manual operation already can not adapt to the needs of the office now. In order to get rid of tedious work and improve working efficiency, we should make computer information processing become inevitable. Developing the perfect function and safe and reliable management system can greatly improve the utilization rate of school.

Keywords? Student Management Software Engineering B/S Browser

? ?

? ? ..................................................... 1

?1? ?????? ......................................... 2

?1.1? ???? ........................................... 2

?1.2? ???????? ................................... 2

?1.3? ???? ........................................... 3

?2? ????? ........................................... 5

?2.1? ??????? ..................................... 5

?2.2? ??????? ..................................... 6

?2.3? ????? ......................................... 6

?3? ???? ............................................. 7

?3.1? ???? ........................................... 7

?3.2? ???? ........................................... 8

?3.3? ?????? ....................................... 8

?3.4? ????? ......................................... 9

?3.5? ??UML??? .................................... 11

?4? ???? ............................................ 12

?4.1? ?????? ...................................... 12

?4.2? ????????? ................................ 14

?4.3? ??????? .................................... 17

?4.4? ?????? ...................................... 18

?5? ????? .......................................... 19

?5.1? ????? ........................................ 19

?5.2? ??????? .................................... 20

?5.3? ???E-R? ...................................... 22

?5.4? ???? .......................................... 23

?5.5? ???? .......................................... 24

??? ???? ............................................ 26

?6.1? ????????? ................................ 26

?6.2? ???? .......................................... 27

?6.3? ???????? .................................. 28

?6.4? ?????? ...................................... 29

?6.5? ?????? ...................................... 30

?6.6? ?????? ...................................... 31

? ? .................................................... 33

???? .................................................... 34

? ? .................................................... 35

???????????????????????(???)

?????????????? ???? ????????????????? ???? ................................ ......... 5? 1 ? ?????? ........................................................................................................................5 ? 2 ? ?????? ........................................................................................................................5 ? 3 ? ???? .................................................................................................................................6???? ???? ................................ ......... 11? 4 ? ???????? ............................................................................................................ 11 ? 5 ? ?????? ..................................................................................................................... 145.1 ????..................................................................................................................................... 15 5.2 ????..................................................................................................................................... 15 5.3 ????..................................................................................................................................... 16? 6 ? ?????? ..................................................................................................................... 166.1 ????..................................................................................................................................... 17 6.2 ????..................................................................................................................................... 17 6.3 ????..................................................................................................................................... 18 6.4 ????..................................................................................................................................... 18? 7 ? ????? ......................................................................................................................... 197.1 ?????................................................................................................................................. 19 7.2 ?????................................................................................................................................. 19 7.3 ?????................................................................................................................................. 20???? ???? ................................ ......... 20? 8 ? ???? .............................................................................

..................................................208.1 ????..................................................................................................................................... 20 8.2 ????????..................................................................................................................... 25 8.3 ??????............................................................................................................................. 26? 9 ? ???? .............................................................................................................................. 299.1 ?????????................................................................................................................. 29 9.2 ??????............................................................................................................................. 30 9.3 ????..................................................................................................................................... 329.4 ??????............................................................................................................................. 35? 10 ? ???? ............................................................................................................................3710.1 ????................................................................................................................................... 37 10.2 ??????........................................................................................................................... 37 10.3 ????????................................................................................................................... 38 10.4 ??????????........................................................................................................... 40 10.5 ??????........................................................................................................................... 40 10.6 ????????................................................................................................................... 43 10.7 ????................................................................................................................................... 44 10.8 ???????....................................................................................................................... 46 10.9 ??????........................................................................................................................... 47 10.10 ??????......................................................................................................................... 49? 11 ? ???? ................................................................

............................................................5111.1 ????................................................................................................................................... 51 11.2 ??????........................................................................................................................... 53 11.3 ??????........................................................................................................................... 53 11.4 ??????........................................................................................................................... 55? 12 ? ???? ........................................................................................................................... 5612.1 ?????............................................................................................................................... 56 12.2 ????................................................................................................................................... 58 12.3 ??????........................................................................................................................... 59 12.4 ?????............................................................................................................................... 61 12.5 ??????........................................................................................................................... 62???? ?????................................ ........ 64? 13 ? ??? ................................................................................................................................ 6413.1 ??????........................................................................................................................... 64 13.2 ??????........................................................................................................................... 65 13.3 ????????................................................................................................................... 67 13.4 ????????................................................................................................................... 68 13.5 ??????........................................................................................................................... 7113.6 ?????????............................................................................................................... 72 13.7 ????????................................................................................................................... 73 13.8 ??????????........................................................................................................... 75? 14 ?

??? ................................................................................................................................ 7714.1 ????????................................................................................................................... 77 14.2 ?????????............................................................................................................... 78???? ???? ................................ ......... 79? 15 ? ???? ........................................................................................................................... 7915.1 ??????........................................................................................................................... 79???? ???? ? ? ?? 1? ? ????????? ???? ? ????? ? ??�??�? ?????? ????�?? ???? ?�??? ?? ?? 2 ? ?????????????????????????????? ????????? ??????????????????????????????????? ?????????????????????????? ????????? ??????????????????????????????????? ??????????????????????????????????? ?? ??????????????????????? 1. ??????????????????????????????? ??????????????????????????????????? ?????????????????????????? 2.??????????????????????????? ????? ??????????????????????????????????? ???????????????????�????�???? 3.???????????????????????????????? ?? ???????????????????????? ?????????? 4.???????????????????????????????? ??????????????????????????????????? ?????????????????????????????? ????? ??????????????????? ???????????????????????????????????????????????????????????

???????? ??????????????????????????????????? ??????????????????????????????????? ??????????????????????????????????? ??????????????????????????????????? ?????????????????????????????????? ??????????????????????????????????? ?????????????????????????????????? 1.????????????? 2.??????????? ????????????????????? ?????????????????? 3.??????????????????�????� ???????? ????????????????????? 4.???????????????????????????????? 5.???????????????? ????????????????????????2010 ? 3 ???? ?????????????????????????????????? ??????????????????????????????????? 2010 ???????????????????????????????? ????? ?????????????? ???????? ????? ???? ????????????????????????????????? ???? 3??????????????? ?? ??????? ?excel???? ?????? ????????????????????? ???????? ???????????????????? ? ? ????? ? ? ???? ? ?? ?? ? ??????? ??????? ??????? ?? ? ???????? ???????? ???????? ????????? ?????????? ??????? ?????? ? ???????????????????? ??????????? Excel ??????? ??????????????????????????????????? ?????? ??????????? ??????????? ???????? ??????????????????????????????????? ?????

?????????????????????????

???????

??????2013?68?

?????????????????? ????????????????

??????????????????????????????

????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????

???????????????????????????????????????????????????????2014?1?10?????????????????????????????????????????????????????????????????

??????????????????????????????

????????????????????????????????????????????????????????????????????????????????????????????????

????????????????????�???????????????????????????????????????????�??????????????????????????????�????????????????????????????????????????????????????????????????????10???????????�???????????????????????????????????????????????????????????????????????????????????????????????????

??????????????????????????????????????????????????

?????????????????????????

????????? ????????

2013?12?30?

???

??????????????

????????

????????

1. ?????????????????????????????????????????????

2.???????????????????????

3.??????????????????????????????

4.???????????????????

5.?????????????

6.???????????????????

7.?????????????????????????

8.???????????????????????????????????????????????

9.????????????????????????????????????

?????????????

1.??????

?1?????????

?????????????????????????

????????????????????????�??�?????????????

???????????????????????????????????????????????????????????????�??�?????

?2???????

??????????????????????????????????????????

?????????????????�??�?????

2?????????????

??????????????????????????????????????????????????????????�??�?????????????

???????????????�??�???????????�??�??????????�???�????????????????


??????????????????
?????http://www.850500.com/news/62009.html
?????,??!