ÒÔǰһֱ²»ÔÚÒâµÄһЩ֪ʶ:
1.ʹÓÃmysqlÓï¾ä²é¿´±í½á¹¹£º
£¨1£© desc ±íÃû;
£¨2£© show from ±íÃû;
»òÕß show columns from ±íÃû;
2.ÔÚmysql¿ØÖÆÌ¨ÖÐÏÔʾ¡¢Ñ¡ÔñÊý¾Ý¿â
show databases;
use ±íÃû; ......
²âÊÔÍøÕ¾£ºBaiduÖ÷Ò³ÒÔ¼°Ïà¹ØµÄÒ³Ãæ
Ö÷Ì⣺ºÚºÐ²âÊÔ£¬¹¦ÄܲâÊÔ£¬ÐÔÄÜ/ѹÁ¦²âÊÔ£¬°²È«²âÊÔ£¬ Êý¾Ý×Öµä¹ÜÀí
1. ²âÊÔÒ³ÃæÊÇ·ñ¿É·ÃÎʵģ»
1.1 HTTP request status = 200, Ò³ÃæÏÂÔØÕýÈ·
from urllib import urlopen
# set up
url = None
# test
url = urlopen('http://www.baidu.com')
assert url.getcode() == 200
# clean up
del url
1.2 ÏÂÃæ¿¼ÂǸü¶àµÄ²âÊԵ㣬±ÈÈç¸÷ÖÖURL£¬¶Ë¿Ú£¬´úÀí£¬RequestÊý¾ÝÒÔ¼°Cookie.
¸ù¾ÝÍøÒ³µÄÁé»îÐÔ£¬ÎÒÃÇÑ¡Ôñ±È½Ï¼Ç¼Ðεķ½·¨À´ÊµÏÖ²âÊÔ¹¦ÄÜ£¬ÀàËÆLoadRunnerÖ»Êǽű¾ÊÇ×Ô¼ºÊÖд¡£
2. ²âÊÔÒ³ÃæµÄ¹¦ÄÜÊÇ·ñ·ûºÏÒªÇó: ÒԵǽ£¬·¢±íÎÄÕÂΪÀý
3. ²âÊÔÒ³ÃæµÄÐÔÄÜÊÇ·ñ·ûºÏÒªÇó£º
²¢·¢Óû§ÊýÁ¿£¬ÇëÇóÏìӦʱ¼ä£¬ÊÂÎñÇëÇóÏìӦʱ¼ä£¬£¨ÍÌÍÂÂÊ£¬ TPS£¬×ÊÔ´ÀûÓÃÂÊ ÎÞ·¨·ÃÎÊ·þÎñÆ÷)£¬ µã»÷ÂÊ
4. ²âÊÔÒ³ÃæÔÚÓû§²Ù×÷ºÍÍþвÏÂÊÇ·ñ°²È«£º
Cookie¹¥»÷£¬SQL×¢Èë¹¥»÷£¬ä¯ÀÀÆ÷¹¥»÷£¬±©Á¦¹¥»÷£¬ÊäÈë·Ç·¨Êý¾Ý£¬ÉÏ´«·Ç·¨Îļþ£¬Õ¾Íâ½Å±¾¹¥»÷£¬Ä¾Âí¼ì²é ......
Example 2-18 չʾÁË traceback Ä£¿éÔÊÐíÄãÔÚ³ÌÐòÀï´òÓ¡Òì³£µÄ¸ú×Ù·µ»Ø
(Traceback)ÐÅÏ¢, ÀàËÆÎ´²¶»ñÒ쳣ʱ½âÊÍÆ÷Ëù×öµÄ. Èç Example 2-18 Ëùʾ. 2.11.0.1. Example
2-18. ʹÓà traceback Ä£¿é´òÓ¡¸ú×Ù·µ»ØÐÅÏ¢ File: traceback-example-1.py # note!
import
Example 2-18 չʾÁË traceback Ä£¿éÔÊÐíÄãÔÚ³ÌÐòÀï´òÓ¡Òì³£µÄ¸ú×Ù·µ»Ø (Traceback)ÐÅÏ¢, ÀàËÆÎ´²¶»ñÒ쳣ʱ½âÊÍÆ÷Ëù×öµÄ. Èç Example 2-18 Ëùʾ.
2.11.0.1. Example 2-18. ʹÓà traceback Ä£¿é´òÓ¡¸ú×Ù·µ»ØÐÅÏ¢
File: traceback-example-1.py
# note! importing the traceback module messes up the
# exception state, so you better do that here and not
# in the exception handler
# ×¢Òâ! µ¼Èë traceback »áÇåÀíµôÒ쳣״̬, ËùÒÔ
# ×îºÃ±ðÔÚÒì³£´¦Àí´úÂëÖе¼Èë¸ÃÄ£¿é
import traceback
try:
raise SyntaxError, "example"
except:
traceback.print_exc()
Traceback (innermost last):
File "traceback-example-1.py", line 7, in ?
SyntaxError: example
Example 2-19 ʹÓà StringIO Ä£¿é½«¸ú×Ù·µ»ØÐÅÏ¢·ÅÔÚ×Ö·û´®ÖÐ.
2.11.0.2. Example 2-19. ʹÓà traceba ......
½èÖúCinpyºÍCÓïÑÔ½âÊÍÆ÷TinyCC£¬¿ÉÒÔÔÚpython³ÌÐòÀïÃæÖ±½ÓǶÈëCÓïÑÔÆ¬¶Ï¡¢²»¾±àÒëÖ±½ÓʹÓÃC±àдµÄº¯ÊýÁË¡£
win2kƽ̨ÉÏ£¬¼òµ¥µÄ²âÊÔ¶Ô±ÈÊý¾ÝÈçÏ£¨µÝ¹é·½·¨¼ÆËãµÚËÄÊ®ÏîÍÃ×ÓÊýÁÐfib£¨40£©£©
ÓïÑÔ
ʵÏÖ
ʱ¼ä
£¨µ¥Î»£ºÃ룩
ÆÀ
python
¹Ù·½python 2.4.3
´¿python fibº¯Êý
568.718
Ìì°¡
ʹÓÃpsyco¼ÓËÙµÄpython fibº¯Êý
17.922
±È½Ï½Ó½ü£¬»¹ÐÐ
ʹÓÃswigÖ±½Óת»»µÄCÓïÑÔ±àдµÄÄ£¿é
13.453
ʹÓÃCinpyǶÈëfibº¯Êý
11.532
¡¡
¡¡
¡¡
¡¡
¡¡
C
VC6
ËÙ¶ÈÓÅ»¯±àÒëµÄ¿ÉÖ´ÐÐÎļþ
5.562
¡¡
TinyCC 0.9.23
±àÒëµÄ¿ÉÖ´ÐÐÎļþ
6.719
¡¡
½âÊÍÖ´ÐÐ
6.813
¡¡
¡¡
¡¡
¡¡
¡¡
¡¡
FreeBASIC
fbc 0.16b
±àÒëµÄ¿ÉÖ´ÐÐÎļþ£¨-arch 486)
8.022
¡¡
±àÒëµÄ¿ÉÖ´ÐÐÎļþ£¨-arch 686)
7.619
¡¡
¡¡
¡¡
¡¡
¡¡
¡¡
forth
4th 3.5a2
4th cx fib.4th
277
Õâ¸ö±íÏÖ̫ʧÍûÁË
4th csv fib.4th fib.hx
4th lx fib.hx
196
4th lg fib.hx fib.c
mingw -O2 fib.c -o fib.exe
110
gforth-0.6.2
Gforth-fast fib.gfth
14.719
²»´í£¬²»¹ý²»ÊÇ˵ºÍCµÄËÙ¶È¿ÉÒÔ±ÈÂ
ÔõôҲ¾ÍÊÇÓÅ»¯µÄpythonµÄËٶȰ¡
¡¡
×¢£º
ÆäÓàÔ´³ÌÐò
freebasic
function fib(x ......
½èÖúCinpyºÍCÓïÑÔ½âÊÍÆ÷TinyCC£¬¿ÉÒÔÔÚpython³ÌÐòÀïÃæÖ±½ÓǶÈëCÓïÑÔÆ¬¶Ï¡¢²»¾±àÒëÖ±½ÓʹÓÃC±àдµÄº¯ÊýÁË¡£
win2kƽ̨ÉÏ£¬¼òµ¥µÄ²âÊÔ¶Ô±ÈÊý¾ÝÈçÏ£¨µÝ¹é·½·¨¼ÆËãµÚËÄÊ®ÏîÍÃ×ÓÊýÁÐfib£¨40£©£©
ÓïÑÔ
ʵÏÖ
ʱ¼ä
£¨µ¥Î»£ºÃ룩
ÆÀ
python
¹Ù·½python 2.4.3
´¿python fibº¯Êý
568.718
Ìì°¡
ʹÓÃpsyco¼ÓËÙµÄpython fibº¯Êý
17.922
±È½Ï½Ó½ü£¬»¹ÐÐ
ʹÓÃswigÖ±½Óת»»µÄCÓïÑÔ±àдµÄÄ£¿é
13.453
ʹÓÃCinpyǶÈëfibº¯Êý
11.532
¡¡
¡¡
¡¡
¡¡
¡¡
C
VC6
ËÙ¶ÈÓÅ»¯±àÒëµÄ¿ÉÖ´ÐÐÎļþ
5.562
¡¡
TinyCC 0.9.23
±àÒëµÄ¿ÉÖ´ÐÐÎļþ
6.719
¡¡
½âÊÍÖ´ÐÐ
6.813
¡¡
¡¡
¡¡
¡¡
¡¡
¡¡
FreeBASIC
fbc 0.16b
±àÒëµÄ¿ÉÖ´ÐÐÎļþ£¨-arch 486)
8.022
¡¡
±àÒëµÄ¿ÉÖ´ÐÐÎļþ£¨-arch 686)
7.619
¡¡
¡¡
¡¡
¡¡
¡¡
¡¡
forth
4th 3.5a2
4th cx fib.4th
277
Õâ¸ö±íÏÖ̫ʧÍûÁË
4th csv fib.4th fib.hx
4th lx fib.hx
196
4th lg fib.hx fib.c
mingw -O2 fib.c -o fib.exe
110
gforth-0.6.2
Gforth-fast fib.gfth
14.719
²»´í£¬²»¹ý²»ÊÇ˵ºÍCµÄËÙ¶È¿ÉÒÔ±ÈÂ
ÔõôҲ¾ÍÊÇÓÅ»¯µÄpythonµÄËٶȰ¡
¡¡
×¢£º
ÆäÓàÔ´³ÌÐò
freebasic
function fib(x ......
ÏÂÔØÔ´´úÂë
Python¼ò½é
¡¡¡¡PythonÊÇÒ»ÖÖ¼òµ¥Ò×ѧ£¬¹¦ÄÜÇ¿´óµÄ½âÊÍÐͱà³ÌÓïÑÔ£¬ËüÓмò½àÃ÷Á˵ÄÓï·¨£¬¸ßЧÂʵĸ߲ãÊý¾Ý½á¹¹£¬Äܹ»¼òµ¥¶øÓÐЧµØÊµÏÖÃæÏò¶ÔÏó±à³Ì£¬ÌرðÊÊÓÃÓÚ¿ìËÙÓ¦ÓóÌÐò¿ª·¢£¬Ò²¿ÉÒÔÓÃÀ´¿ª·¢´ó¹æÄ£µÄÖØÒªµÄÉÌÒµÓ¦Óá£PythonÊÇÒ»¸öÀíÏëµÄ½Å±¾ÓïÑÔ¡£
¡¡¡¡PythonÃâ·Ñ¿ªÔ´£¬¿ÉÒÆÖ²µ½¶àÖÖ²Ù×÷ϵͳ£¬Ö»Òª±ÜÃâʹÓÃÒÀÀµÓÚÌØ¶¨²Ù×÷ϵͳµÄÌØÐÔ£¬Python³ÌÐòÎÞÐèÐ޸ľͿÉÒÔÔÚ¸÷ÖÖÆ½Ì¨ÉÏÃæÔËÐС£
¡¡¡¡PythonÓµÓÐÏÖ´ú±à³ÌÓïÑÔËù¾ßÓеÄÒ»ÇÐÇ¿´ó¹¦ÄÜ£¬Python±ê×¼¿âÊ®·ÖÅӴ󣬿ÉÒÔ°ïÖú¿ª·¢Õß´¦Àí¸÷ÖÖ¹¤×÷£¬È磺ͼÐÎÓû§½çÃæ¡¢Îļþ´¦Àí¡¢¶àýÌå¡¢ÕýÔò±í´ïʽ¡¢ÎĵµÉú³É¡¢µ¥Ôª²âÊÔ¡¢Ï̡߳¢Êý¾Ý¿â¡¢ÍøÂçͨѶ¡¢ÍøÒ³ä¯ÀÀÆ÷¡¢CGI¡¢FTP¡¢µç×ÓÓʼþ¡¢XML¡¢HTML¡¢WAVÎļþ¡¢ÃÜÂëϵͳ¡¢TkºÍÆäËûÓëϵͳÓйصIJÙ×÷¡£Ö»Òª°²×°ÁËPython£¬ÕâЩ¹¦Äܶ¼ÊÇ¿ÉÓõijýÁ˱ê×¼¿âÒÔÍ⣬»¹ÓÐÐí¶àÆäËû¸ßÖÊÁ¿µÄ¿â£¬ÈçwxPython¡¢TwistedºÍPythonͼÐοâµÈµÈÊý²»Ê¤Êý¡£
¡¡¡¡PythonÈÝÒ×À©Õ¹ºÍǶÈë¡£PythonÌṩµÄÐí¶à±ê׼ģ¿éÖ§³ÖC»òÕßC++½Ó¿Ú¡£PythonºÍC¿ÉÒÔÒ»Æð¹¤×÷£¬Ëü¿ÉÒÔǶÈëµ½C»òÕßC++µÄÓ¦ÓóÌÐòµ±ÖУ¬Òò´Ë¿ÉÓÃPythonÓïÑÔΪӦÓóÌÐòÌṩ½Å±¾½Ó¿Ú£¬ÓÉÓÚÖ§³Ö¿çÓïÑÔ¿ª·¢£¬¿ÉÓÃPythonÉè¼Æ¸ÅÄӦÓóÌÐò£¬²¢Öð ......
±¾ÎĽéÉÜjavascriptÁ¬½ÓaccessÊý¾Ý¿âµÄ·½·¨¡£Õâ¶Î´úÂëÔÚ±¾µØ¿ÉÒÔÕý³£ÔËÐУ¬ÔÚÏßÔòÐèÒª×ã¹»µÄȨÏÞ¡£ÓÉÓÚ²ÉÓÃAccessÊý¾Ý¿â£¬ËùÒÔ²¢²»Ê¹Óñê×¼µÄSQLÓ﷨ʹÓÃʱ¡£ÐèҪעÒâ¡£
Õ⼸Ìì·ÑÁËͦ´óÁ¦ÆøÔÚÍøÉϲéÕÒjavascriptÁ¬½ÓaccessÊý¾Ý¿âµÄ·½·¨£¬¾¹ýÕûÀí×ܽᣬÖÕÓÚд³öÒ»¶ÎÄܹ»ÓÐЧִÐеĴúÂë¡£
µ«ÊÇÕâ¶Î´úÂëÔÚ±¾µØ¿ÉÒÔÕý³£ÔËÐУ¬Ò»µ©·Åµ½Ãâ·Ñ¸öÈ˿ռäÉϾÍû·¨Ö´ÐÐÁË£¬Ö÷ÒªÔÒò¾ÍÊDzÙ×÷ȨÏÞ²»¹»£¬ÓÉÓÚÖ»Ö§³Ö¾²Ì¬Ò³ÃæµÄÃâ·Ñ¿Õ¼ä¶àÊý¶¼
×÷Á˷dz£ÑϸñµÄÏÞÖÆ£¬ËùÒÔÎÞÂÛÊÇÓÃmdbµÄ·½Ê½£¬»¹ÊǶÁд´¿Îı¾ÎļþµÄ·½Ê½¶¼Ã»°ì·¨Í¨¹ý£¬¶øÓÉÒ³Ãæ±¨³öjs´íÎó¡£¹úÍâµÄһЩÃâ·Ñ¿Õ¼ä£¬Ö±½Ó¾Í½ûÖ¹mdbÕâÑùÀ©Õ¹ÃûµÄÎļþÉÏ´«¡£
ËäȻûϣÍûÔÚ´¿¾²Ì¬Ò³ÃæµÄÃâ·Ñ¿Õ¼äÉÏ×÷×Ô¼ºµÄ¼ÆÊýÆ÷»òÊÇÁôÑ԰棬µ«ÊÇÕâ¶Î³ÌÐòÒ²Ðí»¹ÊǶÔһЩÅóÓÑÓÐÓô¦£¬Ð´³öÀ´¹©¸÷λÑо¿Ò»Ï¡£
Îļþ¹¹³É£º
AccessÊý¾Ý¿âÃûΪ MyData.Mdb£¬ ÀïÃæ½¨ÁËÒ»¸öÃûΪcountµÄ±í£¬±íÓÉÁ½¸ö ×Ö¶Î×é³É£º IDºÍCOUNT£¬±íÀïÓÐÒ»ÌõÊý¾Ý£º ('count','100')¡£
Îı¾ÎļþÃûΪ count.txt£¬ÀïÃæËæ±ãдÈëÒ»¸öÊý×Ö¡£
¾²Ì¬Ò³ÃæÃûΪCnt.htm¡£
ÒÔÉÏ3¸öÎļþ¶¼·ÅÔÚͬһĿ¼Ï¡£
ÓÉÓÚ²ÉÓÃAccessÊý¾Ý¿â£¬¶øËü²ÉÓ÷DZê×¼SQLÓï·¨£¬ËùÒÔҪעÒâÔÚ±íÃûºÍ×Ö¶ÎÃûÉÏÐèÒª¼Ó·½À¨º ......
±¾ÎĽéÉÜjavascriptÁ¬½ÓaccessÊý¾Ý¿âµÄ·½·¨¡£Õâ¶Î´úÂëÔÚ±¾µØ¿ÉÒÔÕý³£ÔËÐУ¬ÔÚÏßÔòÐèÒª×ã¹»µÄȨÏÞ¡£ÓÉÓÚ²ÉÓÃAccessÊý¾Ý¿â£¬ËùÒÔ²¢²»Ê¹Óñê×¼µÄSQLÓ﷨ʹÓÃʱ¡£ÐèҪעÒâ¡£
Õ⼸Ìì·ÑÁËͦ´óÁ¦ÆøÔÚÍøÉϲéÕÒjavascriptÁ¬½ÓaccessÊý¾Ý¿âµÄ·½·¨£¬¾¹ýÕûÀí×ܽᣬÖÕÓÚд³öÒ»¶ÎÄܹ»ÓÐЧִÐеĴúÂë¡£
µ«ÊÇÕâ¶Î´úÂëÔÚ±¾µØ¿ÉÒÔÕý³£ÔËÐУ¬Ò»µ©·Åµ½Ãâ·Ñ¸öÈ˿ռäÉϾÍû·¨Ö´ÐÐÁË£¬Ö÷ÒªÔÒò¾ÍÊDzÙ×÷ȨÏÞ²»¹»£¬ÓÉÓÚÖ»Ö§³Ö¾²Ì¬Ò³ÃæµÄÃâ·Ñ¿Õ¼ä¶àÊý¶¼
×÷Á˷dz£ÑϸñµÄÏÞÖÆ£¬ËùÒÔÎÞÂÛÊÇÓÃmdbµÄ·½Ê½£¬»¹ÊǶÁд´¿Îı¾ÎļþµÄ·½Ê½¶¼Ã»°ì·¨Í¨¹ý£¬¶øÓÉÒ³Ãæ±¨³öjs´íÎó¡£¹úÍâµÄһЩÃâ·Ñ¿Õ¼ä£¬Ö±½Ó¾Í½ûÖ¹mdbÕâÑùÀ©Õ¹ÃûµÄÎļþÉÏ´«¡£
ËäȻûϣÍûÔÚ´¿¾²Ì¬Ò³ÃæµÄÃâ·Ñ¿Õ¼äÉÏ×÷×Ô¼ºµÄ¼ÆÊýÆ÷»òÊÇÁôÑ԰棬µ«ÊÇÕâ¶Î³ÌÐòÒ²Ðí»¹ÊǶÔһЩÅóÓÑÓÐÓô¦£¬Ð´³öÀ´¹©¸÷λÑо¿Ò»Ï¡£
Îļþ¹¹³É£º
AccessÊý¾Ý¿âÃûΪ MyData.Mdb£¬ ÀïÃæ½¨ÁËÒ»¸öÃûΪcountµÄ±í£¬±íÓÉÁ½¸ö ×Ö¶Î×é³É£º IDºÍCOUNT£¬±íÀïÓÐÒ»ÌõÊý¾Ý£º ('count','100')¡£
Îı¾ÎļþÃûΪ count.txt£¬ÀïÃæËæ±ãдÈëÒ»¸öÊý×Ö¡£
¾²Ì¬Ò³ÃæÃûΪCnt.htm¡£
ÒÔÉÏ3¸öÎļþ¶¼·ÅÔÚͬһĿ¼Ï¡£
ÓÉÓÚ²ÉÓÃAccessÊý¾Ý¿â£¬¶øËü²ÉÓ÷DZê×¼SQLÓï·¨£¬ËùÒÔҪעÒâÔÚ±íÃûºÍ×Ö¶ÎÃûÉÏÐèÒª¼Ó·½À¨º ......