I've developped a set of java wrappers around the tables of the goldenpath. I use link Apache Velocity to generate the java source code.
As a java programmer I wanted to create my own wrappers to use the data of the UCSC. I wrote a custom ANT task(the code is available here) using the [public mysql server] of the UCSC to get the structure of each table (e.g. desc cytoBand) and the description of each table (e.g. select autoSqlDef from tableDescriptions where tableName="cytoBand"). Each structure is parsed and injected into an apache-velocity template (the template is available here).
Here is an example of a source generated by the ant task: http://pastie.org/284507
See the complete article here: [http://plindenbaum.blogspot.com/2008/10/java-wrappers-for-tables-of.html]