python 留言板 mysql_python+flask+mysql 实现简单留言板功能

python文件代码编写

from flask import Flask,render_template,request,jsonify

import requests,json,os,time,pymysql,datetime

app = Flask(__name__)

# 数据库配置

mysql_config={

'host':'localhost',

'port':3306,

'user':'root',

'password':'tan11300',

'db':'myblog',

}

@app.route('/bbs', methods=['POST'])

def bbs2():

# 创建连接

connection = pymysql.connect(**mysql_config)

data = json.loads(request.form.get('data'))

action = data['action']

if action == 1:

##########################增加数据

try:

with connection.cursor() as cursor:

#读取HTML页面数据

now = datetime.datetime.now()

data = json.loads(request.form.get('data'))

name = data['name']

nr = data['nr']

# 执行sql语句，插入记录

sql = 'INSERT INTO message (name, body, timestamp) VALUES (%s, %s, %s)'

cursor.execute(sql, (name, nr, now))

# 没有设置默认自动提交，需要主动提交，以保存所执行的语句

connection.commit()

return jsonify({"success": 200, "msg": "提交成功"})

finally:

connection.close()

elif action == 2:

#######################删除数据

try:

with connection.cursor() as cursor:

id = data['id']

sql = 'DELETE FROM message where `id` like (%s) '

cursor.execute(sql, (id))

# 没有设置默认自动提交，需要主动提交，以保存所执行的语句

con