python+MySQL架構

標籤：htm   close   nal   use   int   utf8   html   span   客戶   

 1 #! usr/bin/python 2 #coding=utf-8 3  4 # Python + 連接器 構成一個用戶端 5 from pymysql import connect 6  7 # 串連選項 8 db_config = { 9     ‘host‘: ‘192.168.1.105‘,10     ‘port‘: 3306,11     ‘user‘: ‘wendy‘,12     ‘passwd‘: ‘1234567890‘,13     ‘db‘: ‘testDB2‘,14     ‘charset‘: ‘utf8‘,15 }16 17 # 串連到資料庫18 connection = connect(**db_config)19 20 try:21     with connection.cursor() as cursor:22         sql = "SELECT * FROM `testDB2`.`users`"23         cursor.execute(sql)24         for i in cursor:25             print(i)26 finally:27     connection.close()

參考網站：http://pymysql.readthedocs.io/en/latest/user/examples.html

python+MySQL架構