ÄÚÈÝ·¢²¼¸üÐÂʱ¼ä : 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