今天继续学习python，操作mysql数据库
AI搜索：python做一个用户管理系统mysql
以下是过程和结果：
import mysql.connector
from mysql.connector import Error
import time
def connect_to_database():try:conn = mysql.connector.connect(host='localhost',user='root',password='root',database='test_db')return connexcept Error as e:print(f"Error connecting to the database: {e}")def create_user(name, email, password, create_time):#print(create_time)#return Falseconn = connect_to_database()if conn.is_connected():#print("连接成功！")cursor = conn.cursor()sql = """INSERT INTO users (name, email, password, create_time) VALUES (%s, %s, %s, %s)""" cursor.execute(sql,(name, email, password, create_time))conn.commit()print("User created successfully")cursor.close()conn.close()else:print("Error: Unable to connect to MySql.")def delete_user(name):conn = connect_to_database()if conn.is_connected():cursor = conn.cursor()sql = """DELETE FROM users WHERE name = %s""" cursor.execute(sql,(name))conn.commit()print("User deleted successfully")cursor.close()conn.close()else:print("Error: Unable to connect to MySql.")def view_users():conn = connect_to_database()if conn.is_connected():cursor = conn.cursor()sql = """SELECT * FROM users""" cursor.execute(sql)rescord = cursor.fetchall()for row in rescord:print(f"ID: {row[0]}, Name:{row[1]}, Email: {row[2]},Password: {row[3]}")cursor.close()conn.close()else:print("Error: Unable to connect to MySql.")def find_user(name):conn = connect_to_database()if conn.is_connected():cursor = conn.cursor()sql = """SELECT * FROM users WHERE name = %s""" cursor.execute(sql,(name))rescord = cursor.fetchone()if rescord:print(f"ID: {rescord[0]}, Name:{rescord[1]}, Email: {rescord[2]},Password: {rescord[3]}")else:print("No user found.")cursor.close()conn.close()else:print("Error: Unable to connect to MySql.")# Example usage:#执行
if __name__ == '__main__':#create_time = time.strftime("%Y-%m-%d %H:%M:%S", time.localtime())#create_user('zhangsan', 'zhangsan@example.com', '123456',create_time)#view_users()#find_user(['test']) delete_user(['test'])'''
AI搜索：python做一个用户管理系统mysql为了创建一个用户管理系统，您可以使用Python连接MySQL数据库，并实现用户的增删改查功能。以下是一个简单的用户管理系统示例，包括添加用户、删除用户、查看所有用户和查找特定用户的信息。首先，确保安装了mysql-connector-python库，可以使用pip安装：pip install mysql-connector-python然后，您可以编写以下Python代码来实现用户管理系统：import mysql.connector
from mysql.connector import Errordef connect_to_database():try:connection = mysql.connector.connect(host='localhost',user='yourusername',password='yourpassword',database='yourdatabase')return connectionexcept Error as e:print(f"Error connecting to the database: {e}")def create_user(name, email, password):connection = connect_to_database()if connection.is_connected():cursor = connection.cursor()sql_insert_query = """INSERT INTO users (name, email, password) VALUES (%s, %s, %s)"""cursor.execute(sql_insert_query, (name, email, password))connection.commit()print("User created successfully")cursor.close()connection.close()else:print("Error: Unable to connect to MySQL.")def delete_user(name):connection = connect_to_database()if connection.is_connected():cursor = connection.cursor()sql_delete_query = """DELETE FROM users WHERE name = %s"""cursor.execute(sql_delete_query, (name))connection.commit()print("User deleted successfully")cursor.close()connection.close()else:print("Error: Unable to connect to MySQL.")def view_users():connection = connect_to_database()if connection.is_connected():cursor = connection.cursor()sql_select_query = """SELECT * FROM users"""cursor.execute(sql_select_query)records = cursor.fetchall()for row in records:print(f"Name: {row[0]}, Email: {row[1]}, Password: {row[2]}")cursor.close()connection.close()else:print("Error: Unable to connect to MySQL.")def find_user(name):connection = connect_to_database()if connection.is_connected():cursor = connection.cursor()sql_select_query = """SELECT * FROM users WHERE name = %s"""cursor.execute(sql_select_query, (name))record = cursor.fetchone()if record:print(f"Name: {record[0]}, Email: {record[1]}, Password: {record[2]}")else:print("No user found.")cursor.close()connection.close()else:print("Error: Unable to connect to MySQL.")# Example usage:
create_user('Alice', 'alice@example.com', 'password123')
delete_user('Alice')
view_users()
find_user('Alice')确保您的MySQL数据库中有一个名为users的表，并且包含name、email和password这三个字段。请根据您的实际数据库配置（如用户名、密码和数据库名）以及表结构进行相应的调整。这个示例假设您已经有了一个名为users的表，并且表中有name、email和password这三个字段。在实际应用中，您可能需要添加额外的安全措施，如密码散列等。提示：AI自动生成，仅供参考'''
以下创建数据表
创建数据表
CREATE TABLE `users` (`id` int(11) NOT NULL AUTO_INCREMENT,`name` varchar(100) NOT NULL DEFAULT '',`email` varchar(100) NOT NULL DEFAULT '',`password` varchar(255) NOT NULL DEFAULT '',`create_time` datetime NOT NULL,PRIMARY KEY (`id`),KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;以下测试结果
cmd下测试
E:\pytest>user_mysql.py
ID: 2, Name:test, Email: test@example.com,Password: 111111E:\pytest>user_mysql.py
User deleted successfullyE:\pytest>user_mysql.py
ID: 1, Name:Alice, Email: alice@example.com,Password: password123
ID: 2, Name:test, Email: test@example.com,Password: 111111
ID: 3, Name:zhangsan, Email: zhangsan@example.com,Password: 123456
