Come nearly 10 years, medium, outside the scholar affirmed mental element is in diabetic happening, developing action, those who think to accompanying mental insecurity, mood is excited reach all sort..
http://en.medicineresearch.org/Medical_knowledge/t4284

Diabetic policy group was in Asia-Pacific area 4 years in September Australia published the second edition of guideline of ¢ò diabetic cure, mix to diabetic diagnostic standard cent have new proposal ..
http://en.medicineresearch.org/Medical_knowledge/t4344

The reporter learns 29 days from hospital of Guangzhou city children, this courtyard near future discovered to account still is not had on schoolbook of a kind of medicine, but OK however and deadly n..
http://en.medicineresearch.org/Medical_knowledge/t4484

The turn of life is diabetic Diabetic it is a kind of common endocrine metabolization disorder sex disease, woman of the turn of life suffers from easily diabetic, this is decided by place of characte..
http://en.medicineresearch.org/Medical_knowledge/t4504

Hotpot sex is tepid, often take easy suffer from excessive internal heat. The doctor of traditional Chinese medicine is exquisite %26quot; heat is cold %26quot; dietotherapy method. Accordingly, what coll..
http://en.medicineresearch.org/Medical_knowledge/t4544

One, eliminate abdomen adipose, constrictive and abdominal muscle The body sits on the chair, the body and ham become 90 degrees, the back should sit straight. Both hands is put in ham two side, help ..
http://en.medicineresearch.org/Medical_knowledge/t4944

Differentiate true sex and pseudomyopia, outside dividing hospital optometry, simple method can hang eyesight of one international standard to express in 5 meters of far, define vision first, wear 300..
http://en.medicineresearch.org/Medical_knowledge/t5084

Climate is heated, holiday will come. The doctor reminds, ultraviolet ray already showed killer instinctive quality, pathogenic bacteria of contagion of path of this one seasonal bowel grows breed is ..
http://en.medicineresearch.org/Medical_knowledge/t5284

Ideal sexual life is the important facet that husband and wife lives, but in real life, a lot of females complain its sexual life is faulty. Complaint is most is, the husband tumble into bed after sex..
http://en.medicineresearch.org/Medical_knowledge/t5704

Hello I want to ask. I 24. Masturbate for a long time previously. Susceptibility is very tall, masturbation is done not have a few times now shot. In sexual life when also be after inserting, do not h..
http://medicine.gegemeimei.com/Gender_health/t7493

¼ÓÃÜ»ò½âÃÜÊý¾Ý¿â

×î¼òµ¥£¨Ò²ÊÇ°²È«ÐÔ×îµÍ£©µÄ±£»¤·½·¨ÊǶÔÊý¾Ý¿â½øÐмÓÃÜ¡£¼ÓÃÜÊý¾Ý¿â¾ÍÊǽ«Êý¾Ý¿âÎļþѹËõ£¬´Ó¶øʹijЩʵÓóÌÐò£¨Èç×Ö´¦ÀíÆ÷£©²»Äܽâ¶ÁÕâЩÎļþ¡£¼ÓÃÜÒ»¸ö²»¾ßÓа²È«ÉèÖõÄÊý¾Ý¿â²¢²»Äܱ£Ö¤Êý¾Ý¿âµÄ°²È«£¬ÒòΪÈκÎÈ˶¼¿ÉÒÔ´ò¿ªÊý¾Ý¿â²¢ÍêÈ«·ÃÎÊÊý¾Ý¿âÖеÄËùÓжÔÏó¡£ÓйضÔÊý¾Ý¿â½øÐа²È«ÉèÖõÄÏêϸÄÚÈÝ£¬Çë²ÎÔı¾ÎĺóÃæµÄʹÓà Security Wizard ÉèÖà Access Êý¾Ý¿âµÄ°²È«ÐÔ¡£

¼ÓÃÜ¿ÉÒÔ±ÜÃâÔÚÒÔµç×Ó·½Ê½´«ÊäÊý¾Ý¿â»òÕß½«Æä´æ´¢ÔÚÈíÅÌ¡¢´Å´ø»ò¹âÅÌÉÏʱ£¬ÆäËûÓû§Å¼È»·ÃÎÊÊý¾Ý¿âÖеÄÐÅÏ¢¡£È»¶ø Jet£¨Access ʹÓõÄÊý¾Ý¿âÒýÇ棩ʹÓõļÓÃÜ·½·¨·Ç³£±¡Èõ£¬Òò´Ë¾ø²»ÄÜÓÃÓÚ±£»¤Ãô¸ÐÊý¾Ý¡£¡°¼ÓÃÜ/½âÃÜÊý¾Ý¿â¡±ÃüÁîλÓÚ¡°¹¤¾ß¡±²Ëµ¥µÄ¡°°²È«¡±×Ӳ˵¥ÖС£½âÃÜÊý¾Ý¿âÊǶԼÓÃܹý³ÌµÄÄæÔËËã¡£

ʹÓÃ×Ô¶¨Òå½çÃæ

ÁíÒ»ÖÖÏà¶Ô¼òµ¥µÄ±£»¤·½°¸ÊÇʹÓÃ×Ô¶¨Òå½çÃæ´úÌæ Access ±ê×¼½çÃæ¡£Óë¼ÓÃÜÒ»Ñù£¬ËüÒ²²»Äܱ£»¤Êý¾Ý¿âÖеĶÔÏóºÍÃô¸ÐÊý¾ÝµÄ°²È«¡£Í¨¹ýÑ¡Ôñ¡°¹¤¾ß¡±²Ëµ¥Öеġ°Æô¶¯¡±Ñ¡ÏÄú¿ÉÒÔÖ¸¶¨×Ô¶¨ÒåµÄÆô¶¯´°Ìå¡¢²Ëµ¥£¬ÉõÖÁ×Ô¶¨ÒåµÄ±êÌâºÍͼ±ê¡£»¹¿ÉÒÔÑ¡ÔñÈ¡Ïû Database ´°¿Ú£¬´Ó¶ø¶Ôȱ·¦ÏàÓ¦¼¼ÊõµÄÓ¦ÓóÌÐòÓû§Òþ²ØÕâЩ¶ÔÏ󡣡°Æô¶¯¡±¶Ô»°¿òµÄ¸÷ÏÄÜÒ²¿ÉÒÔͨ¹ý±à³ÌʵÏÖ¡£ÓйØÈçºÎ´Ó¡°Æô¶¯¡±¶Ô»°¿òÉèÖÃÆô¶¯Ñ¡ÏîµÄÏêϸÐÅÏ¢£¬Çë²ÎÔÄ Access °ïÖúÖеġ°¹ØÓÚÆô¶¯Ñ¡Ï¡£ÓйØÈçºÎͨ¹ý±à³ÌÉèÖÃÆô¶¯Ñ¡ÏîµÄÏêϸÐÅÏ¢£¬Çë²ÎÔÄ Access °ïÖú Microsoft Visual Basic%26reg; ±à¼­Æ÷µÄ¡°ÉèÖá®Æô¶¯¡¯Ñ¡ÏîºÍ±àÂëÖеÄÑ¡Ï¡£

ÉèÖÃÊý¾Ý¿âÃÜÂë

Äú¿ÉÒÔÔÚÊý¾Ý¿âÉÏÉèÖÃÃÜÂ룬´Ó¶øÒªÇóÓû§ÔÚ·ÃÎÊÊý¾ÝºÍÊý¾Ý¿â¶ÔÏóʱÊäÈëÃÜÂë¡£

×¢Ò⣺ʹÓÃÃÜÂë±£»¤Êý¾Ý¿â»òÆäÖеĶÔÏóµÄ°²È«ÐÔÒ²³ÆΪ¹²Ïí¼¶°²È«ÐÔ¡£

Äú²»ÄÜʹÓôËÑ¡ÏîΪÓû§»ò×é·ÖÅäȨÏÞ£¬Òò´ËÈκÎÕÆÎÕÃÜÂëµÄÈ˶¼¿ÉÒÔÎÞÏÞÖƵطÃÎÊËùÓÐ Access Êý¾ÝºÍÊý¾Ý¿â¶ÔÏ󡣡°ÉèÖÃÊý¾Ý¿âÃÜÂ롱ÃüÁîλÓÚ¡°¹¤¾ß¡±²Ëµ¥µÄ¡°°²È«¡±×Ӳ˵¥ÖС£

Óû§¼¶°²È«ÐÔ

³ý¹²Ïí¼¶°²È«ÐÔÍ⣬Äú»¹¿ÉÒÔʹÓÃÓû§¼¶°²È«ÐÔ£¬ËüÌṩÁË×îÑϸñµÄ·ÃÎÊÏÞÖÆ£¬Ê¹ÄúÄܹ»×î´óÏ޶ȵؿØÖÆÊý¾Ý¿â¼°ÆäÖаüº¬µÄ¶ÔÏó¡£ÕâÊÇÎÒÃÇËùÍƼöµÄÊý¾Ý¿â±£»¤´ëÊ©µÄÒ»²¿·Ö£¨µ±ºÍ²Ù×÷ϵͳÌṩµÄÎļþ¼¶ºÍ¹²Ïí¼¶°²È«ÐÔ½áºÏʹÓÃʱ£©£¬Òò´ËÎÒÃǽ«ÔÚ±¾ÎĺóÃæ¶ÔÓû§¼¶°²È«ÐÔ×öÏêϸ½éÉÜ¡£

ͬÑù£¬ÎÒÃÇÒ²½«ÌÖÂÛÓÃÓÚ±£»¤Êý¾Ý¿âÖаüº¬µÄ Visual Basic for Applications (VBA) ´úÂëµÄ¸÷ÖÖ·½·¨¡£

¾¯¸æ£ºÓû§¼¶°²È«ÐÔ£¨ÔÚµ¥¶ÀʹÓÃʱ£©Ö÷ÒªÓÃÓÚ±£»¤Êý¾Ý¿âÖеĴúÂëºÍ¶ÔÏó£¬ÒÔÃâÓû§²»Ð¡ÐĽøÐÐÁËÐ޸Ļò¸ü¸Ä¡£Èç¹û²»Ï£ÍûÓû§·Ç·¨·ÃÎÊ´°Ìå¡¢±¨±í»òÄ£¿éÖеĴúÂ룬Ôò±ØÐ뽫 .mdb Îļþת»»Îª MDE Îļþ£¨±¾ÎĺóÃ潫Ïêϸ½éÉÜ£©¡£Òª±ÜÃâÓû§ÐÞ¸ÄÊý¾Ý¿âÖеIJéѯ¡¢ºê»òÊý¾Ý·ÃÎÊÒ³£¬Î¨Ò»µÄ·½·¨¾ÍÊǽ«Êý¾Ý¿âÎļþ·ÅÔÚÒ»¸öÊܱ£»¤µÄÎļþ¹²ÏíÇøÓòÖС£´ËÍ⣬ÔÚ Access Öв»¿ÉÄܼÈÔÊÐíÓû§Ð޸ıíÖеÄÊý¾Ý£¬Í¬Ê±ÓÖ½ûÖ¹ÆäÐ޸ıíµÄÉè¼Æ»òɾ³ý±í¡£ÒªÌṩÕâÑùÒ»ÖÖ¹¦ÄÜ£¬ÐèҪʹÓÃÒ»¸ö»ùÓÚ·þÎñÆ÷µÄÊý¾Ý¿â²úÆ·£¬ÀýÈç Microsoft SQL Server%26#8482;¡£

ÉèÖÃÄ£¿éÃÜÂë

ʹÓÃÃÜÂë¿ÉÒÔ±£»¤ËùÓбê׼ģ¿éºÍÀàÄ£¿é£¨ÀýÈç´°ÌåºÍ±¨±íÖаüº¬µÄ´úÂ룩ÒÔÃâÓû§²»Ð¡ÐÄÐ޸Ļò²é¿´ VBA ´úÂë¡£ÉèÖÃÃÜÂëºó£¬ÄúÖ»ÐèÔÚÿ´Î»á»°Ê±ÊäÈëÒ»´ÎÃÜÂ룬ÒÔ±ãÔÚ Visual Basic ±à¼­Æ÷Öв鿴»òÐ޸ĴúÂë¡£³ý²é¿´ºÍ±à¼­Í⣬ÔÚ¼ôÇС¢¸´ÖÆ¡¢Õ³Ìù¡¢µ¼³ö»òɾ³ýÈκÎÄ£¿éʱҲ¶¼ÐèÒªÃÜÂë¡£µ«Ó¦¸ÃÇå³þµÄÊÇ£¬Ê¹ÓÃÕâÖÖ·½·¨±£»¤´úÂë²»ÄÜ·ÀÖ¹Äú»òÆäËûÓû§ÔËÐдúÂ룬Ҳ²»ÄÜ·ÀÖ¹ÆäËûÓû§Ê¹ÓõÚÈý·½ÊµÓóÌÐò£¨Èç 16 ½øÖƱ༭Æ÷£©À´²é¿´´úÂë¡£ÒªÍêÈ«±£»¤´úÂ룬±ØÐ뽫 .mdb Îļþת»»Îª MDE Îļþ¡£

ҪΪÏîÄ¿ÖеÄÄ£¿éÉèÖÃÃÜÂ룺

1.Ϊ¸ÃÏîÄ¿´Ó Visual Basic ±à¼­Æ÷µÄ¡°¹¤¾ß¡±²Ëµ¥ÖÐÑ¡Ôñ¡°ÊôÐÔ¡±ÃüÁî¡£

2.ÔÚ¡°ÏîÄ¿ÊôÐÔ¡±¶Ô»°¿òÖУ¬µ¥»÷¡°±£»¤¡±Ñ¡Ï¡£

3.Ñ¡ÖС°²é¿´Ê±Ëø¶¨¹¤³Ì¡±¸´Ñ¡¿ò²¢¼üÈëÃÜÂë¡£

4.ÔÚ¡°È·ÈÏÃÜÂ롱¿òÖУ¬ÖØмüÈëÃÜÂ룬Ȼºóµ¥»÷¡°È·¶¨¡±¡£

ʹÓà MDE Îļþ

ͨ¹ý½«Êý¾Ý¿âÎļþת»»Îª MDE Îļþ£¬¿ÉÒÔÍêÈ«±£»¤ Access ÖеĴúÂëÃâÊÜ·Ç·¨·ÃÎÊ¡£½« .mdb Îļþת»»Îª MDE Îļþʱ£¬Access ½«±àÒëËùÓÐÄ£¿é£¬É¾³ýËùÓпɱ༭µÄÔ´´úÂ룬ȻºóѹËõÄ¿±êÊý¾Ý¿â¡£Ô­Ê¼µÄ .mdb Îļþ²»»áÊܵ½Ó°Ïì¡£ÐÂÊý¾Ý¿âÖÐµÄ VBA ´úÂëÈÔÈ»ÄÜÔËÐУ¬µ«²»Äܲ鿴»ò±à¼­¡£Êý¾Ý¿â½«¼ÌÐøÕý³£¹¤×÷£¬ÄúÈÔÈ»¿ÉÒÔÉý¼¶Êý¾ÝºÍÔËÐб¨±í¡£ÓÈÆäÊÇ£¬½« Access Êý¾Ý¿â±£´æΪ MDE Îļþ¿ÉÒÔ·ÀÖ¹ÒÔϲÙ×÷£º

%26#8226; ÔÚÉè¼ÆÊÓͼÖв鿴¡¢Ð޸Ļò´´½¨´°Ìå¡¢±¨±í»òÄ£¿é¡£

%26#8226; Ìí¼Ó¡¢É¾³ý»ò¸ü¸Ä¶Ô¶ÔÏó¿â»òÊý¾Ý¿âµÄÒýÓá£

%26#8226; ʹÓà Access »ò VBA ¶ÔÏóÄ£Ð͵ÄÊôÐÔ»ò·½·¨¸ü¸Ä´úÂë - MDE Îļþ²»°üº¬¿É±à¼­´úÂë¡£

%26#8226; µ¼Èë»òµ¼³ö´°Ìå¡¢±¨±í»òÄ£¿é¡£¶ø±í¡¢²éѯ¡¢Êý¾Ý·ÃÎÊÒ³ºÍºê¿ÉÒÔµ¼Èë·Ç MDE Êý¾Ý¿â£¬»ò´ÓÖе¼³ö¡£

Òª½«.mdbÎļþת»»Îª MDE Îļþ£º

1.¹Ø±ÕÊý¾Ý¿â¡£

2.µ¥»÷¡°¹¤¾ß¡±²Ëµ¥Öеġ°Êý¾Ý¿âʵÓù¤¾ß¡±¡£

3.µ¥»÷¡°Éú³É MDE Îļþ¡±¡£

4.ÔÚ¡°±£´æÊý¾Ý¿âΪ MDE¡±¶Ô»°¿òÖУ¬ÕÒµ½ .mdb Îļþ£¬È»ºóµ¥»÷¡°Éú³É MDE¡±¡£

×¢Ò⣺ÔÚ Access 2002 Öд´½¨µÄÊý¾Ý¿âʹÓÃĬÈ쵀 Access 2000 Îļþ¸ñʽ¡£Access 2000 Îļþ¸ñʽµÄÊý¾Ý¿âÖ»ÄÜÔÚ Access 2000 ÖÐת»»Îª MDE ¸ñʽ¡£ÒªÔÚ Access 2002 Öн«ÒÔĬÈ쵀 Access 2000 ¸ñʽ´´½¨µÄ .mdb Îļþת»»Îª MDE Îļþ£¬±ØÐëÏȽ«Îļþת»»Îª Access 2002 Îļþ¸ñʽ¡£Îª´Ë£¬¿ÉÒÔÊ×ÏÈÒÔ¶ÀÕ¼·½Ê½´ò¿ªÊý¾Ý¿â£¨ÒªÒÔ¶ÀÕ¼·½Ê½´ò¿ªÊý¾Ý¿â£¬Çë²ÎÔı¾ÎĺóÃæµÄÊÖ¶¯ÉèÖÃÊý¾Ý¿âÃÜÂëÒ»½Ú)¡£½ÓÏÂÀ´£¬Ö¸Ïò¡°¹¤¾ß¡±²Ëµ¥Öеġ°Êý¾Ý¿âʵÓù¤¾ß¡±£¬Ö¸Ïò¡°×ª»»Êý¾Ý¿â¡±£¬È»ºóµ¥»÷¡°×ªÎª Access 2002 Îļþ¸ñʽ¡±¡£Êý¾Ý¿â¼´¿Éת»»Îª MDE Îļþ¡£

¹ØÓÚ Access Óû§¼¶°²È«ÐÔ

Access ʹÓà Microsoft Jet Êý¾Ý¿âÒýÇæÀ´´æ´¢ºÍ¼ìË÷Êý¾Ý¿âÖеĶÔÏó¡£Jet Êý¾Ý¿âÒýÇæʹÓûùÓÚ¹¤×÷×éµÄ°²È«Ä£ÐÍ£¨Ò²³ÆΪÓû§¼¶°²È«ÐÔ£©À´ÅжÏË­¿ÉÒÔ´ò¿ªÊý¾Ý¿â£¬²¢±£»¤Êý¾Ý¿âËù°üº¬¶ÔÏóµÄ°²È«¡£ÎÞÂÛÊÇ·ñÃ÷È·ÉèÖÃÁËÊý¾Ý¿âµÄ°²È«ÐÔ£¬Óû§¼¶°²È«ÐÔ¶ÔËùÓÐ Access Êý¾Ý¿âʼÖÕ´¦ÓÚ´ò¿ª×´Ì¬¡£Äú¿ÉÒÔͨ¹ý²Ù×ÝÓû§ºÍ×éÕÊ»§µÄȨÏ޺ͳÉÔ±Éí·ÝÀ´¸ü¸Ä Access ÖеÄĬÈÏ°²È«¼¶±ð¡£ÏÂÃ潫¶Ô´Ë½øÐнéÉÜ¡£

ÎÞÂÛºÎʱÆô¶¯ Access£¬Jet Êý¾Ý¿âÒýÇ涼Ҫ²éÕÒ¹¤×÷×éÐÅÏ¢Îļþ£¨Ä¬ÈÏÃû³ÆΪ system.mdw£¬Ò²¿ÉÒÔʹÓÃÀ©Õ¹Ãû .mdw ÈÎÒâÃüÃû£©¡£¹¤×÷×éÐÅÏ¢Îļþ°üº¬×éºÍÓû§ÐÅÏ¢£¨°üÀ¨ÃÜÂ룩£¬ÕâЩÐÅÏ¢¾ö¶¨ÁËË­¿ÉÒÔ´ò¿ªÊý¾Ý¿â£¬ÒÔ¼°ËûÃǶÔÊý¾Ý¿âÖеĶÔÏóµÄȨÏÞ¡£¶Ôµ¥¸ö¶ÔÏóµÄȨÏÞ´æ´¢ÔÚÊý¾Ý¿âÖС£ÕâÑù£¬ÀýÈ磬¾Í¿ÉÒÔ¸³ÓèÒ»¸ö×éµÄÓû§£¨¶ø²»ÊÇÆäËûÓû§£©Ê¹ÓÃÌض¨±íµÄȨÏÞ£¬¶ø¸³ÓèÁíÒ»¸ö×é²é¿´±¨±íµÄȨÏÞ£¬µ«²»ÄÜÐ޸ı¨±íµÄÉè¼Æ¡£

¹¤×÷×éÐÅÏ¢Îļþ°üÀ¨ÄÚÖÃ×飨Admins ºÍ Users£©ÒÔ¼°Ò»¸öͨÓÃÓû§ÕÊ»§ (Admin)£¬¸ÃÕÊ»§¾ßÓйÜÀíÊý¾Ý¿â¼°Æä°üº¬µÄ¶ÔÏóµÄȨÏÞ£¨ÎÞÏÞÖÆ£©¡£ÄúÒ²¿ÉÒÔʹÓò˵¥ÃüÁ¡°¹¤¾ß¡±²Ëµ¥Öеġ°°²È«¡±×Ӳ˵¥£©»òÕßͨ¹ý VBA ´úÂëÌí¼ÓеÄ×éºÍÓû§¡£

×¢Ò⣺°²×° Access ʱ£¬°²×°³ÌÐò»á×Ô¶¯´´½¨¹¤×÷×éÐÅÏ¢Îļþ£¬²¢Ê¹ÓÃÄúÖ¸¶¨µÄÃû³ÆºÍµ¥Î»ÐÅÏ¢À´ÃüÃû¡£ÒòΪÕâÒ»ÐÅϢͨ³£ºÜÈÝÒ×±»ÅжϳöÀ´£¬Òò¶øδ¾­ÊÚȨµÄÓû§ºÜ¿ÉÄܻᴴ½¨ÁíÒ»¸ö°æ±¾µÄ¹¤×÷×éÐÅÏ¢Îļþ£¬´Ó¶øÔÚÓɸù¤×÷×éÐÅÏ¢Îļþ¶¨ÒåµÄ¹¤×÷×éÖУ¬Îª×Ô¼ºÉ趨һ¸ö²»¿É³·ÏûµÄ¹ÜÀíÔ±ÕÊ»§£¨Admins ×éµÄ³ÉÔ±£©È¨ÏÞ¡£Îª·ÀÖ¹·¢ÉúÕâÖÖÇé¿ö£¬Ó¦´´½¨Ò»¸öÐµĹ¤×÷×éÐÅÏ¢Îļþ£¬²¢Ö¸¶¨Î¨Ò»µÄ¹¤×÷×é ID (WID)¡£ÕâÑù£¬Ö»ÓÐÖªµÀ WID µÄÓû§²ÅÄÜ´´½¨¸Ã¹¤×÷×éÐÅÏ¢ÎļþµÄ¸±±¾¡£±¾ÎĺóÃ潫ÌÖÂÛʹÓà User-level Security Wizard ´´½¨ÐµĹ¤×÷×éÐÅÏ¢Îļþ¡£

Admins ×é²»Äܱ»É¾³ý£¬Æä³ÉÔ±¾ßÓв»¿É³·ÏûµÄ¹ÜÀíȨÏÞ¡£Äú¿ÉÒÔͨ¹ý²Ëµ¥»ò´úÂëɾ³ý Admins ×éµÄȨÏÞ£¬µ« Admins ×éµÄÈκγÉÔ±¶¼¿ÉÒÔÖØÐÂÌí¼ÓȨÏÞ¡£´ËÍ⣬Admins ×éÖбØÐëʼÖÕÖÁÉÙÓÐÒ»¸ö¹ÜÀíÊý¾Ý¿âµÄ³ÉÔ±¡£¶ÔÓÚûÓнøÐа²È«ÉèÖõÄÊý¾Ý¿â£¬Admins ×éʼÖÕ°üº¬Ä¬È쵀 Admin Óû§ÕÊ»§£¬ËüÒ²ÊÇËùÓÐÓû§Ä¬ÈϵǼµÄÕÊ»§¡£

ËùÓÐÓû§±ØÐëÊôÓÚĬÈ쵀 Users ×飬²»¹ÜËûÃÇÊÇ·ñ»¹ÊôÓÚÆäËû×é¡£Äú¿ÉÒÔÔÚ VBA Öд´½¨Óû§ÕÊ»§£¬¶ø²¢²»½«ÐµÄÓû§ÕÊ»§Ìí¼Óµ½ Admins ×éÖС£È»¶ø£¬Èç¹û²»Í¬Ê±½«¸ÃÓû§ÕÊ»§Ìí¼Óµ½ Admins ×éÖУ¬¸ÃÓû§½«ÎÞ·¨³É¹¦Æô¶¯ Access£¬ÒòΪ Access ÄÚ²¿Ê¹ÓõÄÓÃÓÚ¹ÜÀíÊý¾Ý¿âµÄºÜ¶à±í¶¼Ó³Éäµ½ Users ×éµÄȨÏÞ¡£

ʹÓÃÒÔϲ½Öè½øÐÐ Access Êý¾Ý¿âµÄ°²È«ÉèÖãº

1.½«ÐÂÓû§ÕÊ»§Ìí¼Óµ½ Admins ×éÖС£¸ÃÓû§¶ÔÊý¾Ý¿âÖеĶÔÏó¾ßÓйÜÀíȨÏÞ¡£

2.´Ó Admins ×éÖÐɾ³ýĬÈ쵀 Admin Óû§ÕÊ»§¡£

3.´Ó Admin Óû§ºÍ Users ×éÖÐɾ³ýȨÏÞ¡£

4.ΪËù´´½¨µÄÈκÎ×Ô¶¨Òå×é·ÖÅäȨÏÞ¡£

ÔÚĬÈÏ Admin Óû§ÕÊ»§ÉÏÉèÖÃÃÜÂë»á¼¤»îµÇ¼¶Ô»°¿ò£¬´Ó¶øÿ´ÎÆô¶¯ Access ʱ¶¼»áÌáʾÓû§ÊäÈëÓû§ÃûºÍÃÜÂë¡£Èç¹ûÄúûÓÐÔÚ Admin ÕÊ»§ÉÏÉèÖÃÃÜÂ룬Óû§½«×Ô¶¯×÷Ϊ Admin Óû§µÇ¼£¬ÎÞÐèÃÜÂ룬Ҳ²»»á³öÏֵǼ¶Ô»°¿ò¡£

¶ÔÊý¾Ý¿âÖжÔÏóµÄȨÏÞ¿ÉÒÔÊÇÏÔʽµÄ£¨Ö±½Ó·ÖÅä¸øÓû§ÕÊ»§£©»òÒþʽµÄ£¨´ÓÓû§ËùÊôµÄ×é¼Ì³Ð£©£¬Ò²¿ÉÒÔÊÇÁ½ÕߵĽáºÏ¡£Access ÔÚȨÏÞÎÊÌâÉÏʹÓá°×îÉÙÏÞÖÆ¡±¹æÔò£¬¼´Óû§µÄȨÏÞ°üÀ¨ÆäÏÔʽºÍÒþʽȨÏÞµÄ×ܺ͡£ÀýÈ磬Èç¹ûÓû§ A µÄÕÊ»§¾ßÓÐÏÞÖÆȨÏÞ£¬¶øÓû§ A ÊôÓÚÒ»¸ö¾ßÓÐÏÞÖÆȨÏÞµÄ×飬ͬʱҲÊôÓÚÁíÒ»¸ö¾ßÓйÜÀí£¨ËùÓУ©È¨ÏÞµÄ×飬ÄÇôÓû§ A ½«¾ßÓйÜÀíȨÏÞ¡£ÓмøÓÚ´Ë£¬Í¨³£×îºÃ²»ÒªÎªÓû§ÕÊ»§·ÖÅäÏÔʽȨÏÞ¡£¶øÓ¦´´½¨¾ßÓв»Í¬È¨ÏÞµÄ×飬Ȼºó½«Óû§·ÖÅä¸ø¾ßÓÐÊʵ±È¨ÏÞµÄ×飬Õâ»á¼õÉÙÊý¾Ý¿â¹ÜÀí·½ÃæµÄÂé·³¡£

ÔÚÒÔϸ÷½ÚÖУ¬ÎÒÃǽ«Õ¹Ê¾ÈçºÎͨ¹ýÓû§½çÃæºÍ±à³ÌÊÖ¶ÎÀ´±£»¤Êý¾Ý¿â¼°Æä°üº¬µÄ¶ÔÏó¡£Ê×ÏÈ£¬ÎÒÃÇÀ´¿´¿´¼¸ÖÖÉèÖÃÊý¾Ý¿âÃÜÂëµÄ²»Í¬·½·¨¡£

ÊÖ¶¯ÉèÖÃÊý¾Ý¿âÃÜÂë

Äú¿ÉÒÔΪÊý¾Ý¿âÉèÖÃÃÜÂ룬´Ó¶øÒªÇóÓû§ÔÚ·ÃÎÊÊý¾Ý¿âʱÊäÈëÃÜÂ롣Ȼ¶ø£¬Ò»µ©Óû§µÇ¼ºó£¬±ã¿ÉÒÔ²»ÊÜÏÞÖƵطÃÎÊÊý¾Ý¿âÖеÄÊý¾ÝºÍ¶ÔÏó¡£

×¢Ò⣺ÔÚÉèÖÃÊý¾Ý¿âÃÜÂë֮ǰ£¬½¨Ò鱸·ÝÊý¾Ý¿â²¢½«Æä´æ´¢ÔÚÒ»¸ö°²È«µÄλÖá£

ÔÚÉèÖÃÊý¾Ý¿âÃÜÂë֮ǰ£¬ÐèÒªÒÔ¶ÀÕ¼·½Ê½´ò¿ªÊý¾Ý¿â¡£ÒªÒÔ¶ÀÕ¼·½Ê½´ò¿ªÊý¾Ý¿â£º

1.Èç¹ûÊý¾Ý¿â´¦ÓÚ´ò¿ª×´Ì¬£¬¹Ø±ÕÊý¾Ý¿â¡£

2.µ¥»÷¡°Îļþ¡±²Ëµ¥Öеġ°´ò¿ª¡±ÖØдò¿ªÊý¾Ý¿â¡£

3.ÔÚ¡°´ò¿ª¡±¶Ô»°¿òÖУ¬ÕÒµ½Êý¾Ý¿â£¬µ¥»÷¡°´ò¿ª¡±°´Å¥ÅԱߵļýÍ·£¬È»ºóµ¥»÷¡°ÒÔ¶ÀÕ¼·½Ê½´ò¿ª¡±¡£

ÒªÊÖ¶¯ÉèÖÃÊý¾Ý¿âÃÜÂ룺

1.ÔÚ¡°¹¤¾ß¡±²Ëµ¥ÖУ¬Ö¸Ïò¡°°²È«¡±£¬È»ºóµ¥»÷¡°ÉèÖÃÊý¾Ý¿âÃÜÂ롱¡£

2.ÔÚ¡°ÃÜÂ롱¿òÖУ¬¼üÈëÃÜÂë¡£

×¢Ò⣺ÃÜÂëÇø·Ö´óСд¡£

3.ÔÚ¡°ÑéÖ¤¡±¿òÖУ¬ÖØмüÈëÃÜÂëÒÔÈ·ÈÏ£¬È»ºóµ¥»÷¡°È·¶¨¡±¡£

ÏÖÔÚ¾ÍÉèÖÃÁËÊý¾Ý¿âÃÜÂ롣ϴÎÄú»òÆäËûÓû§´ò¿ªÊý¾Ý¿âʱ£¬»á³öÏÖÒ»¸ö¶Ô»°¿òÒªÇóÊäÈëÃÜÂë¡£ÏÂÃæÎÒÃÇÀ´¿´¿´ÈçºÎͨ¹ý±à³ÌÉèÖÃÊý¾Ý¿âÃÜÂë¡£

Ï׸øËùÓеĿª·¢Õߣ¬Ì¸Ì¸ÈçºÎ¡°Èý²½×ß¡±³ÉΪһ¸öºÃµÄ³ÌÐòÔ±£º1£© ÒÔÒ»ÖÖÓÐЧµÄ·½Ê½Ñ§Ï°Ò»ÖÖ±à³ÌÓïÑÔ¡£2£© ¿ìËÙÓÐЧµÄµ÷ÊÔÄãµÄ´úÂë¡£3£© ʱ¿Ì²»µ«Ñ§Ï°µÄÐÄ̬£¬±£³Ö֪ʶµÄ¸üС£

ÏÂÃæÎÒ¾ßÌåµÄ½²Ò»½²£º

µÚÒ»²½£º ÒÔÒ»ÖÖÓÐЧµÄ·½Ê½Ñ§Ï°Ò»ÖÖ±à³ÌÓïÑÔ
ÏÂÃæÎÒÒª½²µÄÊÇÒ»ÖÖרҵÓÐЧµÄ·½·¨À´Ï°µÃÈκÎÒ»ÃÅÓïÑÔ¡£Ã¿¸öÓïÑÔ¶¼ÓÐһЩÏàͨµÄµØ·½¡£Èç¹ûÎÒÃÇÄܹ»ÕÆÎÕÕâЩ¹²ÓеĶ«Î÷£¬ÄÇôÎÒÃǾÍÄܲ»·ÑÁ¦µÄѧϰÈκÎÆäËüµÄÓïÑÔ¡£

ÏÂÃæÊÇÈκÎÒ»ÃÅÓïÑÔ¹²ÓеĶ«Î÷.
%26#61607; ÓïÑÔµÄÀúÊ·
%26#61607; ¼ò½é
%26#61607; Ä¿µÄ
%26#61607; ÌØÕ÷
%26#61607; Óŵã
%26#61607; ȱÏÝ
%26#61607; ±äÁ¿£¬¹Ø¼ü×Ö
%26#61607; ÊäÈë/Êä³öÉùÃ÷
%26#61607; »ù±¾Óï·¨
%26#61607; Ìõ¼þÓï¾ä£¬Èçif-else, while, forµÈµÈ
%26#61607; ´æ´¢Êý¾ÝµÄÊý×é
%26#61607; º¯Êý £¨¿âº¯Êý%26amp;Óû§×Ô¶¨Ò庯Êý£©
%26#61607; Îļþ²Ù×÷£¨ÊäÈë/Êä³ö£©
%26#61607; Èç¹ûÕâÃÅÓïÑÔÊÇÃæÏò¶ÔÏóµÄ£¬ÄÇôÄ㻹µÃѧϰһЩÏàͨµÄ¸ÅÄ±ÈÈç˵ÊÇÀ࣬¶ÔÏ󣬼̳У¬¶à̬£¬³éÏóµÈµÈ
Èç¹ûÄã°´ÕâÖÖ˳ÐòÀ´Ñ§Ï°£¬ÈκÎÒ»ÃÅÓïÑԾͻá¾õµÃѧÆðÀ´ºÜÇáËÉ¡£Äã¿ÉÒÔÄÃÈκÎÒ»ÖÖÓïÑÔ¿´ÎÒ˵µÄ¶Ô²»¶Ô£¬Æäʵ£¬Õâ¾ÍÊÇËùÓÐÓïÑÔËù¹²ÓеĶ«Î÷¡£
µÚ¶þ²½£º ³ÌÐòÔ±Ó¦¸ÃÄÜ¿ìËÙÓÐЧµÄµ÷ÊÔÄãµÄ´úÂë

±à³ÌÖÐ×îÓÐȤµÄ¾ÍÊǵ÷ÊÔÁË
ÎÒ˵µ÷ÊÔÓÐȤ£¬ÊÇÒòΪµ÷ÊԵĹý³ÌÖгäÂúÁËδ֪£¬ÉñÃØ¡£ÄãÒÔΪËü»á°´ÕÕÄãËùÔ¤Áϵķ½Ê½ÔËÐУ¬µ«ÊÇ£¬½á¹ûÈ´²»ÊÇÄãÏëÏñµÄÄÇÑù¡£µ÷ÊÔ²¢²»ÊÇÒ»¸ö¼òµ¥µÄ¹ý³Ì¡ª¡ªµ÷ÊÔÐèÒª´´ÔìÐÔºÍÁé»îÐÔ¡£

µ÷ÊÔÖеÄÒ»¸ö¹Ø¼ü¼¼Êõ¾ÍÊÇÓ÷ÖÖ稣¨Divide and Conquer£©¼¼Êõ£¬À´½â¾öÄãµÄÎÊÌâ¡£
¾Ù¸öÀý×Ó£¬¼ÙÉèÄãÒª±àÖÆÒ»¸ö³ÌÐò£¬°Ñ10¼þÊÂÇéÅÅÐò¡£µ±ÄãÔËÐк󣬽á¹û´íÎó³öÏÖÁË¡£µ±Äã¹Û²ìÊä³öµÄʱºò£¬Äã»á·¢ÏÖÇ°ÃæµÄ7¼þÊÂÇé³ÌÐòµÄÅÅÐò¡£ºóÃæµÄÈý¼þÊÇÔÚ²¢Ã»ÓÐÊä³ö£¬Õâʱ£¬ÄãµÄÎÊÌâ¾ÍºÜСÁË£ºÄã¾Í¼¯ÖÐÔÚºóÃæµÄÈý¼þÊÂÇ飨#8, #9, »òÕß #10£©ÉÏÁË¡£

»ýÀÛ±à³ÌµÄ¾­ÑéÓÐÖúÓÚÔö¼ÓÄãµÄµ÷ÊÔÄÜÁ¦¡£°´ÕÕһϲ½ÖèÓÐÖúÓÚÄãµÄ±à³Ì
1) ÇåÎúµÄÎĵµÊ±ËµÃ÷
2) ×ñÕÕÈí¼þ¹¤³ÌÔ­ÀíʵʩÏîÄ¿
3) Á˽â²âÊÔµÄ֪ʶ£¬È磺ºÚºÐ²âÊÔ£¬°×ºÐ²âÊÔ£¬µ¥Ôª²âÊÔ£¬ÕûºÏ²âÊÔ£¬ÐÔÄܲâÊԵȵÈ
4£©ÀûÓÃ×Ô¼ºµÄ¾­Ñéµ÷ÊÔÄãµÄ´úÂ룬Èç¸ù¾Ý´íÎóÐÅÏ¢¼ì²éÄãµÄ´úÂ룻·ÖÖμ¼Êõ£¨Ò»¸ö¹æÄ£NµÄÎÊÌ⣬·Ö½âΪK¸ö¹æģСµÄÎÊÌ⣩µÈµÈ¡£

µÚÈý²½£º ʱ¿Ì²»µ«Ñ§Ï°µÄÐÄ̬£¬±£³Ö֪ʶµÄ¸üÐÂ
ITÐÐÒµÕýÔÚÈÕÐÂÔÂÒìµÄÇ°½ø×Å£¬ÎÒÃÇÓ¦¸ÃѧϰһЩеļ¼Êõ£¬·ñÔòÎÒÃǾͻᱻԶԶµÄ˦ÔÚºóÃæ¡£
Òò´ËÎÒÃÇÒª±£³ÖÓëһЩеļ¼ÊõºÍÈí¼þÉè¼Æ˼Ïëͬ²½¡£Èç
1£©Éý¼¶ÄãµÄ°æ±¾£¬¸üеÄƽ̨
2£©Á˽âм¼ÊõÇ÷ÊÆ
3£©¹Ø×¢Óû§¹Ø×¢µÄ¶«Î÷
4£©ä¯ÀÀ¼¼ÊõÍøÕ¾£¬²©¿Í£¬²Î¼û»áÒéÌÖÂ۵ȵÈ
°´ÕÕÒÔÉÏÏêϸµÄÁ÷³ÌѧϰÈκÎÒ»ÃÅеÄÓïÑÔ¡£
×ñ´ÓÒ»¸öÓÅÐãµÄ±à³Ì¼¼Êõ£¬±à³Ì·½·¨Èç¶àдÎĵµËµÃ÷£¬ºÃµÄÂß¼­Ëã·¨µÈµÈ
ѧϰÔõÑùµ÷ÊÔ³ÌÐòºÍ¾­µäµÄµ÷ÊÔ¼¼Êõ£¬Èç·ÖÖμ¼Êõ£¨Ò»¸ö¹æÄ£NµÄÎÊÌ⣬·Ö½âΪK¸ö¹æģСµÄÎÊÌ⣩ºÍÆäËû¼¼Êõ
Óëеļ¼Êõ±£³Öͬ²½

SQLDMO(SQL Distributed Management Objects£¬SQL·Ö²¼Ê½¹ÜÀí¶ÔÏó)·â×°ÁËMicrosoft SQL ServerÊý¾Ý¿âÖеĶÔÏó¡£SQLDMOÊÇMicrosoft SQL ServerÖÐÆóÒµ¹ÜÀíÆ÷ËùʹÓõÄÓ¦ÓóÌÐò½Ó¿Ú£¬ËùÒÔËü¿ÉÒÔÖ´Ðкܶ๦ÄÜ£¬ÆäÖе±È»Ò²°üÀ¨¶ÔÊý¾Ý¿âµÄ±¸·ÝºÍ»Ö¸´¡£
SQLDMOÓÉMicrosoft SQL Server×Ô´øµÄSQLDMO.dllÌṩ£¬ÓÉÓÚSQLDMO.dllÊÇÒ»¸öCOM¶ÔÏó£¬ËùÒÔ´ó¼ÒÔÚÓÃ֮ǰ±ØÐëÔÚ.NETÏîÄ¿ÖÐÌí¼Ó¶ÔËüµÄÒýÓã¬ÈçÏÂͼËùʾ£º

ÏÂÃæÊÇÓÃC#ÓïÑÔÊéдµÄÓÃÓÚMicrosoft SQL ServerÊý¾Ý¿â±¸·ÝºÍ»Ö¸´µÄÀࣺ

using System;

namespace DbService
{
/// %26lt;summary%26gt;
/// DbOperÀà,Ö÷ÒªÓ¦ÓÃSQLDMOʵÏÖ¶ÔMicrosoft SQL ServerÊý¾Ý¿âµÄ±¸·ÝºÍ»Ö¸´
/// %26lt;/summary%26gt;
public sealed class DbOper
{
/// %26lt;summary%26gt;
/// DbOperÀàµÄ¹¹Ô캯Êý
/// %26lt;/summary%26gt;
private DbOper()
{
}

/// %26lt;summary%26gt;
/// Êý¾Ý¿â±¸·Ý
/// %26lt;/summary%26gt;
public static void DbBackup()
{
SQLDMO.Backup oBackup = new SQLDMO.BackupClass();
SQLDMO.SQLServer oSQLServer = new SQLDMO.SQLServerClass();
try
{
oSQLServer.LoginSecure = false;
oSQLServer.Connect(%26quot;localhost%26quot;, %26quot;sa%26quot;, %26quot;1234%26quot;);
oBackup.Action = SQLDMO.SQLDMO_BACKUP_TYPE.SQLDMOBackup_Database;
oBackup.Database = %26quot;Northwind%26quot;;
oBackup.Files = @%26quot;d:\Northwind.bak%26quot;;
oBackup.BackupSetName = %26quot;Northwind%26quot;;
oBackup.BackupSetDescription = %26quot;Êý¾Ý¿â±¸·Ý%26quot;;
oBackup.Initialize = true;
oBackup.SQLBackup(oSQLServer);
}
catch
{
throw;
}
finally
{
oSQLServer.DisConnect();
}
}

/// %26lt;summary%26gt;
/// Êý¾Ý¿â»Ö¸´
/// %26lt;/summary%26gt;
public static void DbRestore()
{
SQLDMO.Restore oRestore = new SQLDMO.RestoreClass();
SQLDMO.SQLServer oSQLServer = new SQLDMO.SQLServerClass();
try
{
oSQLServer.LoginSecure = false;
oSQLServer.Connect(%26quot;localhost%26quot;, %26quot;sa%26quot;, %26quot;1234%26quot;);
oRestore.Action = SQLDMO.SQLDMO_RESTORE_TYPE.SQLDMORestore_Database;
oRestore.Database = %26quot;Northwind%26quot;;
oRestore.Files = @%26quot;d:\Northwind.bak%26quot;;
oRestore.FileNumber = 1;
oRestore.ReplaceDatabase = true;
oRestore.SQLRestore(oSQLServer);
}
catch
{
throw;
}
finally
{
oSQLServer.DisConnect();
}
}
}
}

Õâ¶Î´úÂëËäÈ»ºÜ¶Ì£¬µ«ÊÇÈ´ºÜʵÓã¬Ï£ÍûÄܹ»¶Ô´ó¼ÒÓÐËù°ïÖú:)

ÓÐÁËÔÚwordÎĵµÖбà³ÌʵÏÖËÑË÷Îı¾µÄ¾­Ñ飬ÔÚexcelÖÐʵÏÖÕâ¸ö¹¦ÄÜÒ²²¢·ÇÄÑÊ¡£

¡¡¡¡´ò¿ªExcelµÄVBA°ïÖú£¬²é¿´ExcelµÄ¶ÔÏóÄ£ÐÍ£¬ºÜÈÝÒ×ÕÒµ½Íê³ÉÕâ¸ö¹¦ÄÜÐèÒªµÄ¼¸¸ö¼¯ºÏºÍ¶ÔÏó£ºApplication¡¢Workbooks¡¢Workbook¡¢Worksheets»¹ÓÐWorksheetºÍRange¡£Application´´½¨ExcelÓ¦Óã¬Workbooks´ò¿ªExcelÎĵµ£¬Workbook»ñµÃExcelÎĵµ¹¤×÷±¡£¬Worksheets²Ù×÷¹¤×÷±í¼¯ºÏ£¬Worksheet»ñµÃµ¥¸ö¹¤×÷±í¡£

¡¡¡¡ËÑË÷µÄ˼·¶ÔÓ¦ÉÏÊö¼¯ºÏºÍ¶ÔÏ󣬿ÉÒÔÕâÑù±íÊö£ºÒªËÑË÷µÄÎı¾¿ÉÄÜ´æÔÚExcelÎĵµµ±ÖеÄij¸ö¹¤×÷±íÉÏ£¬ËÑË÷Ó¦¸Ã±éÀúÄ¿±êExcelÎļþµÄÿ¸ö¹¤×÷±íÖеÄÓÐЧÇøÓò£¬Èç¹ûÕÒµ½£¬ÔòÍ˳ö±¾´ÎËÑË÷£¬Èç¹ûûÓÐÕÒµ½£¬Ôò¼ÌÐøËÑË÷Ö±µ½Íê³É±¾´ÎËÑË÷¡£

¡¡¡¡¸úWord¶ÔÏóÄ£ÐͲ»Ò»ÑùµÄÊÇ£¬Excel¶ÔÏóÄ£ÐÍûÓÐÌṩFind¶ÔÏ󣬲»¹ýûÓйØϵ£¬¿ÉÒÔͨ¹ýÁ½ÖÖ·½·¨À´ÊµÏÖ£¬Ò»¸öÊÇͨ¹ýRange¶ÔÏóµÄFind()·½·¨À´ÊµÏÖ£¬ÁíÍâÒ»¸ö±È½ÏÂé·³£¬È¡µÃ¹¤×÷±íWorksheetµÄÓÐЧÇøÓòUsedRangeÖ®ºó£¬±éÀú¸ÃRange¶ÔÏóÖеÄËùÓÐÐÐÁС£Êµ¼Ê¿ª·¢ÖУ¬ÓõڶþÖÖ·½·¨Ê±·¢ÏÖÁËÒ»¸öÌرðµÄÏÖÏó£¬ËùÒÔµÚ¶þÖÖ·½·¨Ò²×¼±¸Ïêϸ¼ÇÊöһϡ£

¡¡¡¡µÚÒ»²½£¬´ò¿ªExcelÎĵµ£º

using System;
using System.Collections.Generic;
using System.Text;
using System.Diagnostics;

namespace Log
{
class LogWirter
{
/// %26lt;summary%26gt;
/// ʼþÔ´Ãû³Æ
/// %26lt;/summary%26gt;
private string eventSourceName;
EventLogEntryType eventLogType;
public LogWirter()
{
eventSourceName = %26quot;test%26quot;;
eventLogType = EventLogEntryType.Error;
}

/// %26lt;summary%26gt;
/// ÏûϢʼþÔ´Ãû³Æ
/// %26lt;/summary%26gt;
public string EventSourceName
{
set { eventSourceName = value; }
}

/// %26lt;summary%26gt;
/// ÏûϢʼþÀàÐÍ
/// %26lt;/summary%26gt;
public EventLogEntryType EventLogType
{
set { eventLogType = value; }
}

/// %26lt;summary%26gt;
/// дÈëϵͳÈÕÖ¾
/// %26lt;/summary%26gt;
/// %26lt;param name=%26quot;message%26quot;%26gt;ʼþÄÚÈÝ%26lt;/param%26gt;
public void LogEvent(string message)
{
if (!EventLog.SourceExists(eventSourceName))
{
EventLog.CreateEventSource(eventSourceName, %26quot;Application%26quot;);
}
EventLog.WriteEntry(eventSourceName, message, EventLogEntryType.Error);
}
}
}

ʲô³¡ºÏÒªÓÃusestrict
µ±ÄãµÄ³ÌÐòÓÐÒ»¶¨µÄÐÐÊýʱ£¬ÓÈÆäÊÇÔÚÒ»Ò³·Å²»ÏÂʱ£¬»òÕßÊÇÄãÕÒ²»µ½·¢Éú´íÎóµÄÔ­Òòʱ¡£

ΪʲôҪÓÃusestrict£¿
ÖÚ¶àµÄÔ­ÒòÖ®Ò»ÊÇ°ïÄãÑ°ÕÒÒòΪ´íÎóƴдÔì³ÉµÄ´íÎó¡£±ÈÈç´íÎóʹÓÃÁË'$recieve_date'±äÁ¿£¬µ«Êµ¼ÊÉÏÄãÔÚ³ÌÐòÖÐÒÑÉùÃ÷µÄÊÇ'$receive_date'±äÁ¿£¬Õâ¸ö´íÎó¾ÍºÜÄÑ·¢ÏÖ¡£Í¬Ñù£¬usestrictÆÈʹÄã°Ñ±äÁ¿µÄ·¶Î§Ëõµ½×îС£¬Ê¹Äã²»±Øµ£ÐÄͬÃû±äÁ¿ÔÚ³ÌÐòµÄÆäËü²¿·Ý·¢Éú²»Á¼×÷Óᣣ¨¾¡¹ÜÕâÊÇmyµÄ¹¦ÄÜ£¬µ«ÊÇÈç¹ûÄãʹÓÃusestrictµÄ»°£¬Ëü»áÇ¿ÆÈÄãÓÃmyÉùÃ÷±äÁ¿£¬À´´ïµ½ÉÏÊöÄ¿µÄ£©¡£ÓÃusestrictÂé·³Â𣿲»Âé·³£¬Ö»ÒªÔÚÄãµÄ½Å±¾µÄ¿ªÊ¼¼ÓÉÏ11¸ö×Ö·û¶øÒÑ£¡(usestrict;),ÁíÍâÔÚÕû¸ö³ÌÐòÖÐÓÃmyÉùÃ÷±äÁ¿¡£²»´í£¬ÄÇÎÒÔõôÓÃusestrictÄØ£¿ÔÚÄãµÄ½Å±¾µÄ¿ªÍ·'#!/usr/local/bin/perl'ºóÃæ¼ÓÉÏÕâ¾ä¾ÍÐС£

usestrict;
µÃ£¬³ÌÐò³ö´íÁË£¬ÎÒ¸ÃÔõô°ì£¿³£¼ûµÄ´íÎóÐÅÏ¢Ò»°ãÈçÏ£º
Globalsymbol%26quot;$xxx%26quot;requiresexplicitpackagenameat./tstline5.
ÕâÊÇÎÒÃÇÒªÂíÉϽâ¾öµÄ´íÎó¡££¨Èç¹û³öÏÖÀàËÆÓÚ'ServerError'Ö®ÀàµÄ´íÎó£¬Çë¼ì²éÒ»ÏÂÄãµÄweb·þÎñÆ÷ÉϵÄerrorlogs£¬»òÓÃ%26quot;CGI::Carp%26quot;°ü¡££©ÈκÎʱºò£¬µ±ÄãÒªÉùÃ÷Ò»¸ö±äÁ¿Ê±£¬¶¼Òª°Ñ'my'·ÅÔÚÇ°Ãæ¡£ÀýÈ磺
#°ÑÕâ¶Î´úÂë:$string=%26quot;helloworld%26quot;;@array=qw(ABCDEF);hash=(A=%26gt;1,B=%26gt;2);#¸Ä³É:my$string=%26quot;helloworld%26quot;;my@array=qw(ABCDEF);myhash=(A=%26gt;1,B=%26gt;2);#°ÑÕâ¶Î´úÂë:#'$name'isglobalhereforeach$name(@names){print%26quot;Name:$namen%26quot;;}#¸Ä³É:foreachmy$name(@names){#Now'$name'onlyexistsinthisblockprint%26quot;Name:$namen%26quot;;}#°ÑÕâ¶Î´úÂë:#ͬÑù,'$digit'ÔÚÕâÀïÊÇÈ«¾Ö±äÁ¿foreach$digit(@digits){$number=10*$number $digit;}print%26quot;Number:$numbern%26quot;;#¸Ä³É£º(Íâ²ãµÄ±äÁ¿('$number')#½«ÔÚÍâ²ãÉùÃ÷):my$number=0;foreachmy$digit(@digits)#ÏÖÔÚ'$digit'½ö½öÔÚÕâ¸ö´úÂë¿éÀï´æÔÚ$number=10*$number $digit;}print%26quot;Number:$numbern%26quot;;#°ÑÕâ¶Î´úÂë:submy_sub{($arg1,$arg2)=@_;print%26quot;Arg1:$arg1Arg2:$arg2n%26quot;;}#¸Ä³É:submy_sub{my($arg1,$arg2)=@_;print%26quot;Arg1:$arg1Arg2:$arg2n%26quot;;}#ÏÂÃæµÄ´úÂëºÃÏñÔÚÓÃDBIÂһÑùÒª¸Ä£¡:$sth-%26gt;bind_columns($field1,$field2);while($sth-%26gt;fetch){print%26quot;F1:$field1F2:$field2n%26quot;;}#¸Ä³É:$sth-%26gt;bind_columns(my($field1,$field2));while($sth-%26gt;fetch){print%26quot;F1:$field1F2:$field2n%26quot;;}
ÕâҲ̫Âé·³ÁË°É¡£ÀÁ¶è²»ÊÇPerlÎÄ»¯ÖеÄÃÀµÂÂ𣿵±È»£¬ÀÁ¶èÊÇÎÒÃǵÄÃÀµÂ¡£ÒòΪÄã»á·¢ÏÖʹÓÃusestrictÖ®ºó£¬ÎÒÃǾͲ»±Ø»¨Ì«¶àµÄʱ¼ä×Ô¼ºÈ¥²éÕÒusestrict¿ÉÒÔÕÒµ½µÄºÜ¶à¼òµ¥´íÎó¡£ÄÇwarningsÓÖÊÇʲô£¿Å¶£¬¶ÔÁË¡£ÔÚPerl5.6¼°ÒÔºóµÄ°æ±¾ÀÎÒÃÇ¿ÉÒÔÔÚд'usestrict;'µÄλÖÃÅÔд'usewarnings;':
usewarnings;
ÔÚPerl5.6°æ֮ǰ£¨»òÕßΪÁ˲»Í¬Perl°æ±¾¼äµÄ¼æÈÝ£©£¬Äã¿ÉÒÔÓÃÃüÁîÐвÎÊý'#!/usr/bin/perl-w'¡£»¹ÓÐÒ»ÖÖ°ì·¨ÊÇÉèÖÃ$^W±äÁ¿£¨²»¹ý£¬Èç¹û$^W²»ÔÚBEGIN{}³ÌÐò¿éÀïµÄ»°£¬¾Íû°ì·¨½ØÈ¡±àÒëʱµÄ´íÎóÌáʾ£¬ËùÒÔÒ»°ãÎÒÃÇÓÃ'-w'£©:
#!/usr/local/bin/perl-w#»òÕß$^W=1;#»òÕßBEGIN{$^W=1}
Èç¹ûÄãÈ·¶¨²»ÓÃwarnings£¬Äã¿ÉÒÔÏÞÖÆËüµÄʹÓ÷¶Î§£¬È磺
#°ÑÕâ¶Î´úÂë:subadd_two_numbers_which_might_be_undef{$_[0] $_[1];}#¸ù¾ÝPerlµÄ°æ±¾²»Í¬¸Ä³ÉÏÂÃæµÄÑù×Ó:#1subadd_two_numbers_which_might_be_undef{#²Î¼û'perldocperllexwarn'#ÒòΪ×îºÃÊÇÖ»ÔÚÄãÏ£ÍûµÄµØ·½½ûÖ¹µôwarningnowarnings%26quot;uninitialized%26quot;;$_[0] $_[1];}#2subadd_two_numbers_which_might_be_undef{local$^W;$_[0] $_[1];}
»òÕߣ¬ÄãÓ¦ÏñÇ°ÃæÀý×ÓÖÐÉùÃ÷'$number'Ò»Ñù³õʼ»¯±äÁ¿¡£
Ä㻹¿ÉÒÔ²ÎÔÄ%26quot;OvidµÄ%26quot;:ÃîÎÄ%26quot;'usestrict'isnotPerl%26quot;¡£%26quot;okay£¬ÏÖÔÚÄãÓ¦¸Ãûʲô½è¿Ú²»ÓÃusestrict»òusewarningsÁË°É£¬ËüʹÎÒÃÇ´ó¼ÒÉú»î¿ÉÒÔÇáËÉһЩ£º£©

ÒýÑÔ

¡¡¡¡ÏÖÔڵĸ÷ÖÖÊý¾Ý¿âÓ¦Óã¬ÓÉÓÚ¼¼Êõ¡¢ÀúÊ·µÈÒòËØ£¬ÍùÍùÔÚÒ»¸ö´óµÄ²¿ÃÅÖв¢´æÓжà¸öÓ¦ÓÃϵͳ¡£ÕâЩӦÓÃϵͳ¿ÉÄÜ·ÖÉ¢ÓÚ²»Í¬µÄÍøÂç½Úµã¡¢»ùÓÚ²»Í¬µÄ²Ù×÷ƽ̨¡¢Ê¹Óò»Í¬µÄÊý¾Ý¿â¹ÜÀíϵͳ£¬ÇÒ¸÷×Óϵͳ·â±ÕÔËÐУ¬×Ô³ÉÒ»Ì壬ÕâÑù¸ø²»Í¬²¿ÃŵÄÐÅÏ¢×ÊÔ´¹²Ïí´øÀ´À§ÄÑ¡£ÈçºÎÔÚ²»¸Ä±äÔ­À´ÏµÍ³µÄÄÚ²¿ÐÅÏ¢µÄÇ°ÌáÏ£¬Íê³É²»Í¬Êý¾Ý¿âϵͳ¼äµÄÊý¾Ý·ÃÎʺͽ»»»ÊÇÖµµÃÑо¿µÄÎÊÌâ¡£

¶àÊý¾Ý¿âϵͳµÄJava½â¾ö·½°¸

¡¡¡¡¶àÊý¾Ý¿âϵͳµÄ¹¹³ÉÓжàÖÖ·½Ê½£¬ÔÚÕâЩ·½Ê½ÖУ¬ÎÒÃÇ¿¼²ìÕâЩ¶àÊý¾Ý¿âµÄ²»Í¬µã£¬ÆäÖ÷Òª±íÏÖÔÚÒÔϼ¸¸ö·½ÃæµÄÒì¹¹£º

(1)Êý¾Ý¿âÂß¼­Êý¾ÝÄ£Ð͵ÄÒì¹¹£ºÓвã´Î¡¢Íø×´¡¢¹Øϵ¡¢¶ÔÏó-¹ØϵºÍ¶ÔÏóÎåÖÖÊý¾Ý¿â¡£

(2)Êý¾Ý¿âÎïÀíÊý¾ÝÄ£Ð͵ÄÒì¹¹£ºÎïÀíÊý¾ÝÄ£ÐÍ·´Ó³Êý¾Ý¿â´æ´¢½á¹¹£¬ÀýÈçÎïÀí¿é¡¢Ö¸Õë¡¢Ë÷ÒýµÈ£¬¼´Ê¹Âß¼­Êý¾ÝÄ£ÐÍÏàͬ£¬Èç¹ØϵÊý¾Ý¿âµÄORACLE¡¢SYBASE¡¢DB2µÈ£¬ÆäÎïÀíÊý¾ÝÄ£ÐÍÒ²´æÔÚ²îÒì¡£

(3)²Ù×÷ϵͳµÄÒì¹¹£ºUNIX¡¢WINDOWSϵÁС¢MacOS¡¢OS/2¡¢DOSµÈ¡£

(4)¼ÆËã»úƽ̨µÄÒì¹¹£º´Ó¾Þ¡¢´ó¡¢ÖС¢Ð¡ÐÍ»úµ½¹¤×÷Õ¾£¬Î¢»úÒÔ¼°ÊÖ³Ö»ú¡£

(5)ÍøÂçµÄÒì¹¹£ºLAN¡¢WAN¡¢ÒÔÌ«×ÜÏ߽ṹÓëÁîÅÆ»·½á¹¹µÈ¡£

¡¡¡¡ÔÚÕâЩÒì¹¹ÖУ¬ÓÐЩÊÇÊý¾Ý¿âÀúÊ·ËùÔì³ÉµÄ£¬Èç²ã´Î¡¢Íø×´ÀàÐ͵ÄÊý¾Ý¿â£»ÓÐЩÊDz»Í¬µÄÊý¾Ý¿â¿ª·¢ÉÌ¿ª·¢µÄ²»Í¬µÄÊý¾Ý¿â¹ÜÀíϵͳÔì³ÉµÄ£»ÓÐЩÊǼÆËã»ú²Ù×÷ϵͳµÄ²»Í¬£»¶øÓÐЩÊÇÍøÂç½á¹¹ºÍ¼ÆËã»úƽ̨µÄÔ­Òò¡£¶ÔÓÚÕâЩ²»Í¬£¬´ÓÄ¿Ç°À´¿´£¬ÎÒÃÇÈÏΪµ±Ç°Ó¦¸Ã×ÅÖؽâ¾öµÄÔÚ¹ØϵģʽϵIJ»Í¬µÄ²Ù×÷ϵͳºÍ²»Í¬Êý¾Ý¿â¹ÜÀíϵͳ¡£

¡¡¡¡ÖÚËùÖÜÖª£¬Java¼¼ÊõÊÇȫеıà³Ì¼¼Êõ£¬Ëü¾ßÓÐƽ̨ÎÞ¹ØÐÔ¡¢ÃæÏò¶ÔÏó¡¢°²È«¡¢¸ßÐÔÄÜ¡¢·Ö²¼Ê½£¬¶àÏ̵߳ÈÌص㣬ʹJava³ÉΪµ±Ç°×îΪÀàÐ͵ıà³ÌÓïÑÔºÍƽ̨¡£¶ÔÓÚ¶àÊý¾Ý¿âϵͳÁªºÏ·ÃÎʺÍÊý¾Ý½»»»£¬Ê¹ÓÃJava¼¼Êõ¿ÉÒÔ½â¾ö²»Í¬µÄ²Ù×÷ϵͳºÍ²»Í¬µÄÊý¾Ý¿â¹ÜÀíϵͳ֮¼äµÄÊý¾Ý´¦Àí¡£

1)ʹÓÃJava Bean¼¼ÊõʵÏÖ¶àÊý¾Ý¿âµÄ·ÃÎÊ

¡¡¡¡Java BeanÊÇÒ»¸öJavaÄ£ÐÍ×é¼þ£¬ËüΪʹÓÃJavaÀàÌṩÁËÒ»ÖÖ±ê×¼µÄ¸ñʽ£¬ÔÚÓû§³ÌÐòºÍ¿ÉÊÓ»¯¹ÜÀí¹¤¾ßÖпÉÒÔ×Ô¶¯»ñµÃÕâÖÖ¾ßÓбê×¼¸ñʽµÄÀàµÄÐÅÏ¢£¬²¢Äܹ»´´½¨ºÍ¹ÜÀíÕâЩÀà¡£

¡¡¡¡»ùÓÚWebµÄ¶àÊý¾Ý¿â·ÃÎÊÊǵç×ÓÉÌÎñºÍµç×ÓÕþÎñѸËÙ·¢Õ¹¶ø³öÏÖµÄÒ»ÖÖ¶àÊý¾Ý¿âÁªºÏÓ¦ÓõÄÐÎʽ¡£ÔÚÊý¾Ý¿âÒì¹¹£¬²Ù×÷ϵͳÒì¹¹µÄÌõ¼þÏ£¬¶ÔÓÚÊý¾ÝÁ¿ºÜ´óµÄÕâÖÖ¶àÊý¾Ý¿âÓ¦ÓÃÎÊÌ⣬ֻÓÐJava ¼¼Êõ²ÅÓÐÄÜÁ¦½â¾ö¡£

¡¡¡¡¶ÔÓÚÔÚWebϵĶàÊý¾Ý¿â·ÃÎÊ£¬JavaµÄм¼ÊõÊÇServlet¡£Java ServletÊÇÔÚ·þÎñÆ÷¶ËÔËÐеÄJava³ÌÐò¡£ÏÖÔÚËæ×ÅServlet API2.3°æµÄÒýÈ룬·þÎñÆ÷µÄServlet½«°ÑJava WebÈí¼þ¿ª·¢´øÏò¸ü¸ßµÄ²ã´Î¡£ServletÌṩÁË¿ì½Ý¡¢Ç¿´ó¡¢Áé»îµÄ¿ª·¢»·¾³¡£¿ª·¢³öÀ´µÄServlet¿ÉÒÔÔÚ·þÎñÆ÷µÄ½ø³Ì¿Õ¼äÀïÔËÐУ¬²¢ÄÜͬʱ´¦Àí¶à¸öÇëÇó¡£µ±È»£¬×îÖµµÃ³ÆµÀµÄÊÇServletµÄƽ̨ÎÞ¹ØÐÔ¡£

¡¡¡¡¶ÔÓÚ»ùÓÚWebµÄ¶àÊý¾Ý¿â·ÃÎÊ£¬Java Bean¼¼Êõ¿ÉÒÔÌṩһ¸ö±È½ÏÇ¿´ó¡¢Áé»îµÄ½â¾ö·½°¸¡£Ê×Ïȹ¹Ôì¶à¸öJava Bean£¬ÔÚÕâЩģÐÍ×é¼þÀÎÒÃÇÒª´¦ÀíÊý¾Ý¿âµÄÁ¬½Ó¡¢¶¨Ò壬²éÕÒ¡¢²åÈ롢ɾ³ý²Ù×÷µÈ·½·¨£¬²¢ÒªÊµÏÖ¶àỊ̈߳¬È»ºó¹¹Ôì±àдµ÷ÓÃJava BeanµÄServlet£¬ÕâÑù¿ÉÒÔʵÏÖ¶Ô¶àÊý¾Ý¿âµÄ·ÃÎÊ¡£Java BeanµÄ½á¹¹ÈçÏ£º

public class DatabaseConnectBean

{

¶¨ÒåÊý¾Ý¿âÁ¬½ÓµÄ³ÉÔ±;

¶¨ÒåÁ¬½ÓµÄ·½·¨{ }

¡­¡­

}

ÔÚServletÖе÷ÓÃJava BeanµÄ¹ý³ÌΪ£º

public class UsedatabaseBean extends HttpServlet

{

¡¡public void doGet(httpServletRequest req,HttpServletResponse resp) 
throws ServletException£¬IOException

¡¡{

¡­¡­

¡¡}
public void doPost(httpServletRequest req,HttpServletResponse resp) 
throws ServletException£¬IOException

{

¡¡¡­¡­

¡¡//´´½¨Java BeanµÄ¶ÔÏó

¡¡DatabaseConnectBean conBean=new DatabaseConnectBean(¡­¡­);

¡¡//ʹÓÃconBean½øÐÐÊý¾Ý¿âµÄ²Ù×÷

¡¡¡­¡­

}

}

´ÓÉÏÊöµÄ¹ý³ÌºÍÓï¾äÎÒÃÇ¿ÉÒÔ·¢ÏÖ£¬Ê¹ÓÃServlet¼¼Êõ¿ÉÒÔ·ÃÎʸ÷ÖÖ²»Í¬ÀàÐ͵ÄÊý¾Ý¿â£¬µ«ÊÇʹÓÃServlet¼¼ÊõϵÄJava Bean¼¼ÊõÒª±£Ö¤Êý¾Ý¿âÊý¾ÝµÄÒ»ÖÂÐÔ£¬Ó¦ÔÚJava BeanÖÐÎÒÃÇ¿ÉÒÔʹÓÃJavaµÄÏ̼߳¼ÊõÖеÄͬ²½µÈ·½·¨À´ÊµÏÖ¶ÔÊý¾Ý¿âµÄÁ¬½Ó¡¢²Ù×÷£¬µ«ÕâÑù½«¼Ó´ó³ÌÐòÔ±µÄ±à³ÌʵÏÖ¡£ËùÒÔʹÓÃServlet¼¼ÊõϵÄJava BeanÄÜͬʱ¶Ô¶à¸öÊý¾Ý¿âʵÌåµÄ·ÃÎÊ£¬µ«ÊµÏÖÆðÀ´²»·½±ã¡£

Doctor: úº ? Because suffer from ovarian cyst,I am, my menstrual quantity is exceedingly so little, but time is very accurate, because this has before me,had taken angelica pill, the Chinese traditio..
http://medicine.gegemeimei.com/Chinese_medicine/t3411

2 %26#23681; got child of my wife and children partly facial god %26#32463; is phlogisticThere is %26#20010; to call armour in the %26#33647; of %26#21307; unripe %26#32473;%26#24320; chloric the %26#33647; that frag..
http://medicine.gegemeimei.com/Drugs/t9296

He lows of kind of medicine that move fat seek advice: ûÍ of ¥Ë of Di of fish hawk of ¢È of ¡¡ of ûÍ of ¥Ë of ¢· of ¢° of ¡¡ of ûÍ of ¥Ë of ú· of ¢· of ¡¡ of ûÍ of ¥Ë of Zhan of ¢Æ of ¡¡ of ûÍ of ¥Ë o..
http://medicine.gegemeimei.com/Drugs/t9336