/**
 ** SQLResult.java
 ** Wrap resultset in something more friendly!
 ** @author Jack Wootton
 **/

package beans.jw;
import java.io.Serializable;

public class SQLResult
{
    private Fields columns[];		// mirrors database table
    private int columnPointer = 0;	// keeps track of which attribute we're looking at
    private int currentPos = 0;		// holds reference to last item
	private int size = -1;

	public SQLResult() { }
    public int getColumnPointer() { return columnPointer; }
    public void setColumnPointer(int n) { columnPointer = n; }
    public int getCurrentPos() { return currentPos; }
    public void setCurrentPos(int n) { currentPos = n; }
    public Fields[] getColumns() {return columns; }
    public void setColumns(Fields[] attr) { columns = attr ;}
    public int width() { return columns.length; }
	public int getSize() { return size; }

    public String trimAndUpper(String tmp)
    { 
        return (tmp.trim().toUpperCase());
    }
    
    public int length()
    {
        if (columns.length > 0)
            return columns[0].length();
        else
            return 0;
    }
    
    public boolean isEmpty()
    {
        if (columns.length > 0)
            return columns[0].isEmpty();
        else
            return true;
    }
    
    public String AttributeName(int i)
    {
        return columns[i].getName();
    }
    
    public void setSize(int size)
    {
        this.size = size;
		columns = new Fields[size];
    }
    
    public void newAttribute(String name)
    {
        columns[currentPos++] = new Fields(trimAndUpper(name));
    }
    
    public void addRecord(String attributeName, String value)
    {
        for(int j = 0; j < columns.length; j++)
        {
            if( columns[j].getName().equals(trimAndUpper(attributeName)) )
                columns[j].addItem(value);
        }
    }
    
    public String getEntry(String attributeName, int i)
    {
        String ret = ""; 
        for(int k = 0; k < columns.length; k++)
         {
              if( columns[k].getName().equals(trimAndUpper(attributeName)))
                  ret = columns[k].getItem(i);
         }
        return ret;
    }
}