Ö°¹¤ÐÅÏ¢¹ÜÀí¼°²éѯϵͳµÄÉè¼ÆÓëʵÏÖ_¼ÆËã»úרҵÂÛÎÄ
·¢²¼Ê±¼ä£º
2015-01-17
À´Ô´£º
ÈË´ó¾¼ÃÂÛ̳
¼ÆËã»úרҵÂÛÎÄ·¶ÎÄ
Ŀ¼
Õª ÒªI
ABSTRACTII
µÚ1 ÕÂ ÒýÑÔ1
1.1Ö°¹¤ÐÅÏ¢¹ÜÀí¼°²éѯϵͳµÄ±³¾°·ÖÎö1
1.2¿ª·¢Ö°¹¤ÐÅÏ¢¹ÜÀí¼°²éѯϵͳµÄ±ØÒªÐÔ1
µÚ2 Õ ÐèÇó·ÖÎö3
2.1Ö°¹¤ÐÅÏ¢¹ÜÀí¼°²éѯϵͳÉè¼ÆµÄÄ¿µÄµÄ·ÖÎö3
2.2Ö°¹¤ÐÅÏ¢¹ÜÀí¼°²éѯϵͳµÄϵͳÐèÇó3
2.3Ö°¹¤ÐÅÏ¢¹ÜÀí¼°²éѯϵͳµÄ¹¦ÄÜÐèÇó·ÖÎö3
µÚ3Õ ϵͳ¼¼ÊõÒÔ¼°ÔËÐл·¾³µÄÐèÇó·ÖÎö5
3.1 ASP¼¼Êõ¼ò½é5
3.2 SQL SERVER¼ò½é5
3.3 SQLÓï¾ä¼ò½é6
3.4 IIS¼ò½é7
3.5 ¿ÉÐÐÐÔ·ÖÎö7
3.6 ÔËÐл·¾³8
µÚ4Õ Êý¾Ý¿âÉè¼Æ9
4.1Óû§ÐÅÏ¢±í£¨user±í£©9
4.2Ö°¹¤¹¤×Ê±í£¨wage±í£©9
4.3Ö°¹¤±£ÏÕ±í£¨Insurance±í£©9
4.4Ö°¹¤¸öÈËÐÅÏ¢±í£¨employee1±í£©10
4.5ϵͳE-Rͼ12
µÚ5Õ ϵͳÉè¼ÆÓëʵÏÖ13
5.1 ¹¦ÄÜÄ£¿é»®·Ö13
5.1.1 ¹¦ÄÜÄ£¿é»®·Öͼ13
5.1.2 ¹¦ÄÜÄ£¿é½éÉÜ14
5.2 ¹¦ÄÜÄ£¿éµÄʵÏÖ14
5.2.1ϵͳµÇ¼ģ¿éµÄʵÏÖ15
5.2.2×¢²áÐÂÓû§Ä£¿éµÄʵÏÖ17
5.2.3Óû§Ñ¡ÔñÄ£¿éµÄʵÏÖ19
5.2.4ÆÕͨÓû§²éѯ¼°Ð޸ĸöÈ˹«¹²ÐÅϢģ¿éµÄʵÏÖ21
5.2.5ÆÕͨÓû§²éѯ¸öÈ˵µ°¸ÐÅϢģ¿éµÄʵÏÖ23
5.2.6ÆÕͨÓû§²éѯȫ²¿ÐÅϢģ¿éµÄʵÏÖ24
5.2.7¹ÜÀíÔ±Ôö¼Ó½ÌÖ°¹¤ÐÅϢģ¿éµÄʵÏÖ28
5.2.18¹ÜÀíԱɾ³ý½ÌÖ°¹¤ÐÅϢģ¿éµÄʵÏÖ30
µÚ6Õ ϵͳ²âÊÔÓëÔËÐÐ32
6.1²âÊÔµÄÄ¿µÄºÍÈÎÎñ32
6.2 ϵͳ¿ª·¢»·¾³32
6.3 ²âÊÔ¹ý³Ì32
µÚ7Õ ϵͳÆÀ¼ÛÓëά»¤35
7.1 ϵͳµÄÆÀ¼Û35
7.2 ϵͳά»¤35
µÚ8Õ ½áÂÛ36
Ö л37
²Î ¿¼ ÎÄ Ï×38
Õª Òª
±¾ÏµÍ³ÎªÖ°¹¤ÐÅÏ¢¹ÜÀí¼°²éѯϵͳµÄÉè¼ÆÓëʵÏÖ£¬±¾ÈËÒÔijѧԺ½ÌÖ°¹¤Îª±¾ÏµÍ³µÄÀ¶±¾£¬°üÀ¨¸ÃѧԺ½ÌÖ°¹¤ÆÕͨԱ¹¤µÄ¸öÈËÈËÊÂÐÅÏ¢¡¢µµ°¸ÐÅÏ¢¡¢¹¤×ÊÐÅÏ¢ºÍ±£ÏÕÐÅÏ¢µÄ²éѯºÍ¸ÃѧԺ½ÌÖ°¹¤¹ÜÀíÔ±¶ÔÆÕͨԱ¹¤µÄ¸öÈËÈËÊÂÐÅÏ¢¡¢µµ°¸ÐÅÏ¢¡¢¹¤×ÊÐÅÏ¢ºÍ±£ÏÕÐÅÏ¢µÄ¹ÜÀí¼°²éѯ¡£
±¾ÏµÍ³²ÉÓÃASP+SQL SERVER×÷ΪϵͳµÄ±àд¹¤¾ßºÍÊý¾Ý¿â£¬Ê¹ÓÃSQLÓïÑÔ×÷ΪÊý¾Ý¿âµÄ²Ù×÷ÓïÑÔ¡£Ö°¹¤ÐÅÏ¢¹ÜÀí¼°²éѯϵͳÖ÷ÒªÌṩְ¹¤ÐÅÏ¢²éѯ,·½±ã¹ÜÀíµÄÍøÉÏÐÅÏ¢²éÔÄƽ̨,Ö°¹¤¿ÉÒÔͨ¹ý¸Ãϵͳ²éÔÄÓë×Ô¼ºÏà¹ØµÄÐÅÏ¢£¬°üÀ¨¸öÈËÈËÊÂÐÅÏ¢¡¢¹¤×ÊÐÅÏ¢¡¢±£ÏÕÐÅÏ¢ÒÔ¼°ÆäËûÐÅÏ¢µÈ¡£ÏµÍ³¹ÜÀíÔ±¿ÉÒÔʵÏÖÒÔÉϵÄËùÓй¦ÄÜ,»¹ÄܶÔÖ°¹¤ÐÅÏ¢½øÐÐÌí¼Ó,ÐÞ¸Ä,ɾ³ý,²éѯµÈ²Ù×÷£¬²¢ÉèÖÃȨÏÞʹһ°ãÓû§ÎÞ·¨½øÈë¹ÜÀíԱģ¿é¡£
¹Ø¼ü´Ê£ºASP£¬SQL£¬¹ÜÀíÐÅϢϵͳ
ABSTRACT
The information management system for workers and for the design and implementation, in a College faculty-based system based on the general staff, including College staff and personnel of personal information, files, wage information and insurance information enquiries and College faculty administrator of the General staff of personal and personnel information, files, wage information and insurance information management and query.
The system uses ASP and SQL SERVER as a system of preparation tools and databases, use SQL database language as a language of the operation. Employees¡¯ information management and query system is mainly to provide information query and easy managing platform for interner information query, and workers can access the system and its related information, including individual personnel information, wage information, insurance information and other information. System administrators can not only achieve all the functions mentioned above, but also add, edit, delete, query employees¡¯ information and other operations, and set up permissions so that users can not enter the general manager module.
Keywords: ASP, SQL, MIS