private void importData(String tableName, String query,
			List<TableField> fieldsList, Connection bizConn, Connection memConn)
			throws Exception {
		// 共多少行
		int totalRowNum = 0;
		// 共多少页
		int totalPage = 0;
		// 相同字段
		List<String> joinFieldList = null;
		PreparedStatement pst = null;
		try {
			memConn.setAutoCommit(false);
			Dialect dialect = Dialect.getInstance(bizConn);
			// 相同字段
			joinFieldList = sortingFields(query, fieldsList, bizConn);

			StringBuffer sbJoin = new StringBuffer();
			for (int i = 0; i < joinFieldList.size(); i++) {
				if (sbJoin.length() > 0) {
					sbJoin.append(",");
				}
				sbJoin.append(joinFieldList.get(i));
			}
			String querySql = "SELECT " + sbJoin.toString() + " FROM (" + query
					+ ") queryTmpView ";
			totalRowNum = dialect.getMaxRowNum(querySql, bizConn);
			totalPage = dialect.totalPage(totalRowNum, chunkSize);
			if (totalPage > 0) {
				StringBuffer fieldSB = new StringBuffer();
				StringBuffer fieldSBV = new StringBuffer();
				for (int i = 0; i < joinFieldList.size(); i++) {
					String fieldName = joinFieldList.get(i);
					if (fieldSB.length() > 0) {
						fieldSB.append(",");
						fieldSBV.append(",");
					}
					fieldSB.append(fieldName);
					fieldSBV.append("?");
				}
				StringBuffer sb = new StringBuffer();
				sb.append("INSERT INTO ");
				sb.append(tableName);
				sb.append(" (");
				sb.append(fieldSB);
				sb.append(") ");
				sb.append(" VALUES ");
				sb.append("(");
				sb.append(fieldSBV);
				sb.append(")");
				pst = memConn.prepareStatement(sb.toString(),
						ResultSet.TYPE_SCROLL_SENSITIVE,
						ResultSet.CONCUR_UPDATABLE);
			}
			for (int i = 0; i < totalPage; i++) {
				try {
					memConn.setAutoCommit(false);
					String sql = dialect.getLimitString(querySql,
							i * chunkSize, chunkSize);
					ResultSet rs = util.getResultSetBySql(bizConn, sql);
					int batchSize = chunkUpdate(rs, pst, joinFieldList);
					System.out.println("导入数据量：" + batchSize);
					util.close(rs);
					memConn.commit();
				} catch (Exception e) {
					memConn.rollback();
					throw e;
				}
			}
		} catch (Exception e) {
			throw e;
		} finally {
			util.close(pst);
		}
	}