mysql代码:创建mysql数据库的代码已集成在python代码中。
使用PyQt5编写可视化界面,感兴趣的请先了解pyqt5的安装及基本使用。
项目结构:
1.pyqt5界面设计:
2.程序code:
untitled.py主程序入口:
# -*- coding: utf-8 -*-
# Form implementation generated from reading ui file 'untitled.ui'
#
# Created by: PyQt5 UI code generator 5.10.1
#
# WARNING! All changes made in this file will be lost!
import sys
from PyQt5 import QtCore, QtGui, QtWidgets
from PyQt5.QtCore import QStringListModel, Qt, pyqtSignal
from PyQt5.QtWidgets import QMessageBox, QWidget
from 大数据资讯快抓.getdata import *
class Ui_mainWindow(object):
def setupUi(self, mainWindow):
mainWindow.setObjectName("mainWindow")
mainWindow.resize(640, 560)
mainWindow.setMinimumSize(QtCore.QSize(640, 560))
mainWindow.setMaximumSize(QtCore.QSize(640, 560))
self.centralwidget = QtWidgets.QWidget(mainWindow)
self.centralwidget.setMinimumSize(QtCore.QSize(640, 560))
self.centralwidget.setMaximumSize(QtCore.QSize(640, 560))
self.centralwidget.setObjectName("centralwidget")
# 显示顶部图片
self.top_widget = QtWidgets.QWidget(self.centralwidget)
self.top_widget.setGeometry(QtCore.QRect(0, 0, 640, 120))
self.top_widget.setMinimumSize(QtCore.QSize(640, 120))
self.top_widget.setMaximumSize(QtCore.QSize(640, 120))
self.top_widget.setStyleSheet("image: url(:/png/bg1.png);\n"
"background-image: url(:/png/bg2.png);")
self.top_widget.setObjectName("top_widget")
# 数据库参数模块
self.db_widget = QtWidgets.QWidget(self.centralwidget)
self.db_widget.setGeometry(QtCore.QRect(0, 120, 640, 120))
self.db_widget.setStyleSheet("background-image: url(:/png/bg2.png);")
self.db_widget.setObjectName("db_widget")
# 数据库参数
self.db_set = QtWidgets.QLabel(self.db_widget)
self.db_set.setGeometry(QtCore.QRect(10, 15, 64, 12))
self.db_set.setObjectName("db_set")
self.db_set.setFont(self.getFont())
# 数据库地址
self.db_addr = QtWidgets.QLabel(self.db_widget)
self.db_addr.setGeometry(QtCore.QRect(10, 40, 64, 12))
self.db_addr.setObjectName("db_addr")
self.db_addr.setFont(self.getFont())
# 数据库地址输入框
self.db_addr_edit = QtWidgets.QTextEdit(self.db_widget)
self.db_addr_edit.setGeometry(QtCore.QRect(80, 35, 150, 24))
self.db_addr_edit.setStyleSheet("background-image: url(:/png/bg3.png);")
self.db_addr_edit.setObjectName("db_addr_edit")
self.db_addr_edit.setFont(self.getFont())
# 数据库端口号
self.db_port = QtWidgets.QLabel(self.db_widget)
self.db_port.setGeometry(QtCore.QRect(10, 65, 64, 12))
self.db_port.setObjectName("db_port")
self.db_port.setFont(self.getFont())
# 数据库端口号输入框
self.db_port_edit = QtWidgets.QTextEdit(self.db_widget)
self.db_port_edit.setGeometry(QtCore.QRect(80, 60, 150, 24))
self.db_port_edit.setStyleSheet("background-image: url(:/png/bg3.png);")
self.db_port_edit.setObjectName("db_port_edit")
self.db_port_edit.setFont(self.getFont())
# 数据库编码
self.db_charset = QtWidgets.QLabel(self.db_widget)
self.db_charset.setGeometry(QtCore.QRect(10, 90, 64, 12))
self.db_charset.setObjectName("db_charset")
self.db_charset.setFont(self.getFont())
# 数据库编码输入框
self.db_charset_edit = QtWidgets.QTextEdit(self.db_widget)
self.db_charset_edit.setGeometry(QtCore.QRect(80, 85, 150, 24))
self.db_charset_edit.setStyleSheet("background-image: url(:/png/bg3.png);")
self.db_charset_edit.setObjectName("db_charset_edit")
self.db_charset_edit.setFont(self.getFont())
# 数据库名称
self.db_name = QtWidgets.QLabel(self.db_widget)
self.db_name.setGeometry(QtCore.QRect(240, 40, 64, 12))
self.db_name.setObjectName("db_name")
self.db_name.setFont(self.getFont())
# 数据库名称输入框
self.db_name_edit = QtWidgets.QTextEdit(self.db_widget)
self.db_name_edit.setGeometry(QtCore.QRect(310, 35, 150, 24))
self.db_name_edit.setStyleSheet("background-image: url(:/png/bg3.png);")
self.db_name_edit.setObjectName("db_name_edit")
self.db_name_edit.setFont(self.getFont())
# 数据库用户名
self.db_usename = QtWidgets.QLabel(self.db_widget)
self.db_usename.setGeometry(QtCore.QRect(240, 65, 64, 12))
self.db_usename.setObjectName("db_usename")
self.db_usename.setFont(self.getFont())
# 数据库用户名输入框
self.db_usename_edit = QtWidgets.QTextEdit(self.db_widget)
self.db_usename_edit.setGeometry(QtCore.QRect(310, 60, 150, 24))
self.db_usename_edit.setStyleSheet("background-image: url(:/png/bg3.png);")
self.db_usename_edit.setObjectName("db_usename_edit")
self.db_usename_edit.setFont(self.getFont())
# 数据库密码
self.db_pwd = QtWidgets.QLabel(self.db_widget)
self.db_pwd.setGeometry(QtCore.QRect(240, 90, 64, 12))
self.db_pwd.setObjectName("db_pwd")
self.db_pwd.setFont(self.getFont())
# 数据库密码输入框
self.db_pwd_edit = QtWidgets.QTextEdit(self.db_widget)
self.db_pwd_edit.setGeometry(QtCore.QRect(310, 85, 150, 24))
self.db_pwd_edit.setStyleSheet("background-image: url(:/png/bg3.png);")
self.db_pwd_edit.setObjectName("db_pwd_edit")
self.db_pwd_edit.setFont(self.getFont())
# 数据库参数保存按钮
self.db_save_btn = QtWidgets.QPushButton(self.db_widget)
self.db_save_btn.setGeometry(QtCore.QRect(500, 85, 90, 24))
self.db_save_btn.setObjectName("db_save_btn")
self.db_save_btn.setFont(self.getFont())
self.line_2 = QtWidgets.QFrame(self.db_widget)
self.line_2.setGeometry(QtCore.QRect(0, 0, 640, 3))
self.line_2.setFrameShape(QtWidgets.QFrame.HLine)
self.line_2.setFrameShadow(QtWidgets.QFrame.Sunken)
self.line_2.setObjectName("line_2")
self.widget = QtWidgets.QWidget(self.centralwidget)
self.widget.setGeometry(QtCore.QRect(0, 240, 640, 320))
self.widget.setObjectName("widget")
# 大数据世界消息栏列表
self.bigdataworld_listview = QtWidgets.QListView(self.widget)
self.bigdataworld_listview.setGeometry(QtCore.QRect(0, 30, 250, 290))
self.bigdataworld_listview.setObjectName("bigdataworld_listview")
self.bigdataworld_listview.setFont(self.getFont())
self.bigdataworld_tip_widget = QtWidgets.QWidget(self.widget)
self.bigdataworld_tip_widget.setGeometry(QtCore.QRect(0, 0, 250, 30))
self.bigdataworld_tip_widget.setStyleSheet("background-image: url(:/png/bg2.png);")
self.bigdataworld_tip_widget.setObjectName("bigdataworld_tip_widget")
self.showtable = QtWidgets.QLabel(self.bigdataworld_tip_widget)
self.showtable.setGeometry(QtCore.QRect(60, 10, 120, 12))
self.showtable.setObjectName("showtable")
self.showtable.setFont(self.getFont())
self.line_4 = QtWidgets.QFrame(self.bigdataworld_tip_widget)
self.line_4.setGeometry(QtCore.QRect(0, 0, 250, 3))
self.line_4.setFrameShape(QtWidgets.QFrame.HLine)
self.line_4.setFrameShadow(QtWidgets.QFrame.Sunken)
self.line_4.setObjectName("line_4")
self.bigdatazx_tip_widget = QtWidgets.QWidget(self.widget)
self.bigdatazx_tip_widget.setGeometry(QtCore.QRect(390, 0, 250, 30))
self.bigdatazx_tip_widget.setStyleSheet("background-image: url(:/png/bg2.png);")
self.bigdatazx_tip_widget.setObjectName("bigdatazx_tip_widget")
self.showtable_2 = QtWidgets.QLabel(