Flask的框架搭建我就不在此详说了,CSDN上大佬有更详细的攻略
在此简单说下Flask的增删改查
增加我知道的方法有两种
第一种是批量插入,代码如下:
session.add_all([
User(name = "老张",age = 18,gender = "男",project = "python"),
User(name = "老李",age = 13,gender = "男",project = "python"),
User(name = "老王",age = 14,gender = "女",project = "java"),
User(name = "老赵",age = 15,gender = "男",project = "c++"),
User(name = "老孙",age = 16,gender = "女",project = "python"),
])
session.commit() #提交修改
第二种是具体插入到某个ID下,代码如下:
user = User(
id = 7,
name = "老六",
age = 17,
gender = "男",
project = "python"
)
session.add(user)
session.commit() #提交修改
然后是查询了,查询的方法我知道的有四种
第一种是查询表内所有数据:
all_data = session.query(User).all()
print(all_data)
第二种是筛选查询,就是查询表内符合某个特定的条件的数据:
all_data = session.query(User).filter_by(age = 18,name = "老张")
for data in all_data:
print(data.name,data.gender)
第三种是查询多个符合条件的第一个
laozhang = session.query(User).filter_by(age = 18,name = "老张").first()
print(laozhang.name)
第四种是get方法查询,但查询的条件必须为主键
laozhang = session.query(User).get(ident = 7)
print(laozhang.name)
然后就是删除的方法了
第一种是查到具体某条然后删除:
laozhang = session.query(User).filter_by(age = 16).first()
session.delete(laozhang)
session.commit() #提交修改
第二种是批量删除,删除表内所有18岁的:
laozhang = session.query(User).filter_by(age = 18)
for zhang in laozhang:
session.delete(zhang)
session.commit() #提交修改
最后就是改了
改一条或者多条其实差不多,就是先查询到某条数据,然后直接改就好了,代码如下:
laozhang = session.query(User).filter_by(age = 19).first()
laozhang.name = "老白"
session.commit() #提交修改