²©¿ÍÍøÕ¾Éè¼ÆÓëʵÏÖ±ÏÒµÉè¼Æ(ÂÛÎÄ) ÏÂÔØ±¾ÎÄ

ÄÚÈÝ·¢²¼¸üÐÂʱ¼ä : 2026/4/6 13:49:22ÐÇÆÚÒ» ÏÂÃæÊÇÎÄÕµÄÈ«²¿ÄÚÈÝÇëÈÏÕæÔĶÁ¡£

ºÓÄϿƼ¼´óѧ±¾¿Æ±ÏÒµÉè¼Æ£¨ÂÛÎÄ£©

allusers±í(¹ÜÀíÔ±ÐÅÏ¢±í):

±í4-1 ¹ÜÀíÔ±ÐÅÏ¢±í

ÐòºÅ ×Ö¶ÎÃû³Æ 1 2 3 4 5 ID username pwd cx addtime ×Ö¶ÎÀàÐÍ Int VarChar VarChar VarChar DateTime ´óС 4 50 50 50 8 ÔÊÐíΪ¿Õ ×ÔÔö±àºÅ ÊÇ ÊÇ ÊÇ ÊÇ ×î´ó³¤¶È 10 255 255 255 23 ±¸×¢ xiangce±í(Ïà²áÐÅÏ¢±í):

±í4-2 Ïà²áÐÅÏ¢±í

ÐòºÅ ×Ö¶ÎÃû³Æ 1 2 3 4 5 6 ID bianhao mingcheng beizhu faburen addtime ×Ö¶ÎÀàÐÍ Int VarChar VarChar VarChar VarChar DateTime ´óС 4 50 50 50 50 8 ÔÊÐíΪ¿Õ ×ÔÔö±àºÅ ÊÇ ÊÇ ÊÇ ÊÇ ÊÇ ×î´ó³¤¶È 10 255 255 255 255 23 ±¸×¢ allgonggao±í£¨ÎÄÕÂÐÅÏ¢±í£©:

±í4-3 ÎÄÕÂÐÅÏ¢±í

ÐòºÅ ×Ö¶ÎÃû³Æ 1 2 3 4

×Ö¶ÎÀàÐÍ Int VarChar Text VarChar ´óС 4 255 16 50 20

ÔÊÐíΪ¿Õ ×ÔÔö±àºÅ ÊÇ ÊÇ ÊÇ ×î´ó³¤¶È 10 255 255 255 ±¸×¢ ID title content leibie ºÓÄϿƼ¼´óѧ±¾¿Æ±ÏÒµÉè¼Æ£¨ÂÛÎÄ£©

5 6 addtime addby DateTime VarChar 8 50 ÊÇ ÊÇ 23 255 yonghuzhuce±í£¨Óû§ÐÅÏ¢±í£©:

±í4-4 Óû§ÐÅÏ¢±í

ÐòºÅ ×Ö¶ÎÃû³Æ 1 2 3 4 5 6 7 8 9 10 11 12 13 ID yonghuming mima xingming dianhua youxiang shenfenzheng dizhi jibie xingbie beizhu addtime issh ×Ö¶ÎÀàÐÍ Int VarChar VarChar VarChar VarChar VarChar VarChar VarChar VarChar VarChar VarChar DateTime VarChar ´óС ÔÊÐíΪ¿Õ 4 50 50 50 50 50 50 50 50 50 50 8 2 ×ÔÔö±àºÅ ÊÇ ÊÇ ÊÇ ÊÇ ÊÇ ÊÇ ÊÇ ÊÇ ÊÇ ÊÇ ÊÇ ÊÇ ×î´ó³¤¶È 10 255 255 255 255 255 255 255 255 255 255 23 255 ±¸×¢

21

ºÓÄϿƼ¼´óѧ±¾¿Æ±ÏÒµÉè¼Æ£¨ÂÛÎÄ£©

µÚ5Õ ÏêϸÉè¼Æ

ÓÉÓÚÓû§½çÃæµÄ´ó²¿·Ö¹¦Äܶ¼ÊÇÒÔ¹ÜÀíÄ£¿éΪǰÌáµÄ£¬ÒòΪ¿Í»§Ä£¿éËù ÏÔʾµÄÊý¾Ý´ó²¿·ÖÐèҪͨ¹ý¹ÜÀíÄ£¿éÀ´Ìí¼Ó¡£Òò´Ë£¬ÎÒÃÇÊ×ÏÈÒªÀ´½éÉܹÜÀíÄ£¿éµÄÉè¼ÆÓ뿪·¢¡£¹ÜÀíÄ£¿éÏà¶Ô¿Í»§Ä£¿éÒª¸´ÔÓһЩ£¬ÒòΪÔÚÕâÀïÐèÒª¶ÔËùÓÐÐÅÏ¢½øÐÐά»¤£¬°üÀ¨ä¯ÀÀ¡¢Ôö¼Ó¡¢Ð޸ĺÍɾ³ýµÈ²Ù×÷¡£ÎªÁ˱ãÓÚϵͳά»¤£¬Ò³ÃæµÄÃüÃû²ÅÓá°Ä£¿éÃû+¹¦ÄÜÃû¡±µÄ·½Ê½¡£

¡ì5.1 Óû§½çÃæ

¡ì5.1.1 ϵͳÊ×Ò³½çÃæ

±¾ÍøÕ¾µÄÊ×Ò³½çÃæÖ÷ÒªÓÉÓÚÓû§×Ô¶¨Òå¿Ø¼þ×é³É£¬Èçͼ5-1Ëùʾ£º

ͼ5-1 ϵͳÊ×ҳͼ

22

ºÓÄϿƼ¼´óѧ±¾¿Æ±ÏÒµÉè¼Æ£¨ÂÛÎÄ£©

¡ì5.1.2 ÐÄÇéæäÕ¾½çÃæ

´Ë½çÃæÎª²©¿ÍÎÄÕ²鿴½çÃæ£¬Óû§¿ÉÔÚ´ËÒ³Ãæ½øÐÐÐÅÏ¢ä¯ÀÀ¡£µ±Óû§Ñ¡¶¨Ä³ÐÅÏ¢ºóºó£¬¿É½øÐоßÌåÎÄÕ²鿴²Ù×÷¡£¸ÃÒ³ÃæµÄºËÐIJ¿·ÖÊÇViewContent2Óû§¿Ø¼þ£¬Í¬Ê±ÓÃDatalist¿Ø¼þ½øÐзÖÒ³¡£Èçͼ5-2Ëùʾ£º

ͼ5-2 ÐÄÇéæäÕ¾Ò³ÃæÍ¼

ʵÏÖ±¾Ä£¿éµÄÖ÷Òª´úÂëÈçÏÂËùʾ£º

public string sql, lb, lbtxt;

protected void Page_Load(object sender, EventArgs e) { lb = Request.QueryString[\ switch (lb) { case \

lbtxt = \ÐÄÇéæäÕ¾\ break; case \

lbtxt = \¾«ÃÀÊÕ²Ø\ break;

23