最開始用python連接mysql的時候，會經(jīng)常性的連一次關一次，如此重復，導致端口可能會占用從而報錯，后面采用一次性連接的方式

代碼如下：

import pymysql
import WriteLog
import config

DATABASE_INFO = config.DATABASE_INFO
SQL = config.SQL

class GetData():
    def __init__(self):
        self.conn, self.cur = self.connect_db()

    def connect_db(self):
        try:
            conn = pymysql.connect(**DATABASE_INFO)
            cur = conn.cursor()
            return conn, cur
        except Exception as e:
            WriteLog.writeLog('dbError',str(e))
            return None

    def get_data(self):
        self.cur.execute(SQL)
        self.conn.commit()
        # self.cur.close() 這兩行就不要在寫了
        # self.conn.close()
        pass

下面是自定義LOG的代碼：

# -*- coding: UTF-8 -*-
import time
import os
import config

LOG_PATH = config.LOG_PATH

class WriteLog(object):

    @staticmethod
    def writeLog(file,logs):
        if not os.path.exists(LOG_PATH):
            os.mkdir(LOG_PATH)
        with open(LOG_PATH + '\\'+file+'.log', "a") as f:
            str1 = WriteLog.localTime()
            f.write(str1 + '   ' + logs + "\n")

    @staticmethod
    def localTime():
        return time.strftime("%Y-%m-%d %H:%M:%S", time.localtime())

當然所有的sql語句和連接都可以放在另外一個config文件中作為配置