mysql.exe initialize,SpringBoot+Mysql打包exe生成安装程序

一.SpringBoot将项目打包成jar包

1.在pom.xml文件中导入Springboot的maven依赖;

org.springframework.boot

spring-boot-maven-plugin

2.然后package 把项目打包jar

image.png

3.然后可以自己创建bat文件测试jar包是否打包正常运行

@echo of

.\jre1.8\bin\java -jar test.jar

@pause

二.exe4j 将java程序打包成exe文件

1.第一步选择'JAR in EXE' mode

image.png

2.第二步设置导出位置

image.png

3.第三步选择打开方式、exe文件名和32位或者64运行环境

image.png

4.第四步vm参数可根据系统项目环境要求进行配置,导入项目打包的jar

-Dfile.encoding=utf-8 -XX:PermSize=512M -XX:MaxPermSize=1024M

image.png

5.第五步设置最大运行环境和最小运行环境

image.png

6.第六步加入项目需要运行的jre

image.png

7然后一直next到finish即可

image.png

image.png

三.Inno Setup 打包java环境(项目exe+mysql+jdk+tomcat+redis等...)

1.安装下载inno setup软件(百度自行下载)

2.准备安装目录

image.png

3.然后打开inno Setup选择脚本创建

image.png

4.然后一直next到如下图

image.png

5.配置完成一直next，然后生成iss文件，对文件内容需要进行修改

; Script generated by the Inno Setup Script Wizard.

; SEE THE DOCUMENTATION FOR DETAILS ON CREATING INNO SETUP SCRIPT FILES!

#define MyAppName "test"

#define MyAppVersion "1.5"

#define MyAppPublisher "My Company, Inc."

#define MyAppURL "http://www.example.com/"

#define MyAppExeName test.exe"

[Setup]

; NOTE: The value of AppId uniquely identifies this application.

; Do not use the same AppId value in installers for other applications.

; (To generate a new GUID, click Tools | Generate GUID inside the IDE.)

AppId={{002878FF-AFF2-4940-89B1-D233A71FB076}

AppName={#MyAppName}

AppVersion={#MyAppVersion}

;AppVerName={#MyAppName} {#MyAppVersion}

AppPublisher={#MyAppPublisher}

AppPublisherURL={#MyAppURL}

AppSupportURL={#MyAppURL}

AppUpdatesURL={#MyAppURL}

DefaultDirName={pf}\{#MyAppName}

DisableProgramGroupPage=yes

OutputBaseFilename=setup //输出文件名

Compression=lzma

SolidCompression=yes

[Languages]

Name: "english"; MessagesFile: "compiler:Default.isl"

[Tasks]

Name: "desktopicon"; Description: "{cm:CreateDesktopIcon}"; GroupDescription: "{cm:AdditionalIcons}"; Flags: unchecked

; 安装文件

[Files]

; 安装部署的源文件路径

Source: "C:\Users\Administrator\Desktop\test\install.bat"; DestDir: "{app}"; Flags: ignoreversion

Source: "C:\Users\Administrator\Desktop\test\uninstall.bat"; DestDir: "{app}"; Flags: ignoreversion

Source: "C:\Users\Administrator\Desktop\test\test.exe"; DestDir: "{app}"; Flags: ignoreversion

Source: "C:\Users\Administrator\Desktop\test\jdk1.8\*"; DestDir: "{app}"; Flags: ignoreversion recursesubdirs createallsubdirs

Source: "C:\Users\Administrator\Desktop\test\mysql\*"; DestDir: "{app}"; Flags: ignoreversion recursesubdirs createallsubdirs

; NOTE: Don't use "Flags: ignoreversion" on any shared system files

[Icons]

Name: "{commonprograms}\{#MyAppName}"; Filename: "{app}\{#MyAppExeName}"

Name: "{commondesktop}\{#MyAppName}"; Filename: "{app}\{#MyAppExeName}"; Tasks: desktopicon

; 程序安装成功后执行脚本

[Run]

Filename: "{app}\install.bat"; Flags: nowait skipifdoesntexist

;程序御载后执行脚本

[UninstallRun]

Filename: "{app}\uninstall.bat"; Flags: skipifdoesntexist

大部分为自动生成的,其中修改的有

(1).DefaultDirName=C:\tomcat 默认安装位置

(2).SetupIconFile=D:\onekeyinstell\install\favicon.ico 安装图标

(3).[Files] [Icons][Run][UninstallRun]部分 代码中有解释

6.install.bat文件内容为安装时配置项

@echo off

title 软件配置安装中，请不要手动关闭

color 0a

echo 配置安装环境中...

setx /M JAVA_HOME "%~dp0%jdk1.8.0_171"

setx /M MYSQL_HOME "%~dp0%mysql-5.7.22-winx64"

setx /M REDIS_HOME "%~dp0%Redis-x64-3.0.501"

setx /M CATALINA_HOME "%~dp0%apache-tomcat-8.5.43"

setx /M CLASS_PATH ".;%%JAVA_HOME%%\lib;"

setx /M PATH "%PATH%;%%JAVA_HOME%%\bin;%%MYSQL_HOME%%\bin;%%TOMCAT_HOME%%\bin;%%REDIS_HOME%%"

echo 环境变量配置成功

cd "%~dp0%"

echo 开始安装数据库

cd mysql-5.7.22-winx64

bin\mysqld.exe install

bin\mysqld.exe --initialize-insecure --user=mysql

net start MySQL

sc config MySQL start= auto

echo 数据库启动中...

ping -n 3 127.1>nul

echo 初始化数据库...

bin\mysqladmin.exe -u root password 123456

echo 创建用户mes

bin\mysql.exe -u root -p123456 < sqlfile\createuser.sql

echo 初始化数据库表

bin\mysql.exe -u mes -p123456 < sqlfile\mes-createsql.sql

bin\mysql.exe -u mes -p123456 < sqlfile\procedure.sql

cd ..

echo 数据库安装完成

echo 开始安装缓存服务

cd Redis-x64-3.0.501

redis-server.exe --service-install

echo 缓存服务启动中

redis-server.exe --service-start

ping -n 3 127.1>nul

cd ..

echo 缓存服务安装完成

echo 应用服务安装

setlocal

set "CATALINA_HOME=%~dp0%apache-tomcat-8"

set "JAVA_HOME=%~dp0%jdk1.8"

call apache-tomcat-8.5.43\bin\service.bat install

echo 开始启动应用服务

sc config Tomcat8 start= auto

net start Tomcat8

echo 安装完成

ping -n 3 127.1>nul

注:一定一定要加

setlocal

set "CATALINA_HOME=%~dp0%apache-tomcat-8.5.43"

set "JAVA_HOME=%~dp0%jdk1.8.0_171"

这三行,最开始的setx /M配置永久环境变量,需要cmd重启才有效,所以此处需要设置一个临时变量,供后面的service.bat调用

7.uninstall.bat文件内容(卸载环境，内容)

@echo off

title 软件正在卸载中，请不要关闭

color 0a

echo 停止并删除应用服务

net stop Tomcat9

sc delete Tomcat9

echo 停止并删除数据库

net stop MySQL

sc delete MySQL

echo 停止并删除缓存服务

Redis-x64-3.0.501\redis-server.exe --service-stop

Redis-x64-3.0.501\redis-server.exe --service-uninstall

echo 删除环境变量

wmic ENVIRONMENT where "name='CLASS_PATH'" delete

wmic ENVIRONMENT where "name='TOMCAT_HOME'" delete

wmic ENVIRONMENT where "name='REDIS_HOME'" delete

wmic ENVIRONMENT where "name='MYSQL_HOME'" delete

echo 删除成功

最后生成exe安装包在Output中，安装即可