public List getarticleList(int start, int end, int area) throws Exception{
		Connection conn = null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		List articleList = null;
		String sql  = "";
		try{
			conn = getConnection();
			/*추천지수 불러오는sql*/
			sql = "update board set recommand_count = recommand - non_recommand ";
			pstmt = conn.prepareStatement(sql);
			pstmt.executeUpdate();
		
			sql = "select a.* from (select ROWNUM as RNUM, b.* from (select * from board" +
					" order by idx desc) b order by ref desc, step asc) a where a.RNUM >=? and a.RNUM <=?";
			pstmt = conn.prepareStatement(sql);
			pstmt.setInt(1, start);
			pstmt.setInt(2, end);
			rs = pstmt.executeQuery();
			if(rs.next()){
				articleList = new ArrayList(end);
				do{
					BoardDataBean article = new BoardDataBean();
					article.setIdx(rs.getInt("idx"));
					article.setArea_idx(rs.getInt("area_idx"));
					article.setTitle(rs.getString("title"));
					article.setContent(rs.getString("content"));
					article.setNickname(rs.getString("nickname"));
					article.setId(rs.getString("id"));
					article.setWdate(rs.getTimestamp("wdate"));
					article.setRead_count(rs.getInt("read_count"));
					article.setRecommand_count(rs.getInt("recommand_count"));
					article.setRecommand(rs.getInt("recommand"));
					article.setNon_recommand(rs.getInt("non_recommand"));
					article.setCategory(rs.getString("category"));
					article.setDepth(rs.getInt("depth"));
					articleList.add(article);
					
				}
				while(rs.next());
			}
		}catch(Exception ex){
			System.out.println("boardDBBean getarticleList : " + ex);
		}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 articleList;
		
	}