def search_school1():
cursor = db.cursor()
select = "SELECT name FROM university" #获取表中xxxxx记录数
cursor.execute(select) #执行sql语句
line = cursor.fetchone()
while line != None:
school1.append(line[0])
line = cursor.fetchone()
return school1
def search_school_xuke():
cursor = db.cursor()
select = 'select university_id , xueke_code from xueshuo_mid '
cursor.execute(select) # 执行sql语句
line = cursor.fetchone()
while line != None:
school_xuke.setdefault(line[0], []).append(line[1])
line = cursor.fetchone()
return school_xuke
def search_chanye():
cursor = db.cursor()
select = "SELECT id,name FROM industry" # 获取表中xxxxx记录数
cursor.execute(select) # 执行sql语句
line = cursor.fetchone()
while line != None:
chanye.append((line[0], line[1]))
line = cursor.fetchone()
return chanye
def search_xueke():
cursor = db.cursor()
select = "SELECT code,name FROM xueshuo" # 获取表中xxxxx记录数
cursor.execute(select) # 执行sql语句
line = cursor.fetchone()
while line != None:
xueshuo.append((line[0], line[1]))
line = cursor.fetchone()
return xueshuo
def search_chanye_zhuan():
cursor = db.cursor()
select = 'SELECT industry_id,zhuanye_code from bk_cy'
cursor.execute(select) # 执行sql语句
line = cursor.fetchone()
while line != None:
chanye_zhuanye.setdefault(line[0], []).append(line[1])
line = cursor.fetchone()
return chanye_zhuanye
