ÈÈËÑ´Ê£º¹ºÎïϵͳ Ñ§Éú ÈËÊ ÏúÊÛ ÏúÊÛ¹ÜÀí É̳Ǡ¶©Æ±
µ±Ç°Î»Ö㺼ÆËã»ú±ÏÒµÉè¼Æ > ASP.NET >»ùÓÚ.NETѧÉúÑ¡¿Îϵͳasp.net1023(±ÏÒµÉè¼Æ+ÂÛÎÄ+Ô´Âë) 
 
»ùÓÚ.NETѧÉúÑ¡¿Îϵͳasp.net1023(±ÏÒµÉè¼Æ+ÂÛÎÄ+Ô´Âë)

  À´Ô´£º¼ÆËã»ú±ÏÒµÉè¼Æ   ×÷Õߣº admin   ÈÕÆÚ£º2016-11-11 23:28:48   ¼Û¸ñ£º150Ôª   ÈËÆø£º751  Êղر¾Ò³  
 
ÒÔÏÂÊÇ´ó¸Ù½éÉÜ£¬ÈçÐèÒªÍêÕûÉè¼Æ×ÊÁÏÇ빺Âò
Ìáʾ£º±¾×ÊÁÏÒÑÉóºË¹ý£¬ÄÚÈÝÑϸñ±£ÃÜ£¬¸ñʽ±ê×¼£¬ÖÊÁ¿±£Ö¤¡£
1.ÎÞÐè×¢²á¾Í¿ÉÒÔ¹ºÂò£¬¹ºÂòÇëÊÂÏÈ×Éѯ¿Í·þÈËÔ±¡£
2.±¾Õ¾ÌṩËùÓбÏÒµÉè¼Æ¶¼°üÊÛºó¡¢°üÔËÐС¢°ü½²½â¡¢°üµ÷ÊÔ¡£¡£

¿Í·þ1£ºQQ:1363407015     ΢Ðſͷþ£º
   
 
      
Ïêϸ½éÉÜ ×¨Òµ¶¨ÖƸ÷Àà´óѧÉú±ÏÒµÉè¼Æ£¬°üÊÛºó¡¢°üÔËÐС¢°üµ÷ÊÔ£¡»¶Ó­×Éѯ...

Ëæ×ÅÔÚУ´óѧÉúÈËÊýµÄ²»¶ÏÔö¼Ó£¬½ÌÎñϵͳµÄÊý¾ÝÁ¿Ò²²»¶ÏµÄÉÏÕÇ¡£ÒÔÍùµÄÑ¡¿Î·½·¨ÊÇËæÌñ¨Ãû¡£ÕâÖÖ·½·¨ËäȻֱ½Ó£¬µ«ÊÇÔì³ÉÑ¡¿ÎµÄäĿÐԺͽÌÎñ´¦´¦ÀíÊý¾ÝµÄ·±ÖØÐÔ¡£ÎªÁ˼õÇá½ÌÎñ´¦¹¤×÷£¬ÒÔ¼°Ã¿¸öѧÉú¸üºÃµÄÑ¡Ôñ×Ô¼ºËùϲ»¶µÄ¿ÆÄ¿¡£Õë¶ÔѧÉúÑ¡¿ÎÕâÒ»»·½Ú£¬±¾ÏµÍ³´ÓѧÉúÍøÉÏ×ÔÖ÷Ñ¡¿ÎÒÔ¼°½ÌʦµÄ¿Î³Ì·¢²¼Á½¸ö´ó·½Ãæ½øÐÐÁËÉè¼Æ£¬»ù±¾ÊµÏÖÁËѧÉúµÄÔÚÏßÐÅÏ¢²éѯ¡¢Ñ¡¿Î¹¦ÄÜÒÔ¼°½Ìʦ¶Ô¿Î³ÌÐÅÏ¢·¢²¼µÄ¹ÜÀíµÈ¹¦ÄÜ¡£
    ±¾ÎÄͨ¹ý·ÖÎöä¯ÀÀÆ÷/·þÎñÆ÷½á¹¹µÄÌØµã²¢½áºÏÑ¡¿ÎµÄʵ¼ÊÇé¿ö£¬Ìá³öÁË»ùÓÚä¯ÀÀÆ÷/·þÎñÆ÷½á¹¹ÍøÉÏÑ¡¿ÎϵͳµÄ»ù±¾Éè¼ÆË¼Ï룬¼òÒª½éÉÜÁËϵͳ¸÷¹¦ÄÜÄ£¿é¼°Êý¾Ý¿âµÄÉè¼Æ£¬×ÅÖØÌÖÂÛÁËÓà ASP.NET¼¼ÊõºÍSQL Server 2000¿ª·¢ÍøÉÏÑ¡¿ÎϵͳʱµÄÊý¾Ý¿â·ÃÎʼ¼ÊõºÍ¶¯Ì¬ÍøÒ³ÖÆ×÷¼¼Êõ,²¢¸ø³öÁ˲¿·ÖʵÏÖ´úÂ롣ͨ¹ý¸Ãϵͳ£¬Ê¹Ñ§Éú¿ÉÒÔ·½±ãµØÔÚÐ£Ô°ÍøÉϽøÐÐÍøÉÏÑ¡¿Î¡£¸ÃB/S½á¹¹µÄϵͳÔÚWindows XPϵͳºÍVS.NETƽ̨Ï¿ª·¢Íê³É£¬Ê¹ÓÃC££×÷ΪASP.NETµÄ¿ª·¢ÓïÑÔ£¬SQL Server 2000×÷ΪÊý¾Ý¿â¡£ÏµÍ³ÓнϸߵݲȫÐԺͽϺõÄÐÔÄÜ¡£ÆäÖÐÁ¬½ÓÊý¾Ý¿âµÄ×Ö·û´®¿ÉÒÔËæÊ±ÔÚweb.configÀïÐ޸쬲¢¾­¹ý±àÂë¼ÓÃÜ£¬Ôö¼ÓÁËÁé»îÐÔ£¬±£»¤ÁËÊý¾Ý¿âµÄ°²È«¡£´úÂ뾡Á¿Ê¹Óô洢¹ý³ÌºÍ¾¡Á¿¼õÉÙÊý¾Ý¿âÁ¬½ÓµÄ´ò¿ªÊ±¼äµÈÊÖ¶ÎÀ´Ìá¸ßÐÔÄÜ¡£
    ±¾ÎÄÖгýÁËÓжԳÌÐòµÄϵͳ·ÖÎö¡¢×ÜÌåÉè¼Æ¡¢Êý¾Ý¿âÉè¼Æ¡¢¹¦ÄÜʵÏÖµÈÖ÷Ì岿·ÖÍ⣬ÔÚÕâ֮ǰ»¹½éÉÜÁËÓëÍøÉÏÑ¡¿ÎϵͳÏà¹ØµÄÐÅÏ¢¡¢IIS½éÉÜ¡¢IISÓëASP.NETµÄ½áºÏµÈµÄ»ù±¾ÄÚÈݼ°·¢Õ¹Çé¿ö¡£
¹Ø¼ü´Ê£ºÍøÉÏÑ¡¿Î£¬ä¯ÀÀÆ÷/·þÎñÆ÷½á¹¹£¬ASP.NET,Êý¾Ý¿â¹ÜÀíϵͳ

 

 

 

 

 

 

 

 

 

 


Abstract
    With the development of the enrolling number, the data for daily registry is increasing, too. And always we should goto classroom to enroll. Although this method directly,but result in blindness of the course enrollment and registry data processing of the heavy .In order to reduce the work registry ,and better each student to choose their own favorite subjects .This system is special for the on-line course choosing to design both from the aspect of the student and the teacher. The student can choose the course independently and the teacher can manage the information of the announcing course, also.
    This paper gives the basic design idea of the Browser/Server structure based online course elect system by analyzing the characteristic of the Browser/Server structure and combining with the actual public elective courses conditions of our school£®It introduces the function module and database design briefly£¬followed by a discussion on database accessing technology and the active page technology of the course elect system based on ASP.NET and SQL Server 2000£®By using this system£¬students can elect courses online efficiently£®This Browser/Server structure system is developed under VS.NET platform in Windows XP operating system, using C# as ASP.NET development language and SQL Server 2000 as the database. This system is of higher security and better performance. The character string, which is used to connecting to the database, can be modified at any time in the file ¡° web.config¡±. The string is encoded and encrypted, increasing flexibility of the system and security of the database. In code, making use of stored procedure and minimizing the database opening time to improve performance of the system.
    This paper includes the system analysis ,the main designing ,the database designing, the function designing and , before this , some basic knowledge and present development of the programs mentioned above.
Keywords: online course elect, Browser/Server structure,ASP.NET, DBMS

 


Ŀ¼

Õª   Òª 1
ABSTRACT 2
µÚÒ»ÕÂ ÒýÑÔ 4
1.1¿ÎÌâÑо¿µÄÄ¿µÄ 4
1.2 ¿ÎÌâÑо¿µÄÒâÒå 4
1.3 ¿ÎÌâµÄ¿ÉÐÐÐÔ·ÖÎö 5
µÚ¶þÕ ϵͳ·ÖÎöÓë×ÜÌåÉè¼Æ 6
2£®1ϵͳ·ÖÎö 6
2.2 ϵͳ×ÜÌåÉè¼Æ 7
µÚÈýÕ Êý¾Ý¿âÉè¼ÆÓëʵÏÖ 9
3.1Êý¾Ý¿âϵͳ·ÖÎö 9
3.2 Êý¾Ý¿âÂß¼­Éè¼Æ 12
3.3Êý¾Ý¿âÎïÀíʵÏÖ 13
µÚËÄÕ ¹«¹²ÀàÓ빫¹²Ò³ÃæÉè¼Æ 16
4.1 WEB.CONFIGÒ³ÃæÉè¼Æ 16
4.2 Êý¾Ý¿âÁ¬½Ó²Ù×÷ÀࡪDBÀà 19
4.3 ¹¤¾ßÀàMYUTILITYÀà 20
4.4 ´íÎóÐÅÏ¢ÀàºÍ´íÎóÏÔÊ¾Ò³Ãæ 21
µÚÎåÕ ϵͳ˵Ã÷Êé 22
5£®1ϵͳ½çÃæËµÃ÷ 22
5.2 ϵͳ¹ÜÀí˵Ã÷ 27
5.2½Ìʦ¹ÜÀí˵Ã÷ 30
µÚ6Õ ×ܽá 34
²Î¿¼ÎÄÏ× 35
Ö   л 36

 

µÚÒ»ÕÂ ÒýÑÔ
1.1¿ÎÌâÑо¿µÄÄ¿µÄ
1.ÕÆÎÕ²ÉÓÃInternetµÄTCP/IPЭÒ飬ÒÔB/S·½Ê½£¬ASP.NET±à³Ì¼¼Êõ£¬¶àýÌå¼¼Êõ¡£
2.ÕÆÎÕÒ»ÖÖ¶àÈÎÎñ¶àÓû§²Ù×÷ϵͳ
3.ASP.NETµÄ¶¯Ì¬ÍøÒ³ºÍSQL  Server´óÐ͵ÄÊý¾Ý¿â¡£
4.ѧ»áʹÓÃijÖÖ¿ª·¢¹¤¾ß¡£
5.ÅàÑøÏ໥ºÏ×÷µÄ¾«Éñ¡£

1.2 ¿ÎÌâÑо¿µÄÒâÒå
ѧÉúÑ¡¿ÎϵͳÊÇÒ»¸öѧУ²»¿ÉȱÉٵIJ¿·Ö,ËüµÄÄÚÈݶÔÓÚѧУµÄ¾ö²ßÕߺ͹ÜÀíÕßÀ´Ëµ¶¼ÖÁ¹ØÖØÒª,ËùÒÔѧÉúÑ¡¿ÎϵͳӦ¸ÃÄܹ»ÎªÓû§Ìṩ³ä×ãµÄÐÅÏ¢ºÍ¿ì½ÝµÄ²éѯÊֶΡ£µ«Ò»Ö±ÒÔÀ´ÈËÃÇʹÓô«Í³È˹¤µÄ·½Ê½¹ÜÀíÎļþµµ°¸£¬ÕâÖÖ¹ÜÀí·½Ê½´æÔÚ×ÅÐí¶àȱµã,Èç:ЧÂʵ͡¢±£ÃÜÐÔ²î,ÁíÍâʱ¼äÒ»³¤,½«²úÉú´óÁ¿µÄÎļþºÍÊý¾Ý,Õâ¶ÔÓÚ²éÕÒ¡¢¸üкÍά»¤¶¼´øÀ´Á˲»ÉÙµÄÀ§ÄÑ¡£
    Ëæ×Å¿ÆÑ§¼¼ÊõµÄ²»¶ÏÌá¸ß,¼ÆËã»ú¿ÆÑ§ÈÕ½¥³ÉÊì,ÆäÇ¿´óµÄ¹¦ÄÜÒÑΪÈËÃÇÉî¿ÌÈÏʶ,ËüÒѽøÈëÈËÀàÉç»áµÄ¸÷¸öÁìÓò²¢·¢»Ó×ÅÔ½À´Ô½ÖØÒªµÄ×÷Óá£
    ×÷Ϊ¼ÆËã»úÓ¦ÓõÄÒ»²¿·Ö,ʹÓüÆËã»ú¶ÔÑ¡¿ÎÐÅÏ¢½øÐйÜÀí,ÓÐ×ÅÊÖ¹¤¹ÜÀíËùÎÞ·¨±ÈÄâµÄÓŵã.ÀýÈç:¼ìË÷ѸËÙ¡¢²éÕÒ·½±ã¡¢¿É¿¿ÐԸߡ¢´æ´¢Á¿´ó¡¢±£ÃÜÐԺá¢ÊÙÃü³¤¡¢³É±¾µÍµÈ¡£ÕâЩÓŵãÄܹ»¼«´óµØÌá¸ßÈËÊÂÀÍ×ʹÜÀíµÄЧÂÊ,Ò²ÊÇÆóÒµµÄ¿ÆÑ§»¯¡¢Õý¹æ»¯¹ÜÀí,ÓëÊÀ½ç½Ó¹ìµÄÖØÒªÌõ¼þ¡£
    Òò´Ë£¬¿ª·¢ÕâÑùÒ»Ì×Èí¼þ³ÉΪºÜÓбØÒªµÄÊÂÇé,ÔÚÏÂÃæµÄ¸÷ÕÂÖÐÎÒÃǽ«ÒÔ¿ª·¢Ò»Ì×ѧÉúÑ¡¿ÎϵͳΪÀý,̸̸Æä¿ª·¢¹ý³ÌºÍËùÉæ¼°µ½µÄÎÊÌâ¼°½â¾ö·½·¨¡£
±¾ÎÄÖÐËù×öµÄÖ÷Òª¹¤×÷ÈçÏ£º
(1)½éÉÜÁ˸öÐÔ»¯Ò³ÃæµÄ±³¾°¼°Win2000server+IIS+ASP.NETϵͳµÄÒ»°ãÔ­Àí£»
(2) ²ûÊöÕû¸ö¸öÐÔ»¯Ò³ÃæÉú³ÉϵͳµÄϵͳ½á¹¹¼°¹¤×÷Ô­Àí£»·ÖÎöÁËϵͳʵÏÖÖеÄÌØÊâÐÔ¡¢ÄѵãºÍÖØµã¡£
(3) Éè¼ÆÊµÏÖÓû§¹ÜÀí¡¢¿Î³Ì¹ÜÀí¡¢Ñ¡¿ÎÐÅϢ¼Èë¹ÜÀí¡¢ÐÂÉúÐÅϢ¼Èë¹ÜÀí¡¢¿Î³ÌµÄä¯ÀÀºÍ²éÕÒ¡¢Ñ§Éú²éÕÒµÈASP.NETÒ³Ãæ ¡£
(4) ·ÖÎö²¢½â¾öʵÏÖÖеÄÈô¸É¼¼ÊõÎÊÌâ¡£
(5) ½¨Á¢ÍêÕûµÄÍøÉÏÑ¡¿Î£¬½øÐвâÊÔ²¢·ÖÎö½á¹û¡£

 


 

˵Ã÷£º±¾Õ¾ËùÓгÌÐò¶¼±£Ö¤ÔËÐУ¬Ã¿¸öÌâÄ¿¶¼ÓжÔÓ¦µÄÊÓÆµÑÝʾ¼Ïñ£¬½ØÍ¼ÎĵµµÈÄÚÈÝ¡£

ÈçÐèÒª¸ü¶à×ÊÁÏÇëÁªÏµ¿Í·þÈËQQ£º:1363407015

   
  ¹ºÂòÖ¸ÄÏ
 
ͬѧ¹ºÂò°ïÖúÖÐÐÄ
¶©×öÁ÷³ÌºÍ¼Û¸ñ˵Ã÷
Õæ³Ï·þÎñ¡¢³ÏÐÅΪ±¾
±ÏÒµÉè¼ÆµÄ¹ºÂòÁ÷³Ì
ÊÛºó·þÎñ½éÉÜ
 
  ÈÈÃÅÉè¼Æ
 
ѧÉúµµ°¸¹ÜÀíϵͳvb1030(±ÏÒµÉè¼Æ+ÂÛÎ
ѧУ¹¤×ʹÜÀíϵͳvb1035(±ÏÒµÉè¼Æ+ÂÛ
ÖÐСÐÍÆóÒµ¿â´æ¹ÜÀí×ÓϵͳµÄÉè¼ÆVB101
ÍøÉÏÑ¡Ìâϵͳasp1025(±ÏÒµÉè¼Æ+ÂÛÎÄ)
ͼÊé¹Ý¹ÜÀíϵͳasp1036(±ÏÒµÉè¼Æ+ÂÛÎÄ
»ùÓÚSSMµÄÓ°ÊÓÔ¤Ô¼ÍÆ¼öϵͳµÄÉè¼ÆÓëʵ
ÖÐСÐÍÖÆÔìÆóÒµERP¿â´æ¹ÜÀí×Óϵͳ·ÖÎ
µã²ËÊÕÒø¹ÜÀíϵͳVB1019(±ÏÒµÉè¼Æ+ÂÛÎ
»ùÓÚhtml5µÄÍøÉÏ·þ×°ÏúÊÛϵͳ ³ÌÐò+ÂÛ
±ö¹ÝסËÞ¹ÜÀíϵͳvb1034(±ÏÒµÉè¼Æ+ÂÛÎ
ÍøÉÏBBSµÄÉè¼ÆÓëʵÏÖasp1022(±ÏÒµÉè¼Æ
ѧÉúѧ¼®¹ÜÀíϵͳjsp1120(³ÌÐòÉè¼Æ+Â
¸ñ×ÓÆÌ¹ÜÀíϵͳjsp1126(±ÏÒµÉè¼Æ+ÂÛÎÄ
»ùÓÚ΢ÐÅÆ½Ì¨µÄµçÓ°¹ºÆ±ÏµÍ³Éè¼ÆÓëʵÏ
µã²Ëϵͳ³ø·¿¶ËÉè¼Æjsp1125(±ÏÒµÉè¼Æ+
 
  ´ð±ç×Éѯ
 
Âò±ÏÒµÉè¼Æ³ÉÆ·µÄͬѧעÒâ±ãÒËûºÃ»õ£
ÊÛºó·þÎñ½éÉÜ
¼ÆËã»ú±ÏÒµÉè¼Æ£¨ÂÛÎÄ£©¿ªÌⱨ¸æÊéд×
¶¨×ö±ÏÒµÉè¼ÆÎªÊ²Ã´±ØÐëÌáǰ½»Äɶ¨½ð£
¼ÆËã»úרҵ±ÏÒµÂÛÎÄ´ð±çµÄÒ»°ã³ÌÐò¼°³
±ÏÒµÉè¼ÆµÄ¹ºÂòÁ÷³Ì
ͬѧ¹ºÂò°ïÖúÖÐÐÄ
±ÏÒµÉè¼Æ¶¨¼ÛÖ÷Òª¿´ÒÔϼ¸µã
¹ºÂò±ÏÒµÉè¼ÆÏÖ³É×÷Æ·ÄãÃÇÌṩÐÞ¸ÄÂð£
³£¼ûÎÊÌâÖ¸Òý
±ÏÒµÉè¼ÆÈçºÎд¿ªÌⱨ¸æ
¶©×ö±ÏÒµÉè¼ÆÁ÷³Ì˵Ã÷
¹ºÂòÏֳɵÄ×÷Æ·ºÍ¶¨×öµÄ×÷Æ·ÓÐÊ²Ã´Çø±
¶©×öÁ÷³ÌºÍ¼Û¸ñ˵Ã÷
Õæ³Ï·þÎñ¡¢³ÏÐÅΪ±¾
  ×îÐÂÉè¼Æ
 
»ùÓÚSSMµÄ¼ÆËã»úѧԺ¼¨Ð§¿¼ÆÀϵͳµÄÉè
»ùÓÚSSMµÄ·ÇÎïÖÊÎÄ»¯ÒŲúÍøÕ¾µÄÉè¼ÆÓë
»ùÓÚBSϵÄʦÉú½»»¥Æ½Ì¨µÄÉè¼ÆÓëʵÏÖP
»ùÓÚPHPµÄ¶¯ÂþÂÃÓν»Á÷ÍøÕ¾php
´óѧ¶àýÌå¿Î¼þÉóºËϵͳPHP1029(±ÏÒµÉ
»ùÓÚPHPµÄ´óÁ¬µØÇøÎÛȾ״¿ö²éѯPHP102
»ùÓÚPHPµÄ³¬ÊйÜÀíϵͳÉè¼ÆPHP1027(±Ï
»ùÓÚPHPµÄרҵ½¡Éí×ÊÑ¶ÍøÕ¾Éè¼ÆÓëʵÏÖ
»ùÓÚPHPÖÇÁ¦¾ºÈüÇÀ´ð¼Æ·ÖϵͳPHP1025(
»ùÓÚPHPµÄÇóÖ°ÕÐÆ¸ÏµÍ³PHP1024(±ÏÒµÉè
»ùÓÚJSPµÄÎïÁ÷¹ÜÀíϵͳµÄÉè¼ÆÓëʵÏÖJS
»ùÓÚJSPµÄÍøÉÏͶƱϵͳÉè¼ÆJSP179(±ÏÒ
»ùÓÚJSPµÄÍøÉÏÉÌÆ·¹ºÎïÍøÕ¾ JSP178(³Ì
»ùÓÚJSPµÄÍøÉÏÅÄÂôϵͳÉè¼ÆJSP177(±ÏÒ
»ùÓÚJSPµÄÍøÉÏ»¨µêÍøÕ¾Éè¼Æ
 
 

³ÏÑû¼¼Êõ¼ÓÃ˺Ï×÷£¬IOS¼¼Êõ¡¢Android¡¢Delphi¡¢Î¢ÐÅС³ÌÐò¡¢C++µÈ¼¼ÊõºÏ×÷ £¡³ÏÑû¸÷´óѧУͬѧ¼ÓÃË´úÀíºÏ×÷£¬ÕÐÆ¸Ñ§Ð£´úÀí£¬Íò·Ý¼ÆËã»ú³ÉÆ·×÷Æ·´úÀíȨ£¡

³ÏÕÐÍøÂç´úÀí,ѧÉú´úÀí¡£ Ãâ´úÀí·Ñ£¡ÔÂÈë¹ýÍò²»ÊÇÃΣ¡£¡

°æÈ¨ËùÓУºCopyright 2007-2020 ´´Òâ±ÏÒµÉè¼ÆÍø www.lw225.cn ¼ÆËã»ú±ÏÒµÉè¼ÆÍø¿Í·þ·þÎñ£¡£¡ÍøÕ¾·þÎñQQ£º1363407015 ÍøÕ¾·þÎñQQ2£º405425197   ÊñICP±¸ 08107142ºÅ

ÔÚÏ߿ͷþ
ÈÈÏߵ绰

Ìí¼Ó΢ÐÅÕ˺źÃÓÑ