增加：
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
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(50))
15
16
17 # db.create_all()
18
19 user = User.query.filter(User.username=='mis1555').first()
20 db.session.delete(user)
21 db.session.commit()
22
23 '''
24 user = User(username = 'mis1555',password = 'mis1555')
25 db.session.add(user)
26 db.session.commit()
27
28 user = User.query.filter(User.username=='mis1555').first()
29 user.password = '111111'
30 print(user.username,user.password)
31 db.session.commit()
32 '''
33
34 @app.route('/')
35 def hello_world():
36 return 'Hello World!'
37
38
39 if __name__ == '__main__':
40 app.run()
1 SQLALCHEMY_DATABASE_URI = 'mysql+pymysql://root:@127.0.0.1:3306/mis_db?charset=utf8'
2 SQLALCHEMY_TRACK_MODIFICATIONS = False
