python3.4怎么连接mysql pymysql连接mysql数据库 如何使用Python3.4连接MySQL
\u5982\u4f55\u8fde\u63a5python3.4 \u548cMySQL5.7\uff0c\u8bf7\u5927\u725b\u4eec\u6307\u6559\u8fd9\u4e2apython\u5165\u95e8\u65b0\u624b\u3000\u3000\u5728python\u5b98\u7f51\u4e2d\u53bb\u4e0b\u8f7dez_setup.py\u6587\u4ef6\u3002
\u3000\u3000\u6b64\u5de5\u5177\u662fpython\u7ba1\u7406\u5305\u5de5\u5177\uff0c\u901a\u8fc7\u5b83\u53ef\u4ee5\u4e0b\u8f7d\u5f88\u591a\u670d\u52a1\u3002
\u3000\u3000\u8bf7\u6839\u636e\u7cfb\u7edf\u4e0b\u8f7d\u76f8\u5173\u6587\u4ef6\u3002
\u3000\u3000\u5728python\u4e2d\u6267\u884cpython ez_setup.py\u6587\u4ef6\uff0c\u5982\u679c\u6ca1\u6709\u914d\u7f6e\u73af\u5883\u53d8\u91cf\uff0c\u53ef\u4ee5\u5728python\u5b89\u88c5\u8def\u5f84\u4e2d\u627e\u5230python.exe\uff0c\u5728\u6b64\u76ee\u5f55\u4e2d\u6267\u884c\u4e0a\u9762\u547d\u4ee4\u3002
\u3000\u3000\u547d\u4ee4\u6267\u884c\u6210\u529f\u540e\uff0c\u4f1a\u5728python\u5b89\u88c5\u76ee\u5f55\u4e0beasy_install.exe\u5de5\u5177\u5305\u3002
\u3000\u3000\u5728CMD\u547d\u4ee4\u884c\u6267\u884c\uff1aeasy_install.exe pymysql3
\u3000\u3000\u5982\u679c\u627e\u4e0d\u5230\u8be5\u547d\u4ee4\uff0c\u5207\u6362\u670d\u52a1\u5230python\u5b89\u88c5\u76ee\u5f55/Scripts/\u4e0b\u6267\u884c\u3002\u5982\u679c\u6b64\u76ee\u5f55\u4e0b\u6ca1\u6709easy_install.exe\uff0c\u8bc1\u660e\u4e0a\u4e00\u6b65\u6ca1\u6709\u5b89\u88c5\u6210\u529f\u3002
\u3000\u3000\u5b89\u88c5pymysql3\u670d\u52a1\u5982\u4e0b\u3002
\u3000\u3000pymysql3\u670d\u52a1\u5b89\u88c5\u6210\u529f\u540e\uff0c\u5f00\u59cb\u5199python\u7a0b\u5e8f\u8fde\u63a5mysql\u670d\u52a1\u3002
\u3000\u3000mysql\u6570\u636e\u5e93\u5b89\u88c5\u5728\u6b64\u7701\u7565\uff0c\u5230mysql\u5b98\u65b9\u7f51\u7ad9\u4e0b\u8f7d\uff0c\u4e0b\u4e00\u6b65\u5b89\u88c5\u5c31\u53ef\u4ee5\u4e86\u3002
\u3000\u3000python\u7a0b\u5e8f\u5185\u5bb9\u5982\u4e0b\uff1aimport pymysql
\u3000\u3000conn = pymysql.connect(user='root', passwd='root',
\u3000\u3000host='localhost', db='zjctest')
\u3000\u3000cur = conn.cursor()
\u3000\u3000cur.execute("SELECT * FROM zjc")
\u3000\u3000for r in cur:
\u3000\u3000print("row_number:" , (cur.rownumber) )
\u3000\u3000print("id:"+str(r[0])+"name:"+str(r[1])+"age:"+str(r[2]))
\u3000\u3000cur.close()
\u3000\u3000conn.close()
\u3000\u3000\u6267\u884c\u7ed3\u679c\u5982\u4e0b\uff0c\u8bc1\u660e\u8fde\u63a5mysql\u6570\u636e\u5e93\u6210\u529f\uff0c\u4e14\u6570\u636e\u6b63\u786e\u8fd4\u56de\u3002
python3\u53d1\u5e03\u4ee5\u6765\uff0c\u83b7\u53d6\u4e86\u5e7f\u5927\u7a0b\u5e8f\u5458\u4eec\u7684\u5dee\u8bc4\uff0c\u8bf4\u4e0d\u7a33\u5b9a\uff0c\u53c8\u662f\u4e0d\u517c\u5bb9\u4ec0\u4e48\u7684\uff0c\u4e0d\u8fc7\u5dee\u8bc4\u5f52\u5dee\u8bc4\uff0cpython3\u65e2\u7136\u5df2\u7ecf\u53d1\u5e03\uff0c\u80af\u5b9a\u662f\u4e2a\u8d8b\u52bf\uff0c\u4f46\u5728python3.4\u91cc\u9762\uff0c\u4f7f\u7528\u539f\u6765python2.7\u7684mysqldb\u5df2\u7ecf\u4e0d\u80fd\u8fde\u63a5mysql\u6570\u636e\u5e93\u4e86\uff0c\u6bd4\u8f83\u4ee4\u4eba\u7ea0\u7ed3\uff0c\u4e0d\u8fc7\u6211\u4eec\u53ef\u4ee5\u4f7f\u7528pymysql\uff0c\u6765\u5b8c\u6210\u8fde\u63a5mysql\u7684\u91cd\u4efb\uff0c\u6b65\u9aa4\u5982\u4e0b\uff1a
\u5e8f\u53f7\u63cf\u8ff0
1\u53bbgithub\u4e0a\u4e0b\u8f7dpymysql\u7684\u5b89\u88c5\u5305pymysql
2\u89e3\u538b\u5230\u67d0\u4e2a\u76d8\u7b26\u4e0b
3\u6253\u5f00cmd\u7a97\u53e3\uff08win\u73af\u5883\u4e0b\uff09\uff0c\u8fdb\u5165pymysql\u7684\u6839\u76ee\u5f55\u4e0b\u6267\u884c\u547d\u4ee4\uff0cpython setup.py install4\u5728\u7a0b\u5e8f\u91cc\uff0c\u5bfc\u5165pymysql
5\u5f00\u59cb\u8fde\u63a5\u6570\u636e\u5e93
\u6570\u636e\u5e93\u64cd\u4f5c\u7684API\u6587\u6863\u8fde\u63a5:http://legacy.python.org/dev/peps/pep-0249/\u4ee3\u7801\u5982\u4e0b\uff1a
__author__ = 'qindongliang'
#\u5bfc\u5165pymysql\u7684\u5305
import pymysql
try:
#\u83b7\u53d6\u4e00\u4e2a\u6570\u636e\u5e93\u8fde\u63a5\uff0c\u6ce8\u610f\u5982\u679c\u662fUTF-8\u7c7b\u578b\u7684\uff0c\u9700\u8981\u5236\u5b9a\u6570\u636e\u5e93conn=pymysql.connect(host='localhost',user='root',passwd='qin',db='person',port=3306,charset='utf8')cur=conn.cursor()#\u83b7\u53d6\u4e00\u4e2a\u6e38\u6807
cur.execute('select * from person')
data=cur.fetchall()
for d in data :
#\u6ce8\u610fint\u7c7b\u578b\u9700\u8981\u4f7f\u7528str\u51fd\u6570\u8f6c\u4e49
print("ID: "+str(d[0])+' \u540d\u5b57\uff1a '+d[1]+" \u6027\u522b\uff1a "+d[2])cur.close()#\u5173\u95ed\u6e38\u6807
conn.close()#\u91ca\u653e\u6570\u636e\u5e93\u8d44\u6e90
except Exception :print("\u53d1\u751f\u5f02\u5e38")
\u7ed3\u679c\u5982\u4e0b\uff1a
D:\python\python.exe D:/pythonide/pythonprojectworkspace/python/mysql.pyID: 1 \u540d\u5b57\uff1a \u79e6\u5929 \u6027\u522b\uff1a \u7537
ID: 2 \u540d\u5b57\uff1a \u738b\u6676 \u6027\u522b\uff1a \u5973
Process finished with exit code 0
\u539f\u6587 http://qindongliang1922.iteye.com/blog/2096512\u8865\u5145\u8bf4\u660e\uff1a
mysqldb\u4f5c\u4e3apython\u8fde\u63a5mysql\u6570\u636e\u5e93\u7684\u5de5\u5177\uff0c\u4f46\u662fmysqldb\u76ee\u524d\u652f\u6491\u7684\u7248\u672c\u8f83\u4f4e\uff0c\u5b89\u88c5\u5931\u8d25\u3002\u6240\u4ee5\u624d\u5c1d\u8bd5pymysql,\u8fd9\u4e2a\u6bd4\u8f83\u7b80\u5355\u6613\u7528\u8f6f\u4ef6\u4e0b\u8f7d\u5730\u5740\uff1a
python3.2.5:https://www.python.org/ftp/python/3.2.5/python-3.2.5.msipymysql3.0.5:https://pypi.python.org/packages/source/P/PyMySQL3/PyMySQL3-0.5.tar.gzmysql:http://www.phpstudy.net/phpstudy/phpStudyLite.zip(\u4e3a\u4e86\u65b9\u4fbf\u5b89\u88c5\uff0c\u6211\u8fd9\u91cc\u9009\u62e9phpstudy)1\u3001python\u5b89\u88c5\u76ee\u5f55\u8bbe\u5b9a\u4e3ad:/python32
2\u3001pymysql\u5b89\u88c5\u65b9\u6cd5\u4e3a\uff1a\u89e3\u538b\u4e0b\u8f7d\u7684\u6587\u4ef6\uff0c\u5728cmd\u4e2d\u8fd0\u884c: python setup.py install\u3002
\u68c0\u9a8c\u5b89\u88c5\u5b89\u88c5\u662f\u5426\u6210\u529f\u7684\u65b9\u6cd5\uff1aimport pymysql \u3002 \u5982\u679c\u4e0d\u62a5\u9519 \u8bf4\u660e\u5b89\u88c5\u6210\u529f\u3002
3\u3001mysql\u5b89\u88c5\u76ee\u5f55\u4e3aD:/phpStudy/MySQL\u3002\u4e3a\u907f\u514d\u66f4\u591a\u914d\u7f6e\u95ee\u9898\uff0c\u53ef\u5728\u542f\u52a8phpstudy\u540e\uff0c\u5c06\u5176\u8bbe\u4e3a\u7cfb\u7edf\u670d\u52a14\u3001\u57fa\u672c\u64cd\u4f5c\uff1a
\uff081\uff09\u5bfc\u5165pymysql: import pymysql
\uff082\uff09\u8fde\u63a5\u6570\u636e\u5e93\uff1a conn=pymysql.connect(host='localhost',user='root',passwd='root',db='ere'\uff0ccharset='utf8') \u52a1\u5fc5\u6ce8\u610f\u5404\u7b49\u53f7\u524d\u9762\u7684\u5185\u5bb9\uff01charset\u53c2\u6570\u53ef\u907f\u514d\u4e2d\u6587\u4e71\u7801\uff083\uff09\u83b7\u53d6\u64cd\u4f5c\u6e38\u6807\uff1acur=conn.cursor()
\uff084\uff09\u6267\u884csql\u8bed\u53e5,\u63d2\u5165\u8bb0\u5f55\uff1asta=cur.execute("insert \u8bed\u53e5") \u6267\u884c\u6210\u529f\u540esta\u503c\u4e3a1\u3002\u66f4\u65b0\u3001\u5220\u9664\u8bed\u53e5\u4e0e\u6b64\u7c7b\u4f3c\u3002
\uff085\uff09\u6267\u884csql\u8bed\u53e5\uff0c\u67e5\u8be2\u8bb0\u5f55\uff1acur.execute("select\u8bed\u53e5") \u6267\u884c\u6210\u529f\u540ecur\u53d8\u91cf\u4e2d\u4fdd\u5b58\u4e86\u67e5\u8be2\u7ed3\u679c\u8bb0\u5f55\u96c6\uff0c\u7136\u540e\u518d\u7528\u5faa\u73af\u6253\u5370\u7ed3\u679c\uff1a
for each in cur:
print(each[1].decode('utf-8')) # each[1] \u8868\u793a\u5f53\u524d\u6e38\u6807\u6240\u5728\u884c\u7684\u7684\u7b2c2\u5217\u503c\uff0c\u5982\u679c\u662f\u4e2d\u6587\u5219\u9700\u8981\u5904\u7406\u7f16\u7801
2、pymysql安装方法为：解压下载的文件，在cmd中运行: python setup.py install。
检验安装安装是否成功的方法：import pymysql 。 如果不报错 说明安装成功。
3、mysql安装目录为D:/phpStudy/MySQL。为避免更多配置问题，可在启动phpstudy后，将其设为系统服务
4、基本操作：
（1）导入pymysql: import pymysql
（2）连接数据库：
conn=pymysql.connect(host='localhost',user='root',passwd='root',db='ere'，charset='utf8')
务必注意各等号前面的内容！charset参数可避免中文乱码
（3）获取操作游标：cur=conn.cursor()
（4）执行sql语句,插入记录：sta=cur.execute("insert 语句") 执行成功后sta值为1。更新、删除语句与此类似。
（5）执行sql语句，查询记录：cur.execute("select语句") 执行成功后cur变量中保存了查询结果记录集，然后再用循环打印结果：
for each in cur:
print(each[1].decode('utf-8')) # each[1] 表示当前游标所在行的的第2列值，如果是中文则需要处理编码
具体步骤：
序号 描述
1 去github上下载pymysql的安装包pymysql https://github.com/PyMySQL/PyMySQL
2 解压到某个盘符下
3 打开cmd窗口（win环境下），进入pymysql的根目录下执行命令，python setup.py install
4 在程序里，导入pymysql
5 开始连接数据库
数据库操作的API文档连接:http://legacy.python.org/dev/peps/pep-0249/
绛旓細寰堟槑鏄惧晩锛屼綘鏈鍚庝竴鍙ヤ唬鐮乸rint(Myaddress())鍝潵鐨勫晩锛熶綘瀹氫箟鐨勫嚱鏁版槸printMyaddress锛堬級锛屾墍浠ヤ綘鏈鍚庝竴鍙ヤ唬鐮佸簲璇ユ槸print(printMyaddress())PS锛氭渶鍚庝竴鍙ヤ笉鏀瑰湪2.7鑲畾涔熻繍琛屽嚭閿欍
绛旓細python灏嗘暟缁勮浆鎹负鐭╅樀锛屾柟娉曞涓嬶細鏁扮粍杞崲鐭╅樀锛 A 锛 mat锛坰锛伙冀锛Python鐨瀹氫箟锛歅ython鏄竴绉嶉潰鍚戝璞°佺洿璇戝紡璁＄畻鏈虹▼搴忚璁¤瑷锛孭ython璇硶绠鎹疯屾竻鏅帮紝鍏锋湁涓板瘜鍜屽己澶х殑绫诲簱銆傚畠甯歌涓鸿兌姘磋瑷锛屽畠鑳藉寰堣交鏉剧殑鎶婄敤鍏朵粬璇█鍒朵綔鐨勫悇绉嶆ā鍧楋紙灏ゅ叾鏄疌/C++锛夎交鏉惧湴鑱旂粨鍦ㄤ竴璧枫傚父瑙佺殑涓绉嶅簲鐢ㄦ儏褰㈡槸...
绛旓細姝ｇ‘鐨勪娇鐢ㄦ槸杩欐牱鐨勩備换浣曟墿灞曞悕涓簆y鐨勬枃鏈枃妗ｉ兘鏄python鐨鏂囦欢锛岀劧鍚庤皟鐢ㄥ氨鍙互浜 windows涓嬫墽琛 c:\python27\python.exe d:\myfile.py 杩欐牱鎵ц銆傚彟澶栵紝鍦python 鐨IDE閲岄潰锛屼笂闈㈡槸鏂囨湰鐨勭紪杈戠晫闈紝鍙互杈撳叆锛屼笅闈㈡槸浜や簰鐣岄潰銆傛帹鑽愪綘鎵撳紑IDE锛堝彟澶栦竴涓揩鎹锋柟寮忥級锛岃屼笉鏄洿鎺ユ墦寮鍛戒护琛岀殑浜や簰鐣岄潰 ...
绛旓細def handle_data(self, data): f = open('filename.txt','w') if self.p_text: a = data f.write(a) f.close()杩欎竴閮ㄥ垎浠ｇ爜鏈夐棶棰橈紝濡傛灉鏄疻姣忔閮戒細閲嶅啓杩欎釜鏂囦欢鏀规垚A灏卞彲浠ヤ簡 f = open('filename.txt','a')
绛旓細b锛濓紙x锛峚锛夛紡y return锛坅锛宐锛夛純涔熷彲浠ュ啓浣渞eturna锛宐 锛坈锛宒锛夛紳F1锛9锛4锛夛純涔熷彲浠ュ啓浣渃锛宒锛滷1锛9锛4锛塸rintc锛宒 缁撴灉鏄剧ず锛1锛2 Python涓庡ぇ澶氭暟鍏跺畠璇█涓鏍锋湁灞閮ㄥ彉閲忓拰鍏ㄥ眬鍙橀噺涔嬪垎锛屼絾鏄畠娌℃湁鏄庢樉鐨勫彉閲忓０鏄庛傚彉閲忛氳繃棣栨璧嬪间骇鐢燂紝褰撹秴鍑轰綔鐢ㄨ寖鍥存椂鑷姩娑堜骸銆備緥2銆佸畾涔myParams...
绛旓細Python鐖櫕锛屽叏绉癙ython缃戠粶鐖櫕锛屾槸涓绉嶆寜鐓т竴瀹氱殑瑙勫垯锛岃嚜鍔ㄥ湴鎶撳彇涓囩淮缃戜俊鎭殑绋嬪簭鎴栬剼鏈紝涓昏鐢ㄤ簬鎶撳彇璇佸埜浜ゆ槗鏁版嵁銆佸ぉ姘旀暟鎹佺綉绔欑敤鎴锋暟鎹拰鍥剧墖鏁版嵁绛夛紝Python涓烘敮鎸佺綉缁滅埇铏甯稿姛鑳藉疄鐜帮紝鍐呯疆浜嗗ぇ閲忕殑搴擄紝涓昏鏈夊嚑绉嶇被鍨嬨備笅闈㈡湰绡囨枃绔犲氨鏉ョ粰澶у浠嬬粛銆備竴銆丳ython鐖櫕缃戠粶搴揚ython鐖櫕缃戠粶搴撲富瑕佸寘鎷細...
绛旓細import ctypesdef get(): '''浠庡壀鍒囨澘涓幏寰楀瓧绗︿覆''' h=ctypes.WinDLL('user32.dll') h.OpenClipboard(0) aa=h.GetClipboardData(13) ss=ctypes.c_wchar_p(aa) h.CloseClipboard() return ss.valuedef set(mystr): '''鎶婂瓧绗︿覆鏀惧埌鍓垏鏉夸腑,鎴愬姛杩斿洖1锛屽け璐...
绛旓細Navigation 闈㈡澘涓夋嫨鐨勭▼搴忥紙濡傛灉鏈夌殑璇濓級璁剧疆鍜屼慨鏀规椿鍔ㄥ惎鍔ㄩ」锛屽彲浠ヤ娇鐢ㄥ惎鍔ㄩ」绠＄悊宸ュ叿銆濡備綍鑾峰緱鍚姩椤圭鐞嗗伐鍏峰彲浠ュ弬鑰冨垱寤轰竴涓惎鍔ㄩ」杩愯鎴栬皟璇曞簲鐢ㄧ▼搴忓皢瑙﹀彂浠ヤ笅鍔ㄤ綔:鍚姩妯℃嫙鍣紝濡傛灉浠栬繕娌℃湁寮濮嬭繍琛屻傜紪璇戝伐绋嬶紝 濡傛灉鍦ㄤ笂娆＄紪璇戠殑鍩虹涓婁慨鏀硅繃浠ｇ爜锛屽皢閲嶆柊缂栬瘧銆傚湪妯℃嫙鍣ㄤ笂瀹夎搴旂敤绋嬪簭銆
绛旓細鍥炵瓟锛氬拫杞繃鏉ョ殑
绛旓細缁忚繃璇曢獙, 鎹㈢敤鏇撮珮鐨刣jango鐗堟湰灏辨病闂浜, 鎵浠ヤ及璁℃槸django1.7.11涓嶆敮鎸python3.5 鑰屼笖, 瑕佸畨瑁卍jango鐩存帴:pip install django
