mysql 处理非法数据

import mysql.connector

try:
    conn = mysql.connector.connect(user='user', password='password', host='host', database='database')
    cursor = conn.cursor()
    
    # 假设我们要插入的数据
    data = {
        'name': 'John Doe',
        'age': -5  # 非法数据，年龄不能为负数
    }
    
    # 数据验证
    if data['age'] < 0:
        raise ValueError("Age cannot be negative")
    
    query = "INSERT INTO users (name, age) VALUES (%s, %s)"
    cursor.execute(query, (data['name'], data['age']))
    conn.commit()
except mysql.connector.Error as err:
    print(f"Error: {err}")
finally:
    cursor.close()
    conn.close()

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    age INT CHECK (age >= 0)
);

query = "SELECT * FROM users WHERE username = %s AND password = %s"
cursor.execute(query, (username, password))

import re

def validate_email(email):
    pattern = r'^[a-zA-Z0-9_.+-]+@[a-zA-Z0-9-]+\.[a-zA-Z0-9-.]+$'
    return re.match(pattern, email) is not None

if validate_email(email):
    # 执行数据库操作
    pass
else:
    print("Invalid email address")