public class ProductSearchDAOOracleImpl extends OracleDAOImpl implements ProductSearchDAO {
	private String QUERY_GETCATEGORY = "SELECT * FROM Category";
	//ProductSearchForm productsearchform=(ProductSearchForm) form;
	private ArrayList categoryArray= new ArrayList() ;	
	@Override
	public ProductSearchDBVO getCategory() 
	       throws DatabaseException {
		ProductSearchDBVO productsearchDBVO = null;
		Connection conn = null;
		PreparedStatement pstmt = null;
		ResultSet resultSet = null;
 
		try {
			conn = getConnection();
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			throw new DatabaseException(e);
		}
 
		try {
			pstmt = conn.prepareStatement(QUERY_GETCATEGORY);
			resultSet = pstmt.executeQuery();
			while (resultSet.next()) {
				productsearchDBVO=new ProductSearchDBVO();
				productsearchDBVO.setProductCategory(resultSet.getString(1));
			categoryArray.add(productsearchDBVO);
			}
 
 
	}catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
		throw new DatabaseException(e);
	}finally {
	// Close all the resources properly.
	closeResources(resultSet, pstmt, conn);
	}
 
	return productsearchDBVO;
	}
 
}

request.setAttribute("array",categoryList);

request.setAttribute("array",categoryArray);

while (resultSet.next()) {
	productsearchDBVO=new ProductSearchDBVO();
	productsearchDBVO.setProductCategory(resultSet.getString(1));
	categoryArray.add(productsearchDBVO);
}