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

Python MySqlDB Ôöɾ¸ÄÊý¾Ý¿â


ÏÂÔØ°²×°MySQLdb
http://sourceforge.net/projects/mysql-python/ ºÃÏñû¿´µ½windows°æ±¾for python2.6µÄÏÂÔØ£¬ÍøÉÏËÑË÷µ½Ò»¸ö
http://www.technicalbard.com/files/MySQL-python-1.2.2.win32-py2.6.exe
°²×°ºóimport MySQLdb»á³öÏÖ DeprecationWarning: the sets module is deprecated ÕâÑùÒ»¸ö¾¯¸æ£¬googleÖ®
Ô­ÒòÊÇ2.6²»ÖªsetsÕâ¸öÄ£¿é£¬²»¹ýÒѾ­Ìí¼ÓÁËsetÄÚÖú¯Êý¡£ÕÒµ½MySQLdbÎļþ¼ÐµÄÖÐ__init__.py,×¢Ê͵ôfrom sets import ImmutableSet   class DBAPISet(ImmutableSet):Ìí¼Óclass DBAPISet(frozenset):£»ÕÒµ½converters.py×¢Ê͵ôfrom sets import BaseSet, Set¡£È»ºóÐ޸ĵÚ45ÐкÍ129ÐÐÖеÄSetΪset¡£
¸ã¶¨¡£
ÏÂÃæ¿ªÊ¼²Ù×÷µÄdemo:
Python´úÂë
# -*- coding: utf-8 -*-    
#mysqldb   
import time, MySQLdb   
  
#Á¬½Ó   
conn=MySQLdb.connect(host="localhost",user="root",passwd="",db="test",charset="utf8")   
cursor = conn.cursor()   
  
#дÈë   
sql = "insert into user(name,created) values(%s,%s)"  
param = ("aaa",int(time.time()))   
n = cursor.execute(sql,param)   
print n   
  
  
#¸üР  
sql = "update user set name=%s where id=3"  
param = ("bbb")   
n = cursor.execute(sql,param)   
print n   
  
  
#²éѯ   
n = cursor.execute("select * from user")   
for row in cursor.fetchall():   
    for r in row:   
        print r   
  
  
#ɾ³ý   
sql = "delete from user where name=%s"  
param =("aaa")   
n =&nb


Ïà¹ØÎĵµ£º

Python±ê×¼¿â randomÄ£¿é


Python±ê×¼¿â-randomÄ£¿é
random Ä£¿é°üº¬Ðí¶àËæ»úÊýÉú³ÉÆ÷. »ù±¾Ëæ»úÊýÉú³ÉÆ÷(»ùÓÚ Wichmann ºÍ Hill , 1982 µÄÊýѧÔËËãÀíÂÛ) ¿ÉÒÔͨ¹ýºÜ¶à·½·¨·ÃÎÊ, Èç Example 2-29 Ëùʾ. 2.17.0.1. Example 2-29. ʹÓà random Ä£¿é»ñµÃËæ»úÊý×Ö File: random-example-1.py import random for i i
¡¡¡¡
random Ä£¿é°üº¬Ðí¶àËæ»úÊýÉ ......

PythonÖÐRangeºÍXRangeµÄÇø±ð

PythonÖÐRangeºÍXRangeµÄÇø±ð(Difference between Range and XRange in Python)
×î½ü»úÆ÷³öÁ˵ãÎÊÌ⣬ËùÒÔһֱûÓÐдÐµĶ«Î÷³öÀ´¡£Ö®Ç°ÔÚ¶ÁPythonµÄ´úÂëµÄʱºò£¬·¢¾õºÃ¶àÈËϲ»¶ÓÃXRange£¬¶ø²»ÊÇRange£¬ÎÒÒ²Ö»ÊǼǵÃѧϰµÄʱºò¿ªÊ¼Ñ§µ½µÄÊÇRange£¬ºóÃæÓÖ¿´µ½ÓиöXRange£¬µ±Ê±Ò²Ã»ÓÐÉ£¬ÎªÊ²Ã´PythonÀïÃæÒªÓÐÁ½¸öͬÑùµÄ¹¦ ......

ÓÃPythonʵÏÖ¼òµ¥µÄÒÅ´«Ëã·¨

ÓÃPythonʵÏÖ¼òµ¥µÄÒÅ´«Ëã·¨
2010-02-15 14:00
Õ⼸ÌìÒ»Ö±ÔÚÓÃPythonдһ¸ö¼òµ¥µÄÒÅ´«Ëã·¨£¬ºÃ×Ô¼ºÄÃÀ´ÊµÑé¡£¶Ï¶ÏÐøÐøµÄÕÛÌÚÁ˼¸Ì죬½ñÌìÏÂÎçÖÕÓÚдÁËÒ»¸ö¼òµ¥µÄ³öÀ´¡£Õû¸ö´úÂ뻹ÊÇ·ÂÕÕ¡¶ÓÎÏ·±à³ÌÖеÄÈ˹¤ÖÇÄܼ¼Êõ¡·ÖеĴúÂëÀ´Ð´µÄ¡£Èç¹ûÏë¼òµ¥µÄѧϰһÏÂÒÅ´«Ëã·¨ÒÔ¼°¼òµ¥Ó¦Óá¶ÓÎÏ·±à³ÌÖеÄÈ˹¤ÖÇÄܼ¼Êõ¡·ÊDz»´íµÄÑ¡Ôñ¡£ ......

python ³õÌåÑé

windowsÏÂ
1 ÏÂÔØpython°²×°°ü£¬ һ·ÏÂÈ¥°²×°
2 ÏÂÔØmysqldb°²×°
3 ÏÂÔØdjangoÎļþ£¬ dyango-admin.py install Íê³É
£­£­£­£­£­Èç¹ûÆô¶¯ºó±¨´íimport error: dll load failed. ÐèÒªÔÚsite-packageÏÂÔö¼Ódll: libguide40.dll  libmmd.dll  libmySQL.dll
´´½¨Ó¦ÓÃºó£¬ manage.py µÄprogram argumentÖÐÓ¦ ......

[python]ÖØ¶¨ÏòÊä³ö

  µ÷ÓÃÒ»¸ö¿ØÖÆÌ¨³ÌÐò£¬»ñÈ¡ËüµÄ±ê×¼Êä³ö£¬»ò°ÑËüµÄ±ê×¼Êä³öÖØ¶¨Ïòµ½½çÃæÉÏ£¬ÕâÀïÖ»½éÉÜÈçºÎ»ñÈ¡ËüµÄ±ê×¼Êä³ö£¬ÒòΪԭÀí¶¼Ò»ÑùµÄ¡£
ʹÓÃpython2.5µÄsubprocessÄ£¿éÀ´ÊµÏÖ¡£
import sys
import subprocess
def RunShellWithReturnCode(command, print_output=False,
universal_newline ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ