Python and MySQL
½üÀ´ÐèÒªÓÃPython¶ÔMySQLÊý¾Ý¿â½øÐвÙ×÷¡£Python¾ÃÎÅÆäÃû£¬Î´¼ûÆä“ÈË”£»Êý¾Ý¿âÔø¾ºÜ¸ß·Ö£¬ÔçÒÑ»¹¸øÏÈÉú£¬¸üÎÞMySQL¾Ñé¡£ÓÚÊÇÒ»ÇдÓÁ㿪ʼ£¬½è»úºÃºÃѧϰһ·¬¡£
PythonÕâ¸ö½Å±¾ÓïÑÔȷʵÃû¸±Æäʵ£¬ÓÃÁ˼¸Ìì±ãϲ»¶ÉÏËüÀ²¡£ºÜ¼ò½à£¬ºÜ·½±ã¡£ÒÔËõ¼õ×÷Ϊģ¿é·Ö¸î·û£¬¶ÁÆðÀ´ÉÍÐÄÔÃÄ¿¡£pythonµÄÄÚ½¨Êý¾ÝÀàÐÍ£¨list, tuple, dict£©ÒÔ¼°ÄÚ´æ¹ÜÀí»úÖÆÊ¹µÃ±äÁ¿µÄʹÓ÷dz£¼òµ¥£¬Ð´Æð´úÂëÀ´º¨³©ÁÜÀ죨µ±È»»¹ÊÇÓ¦¸Ã¶¯ÊÖǰ×Ô¸ö½øÐй滮µÄºÃ£©¡£
¹Ø¼üµÄ£¬PythonÒѾÁ÷ÐÐÁ˺ܾÃÀ²£¬¸÷ÖÖÄ£¿éºÜ¶àºÜÇ¿´ó¡£±ÈÈçÆäMySQL½Ó¿Ú¡£ÀûÓÃPython£¬ºÜÈÝÒ׵ľͽ«Ò»Ð©¸´ÔÓµÄSQL¹ý³ÌÖØÐÂʵÏÖÁË¡£ÊµÔÚ²»´í¡£
Êý¾Ý¿âÕâ±ßÖ÷Òª¸´Ï°ÁËϹØÏµÊý¾ÝµÄÏà¹Ø¸ÅÄÁ˽âһЩMySQLµÄ¾ßÌåÓï·¨ºÍÃüÁî¡£ÒòΪÖ÷ÒªÊDzÙ×÷£¬ÔÝʱ²»Éæ¼°Êý¾Ý¿âµÄÉè¼Æ£¬¾Í²»¶à˵ÁË¡£¸Ð¿®Ò»Ï£¬Êý¾Ý¿âÕæÊÇ»¥ÁªÍø¹«Ë¾µÄºËÐÄÖ®Ò»¡£
¼¸¸ö²»´íµÄ²Î¿¼Îĵµ£º
Python£º
¡¶PythonºËÐıà³Ì¡·
http://docs.python.org/tutorial/index.html
MySQL£º
¡¶Êý¾Ý¿âϵͳ¸ÅÄî¡·
http://dev.mysql.com/doc/refman/5.1/zh/index.html
Python and MySQL£º
http://www.kitebird.com/articles/pydbapi.html
http://mysql-python.sourceforge.net/MySQLdb.html
Ïà¹ØÎĵµ£º
PythonÖÐÎļþ²Ù×÷¿ÉÒÔͨ¹ýopenº¯Êý£¬ÕâµÄÈ·ºÜÏñCÓïÑÔÖеÄfopen¡£Í¨¹ýopenº¯Êý»ñȡһ¸öfile object£¬È»ºóµ÷ÓÃread()£¬write()µÈ·½·¨¶ÔÎļþ½øÐжÁд²Ù×÷¡£
1.open
ʹÓÃopen´ò¿ªÎļþºóÒ»¶¨Òª¼ÇµÃµ÷ÓÃÎļþ¶ÔÏóµÄclose()·½·¨¡£±ÈÈç¿ÉÒÔÓÃtry/finallyÓï¾äÀ´È·±£×îºóÄܹرÕÎļþ¡£
file_object = open('thefile.txt' ......
¼Æ»®Õâ¸öÐÇÆÚѧϰÓÃpythonʵÏÖ¾ö²ßÊ÷Ëã·¨¡£½ñÍí¾ÍÅöµ½Á˺öàÎÊÌ⣬ºÃ¾ÃûÓÐÓÃpythonÁË£¬²¢ÇÒ3.0ºÍÊé±¾ÉϵÄÓÐЩ¶«Î÷²»Ì«Ò»Ö£¬ÕâÀï¼Ç¼Ï¼¸¸öµØ·½¡£
1£© import module Èç¹û²»ÊÇÔÚ±ê׼Ŀ¼Ï£¨ÏµÍ³µÄpath£¬pythonµÄĿ¼£¬µ±Ç°Ä¿Â¼£©£¬ÄÇôÐèÒªÏÈimport sys£¬È»ºósys.path.append('')£»
2£© ¸Ä±äÔ´Îļþºó£¬ÔÙ´Îimport ......
from cmd import *
class MyShell(Cmd):
def preloop(self):
print "print this line before entering the loop"
def postloop(self):
&nb ......
2005-2006ѧÄêµÚ1ѧÆÚ
±à Òë Ô Àí
¿Î ³Ì Éè ¼Æ ±¨ ¸æ
°à¼¶ 02¼Æ(¶þ)
ѧºÅ 19
ÐÕÃû ÁõÏþÃ÷
³É¼¨
Ö¸µ¼½Ìʦ ¬³¯»Ô
Ò»¡¢ Éè¼ÆÄ¿µÄ
¼ÓÉî¶Ô±àÒ ......