How to use Python to develop the personnel management function of CMS system

How to use Python to develop the personnel management function of the CMS system

CMS (Content Management System) system is a software tool used to manage website content. Through a CMS system, website administrators can easily edit, publish and manage website content. The personnel management function is an indispensable part of the CMS system, which involves the administrator's operations such as creating, modifying, and deleting user accounts. This article will introduce how to use Python to develop the personnel management function of the CMS system and provide corresponding code examples.

1. Design the database structure

Before starting development, you first need to design the structure of the database. In the example of this article, we will use the MySQL database and design the following table structure:

1. User table (user)

Field	Type	Description
id	int	User ID
username	varchar	username
password	varchar	Password
email	varchar	EMAIL
role	varchar	role
create_at	timestamp	Creation time
update_at	timestamp	Last updated time

2. Role table (role)

Field	Type	Description
id	int	Role ID
name	varchar	Role name

2. Create a database connection class

Next, we need to create a database connection class for interacting with the database. First, we need to install the MySQL Python driver package mysql-connector-python:

pip install mysql-connector-python

Then, create a Database class and connect to the database in the initialization method Settings:

import mysql.connector

class Database:
    def __init__(self):
        self.conn = mysql.connector.connect(
            host='localhost',
            user='root',
            password='password',
            database='cms_system'
        )
        self.cursor = self.conn.cursor()

    def __del__(self):
        self.conn.close()

3. Add user function implementation

Next, we can start adding user function implementation. First, we need to add a method to the Database class for creating users:

def create_user(self, username, password, email, role):
    sql = f"INSERT INTO user (username, password, email, role) VALUES ('{username}', '{password}', '{email}', '{role}')"
    self.cursor.execute(sql)
    self.conn.commit()

Then, we can write a simple command line program to test the function of creating users:

def main():
    db = Database()
    username = input("请输入用户名：")
    password = input("请输入密码：")
    email = input("请输入邮箱：")
    role = input("请输入角色：")
    db.create_user(username, password, email, role)
    print("用户创建成功！")

if __name__ == '__main__':
    main()

After running the program, enter the corresponding user information to create a new user in the database.

4. Implementation of modifying user function

Next, we can continue to implement the function of modifying user. Add a method to the Database class to modify user information:

def update_user(self, user_id, email, role):
    sql = f"UPDATE user SET email='{email}', role='{role}' WHERE id={user_id}"
    self.cursor.execute(sql)
    self.conn.commit()

Write a command line program again to test the function of modifying users:

def main():
    db = Database()
    user_id = input("请输入用户ID：")
    email = input("请输入新的邮箱：")
    role = input("请输入新的角色：")
    db.update_user(user_id, email, role)
    print("用户信息修改成功！")

if __name__ == '__main__':
    main()

After running the program, enter the user ID to be modified and the new mailbox and role to update the corresponding user information in the database.

5. Implementation of deleting user function

Finally, we can realize the function of deleting user. Add a method to the Database class for deleting users:

def delete_user(self, user_id):
    sql = f"DELETE FROM user WHERE id={user_id}"
    self.cursor.execute(sql)
    self.conn.commit()

Write a command line program again to test the function of deleting users:

def main():
    db = Database()
    user_id = input("请输入用户ID：")
    db.delete_user(user_id)
    print("用户删除成功！")

if __name__ == '__main__':
    main()

Run the program After that, enter the user ID to be deleted to delete the corresponding user in the database.

Through the above steps, we have implemented the personnel management function of a simple CMS system. Through Python development, we can easily operate the database and create, modify and delete users. In the actual development process, we can add more functions according to needs and carry out corresponding optimization and expansion. I hope this article can help you understand and master the personnel management functions of the CMS system!

The above is the detailed content of How to use Python to develop the personnel management function of CMS system. For more information, please follow other related articles on the PHP Chinese website!