本篇文章给大家谈谈编程小游戏教程跑酷游戏,以及编程小游戏制作教程简单,希望对各位有所帮助,不要忘了收藏本站喔。
#-*- coding:utf-8 -*-
import sqlite3
#打开本地数据库用于存储用户信息
cx = sqlite3.connect('')
#在该数据库下创建学生信息表
cx.execute ('''CREATE TABLE StudentTable( ID INTEGER PRIMARY KEY AUTOINCREMENT, StuId INTEGER NOT NULL, NAME TEXT NOT NULL, CLASS INT NOT NULL);''')
print "Table created successfully";
#在该数据库下创建课程信息表
cx.execute ('''CREATE TABLE CourseTable( ID INTEGER PRIMARY KEY AUTOINCREMENT, CourseId INT NOT NULL, Name TEXT NOT NULL, Teacher TEXT NOT NULL, Classroom TEXT NOT NULL, StartTime CHAR(11) NOT NULL, EndTime CHAR(11) NOT NULL);''')
print "Table created successfully";
#在该数据库下创建选课情况信息表
cx.execute ('''CREATE TABLE XuankeTable( ID INTEGER PRIMARY KEY AUTOINCREMENT, StuId INT NOT NULL, CourseId INT NOT NULL);''')
print "Table created successfully";
#以上三个表创建完后,再次运行程序时,需要把三个建表代码注释掉,否则会提示:该表已存在。即建表只需建一次。
cx = sqlite3.connect('')
def insert_stu():#录入学生信息
cu = cx.cursor()
stu_id = input("请输入学生学号:")
cu.execute("SELECT StuId from StudentTable where StuId = '%s';"%stu_id)
row = cu.fetchone()
if row:
print "sorry,该学号已存在,请重新输入"
else:
stu_name = raw_input("请输入学生姓名:")
stu_class = input("请输入学生班级:")
sql1 = "INSERT INTO StudentTable(StuId,NAME,CLASS)"
sql1 += " VALUES(%d,'%s',%d);"%(stu_id,stu_name,stu_class)
cu.execute(sql1)
cx.commit()
print "恭喜你,学生录入成功!"
cu.close()
cx = sqlite3.connect('stud