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

pythonÖÐMySQLdbµÄ¼òµ¥Ê¹ÓÃ

¶ÔÊý¾Ý¿âµÄ²Ù×÷»ù±¾·ÖΪÈý²½£º
 
Á¬½ÓÊý¾Ý¿â
¸ù¾ÝÐèÒªÖ´ÐÐSQLÓï¾ä£¬½ÓÊÜ·µ»ØÖµ
¹Ø±ÕÁ¬½Ó
ÎÒÃÇÕý³£µÄÊý¾Ý¿âÓ¦¸Ã¶¼Àë²»¿ªÕâÈý²½£¬ÏÂÀ´ËµËµÈçºÎʹÓÃpythonÖеÄMySQLdbÄ£¿é½øÐÐÕâЩ²Ù×÷£º
Ê×ÏÈ£¬ÎÒÃÇÐèÒª°ÑMySQLdbÒýÈëµ½³ÌÐòÖÐ
 
import MySQLdb
 
È»ºó¿ªÊ¼Êý¾Ý¿â²Ù×÷
1.Êý¾Ý¿âÁ¬½Ó
conn = MySQLdb.connect(host="localhost", port=3306, user="root", passwd="sa", db="test")
ͨ¹ýconnectº¯ÊýÓëÊý¾Ý¿â½¨Á¢Á¬½Ó£¬·µ»ØÁ¬½Ó¶ÔÏó£¬ÓÃÀ´½øÐÐÊý¾Ý¿âµÄ²Ù×÷
 
host£ºÊý¾Ý¿âÖ÷»úÃû£¬Ä¬ÈÏÊÇlocalhost
port£ºmysql·þÎñÆ÷ʹÓõÄTCP¶Ë¿Ú£¬Ä¬ÈÏÊÇ3306
user£ºÊý¾Ý¿âµÇ¼Óû§Ãû£¬Ä¬ÈÏÊǵ±Ç°Óû§
passwd£ºÊý¾Ý¿âµÇ¼ÃÜÂ룬ĬÈÏΪ¿Õ
db£º½«ÒªÊ¹ÓõÄÊý¾Ý¿âÃû£¬½«¶Ô¸ÄÊý¾Ý¿â½øÐвÙ×÷£¬ÎÞĬÈÏÖµ
 
Õâ¸öÁ¬½Ó¶ÔÏóͨ¹ýÏÂÃæµÄÁ½¸öº¯Êý¶ÔÊÂÎñµÄ²Ù×÷£º
commit() Ìá½»
rollback() »Ø¹ö
 
 
2.Ö´ÐÐsqlºÍ½ÓÊÜ·µ»ØÖµ
cursor=conn.cursor()
n=cursor.execute(sql,param)
Ê×ÏÈ,ÎÒÃÇÓÃʹÓÃÁ¬½Ó¶ÔÏó»ñµÃÒ»¸öcursor¶ÔÏó,½ÓÏÂÀ´,ÎÒÃÇ»áʹÓÃcursorÌṩµÄ·½·¨À´½øÐй¤×÷.ÕâЩ·½·¨°üÀ¨Á½´óÀà:
1.Ö´ÐÐÃüÁî,2.½ÓÊÕ·µ»ØÖµ
cursorÓÃÀ´Ö´ÐÐÃüÁîµÄ·½·¨:
callproc(self, procname, args):ÓÃÀ´Ö´Ðд洢¹ý³Ì,½ÓÊյIJÎÊýΪ´æ´¢¹ý³ÌÃûºÍ²ÎÊýÁбí,·µ»ØÖµÎªÊÜÓ°ÏìµÄÐÐÊý
execute(self, query, args):Ö´Ðе¥ÌõsqlÓï¾ä,½ÓÊյIJÎÊýΪsqlÓï¾ä±¾ÉíºÍʹÓõIJÎÊýÁбí,·µ»ØÖµÎªÊÜÓ°ÏìµÄÐÐÊý
executemany(self, query, args):Ö´Ðе¥ÌôsqlÓï¾ä,µ«ÊÇÖØ¸´Ö´ÐвÎÊýÁбíÀïµÄ²ÎÊý,·µ»ØÖµÎªÊÜÓ°ÏìµÄÐÐÊý
nextset(self):ÒÆ¶¯µ½ÏÂÒ»¸ö½á¹û¼¯
cursorÓÃÀ´½ÓÊÕ·µ»ØÖµµÄ·½·¨:
fetchall(self):½ÓÊÕÈ«²¿µÄ·µ»Ø½á¹ûÐÐ.
fetchmany(self, size=None):½ÓÊÕsizeÌõ·µ»Ø½á¹ûÐÐ.Èç¹ûsizeµÄÖµ´óÓÚ·µ»ØµÄ½á¹ûÐеÄÊýÁ¿,Ôò»á·µ»Ø
cursor.arraysizeÌõÊý¾Ý.
fetchone(self):·µ»ØÒ»Ìõ½á¹ûÐÐ.
scroll(self, value, mode='relative'):ÒÆ¶¯Ö¸Õ뵽ijһÐÐ.Èç¹ûmode='relative',Ôò±íʾ´Óµ±Ç°ËùÔÚÐÐÒÆ¶¯valueÌõ
,Èç¹ûmode='absolute',Ôò±íʾ´Ó½á¹û¼¯µÄµÚÒ»ÐÐÒÆ¶¯valueÌõ.
ÏÂÃæµÄ´úÂëÊÇÒ»¸öÍêÕûµÄÀý×Ó.
#ʹÓÃsqlÓï¾ä,ÕâÀïÒª½ÓÊյIJÎÊý¶¼ÓÃ%sռλ·û.ҪעÒâµÄÊÇ,ÎÞÂÛÄãÒª²åÈëµÄÊý¾ÝÊÇʲôÀàÐÍ,ռλ·ûÓÀÔ¶¶¼ÒªÓÃ%s
sql="insert into cdinfo values(%s,%s,%s,%s,%s)"
#paramÓ¦¸ÃΪtuple»òÕßlist
param=(tit


Ïà¹ØÎĵµ£º

PythonÍøÂç×¥°ü¿â pypcap

Ethereal ×Ô´øÐí¶àЭÒéµÄ decoder,¼òµ¥,Ò×ÓÃ,»ùÓÚwinpcapµÄÒ»¸ö¿ªÔ´µÄÈí¼þ.µ«ÊÇËüµÄ¼Ü¹¹²¢²»Áé»î,ÈçºÎÄãÒª¼ÓÈëÒ»¸ö×Ô¼º¶¨ÒåµÄµÄ½âÂëÆ÷,µÃÈ¥ÐÞ¸Ä EtherealµÄ´úÂë,ÔÙÖØÐ±àÒë,ºÜ·³Ëö.¶ÔÓÚÒ»°ãµÄÃ÷ÎÄ Ð­Òé,ûÓÐʲôÎÊÌâ,µ«ÊǶÔÓÚ¼ÓÃÜЭÒé,±ÈÈçÍøÂçÓÎÏ·,¿Í»§¶Ë³ÌÐòÒ»°ã»áÔÚ¸ÕÁ¬½ÓÉϵÄʱºò,·¢ËÍÒ»¸öËæ»úÃÜÔ¿,¶øºóµÄ±¨Îͼ»áÓÃÕ⸠......

pythonѧϰ±Ê¼Ç——pcap×¥°ü

½ñÌì¿´¿´ÈçºÎÓÃpythonʵÏÖ×¥°ü¡£
    ÒÔǰÎÒÃÇÔøÓùýwinpcapʵÏÖ×¥°ü£¬Æäʵ½ñÌìÎÒÃÇ»¹ÊÇÓÃËü£¬Ö»²»¹ýÊÇËüÔÚpythonϵÄÄ£¿é£¬ÔÚÓÃ֮ǰÎÒÃDZØÐëÏÈÏÂÔØÁ½¸ö¿â£¬pcap¿âºÍdpkt¿â£¬Õâ¸ö¿ÉÒÔÔÚGoogle codeÀïºÜÈÝÒ×ÕÒµ½£¬ÐèҪעÒâµÄÊÇpcapÖ»Ö§³Öµ½python2.5 £¬ËùÒÔÎÒÃÇÒªÓÃ2.5À´±àд¡£
    °²×°ÍêÁ ......

Performance Python Vs Java


£ª javaÇ¿ÖÆÊ¹ÓÃOO½øÐÐÓ¦Óÿª·¢£¬Python¿ÉÒÔÓú¯Êýʽ±à³Ì¡£º¯ÊýʽÓÐʱÏԵ÷dz£¼òµ¥£¬´úÂëÁ¿¾Þ¼õ¡£»ØÏëÆðJava¶¯²»¶¯µÄN²ã¡¢»¹ÓÐÒ»¸ö¸ö¶ÔÏó£¬ÕæµÄÓÐÄÇÖÖÐÄÒªÂ𣿶øÇÒPython±¾ÉíÓïÑÔ·ç¸ñ¾Í¼ò½à£¬ÔÙ¼ÓÉϼò½àµÄº¯Êý£¬ÔÚ¿ª·¢Ð§ÂÊ¡¢Debug¡¢²âÊÔÉÏËÆºõ»áÓÐÓÅÊÆ¡£
£ª ´óÐ͸´ÔÓÏîÄ¿µÄÐÔÄܸü¶àµØÌåÏÖÔڼܹ¹¡¢Ó²¼þÍØÆË½á¹¹Éϵȡ£Ó¦¶Ô ......

Python 3 µÄÐÂÌØÐÔ

Python 3 ÊÇ Guido van Rossum ¹¦ÄÜÇ¿´óµÄͨÓñà³ÌÓïÑÔµÄ×îа汾¡£ËüËäÈ»´òÆÆÁËÓë 2.x °æ±¾µÄÏòºó¼æÈÝÐÔ£¬µ«È´ÇåÀíÁËijЩÓï·¨·½ÃæµÄÎÊÌâ¡£±¾ÎÄÊÇϵÁÐÎÄÕÂÖеĵÚһƪ£¬½éÉÜÁËÓ°Ïì¸ÃÓïÑÔ¼°Ïòºó¼æÈÝÐԵĸ÷Öֱ仯£¬²¢ÇÒ»¹ÌṩÁËÐÂÌØÐԵöÀý×Ó¡£
Python °æ±¾ 3£¬Ò²±»³ÆÎª Python 3000 »ò Py3K£¨·ÂЧ Microsoft® Windows ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ