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

# 发邮件人邮箱账号
my_mail = 'liujun@021.com'
# password
my_pwd = 'Jerry308477'
# 收件人邮箱账号
my_user = 'liujun@021.com'

def mail():
    flag = True
    try:
        msg = MIMEMultipart()
        # 邮件内容
        msg.attach(MIMEText('附件中是没有统计数据','plain','utf-8'))
        # 括号里的对应收件人邮箱昵称，发件人邮箱账号
        msg['From'] = formataddr([my_mail,my_mail])
        # 收件人昵称，收件人邮箱
        msg['To'] = formataddr(['柳俊','liujun@021.com'])
        #  邮件主题
        msg['Subject'] = '广告收入未统计数据'
        # 构建附件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服务器，腾讯企业邮箱端口是465，腾讯邮箱支持SSL(不强制)， 不支持TLS
        # qq邮箱smtp服务器地址:smtp.qq.com,端口号：456
        # 163邮箱smtp服务器地址：smtp.163.com，端口号：25
        server = smtplib.SMTP_SSL("smtp.exmail.qq.com",465)
        # 登录服务器，括号中为发件人账号、密码
        server.login(my_mail,my_pwd)
        # 发送邮件，括号对应发件人账号，收件人账号，发送邮件
        server.sendmail(my_mail,my_user,msg.as_string())
        # 关闭连接
        server.quit()
        # 如果 try 中的语句没有执行，则会执行下面的 flag = False
    except Exception as e:
        print(e)
        flag = False
    return flag

if __name__ == '__main__':
    result = mail()
    if result :
        print("邮件发送成功！")
    else:
        print("邮件发送失败！")
            
          

pymysql示例：

            
              # -*- coding: utf-8 -*-
# 将 Excel 的数据写入到mysql中

import pymysql

def connectMysql(baseName):
    #建立连接
    conn = pymysql.connect(
        host='192.168.88.99',
        user='mysql',
        passwd='mysql',
        db='test',
        port=3306,
        charset='utf8'
    )
    # 获取游标
    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")