取得结果集

import java.sql.*;
import java.util.*;
import java.io.IOException;

public class E21NumberingPlanDiscrepancyAlert {
	private static String NUMBERINGPLANDISCREPANCYALERTCODE = "ALE_0030";

	private static java.sql.PreparedStatement pstmt;
	private static java.sql.Connection sqlCon;
	private static java.sql.ResultSet rs;

	public static void main(String[] args) throws SQLException {
		try {
			// sqlCon = getConnection(args[0], args[1], args[2]);
			sqlCon = getConnection("XXXX:1521:XXX", "XXXX",
					"XXX");
			getRegionPrefix(sqlCon);
			System.out.println("End funciton...");
		} catch (Exception e) {

		} finally {
			if (sqlCon != null) {
				sqlCon.close();
				sqlCon = null;
			}
		}
	}

	public static RegionPrefixDO[] getRegionPrefix(Connection sqlCon) throws SQLException {
		System.out.println("start getRegionPrefix.....");
		RegionPrefixDO[] result = null;
		Row oneRow;
		HTMLTable HtmlMail = new HTMLTable();
		Statement writeStat = null;
		String strDescrp = "";
		String szPeriod = "";
		String szPeriod0 = "";
		String szPeriod1 = "";
		String szPeriod2 = "";
		String constrDescrpHead = "<strong><font size=6> Numbering Plan Discrepancy Report </font></strong> v3.0 ";
		try {
			if (sqlCon != null) {
				String sql = "	SELECT des.rco_region_cd, des.mobile, des.acd_area_cd_cd, iad.para,	 "
						+ "	des.mobile, iad.prefix	 "
						+ "	FROM (SELECT rco_region_cd, acd_area_cd_cd,	 "
						+ "	DECODE (bin_ind_id, 1, 'N', 'Y') mobile	 "
						+ "	FROM des_destination	 "
						+ "	WHERE car_carrier_cd = 'AT&T') des,	 "
						+ "	(SELECT rkp.para, iad.ctry_cd || iad.area_cd prefix	 "
						+ "	FROM [e-mail] iad,	 "
						+ "	[e-mail] rkp,	 "
						+ "	[e-mail] ust	 "
						+ "	WHERE iad.usage_type_id = ust.usage_type_id	 "
						+ "	AND iad.eff_strt_date <= SYSDATE	 "
						+ "	AND NVL (iad.eff_end_date, TO_DATE ('31/12/2099', 'DD/MM/YYYY')) >=SYSDATE	 "
						+ "	AND iad.rtng_key_para_id = rkp.rtng_key_para_id	 "
						+ "	AND iad.area_cd_dl_dgt_grp_id IS NULL	 "
						+ "	AND ust.usage_type = 'RFL') iad	 "
						+ "	WHERE des.rco_region_cd <> iad.para  AND des.acd_area_cd_cd <> iad.prefix	 ";

				System.out.println("select sql is:" + sql);

				// pstmt =
				// sqlCon.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
				// pstmt =
				// sqlCon.prepareStatement(sql,ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);

				pstmt = sqlCon.prepareStatement(sql);
				rs = pstmt.executeQuery();

				// rs.last();
				// System.out.println("result = "+rs.getRow());
				// result = new RegionPrefixDO[rs.getRow()];
				// rs.first();

				ArrayList temp = new ArrayList();
				int k = 1;
				while (rs.next()) {
					k++;
					int i = 1;
					RegionPrefixDO regionPrefixDO = new RegionPrefixDO();
					regionPrefixDO.setRcoRegionCD(rs.getString(i++));
					regionPrefixDO.setMobile1(rs.getString(i++));
					regionPrefixDO.setAcdAreaCdCD(rs.getString(i++));
					regionPrefixDO.setPara(rs.getString(i++));
					regionPrefixDO.setMobile2(rs.getString(i++));
					regionPrefixDO.setPrefix(rs.getString(i++));
					if (regionPrefixDO.getRcoRegionCD() != regionPrefixDO
							.getPara()) {
						regionPrefixDO
								.setError("rcoRegionCD is does not mean para");
					}
					if (regionPrefixDO.getAcdAreaCdCD() != regionPrefixDO
							.getPrefix()) {
						regionPrefixDO
								.setError("acdAreaCd is does not mean prefix");
					}

					System.out
							.println("----------------start out print--------------");

					System.out.print(regionPrefixDO.getRcoRegionCD() + "  ");
					System.out.print(regionPrefixDO.getMobile1() + "  ");
					System.out.print(regionPrefixDO.getAcdAreaCdCD() + "  ");
					System.out.print(regionPrefixDO.getPara() + "  ");
					System.out.print(regionPrefixDO.getMobile2() + "  ");
					System.out.print(regionPrefixDO.getPrefix() + "  ");
					System.out.println(regionPrefixDO.getError());

					System.out
							.println("----------------end out print--------------");
					temp.add(regionPrefixDO);
				}
				System.out.println("............k=" + k);
				result = new RegionPrefixDO[temp.size()];
				if (temp.size() > 0) {
					temp.toArray(result);
				}

				// System.out.println("..............start set
				// result...........");
				// for(int i=0;i<result.length;i++){
				// result[i] = new RegionPrefixDO();
				// result[i].setRcoRegionCD(rs.getString(i++));
				// result[i].setMobile1(rs.getString(i++));
				// result[i].setAcdAreaCdCD(rs.getString(i++));
				// result[i].setPara(rs.getString(i++));
				// result[i].setMobile2(rs.getString(i++));
				// result[i].setPrefix(rs.getString(i++));
				// if (result[i].getRcoRegionCD() != result[i].getPara()) {
				// result[i].setError("rcoRegionCD is does not mean para");
				// }
				// if (result[i].getAcdAreaCdCD() != result[i].getPrefix()) {
				// result[i].setError("acdAreaCd is does not mean prefix");
				// }
				// rs.next();
				// }
				// System.out.println("..............end set
				// result...........");
			}
		} catch (Exception e) {
			System.out.println(e.getMessage());
			e.printStackTrace(System.out);
		} finally {
			if (pstmt != null) {
				pstmt.close();
				pstmt = null;
			}
		}
		System.out.println("End RegionPrefix.....");
		return result;
	}
		
	public static Connection getConnection(String szConnectionStr, String user,
			String password) {
		Connection conn = null;
		System.out.println("Getting Connection...");
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
			conn = DriverManager.getConnection("jdbc:oracle:thin:@"
					+ szConnectionStr, user, password);
			System.out.println("Connection success.");
		} catch (Exception e) {
			System.out.println("Connection is fail. Message is:");
			System.out.println(e.getMessage());
		}
		return conn;
	}
}

class RegionPrefixDO {
	String rcoRegionCD;
	String acdAreaCdCD;
	String para;
	String prefix;
	String mobile1;
	String mobile2;
	String error;

	public RegionPrefixDO() {
		rcoRegionCD = "";
		acdAreaCdCD = "";
		para = "";
		prefix = "";
		mobile1 = "";
		mobile2 = "";
		error = "";
	}

	public String getRcoRegionCD() {
		return rcoRegionCD;
	}

	public void setRcoRegionCD(String rcoRegionCD) {
		this.rcoRegionCD = rcoRegionCD;
	}

	public String getAcdAreaCdCD() {
		return acdAreaCdCD;
	}

	public void setAcdAreaCdCD(String acdAreaCdCD) {
		this.acdAreaCdCD = acdAreaCdCD;
	}

	public String getPara() {
		return para;
	}

	public void setPara(String para) {
		this.para = para;
	}

	public String getPrefix() {
		return prefix;
	}

	public void setPrefix(String prefix) {
		this.prefix = prefix;
	}

	public String getMobile1() {
		return mobile1;
	}

	public void setMobile1(String mobile1) {
		this.mobile1 = mobile1;
	}

	public String getMobile2() {
		return mobile2;
	}

	public void setMobile2(String mobile2) {
		this.mobile2 = mobile2;
	}

	public String getError() {
		return error;
	}

	public void setError(String error) {
		this.error = error;
	}

}