ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Steven Pannell <steven.pann...@zooplus.com>
Subject building a hierarchy
Date Wed, 06 Apr 2005 16:16:52 GMT

Does anyone know how I could (if possible) build a hierarchy of objects
using a single SQL statement.  Is this possible?

For example I have a SQL table of BOXES.  A BOX can contain other BOXES and
so on, like:

class BOX {
	public void id();
	public void parentBoxId();
	public BOX getChild();

my sql would be something like:

select * from boxes b1, boxes b2
where b1.id = b2.parentBoxId;

result is a big list of boxes but I want the parent / child hierarchy.

anyway to do this?  know what I mean?


View raw message