基于mysql的信息管理系统Python代码
时间: 2024-06-17 10:01:04 浏览: 16
基于MySQL的信息管理系统通常涉及到数据库连接、查询操作、数据处理和用户界面展示等部分。在Python中,我们可以使用像`mysql-connector-python`这样的库来连接MySQL数据库,而Flask或Django这样的Web框架可以帮助构建用户界面。以下是一个简单的基于Python和Flask的数据库操作示例:
```python
# 导入必要的库
from flask import Flask, render_template, request
import mysql.connector
from mysql.connector import Error
# 初始化Flask应用
app = Flask(__name__)
# 数据库连接信息
config = {
'user': 'your_username',
'password': 'your_password',
'host': 'localhost',
'database': 'your_database'
}
# 连接数据库
def create_connection():
try:
connection = mysql.connector.connect(**config)
return connection
except Error as e:
print("Error while connecting to MySQL", e)
@app.route('/')
def index():
# 如果连接成功,获取数据
connection = create_connection()
if connection.is_connected():
cursor = connection.cursor()
cursor.execute("SELECT * FROM your_table")
rows = cursor.fetchall()
cursor.close()
connection.close()
else:
rows = []
return render_template('index.html', rows=rows)
@app.route('/add', methods=['POST'])
def add_data():
data = request.form
# 插入数据到数据库
connection = create_connection()
cursor = connection.cursor()
query = "INSERT INTO your_table (column1, column2) VALUES (%s, %s)"
cursor.execute(query, (data['column1'], data['column2']))
connection.commit()
cursor.close()
connection.close()
return "Data added successfully."
# 运行应用
if __name__ == '__main__':
app.run(debug=True)