# Time: 2020/05/17
#Author: Xiaohong
# 运行环境: OS: Windows 7
# Python: 3.7
# 功能: 从sqilite3 DB 中取出数据,显示在QTable Widget 中
运行后的界面如下:
主界面脚本如下:
import sys
import sqlite3
from PyQt5.QtWidgets import *
from PyQt5 import QtGui, QtCore, QtWidgets
# from PyQt5.QtWidgets import QTableWidget, QProgressBar, QLineEdit, QComboBox, QFrame, QTableWidgetItem
from PyQt5.QtCore import *
from PyQt5.QtGui import *
# 这个test_pyqt是ui文件对应的py文件的文件名
from Ui_test02 import Ui_test_form1
# 我的Form是用的QWidget作为基类
# 全局字体
light_10_font = QtGui.QFont()
light_10_font.setFamily("微软雅黑 Light")
light_10_font.setPointSize(10)
light_10_font.setBold(False)
light_10_font.setWeight(50)
light_12_font = QtGui.QFont()
light_12_font.setFamily("微软雅黑 Light")
light_12_font.setPointSize(12)
light_12_font.setBold(False)
light_12_font.setWeight(50)
class MyWindow(QWidget, Ui_test_form1):
def __init__(self, parent=None):
super().__init__(parent)
self.setupUi(self)
self.SetDailyTableColumns()
self.btn_read.clicked.con