Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

½»»»»úÈýÖֶ˿ÚģʽAccess¡¢HybridºÍTrunkµÄÀí½â

untag¾ÍÊÇÆÕͨµÄethernet±¨ÎÄ£¬ÆÕͨPC»úµÄÍø¿¨ÊÇ¿ÉÒÔʶ±ðÕâÑùµÄ±¨ÎĽøÐÐͨѶ£»
tag±¨ÎĽṹµÄ±ä»¯ÊÇÔÚÔ´macµØÖ·ºÍÄ¿µÄmacµØÖ·Ö®ºó£¬¼ÓÉÏÁË4bytesµÄvlanÐÅÏ¢£¬Ò²¾ÍÊÇvlan tagÍ·£»Ò»°ãÀ´ËµÕâÑùµÄ±¨ÎÄÆÕͨPC»úµÄÍø¿¨ÊDz»ÄÜʶ±ðµÄ
ÏÂͼ˵Ã÷ÁË802.1Q·â×°tag±¨ÎÄÖ¡½á¹¹
´ø802.1QµÄÖ¡ÊÇÔÚ±ê×¼ÒÔÌ«ÍøÖ¡ÉϲåÈëÁË4¸ö×ֽڵıêʶ¡£ÆäÖаüº¬£º
2¸ö×Ö½ÚµÄЭÒé±êʶ·û£¨TPID)£¬µ±Ç°ÖÃ0x8100µÄ¹Ì¶¨Öµ£¬±íÃ÷¸ÃÖ¡´øÓÐ802.1QµÄ±ê¼ÇÐÅÏ¢¡£
2¸ö×ֽڵıê¼Ç¿ØÖÆÐÅÏ¢£¨TCI£©£¬°üº¬ÁËÈý¸öÓò¡£
PriorityÓò£¬Õ¼3bits£¬±íʾ±¨ÎĵÄÓÅÏȼ¶£¬È¡Öµ0µ½7£¬7Ϊ×î¸ßÓÅÏȼ¶£¬0Ϊ×îµÍÓÅÏȼ¶¡£¸ÃÓò±»802.1p²ÉÓá£
¹æ·¶¸ñʽָʾ·û£¨CFI)Óò£¬Õ¼1bit£¬0±íʾ¹æ·¶¸ñʽ£¬Ó¦ÓÃÓÚÒÔÌ«Íø£»1±íʾ·Ç¹æ·¶¸ñʽ£¬Ó¦ÓÃÓÚToken Ring¡£
VLAN IDÓò£¬Õ¼12bit£¬ÓÃÓÚ±êʾVLANµÄ¹éÊô¡£
ÒÔÌ«Íø¶Ë¿ÚÓÐÈýÖÖÁ´Â·ÀàÐÍ£ºAccess¡¢HybridºÍTrunk¡£
AccessÀàÐ͵Ķ˿ÚÖ»ÄÜÊôÓÚ1¸öVLAN£¬Ò»°ãÓÃÓÚÁ¬½Ó¼ÆËã»úµÄ¶Ë¿Ú£»
TrunkÀàÐ͵Ķ˿ڿÉÒÔÔÊÐí¶à¸öVLANͨ¹ý£¬¿ÉÒÔ½ÓÊպͷ¢ËͶà¸öVLANµÄ±¨ÎÄ£¬Ò»°ãÓÃÓÚ½»»»»úÖ®¼äÁ¬½ÓµÄ¶Ë¿Ú£»
HybridÀàÐ͵Ķ˿ڿÉÒÔÔÊÐí¶à¸öVLANͨ¹ý£¬¿ÉÒÔ½ÓÊպͷ¢ËͶà¸öVLANµÄ±¨ÎÄ£¬¿ÉÒÔÓÃÓÚ½»»»»úÖ®¼äÁ¬½Ó£¬Ò²¿ÉÒÔÓÃÓÚÁ¬½ÓÓû§µÄ¼ÆËã»ú¡£
Hybrid¶Ë¿ÚºÍTrunk¶Ë¿ÚÔÚ½ÓÊÕÊý¾Ýʱ£¬´¦Àí·½·¨ÊÇÒ»ÑùµÄ£¬Î¨Ò»²»Í¬Ö®´¦ÔÚÓÚ·¢ËÍÊý¾Ýʱ£ºHybrid¶Ë¿Ú¿ÉÒÔÔÊÐí¶à¸öVLANµÄ±¨ÎÄ·¢ËÍʱ²»´ò±êÇ©£¬¶øTrunk¶Ë¿ÚÖ»ÔÊÐíȱʡVLANµÄ±¨ÎÄ·¢ËÍʱ²»´ò±êÇ©¡£
ÔÚÕâÀïÏÈÒªÏò´ó¼Ò²ûÃ÷¶Ë¿ÚµÄȱʡVLANÕâ¸ö¸ÅÄî
Access¶Ë¿ÚÖ»ÊôÓÚ1¸öVLAN£¬ËùÒÔËüµÄȱʡVLAN¾ÍÊÇËüËùÔÚµÄVLAN£¬²»ÓÃÉèÖã»
Hybrid¶Ë¿ÚºÍTrunk¶Ë¿ÚÊôÓÚ¶à¸öVLAN£¬ËùÒÔÐèÒªÉèÖÃȱʡVLAN ID¡£È±Ê¡Çé¿öÏ£¬Hybrid¶Ë¿ÚºÍTrunk¶Ë¿ÚµÄȱʡVLANΪVLAN 1
µ±¶Ë¿Ú½ÓÊÕµ½²»´øVLAN TagµÄ±¨Îĺó£¬Ôò½«±¨ÎÄת·¢µ½ÊôÓÚȱʡVLANµÄ¶Ë¿Ú£¨Èç¹ûÉèÖÃÁ˶˿ڵÄȱʡVLAN ID£©¡£µ±¶Ë¿Ú·¢ËÍ´øÓÐVLAN TagµÄ±¨ÎÄʱ£¬Èç¹û¸Ã±¨ÎĵÄVLAN IDÓë¶Ë¿ÚȱʡµÄVLAN IDÏàͬ£¬Ôòϵͳ½«È¥µô±¨ÎĵÄVLAN Tag£¬È»ºóÔÙ·¢Ë͸ñ¨ÎÄ¡£
×¢£º¶ÔÓÚ»ªÎª½»»»»úȱʡVLAN±»³ÆΪ“Pvid Vlan”£¬¶ÔÓÚ˼¿Æ½»»»»úȱʡVLAN±»³ÆΪ“Native Vlan”½»»»»ú½Ó¿Ú³öÈëÊý¾Ý´¦Àí¹ý³ÌÈçÏ£º
Acess¶Ë¿ÚÊÕ±¨ÎÄ:
ÊÕµ½Ò»¸ö±¨ÎÄ,ÅжÏÊÇ·ñÓÐVLANÐÅÏ¢£ºÈç¹ûûÓÐÔò´òÉ϶˿ڵÄPVID£¬²¢½øÐн»»»×ª·¢,Èç¹ûÓÐÔòÖ±½Ó¶ªÆú£¨È±Ê¡£©
Acess¶Ë¿Ú·¢±¨ÎÄ£º
½«±¨ÎĵÄVLANÐÅÏ¢°þÀ룬ֱ½Ó·¢ËͳöÈ¥   
£¨ËùÒÔ£¬Access¶Ë¿Ú¿ÉÒÔʵÏÖͬһ½


Ïà¹ØÎĵµ£º

½â¾öSQL ServerתACCESS×Ô¶¯±àºÅÎÊÌâ


1.´ò¿ªSQL server enterprise mananger “ÆóÒµ¹ÜÀíÆ÷”
ÔÚÄãÒªµ¼³öµÄSQLÊý¾Ý¿âÉÏÊó±êÓÒ¼ü²Ëµ¥£ºËùÓÐÈÎÎñ-¡·µ¼³öÊý¾Ý
2.»Ø³öÏÖÒ»¸öµ¼³öÏòµ¼´°¿Ú¡£
Ñ¡Ôñ±»µ¼³öµÄÊý¾ÝÔ´£¬ÎªÄã¸Õ²ÅËùÑ¡ÔñµÄÊý¾Ý¿â£¬Èç¹û·¢ÏÖ²»¶ÔÓ¦×ÔÐÐÐ޸ġ£
3.½øÈëµ¼³öµ½Ä¿±êÊý¾ÝÔ´µÄÑ¡Ôñ£¬ÕâÀïÎÒÃÇҪת³ÉACCESSµÄÊý¾Ý¿â¡£×¢ÒâÑ¡ÔñÊý¾ÝÔ´ÀàÐÍÎ ......

ASP.NETµÄACCESSÊý¾Ý¿â²Ù×÷Àà

//private string datapatch = ConfigurationSettings.AppSettings["acessconn"];//Êý¾Ý¿âµØÖ· 
private string datapatch = "db/global.asa";//Êý¾Ý¿âµØÖ· 
/// 
/// È¡µÃdataset 
// 
/// ²éѯÓï¾ä 
/// 
public DataSet GetDataSet(string Commandtext) 
{&nbs ......

¼Ü¹¹B/SËÄ DALFactory Êý¾Ý·ÃÎʲã Data Access Layer

2008-04-10 09:45 //*******FactoryManage.cs using System;
using System.Reflection;
using System.Configuration;
using CoalTraffic.IDAL; namespace CoalTraffic.DALFactory
{
    /// <summary>
    /// ³éÏ󹤳§Ä£Ê½´´½¨DAL¡£
   ......

SQL Access Advisor

Oracle Êý¾Ý¿â 10g ÌṩÁË´óÁ¿°ïÖú³ÌÐò£¨»ò“¹ËÎʳÌÐò”£©£¬¿É°ïÖúÄú¾ö¶¨×î¼Ñ²Ù×÷Á÷³Ì¡£ÆäÖÐÒ»¸öʾÀýÊÇ SQL Tuning Advisor£¬Ëü¿ÉÒÔÌṩÓйزéѯµ÷ÕûÒÔ¼°ÔÚÁ÷³ÌÖÐÑÓ³¤Õû¸öÓÅ»¯¹ý³ÌµÄ½¨Òé¡£
µ«Ç뿼ÂÇÒÔϵ÷Õû°¸Àý£º¼ÙÉèÒ»¸öË÷ÒýȷʵÓÐÖúÓÚij¸ö²éѯ£¬µ«¸Ã²éѯִֻÐÐÒ»´Î¡£ÕâÑù£¬¼´Ê¹¸Ã²éѯ¿ÉÒÔµÃÒæÓÚ´ËË÷Òý£¬µ«´´ ......

C#Á¬½ÓAccessÊý¾Ýʱ×ܱ¨ÕÒ²»µ½dbo.mdbµÄÎÊÌâ

½ñÌìÓÃOleDbÁ¬½ÓAccessʱ×ܱ¨ÕÒ²»µ½dbo.mdbµÄÎÊÌâ¡£¿ÉÊÇÎÒµÄÁ¬½Ó×Ö·û´®ÖÐÃ÷Ã÷д×Ålocal.mdb¡£µ¥²½¸ú×Ùµ÷ÊÔ·¢ÏÖConnectionÖеÄÁ¬½Ó×Ö·û´®Ò²ÊÇ”Provider=Microsoft.Jet.OLEDB.4.0; Data Source=local.mdb;”£¬¸ù±¾Ã»ÓÐdbo.mdbµÄÊ¡£ºóÀ´²é¹ýÅŲ鷢ÏÖÊÇschemaµÄÎÊÌâ¡£SQL ServerÖÐÓÐschemaµÄ¸ÅÄîËùÒÔÎÒÃÇÒ»°ã¶¼Ï°¹ß ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ