Ëùν“´æÈ¡¼ü”¾ÍÏñ windows Ó¦ÓóÌÐòÖÐµÄ Alt ¿ì½Ý¼ü£¬Í¬Ê±°´ Alt ¼üºÍij¸ö×Öĸ¼ü£¬¿ÉÒÔ¿ìËÙÇл»µ½Îı¾¿ò¡¢°´Å¥µÈÒ³Ãæ¶ÔÏóÉÏ¡£
(1)¡¢Îı¾¿òµÄ Access Key£º
<FORM>
<LABEL FOR="Namebox" ACCESSKEY="N"><U>N</U>ame:</LABEL>
<INPUT TYPE="TEXT" ID="Namebox" SIZE=30>
<LABEL FOR="Emailbox" ACCESSKEY="E"><U>E</U>mail:</LABEL>
<INPUT TYPE="TEXT" ID="Emailbox" SIZE=30>
<LABEL FOR="areabox" ACCESSKEY="S"><U>S</U>uggest</LABEL>
<TEXTAREA ID="areabox" COLS="10" ROWS="2"></TEXTAREA>
</FORM>
ÆäÖÐµÄ <U>…</U> ±êÇ©²úÉúÏ»®Ïߣ»For="Name" ºÍ ID="Name" ÖÐµÄ Name ÊÇÒ»Öµģ»ACCESSKEY=… ÉèÖÓÈȼü”¡£
(2)¡¢Ñ¡Ôñ¿òµÄ Acsess Key£ºÑ¡ÔñÏîĿʱ²»±Ø·ÇµÃÔÚ¿òÄÚµã»÷Êó±êÁË£¬ÔÚÎı¾ÉÏÑ¡Ôñ¼´¿É£º
<form>
<label for="check1">ÎÒ°®ÕÅÇì</label>
<input type="CHECKBOX" id="check1" value="often" name="checkoften">
<label for="check2">ÎÒ¸ü°®¡¶& ......
Java д Access
1. ÔÚ±¾µØÖÐÎļÆËã»úÉÏ£¬·¢ÏÖдÖÐÎĵ½accessÉÏ£¬³öÏÖÂÒÂë¡£¶ÁµÄʱºòÒ²ÊÇÂÒÂë¡£
2. ¶ÁµÄʱºò£¬²»ÄܶÁstring£¬ÏÈʹÓÃbyte¶Á³öÀ´£¬È»ºóÔÙ´´½¨GBK±àÂëµÄString.
3. ²Î¿¼¶Á£¬¿ÉÄÜдµÄʱºòÒ²ÊDZàÂëת»»µÄÎÊÌ⣬ËùÒÔÒ»Ö±ÔÚ×ö±àÂëת»»£¬¿ÉÊÇÎÞÂÛÈçºÎÒ²²»ÄÜÕýȷдÈë¡£
4. ¿¼ÂÇÊÇ·ñÊÇ»·¾³ÓÐÎÊÌâ¡£´Ónetbeans6.7.1תÒƵ½ÁËeclipse3.4.2¡£ÎÊÌâÒÀ¾É¡£
5. µ½ÁíÍâµÄ»úÆ÷ÉÏÈ¥ÊÔÁË£¬ÓкÍÎÒ»úÆ÷ÏÖÏóÏàͬµÄ£¬Ò²ÓÐÕý³£µÄ¡£¼ÈÈ»ÓÐÕý³£µÄ£¬ÄÇô»¹ÊÇ¿ÉÄÜÓÐЩÉèÖá£
6. ·ÖÎöÁ˰ѹ¤³ÌתΪUTF-8»òÕßGBKʵ¼ÊûÓйØϵ£¬ÒòΪÕâÖ»ÊÇÓ°ÏìjavacµÄ±àÒë¡£Ö»ÒªÔÚjavacµÄʱºòÖ¸¶¨ÁËencoding£¬ÄÇô±àÂë¾ÍûÓйØϵÁË¡£¿ÉÊÇ£¬¹¤³ÌÖ¸¶¨ÎªGBKµÄʱºò£¬²âÊÔ³ÌÐò»¹ÊÇÕý³£ÁË£¬µ«ÊÇ£¬ÎÒÓõÄswing£¬ÆäÇ°¶ËÊÇUTF-8µÄ£¬¶øÇÒÎҵijÌÐòÐèÒª¿¼ÂÇÖÐÈÕÎÄ£¬ËùÒÔÎÒ»¹ÊÇҪʹÓÃUTF-8¡£
7. ·¢ÏÖ¿ØÖÆ̨ÉÏÖ±½ÓʹÓÃjavaÃüÁ¿ÉÒÔÕý³££¬µ«ÊÇͬÑùµÄµ½ ......
Java д Access
1. ÔÚ±¾µØÖÐÎļÆËã»úÉÏ£¬·¢ÏÖдÖÐÎĵ½accessÉÏ£¬³öÏÖÂÒÂë¡£¶ÁµÄʱºòÒ²ÊÇÂÒÂë¡£
2. ¶ÁµÄʱºò£¬²»ÄܶÁstring£¬ÏÈʹÓÃbyte¶Á³öÀ´£¬È»ºóÔÙ´´½¨GBK±àÂëµÄString.
3. ²Î¿¼¶Á£¬¿ÉÄÜдµÄʱºòÒ²ÊDZàÂëת»»µÄÎÊÌ⣬ËùÒÔÒ»Ö±ÔÚ×ö±àÂëת»»£¬¿ÉÊÇÎÞÂÛÈçºÎÒ²²»ÄÜÕýȷдÈë¡£
4. ¿¼ÂÇÊÇ·ñÊÇ»·¾³ÓÐÎÊÌâ¡£´Ónetbeans6.7.1תÒƵ½ÁËeclipse3.4.2¡£ÎÊÌâÒÀ¾É¡£
5. µ½ÁíÍâµÄ»úÆ÷ÉÏÈ¥ÊÔÁË£¬ÓкÍÎÒ»úÆ÷ÏÖÏóÏàͬµÄ£¬Ò²ÓÐÕý³£µÄ¡£¼ÈÈ»ÓÐÕý³£µÄ£¬ÄÇô»¹ÊÇ¿ÉÄÜÓÐЩÉèÖá£
6. ·ÖÎöÁ˰ѹ¤³ÌתΪUTF-8»òÕßGBKʵ¼ÊûÓйØϵ£¬ÒòΪÕâÖ»ÊÇÓ°ÏìjavacµÄ±àÒë¡£Ö»ÒªÔÚjavacµÄʱºòÖ¸¶¨ÁËencoding£¬ÄÇô±àÂë¾ÍûÓйØϵÁË¡£¿ÉÊÇ£¬¹¤³ÌÖ¸¶¨ÎªGBKµÄʱºò£¬²âÊÔ³ÌÐò»¹ÊÇÕý³£ÁË£¬µ«ÊÇ£¬ÎÒÓõÄswing£¬ÆäÇ°¶ËÊÇUTF-8µÄ£¬¶øÇÒÎҵijÌÐòÐèÒª¿¼ÂÇÖÐÈÕÎÄ£¬ËùÒÔÎÒ»¹ÊÇҪʹÓÃUTF-8¡£
7. ·¢ÏÖ¿ØÖÆ̨ÉÏÖ±½ÓʹÓÃjavaÃüÁ¿ÉÒÔÕý³££¬µ«ÊÇͬÑùµÄµ½ ......
½ñÌìÓÃOleDbÁ¬½ÓAccessʱ×ܱ¨ÕÒ²»µ½dbo.mdbµÄÎÊÌâ¡£¿ÉÊÇÎÒµÄÁ¬½Ó×Ö·û´®ÖÐÃ÷Ã÷д×Ålocal.mdb¡£µ¥²½¸ú×Ùµ÷ÊÔ·¢ÏÖConnectionÖеÄÁ¬½Ó×Ö·û´®Ò²ÊÇ”Provider=Microsoft.Jet.OLEDB.4.0; Data Source=local.mdb;”£¬¸ù±¾Ã»ÓÐdbo.mdbµÄÊ¡£ºóÀ´²é¹ýÅŲ鷢ÏÖÊÇschemaµÄÎÊÌâ¡£SQL ServerÖÐÓÐschemaµÄ¸ÅÄîËùÒÔÎÒÃÇÒ»°ã¶¼Ï°¹ßд³Édbo.xxxTable£¬ËùÒÔÈç¹ûÄãÒªÊÇÒ²ÔÚAccessÖÐÕâÑùдµÄ»°£¬¾Í»á±¨ÈçÉÏÕÒ²»µ½dbo.mdbµÄÎÊÌâ¡£ÐÞ¸ÄSQLÓï¾ä£¬È¥µôdboºó£¬ÎÊÌâ½â¾ö¡£ ......
½ñÌìÓÃOleDbÁ¬½ÓAccessʱ×ܱ¨ÕÒ²»µ½dbo.mdbµÄÎÊÌâ¡£¿ÉÊÇÎÒµÄÁ¬½Ó×Ö·û´®ÖÐÃ÷Ã÷д×Ålocal.mdb¡£µ¥²½¸ú×Ùµ÷ÊÔ·¢ÏÖConnectionÖеÄÁ¬½Ó×Ö·û´®Ò²ÊÇ”Provider=Microsoft.Jet.OLEDB.4.0; Data Source=local.mdb;”£¬¸ù±¾Ã»ÓÐdbo.mdbµÄÊ¡£ºóÀ´²é¹ýÅŲ鷢ÏÖÊÇschemaµÄÎÊÌâ¡£SQL ServerÖÐÓÐschemaµÄ¸ÅÄîËùÒÔÎÒÃÇÒ»°ã¶¼Ï°¹ßд³Édbo.xxxTable£¬ËùÒÔÈç¹ûÄãÒªÊÇÒ²ÔÚAccessÖÐÕâÑùдµÄ»°£¬¾Í»á±¨ÈçÉÏÕÒ²»µ½dbo.mdbµÄÎÊÌâ¡£ÐÞ¸ÄSQLÓï¾ä£¬È¥µôdboºó£¬ÎÊÌâ½â¾ö¡£ ......
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µÄ±¨ÎÄ£¬¿ÉÒÔÓÃÓÚ½»»»»úÖ®¼äÁ¬½Ó£¬Ò²¿ÉÒÔÓÃÓÚÁ¬½ÓÓû§µÄ ......
Microsoft AccessÊÇÒ»ÖÖ¹ØϵʽÊý¾Ý¿â£¬¹ØϵʽÊý¾Ý¿âÓÉһϵÁбí×é³É£¬±íÓÖÓÉһϵÁÐÐкÍÁÐ×é³É£¬Ã¿Ò»ÐÐÊÇÒ»¸ö¼Ç¼£¬Ã¿Ò»ÁÐÊÇÒ»¸ö×ֶΣ¬Ã¿¸ö×Ö¶ÎÓÐÒ»¸ö×Ö¶ÎÃû£¬×Ö¶ÎÃûÔÚÒ»¸ö±íÖв»ÄÜÖظ´¡£ ¡¡¡¡
±íÓë±íÖ®¼ä¿ÉÒÔ½¨Á¢¹Øϵ£¨»ò³Æ¹ØÁª£¬Á¬½Ó£©£¬ÒÔ±ã²éѯÏà¹ØÁªµÄÐÅÏ¢¡£AccessÊý¾Ý¿âÒÔÎļþÐÎʽ±£´æ£¬ÎļþµÄÀ©Õ¹ÃûMDB¡£ ¡¡¡¡
Access Êý¾Ý¿âÓÉÁùÖÖ¶ÔÏó×é³É£¬ËüÃÇÊÇ±í¡¢²éѯ¡¢´°Ìå¡¢±¨±í¡¢ºêºÍÄ£¿é¡£
¡¡¡¡±í(Table) ——±íÊÇÊý¾Ý¿âµÄ»ù±¾¶ÔÏó£¬ÊÇ´´½¨ÆäËû5ÖÖ¶ÔÏóµÄ»ù´¡¡£±íÓɼǼ×é³É£¬¼Ç¼ÓÉ×Ö¶Î×é³É£¬±íÓÃÀ´´æÖüÊý¾Ý¿âµÄÊý¾Ý£¬¹ÊÓÖ³ÆÊý¾Ý±í¡£
¡¡¡¡²éѯ(Query)——²éѯ¿ÉÒÔ°´Ë÷Òý¿ìËÙ²éÕÒµ½ÐèÒªµÄ¼Ç¼£¬°´ÒªÇóɸѡ¼Ç¼²¢ÄÜÁ¬½ÓÈô¸É¸ö±íµÄ×Ö¶Î×é³ÉÐÂ±í¡£ ¡¡
¡¡¡¡´°Ìå(Form)——´°ÌåÌṩÁËÒ»ÖÖ·½±ãµÄä¯ÀÀ¡¢ÊäÈë¼°¸ü¸ÄÊý¾ÝµÄ´°¿Ú¡£»¹¿ÉÒÔ´´½¨×Ó´°ÌåÏÔʾÏà¹ØÁªµÄ±íµÄÄÚÈÝ¡£´°ÌåÒ²³Æ±íµ¥¡£
¡¡¡¡±¨±í(Report)——±¨±íµÄ¹¦ÄÜÊǽ«Êý¾Ý¿âÖеÄÊý¾Ý·ÖÀà»ã×Ü£¬È»ºó´òÓ¡³öÀ´£¬ÒÔ±ã·ÖÎö¡£ ¡¡¡¡
¡¡¡¡ºê(Macro)——ºêÏ൱ÓÚDOSÖеÄÅú´¦Àí£¬ÓÃÀ´×Ô¶¯Ö´ÐÐһϵÁвÙ×÷¡£AccessÁгöÁËһЩ³£ÓõIJÙ×÷¹©Óû§Ñ¡Ôñ£¬Ê¹ÓÃÆðÀ´Ê®·Ö·½±ã¡£
¡¡¡¡Ä£¿é(Modul ......
תÔصØÖ·£ºhttp://hi.baidu.com/mbaba/blog/item/39dc8b58d41191dc9c8204c8.html
ºÜ¶àÅóÓÑËäÈ»°²×°ºÃÁËmysqlµ«È´²»ÖªÈçºÎʹÓÃËü¡£ÔÚÕâƪÎÄÕÂÖÐÎÒÃǾʹÓÁ¬½ÓMYSQL¡¢ÐÞ¸ÄÃÜÂë¡¢Ôö¼ÓÓû§µÈ·½ÃæÀ´Ñ§Ï°Ò»Ð©MYSQLµÄ³£ÓÃÃüÁî¡£
Ò»¡¢Á¬½ÓMYSQL¡£
¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû £pÓû§ÃÜÂë
1¡¢Àý1£ºÁ¬½Óµ½±¾»úÉϵÄMYSQL¡£
Ê×ÏÈÔÚ´ò¿ªDOS´°¿Ú£¬È»ºó½øÈëĿ¼ mysqlbin£¬ÔÙ¼üÈëÃüÁîmysql -uroot -p£¬»Ø³µºóÌáʾÄãÊäÃÜÂ룬Èç¹û¸Õ°²×°ºÃMYSQL£¬³¬¼¶Óû§rootÊÇûÓÐÃÜÂëµÄ£¬¹ÊÖ±½Ó»Ø³µ¼´¿É½øÈëµ½MYSQLÖÐÁË£¬MYSQLµÄÌáʾ·ûÊÇ£ºmysql>;
2¡¢Àý2£ºÁ¬½Óµ½Ô¶³ÌÖ÷»úÉϵÄMYSQL¡£¼ÙÉèÔ¶³ÌÖ÷»úµÄIPΪ£º110.110.110.110£¬Óû§ÃûΪroot,ÃÜÂëΪabcd123¡£Ôò¼üÈëÒÔÏÂÃüÁ
mysql -h110.110.110.110 -uroot -pabcd123
£¨×¢:uÓëroot¿ÉÒÔ²»Óüӿոñ£¬ÆäËüÒ²Ò»Ñù£©
3¡¢Í˳öMYSQLÃüÁ exit £¨»Ø³µ£©
¶þ¡¢ÐÞ¸ÄÃÜÂë¡£
¸ñʽ£ºmysqladmin -uÓû§Ãû -p¾ÉÃÜÂë password ÐÂÃÜÂë
1¡¢Àý1£º¸øroot¼Ó¸öÃÜÂëab12¡£Ê×ÏÈÔÚDOSϽøÈëĿ¼mysqlbin£¬È»ºó¼üÈëÒÔÏÂÃüÁî
mysqladmin -uroot -password ab12
×¢£ºÒòΪ¿ªÊ¼Ê±rootûÓÐÃÜÂ룬ËùÒÔ-p¾ÉÃÜÂëÒ»Ïî¾Í¿ÉÒÔÊ¡ÂÔÁË¡£
2¡¢Àý2£ºÔÙ½«rootµÄÃÜ ......