public List<ShopDataBean> getCouponList(int start, int end, String id) {
		Connection conn = null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		List<ShopDataBean> couponList = null;
		String sql = "";
		
		try {
			conn = getConnection();
			sql = "select a.* from (select ROWNUM as RNUM, b.* from (select * from coupon where id=?" +
			" order by cou_num desc) b) a where a.RNUM >=? and a.RNUM <=?";
			pstmt = conn.prepareStatement(sql);
			pstmt.setString(1, id);
			pstmt.setInt(2, start);
			pstmt.setInt(3, end);
			rs = pstmt.executeQuery();
			
			if (rs.next()) {
				couponList = new ArrayList<ShopDataBean>();
				do {
					ShopDataBean coupon = new ShopDataBean();
					coupon.setCou_name(rs.getString("cou_name"));
					coupon.setCou_num(rs.getInt("cou_num"));
					coupon.setCou_usage(rs.getInt("cou_usage"));
					coupon.setCou_date(rs.getDate("cou_date"));
					
					couponList.add(coupon);
				} while (rs.next());
			}
			
		} catch (Exception e) {
			e.printStackTrace();
		} finally{
			if(rs != null){
				try{rs.close();}
				catch(SQLException e){e.printStackTrace();}
			}
			if(pstmt != null){
				try{pstmt.close();}
				catch(SQLException e){e.printStackTrace();}
			}
			if(conn != null){
				try{conn.close();}
				catch(SQLException e){e.printStackTrace();}
			}
		}
		return couponList;
	}