学生信息数据库增改记录程序

题目说明

import sqlite3
con = sqlite3.connect('students.db')
cursor = con.cursor()
cursor.execute('''
               CREATE TABLE IF NOT EXISTS users(  id     int(8) primary key,
                name   varchar(18),
                age    int(8))
                ''')
cursor.close()
con.commit()
con.close()
def user_insert(user_id, user_name, user_age):
    con = sqlite3.connect('students.db')
    cursor = con.cursor()
    cursor.execute("insert into users (id,name,age) values (?,?,?)", (user_id, user_name, user_age))
    cursor.close()
    con.commit()
    con.close()
def user_select():
    con = sqlite3.connect('           ①           ')
    cursor = con.cursor()
               ②            ('select * from users')
    print(cursor.fetchall())
    cursor.close()
    con.close()
def user_update(user_id, user_name, user_age):
    con = sqlite3.connect('students.db')
    cursor = con.cursor()
    cursor.execute('UPDATE users SET name=?,age=? WHERE id =?',(user_name, user_age,user_id))
    cursor.close()
    con.commit()
    con.close()
print("------------学生信息系统样例------------")
while True:
               ③
    s = int(input("请输入操作符：1-增加记录,2-修改记录,3-退出系统"))
    if            ④           :
         break
    user_id = int(input("请输入id:"))
    user_name = input("请输入name:")
    user_age = input("请输入age:")
    if s == 1:    # 增加记录
                  ⑤
        print("插入成功！")
elif s == 2:  # 修改记录
        user_update(user_id, user_name, user_age)
        print("修改成功！")