通过用户模型,对数据库进行增删改查操作
2017-11-17 16:14 095罗其婷 阅读(238) 评论(0) 编辑 收藏 举报增加: user = 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()
class User(db.Model):
__tablename__='user'
id=db.Column(db.Integer,primary_key=True,autioncrement=True)
username=db.Column(db.String(20),nullable=False)
password = db.Column(db.String(20), nullable=False)
#增加
user=User(username='papikk',password='1234598')
db.session.add(user)
db.session.commit()
#查询
user=User.query.filter(User.username == 'papikk').first()
print(user.username,user.password)
#修改
user=User.query.filter(User.username == 'papikk').first()
user.password=8888888
db.session.commit()
print(user.password)
#删除
user=User.query.filter(User.username == 'papikk').first()
db.session.delete(user)
db.session.commit()