使用flask+sqlite注册账号时报错tableuserhasnocolumnnamed'xxx'？

from flask import Flask,render_template

from flask import request

import sqlite3

app = Flask(__name__)

app.config.update(dict(

    SECRET_KEY = 'NI CAI CAI KAN'

    ))

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

def Home():

    return "

Welcome to home.Please login

"



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

def login():

    cOnn= sqlite3.connect('user.db')

    cu = conn.cursor()

    try:

        cu.execute("create table user(users text primary key not null,\

                                      pass text not null)")

    except sqlite3.OperationalError:

        pass

    if request.method == 'POST':

        u = request.form['username']

        p = request.form['password']

        cu.execute('select *from user where users=%s' %(u))

        data = cu.fetchone()

        if u==data[0] and p==data[1]:

            return 'Login!'

        elif u!=data[0] or p != data[1]:

            return '

Username or password error!

'

        else:

            return '

Please sign up!

'

    if request.method == 'GET':

        return render_template("login.html")

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

def register():

    cOnn= sqlite3.connect('user.db')

    cu = conn.cursor()

    try:

        cu.execute("create table user(user text primary key not null,\

                                      pass text not null)")

    except sqlite3.OperationalError:

        pass

    if request.method == 'GET':

        return render_template('register.html')

    if request.method == 'POST':

        u = request.form['username']

        p = request.form['password']

        cu.execute('insert into user(users,pass) values(%s,%s)' %(u,p))

        conn.commit()

        return '

register!

'

if __name__ == '__main__':

    app.run(debug=True)

         

         

         

register