Õª Òª
±ÏÒµÉè¼Æ×÷Ϊ¸ßУѧÉú±ÏҵǰµÄ×îºóÉè¼Æ¿Î³Ì£¬ÊǶÔѧÉú×ÛºÏÄÜÁ¦¼ìÑé¼°Ó¦ÓÃÄÜÁ¦ÅàÑøµÄÖØҪ;¾¶¡£Í¨¹ý±ÏÒµÉè¼Æ¹ÜÀíϵͳ£¬Äܹ»Ê¹Ñ§ÉúÓëÀÏʦ½øÐÐÓÐЧµÄ¹µÍ¨£¬±ÏÒµÉè¼Æ¹ý³ÌÖеÄÒªÇóºÜºÃµÄµÃµ½Íê³É£¬¿ÎÌâ¹ÜÀíÒ²ºÜ·½±ã¡£±¾¿ÎÌâÖ÷ÒªÕë¶ÔÓÚ¸ßУµÄ±ÏÒµ»·½Ú½øÐйÜÀí£¬°üÀ¨Ö¸µ¼½Ìʦ·¢²¼¿ÎÌ⣬ѧÉú½øÐÐÑ¡Ì⣬½ÌʦÉóºË£¬±ÏÒµÉè¼Æ×ÊÁϹÜÀíϵͳ»·½Ú¡£
±¾¿ÎÌâÄâÔÚWINDOWS XPϵͳÏ£¬°²×°ÅäÖÃIIS·þÎñÆ÷ʵÏÖÏàÓ¦µÄ¹¦ÄÜ£¬ÓÃSQL SERVER ×÷Ϊºǫ́Êý¾Ý¿â£¬¿ª·¢¹¤¾ß²ÉÓÃMicrosoft Visual Studio 2005£¬ÀûÓÃASP.NET¼¼ÊõÉè¼ÆÏà¹Ø¶¯Ì¬ÍøÒ³Ò³Ã棬Íê³ÉϵͳµÄ¿ª·¢¡£
ÔÚϵͳÖÐÖ÷ҪʵÏֵŦÄÜ¿É·ÖΪÒÔϼ¸À࣬һÊÇ¿ÎÌâÉ걨¹ÜÀí£¬¶þÊÇѧÉúÑ¡Ìâ¹ÜÀí£¬ÈýÊǽÌʦ¶Ô¿ÎÌâµÄÉóºË½øÐйÜÀí£¬ËÄÊǶԱÏÉè¹ý³ÌÖеÄ×ÊÁϽøÐйÜÀí¡£ÔÚ±¾ÏµÍ³µÄ¾ßÌåʵÏÖÖУ¬¼´±àÂë½×¶Î£¬³ýÁË×ÛºÏÃæÏò¶ÔÏóµÄ¿ª·¢¼¼ÊõÍ⣬SQLÓï¾äÊǹᴩÕû¸ö³ÌÐòµÄ£¬ÎÞÂÛÊDzéѯ¡¢É¾³ý¡¢²åÈë¡¢ÐÞ¸ÄÓÃSQLÓï¾äʵÏÖ¶¼ÊDZȽÏÖ±¹ÛµÄ£¬¶øÇÒÒ׶®¡£
¹Ø¼ü´Ê£º Êý¾Ý¿â£»SQL£»·þÎñÆ÷
Abstract
As a college graduation graduation before the final design course, is their comprehensive ability test and an important way of Application Ability. Design management system through graduation, enabling students to communicate effectively with teachers, graduation requirements of the design process be completed well, Project Management is also very convenient. The main subject areas for the university's graduate management, including guidance issued subject teachers, students topics, teachers review, graduate design data management system links.
The project intends to WINDOWS XP system, install and configure IIS server to achieve the corresponding functions, using SQL SERVER as backend database, development tools using Microsoft Visual Studio 2005, using ASP.NET dynamic web page design-related technologies, complete systems.
Main achieved in the system functions can be divided into the following categories, one subject reporting management, two topics of management students, three teachers management review of the subject, four is a complete data set to manage the process. In the specific implementation of the system, that the coding phase, in addition to the development of integrated object-oriented technology outside, SQL statement is run through the whole process, whether it is the query, delete, insert, modify, use the SQL statement is relatively straightforward to achieve, and Easy to understand.
Keywords: Database; SQL; server
Ŀ ¼
Õª Òª I
Abstract II
µÚ 1 Õ ϵͳ¸ÅÊö 1
1.1ÏîÄ¿¿ª·¢±³¾° 1
1.2¿ÎÌⶨÒå 1
1.3ϵͳÁ÷³Ì 1
µÚ 2 ÕÂ ¿ÉÐÐÐÔ·ÖÎö 3
2.1ÒýÑÔ 3
2.2ϵͳ¿ª·¢µÄÄ¿µÄºÍÒâÒå 3
2.3¿ª·¢¹¤¾ßµÄÑ¡Ôñ 4
2.4ϵͳ¿ÉÐÐÐÔ·ÖÎö 5
2.4.1 ¼¼Êõ¿ÉÐÐÐÔ 5
2.4.2 ¾¼Ã¿ÉÐÐÐÔ 5
2.4.3 ²Ù×÷¿ÉÐÐÐÔ 5
2.5×ܽá 5
µÚ 3 Õ ÐèÇó·ÖÎö 6
3.1ÒýÑÔ 6
3.2ϵͳ¹¦ÄÜÃèÊö 6
3.3ϵͳÅäÖÃÒªÇó 7
3.4 Êý¾ÝÁ÷ͼ 7
3.5 Êý¾Ý×Öµä 9
3.5.1 Êý¾Ý´æ´¢ 10
3.5.2 Êý¾ÝÁ÷ 11
3.5.3 Êý¾Ý´¦Àí 14
µÚ 4 Õ ×ÜÌåÉè¼Æ 15
4.1ÒýÑÔ 15
4.2ϵͳ×ÜÌåÉè¼Æ 16
4.2.1¹ÜÀíÔ±²Ù×÷×ÓϵͳµÄ×ÜÌåÉè¼Æ 16
4.2.2½Ìʦ²Ù×÷×ÓϵͳµÄ×ÜÌåÉè¼Æ 17
4.2.3ѧÉú²Ù×÷×ÓϵͳµÄ×ÜÌåÉè¼Æ 17
4.3ϵͳ¹¦ÄÜÃèÊö 18
4.4 Êý¾Ý¿â¸ÅÄî½á¹¹Éè¼Æ 19
4.4.1 ¸÷ʵÌåÊôÐÔͼÈçÏÂËùʾ£º 19
4.4.2 ¸÷ʵÌåÖ®¼äµÄ¹Øϵ×ÜE-Rͼ 20
4.5Êý¾Ý¿âÉè¼Æ 21
4.5.1Êý¾Ý¿â¼¼Êõ 21
4.5.2 SQL Server 2000 µÄÌØÐÔ 23
4.5.3±¾ÏµÍ³µÄÊý¾Ý¿âÉè¼Æ 24
µÚ 5 Õ ÏêϸÉè¼Æ 27
5.1±à³Ì»·¾³¼ò½é 27
5.2 ³ÌÐòÁ÷³Ìͼ 28
5.3 ¹ÜÀí×ÓϵͳµÄʵʩ 30
5.3.1 ϵͳµÇ¼ģ¿é 30
5.3.2 ѧÉúÐÅÏ¢¹ÜÀíÄ£¿é 32
5.3.3 ½ÌʦÐÅÏ¢¹ÜÀíÄ£¿é 33
5.3.4 ѧÉúÑ¡ÌâÐÅÏ¢²é¿´Ä£¿é 34
5.4 ½Ìʦ×ÓϵͳµÄʵʩ 35
5.4.1 ¿ÎÌâÐÅÏ¢¹ÜÀíÄ£¿é 35
5.4.2 ÉêÇëÈË¿ÎÌâ¹ÜÀíÄ£¿é 36
5.4.3 ×ÊÁÏÉÏ´«¹ÜÀíÄ£¿é 37
5.4.4ѧÉúÉÏ´«×ÊÁϲ鿴ģ¿é 38
5.5 ѧÉú×ÓϵͳµÄʵʩ 38
5.5.1 ѧÉú×¢²áÄ£¿é 38
5.5.2 Éè¼ÆÑ¡Ìâ¹ÜÀíÄ£¿é 40
5.5.3 ÒÑÑ¡¿ÎÌâ²é¿´Ä£¿é 41
5.5.4×ÊÁÏÉÏ´«Ä£¿é 41
5.5.5½ÌʦÉÏ´«×ÊÁϲ鿴ģ¿é 43
µÚ6Õ ²âÊÔÓëά»¤ 44
6.1²âÊÔµÄÈÎÎñ¼°Ä¿±ê 44
6.1.1²âÊÔµÄÈÎÎñ 44
6.1.2²âÊÔµÄÄ¿±ê 44
6.2²âÊÔ·½°¸ 44
6.2.1Óû§µÇ¼²âÊÔ 46
6.2.2ϵͳ¹¦ÄܲâÊÔ 46
6£®3 ϵͳά»¤ 46
×Ü ½á 48
Ö л 49
²Î¿¼ÎÄÏ× 50
µÚ 1 Õ ϵͳ¸ÅÊö
1.1ÏîÄ¿¿ª·¢±³¾°
Ëæ×ÅÉç»áµÄ¿ìËÙ·¢Õ¹£¬¼ÆËã»ú¿Æѧ¼¼ÊõµÄÈÕÇ÷ÍêÉÆ£¬ÈËÃÇ´«Í³µÄ˼Ïë¹ÛÄîºÍ¹¤×÷·½Ê½¿ªÊ¼·¢Éú¾Þ´óµÄת±ä£¬ÒÀ¿¿¼ÆËã»ú¼¼Êõ½øÐÐÐÅÏ¢»¯¹ÜÀíÒѾÊÆÔÚ±ØÐС£¶øÎÒÃǸßУҲÃæÁÙ×ÅͬÑùµÄÎÊÌ⣬ѧÉúÐÅÏ¢µÄ¹ÜÀí¡¢ÀÏʦÐÅÏ¢µÄ¹ÜÀíºÍÈÕ³£¹¤×÷µÄ¹ÜÀíµÈµÈ£¬¶¼±ØÐëÒÀ¿¿¼ÆËã»úÈí¼þ¹ÜÀí¡£Ñ§Éú±ÏÒµÉè¼Æ¹ÜÀíϵͳÊÇÖÚ¶à¹ÜÀíϵͳÖеÄÒ»²¿·Ö£¬Ò²ÊǺÜÖØÒªµÄÒ»²¿·Ö¡£¿ÉÊÇ£¬¾ÝÎÒÁ˽⣬Ðí¶à¸ßУ²¢Ã»ÓÐÔÚÕâÒ»»·½ÚÉÏʵÏÖÐÅÏ¢»¯¹ÜÀí£¬¶øÕâÒ»²¿·ÖµÄ¹¤×÷ÈÔÈ»ÊÇÓÉÈ˹¤À´½øÐÐÍê³É¡£È˹¤²Ù×÷±Ø¶¨´æÔںܶàµÄȱÏÝ£¬±ÈÈ磺¹¤×÷Á¿·±¶à¡¢×ÊÁÏÒ׶ªÊ§¡¢¸üкÍÐ޸ĺܲ»·½±ã¡¢ÀÏʦ ÓëѧÉúÖ®¼äµÄ¹µÍ¨²»¼°Ê±µÈµÈ¡£ÎÒËù×öµÄ¿ÎÌâ»ùÓÚWEBµÄ±ÏÒµÉè¼Æ¹ÜÀíϵͳ£¬Ëü²ÉÓÃÁ˵±Ç°Á÷ÐеÄB/S½á¹¹ºÍInternetÍøÂç¼¼Êõ£¬²»½ö·½±ã²Ù×÷£¬¶øÇÒ¿ÉÒÔ´ó´óÌá¸ßϵͳµÄ¿ÉÒÆÖ²ÐÔ¡£²¢ÇÒ£¬Í¨¹ý¼ÆËã»úÐÅÏ¢»¯¹ÜÀí¿ÉÒÔ±ÜÃâÈ˹¤²Ù×÷µÄһЩȱÏݺͲ»×ã¡£