11.21

from flask import Flask,render_template,request,redirect,url_for,session
from flask_sqlalchemy import SQLAlchemy
import config

app = Flask(__name__)
app.config.from_object(config)
db=SQLAlchemy(app)

# class SQLALchemy(object):
#     pass



class User(db.Model):
    _tablename_ = ‘user‘
    id = db.Column(db.Integer,primary_key=True,autoincrement=True)
    username = db.Column(db.String(20),nullable=False)
    password = db.Column(db.String(20), nullable=False)
    nickname = db.Column(db.String(20))


@app.route(‘/‘)
def index():
    return render_template(‘index.html‘)


@app.route(‘/login/‘, methods=[‘GET‘, ‘POST‘])
def login():
    if request.method == ‘GET‘:
        return render_template(‘login.html‘)
    else:
        username = request.form.get(‘username‘)
        password = request.form.get(‘password‘)
        # nickname=request.form.get(‘nickname‘)
        user = User.query.filter(User.username == username).first()
        if user:
            session[‘user‘]=username
            session.permanent=True
            return redirect(url_for(‘daohang‘))
        else:
            return ‘error username or password‘

        return redirect(url_for(‘daohang‘))

    @app.route(‘/regist/‘, methods=[‘GET‘, ‘POST‘])
    def regist():
        if request.method == ‘GET‘:
            return render_template(‘regist.html‘)
        else:
            username = request.form.get(‘username‘)
            password = request.form.get(‘password‘)

            user = User.query.filter(User.username == username).first()
            if user:
                return ‘username existed‘
            else:
                user = User(username=username, password=password)
                db.session.add(user)
                db.session.commit()
                return redirect(url_for(‘login‘))

            @app.route(‘/biaoqian/‘)
            def biaoqian():
                return render_template(‘biaoqian.html‘)


if __name__ == ‘__main__‘:
    app.run()

import os
SECRET_KEY = os.urandom(24)
DIALECT=‘mysql‘
DRIVER=‘mysqldb‘
USERNAME=‘root‘
PASSWORD=‘ROOT‘
HOST=‘127.0.0.1‘
PORT=‘3306‘
DATABASE=‘mis_db‘

SQLALCHEMY_DATABASE_URI = ‘mysql+pymysql://root:@127.0.0.1:3306/test?charset=utf8‘
SQLALCHEMY_TRACK_MODIFICATIONS = False

function config() {
    var oUname = document.getElementById("uname");
    var oUpass = document.getElementById("upass");
    var oUpass1 = document.getElementById("upass1");
    var oError = document.getElementById("error_box");
    oError.innerHTML = "<br>";
    if (oUname.value.length < 6 || oUname.value.length > 20) {
        oError.innerHTML = "用户名要6-20之位";
        return;
    } else if ((oUname.value.charCodeAt(0) >= 48) && (oUname.value.charCodeAt(0) <= 57)) {
        oError.innerHTML = "首字母不能为数字";
        return;
    } else for (var i = 0; i < oUname.value.length; i++) {
        if ((oUname.value.charCodeAt(i) < 48) || (oUname.value.charCodeAt(i) > 57) && ((oUname.value.charCodeAt(i) < 97)) || oUname.value.charCodeAt(i) > 122) {
            oError.innerHTML = "只能填写数字或字母";
            return;
        }
    }
// oUpass
    if (oUpass.value.length < 6 || oUpass.value.length > 20) {
        oError.innerHTML = "密码要6-20位";
        return;
    }
    else if (oUpass.value !== oUpass1.value) {
        oError.innerHTML = "两次密码不一致";
        return false;
    }
    return true;
    window.alert("注册成功")

}

{% extends ‘base.html‘ %}
{% block title %}注册{% endblock %}
{% block head %}
    <link rel="stylesheet" type="text/css" href="{{ url_for(‘static‘,filename=‘css/zhuce.css‘) }}">
    <script src="{{ url_for(‘static‘,filename=‘js/zhuce.js‘) }}"></script>
{% endblock %}

{% block main %}
    <div class="box">
        <h2>注册</h2>
        <form action="{{ url_for(‘zhuce‘) }}" method="post">
            <div class="input_box">
                <input id="uname" type="text" placeholder="请输入用户名" name="username">
            </div>
            <div class="input_box">
                <input id="upass" type="password" placeholder="请输入密码" name="password">
            </div>
            <div class="input_box">
                <input id="upass1" type="password" placeholder="请再次输入密码">
            </div>
            <div id="error_box"><br></div>
            <div class="input_box">
                <button onclick="fnzhuce()">注册</button>
            </div>
        </form>
    </div>
{% endblock %}