Python 添加与查询数据
import pymysql;
def add():
print("请输入用户信息:")
name = input("姓名:")
sex = input("性别:")
age = input("年龄:")
phone = input("电话号码:")
conn = pymysql.connect(host = "localhost",port = 3306,user = "root",password = "root",database = "USER_DB")
cursor = conn.cursor()
try:
sql = "insert into user(name,sex,age,phone) values(%s,%s,%s,%s)"
cursor.execute(sql,(name,sex,age,phone))
conn.commit()
print("添加用户信息成功!")
finally:
conn.close()
def display():
print("用户信息如下:")
print("编号\t姓名\t性别\t年龄\t电话号码\n")
conn = pymysql.connect(host = "localhost",port = 3306,user = "root",password = "root",database = "USER_DB")
cursor = conn.cursor()
try:
cursor.execute("SELECT * FROM user")
for r in cursor:
print("%d\t%s\t%s\t%s\t%s\n" %(r[0],str(r[1]),str(r[2]),str(r[3]),str(r[4])))
finally:
cursor.close()
conn.close()
def main():
nSelection = -1
while(nSelection != 0):
print("----------------")
print("1.添加用户信息")
print("2.查询用户信息")
print("0.退出")
nSelection = int(input("请输入操作编号:"))
if(nSelection == 1):
add()
elif(nSelection == 2):
display()
elif(nSelection == 0):
break
print("退出")
else:
print("输入的编号错误!")
if __name__ == '__main__':
main()