#新增
def Student(host,sex,age,phone,address,subject):
print(host,sex,age,phone,address,subject)
session=Session()
shuju=StudentUser(Name="%s"%host,Sex ="%s"%sex,Age ="%s"%age,
Phone ="%s"%phone,Address ="%s"%address,Subject ="%s"%subject
)
session.add(shuju)
session.commit()
session.close()
#查询
def Inquire():
session=Session()
query=session.query(StudentUser.Name,StudentUser.Sex
, StudentUser.Age,StudentUser.Phone
, StudentUser.Address,StudentUser.Subject)
s=query
print("Name\tSex\t\tAge\tPhone\tAddress\tSubject")
for iin query:
print("%-5s\t%-5s\t%-5s\t%-5s\t%-5s\t%-5s"%(i.Name,i.Sex,i.Age,i.Phone,i.Address,i.Subject))
#删除
def Delete(name):
session=Session()
#q=session.query(StudentUser).filter(StudentUser.Name==name).one()
q = session.query(StudentUser).get(name)
session.delete(q)
session.commit()
session.close()
return "删除编号为%s的学生成功"%name
#修改
def Update(id,host,sex,age,phone,address,subject):
session=Session()
q=session.query(StudentUser).filter(StudentUser.Id==id)
q.update({StudentUser.Name:host},{StudentUser.Sex:sex},{StudentUser.Age: age},
{StudentUser.Phone:phone},{StudentUser.Address: address},{StudentUser.Subject:subject})
session.commit()
session.close()
pass
