python实现信息管理系统
时间: 2024-01-21 22:15:19 浏览: 25
以下是一个简单的Python实现的信息管理系统的例子:
```python
import pymysql
# 连接数据库
def connect_db():
conn = pymysql.connect(host='localhost', user='root', password='password', database='mydb')
return conn
# 创建表
def create_table(conn):
cursor = conn.cursor()
sql = '''
CREATE TABLE IF NOT EXISTS student (
id INT PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(50),
age INT,
gender VARCHAR(10)
)
'''
cursor.execute(sql)
conn.commit()
# 插入数据
def insert_data(conn, name, age, gender):
cursor = conn.cursor()
sql = '''
INSERT INTO student (name, age, gender) VALUES (%s, %s, %s)
'''
cursor.execute(sql, (name, age, gender))
conn.commit()
# 查询数据
def query_data(conn):
cursor = conn.cursor()
sql = '''
SELECT * FROM student
'''
cursor.execute(sql)
result = cursor.fetchall()
for row in result:
print(row)
# 更新数据
def update_data(conn, id, name):
cursor = conn.cursor()
sql = '''
UPDATE student SET name = %s WHERE id = %s
'''
cursor.execute(sql, (name, id))
conn.commit()
# 删除数据
def delete_data(conn, id):
cursor = conn.cursor()
sql = '''
DELETE FROM student WHERE id = %s
'''
cursor.execute(sql, (id,))
conn.commit()
# 主函数
def main():
conn = connect_db()
create_table(conn)
insert_data(conn, 'Alice', 20, 'Female')
insert_data(conn, 'Bob', 22, 'Male')
query_data(conn)
update_data(conn, 1, 'Alex')
delete_data(conn, 2)
query_data(conn)
conn.close()
if __name__ == '__main__':
main()
```
相关推荐
![py](https://img-home.csdnimg.cn/images/20210720083646.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)