''' @author:wusen time :2020-02-28 10:12:41 ''' # ============================================================================= # Ctrl + 1: 注释/反注释 # # Ctrl + 4/5: 块注释/块反注释 # '''和"""都可以注释 # ============================================================================= #获取当前时间 import datetime now_time=datetime.datetime.now() time=now_time.strftime("%Y-%m-%d %H:%M:%S") print(time) #变量 变量区分大小写 #global animal="动物" 在函数内部创建为全局变量 animal1,animal2,animal3="小狗","小猫","小羊" print(animal3) #数据类型转换 animal4="4" #强制转换 print(type(int(animal4))) #int float complex复数 num1=2j print(num1) print(type(num1)) #随机数 random import random print(random.randrange(1,10)) #'''和"""也是多行字符串位置 str1="""2020年 加油! """ print(str1) #bool(7>6)布尔类型 #运算符 #列表可以表示数组（python没有数组） fruit=["香蕉","apple",12] print(fruit[1]) print(len(fruit)) fruit.append("wusen") fruit.pop(1) fruit.remove(12) print(fruit) #元组 #不可修改。 #元组之间可以相加 name=("wusen","吴森",12,12) print(name.count(12)) #集合 是无序的，不可修改，可以增加，删除 animal={"wusen","吴森","3可贼",12} animal.add(14) #字典 sex={ "wusen":"男", "xiaohong":"女", "xiaobai":12, "xiaohei":12 } print(sex.get("xiaobai")) city=("邢台","石家庄","保定","邯郸","衡水","廊坊","秦皇岛","唐山") j=range(1,100,3) arr={0:0,} for i in range(1,20): arr[i]=j[i] for i ,j in arr.items(): print(i,j) for i in arr: print(i,arr[i]) i=0 j=1 while i<9: i=i+1 j=1 while j<=i: # print("%dX%d=%d" %(i,j,i*j),end=" ") print((i,j),end="") j=j+1 print("") #函数 def def demoprint(a): print("第",a,"遍新年快乐") for i in range(1,10): if i!=7: demoprint(i) else: continue else: print("结束") #lambda函数 sum=lambda a,b:a+b sum(1,2) def my_f(a): return lambda b:a*b my=my_f(5) my(50) #类 class people: def __init__(self,name,age): self.name=name self.age=age def myname(self): print("My name is",self.name) I=people("吴森",24) I.myname() import mysql.connector mydb = mysql.connector.connect( host="localhost", user="root", passwd="123456" ) print(mydb) #数据库(大小写好像没事) import mysql.connector mydb=mysql.connector.connect( host="localhost", user="root", passwd="123456" ) mycursor=mydb.cursor() mycursor.execute("CREATE DATABASE mydatabase") #输出数据库 import mysql.connector mydb=mysql.connector.connect( host="localhost", user="root", passwd="123456" ) mycursor=mydb.cursor() mycursor.execute("SHOW DATABASES") #print(mycursor) for x in mycursor: print(x) import mysql.connector mydb=mysql.connector.connect( host="localhost", user="root", passwd="123456", database="mydatabase" ) mycursor=mydb.cursor() #mycursor.execute("CREATE TABLE customers(name VARCHAR(255), address VARCHAR(255))") # ALTER TABLE customers ADD COLUMN id INT AUTO_INCREMENT PRIMARY KEY mycursor.execute("ALTER TABLE customers ADD COLUMN id INT AUTO_INCREMENT PRIMARY KEY") mycursor.execute("show tables") for x in mycursor: print(x) import mysql.connector mydb = mysql.connector.connect( host="localhost", user="root", passwd="123456", database="mydatabase" ) mycursor = mydb.cursor() sql = "INSERT INTO customers (name, address) VALUES (%s, %s)" val = ("John", "Highway 21") mycursor.execute(sql, val) mydb.commit() print(mycursor.rowcount, "record inserted.") import mysql.connector mydb=mysql.connector.connect( host="localhost", user="root", passwd="123456", database="mydatabase" ) mycursor=mydb.cursor() sql="INSERT INTO customers (name,address) VALUES (%s,%s)" val=("曹操","东汉末年") mycursor.execute(sql,val) mydb.commit() import mysql.connector mydb=mysql.connector.connect( host="localhost", user="root", passwd="123456", database="mydatabase" ) mycursor=mydb.cursor() mycursor.execute("SELECT * FROM CUSTOMERS") myresult=mycursor.fetchall() for x in myresult: print(x) #批量插入 def myinsert(vals): import mysql.connector mydb=mysql.connector.connect( host="localhost", user="root", passwd="123456", database="mydatabase" ) mycursor=mydb.cursor() sql="INSERT INTO customers (name ,address) VALUES(%s,%s)" for val in vals: mycursor.execute(sql,val) mydb.commit() import openpyxl wb=openpyxl.load_workbook("E:\data.xlsx") sheets = wb.sheetnames print(sheets, type(sheets)) ws=wb["Sheet1"] print(ws["A1"].value) i=1 while i<=ws.max_row: s="A"+str(i) print(ws[s].value) i=i+1 for x in ws[3]: print(x) col_range = ws["A":"B"] row_range = ws[1:4] for col in col_range: # 打印BC两列单元格中的值内容 for cell in col: print(cell.value) for row in row_range: # 打印 2-5行中所有单元格中的值 for cell in row: print(cell.value) print("A"+str(1)) s=input("请输入：") print(s) #发邮件 #email构建邮件 #smtplib发送邮件 #!/usr/bin/python # -*- coding: UTF-8 -*- import smtplib from email.mime.text import MIMEText from email.header import Header sender = 'from@runoob.com' receivers = ['2096706824@qq.com'] # 接收邮件，可设置为你的QQ邮箱或者其他邮箱 mail_msg = """ Python 邮件发送测试... 这是一个链接 """ message = MIMEText(mail_msg, 'html', 'utf-8') message['From'] = Header("菜鸟教程", 'utf-8') message['To'] = Header("测试", 'utf-8') subject = 'Python SMTP 邮件测试' message['Subject'] = Header(subject, 'utf-8') try: smtpObj = smtplib.SMTP('localhost') smtpObj.sendmail(sender, receivers, message.as_string()) print "邮件发送成功" except smtplib.SMTPException: print "Error: 无法发送邮件" import smtplib server = smtplib.SMTP() server.connect(host, port) server.login(username, password) server.sendmail(from_addr, to_addr, msg.as_string()) server.quit() #成功发送 import smtplib from email.mime.text import MIMEText from_addr='2096706824@qq.com' password="nmckgeilsckzcghg" to_addr="2376502463@qq.com" smtp_server="smtp.qq.com" msg=MIMEText("python","plain","utf-8") server=smtplib.SMTP() server.connect(smtp_server,25) server.login(from_addr,password) server.sendmail(from_addr,to_addr,msg.as_string()) server.quit() print("结束") #发送邮件 import smtplib from email.mime.text import MIMEText from_addr="2096706824@qq.com" password="nmckgeilsckzcghg" to_addr="2376502463@qq.com" smtp_server="smtp.qq.com" msg=MIMEText("python","plain","utf-8") i=1; while i<10: server=smtplib.SMTP() server.connect(smtp_server,25) server.login(from_addr,password) server.sendmail(from_addr,to_addr,msg.as_string()) server.quit() i=i+1
