导入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()