def getCourseInfo(student_id): conn = Connection.getConnection() cursor = conn.cursor() sql = "select * from course where course_id in \ (select course_id from selection where student_id = %d)"%(student_id) cursor.execute(sql) return cursor.fetchall()
def getSelectStudentNum(courseId):
conn = Connection.getConnection()
cursor = conn.cursor()
sql = "select count(*) from selection where course_id = %d" % (
courseId)
cursor.execute(sql)
return cursor.fetchone()[0]
def getStudentIdByUserName(username):
conn = Connection.getConnection()
cursor = conn.cursor()
sql = "select student_id from student_account where username = '******'" % (
username)
cursor.execute(sql)
return cursor.fetchone()[0]
def getSelectCourseNum(studentId):
conn = Connection.getConnection()
cursor = conn.cursor()
sql = "select count(*) from selection where student_id = %d" % (
studentId)
cursor.execute(sql)
result = cursor.fetchone()
return result[0]
def isAccountValid(username, password):
connection = Connection.getConnection()
cursor = connection.cursor()
sql = "select * from student_account where username = '******' and password = '******'" % (
username, password)
cursor.execute(sql)
resultList = cursor.fetchall()
return len(resultList) == 1
def selectCourse(student_id, course_id):
conn = Connection.getConnection()
cursor = conn.cursor()
sql = "select * from selection \
where student_id=%d and course_id=%d"%(student_id, course_id)
cursor.execute(sql)
if (len(cursor.fetchall()) == 0):
sql = "insert into selection values(%d, %d)"%(student_id, course_id)
cursor.execute(sql)
conn.commit()
return ('1', u"成功选择该课程")
else:
return ('0', u"已经选过该课程")
def quitCourse(student_id, course_id):
conn = Connection.getConnection()
cursor = conn.cursor()
sql = "select * from selection \
where student_id=%d and course_id=%d"%(student_id, course_id)
cursor.execute(sql)
if (len(cursor.fetchall()) > 0):
sql = "delete from selection \
where student_id=%d and course_id=%d"%(student_id, course_id)
cursor.execute(sql)
conn.commit()
return ('1', u"成功退选该课程")
else:
return ('0', u"没有选择该课程")
def getCourseInfoById(id): conn = Connection.getConnection() cursor = conn.cursor() sql = "select * from course where course_id = %d"%(id) cursor.execute(sql) return cursor.fetchall()
def getAllCourseInfo(): conn = Connection.getConnection() cursor = conn.cursor() sql = "select * from course" cursor.execute(sql) return cursor.fetchall()
# 生成账号信息
student_accounts = []
for i in range(0, 100):
student_accounts.append((student_id[i], 'test', student_id[i]))
# 生成工号
teacher_ids = np.arange(1, 11, 1)
# 随机生成教师信息
teacher_infos = []
for i in range(0, 10):
teacher_infos.append((teacher_ids[i], createName(), \
createGender(), u'电子科学与工程学院', \
createRank(), createPhoneNum()))
conn = Connection.getConnection()
cursor = conn.cursor()
cursor.execute("select * from teach")
resultList = cursor.fetchall()
# 生成课程信息
course_infos = [\
(1, u'计算方法', u'仙林校区 逸B-105', u'周二 第5-7节 1-18周', u'选修', u'电子科学与工程学院'), \
(2, u'微波测量实验', u'仙林校区 仙林电子楼239室', u'周五 第5-6节 1-18周', u'核心', u'电子科学与工程学院'), \
(3, u'操作系统', u'仙林校区 仙Ⅰ-115', u'周一 第3-4节 1-18周', u'选修', u'电子科学与工程学院'), \
(4, u'矩阵计算与应用', u'仙林校区 仙Ⅰ-115', u'周一 第9-10节 1-18周', u'选修', u'电子科学与工程学院'), \
(5, u'IT企业创业与发展战略', u'仙林校区 仙Ⅱ-304', u' 周二 第9-10节 1-18周', u'选修', u'电子科学与工程学院'), \
(6, u'数据通信', u'仙林校区 仙Ⅰ-206', u' 周四 第5-7节 1-18周', u'选修', u'电子科学与工程学院'), \
(7, u'微电子工艺', u'仙林校区 仙Ⅰ-104', u'周一 仙Ⅰ-104 1-18周', u'选修', u'电子科学与工程学院'), \
(8, u'数字集成电路设计', u'仙林校区 仙Ⅰ-115', u'周一 第5-7节 1-12周', u'选修', u'电子科学与工程学院'), \
(9, u'电子系统实践', u'仙林校区 仙Ⅰ-115 ', u'周一 第5-7节 1-12周', u'选修', u'电子科学与工程学院'), \
def getAllStudentInfo(): conn = Connection.getConnection() cursor = conn.cursor() sql = "select * from student" cursor.execute(sql) return cursor.fetchall()
