Python pyinstaller实现图形化打包工具

2025-01-09 16:50

本文主要是介绍Python pyinstaller实现图形化打包工具,希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!

《Pythonpyinstaller实现图形化打包工具》:本文主要介绍一个使用PythonPYQT5制作的关于pyinstaller打包工具,代替传统的cmd黑窗口模式打包页面,实现更快捷方便的...

1.简介

一个使用python PYQT5制作的关于pyinstaller打包工具,代替传统的cmd黑窗口模式打包页面,实现更快捷方便的python打包体验。资源已打包,大家可自行下载。

相关功能:

  • 识别是否安装了pyinstaller,如果没有的话,打开在左上角会提示,并在右上角增加“安装”按钮。
  • 打包过程设置为隐式。并且加入“显示处理”选项。
  • 支持一键拖拽文件以及自动选择文件。
  • 支持导出到桌面以及设置打包好的软件图标。

pyinstaller 相关参数:

-F    制作独立的可执行程序

-D    制作出的档案存放在同一个文件夹下(默认值)

-K    包含TCL/TK(对于使用了TK的,最好加上这个选项,否则在未安装TK的电脑上无法运行)

-w    制作窗口程序

-c    制作命令行程序(默认)

-X    制作使用UPX压缩过的可执行程序(推荐使用这个选项,需要下载UPX包,解压后upx.exe放在Python(非PyInstaller)安装目录下,下载upx308w.zip)

-o DIR  指定输出SPEC文件路径(这也决定了最后输出的exe文件路径)

–icon=[ICO文件路径] 指定程序图标

-v [指定文件] 指定程序版本信息

-n [指定程序名] 指定程序名称

–distpath=D:/dist 输出到指定位置

2.运行效果

Python pyinstaller实现图形化打包工具

3.相关源码

from PyQt5.QtWidgets import QWidget, QApplication, QPushButton, QTextEdit, QCheckBox, QLabel, QFileDialog
from PyQt5.QtGui import QIcon
import sys
import os
import subprocess
 
 
class WinDow(QWidget):
 
    def __init__(self):
        super().__init__()
        self.setWindowTitle("Pyinstaller图形化打包工具")
        self.setMinimumSize(500 , 300)
        self.setMaximumSize(500 , 300)
        self.setWindowIcon(QIcon("pussy.ico"))
        self.wenjian_ui()
        self.ico_ui()
        self.anniu_ui()
        self.qingchu_ui()
        self.zhuomian_ui()
        self.tishi_ui()
        self.banben_ui()
        self.anzhuang_ui()
        self.anzhuang_anniu()
        self.xianshi_anniu()
        self.tishi2_ui()
        self.minglingchuang_ui()
        self.tishi3_ui()
        self.wenjian_anniu()
        self.ico_anniu()
        self.sczdwz_ui()
        self.sczdwz_xx()
        self.baocun_anniu()
        self.sczdwz_tishi()
 
    def wenjian_ui(self):
        wenjian = QTextEdit(self)
        self.wenjian = wenjian
        wenjian.resize(480-50-20 , 150-50-50)
        wenjian.move(10,30)
        wenjian.setPlaceholderText("可拖拽py文件至此:")
        wenjian.setTabChangesFocus(True)
 
    def ico_ui(self):
        ico = QTextEdit(self)
        self.ico = ico
        ico.resize(480-50-20 , 50)
        ico.move(10,190-50-50)
        ico.setPlaceholderText("可拖拽ico文件至此:")
        ico.setTabChangesFocus(True)
 
    def anniu_ui(self):
        anniu = QPushButton(self)
        self.anniu = anniu
        anniu.setText("打包生成EXE")
        anniu.move(415 , 340-105)
        anniu.resize(80,60)
        self.anniu.clicked.connect(self.anniu_cao)
 
    def qingchu_ui(self):
        qingchu = QPushButton(self)
        self.qingchu = qingchu
        qingchu.setText("清空")
        qingchu.move(415 , 340-105-40)
        self.qingchu.clicked.connect(self.qingchu_cao)
 
    def zhuomian_ui(self):
        zhuomian  = QCheckBox(self)
        self.zhuomian = zhuomian
        zhuomian.setText("输出到桌面")
        zhuomian.move(20, 345-110-40)
        # zhuomian.toggled.connect(lambda isChecked :print(isChecked))
        def guanbibaocun():
            if self.zhuomian.isChecked() == True:
                self.sczdwzan.setChecked(False)
                self.sczdwz.setText("")
                self.baocunanniu.close()
            elif self.zhuomian.isChecked() == False and self.baocunanniu.isChecked() ==True:
                self.baocunanniu.show()
 
        zhuomian.clicked.connect(guanbibaocun)
 
    def tishi_ui(self):
        tishi = QLabel(self)
        self.tishi = tishi
        tishi.setText("支持XP,Win7,Win10等打包到桌面")
        tishi.setStyleSheet('background-color: rgb(255, 251, 100)')
        tishi.move(5, 365-113-40)
 
 
    def banben_ui(self):
        banben = QLabel(self)
        self.banben = banben
        banben.move(10, 10)
        cmd = 'pyinstaller -v'
        pivi = subprocess.call(cmd, shell=True, stdin=subprocess.PIPE, stdout=subprocess.PIPE, stderr=subprocess.PIPE)
        # print(pivi)
        self.bbpi = pivi
        if self.bbpi == 0:
            banben.setText("您已安装PyInstaller")
        else:
            banben.setText("您目前还没安装PyInstaller")
            banben.setStyleSheet('color:rgb(255, 10, 10)')
 
    def anzhuang_ui(self):
        anzhuang = QLabel(self)
        self.anzhuang = anzhuang
        anzhuang.move(300,10)
        if self.bbpi == 0:
            anzhuang.setText("")
        else:
            anzhuang.setText("我要安装PyInstaller")
 
    def anzhuang_anniu(self):
        azan = QPushButton(self)
        self.azan = azan
        azan.move(415,3)
        if self.bbpi == 0:
            azan.close()
        else:
            azan.setText("我要安装")
        azan.clicked.connect(self.anzhuang_cao)
 
    def anzhuang_cao(self):
        a = "pip install pyinstaller"
        os.system(a)
 
    def xianshi_anniu(self):
        xianshi = QCheckBox(self)
        self.xianshi = xianshi
        xianshi.setText("使用显式处理")
        xianshi.move(20, 265-40)
 
    def tishi2_ui(self):
        tishi2 = QLabel(self)
        self.tishi2 = tishi2
        tishi2.setText("默认使用隐式,显式处理为弹出打包的命令行界面")
        tishi2.setStyleSheet('background-color: rgb(255, 251, 100)')
        tishi2.move(5, 280-40)
 
    def minglingchuang_ui(self):
        minglingchuang = QCheckBox(self)
        self.minglingchuang = minglingchuang
        minglingchuang.setText("使用命令窗")
        minglingchuang.move(20, 255)
 
    def tishi3_ui(self):
        tishi3 = QLabel(self)
        self.tishi3 = tishi3
        tishi3.setText("注意:命令行程序请勾选此选项,否则运行时会提示以下报错\n          failed to execute scipt XXX")
        tishi3.setStyleSheet('background-color: rgb(255, 251, 100)')
        tishi3.move(5, 280-10)
 
    def wenjian_anniu(self):
        wenjiananniu = QPushButton(self)
        self.wenjiananniu = wenjiananniu
        wenjiananniu.setText("选择py文件")
        wenjiananniu.move(430-10, 30+10)
        # wenjiananniu.resize(30,30)
        wenjiananniu.adjustSize()
        wenjiananniu.clicked.connect(self.dakaiwenjian_cao)
 
    def dakaiwenjian_cao(self):
        # dakaiwenjian = QFileDialog.getOpenFileUrl(self)
        dakaiwenjian = QFileDialog.getOpenFileName(self, "请选择一个PY文件", "./", "python文件(*.py)", "python文件(*.py)")
        # print(dakaiwenjian)
        self.wenjian.setText("file:///"+str(dakaiwenjian[0]))
 
    def ico_anniu(self):
        icoanniu = QPushButton(self)
        self.icoanniu = icoanniu
        icoanniu.setText("选择ico文件")
        icoanniu.move(430 - 10, 30 + 10+50+10)
        # wenjiananniu.resize(30,30)
        icoanniu.adjustSize()
        icoanniu.clicked.connect(self.dakaiico_cao)
 
    def dakaiico_cao(self):
        # dakaiwenjian = QFileDialog.getOpenFileUrl(self)
        dakaiico = QFileDialog.getOpenFileName(self, "请选择一个ico文件", "./", "ico文件(*.ico)", "ico文件(*.ico)")
        # print(dakaiico)
        self.ico.setText("file:///"+str(dakaiico[0]))
 
    def sczdwz_ui(self):
        sczdwz = QTextEdit(self)
        self.sczdwz = sczdwz
        sczdwz.setText("")
        sczdwz.move(10 , 170)
        sczdwz.resize(480-50-20 , 150-50-50-25)
        sczdwz.setReadOnly(True)
 
    def sczdwz_xx(self):
        sczdwzan = QCheckBox(self)
        self.sczdwzan = sczdwzan
        sczdwzan.setText("打包文件输出到指定位置")
        sczdwzan.move(20, 345-110-60-25-10)
        def guanbizhuomian():
            if sczdwzan.isChecked() == True:
                self.zhuomian.setChecked(False)
                self.baocunanniu.show()
            else:
                androidself.baocunanniu.close()
                self.sczdwz.setText("")
        sczdwzan.clicked.connect(guanbizhuomian)
 
    def baocun_anniu(self):
        baocunanniu = QPushButton(self)
        self.baocunanniu = baocunanniu
        baocunanniu.setText("选择保存路径")
        baocunanniu.move(480-50-10 , 345-110-60-5)
        # wenjiananniu.resize(30,30)
        baocunanniu.adjustSize()
        baocunanniu.clicked.connect(self.baocunlujin_cao)
        baocunanniu.close()
 
    def sczdwz_tishi(self):
        sczdwzts = QLabel(self)
        self.sczdwzts = sczdwzts
        sczdwzts.setText("打钩后才会显示选择按钮")
        sczdwzts.move(5, 345-110-60-20)
        sczdwzts.setStyleSheet('background-color: rgb(255, 251, 100)')
 
    def baocunlujin_cao(self):
        baocunlujin = QFileDialog.getExistingDirectory(self)
        # print(baocunlujin)
        self.sczdwz.setText(baocunlujin)
 
    def anniu_cao(self):
        if self.minglingchuang.isChecked() == True:
 
            if self.xianshi.isChecked() == True:
 
                if self.zhuomian.isChecked() == True and self.ico.toPlainText() == "":
                    i = "pyinstaller -F "
                    j = self.wenjian.toPlainText()
                    h = " --distpath=%UserProfile%/Desktop/dist"
                    self.k = i + j[8:] + h
                    shuchu = self.k
                    # print(shuchu)
                    os.system(shuchu)
 
                elif self.zhuomian.isChecked() == False and self.sczdwzan.isChecked() == False and self.ico.toPlainText() == "":
                    i = "pyinstaller -F "
                    j = self.wenjian.toPlainText()
                    self.k = i + j[8:]
                    shuchu = self.k
                    # print(shuchu)
                    os.system(shuchu)
 
                elif self.zhuomian.isChecked() == True and self.ico.toPlainText() != "":
                    i = "pyinstaller -F -i "
                    j = self.wenjian.toPlainText()
                    h = self.ico.toPlainText()
                    m = " --distpath=%UserProfile%/Desktop/dist"
                    self.k = i + h[8:] python+ " " + j[8:] + m
                    shuchu = self.k
                    os.system(shuchu)
                    # print(shuchu)
 
                elif self.zhuomian.isChecked() == False and self.sczdwzan.isChecked() == False and self.ico.toPlainText() != "":
                    i = "pyinstaller -F -i "
                    j = self.wenjian.toPlainText()
                    h = self.ico.toPlainText()
                    self.k = i + h[8:] + " " + j[8:]
                    shuchu = self.k
                    os.system(shuchu)
                    # print(shuchu)
 
                #这是一段
                elif self.sczdwzan.isChecked() == True and self.ico.toPlainText() == "":
                    i = "pyinstaller -F "
                    j = self.wenjian.toPlainText()
                    h = " --distpath="
                    s = self.sczdwz.toPlainText()
                    self.k = i + j[8:] + h + s
                    shuchu = self.k
                    # print(shuchu)
                    os.system(shuchu)
 
                elif self.sczdwzan.isChecked() == True and self.ico.toPlainText() != "":
                    i = "pyinstaller -F -i "
                    j = self.wenjian.toPlainText()
                    h = self.ico.toPlainText()
                    m = " --distpath="
                    s = self.sczdwz.toPlainText()
                    self.k = i + h[8:] + " " + j[8:] + m + s
                    shuchu = self.k
                    os.system(shuchu)
                    # print(shuchu)
 
                else:
                    pass
            else:
                if self.zhuomian.isChecked() == True and self.ico.toPlainText() == "":
                    i = "pyinstaller -F "
                    j = self.wenjian.toPlainText()
                    h = " --distpath=%UserProfile%/Desktop/dist"
                    self.k = i + j[8:] + h
                    shuchu = self.k
                    # print(shuchu)
                    subprocess.call(shuchu, shell=True, stdin=subprocess.PIPE, stdout=subprocess.PIPE,
                                    stderr=subprocess.PIPE)
 
                elif self.zhuomian.isChecked() == False and self.sczdwzan.isChecked() == False and self.ico.toPlainText() == "":
                    i = "pyinstaller -F "
                    j = self.wenjian.toPlainText()
                    self.k = i + j[8:]
                    shuchu = self.k
                    # print(shuchu)
                    subprocess.call(shuchu, shell=True, stdin=subprocess.PIPE, stdout=subprocess.PIPE,
                                    stderr=subprocess.PIPE)
 
                elif self.zhuomian.isChecked() == True and self.ico.toPlainText() != "":
                    i = "pyinstaller -F -i "
                    j = self.wenjian.toPlainText()
                    h = self.ico.toPlainText()
                    m = " --distpath=%UserProfile%/Desktop/dist"
                    self.k = i + h[8:] + " " + j[8:] + m
                    shuchu = self.k
                    # print(shuchu)
                    subprocess.call(shuchu, shell=True, stdin=subprocess.PIPE, stdout=subprocess.PIPE,
                                    stderr=subprocess.PIPE)
 
                elif self.zhuomian.isChecked() == False and self.sczdwzan.isChecked() == False and self.ico.toPlainText() != "":
                    i = "pyinstaller -F -i "
                    j = self.wenjian.toPlainText()
                    h = self.ico.toPlainText()
                    self.k = i + h[8:] + " " + j[8:]
                    shuchu = self.k
                    # print(shuchu)
                    subprocess.call(shuchu, shell=True, stdin=subprocess.PIPE, stdout=subprocess.PIPE,
                                    stderr=subprocess.PIPE)
 
                #这是第二段
                elif self.sczdwzan.isChecked() == True and self.ico.toPlainText() == "":
                    i = "pyinstaller -F "
                    j = self.wenjian.toPlainText()
                    h = " --distpath="
                    s = self.sczdwz.toPlainText()
                    self.k = i + j[8:] + h + s
                    shuchu = self.k
                    # print(shuchu)
                    subprocess.call(shuchu, shell=True, stdin=subprocess.PIPE, stdout=subprocess.PIPE,
                                    stderr=subprocess.PIPE)
 
                elif self.sczdwzan.isChecked() == True and self.ico.toPlainText() != "":
                    i = "pyinstaller -F -i "
                    j = self.wenjian.toPlainText()
                    h = self.ico.toPlainText()
                    m = " --distpath="
                    s = self.sczdwz.toPlainText()
                    self.k = i + h[8:] + " " + j[8:] + m + s
                    shuchu = self.k
                    # print(shuchu)
                    subprocess.call(shuchu, shell=True, stdin=subprocess.PIPE, stdout=subprocess.PIPE,
                                    stderr=subprocess.PIPE)
 
                else:
                    pass
        else:
            if self.xianshi.isChecked() == True:
 
javascript                if self.zhuomian.isChecked() == True and self.ico.toPlainText() == "":
                    i = "pyinstaller -F -w "
                    j = self.wenjian.toPlainText()
                    h = " --distpath=%UserProfile%/Desktop/dist"
                    self.k = i + j[8:] + h
                    shuchu = self.k
                    # print(shuchu)
                    os.system(shuchu)
 
                elif self.zhuomian.isChecked() == False and self.sczdwzan.isChecked() == False and self.ico.toPlainText() == "":
                    i = "pyinstaller -F -w "
                    j = self.wenjian.toPlainText()
                    self.k = i + j[8:]
                    shuchu = self.k
                    # print(shuchu)
                    os.system(shuchu)
 
                elif self.zhuomian.isChecked() == True and self.ico.toPlainText() != "":
                    i = "pyinstaller -F -w -i "
                    j = self.wenjian.toPlainText()
                    h = self.ico.toPlainText()
                    m = " --distpath=%UserProfile%/Desktop/dist"
                    self.k = i + h[8:] + " " + j[8:] + m
                    shuchu = self.k
                    os.system(shuchu)
                    # print(shuchu)
 
                elif self.zhuomian.isChecked() == False and self.sczdwzan.isChecked() == False and self.ico.toPlainText() != "":
                    i = "pyinstaller -F -w -i "
                    j = self.wenjian.toPlainText()
                    h = self.ico.toPlainText()
                    self.k = i + h[8:] + " " + j[8:]
                    shuchu = self.k
                    os.system(shuchu)
                    # print(shuchu)
 
                elif self.sczdwzan.isChecked() == True and self.ico.toPlainText() == "":
                    i = "pyinstaller -F -w "
                    j = self.wenjian.toPlainText()
                    h = " --distpath="
                    s = self.sczdwz.toPlainText()
                    self.k = i + j[8:] + h + s
                    shuchu = self.k
                    # print(shuchu)
                    os.system(shuchu)
 
                elif self.sczdwzan.isChecked() == True and self.ico.toPlainText() != "":
                    i = "pyinstaller -F -w -i "
                    j = self.wenjian.toPlainText()
                    h = self.ico.toPlainText()
                    m = " --distpath="
                    s = self.sczdwz.toPlainText()
                    self.k = i + h[8:] + " " + j[8:] + m + s
                    shuchu = self.k
                    os.system(shuchu)
                    # print(shuchu)
 
 
                else:
                    pass
            else:
                if self.zhuomian.isChecked() == True and self.ico.toPlainText() == "":
                    i = "pyinstaller -F -w "
                    j = self.wenjian.toPlainText()
                    h = " --distpath=%UserProfile%/Desktop/dist"
                    self.k = i + j[8:] + h
                    shuchu = self.k
                    # print(shuchu)
                    subprocess.call(shuchu, shell=True, stdin=subprocess.PIPE, stdout=subprocess.PIPE,
                                    stderr=subprocess.PIPE)
 
                elif self.zhuomian.isChecked() == False and self.sczdwzan.isChecked() == False and self.ico.toPlainText() == "":
                    i = "pyinstaller -F -w "
                    j = self.wenjian.toPlainText()
                    self.k = i + j[8:]
                    shuchu = self.k
                    # print(shuchu)
                    subprocess.call(shuchu, shell=True, stdin=subprocess.PIPE, stdout=subprocess.PIPE,
                                    stderr=subprocess.PIPE)
 
                elif self.zhuomian.isChecked() == True and self.ico.toPlainText() != "":
                    i = "pyinstaller -F -w -i "
                    j = self.wenjian.toPlainText()
                    h = self.ico.toPlainText()
                    m = " --distpath=%UserProfile%/Desktop/dist"
                    self.k = i + h[8:] + " " + jChina编程[8:] + m
                    shuchu = self.k
                    # print(shuchu)
                    subprocess.call(shuchu, shell=True, stdin=subprocess.PIPE, stdout=subprocess.PIPE,
                                    stderr=subprocess.PIPE)
 
                elif self.zhuomian.isChecked() == False and self.sczdwzan.isChecked() == False and self.ico.toPlainText() != "":
                    i = "pyinstaller -F -w -i "
                    j = self.wenjian.toPlainText()
                    h = self.ico.toPlainText()
                    self.k = i + h[8:] + " " + j[8:]
                    shuchu = self.k
                    # print(shuchu)
                    subprocess.call(shuchu, shell=True,编程China编程 stdin=subprocess.PIPE, stdout=subprocess.PIPE,
                                    stderr=subprocess.PIPE)
 
                elif self.sczdwzan.isChecked() == True and self.ico.toPlainText() == "":
                    i = "pyinstaller -F -w "
                    j = self.wenjian.toPlainText()
                    h = " --distpath="
                    s = self.sczdwz.toPlainText()
                    self.k = i + j[8:] + h + s
                    shuchu = self.k
                    # print(shuchu)
                    subprocess.call(shuchu, shell=True, stdin=subprocess.PIPE, stdout=subprocess.PIPE,
                                    stderr=subprocess.PIPE)
 
                elif self.sczdwzan.isChecked() == True and self.ico.toPlainText() != "":
                    i = "pyinstaller -F -w -i "
                    j = self.wenjian.toPlainText()
                    h = self.ico.toPlainText()
                    m = " --distpath="
                    s = self.sczdwz.toPlainText()
                    self.k = i + h[8:] + " " + j[8:] + m + s
                    shuchu = self.k
                    # print(shuchu)
                    subprocess.call(shuchu, shell=True, stdin=subprocess.PIPE, stdout=subprocess.PIPE,
                                    stderr=subprocess.PIPE)
 
                else:
                    pass
 
    def qingchu_cao(self):
        self.wenjian.clear()
        self.ico.clear()
        self.sczdwz.clear()
 
 
if __name__ == "__main__":
 
    app = QApplication(sys.argv)
 
    window = WinDow()
 
    window.show()
 
    sys.exit(app.exec())

到此这篇关于Python pyinstaller实现图形化打包工具的文章就介绍到这了,更多相关Python pyinstaller打包内容请搜索China编程(www.chinasem.cn)以前的文章或继续浏览下面的相关文章希望大家以后多多支持China编程(www.chinasem.cn)!

这篇关于Python pyinstaller实现图形化打包工具的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!



http://www.chinasem.cn/article/1152999

相关文章

Spring StateMachine实现状态机使用示例详解

《SpringStateMachine实现状态机使用示例详解》本文介绍SpringStateMachine实现状态机的步骤,包括依赖导入、枚举定义、状态转移规则配置、上下文管理及服务调用示例,重点解... 目录什么是状态机使用示例什么是状态机状态机是计算机科学中的​​核心建模工具​​,用于描述对象在其生命

Spring Boot 结合 WxJava 实现文章上传微信公众号草稿箱与群发

《SpringBoot结合WxJava实现文章上传微信公众号草稿箱与群发》本文将详细介绍如何使用SpringBoot框架结合WxJava开发工具包,实现文章上传到微信公众号草稿箱以及群发功能,... 目录一、项目环境准备1.1 开发环境1.2 微信公众号准备二、Spring Boot 项目搭建2.1 创建

IntelliJ IDEA2025创建SpringBoot项目的实现步骤

《IntelliJIDEA2025创建SpringBoot项目的实现步骤》本文主要介绍了IntelliJIDEA2025创建SpringBoot项目的实现步骤,文中通过示例代码介绍的非常详细,对大家... 目录一、创建 Spring Boot 项目1. 新建项目2. 基础配置3. 选择依赖4. 生成项目5.

使用Python删除Excel中的行列和单元格示例详解

《使用Python删除Excel中的行列和单元格示例详解》在处理Excel数据时,删除不需要的行、列或单元格是一项常见且必要的操作,本文将使用Python脚本实现对Excel表格的高效自动化处理,感兴... 目录开发环境准备使用 python 删除 Excphpel 表格中的行删除特定行删除空白行删除含指定

golang程序打包成脚本部署到Linux系统方式

《golang程序打包成脚本部署到Linux系统方式》Golang程序通过本地编译(设置GOOS为linux生成无后缀二进制文件),上传至Linux服务器后赋权执行,使用nohup命令实现后台运行,完... 目录本地编译golang程序上传Golang二进制文件到linux服务器总结本地编译Golang程序

Linux下删除乱码文件和目录的实现方式

《Linux下删除乱码文件和目录的实现方式》:本文主要介绍Linux下删除乱码文件和目录的实现方式,具有很好的参考价值,希望对大家有所帮助,如有错误或未考虑完全的地方,望不吝赐教... 目录linux下删除乱码文件和目录方法1方法2总结Linux下删除乱码文件和目录方法1使用ls -i命令找到文件或目录

SpringBoot+EasyExcel实现自定义复杂样式导入导出

《SpringBoot+EasyExcel实现自定义复杂样式导入导出》这篇文章主要为大家详细介绍了SpringBoot如何结果EasyExcel实现自定义复杂样式导入导出功能,文中的示例代码讲解详细,... 目录安装处理自定义导出复杂场景1、列不固定,动态列2、动态下拉3、自定义锁定行/列,添加密码4、合并

mybatis执行insert返回id实现详解

《mybatis执行insert返回id实现详解》MyBatis插入操作默认返回受影响行数,需通过useGeneratedKeys+keyProperty或selectKey获取主键ID,确保主键为自... 目录 两种方式获取自增 ID:1. ​​useGeneratedKeys+keyProperty(推

Spring Boot集成Druid实现数据源管理与监控的详细步骤

《SpringBoot集成Druid实现数据源管理与监控的详细步骤》本文介绍如何在SpringBoot项目中集成Druid数据库连接池,包括环境搭建、Maven依赖配置、SpringBoot配置文件... 目录1. 引言1.1 环境准备1.2 Druid介绍2. 配置Druid连接池3. 查看Druid监控

Python通用唯一标识符模块uuid使用案例详解

《Python通用唯一标识符模块uuid使用案例详解》Pythonuuid模块用于生成128位全局唯一标识符,支持UUID1-5版本,适用于分布式系统、数据库主键等场景,需注意隐私、碰撞概率及存储优... 目录简介核心功能1. UUID版本2. UUID属性3. 命名空间使用场景1. 生成唯一标识符2. 数