2018-09-30

#新增

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