### 使用Python和MySQL创建员工绩效考核管理系统 #### 创建数据库结构 为了建立一个有效的员工绩效考核管理系统，首先需要定义合适的数据库架构。这通常涉及多个表的设计来存储不同类型的关联数据。 对于员工信息可以设计如下SQL语句来创建`employees`表[^2]: ```sql CREATE TABLE employees ( id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(100), position VARCHAR(100), department_id INT, hire_date DATE ); ``` 针对绩效评估记录，则可创建名为`performance_reviews`的表: ```sql CREATE TABLE performance_reviews ( review_id INT AUTO_INCREMENT PRIMARY KEY, employee_id INT NOT NULL, reviewer_name VARCHAR(100), score DECIMAL(3, 2), -- 绩效评分范围可能是0到5之间的小数点后两位精度 comments TEXT, date_reviewed TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, FOREIGN KEY (employee_id) REFERENCES employees(id) ); ``` #### 编写Python脚本连接并操作MySQL数据库 利用Python中的`mysql.connector`库能够轻松地与MySQL服务器交互。下面是一个简单的例子展示怎样通过Python向上述两个表中插入新纪录: ```python import mysql.connector def add_employee(name, position, deptartment_id): conn = mysql.connector.connect( host="localhost", user="root", password="password", database="hr_system" ) cursor = conn.cursor() sql_query = "INSERT INTO employees (name, position, department_id) VALUES (%s, %s, %s)" values = (name, position, deptartment_id) try: cursor.execute(sql_query, values) conn.commit() print(f"{cursor.rowcount} record inserted.") except Exception as e: print(e) conn.rollback() finally: if(conn.is_connected()): cursor.close() conn.close() def log_performance_review(employee_id, reviewer_name, score, comment): conn = mysql.connector.connect( host="localhost", user="root", password="password", database="hr_system" ) cursor = conn.cursor() sql_query = """INSERT INTO performance_reviews (employee_id, reviewer_name, score, comments) VALUES (%s,%s,%s,%s);""" val = (employee_id, reviewer_name, score, comment) try: cursor.execute(sql_query,val) conn.commit() print(f"Review logged successfully.") except Exception as err: print(err) conn.rollback() finally: if(conn.is_connected()): cursor.close() conn.close() ``` 以上代码片段展示了基本的数据持久化逻辑；然而，在实际应用环境中还需要考虑更多因素如安全性、并发处理以及错误恢复机制等。