public List<FoodDataBean> getSearchArticles(int start, int end,String search, String val, int area) throws Exception{
		Connection conn = null;
		Statement stmt = null;
		ResultSet rs = null;
		List<FoodDataBean> articleList = null;
		try{
			conn = getConnection();
			val = new String(val.getBytes("iso_8859-1"),"utf-8");
			String sql = "select * from (select ROWNUM as RNUM, b.* from (select * from food" +
					" where area="+area+" and "+search+" like '%"+val+"%'"+" order by ref desc, step asc) b) a " +
					"where RNUM >="+start+" and RNUM <="+end;
			stmt = conn.createStatement();
			rs = stmt.executeQuery(sql);
			if(rs.next()){
				articleList = new ArrayList<FoodDataBean>(end);
				do{
					FoodDataBean article = new FoodDataBean();
					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"));
					articleList.add(article);
				}while(rs.next());
			}
		}catch(Exception ex){
			ex.printStackTrace();
		}finally{
			if(rs != null){
				try{rs.close();}
				catch(SQLException e){e.printStackTrace();}
			}
			if(stmt != null){
				try{stmt.close();}
				catch(SQLException e){e.printStackTrace();}
			}
			if(conn != null){
				try{conn.close();}
				catch(SQLException e){e.printStackTrace();}
			}
		}
		return articleList;
	}