通过用户模型，对数据库进行增删改查操作。

增加：
db.session.add(user)
db.session.commit()

查询：
User.query.filter(User.username == 'mis1114').first()

修改：
user.password = '111111'
db.session.commit()

删除：
db.session.delete(user)
db.session.commit()

 1 from flask import Flask,render_template,request
 2 from flask_sqlalchemy import SQLAlchemy
 3 import config
 4 
 5 app = Flask(__name__)
 6 app.config.from_object(config)
 7 db = SQLAlchemy(app)
 8 
 9 class User(db.Model):
10     __tablename__ = 'user'
11     id = db.Column(db.Integer,primary_key=True,autoincrement=True)
12     username = db.Column(db.String(20),nullable=False)
13     password = db.Column(db.String(20),nullable=False)
14     # nickname=db.Column(db.String(20))
15 
16 # 数据更改
17 user=User.query.filter(User.username=='xiaojiaoya').first()
18 user.password='970420'
19 db.session.commit()
20 # 数据查询
21 user=User.query.filter(User.username=='xiaojiaoya').first()
22 print(user.username,user.password)
23 # 数据删除
24 user = User.query.filter(User.username=='xiaojiaoya').first()
25 db.session.delete(user)
26 db.session.commit()
27 # 数据添加
28 user=User(username='xiaojiaoya',password='xiaojiaoya')
29 db.session.add(user)
30 db.session.commit()
31 db.create_all()
32 
33 @app.route('/')
34 def index():
35     return render_template('switch切换.html')
36 
37 @app.route('/login/', methods = ['GET','POST'])
38 def login():
39     return render_template('login登录.html')
40 
41 @app.route('/regist/', methods = ['GET','POST'])
42 def regist():
43     if request.method == 'GET':
44         return render_template('regist注册.html')
45     else:
46         pass
47 
48 
49 
50 if __name__ == '__main__':
51     app.run(debug=True)

posted on 2017-11-15 15:57 051刘佳铃阅读(154) 评论(0) 收藏举报