email 示例：

            
              # -*- coding: utf-8 -*-

from email.mime.text import MIMEText
from email.utils import formataddr
from email.mime.application import MIMEApplication
from email.mime.multipart import MIMEMultipart
import smtplib

# 發(fā)郵件人郵箱賬號
my_mail = 'liujun@021.com'
# password
my_pwd = 'Jerry308477'
# 收件人郵箱賬號
my_user = 'liujun@021.com'

def mail():
    flag = True
    try:
        msg = MIMEMultipart()
        # 郵件內(nèi)容
        msg.attach(MIMEText('附件中是沒有統(tǒng)計數(shù)據(jù)','plain','utf-8'))
        # 括號里的對應(yīng)收件人郵箱昵稱，發(fā)件人郵箱賬號
        msg['From'] = formataddr([my_mail,my_mail])
        # 收件人昵稱，收件人郵箱
        msg['To'] = formataddr(['柳俊','liujun@021.com'])
        #  郵件主題
        msg['Subject'] = '廣告收入未統(tǒng)計數(shù)據(jù)'
        # 構(gòu)建附件1（附件為xlsx格式的文本）
        att = MIMEApplication(open(r'E:\Jerry\20190901.xlsx','rb').read())
        att["Content-type"] = 'application/octet-stream'
        att.add_header('Content-Disposition','attachment',filter = ('utf8','','20190901.xlsx'))
        msg.attach(att)

        # SMTP服務(wù)器，騰訊企業(yè)郵箱端口是465，騰訊郵箱支持SSL(不強(qiáng)制)， 不支持TLS
        # qq郵箱smtp服務(wù)器地址:smtp.qq.com,端口號：456
        # 163郵箱smtp服務(wù)器地址：smtp.163.com，端口號：25
        server = smtplib.SMTP_SSL("smtp.exmail.qq.com",465)
        # 登錄服務(wù)器，括號中為發(fā)件人賬號、密碼
        server.login(my_mail,my_pwd)
        # 發(fā)送郵件，括號對應(yīng)發(fā)件人賬號，收件人賬號，發(fā)送郵件
        server.sendmail(my_mail,my_user,msg.as_string())
        # 關(guān)閉連接
        server.quit()
        # 如果 try 中的語句沒有執(zhí)行，則會執(zhí)行下面的 flag = False
    except Exception as e:
        print(e)
        flag = False
    return flag

if __name__ == '__main__':
    result = mail()
    if result :
        print("郵件發(fā)送成功！")
    else:
        print("郵件發(fā)送失敗！")
            
          

pymysql示例：

            
              # -*- coding: utf-8 -*-
# 將 Excel 的數(shù)據(jù)寫入到mysql中

import pymysql

def connectMysql(baseName):
    #建立連接
    conn = pymysql.connect(
        host='192.168.88.99',
        user='mysql',
        passwd='mysql',
        db='test',
        port=3306,
        charset='utf8'
    )
    # 獲取游標(biāo)
    cur = conn.cursor()
    # sql
    sql = "select * from student where id = '%s'" % (baseName)

    try:
        cur.execute(sql)
        conn.commit()
    except:
        conn.rollback()
    cur.close()
    conn.close()

if __name__ == '__main__':
    connectMysql("1234")
            
          

?