import javax.servlet.jsp.*;
import javax.servlet.jsp.tagext.*;
import java.io.*;
import java.sql.*;
import java.util.*;

public class ForEachRowTag extends BodyTagSupport
{
	private ConnectTag ct;
	public int doStartTag() throws JspException
	{
		ct = (ConnectTag)findAncestorWithClass(this,ConnectTag.class);
		if( ct == null){
			throw new JspException("In [ForEachRow]:No ConnectTag Object error.");
		}	
		System.out.println("ForEachRowTag.doStartTag()......");
		return incrementRow();
	}
	public int doAfterBody() throws JspException
	{
		System.out.println("ForEachRowTag.doAfterBody()......");
		return incrementRow();		
	}
	private int incrementRow() throws JspException
	{
		ResultSet rs = ct.getResultSet();
		if(rs == null ){
			throw new JspException("No resultset.");
		}
		boolean hasNext;
		try{
			hasNext = rs.next();
		}catch(SQLException e){
			throw new JspException(e.getMessage());
		}
		System.out.println("ForEachRowTag.incrementRow()......");
		if(hasNext){
			return EVAL_BODY_TAG;
	 	}else{
	 		return SKIP_BODY;
	 	}
	}
	public int doEndTag() throws JspException
	{
		try{
			pageContext.getOut().print(bodyContent.getString());	
		}catch(IOException e){
			throw new JspException(e.getMessage());
		}
		System.out.println("ForEachRowTag.doEndTag()......");
		return EVAL_PAGE;	
	}
}