1. 数据库准备至少15个学生的信息，测试数据文件中准备30个学生的ID；[1,2,3,4,。。。。。30]
      针对Student进行查询操作，调用selectStudent方法，采用5个子线程进行处理
      待查询的学生ID存放在列表中，5个子线程各自分配一批学生ID进行查询操作，
      第一个子线程：获取ID%5==1的ID号
      第二个子线程：获取ID%5==2的ID号
      第三个子线程：获取ID%5==3的ID号
      第四个子线程：获取ID%5==4的ID号
      第五个子线程：获取ID%5==0的ID号
      如果查询到相应的结果，将学生ID记录到一个公共的列表中，没有查询到的学生ID记录到另外一个公共的列表中
       屏幕打印最终的查询结果情况。
      # foundList=[] notFoundList=[]_ ```python import threading class DBOperation: @staticmethod def openDB(host, user, pwd, port, db):

      1.  import pymysql
      2.  dbObj = pymysql.connect(host=host, user=user, password=pwd, port=int(port), db=db, charset='utf8')
      3.  curObj = dbObj.cursor()  # 生成游标对象
      4.  return dbObj, curObj

      @staticmethod def readDB(curObj, sql):

      1.  curObj.execute(sql)
      2.  result = curObj.fetchall()  # 提取查询结果的所有记录
      3.  return result

    foundList=[] notFouldList=[] class Student: def init(self): self.dbObj, self.curObj = DBOperation.openDB(‘localhost’, ‘root’, ‘root’, 3306, ‘school’)

    1. def searchStu(self,stuList):
    2.     for sid in stuList:
    3.         sql='select * from student where sid='+str(sid)
    4.         result=DBOperation.readDB(self.curObj,sql)
    5.         if len(result)==0:
    6.             notFouldList.append(sid)
    7.         else:
    8.             foundList.append(sid)

    if name == ‘main‘: list1=[] list2=[] list3=[] list4=[] list5=[] for sid in range(1,31): if sid%5==0: list1.append(sid) elif sid%5==1: list2.append(sid) elif sid%5==2: list3.append(sid) elif sid%5==3: list4.append(sid) elif sid%5==4: list5.append(sid) mylist=[list1,list2,list3,list4,list5] print(list1,list2,list3,list4,list5) thList=[] for i in range(5): th = threading.Thread(target=Student().searchStu,args=(mylist[i],)) thList.append(th)

    1. for th in thList:
    2.     th.start()
    4. for th in thList:
    5.     th.join()
    7. print(foundList, notFouldList)
    1. ```python
    2. import threading
    3. class DBOperation:
    4.     @staticmethod
    5.     def openDB(host, user, pwd, port, db):
    6.         import pymysql
    7.         dbObj = pymysql.connect(host=host, user=user, password=pwd, port=int(port), db=db, charset='utf8')
    8.         curObj = dbObj.cursor()  # 生成游标对象
    9.         return dbObj, curObj
    11.     @staticmethod
    12.     def readDB(curObj, sql):
    13.         curObj.execute(sql)
    14.         result = curObj.fetchall()  # 提取查询结果的所有记录
    15.         return result
    17. foundList=[]
    18. notFouldList=[]
    19. class Student:
    20.     def __init__(self):
    21.         self.dbObj,self.curObj=DBOperation.openDB('localhost','root','root',3306,'school')
    23.     def searchStu(self,stuList):
    24.         for sid in stuList:
    25.             sql='select * from student where sid='+str(sid)
    26.             result=DBOperation.readDB(self.curObj,sql)
    27.             if len(result)==0:
    28.                 notFouldList.append(sid)
    29.             else:
    30.                 foundList.append(sid)
    32. if __name__ == '__main__':
    34.     list1=[]
    35.     list2=[]
    36.     list3=[]
    37.     list4=[]
    38.     list5=[]
    39.     for sid in range(1,31):
    40.         if sid%5==0:
    41.             list1.append(sid)
    42.         elif sid%5==1:
    43.             list2.append(sid)
    44.         elif sid%5==2:
    45.             list3.append(sid)
    46.         elif sid%5==3:
    47.             list4.append(sid)
    48.         elif sid%5==4:
    49.             list5.append(sid)
    50.     print(list1,list2,list3,list4,list5)
    52.     th1 = threading.Thread(target=Student().searchStu,args=(list1,))
    53.     th2 = threading.Thread(target=Student().searchStu, args=(list2,))
    54.     th3 = threading.Thread(target=Student().searchStu, args=(list3,))
    55.     th4 = threading.Thread(target=Student().searchStu, args=(list4,))
    56.     th5 = threading.Thread(target=Student().searchStu, args=(list5,))
    58.     th1.start()
    59.     th2.start()
    60.     th3.start()
    61.     th4.start()
    62.     th5.start()
    63.     th1.join()
    64.     th2.join()
    65.     th3.join()
    66.     th4.join()
    67.     th5.join()
    69.     print(foundList, notFouldList)