DB - Import Oracle DB Script

@echo off
SETLOCAL

Set USERNAME=userid
Set PASSWORD=ps
Set SID=artd
Set DATA_FILE=outdat

@rem Check all value exist before we start the process

if "%USERNAME%" == "" goto formaterror
if "%PASSWORD%" == "" goto formaterror
if "%SID%" == "" goto formaterror
if "%DATA_FILE%" == "" goto formaterror

goto main

:formaterror
echo Usage: import [username] [password] [sid] [data_filename]
@echo off
goto finish

:main
SQLPLUS %USERNAME%/%PASSWORD%@%SID%
cd ..
imp %USERNAME%/%PASSWORD%@%SID% file=%DATA_FILE%.dmp log=%USERNAME%imp.log fromuser=%USERNAME% touser=%USERNAME% ignore=y

:finish

DB - Export Oracle DB Script

@echo off
SETLOCAL

Set USERNAME=userid
Set PASSWORD=ps
Set SID=ARTD
Set OUTPUT_FILE=outdat

@rem Check all value exist before we start the process

if "%USERNAME%" == "" goto formaterror
if "%PASSWORD%" == "" goto formaterror
if "%SID%" == "" goto formaterror
if "%OUTPUT_FILE%" == "" goto formaterror

goto process

:formaterror
echo Usage: export [username] [password] [sid] [output_filename]
@echo off
goto finish

:process
exp %USERNAME%/%PASSWORD%@%SID% file=%OUTPUT_FILE%.dmp log=%USERNAME%exp.log owner=%USERNAME%

:finish

ENDLOCAL

Struts - Set : If

<s:set name="isCust" value="%{'true'}"/>

<s:if test="%{#isCust=='true'}">
<td> class="colHeader"> </td>
<td> </td>
</s:if>

Struts - Combine 2 value in Textfield

<s:textfield name="data.firstName" value="${data.salutation} ${data.firstName}" required="false" size="25" theme="simple" readonly="true"/>

salutation = Mr
firstname = Kiat Hooi

Display value = Mr Kiat Hooi