@echo off
echo -------------------------------------------------------------------------
echo simple test
echo -------------------------------------------------------------------------
title=simple test
echo.
setlocal
rem # define two param
set RES_PATH=D:\dev-test\cmd
set DES_PATH=D:\dev-tools\jboss-eap-4.3\jboss-as\server\production\deploy\ear-war\app.war
rem ###############################
rem # deal destination
del /s /q %DES_PATH%\WEB-INF\*
rd /s /q %DES_PATH%\WEB-INF
mkdir %DES_PATH%\WEB-INF
echo.
copy %RES_PATH%\web.xml %DES_PATH%\WEB-INF
endlocal
echo.
pause
运行结果:
3 向Oracle数据库创建用户, 给创建的用户分配权限, 给创建的用户创建新表并添加数据
先给出创建用户和添加数据的sql
createUser.sql:
Sql代码
define TESTUSR=&1
define TESTPASSWD=&2
define TABLESPACE=&3
define TESTUSERCONNECTSTRING=&4
create user &TESTUSR identified by &TESTPASSWD default tablespace &TABLESPACE;
--Grant necessary permissions
grant resource to &TESTUSR;
grant CREATE SESSION to &TESTUSR;
grant ALTER SESSION to &TESTUSR;
grant QUERY REWRITE to &TESTUSR;
grant UNLIMITED TABLESPACE to &TESTUSR;
connect &TESTUSERCONNECTSTRING
@add_data.sql
exit;
add_data.sql:
Sql代码
create table student(
name varchar2(20),
age number(3)
);
insert into student values('Kobe Bryant',32);
导入oracle_import.cmd:
@echo off
echo -------------------------------------------------------------------------
echo TEST TABLE CREATE ORACLE
echo -------------------------------------------------------------------------
echo.
title=TEST TABLE CREATE
setlocal
set usage=createIPCDB.cmd [systemUser] [systemPassword] [SERVICENAME] [testUser] [testPassword] [tableSpaceName] [DBSERVER] [DBPORT]
rem # createIPCDB.cmd system ADMIN orcl newUser ADMIN tableSpace songzhiqi-dt 1521
if "%1"=="" goto Exit
set SYSTEMUSER=%1
echo [SYSTEMUSER] %SYSTEMUSER%
if "%2"=="" goto Exit
set SYSTEMPASSWD=%2
if "%3"=="" goto Exit
set SERVICENAME=%3
echo [SERVICENAME] %SERVICENAME%
if "%4"=="" goto Exit
set TESTUSR=%4
echo [TESTUSR] %TESTUSR%
if "%5"=="" goto Exit
set TESTPASSWD=%5
if "%6"=="" goto Exit
set TABLESPACENAME=%6
echo [TABLESPACENAME] %TABLESPACENAME%
if "%7"=="" goto Exit
set DBSERVER=%7
echo [DBSERVER] %DBSERVER%
if "%8"=="" goto Exit
set DBPORT=%8
echo [DBPORT] %DBPORT%
set SYSTEMCONNECTSTRING=%SYSTEMUSER%/%SYSTEMPASSWD%@//%DBSERVER%:%DBPORT%/%SERVICENAME%
set TESTUSERCONNECTSTRING=%TESTUSR%/%TESTPASSWD%@//%DBSERVER%:%DBPORT%/%SERVICENAME%
echo.
echo %SYSTEMCONNECTSTRING%
echo %TESTUSERCONNECTSTRING%
set RUN_SCRIPT=sqlplus -l -s %SYSTEMCONNECTSTRING% @createUser.sql %TESTUSR% %TESTPASSWD% %TABLESPACENAME% %TESTUSERCONNECTSTRING%
echo.
echo %RUN_SCRIPT%
%RUN_SCRIPT%
goto END
exit
:Exit
echo RUN LIKE:
echo %usage%
endlocal
pause
exit
:END
echo.
endlocal
echo.
pause