From 2cac051908c3f5e6e55b8df6841ebdab18b42abe Mon Sep 17 00:00:00 2001
From: kuboryu <kuboryu@yahoo.co.jp>
Date: Tue, 24 Jan 2017 07:57:03 +0900
Subject: [PATCH] 20170124

---
 com/rapide_act/DataAccessObjects.java |  14 ++--
 com/rapide_act/RapideUnloader.java    | 132 +++++++++++++++++-----------------
 2 files changed, 73 insertions(+), 73 deletions(-)

diff --git a/com/rapide_act/DataAccessObjects.java b/com/rapide_act/DataAccessObjects.java
index 13ab22b..f81f0d2 100644
--- a/com/rapide_act/DataAccessObjects.java
+++ b/com/rapide_act/DataAccessObjects.java
@@ -295,8 +295,8 @@ public class DataAccessObjects{
 			isQuotation = _isQuotation;
 			isMask = _isMask;
 			recCount = 0;
-			String lnSprtr = CmnUtils.getLineSeparator("lnSprtr", System.getProperty("line.separator"));
-			if(System.getProperty("nullMark")!= null)nullMark = System.getProperty("nullMark");
+			String lnSprtr = CmnUtils.getLineSeparator("ls", System.getProperty("line.separator"));
+			if(System.getProperty("nm")!= null)nullMark = System.getProperty("nm");
 			while (rst.next()) {
 				colString = null;
 				for(int i=0;i<ColumnCount;i++){
@@ -393,11 +393,11 @@ public class DataAccessObjects{
 		Clob colClob = null;
 		ByteArrayOutputStream baos = null;
 		InputStream is = null;
-		boolean isQuotation = CmnUtils.getSystemProperty("quotation", true);
-		boolean isMask = CmnUtils.getSystemProperty("inclMaskCols", false)  || CmnUtils.getSystemProperty("exclMaskCols", false);
-		char hankakuMask = CmnUtils.getSystemProperty("hankakuMask", '*');
-		char zenkakuMask = CmnUtils.getSystemProperty("zenkakuMask", '–');
-		String maskPtn = CmnUtils.getSystemProperty("maskPtn", MASK_PTN[MASK_PTN_ALT]);
+		boolean isQuotation = CmnUtils.getSystemProperty("qt", true);
+		boolean isMask = CmnUtils.getSystemProperty("imc", false)  || CmnUtils.getSystemProperty("emc", false);
+		char hankakuMask = CmnUtils.getSystemProperty("hmm", '*');
+		char zenkakuMask = CmnUtils.getSystemProperty("zmm", '–');
+		String maskPtn = CmnUtils.getSystemProperty("mp", MASK_PTN[MASK_PTN_ALT]);
 
 		if (CmnUtils.isColString(_colTypeName)) {
 			colString = _rst.getString(_rec_cnt);
diff --git a/com/rapide_act/RapideUnloader.java b/com/rapide_act/RapideUnloader.java
index a825f07..bf27891 100644
--- a/com/rapide_act/RapideUnloader.java
+++ b/com/rapide_act/RapideUnloader.java
@@ -106,14 +106,10 @@ public class RapideUnloader{
 			prop = new Properties();
 			is = RapideUnloader.class.getClassLoader().getResourceAsStream(_propFile);
 			prop.load(is);
-			driver = prop.getProperty(database + "." + "driver");
-			user = prop.getProperty(database + "." + "user");
-			pass = prop.getProperty(database + "." + "pass");
+			user = prop.getProperty(database + "." + "us");
+			pass = prop.getProperty(database + "." + "pw");
 			url = prop.getProperty(database + "." + "url");
-			CmnUtils.debugPrint("user=" + user);
-			CmnUtils.debugPrint("pass=" + pass);
-			CmnUtils.debugPrint("url=" + url);
-			CmnUtils.debugPrint("driver=" + driver);
+			driver = prop.getProperty(database + "." + "dr");
 			is.close();
 			is = null;
 		} catch (NullPointerException e) {
@@ -155,55 +151,57 @@ public class RapideUnloader{
 		int tb_count 					= 0;
 		int tb_col_count 				= 0;
 
-		boolean isOrder 				= CmnUtils.getSystemProperty("order", false);
-		boolean isQuotation 			= CmnUtils.getSystemProperty("quotation", true);
-		boolean isInclTables 			= CmnUtils.getSystemProperty("inclTables", false);
-		boolean isExclTables 			= CmnUtils.getSystemProperty("exclTables", false);
-		boolean isMask 					= CmnUtils.getSystemProperty("inclMaskCols", false) || CmnUtils.getSystemProperty("exclMaskCols", false);
-		boolean isInclMaskCols 			= CmnUtils.getSystemProperty("inclMaskCols", false);
-		boolean isExclMaskCols 			= CmnUtils.getSystemProperty("exclMaskCols", false);
-		boolean isInclCols 				= CmnUtils.getSystemProperty("inclCols", false);
-		boolean isExclCols 				= CmnUtils.getSystemProperty("exclCols", false);
-		String sprtr 					= CmnUtils.getSeparator("sprtr", "\t");
-		String lnSprtr 					= CmnUtils.getLineSeparator("lnSprtr", System.getProperty("line.separator"));
-		String inColSprtr 				= CmnUtils.getLineSeparator("inColSprtr", System.getProperty("line.separator"));
+		boolean isOrder 				= CmnUtils.getSystemProperty("od", false);
+		boolean isQuotation 			= CmnUtils.getSystemProperty("qt", true);
+		boolean isInclTables 			= CmnUtils.getSystemProperty("it", false);
+		boolean isExclTables 			= CmnUtils.getSystemProperty("et", false);
+		boolean isInclCols 				= CmnUtils.getSystemProperty("ic", false);
+		boolean isExclCols 				= CmnUtils.getSystemProperty("ec", false);
+		boolean isMask 					= CmnUtils.getSystemProperty("imc", false) || CmnUtils.getSystemProperty("emc", false);
+		boolean isInclMaskCols 			= CmnUtils.getSystemProperty("imc", false);
+		boolean isExclMaskCols 			= CmnUtils.getSystemProperty("emc", false);
+		String dlmtr 					= CmnUtils.getSeparator("dm", "\t");
+		String lnSprtr 					= CmnUtils.getLineSeparator("ls", System.getProperty("line.separator"));
 		String defaultFldr 				= "output";
-		String outFldr 					= System.getProperty("output");
-		String inclTables 				= System.getProperty("inclTables");
-		String exclTables 				= System.getProperty("exclTables");
-		String inclCols 				= System.getProperty("inclCols");
-		String exclCols 				= System.getProperty("exclCols");
-		String inclMaskCols 			= System.getProperty("inclMaskCols");
-		String exclMaskCols 			= System.getProperty("exclMaskCols");
-		String [] aryInclTables 		= CmnUtils.getSystemProperty("inclTables");
-		String [] aryExclTables 		= CmnUtils.getSystemProperty("exclTables");
-		String [] aryInclMaskCols 		= CmnUtils.getSystemProperty("inclMaskCols");
-		String [] aryExclMaskCols 		= CmnUtils.getSystemProperty("exclMaskCols");
-		String [] aryInclCols 			= CmnUtils.getSystemProperty("inclCols");
-		String [] aryExclCols 			= CmnUtils.getSystemProperty("exclCols");
-		char hankakuMask				= CmnUtils.getSystemProperty("hankakuMask", '*');
-		char zenkakuMask 				= CmnUtils.getSystemProperty("zenkakuMask", '–');
-		String maskPtn 					= CmnUtils.getSystemProperty("maskPtn", "alt");
-		String fileEncoding 			= CmnUtils.getSystemProperty("fileEncoding", System.getProperty("file.encoding"));
+		String outFldr 					= System.getProperty("out");
+		String inclTables 				= System.getProperty("it");
+		String exclTables 				= System.getProperty("et");
+		String inclCols 				= System.getProperty("ic");
+		String exclCols 				= System.getProperty("ec");
+		String inclMaskCols 			= System.getProperty("imc");
+		String exclMaskCols 			= System.getProperty("emc");
+		String [] aryInclTables 		= CmnUtils.getSystemProperty("it");
+		String [] aryExclTables 		= CmnUtils.getSystemProperty("et");
+		String [] aryInclMaskCols 		= CmnUtils.getSystemProperty("imc");
+		String [] aryExclMaskCols 		= CmnUtils.getSystemProperty("emc");
+		String [] aryInclCols 			= CmnUtils.getSystemProperty("ic");
+		String [] aryExclCols 			= CmnUtils.getSystemProperty("ec");
+		char hankakuMask				= CmnUtils.getSystemProperty("hmm", '*');
+		char zenkakuMask 				= CmnUtils.getSystemProperty("zmm", '–');
+		String maskPtn 					= CmnUtils.getSystemProperty("mp", "alt");
+		String fileEncoding 			= CmnUtils.getSystemProperty("fe", System.getProperty("file.encoding"));
 
 		if(database != null){
-			if(System.getProperty("propFile") != null){
-				getProperties(System.getProperty("propFile"));
+			if(System.getProperty("pf") != null){
+				getProperties(System.getProperty("pf"));
 			} else {
 				getProperties(propFile);
 			}
 		} else {
-			user = System.getProperty("user");
-			pass = System.getProperty("pass");
+			user = System.getProperty("us");
+			pass = System.getProperty("pw");
 			url = System.getProperty("url");
-			driver = System.getProperty("driver");
-			
+			driver = System.getProperty("dr");
 		}
+		CmnUtils.debugPrint("user=" + user);
+		CmnUtils.debugPrint("password=" + pass);
+		CmnUtils.debugPrint("url=" + url);
+		CmnUtils.debugPrint("driver=" + driver);
 
 		if(user == null){
 			throw new Exception("user is null");
 		} else if (pass == null){
-			throw new Exception("pass is null");
+			throw new Exception("password is null");
 		} else if (url == null){
 			throw new Exception("url is null");
 		} else if (driver == null){
@@ -234,7 +232,7 @@ public class RapideUnloader{
 			if(outFldr != null){
 				fldr = new File(outFldr);
 			} else {
-				if (database != null){
+				if(database != null){
 					fldr = new File(defaultFldr + "/" + database.toUpperCase() + "_" + CmnUtils.getYmdhm());
 				} else {
 					fldr = new File(defaultFldr + "/" + DB_TYPE_NAME[dbType].toUpperCase() + "_" + CmnUtils.getYmdhm());
@@ -242,24 +240,26 @@ public class RapideUnloader{
 				fldr.mkdir();
 			}
 			
-			CmnUtils.infoPrint("-->‘Ώۃf[ƒ^ƒx[ƒX='" + database.toUpperCase() + "'");
-			CmnUtils.infoPrint("-->o—͐æ='" + fldr + "'");
-			CmnUtils.infoPrint("-->‹æØ‚蕶Žš='" + sprtr + "'");
-			CmnUtils.infoPrint("-->ƒ\[ƒg=" + CmnUtils.getYesNo(isOrder));
-			CmnUtils.infoPrint("-->ˆø—p‹å=" + CmnUtils.getYesNo(isQuotation));
-			if(isInclTables)CmnUtils.infoPrint("-->‘Ώۃe[ƒuƒ‹='" + inclTables.toUpperCase() + "'");
-			if(isExclTables)CmnUtils.infoPrint("-->œŠOƒe[ƒuƒ‹='" + exclTables.toUpperCase() + "'");
-			if(isInclCols)CmnUtils.infoPrint("-->‘ΏۃJƒ‰ƒ€='" + inclCols.toUpperCase() + "'");
-			if(isExclCols)CmnUtils.infoPrint("-->œŠOƒJƒ‰ƒ€='" + exclCols.toUpperCase() + "'");
-			CmnUtils.infoPrint("-->ƒ}ƒXƒLƒ“ƒO=" + CmnUtils.getYesNo(isMask));
+			if(database!=null)CmnUtils.infoPrint("-->Database='" + database.toUpperCase() + "'");
+			CmnUtils.infoPrint("-->Output='" + fldr + "'");
+			if(System.getProperty("dm")!=null)CmnUtils.infoPrint("-->Delimiter='" + dlmtr + "'");
+			if(System.getProperty("ls")!=null)CmnUtils.infoPrint("-->LineSeparator='" + System.getProperty("ls") + "'");
+			if(System.getProperty("fe")!=null)CmnUtils.infoPrint("-->FileEncoding='" + fileEncoding + "'");
+			if(System.getProperty("qt")!=null)CmnUtils.infoPrint("-->Quotation=" + CmnUtils.getYesNo(isQuotation));
+			if(System.getProperty("od")!=null)CmnUtils.infoPrint("-->Sort=" + CmnUtils.getYesNo(isOrder));
+			if(isInclTables)CmnUtils.infoPrint("-->Include Tables='" + inclTables.toUpperCase() + "'");
+			if(isExclTables)CmnUtils.infoPrint("-->Exclude Tables='" + exclTables.toUpperCase() + "'");
+			if(isInclCols)CmnUtils.infoPrint("-->Include Columns='" + inclCols.toUpperCase() + "'");
+			if(isExclCols)CmnUtils.infoPrint("-->Exclude Columns='" + exclCols.toUpperCase() + "'");
 			if(isMask){
-				CmnUtils.infoPrint("-->ƒ}ƒXƒNƒLƒ“ƒOƒpƒ^[ƒ“=" + maskPtn.toUpperCase());
-				if(isInclMaskCols)CmnUtils.infoPrint("-->ƒ}ƒXƒN‘ΏۃJƒ‰ƒ€='" + inclMaskCols.toUpperCase() + "'");
-				if(isExclMaskCols)CmnUtils.infoPrint("-->ƒ}ƒXƒNœŠOƒJƒ‰ƒ€='" + exclMaskCols.toUpperCase() + "'");
-				CmnUtils.infoPrint("-->”¼Špƒ}ƒXƒN•¶Žš='" + hankakuMask + "'");
-				CmnUtils.infoPrint("-->‘SŠpƒ}ƒXƒN•¶Žš='" + zenkakuMask + "'");
+				CmnUtils.infoPrint("-->Masking=" + CmnUtils.getYesNo(isMask));
+				CmnUtils.infoPrint("-->Masking Pattern=" + maskPtn.toUpperCase());
+				if(isInclMaskCols)CmnUtils.infoPrint("-->Masking Columns='" + inclMaskCols.toUpperCase() + "'");
+				if(isExclMaskCols)CmnUtils.infoPrint("-->NonMasking Columns='" + exclMaskCols.toUpperCase() + "'");
+				CmnUtils.infoPrint("-->1byte Mask Mark='" + hankakuMask + "'");
+				CmnUtils.infoPrint("-->2byte Mask Mark='" + zenkakuMask + "'");
 			}
-			CmnUtils.infoPrint("ƒf[ƒ^ƒAƒ“ƒ[ƒh‚ðŠJŽn‚µ‚Ü‚µ‚½B");
+			CmnUtils.infoPrint("Start DataUnload ---------------------------------------------");
 
 			dao.select(sql_table_list);
 			alData = dao.getArrayList();
@@ -330,7 +330,7 @@ public class RapideUnloader{
 										 !CmnUtils.isMatch(aryExclMaskCols,alData.get(i).toUpperCase(),alColName.get(j).toUpperCase())
 										) 
 									){
-										CmnUtils.debugPrint("ƒ}ƒXƒN‘ΏۃJƒ‰ƒ€" + alColName.get(j).toUpperCase());
+										CmnUtils.debugPrint("Mask Column=" + alColName.get(j).toUpperCase());
 										alColMask.add(true);
 									} else {
 										alColMask.add(false);
@@ -357,7 +357,7 @@ public class RapideUnloader{
 									 !CmnUtils.isMatch(aryExclCols,alData.get(i).toUpperCase(),alColName.get(j).toUpperCase())
 									)
 								){
-									CmnUtils.debugPrint("‘ΏۃJƒ‰ƒ€=" + alColName.get(j).toUpperCase());
+									CmnUtils.debugPrint("column=" + alColName.get(j).toUpperCase());
 									alColIncl.add(true);
 								} else {
 									alColIncl.add(false);
@@ -416,15 +416,15 @@ public class RapideUnloader{
 									} else {
 										if(colIncl[j]){
 											if(isQuotation){
-												pw.print("\"" + sprtr + "\"");
+												pw.print("\"" + dlmtr + "\"");
 											} else {
-												pw.print(sprtr);
+												pw.print(dlmtr);
 											}
 										}
 									}
 								}
 							}
-							dao.getRecordToPrint(pw,sprtr,isQuotation,isMask,firstCol,lastCol);
+							dao.getRecordToPrint(pw,dlmtr,isQuotation,isMask,firstCol,lastCol);
 							dao.closeRecordSet();
 							pw.close();
 							pw = null;
@@ -459,7 +459,7 @@ public class RapideUnloader{
 				pw=null;
 			}
 		}
-		CmnUtils.infoPrint("ƒf[ƒ^ƒAƒ“ƒ[ƒh‚ðI—¹‚µ‚Ü‚µ‚½B");
+		CmnUtils.infoPrint("End DataUnload -----------------------------------------------");
 	}
 
 
-- 
2.11.0