public static List<MeasureSite> findAllMeasureSite() {

		List<MeasureSite> measureSiteList = new ArrayList<MeasureSite>();
		MeasureSite measureSite = null;
		ResultSet rs = null;
		Statement stmt = null;
		Connection conn = null;
		try {

			// new oracle.jdbc.driver.OracleDriver();
			// jdbc.url=jdbc\:oracle\:thin\:@192.168.72.99\:1521\:orcl
			// jdbc.username=lkmes2
			// jdbc.password=lkmes2

			Properties prop = new Properties();// 属性集合对象
			// FileInputStream fis = new FileInputStream("jdbc.properties");// 属性文件流
			InputStream fis = Thread.currentThread().getContextClassLoader().getResourceAsStream("jdbc.properties");
			prop.load(fis);// 将属性文件流装载到Properties对象中
			String driverClassName = prop.getProperty("jdbc.driverClassName");
			// jdbc.url=jdbc\:oracle\:thin\:@10.1.11.222\:1521\:orcl
			String url = prop.getProperty("jdbc.url");
			// jdbc.username=lkmes2
			String username = prop.getProperty("jdbc.username");
			// jdbc.password=lkmes2
			String password = prop.getProperty("jdbc.password");

			Class.forName(driverClassName);
			conn = DriverManager.getConnection(url, username, password);
			stmt = conn.createStatement();
			rs = stmt.executeQuery("select * from MES_MME_MEASURE_SITE");
			while (rs.next()) {
				System.out.println("#####");
				measureSite = new MeasureSite();
				// SID NUMBER(15) NOT NULL,
				long sid = rs.getLong("sid");
				System.out.println(sid);
				measureSite.setSid(sid);
				// METER_NAME VARCHAR2(40 BYTE),
				String meterName = rs.getString("METER_NAME");
				System.out.println(meterName);
				measureSite.setMeterName(meterName);
				// IP VARCHAR2(40 BYTE),
				String ip = rs.getString("IP");
				System.out.println(ip);
				measureSite.setIp(ip);
				// SITE_NO VARCHAR2(32 BYTE) NOT NULL,
				String siteNo = rs.getString("SITE_NO");
				System.out.println(siteNo);
				measureSite.setIp(ip);
				// SITE_NAME VARCHAR2(64 BYTE) NOT NULL,
				String siteName = rs.getString("SITE_NAME");
				System.out.println(siteName);
				measureSite.setIp(ip);
				// SITE_TYPE VARCHAR2(3 BYTE),
				// ZERO_STANDARD VARCHAR2(10 BYTE),
				// CREATED_BY VARCHAR2(32 BYTE),
				// CREATED_DT DATE,
				// UPDATED_BY VARCHAR2(32 BYTE),
				// UPDATED_DT DATE,
				// VERSION NUMBER(9),
				// COM_PORT VARCHAR2(10 BYTE),
				String comPort = rs.getString("COM_PORT");
				System.out.println(comPort);
				measureSite.setComPort(comPort);
				// COM_FREQUENCY NUMBER(8)
				int comFrequency = rs.getInt("COM_FREQUENCY");
				System.out.println(comFrequency);
				measureSite.setComFrequency(comFrequency);
				measureSiteList.add(measureSite);
			}
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		} catch (FileNotFoundException e) {
			e.printStackTrace();
		} catch (IOException e) {
			e.printStackTrace();
		} finally {
			try {
				if (rs != null) {
					rs.close();
					rs = null;
				}
				if (stmt != null) {
					stmt.close();
					stmt = null;
				}
				if (conn != null) {
					conn.close();
					conn = null;
				}
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}

		return measureSiteList;
	}