主程序代码编写
import os,time,datetime,sys,random,math
from PyQt5.QtWidgets import *
from PyQt5.QtGui import *
from PyQt5 import QtWidgets,QtGui
from PyQt5.QtCore import *
from Ui_info5 import Ui_MainWindow
from functools import partial
#导入数据库
from PyQt5 import QtSql
from PyQt5.QtSql import QSqlQuery
class Mywindow(Ui_MainWindow,QMainWindow):
def __init__(self):
super().__init__()
self.setupUi(self)
self.tableWidget.setRowCount(10)
self.current_page = 1
# 设置槽函数
self.pushButton.clicked.connect(self.charu)
self.pushButton.clicked.connect(partial(self.showdb, 0))
# self.pushButton_2.clicked.connect(self.renewtb)
self.pushButton_3.clicked.connect(partial(self.showdb, 0)) #首页
self.pushButton_4.clicked.connect(self.prepage) #上一页
self.pushButton_5.clicked.connect(self.nextpage) #下一页
self.pushButton_6.clicked.connect(partial(self.tbnum, 1)) #尾页
self.pushButton_7.clicked.connect(self.gotopage) #跳转页数
#链接sqlite数据库
self.database = QtSql.QSqlDatabase.addDatabase('QSQLITE')
self.database.setDatabaseName('test.db') #如果没有该文件则自动创建
self.database.open()
# self.table()
self.showdb(0)
self.tbnum(0)
#下一页
def nextpage(self):
n = (self.current_page)*10
if self.current_page > (self.total_page - 1):
Msg = Message()
Msg.msg2('已经最后一页了')
return
self.showdb(n)
self.current_page = self.current_page + 1
self.label_8.setText(str(self.current_page))
#上一页
def prepage(self):
n = (self.current_page-2)*10
if self.current_page < 2:
Msg = Message()
Msg.msg2('已经是第一页了')
return
self.showdb(n)
if n==0:
self.current_page = 1
self.label_8.setText(str(self.current_page))
else:
self.current_page = self.current_page - 1
self.label_8.setText(str(self.current_page))
#跳转指定页数
def gotopage(self):
the_page = int(self.lineEdit_3.text()) #获取页数
the_n = (the_page-1)*10
if the_page <= 0 or the_page > self.total_page:
#如果输入的数值超出范围，提示错误
Msg = Message()
Msg.msg2('输入的数值超出了范围,请重新输入')
else:
self.showdb(the_n)
self.label_8.setText(self.lineEdit_3.text())
self.current_page = the_page
#表格获取总条目 页数
def tbnum(self,x):
#获取总条目
query = QSqlQuery()
if query.exec('select * from person ORDER BY ID DESC'):
id_index = query.record().indexOf('id')
db_list = []
while query.next():
id = query.value(id_index)
db_list.append((id))
# print('总条目：'+ str(len(db_list)))
self.total_page = math.ceil(len(db_list) / 10)
self.label_5.setText('共'+str(self.total_page)+'页')
if x == 1: #点击尾页显示的数据
n = int(self.total_page-1)*10
self.showdb(n)
self.label_8.setText(str(self.total_page))
self.current_page = self.total_page
#可自定义表格
def table(self):
self.tableWidget.setColumnCount(3)
self.tableWidget.setRowCount(2)
j = 0#第几行（从0开始）
i = 0#第几列（从0开始）
Value = "test"#内容
self.tableWidget.setItem(j, i, QTableWidgetItem(Value))#设置j行i列的内容为Value
self.tableWidget.setColumnWidth(j,80)#设置j列的宽度
self.tableWidget.setRowHeight(i,50)#设置i行的高度
self.tableWidget.verticalHeader().setVisible(False)#隐藏垂直表头
self.tableWidget.horizontalHeader().setVisible(False)#隐藏水平表头
#表格刷新数据
def renewtb(self):
self.showdb()
#数据展示在表格上
def showdb(self,n):
query = QSqlQuery()
if query.exec('select * from person ORDER BY ID DESC limit {},10'.format(str(n))):
id_index = query.record().indexOf('id')
name_index = query.record().indexOf('name')
age_index = query.record().indexOf('age')
sex_index = query.record().indexOf('sex')
nr_index = query.record().indexOf('nr')
db = []
while query.next():
id = query.value(id_index)
name = query.value(name_index)
age = query.value(age_index)
sex = query.value(sex_index)
nr = query.value(nr_index)
# print(id,name,age,sex,nr)
db.append((id,name,age,sex,nr))
# print(db)
self.tableWidget.clearContents()#清除所有数据--不包括标题头
if n == 0:
self.label_8.setText('1')
self.current_page = 1
else:
self.label_8.setText(str(self.current_page))
self.tbnum(0)
for i in range(len(db)): #i是行数
# print(db[i])
# print(db[i][0])
self.tableWidget.setItem(i, 0, QTableWidgetItem(str(db[i][0])))
self.tableWidget.setItem(i, 1, QTableWidgetItem(db[i][1]))
self.tableWidget.setItem(i, 2, QTableWidgetItem(db[i][2]))
self.tableWidget.setItem(i, 3, QTableWidgetItem(db[i][3]))
self.tableWidget.setItem(i, 4, QTableWidgetItem(db[i][4]))#设置j行i列的内容为Value
#查询数据
def chaxundb(self):
query = QSqlQuery()
if query.exec('select * from person'):
id_index = query.record().indexOf('id')
name_index = query.record().indexOf('name')
age_index = query.record().indexOf('age')
sex_index = query.record().indexOf('sex')
nr_index = query.record().indexOf('nr')
db = []
while query.next():
id = query.value(id_index)
name = query.value(name_index)
age = query.value(age_index)
sex = query.value(sex_index)
nr = query.value(nr_index)
# print(id,name,age,sex,nr)
db.append((id,name,age,sex,nr))
print(db)
#插入数据
def charu(self):
query = QSqlQuery()
the_name = self.lineEdit.text() #获取姓名
the_age = self.lineEdit_2.text() #获取年龄
the_input = self.textEdit.toPlainText() #获取内容框的值
if self.radioButton.isChecked()==True: #判断性别
the_sex = '男'
else:
the_sex = '女'
print(the_sex)
sql_code ='INSERT INTO person (name,age,sex,nr) VALUES ("{}","{}","{}","{}")'.format(the_name,the_age,the_sex,the_input)
if query.exec_(sql_code):
print('succeed insert data')
Msg = Message()
Msg.msg2('添加成功')
self.lineEdit.setText('')
self.lineEdit_2.setText('')
self.textEdit.setText('')
#删除数据
def deletedb(self):
query = QSqlQuery()
sql_code ='DELETE FROM person WHERE ID = 7'
if query.exec_(sql_code):
print('Delete data Success')
#更新数据
def update(self):
query = QSqlQuery()
sql_code ='UPDATE person SET name = "DUU",age="18",sex="女",nr="哈哈哈从成功了" WHERE ID = 6'
if query.exec_(sql_code):
print('succeed update data')
#提示信息
#这里是消息提示弹出框的主要代码
class Message(QtWidgets.QWidget):
def __init__(self):
super().__init__()
#消息提示框
def msg(self):
QMessageBox.information(self,"提示框","复制成功")
# QMessageBox.question(self,"消息框标题","这是一条问答。")
# QMessageBox.information(self,"消息框标题","这是一条消息。")
def msg2(self,word):
QMessageBox.warning(self,"提示框",word)
if __name__ == '__main__':
app = QApplication(sys.argv)
MainWindow = Mywindow()
MainWindow.show()
sys.exit(app.exec_())
UI界面程序 designer设计好界面生成Ui_info5.py
# -*- coding: utf-8 -*-
# Form implementation generated from reading ui file 'f:\pydemo\Gui_Pyqt5\info5.ui'
#
# Created by: PyQt5 UI code generator 5.13.0
#
# WARNING! All changes made in this file will be lost!
from PyQt5 import QtCore, QtGui, QtWidgets
class Ui_MainWindow(object):
def setupUi(self, MainWindow):
MainWindow.setObjectName("MainWindow")
MainWindow.resize(800, 600)
self.centralwidget = QtWidgets.QWidget(MainWindow)
self.centralwidget.setObjectName("centralwidget")
self.tabWidget = QtWidgets.QTabWidget(self.centralwidget)
self.tabWidget.setGeometry(QtCore.QRect(20, 20, 761, 521))
self.tabWidget.setObjectName("tabWidget")
self.tab = QtWidgets.QWidget()
self.tab.setObjectName("tab")
self.lineEdit = QtWidgets.QLineEdit(self.tab)
self.lineEdit.setGeometry(QtCore.QRect(120, 50, 331, 41))
self.lineEdit.setObjectName("lineEdit")
self.label = QtWidgets.QLabel(self.tab)
self.label.setGeometry(QtCore.QRect(70, 60, 54, 12))
self.label.setObjectName("label")
self.label_2 = QtWidgets.QLabel(self.tab)
self.label_2.setGeometry(QtCore.QRect(70, 150, 54, 12))
self.label_2.setObjectName("label_2")
self.lineEdit_2 = QtWidgets.QLineEdit(self.tab)
self.lineEdit_2.setGeometry(QtCore.QRect(120, 140, 331, 41))
self.lineEdit_2.setObjectName("lineEdit_2")
self.radioButton = QtWidgets.QRadioButton(self.tab)
self.radioButton.setGeometry(QtCore.QRect(120, 220, 89, 16))
self.radioButton.setChecked(True)
self.radioButton.setObjectName("radioButton")
self.label_3 = QtWidgets.QLabel(self.tab)
self.label_3.setGeometry(QtCore.QRect(70, 220, 54, 12))
self.label_3.setObjectName("label_3")
self.radioButton_2 = QtWidgets.QRadioButton(self.tab)
self.radioButton_2.setGeometry(QtCore.QRect(210, 220, 89, 16))
self.radioButton_2.setObjectName("radioButton_2")
self.label_4 = QtWidgets.QLabel(self.tab)
self.label_4.setGeometry(QtCore.QRect(70, 290, 54, 12))
self.label_4.setObjectName("label_4")
self.textEdit = QtWidgets.QTextEdit(self.tab)
self.textEdit.setGeometry(QtCore.QRect(120, 280, 541, 121))
self.textEdit.setObjectName("textEdit")
self.pushButton = QtWidgets.QPushButton(self.tab)
self.pushButton.setGeometry(QtCore.QRect(120, 430, 141, 51))
self.pushButton.setObjectName("pushButton")
self.tabWidget.addTab(self.tab, "")
self.widget = QtWidgets.QWidget()
self.widget.setObjectName("widget")
self.tableWidget = QtWidgets.QTableWidget(self.widget)
self.tableWidget.setGeometry(QtCore.QRect(0, 0, 761, 501))
self.tableWidget.setObjectName("tableWidget")
self.tableWidget.setColumnCount(5)
self.tableWidget.setRowCount(10)
item = QtWidgets.QTableWidgetItem()
self.tableWidget.setVerticalHeaderItem(0, item)
item = QtWidgets.QTableWidgetItem()
self.tableWidget.setVerticalHeaderItem(1, item)
item = QtWidgets.QTableWidgetItem()
self.tableWidget.setVerticalHeaderItem(2, item)
item = QtWidgets.QTableWidgetItem()
self.tableWidget.setVerticalHeaderItem(3, item)
item = QtWidgets.QTableWidgetItem()
self.tableWidget.setVerticalHeaderItem(4, item)
item = QtWidgets.QTableWidgetItem()
self.tableWidget.setVerticalHeaderItem(5, item)
item = QtWidgets.QTableWidgetItem()
self.tableWidget.setVerticalHeaderItem(6, item)
item = QtWidgets.QTableWidgetItem()
self.tableWidget.setVerticalHeaderItem(7, item)
item = QtWidgets.QTableWidgetItem()
self.tableWidget.setVerticalHeaderItem(8, item)
item = QtWidgets.QTableWidgetItem()
self.tableWidget.setVerticalHeaderItem(9, item)
item = QtWidgets.QTableWidgetItem()
self.tableWidget.setHorizontalHeaderItem(0, item)
item = QtWidgets.QTableWidgetItem()
self.tableWidget.setHorizontalHeaderItem(1, item)
item = QtWidgets.QTableWidgetItem()
self.tableWidget.setHorizontalHeaderItem(2, item)
item = QtWidgets.QTableWidgetItem()
self.tableWidget.setHorizontalHeaderItem(3, item)
item = QtWidgets.QTableWidgetItem()
self.tableWidget.setHorizontalHeaderItem(4, item)
item = QtWidgets.QTableWidgetItem()
item.setTextAlignment(QtCore.Qt.AlignCenter)
self.tableWidget.setItem(0, 0, item)
item = QtWidgets.QTableWidgetItem()
self.tableWidget.setItem(1, 1, item)
self.pushButton_2 = QtWidgets.QPushButton(self.widget)
self.pushButton_2.setGeometry(QtCore.QRect(590, 40, 101, 41))
self.pushButton_2.setObjectName("pushButton_2")
self.pushButton_3 = QtWidgets.QPushButton(self.widget)
self.pushButton_3.setGeometry(QtCore.QRect(40, 370, 75, 23))
self.pushButton_3.setObjectName("pushButton_3")
self.pushButton_4 = QtWidgets.QPushButton(self.widget)
self.pushButton_4.setGeometry(QtCore.QRect(130, 370, 75, 23))
self.pushButton_4.setObjectName("pushButton_4")
self.pushButton_5 = QtWidgets.QPushButton(self.widget)
self.pushButton_5.setGeometry(QtCore.QRect(240, 370, 75, 23))
self.pushButton_5.setObjectName("pushButton_5")
self.pushButton_6 = QtWidgets.QPushButton(self.widget)
self.pushButton_6.setGeometry(QtCore.QRect(330, 370, 75, 23))
self.pushButton_6.setObjectName("pushButton_6")
self.label_5 = QtWidgets.QLabel(self.widget)
self.label_5.setGeometry(QtCore.QRect(420, 372, 54, 20))
self.label_5.setObjectName("label_5")
self.label_6 = QtWidgets.QLabel(self.widget)
self.label_6.setGeometry(QtCore.QRect(470, 370, 51, 21))
self.label_6.setObjectName("label_6")
self.lineEdit_3 = QtWidgets.QLineEdit(self.widget)
self.lineEdit_3.setGeometry(QtCore.QRect(500, 370, 41, 20))
self.lineEdit_3.setObjectName("lineEdit_3")
self.label_7 = QtWidgets.QLabel(self.widget)
self.label_7.setGeometry(QtCore.QRect(550, 372, 54, 20))
self.label_7.setObjectName("label_7")
self.pushButton_7 = QtWidgets.QPushButton(self.widget)
self.pushButton_7.setGeometry(QtCore.QRect(570, 370, 75, 23))
self.pushButton_7.setObjectName("pushButton_7")
self.label_8 = QtWidgets.QLabel(self.widget)
self.label_8.setGeometry(QtCore.QRect(220, 372, 16, 20))
self.label_8.setObjectName("label_8")
self.tabWidget.addTab(self.widget, "")
MainWindow.setCentralWidget(self.centralwidget)
self.menubar = QtWidgets.QMenuBar(MainWindow)
self.menubar.setGeometry(QtCore.QRect(0, 0, 800, 23))
self.menubar.setObjectName("menubar")
MainWindow.setMenuBar(self.menubar)
self.statusbar = QtWidgets.QStatusBar(MainWindow)
self.statusbar.setObjectName("statusbar")
MainWindow.setStatusBar(self.statusbar)
self.retranslateUi(MainWindow)
self.tabWidget.setCurrentIndex(1)
QtCore.QMetaObject.connectSlotsByName(MainWindow)
def retranslateUi(self, MainWindow):
_translate = QtCore.QCoreApplication.translate
MainWindow.setWindowTitle(_translate("MainWindow", "信息录入系统"))
self.label.setText(_translate("MainWindow", "姓名"))
self.label_2.setText(_translate("MainWindow", "年龄"))
self.radioButton.setText(_translate("MainWindow", "男"))
self.label_3.setText(_translate("MainWindow", "性别"))
self.radioButton_2.setText(_translate("MainWindow", "女"))
self.label_4.setText(_translate("MainWindow", "内容"))
self.pushButton.setText(_translate("MainWindow", "提交"))
self.tabWidget.setTabText(self.tabWidget.indexOf(self.tab), _translate("MainWindow", "录入信息"))
item = self.tableWidget.verticalHeaderItem(0)
item.setText(_translate("MainWindow", "1"))
item = self.tableWidget.verticalHeaderItem(1)
item.setText(_translate("MainWindow", "2"))
item = self.tableWidget.verticalHeaderItem(2)
item.setText(_translate("MainWindow", "3"))
item = self.tableWidget.verticalHeaderItem(3)
item.setText(_translate("MainWindow", "4"))
item = self.tableWidget.verticalHeaderItem(4)
item.setText(_translate("MainWindow", "5"))
item = self.tableWidget.verticalHeaderItem(5)
item.setText(_translate("MainWindow", "6"))
item = self.tableWidget.verticalHeaderItem(6)
item.setText(_translate("MainWindow", "7"))
item = self.tableWidget.verticalHeaderItem(7)
item.setText(_translate("MainWindow", "8"))
item = self.tableWidget.verticalHeaderItem(8)
item.setText(_translate("MainWindow", "9"))
item = self.tableWidget.verticalHeaderItem(9)
item.setText(_translate("MainWindow", "10"))
item = self.tableWidget.horizontalHeaderItem(0)
item.setText(_translate("MainWindow", "ID"))
item = self.tableWidget.horizontalHeaderItem(1)
item.setText(_translate("MainWindow", "姓名"))
item = self.tableWidget.horizontalHeaderItem(2)
item.setText(_translate("MainWindow", "年龄"))
item = self.tableWidget.horizontalHeaderItem(3)
item.setText(_translate("MainWindow", "性别"))
item = self.tableWidget.horizontalHeaderItem(4)
item.setText(_translate("MainWindow", "内容"))
__sortingEnabled = self.tableWidget.isSortingEnabled()
self.tableWidget.setSortingEnabled(False)
self.tableWidget.setSortingEnabled(__sortingEnabled)
self.pushButton_2.setText(_translate("MainWindow", "刷新数据"))
self.pushButton_3.setText(_translate("MainWindow", "首页"))
self.pushButton_4.setText(_translate("MainWindow", "<上一页"))
self.pushButton_5.setText(_translate("MainWindow", "下一页>"))
self.pushButton_6.setText(_translate("MainWindow", "尾页"))
self.label_5.setText(_translate("MainWindow", "共10页"))
self.label_6.setText(_translate("MainWindow", "跳到"))
self.label_7.setText(_translate("MainWindow", "页"))
self.pushButton_7.setText(_translate("MainWindow", "确定"))
self.label_8.setText(_translate("MainWindow", "4"))
self.tabWidget.setTabText(self.tabWidget.indexOf(self.widget), _translate("MainWindow", "信息列表"))
文件下载
注意：因为我的电脑是64位的，所以生成的文件也是64位的可执行程序，在32位的电脑上是无法运行的，32位的程序打包方法可以参考下面的文章