@echo off echo ------------------------------------------------------------------------- echo 获取服务 SQL 文件 echo ------------------------------------------------------------------------- echo 请选择数据库类型 echo 【1】MySQL 【2】ORACLE 【3】PostgreSQL 【4】SQLServer2012 【5】dameng set /p sqlmodel= 请输入你的选择: echo 请选择服务类型 echo 【1】单服务 【2】多服务 set /p eipmodel= 请输入你的选择: goto :package :package @echo off if /i "%sqlmodel%"=="1" if "%eipmodel%"=="1" cls&goto mysqlassembly if /i "%sqlmodel%"=="1" if "%eipmodel%"=="2" cls&goto mysql if /i "%sqlmodel%"=="2" if "%eipmodel%"=="1" cls&goto oracleassembly if /i "%sqlmodel%"=="2" if "%eipmodel%"=="2" cls&goto oracle if /i "%sqlmodel%"=="3" if "%eipmodel%"=="1" cls&goto postgresqlassembly if /i "%sqlmodel%"=="3" if "%eipmodel%"=="2" cls&goto postgresql if /i "%sqlmodel%"=="4" if "%eipmodel%"=="1" cls&goto sqlserver2012assembly if /i "%sqlmodel%"=="4" if "%eipmodel%"=="2" cls&goto sqlserver2012 if /i "%sqlmodel%"=="5" if "%eipmodel%"=="1" cls&goto damengassembly if /i "%sqlmodel%"=="5" if "%eipmodel%"=="2" cls&goto dameng :mysql @echo off call mkdir publish\MicroService\MySQL call type TableSQL_MySQL\1.bpm_act_init.sql TableSQL_MySQL\2.bpm_init.sql IndexSQL\bpm_index_init.sql InitDataSQL\bpm_init_data.sql ChangeSQL\MySQL\DoSQL\dosql_bpm.sql >> publish\MicroService\MySQL\EipBpm.sql call type TableSQL_MySQL\3.portal_qrtz_init.sql TableSQL_MySQL\4.portal_init.sql IndexSQL\portal_index_init.sql InitDataSQL\portal_init_data.sql DemoInitDataSQL\portal.sql ChangeSQL\MySQL\DoSQL\dosql_portal.sql >> publish\MicroService\MySQL\EipPortal.sql call type TableSQL_MySQL\5.form_init.sql IndexSQL\form_index_init.sql InitDataSQL\form_init_data.sql ChangeSQL\MySQL\DoSQL\dosql_form.sql >> publish\MicroService\MySQL\EipForm.sql call type TableSQL_MySQL\6.uc_init.sql IndexSQL\uc_index_init.sql InitDataSQL\uc_init_data.sql ChangeSQL\MySQL\DoSQL\dosql_uc.sql >> publish\MicroService\MySQL\EipUc.sql goto :success :mysqlassembly @echo off call mkdir publish\SingleService call type TableSQL_MySQL\*.sql IndexSQL\*.sql InitDataSQL\*.sql DemoInitDataSQL\*.sql ChangeSQL\MySQL\DoSQL\*.sql >> publish\SingleService\EipAssembly_MySQL.sql goto :success :oracle @echo off call mkdir publish\MicroService\ORACLE call type TableSQL_ORACLE\1.bpm_act_init.sql TableSQL_ORACLE\2.bpm_init.sql IndexSQL\bpm_index_init.sql InitDataSQL\bpm_init_data.sql ChangeSQL\ORACLE\DoSQL\dosql_bpm.sql >> publish\MicroService\ORACLE\EipBpm.sql call type TableSQL_ORACLE\3.portal_qrtz_init.sql TableSQL_ORACLE\4.portal_init.sql IndexSQL\portal_index_init.sql InitDataSQL\portal_init_data.sql DemoInitDataSQL\portal.sql ChangeSQL\ORACLE\DoSQL\dosql_portal.sql >> publish\MicroService\ORACLE\EipPortal.sql call type TableSQL_ORACLE\5.form_init.sql IndexSQL\form_index_init.sql InitDataSQL\form_init_data.sql ChangeSQL\ORACLE\DoSQL\dosql_form.sql >> publish\MicroService\ORACLE\EipForm.sql call type TableSQL_ORACLE\6.uc_init.sql IndexSQL\uc_index_init.sql InitDataSQL\uc_init_data.sql ChangeSQL\ORACLE\DoSQL\dosql_uc.sql >> publish\MicroService\ORACLE\EipUc.sql goto :success :oracleassembly @echo off call mkdir publish\SingleService call type TableSQL_ORACLE\*.sql IndexSQL\*.sql InitDataSQL\*.sql DemoInitDataSQL\*.sql ChangeSQL\ORACLE\DoSQL\*.sql >> publish\SingleService\EipAssembly_ORACLE.sql goto :success :postgresql @echo off call mkdir publish\MicroService\PostgreSQL call type TableSQL_PostgreSQL\1.bpm_act_init.sql TableSQL_PostgreSQL\2.bpm_init.sql IndexSQL\bpm_index_init.sql InitDataSQL\bpm_init_data.sql ChangeSQL\PostgreSql\DoSQL\dosql_bpm.sql >> publish\MicroService\PostgreSQL\EipBpm.sql call type TableSQL_PostgreSQL\3.portal_qrtz_init.sql TableSQL_PostgreSQL\4.portal_init.sql IndexSQL\portal_index_init.sql InitDataSQL\portal_init_data.sql DemoInitDataSQL\portal.sql ChangeSQL\PostgreSql\DoSQL\dosql_portal.sql >> publish\MicroService\PostgreSQL\EipPortal.sql call type TableSQL_PostgreSQL\5.form_init.sql IndexSQL\form_index_init.sql InitDataSQL\form_init_data.sql ChangeSQL\PostgreSql\DoSQL\dosql_form.sql >> publish\MicroService\PostgreSQL\EipForm.sql call type TableSQL_PostgreSQL\6.uc_init.sql IndexSQL\uc_index_init.sql InitDataSQL\uc_init_data.sql ChangeSQL\PostgreSql\DoSQL\dosql_uc.sql >> publish\MicroService\PostgreSQL\EipUc.sql goto :success :postgresqlassembly @echo off call mkdir publish\SingleService call type TableSQL_PostgreSQL\*.sql IndexSQL\*.sql InitDataSQL\*.sql DemoInitDataSQL\*.sql ChangeSQL\PostgreSql\DoSQL\*.sql >> publish\SingleService\EipAssembly_PostgreSQL.sql goto :success :sqlserver2012 @echo off call mkdir publish\MicroService\SQLServer2012 call type TableSQL_SQLServer2012\1.bpm_act_init.sql TableSQL_SQLServer2012\2.bpm_init.sql IndexSQL\bpm_index_init.sql InitDataSQL\bpm_init_data.sql ChangeSQL\SQLServer2012\DoSQL\dosql_bpm.sql >> publish\MicroService\SQLServer2012\EipBpm.sql call type TableSQL_SQLServer2012\3.portal_qrtz_init.sql TableSQL_SQLServer2012\4.portal_init.sql IndexSQL\portal_index_init.sql InitDataSQL\portal_init_data.sql DemoInitDataSQL\portal.sql ChangeSQL\SQLServer2012\DoSQL\dosql_portal.sql >> publish\MicroService\SQLServer2012\EipPortal.sql call type TableSQL_SQLServer2012\5.form_init.sql IndexSQL\form_index_init.sql InitDataSQL\form_init_data.sql ChangeSQL\SQLServer2012\DoSQL\dosql_form.sql >> publish\MicroService\SQLServer2012\EipForm.sql call type TableSQL_SQLServer2012\6.uc_init.sql IndexSQL\uc_index_init.sql InitDataSQL\uc_init_data.sql ChangeSQL\SQLServer2012\DoSQL\dosql_uc.sql >> publish\MicroService\SQLServer2012\EipUc.sql goto :success :sqlserver2012assembly @echo off call mkdir publish\SingleService call type TableSQL_SQLServer2012\*.sql IndexSQL\*.sql InitDataSQL\*.sql DemoInitDataSQL\*.sql ChangeSQL\SQLServer2012\DoSQL\*.sql >> publish\SingleService\EipAssembly_SQLServer2012.sql goto :success :damengassembly @echo off call mkdir publish\SingleService call type TableSQL_Dameng\*.sql IndexSQL\*.sql InitDataSQL\*.sql DemoInitDataSQL\*.sql ChangeSQL\DM\DoSQL\*.sql >> publish\SingleService\EipAssembly_DM.sql goto :success :dameng @echo off call mkdir publish\MicroService\DM call type TableSQL_Dameng\1.bpm_act_init.sql TableSQL_Dameng\2.bpm_init.sql IndexSQL\bpm_index_init.sql InitDataSQL\bpm_init_data.sql ChangeSQL\DM\DoSQL\dosql_bpm.sql >> publish\MicroService\DM\EipBpm.sql call type TableSQL_Dameng\3.portal_qrtz_init.sql TableSQL_Dameng\4.portal_init.sql IndexSQL\portal_index_init.sql InitDataSQL\portal_init_data.sql DemoInitDataSQL\portal.sql ChangeSQL\DM\DoSQL\dosql_portal.sql >> publish\MicroService\DM\EipPortal.sql call type TableSQL_Dameng\5.form_init.sql IndexSQL\form_index_init.sql InitDataSQL\form_init_data.sql ChangeSQL\DM\DoSQL\dosql_form.sql >> publish\MicroService\DM\EipForm.sql call type TableSQL_Dameng\6.uc_init.sql IndexSQL\uc_index_init.sql InitDataSQL\uc_init_data.sql ChangeSQL\DM\DoSQL\dosql_uc.sql >> publish\MicroService\DM\EipUc.sql goto :success :success @echo off echo ------------------------------------------- echo SUCCESS if "%eipmodel%"=="1" echo 获取完成 请查看 publish 下 SingleService 文件夹 if "%eipmodel%"=="2" echo 获取完成 请查看 publish 下 MicroService 文件夹 echo ------------------------------------------- pause