private ArrayList<RealTimePrice> getPriceList(
			Timestamp firstTime, Timestamp tomorrow) {
		Connection conn = null;
		ArrayList<RealTimePrice> priceList = new ArrayList<RealTimePrice>();
		try {
			conn = DriverManager.getConnection(Utils.CONNECT_STRING);		
			String PriceSql = "select * from PH_PRICE where ELETYPE = 'res' AND TIME >= ? and Time <= ? ORDER BY TIME ASC NULLS LAST";
			PreparedStatement priceStatement = conn.prepareStatement(PriceSql);
			priceStatement.setTimestamp(1, firstTime);
			priceStatement.setTimestamp(2, tomorrow);
			ResultSet priceRet = priceStatement.executeQuery();

			if (priceRet != null) {
				while (priceRet.next()) {
					RealTimePrice tempPrice = new RealTimePrice();
					tempPrice.time = priceRet.getTimestamp(1);
					tempPrice.price = priceRet.getFloat(3);
					priceList.add(tempPrice);
				}
			}
		} catch (SQLException e) {

			e.printStackTrace();
		}finally{
		
		try {
			if(!conn.isClosed()){
				conn.close();
			}
		} catch (SQLException e) {

			e.printStackTrace();
		}
		}
		return priceList;
	}