set _SCRIPT_DRIVE=%~d0
SET PATH="C:/Program Files (x86)/Java/jdk1.7.0_11/bin";%PATH%
SET COOP=ICOOP
SET CORE=ICORE
SET CORE_PATH=%_SCRIPT_DRIVE%\%COOP%_ALL\%CORE%\%COOP%\iReport\ReportBuilderCORE\
SET CLASSPATH=%CORE_PATH%\dist\lib\mysql-connector-java-5.1.38-bin.jar;%CORE_PATH%\OracleLib\ojdbc7.jar;%CORE_PATH%\dist\lib\xml-apis-1.3.04.jar;%CORE_PATH%\dist\lib\xerces-2.8.0.jar;%CORE_PATH%\dist\lib\xalan-2.7.0.jar;%CORE_PATH%\dist\lib\serializer-2.7.0.jar;%CLASSPATH%
SET DRIVER=%1
SET CONNSTR=%2
SET USR=%3
SET PWD=%4
SET PROCESS=%5
SET ARG=%6
javac JavaProcessing.java
rem java -cp %CLASSPATH% JavaProcessing com.mysql.jdbc.Driver jdbc:mysql://192.168.10.149:3306/iscocukj iscocukj iscocukj DIV 2559 
java -cp %CLASSPATH% JavaProcessing  %DRIVER% %CONNSTR% %USR% %PWD% %PROCESS% %ARG%
rem select member_no,div_year,yr_rate,sum(share_amtnet) as share_amtnet,round(sum(div_amt),2) as div_amt from yrdivmas where div_year='2559' group by member_no,div_year,yr_rate order by member_no asc,div_year asc,yr_rate asc ;
rem SET /P E=Enter to quit