前后端开发草稿

app.py

from flask import Flask,request,jsonify
from markupsafe import escape
from flask_cors import CORS,cross_origin

app=Flask(__name__)
CORS(app, supports_credentials=True)

@app.route('/login',methods=['POST'])
def login():
    data=request.json
    username=data['name']
    password=data['password']
    if username=='wzy' and password=='123':
        return {
                    'result':True,
                    'error':None
                }
    else:
        return {
                    'result':False,
                    'error':'Wrong username or password!'
                }



if __name__=="__main__":
    app.run(debug=True, use_debugger=False, use_reloader=False)

login.html

    
        
        
    

    
        
            Name : 
            
        
        
            Password : 
            
        
        
            Login
                
    

commands

create database TEST_USER;
show databases;
use test_user;
select database();
create table user(
    -> name char(20) not null,
    -> password char(20) not null);
insert user values("wzy","123");

pymysql-test

import pymysql

db = pymysql.connect(host=‘localhost’,
user=‘wzy’,
password=‘1234’,
database=‘test_user’)

cursor = db.cursor()

sql = "SELECT * FROM user"
try:
   cursor.execute(sql)
   results = cursor.fetchall()
   for row in results:
      name = row[0]
      password = row[1]
      print('name=%s, password=%s' % (name,password))
except:
   print ("Error: unable to fetch data")
 
db.close()