pip install PyMySQL

import pymysql

# 連接數(shù)據(jù)庫
connection = pymysql.connect(host='localhost',   # 本地
                             user='root',        # 賬號
                             password='root',    # 密碼   
                             charset='utf8mb4')  

# 創(chuàng)建游標對象
cursor = connection.cursor()

'''
### 創(chuàng)建數(shù)據(jù)庫 
（這里假設(shè)創(chuàng)建一個名為face_recognition_attendance的用于人臉識別考勤）
'''
cursor.execute("CREATE DATABASE IF NOT EXISTS face_recognition_attendance")

'''
=== 切換到新創(chuàng)建的數(shù)據(jù)庫
（一樣的，創(chuàng)建一個表命名為face_recognition_attendance用于記錄人臉識別考勤）
'''
cursor.execute("USE face_recognition_attendance")

# 創(chuàng)建表格（表格的結(jié)構(gòu)，我這里自己弄的是【ID，職位，姓名，狀態(tài)，考勤時間】）
create_table_query = """
CREATE TABLE IF NOT EXISTS attendance_data (
    ID INT AUTO_INCREMENT PRIMARY KEY,
    position VARCHAR(255),
    name VARCHAR(255),
    status VARCHAR(50),
    attendance_time DATETIME
)
"""
# 執(zhí)行命令的意思
cursor.execute(create_table_query)

# 提交更改并關(guān)閉連接
connection.commit()
connection.close()

print("人臉識別考勤系統(tǒng)數(shù)據(jù)庫和表格創(chuàng)建成功！")

import pymysql

class FaceRecognitionData:
    def __init__(self):
        pass

    def create_database(self):
        connection = pymysql.connect(host='localhost',
                                     user='root',
                                     password='root',
                                     charset='utf8mb4')

        cursor = connection.cursor()

        # 創(chuàng)建數(shù)據(jù)庫如果不存在
        cursor.execute("CREATE DATABASE IF NOT EXISTS face_recognition_attendance")
        cursor.execute("USE face_recognition_attendance")

        # 創(chuàng)建表格如果不存在
        create_table_query = """
        CREATE TABLE IF NOT EXISTS attendance_data (
            ID INT AUTO_INCREMENT PRIMARY KEY,
            position VARCHAR(255),
            name VARCHAR(255),
            status VARCHAR(50),
            attendance_time DATETIME
        )
        """
        cursor.execute(create_table_query)

        connection.close()

        print("人臉考勤系統(tǒng)數(shù)據(jù)庫創(chuàng)建成功！")

    def insert_data_to_db(self, data):
        connection = pymysql.connect(host='localhost',
                                     user='root',
                                     password='root',
                                     database='face_recognition_attendance',
                                     charset='utf8mb4')

        cursor = connection.cursor()

        insert_query = "INSERT INTO attendance_data (ID, position, name, status, attendance_time) VALUES (%s, %s, %s, %s, %s)"

        for entry in data:
            cursor.execute(insert_query, entry)

        connection.commit()
        connection.close()

        print("數(shù)據(jù)插入成功！")

# 假設(shè)get_fanceRes()函數(shù)已經(jīng)定義并返回數(shù)據(jù)
def get_fanceRes():
    # 假設(shè)這里是您的get_fanceRes()函數(shù)的實現(xiàn)
    data = [
        [1, 'Manager', 'Alice', 'Present', '2022-01-01 08:00:00'],
        [2, 'Engineer', 'Bob', 'Absent', '2022-01-01 09:00:00'],
        # 其他數(shù)據(jù)條目
    ]
    return data

# 創(chuàng)建數(shù)據(jù)庫
face_recognition_data = FaceRecognitionData()
face_recognition_data.create_database()

# 獲取數(shù)據(jù)并插入數(shù)據(jù)庫
face_data = get_fanceRes()
face_recognition_data.insert_data_to_db(face_data)

cd C:\Program Files\MySQL\MySQL Server 8.0\bin

mysql -h localhost -u root -p

SHOW DATABASES;
USE face_recognition_attendance;
SHOW TABLES;
DESCRIBE attendance_data;
SELECT * FROM attendance_data;

SHOW DATABASES;

USE face_recognition_attendance;

SHOW TABLES;

DESCRIBE attendance_data;

SELECT * FROM attendance_data;

compmgmt.msc