Python+selenium案例之连接mysql数据库

import mysql.connector

def connection():

    mydb = mysql.connector.connect(
        host="localhost",
        user="root",
        passwd="123456",
        database="irs0627"
    )
    mycursor = mydb.cursor()

    mycursor.execute("SELECT begin_time,end_time,work_minutes,analyze_result FROM attend_record")

    myresult = mycursor.fetchall()  # fetchall() 获取所有记录

    person=[]
    for x in myresult:
        person.append(x)
        print(x)
        #print(type(x))
    print(person)
    for i in range(len(person)):
        print("--------------",person[i][0],"---------------")
if __name__ == '__main__':
    connection()