Python3.4串連Mysql

標籤：

Python版本：3.4.3

安裝Lib庫：pymysql

 

代碼結構樹：

 

主函數代碼片dbcheck.py

#!/usr/bin/python# -*- coding: utf-8 -*-import configinitimport pymysqldef execute_mysql():    conn = None    cur = None    try:        conn = pymysql.connect(**configinit._mysql_config)        cur = conn.cursor()        query = "SELECT * FROM publicnetbarpolicy;"        cur.execute(query)        result = cur.fetchall()        for record in result:            print(record)        cur.close()        conn.close()    except pymysql.Error as e:        print("Mysql Error %d: %s" % (e.args[0], e.args[1]))if __name__ == ‘__main__‘:    execute_mysql()

 

資料庫設定檔__init__.py

#!/usr/bin/python# -*- coding: utf-8 -*-_mysql_config = {      ‘user‘: ‘root‘,      ‘password‘: ‘js*%##))!!WX‘,      ‘host‘: ‘10.34.53.172‘,      ‘db‘: ‘netbarapppolicys‘,      ‘charset‘:‘utf8‘,    }

 

Python3.4串連Mysql