# 导入Flask对象导入数据库 from flask import Flask render_template request redirect import pymysql # 使用Flask对象创建一个app对象 app = Flask__name__ approuteaddprinter methods=GET POST def add_printer device_list =
在前端代码中，输入框的name属性为“model”，但在后端代码中获取值时使用的是“model_name”，这是不一致的，需要将后端代码中的变量名改为“model”。修改后的代码如下：
# 导入Flask对象，导入数据库
from flask import Flask, render_template, request, redirect
import pymysql
# 使用Flask对象创建一个app对象
app = Flask(__name__)
@app.route("/addprinter", methods=["GET", "POST"])
def add_printer():
device_list = [] #打印机情报
if request.method == "GET":
return render_template("addprinter.html")
print(request.form)
device_id = request.form.get("device_id")
arr_data = request.form.get("arr_data")
device_sn = request.form.get("device_sn")
buy_dept = request.form.get("buy_dept")
catalog = request.form.get("catalog")
series = request.form.get("series")
model = request.form.get("model")
location = request.form.get("location")
location_detail = request.form.get("location_detail")
device_status = request.form.get("device_status")
stock_status = request.form.get("stock_status")
borrower = request.form.get("borrower")
borrow_data = request.form.get("borrow_data")
print("网页上返回arr_data:", arr_data, "网页上返回device_sn:", device_sn, buy_dept, catalog, model) # test输出
#连结数据库
conn = pymysql.connect(host="localhost", user="root", password="1111", db="demo")
cursor = conn.cursor()
# 使用 execute() 方法执行 SQL 查询
sql = "INSERT INTO devices (device_id, arr_data,device_sn,buy_dept, catalog, series, model, location, " \
"location_detail, device_status, stock_status, borrower, borrow_data) " \
"VALUES(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)"
cursor.execute(sql, [device_id, arr_data, device_sn, buy_dept, catalog, series, model, location, location_detail,
device_status, stock_status, borrower, borrow_data])
conn.commit()
# 关闭连接
cursor.close()
conn.close()
return "xxx"
if __name__ == "__main__":
app.run()
同时，还需要将前端代码中的“model_name”改为“model”。修改后的代码如下：
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Title</title>
</head>
<body>
<!--测试已经成功入库的代码
<form method="post" action="/addprinter">
<p>情报入力</p>
<p align="right">
<input type="submit" name="save" id="save" value="保存">
</p>
<p>序 号 <input type="text" name="device_id"></p>
<p>到达日期 <input type="date" name="arr_data"></p>
<p>番 号<input type="text" name="device_sn"></p>
<p>购入部门<input type="text" name="buy_dept"></p>
</form>
-->
<form name="form3" method="post" action="/addprinter">
<h5> </h5>
<h5>情报入力</h5>
<h5> </h5>
<p style="float:right">
<input class="btn btn-primary" type="submit" name="save" id="save" value="保存">
</p>
<p>机器 ID <input type="text" name="device_id"></p>
<p>到达日期 <input type="date" name="arr_data"></p>
<p>序列 号 <input type="text" name="device_sn"></p>
<p>购入部门 <input type="text" name="buy_dept"></p>
<p>分 类
<input type="radio" name="catalog" value="喷墨机">
<input type="radio" name="catalog" value="激光机">
<input type="radio" name="catalog" value="扫描仪">
</p>
<p>系 类 <input type="text" name="series"></p>
<p>型 号 <input type="text" name="model"></p>
<p>放置场所 <input type="text" name="location"></p>
<p>详细场所 <input type="text" name="location_detail"></p>
<p>机器状态
<input type="radio" name="device_status" value="正常">
<input type="radio" name="device_status" value="已损坏">
</p>
<p>在库状态
<input type="radio" name="stock_status" value="在库">
<input type="radio" name="stock_status" value="借出">
<input type="radio" name="stock_status" value="废弃">
</p>
<p>借用 人 <input type="text" name="borrower"></p>
<p>借用日期 <input type="date" name="borrow_data"></p>
</form>
</body>
</html>
原文地址: http://www.cveoy.top/t/topic/bzlg 著作权归作者所有。请勿转载和采集!