alvinalexander.com | career | drupal | java | mac | mysql | perl | scala | uml | unix  

What this is

This file is included in the DevDaily.com "Java Source Code Warehouse" project. The intent of this project is to help you "Learn Java by Example" TM.

Other links

The source code

DROP TABLE testtree;

CREATE TABLE testtree (
  city varchar(20),
  cityurl varchar(80),
  area varchar(20),
  areaurl varchar(80),
  street varchar(20),
  streeturl varchar(80)
);

INSERT INTO testtree VALUES ('Edinburgh',NULL,'Morningside',NULL,'Comiston Rd','DestinationPane.jsp?street=COMISTON+ROAD');
INSERT INTO testtree VALUES ('Edinburgh',NULL,'Morningside',NULL,'Morningside Park','DestinationPane.jsp?street=MORNINGSIDE+PARK');
INSERT INTO testtree VALUES ('Edinburgh',NULL,'Leith','DestinationPane.jsp?area=LEITH','Pitt St','DestinationPane.jsp?street=PITT+STREET');
INSERT INTO testtree VALUES ('Edinburgh',NULL,'Leith','DestinationPane.jsp?area=LEITH','Brunswick Place','DestinationPane.jsp?street=BRUNSWICK+PLACE');
INSERT INTO testtree VALUES ('Manchester',NULL,'Rusholme',NULL,'Claremont Rd','DestinationPane.jsp?street=CLAREMONT+RD');
INSERT INTO testtree VALUES ('Manchester',NULL,'Rusholme',NULL,'Great Western St','DestinationPane.jsp?street=GREAT WESTERN STREET');
INSERT INTO testtree VALUES ('Manchester',NULL,'Victoria Park',NULL,'Oxford Place','DestinationPane.jsp?street=OXFORD+PLACE');
INSERT INTO testtree VALUES ('Manchester',NULL,'Didsbury','DestinationPane.jsp?area=DIDSBURY',NULL,NULL);
INSERT INTO testtree VALUES ('London','DestinationPane.jsp?city=LONDON',NULL,NULL,NULL,NULL);

... this post is sponsored by my books ...

#1 New Release!

FP Best Seller

 

new blog posts

 

Copyright 1998-2021 Alvin Alexander, alvinalexander.com
All Rights Reserved.

A percentage of advertising revenue from
pages under the /java/jwarehouse URI on this website is
paid back to open source projects.