import sqlite3
from PyQt5 import QtWidgets, uic
import sys
from PyQt5.QtWidgets import QApplication, QMainWindow, QDialog, QFileDialog, QMessageBox
import newproject
db = sqlite3.connect('database.db')
cursor = db.cursor()
cursor.execute('''CREATE TABLE IF NOT EXISTS users(
login TEXT,
password TEXT
)''')
db.commit()
for i in cursor.execute('SELECT * FROM users'):
print(i)
db1 = sqlite3.connect('databasepassw.db')
sq = db1.cursor()
cursor.execute('''CREATE TABLE IF NOT EXISTS pass(
platform TEXT,
login TEXT,
password TEXT
)''')
db1.commit()
class Registration(QtWidgets.QMainWindow, newproject.Ui_MainWindow):
def __init__(self):
super(Registration, self).__init__()
self.setupUi(self)
self.label.setText('')
self.label_2.setText('Регистрация')
self.lineEdit.setPlaceholderText('Придумайте логин')
self.lineEdit_2.setPlaceholderText('Придумайте пароль')
self.pushButton.setText('Регистрация')
self.pushButton_2.setText('Вход')
self.setWindowTitle('Войти в систему')
self.pushButton.pressed.connect(self.reg)
self.pushButton_2.pressed.connect(self.login)
def login(self):
self.login = Login()
self.login.show()
self.hide()
def reg(self):
user_login = self.lineEdit.text()
user_password = self.lineEdit_2.text()
if len(user_login) == 0:
return
if len(user_password) == 0:
return
cursor.execute(f'SELECT login FROM users WHERE login="{user_login}"')
if cursor.fetchone() is None:
cursor.execute(f'INSERT INTO users VALUES ("{user_login}", "{user_password}")')
self.label.setText(f'Аккаунт {user_login} успешно зарегистрирован!')
db.commit()
self.hide()
self.Menu = MenuWindow()
self.Menu.show()
else:
self.label.setText('Такая записать уже имеется!')
class Login(QtWidgets.QMainWindow, newproject.Ui_MainWindow):
def __init__(self):
super(Login, self).__init__()
self.setupUi(self)
self.label.setText('')
self.label_2.setText('Вход')
self.lineEdit.setPlaceholderText('Введите логин')
self.lineEdit_2.setPlaceholderText('Введите пароль')
self.pushButton.setText('Вход')
self.pushButton_2.setText('Регистрация')
self.setWindowTitle('Войти в систему')
self.pushButton.pressed.connect(self.login)
self.pushButton_2.pressed.connect(self.reg)
def reg(self):
self.reg = Registration()
self.reg.show()
self.hide()
def login(self):
user_login = self.lineEdit.text()
user_password = self.lineEdit_2.text()
if len(user_login) == 0:
return
if len(user_password) == 0:
return
cursor.execute(f'SELECT password FROM users WHERE login="{user_login}"')
check_pass = cursor.fetchall()
cursor.execute(f'SELECT login FROM users WHERE login="{user_login}"')
check_login = cursor.fetchall()
if check_pass[0][0] == user_password and check_login[0][0] == user_login:
self.label.setText('Успешная авторизация!')
self.Menu = MenuWindow()
self.Menu.show()
self.hide()
else:
self.label.setText('Ошибка авторизации!')
class MenuWindow(QMainWindow):
def __init__(self):
super(MenuWindow, self).__init__()
uic.loadUi('NEW_chosing.ui', self)
self.pushButton_nazad.clicked.connect(self.login)
self.pushButton1.setText("Добавить\n пароль")
self.pushButton1.clicked.connect(self.add_pass)
self.pushButton2.clicked.connect(self.show_pass)
self.setWindowTitle('Выберите действие')
def login(self):
self.login = Login()
self.login.show()
self.hide()
def add_pass(self):
self.add_pass = AddPassword()
self.add_pass.show()
self.hide()
def show_pass(self):
self.show_pass = ChekingPassword()
self.show_pass.show()
self.hide()
class AddPassword(QMainWindow):
def __init__(self):
super(AddPassword, self).__init__()
uic.loadUi('choose1.ui', self)
self.pushButton_nazad.clicked.connect(self.menu)
self.setWindowTitle('Добавить пароль')
self.pushButton_dobavit.clicked.connect(self.adding_pass)
def menu(self):
self.menu = MenuWindow()
self.menu.show()
self.hide()
def adding_pass(self):
platform = self.lineEdit_platform.text()
login = self.lineEdit_login.text()
password = self.lineEdit_password.text()
if len(platform) == 0:
return
if len(login) == 0:
return
if len(password) == 0:
return
cursor.execute(f'SELECT platform FROM pass WHERE platform="{platform}"')
if cursor.fetchone() is None:
cursor.execute(f'INSERT INTO pass VALUES ("{platform}", "{login}", "{password}")')
self.title_2.setText(f'Аккаунт {platform} успешно зарегистрирован!')
self.listWidget.addItem(f"{platform}; {login}; {password}")
db.commit()
class ChekingPassword(QMainWindow):
def __init__(self):
super(ChekingPassword, self).__init__()
uic.loadUi('chekingnew.ui', self)
self.pushButton_nazad.clicked.connect(self.menu)
self.setWindowTitle('Сохраненные пароли')
def menu(self):
self.menu = MenuWindow()
self.menu.show()
self.hide()
if __name__ == '__main__':
app = QApplication(sys.argv)
log = Login()
log.show()
sys.exit(app.exec_())
#окно таблицы(chekingnew)
from PyQt5 import QtCore, QtGui, QtWidgets
class Ui_MainWindow(object):
def setupUi(self, MainWindow):
MainWindow.setObjectName("MainWindow")
MainWindow.resize(500, 400)
MainWindow.setStyleSheet("background-color: qlineargradient(spread:repeat, x1:0, y1:0, x2:1, y2:0, stop:0 rgba(153, 153, 230, 255), stop:1 rgba(255, 191, 191, 255));")
self.centralwidget = QtWidgets.QWidget(MainWindow)
self.centralwidget.setObjectName("centralwidget")
self.pushButton_dobavit = QtWidgets.QPushButton(self.centralwidget)
self.pushButton_dobavit.setGeometry(QtCore.QRect(120, 340, 90, 30))
font = QtGui.QFont()
font.setFamily("Arial")
font.setPointSize(12)
font.setBold(True)
font.setWeight(75)
self.pushButton_dobavit.setFont(font)
self.pushButton_dobavit.setStyleSheet("QPushButton{\n"
" color: rgb(74, 78, 145);\n"
" border: 2px solid ; \n"
" border-color: qlineargradient(spread:repeat, x1:0, y1:0, x2:1,
y2:0, stop:0 rgba(74, 111, 230, 255), stop:1 rgba(255, 144, 144,
255));\n"
"}\n"
"QPushButton:hover{\n"
" \n"
" \n"
" background-color: qlineargradient(spread:repeat, x1:0, y1:0, x2:1,
y2:0, stop:0 rgba(138, 138, 230, 255), stop:1 rgba(255, 171, 171,
255));\n"
"}")
self.pushButton_dobavit.setObjectName("pushButton_dobavit")
self.pushButton_nazad = QtWidgets.QPushButton(self.centralwidget)
self.pushButton_nazad.setGeometry(QtCore.QRect(20, 340, 90, 30))
font = QtGui.QFont()
font.setFamily("Arial")
font.setPointSize(12)
font.setBold(True)
font.setWeight(75)
self.pushButton_nazad.setFont(font)
self.pushButton_nazad.setStyleSheet("QPushButton{\n"
" color: rgb(74, 78, 145);\n"
" border: 2px solid ; \n"
" border-color: qlineargradient(spread:repeat, x1:0, y1:0, x2:1,
y2:0, stop:0 rgba(74, 111, 230, 255), stop:1 rgba(255, 144, 144,
255));\n"
"}\n"
"QPushButton:hover{\n"
" \n"
" \n"
" background-color: qlineargradient(spread:repeat, x1:0, y1:0, x2:1,
y2:0, stop:0 rgba(138, 138, 230, 255), stop:1 rgba(255, 171, 171,
255));\n"
"}")
self.pushButton_nazad.setObjectName("pushButton_nazad")
self.tableWidget = QtWidgets.QTableWidget(self.centralwidget)
self.tableWidget.setGeometry(QtCore.QRect(50, 50, 400, 260))
self.tableWidget.setObjectName("tableWidget")
self.tableWidget.setColumnCount(0)
self.tableWidget.setRowCount(0)
MainWindow.setCentralWidget(self.centralwidget)
self.retranslateUi(MainWindow)
QtCore.QMetaObject.connectSlotsByName(MainWindow)
def retranslateUi(self, MainWindow):
_translate = QtCore.QCoreApplication.translate
MainWindow.setWindowTitle(_translate("MainWindow", "MainWindow"))
self.pushButton_dobavit.setText(_translate("MainWindow", "Удалить"))
self.pushButton_nazad.setText(_translate("MainWindow", "Назад"))
if __name__ == "__main__":
import sys
app = QtWidgets.QApplication(sys.argv)
MainWindow = QtWidgets.QMainWindow()
ui = Ui_MainWindow()
ui.setupUi(MainWindow)
MainWindow.show()
sys.exit(app.exec_())