コード例 #1
0
 def modify_clicked(self):
     # 连接数据库 把修改写进数据库
     # 首先获取文本框数据
     rem = Re_manager()
     name = self.user_lineEdit.text()  # 没有变,不需要加判断语句
     dept = self.dept_lineEdit.text()
     ip = self.ip_lineEdit.text()
     mac = self.mac_lineEdit.text()
     if dept == '' or ip == '' or mac == '':
         print('修改内容需要填写')
         reply = QMessageBox.about(self, '提示', '请完善修改内容')
     else:
         dept = rem.is_dept(dept)
         ip = rem.is_ip(ip)
         mac = rem.is_mac(mac)
         if dept == None or ip == None or mac == None:
             print('格式不符合要求')
             reply = QMessageBox.about(self, '提示', '请按照格式修改相关内容')
         else:
             # 将数据更新到数据库
             mm = Mysql_manager()
             with mm:
                 sql = 'update em_info set em_dept = %s,em_ip = %s,em_mac = %s where em_name = %s'
                 mm.db_exe(sql, (dept, ip, mac, name))
                 print('信息更新')
                 reply = QMessageBox.about(self, '提示', f'{name}的信息修改成功')
                 self.close()  # 修改完成关闭窗口,不然文本框还有内容不好处理
コード例 #2
0
 def register_clicked(self):  # 两个类的同名函数,测试同名函数的影响
     # 获取文本框值,先做正则判断,再写入数据库
     account = self.account_lineEdit.text()
     passwd = self.passwd_lineEdit.text()
     confirm = self.confirm_lineEdit.text()
     # 先判断输入不能为空 测试不配对else
     if account == '' or passwd == '' or confirm == '':
         print('输入不能为空')
         reply = QMessageBox.about(self, '提示', '输入不能为空')
     # 判断两次密码是否一致
     elif passwd != confirm:
         print('密码输入不一致')
         reply = QMessageBox.about(self, '提示', '密码输入不一致')
         # 判断是否符合正则,这里必须在else下面了。防止不必要的执行
     else:
         # 然后进行正则判断
         rem = Re_manager()
         account = rem.is_account(account)
         passwd = rem.is_passwd(passwd)
         if account == None or passwd == None:
             print('帐号或者密码不符合要求')
             reply = QMessageBox.about(self, '提示', '帐号或者密码不符合要求')
         else:
             mm = Mysql_manager()
             with mm:
                 sql = 'insert into user_info values(%s,%s,%s)'
                 mm.db_exe(sql, (account, passwd, 1))
                 print('帐号注册成功')
                 reply = QMessageBox.about(self, '提示', '帐号注册成功')
コード例 #3
0
 def query_clicked(self):
     if self.user_lineEdit == '' and self.ip_lineEdit == '':
         print('请输入查询条件')
     else:
         # 根据单选按钮判断
         mm = Mysql_manager()
         with mm:
             if self.name_radioButton.isChecked(
             ) == True:  # 注意这里的判断条件,后面括号不能少
                 sql = 'select * from em_info where em_name = %s'
                 name = self.user_lineEdit.text()
                 result = mm.db_exe(sql, name)
                 if mm.cur.rowcount == 0:
                     print('没有相关信息')
                     reply = QMessageBox.about(self, '提示', '查不到相关信息')
                 else:
                     # 这个时候把result发射到主窗口
                     print(type(result))
                     print(result)
                     self.mysignal.emit(result)
             else:  # 通过IP查询
                 sql = 'select * from em_info where em_ip = %s'
                 ip = self.ip_lineEdit.text()
                 print(f'this {ip}')
                 result = mm.db_exe(sql, ip)
                 if mm.cur.rowcount == 0:
                     print('没有相关信息')
                     reply = QMessageBox.about(self, '提示', '查不到相关IP信息')
                 else:
                     self.mysignal.emit(result)
コード例 #4
0
 def add_clicked(self):
     # 获取文本框的值
     name = self.user_lineEdit.text()
     dept = self.dept_lineEdit.text()
     ip = self.ip_lineEdit.text()
     mac = self.mac_lineEdit.text()
     # 进行输入值检查
     if name == '' or dept == '' or ip == '' or mac == '':
         print('关键项输入不能为空')
         reply = QMessageBox.about(self, '提示', '关键项输入不能为空')
     else:
         rem = Re_manager()
         name = rem.is_name(name)
         dept = rem.is_dept(dept)
         ip = rem.is_ip(ip)
         mac = rem.is_mac(mac)
         if name == None or dept == None or ip == None or mac == None:
             print('格式不符合要求')
             reply = QMessageBox.about(self, '提示', '格式不符合正则要求')
         else:
             # 都符合要求,准备写入数据库
             mm = Mysql_manager()
             with mm:
                 sql = 'insert into em_info values(%s,%s,%s,%s)'
                 mm.db_exe(sql, (name, dept, ip, mac))
                 print('添加信息成功')
                 reply = QMessageBox.about(self, '提示', '员工信息添加成功')
                 # 添加成功后清空文本框
                 self.user_lineEdit.setText('')
                 self.dept_lineEdit.setText('')
                 self.ip_lineEdit.setText('')
                 self.mac_lineEdit.setText('')
コード例 #5
0
 def login_clicked(self):
     # 首先从文本框获取值,然后交给正则类进行判断
     account = self.account_lineEdit.text()
     passwd = self.passwd_lineEdit.text()
     if account == '' or passwd == '':  # 第一层判断是否为空
         print('输入不能为空')
         reply = QMessageBox.about(self, '注意', '帐号或密码不能为空')
     else:
         rem = Re_manager()
         account = rem.is_account(account)  # 把自己传递进去做判断
         passwd = rem.is_passwd(passwd)
         # 测试
         print('**')
         print(passwd)
         if account == None or passwd == None:  # 第二层判断格式问题
             print('帐号或者密码格式错误')
             reply = QMessageBox.about(self, '注意', '帐号或者密码格式错误')
         else:
             # 第三层判断帐号或者密码是否正确
             mm = Mysql_manager()
             with mm:
                 sql = 'select * from user_info where user_name = %s and user_passwd = %s'
                 result = mm.db_exe(sql, (account, passwd))
                 if mm.cur.rowcount == 0:
                     print('帐号密码错误')
                     reply = QMessageBox.about(self, '注意', '帐号密码错误')
                 else:
                     print(result)
                     print('验证成功,可以登录')  # 这里才是跳转主窗口的语句模块
                     self.em = Em_manager()
                     self.em.show()
                     login.close()
コード例 #6
0
    def import_excel(self,path):
        # 表格对象
        self.wb = load_workbook(path)
        # 表单(子表)对象
        self.ws = self.wb.active
        
        # 建立数据库连接
        mm = Mysql_manager()
        sql = 'insert into em_info values(%s,%s,%s,%s)' 
        with mm:
            # 循环读出,循环写入
            row_num = self.ws.max_row # 获取子表行数
            print('测试')
            print(row_num)
            # 注意表格计数是从1开始,不是0
            for i in range(2,row_num+1):
                name = self.ws.cell(row = i,column = 1).value
                dept = self.ws.cell(row = i,column = 2).value
                ip = self.ws.cell(row = i,column = 3).value
                mac = self.ws.cell(row = i,column = 4).value

                mm.db_exe(sql,(name,dept,ip,mac))
                
                print('数据成功导入到数据库')
コード例 #7
0
 def del_clicked(self):
     name = self.user_lineEdit.text()
     ip = self.ip_lineEdit.text()
     if name == '' and ip == '':
         print('请至少输入一个条件')
         reply = QMessageBox.about(self, '提示', '至少输入一个条件来删除')
     else:
         # 正则判断
         mm = Mysql_manager()
         rem = Re_manager()
         name = rem.is_name(name)
         ip = rem.is_ip(ip)
         if name == None and ip == None:
             print('输入格式不正确')
             reply = QMessageBox.about(self, '提示', '输入格式不正确')
         elif name == None:  # 这里开始至少一个不为0
             with mm:
                 sql = 'delete from em_info where em_ip = %s'
                 mm.db_exe(sql, ip)
                 if mm.cur.rowcount == 0:
                     print('没有该IP相关信息')
                     reply = QMessageBox.about(self, '提示', '没有该IP的相关信息')
                 else:
                     print('删除成功')
                     reply = QMessageBox.about(self, '提示', f'{ip}的相关信息已删除')
         elif ip == None:
             with mm:
                 sql = 'delete from em_info where em_name = %s'
                 mm.db_exe(sql, name)
                 if mm.cur.rowcount == 0:
                     print('没有该员工信息')
                     reply = QMessageBox.about(self, '提示', '数据库没有该员工信息')
                 else:
                     print('删除成功')
                     reply = QMessageBox.about(self, '提示',
                                               f'{name}的相关信息已删除')
         else:  # 最后一种情况,两个文本框都有内容
             with mm:
                 sql = 'select * from em_info where em_name = %s and em_ip = %s'
                 mm.db_exe(sql, (name, ip))
                 if mm.cur.rowcount == 0:
                     print('没有相关信息')
                     reply = QMessageBox.about(self, '提示', '没有相关信息')
                 else:
                     print('删除成功')
                     reply = QMessageBox.about(self, '提示', '信息删除成功')
     # 无论如何,清空文本框
     self.user_lineEdit.setText('')
     self.ip_lineEdit.setText('')