python学习：python做一个用户管理系统操作mysql

今天继续学习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 conn
    except Error as e:
        print(f"Error connecting to the database: {e}")

def create_user(name, email, password, create_time):

    #print(create_time)
    #return False

    conn =  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 Error
 
def connect_to_database():
    try:
        connection = mysql.connector.connect(
            host='localhost',
            user='yourusername',
            password='yourpassword',
            database='yourdatabase'
        )
        return connection
    except 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: 111111

E:\pytest>user_mysql.py
User deleted successfully

E:\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