Object.py

import pymysql as pys
class User(object):
    def __init__(self,id,accountID,password,judge):
        self.id = id
        self.accountID = accountID
        self.password = password
        self.judge = judge

class Student(User):
    def __init__(self,id,name,sex,stuID,maxNum,nowNum):
        self.id = id
        self.name = name
        self.sex = sex
        self.stuID = stuID
        self.maxNum = maxNum
        self.nowNum = nowNum

class Book(object):
    def __init__(self,id,bookID,bookName,bookAuthor,bookPrice,bookType,time):
        self.id = id
        self.bookID = bookID
        self.bookName = bookName
        self.bookAuthor = bookAuthor
        self.bookPrice = bookPrice
        self.bookType = bookType
        self.time = time

class Borrow(object):
    def __init__(self,bookID,stuID,addTime,lastTime):
        self.bookID = bookID
        self.stuID = stuID
        self.addTime = addTime
        self.lastTime = lastTime 

class Examine(object):
    def __init__(self,id,stuID,stuName,type,bookName,bookAuthor,bookType):
        self.id = id
        self.stuID = stuID
        self.stuName = stuName
        self.type = type
        self.bookName = bookName
        self.bookAuthor = bookAuthor
        self.bookType = bookType

def ConntectDB():
    return pys.connect(
    host='localhost',
    user='root',
    password='123456789',
    database='lms',
    charset='utf8',
)