check.py

import Object
import pymysql
import tkinter as tk
import tkinter.messagebox as msg
import begin
import users
import operation
from Object import ConntectDB

# conn = pymysql.connect(host='localhost', port=3306, db='lms', user='root', password='zhanglong4591.')
conn = ConntectDB()

def UserAdminer(ID, pow):#判断账号函数。
    cur = conn.cursor()
    cur.execute("select id, accountID, password, judge from account where accountID = %s" % ID)
    count = cur.fetchone()
    print(count)
    if count:
        if count[2] == pow:
            return Object.User(count[0], count[1], count[2], count[3])
        else:
            msg._show(title='错误!', message='账号或密码错误!')
    else:
        msg._show(title='错误!', message='账号不存在!')
    return


def skip(name, key):  # 比对密码
    user = UserAdminer(name, key)
    if user == None:
        pass
    else:
        if user.judge == 0:
            cur = conn.cursor()
            cur.execute('select  id ,name, sex, stuID, maxNum, nowNum from student where id = %s', user.id)
            count = cur.fetchone()
            stu = Object.Student(count[0], count[1], count[2], count[3], count[4],count[5])
            users.frame(stu)
        else:
            operation.frame()