jakarta-ecs-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thufir <hawat.thu...@gmail.com>
Subject custom Table
Date Tue, 24 Feb 2009 02:53:18 GMT
I think that the problem with this class is that setColumnNames and 
setData aren't really setting attributes.  I suppose I should make 
instance attributes like "header" and "data"?

(luckily we're moving into JSP soon, but, still...)

also, is there a problem with passing ResultSet around to different 
objects?  I read that there's a problem with that.


package a00720398.html;

//adapted from oreilly sample in ch 16
//      Java Servlet Programming, Second Edition
//         http://oreilly.com/catalog/9780596000400/


import java.sql.*;
import org.apache.ecs.html.*;


public class ResultSetTable extends Table {

    private static final boolean isPretty = true;
    private ResultSet rst = null;
    ResultSetMetaData rsmd = null;

    public ResultSetTable() {
    }

    public ResultSetTable(ResultSet rst) throws SQLException {
        this.rst = rst;
        rsmd = rst.getMetaData();
        setBorder(1);
        setColumnNames();
        setData();
    }
    
    public void setResultSet(ResultSet rst) throws SQLException {
        this.rst = rst;
        rsmd = rst.getMetaData();
    }
  
    private void setColumnNames() throws SQLException {
        int colCount = rsmd.getColumnCount();
        TR tr = new TR();
        tr.setPrettyPrint(isPretty);

        A a = new A();
        a.setPrettyPrint(isPretty);
        a.setHref("/Assignment?crud=D&row=0");
        //<http://www.google.ca/search?q=doget
+url&ie=utf-8&oe=utf-8&aq=t&rls=com.ubuntu:en-
US:unofficial&client=firefox-a
        a.addElement("delete");

        TH colZero = new TH();
        colZero.setPrettyPrint(isPretty);
        colZero.addElement(a);
        tr.addElement(colZero);

        for (int i = 1; i <= colCount; i++) {
            TH th = new TH();
            th.setPrettyPrint(isPretty);
            th.addElement(rsmd.getColumnLabel(i));
            tr.addElement(th);
        }
        addElement(tr);
    }

    private void setData() throws SQLException {
        int colCount = rsmd.getColumnCount();
        TR tr = new TR();

        //rst.beforeFirst();
        while (rst.next()) {
            tr = new TR();
            tr.setPrettyPrint(isPretty);
            for (int i = 1; i <= colCount; i++) {
                TH th = new TH();
                th.setPrettyPrint(isPretty);
                th.addElement(rst.getString(i));
                tr.addElement(th);
            }
            addElement(tr);
        }
    }
}



thanks,

Thufir


---------------------------------------------------------------------
To unsubscribe, e-mail: ecs-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: ecs-user-help@jakarta.apache.org


Mime
View raw message