public void copyBatch(String targetTable, String sourceTable,
			Hashtable<String, Object> conditionHt,
			List<Hashtable<String, Object>> replaceColumnValueLt)
			throws Exception {		
		ArrayList<ArrayList<Object>> paramValueList = new ArrayList<ArrayList<Object>>();

		ArrayList<String> targetColumnList = getTblColList(targetTable);
		_log.debug("[" + targetTable + "]get table columns " + targetColumnList);

		ArrayList<String> defaultColumnList = getDefTblColList(targetTable);
		_log.debug("[" + targetTable + "]get has default value columns"
				+ defaultColumnList);

		List removeList = new ArrayList();
		if (!sourceTable.equals(targetTable)) {
			ArrayList<String> sourceColList = getTblColList(sourceTable);
			_log.debug("[" + sourceTable + "]get table columns "
					+ sourceColList);
			for (Map map : replaceColumnValueLt) {
				for (String tCol : targetColumnList) {
					if (!sourceColList.contains(tCol)) {
						if (!map.containsKey(tCol)) {
							if (defaultColumnList.contains(tCol)) {
								if (!removeList.contains(tCol))
									removeList.add(tCol);
							} else {
								map.put(tCol, "");
							}// end if
						}// end if
					}// end if
				}// end for
			}// end for

		}

		for (int x = 0, xSize = removeList.size(); x < xSize; x++) {
			String rCol = (String) removeList.get(x);
			targetColumnList.remove(rCol);
		}

		for (Map map : replaceColumnValueLt) {
			ArrayList<Object> tmpList = new ArrayList<Object>();
			for (String column : targetColumnList) {
				if (map.containsKey(column)) {
					tmpList.add(map.get(column));
				}
			}
			paramValueList.add(tmpList);
		}

		for (ArrayList<Object> array : paramValueList) {
			Enumeration e = conditionHt.keys();
			while (e.hasMoreElements()) {
				String column = (String) e.nextElement();
				Object value = conditionHt.get(column);
				if (!(value instanceof List)) {
					array.add(conditionHt.get(column));
				}
			}
		}

		/* ================prepare sql=================== */
		StringBuffer sql = new StringBuffer();
		sql.append("INSERT INTO " + targetTable + " (");
		for (String column : targetColumnList) {
			sql.append(column.toLowerCase() + ", ");
		}
		sql.setLength(sql.length() - 2);

		Hashtable replaceColumnValueHt = replaceColumnValueLt.get(0);

		sql.append(") SELECT ");
		for (String column : targetColumnList) {
			if (replaceColumnValueHt.containsKey(column)) {
				sql.append("?, ");
			} else {
				sql.append(column.toLowerCase() + ", ");
			}
		}
		sql.setLength(sql.length() - 2);

		sql.append(" FROM " + sourceTable + " WHERE ");
		Enumeration e = conditionHt.keys();
		while (e.hasMoreElements()) {
			String column = (String) e.nextElement();
			Object value = conditionHt.get(column);
			if (value instanceof List) {
				sql.append(column.toLowerCase() + " IN ")
						.append(TransFormat.convertListToIN((List) value))
						.append(" AND ");
			} else {
				sql.append(column.toLowerCase() + " = ? AND ");
			}
		}
		sql.setLength(sql.length() - 4);

		/* =============start execute============= */
		SqlBean sqlBean = new SqlBean(_conn, sql.toString(), _log);
		for (int i = 0; i < paramValueList.size(); i++) {
			ArrayList<Object> pList = paramValueList.get(i);
			for (int j = 0; j < pList.size(); j++) {
				sqlBean.addParameter(pList.get(j));
			}
			sqlBean.addBatch();
		}

		sqlBean.executeBatch();
	}