mini-test for self leaning

import mysql.connector db_host = '10.211.74.58' db_port = 3306 db_name = 'ai_ly' db_username = 'root' db_password = 'Foxconn@admin2023' class DatabaseClass(object): def get_database_connection(self): # 创建数据库连接 connection = mysql.connector.connect( host=db_host, port=db_port, database=db_name, user=db_username, password=db_password ) # 创建游标 cursor = connection.cursor() return connection, cursor def validate_student_id(self, account_name): # 创建数据库连接和游标 connection, cursor = self.get_database_connection() # 查询数据库 sql_query = f""" SELECT * FROM ai_ly.info_user WHERE account_name = '{account_name}' """ cursor.execute(sql_query) result = cursor.fetchone() if result: validate_result = 1 else: validate_result = 0 # 关闭游标和连接（在MySQL中一般不需要显式关闭游标） cursor.close() connection.close() return validate_result if __name__ == '__main__': DB = DatabaseClass() result = DB.validate_student_id(account_name='test_1') print(result) # LINE_ID = 28736 # GROUP_FLAG = DB.LINE(LINE_ID) # print("GROUP_FLAG:", GROUP_FLAG)