1 from flask import Flask, request,redirect,url_for
2 from flask import render_template
3 from flask_sqlalchemy import SQLAlchemy
4 import config
5
6 app=Flask(__name__)
7 app.config.from_object(config)
8 db=SQLAlchemy(app)
9
10 class User(db.Model):
11 __tablename__='user'
12 id=db.Column(db.Integer,primary_key=TabError,autoincrement=True)
13 username=db.Column(db.String(20),nullable=False)
14 password=db.Column(db.String(20),nullable=False)
15
16 '''
17 db.create_all()
18
19
20 # 数据添加
21 user=User(username='hh',password='gg')
22 db.session.add(user)
23 db.session.commit()
24
25 # 数据更改
26 user = User.query.filter(User.username=='hh').first()
27 user.password='0000'
28 db.session.commit()
29
30 # 数据删除
31 user = User.query.filter(User.username=='hh').first()
32 db.session.delete(user)
33 db.session.commit()
34
35 # 数据查询
36 user = User.query.filter(User.username=='hh').first()
37 print(user.username,user.password)
38 '''
39
40 app = Flask(__name__)
41 @app.route('/')
42 def switch():
43 return render_template('moban.html')
44 @app.route('/login/')
45 def login():
46 return render_template('login.html')
47 @app.route('/register/',methods=['GET','POST'])
48 def register():
49 if request.method=='GET':
50 return render_template('register.html')
51 else:
52 username=request.form.get('username')
53 password = request.form.get('password')
54 nickname = request.form.get('nickname')
55 user=User.query.filter(User.username==username).first()
56 if user:
57 return 'username existed'
58 else:
59 user=User(username='hh',password='gg')
60 db.session.add(user)
61 db.session.commit()
62 return redirect(url_for('login'))
63
64 if __name__ == '__main__':
65 app.run(debug=True)
66 if __name__ == '__main__':
67 app.run()
