增加：
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 user = User(username = 'misjiaojiao',password = 'misjiaojiao')
2 db.session.add(user)
3 db.session.commit()
4 #增
5
6 user = User.query.filter(User.username == 'misjiaojiao').first()
7 db.session.delete(user)
8 db.session.commit()
9 #删
10
11 user = User.query.filter(User.username == 'misjiaojiao').first()
12 user.password='1234657'
13 db.session.commit()
14 #改
15
16 user = User.query.filter(User.username == 'misjiaojiao').first()
17 print(user.username,user,password)
18 #查
浙公网安备 33010602011771号