aspire是一个rad工具，提供使用者以标准的xml/xsl、j2ee及关联式资料库技术快速地创建网站。aspire可接受的资料来源包含存储程序、sql语句、ejbs及java控件，并使用apache 的xerces/xalan作为转换的处理器。
aspire可使用于多种servlet引擎，例如apache/jserv、apache/tomcat及websphere等。
目前发展中的功能包含crystal reports及oracle reports等报表工具的整合界面。 aspire优点如下：
1.降低开发时间，开发者只需专注在商业逻辑及gui的样子
2. 降低开发技术门槛
3. 更佳的gui界面
4.支援标准的技术
5. 具有延展性及弹性
通过aspire和tomcat使用层次数据集
（原创：satya komatineni）
翻译人：tonewawa 11/20/2003 17:14:09
一.何为层次数据集？为什么要用层次数据集？
层次数据集并不是一个新的名词。他们已经以客户信息控制系统的事务数据、目录文件、java对象、更接近于xml文件的格式存在了。早在2001年的xml杂志上，我就认为程序员可以从层次数据集的提取上得到好处，尽管他们的数据源具有很强的数据相关性（像：mysql, oracle, sql server, db2等等之类的数据库）。.net思想和数据集概念也很相似。尽管我所认为的层次数据集和传统的微软的数据集有很大的不同，层次数据集具有的丰富的细节描述极大增强了关系型数据的提取。
本篇重在讲述层次数据集的结构和与其相关的java api。并不像xml杂志两年前所说的，你现在就可以用一系列的可执行代码来获取层次数据集的优势。当然我们可以在java里编写一定代码来实现对各种各样的数据源的访问以及创建一个完整的层次数据集，本篇中我们就将给出一可执行的代码，你可以利用这些代码并结合一个简单的预定义的关系型适配器就可以创建一些层次数据集啦。这里的关系型适配器包括：文本阅读器，sql 脚本, 存储过程等等。
现在你可能会问了：“这个层次数据集究竟有什么好啊？”。当然层次数据集是不能和你的那些受到奖赏的同事得到的昂贵的carbon带来的实惠相抗衡，在编程中层次数据集是非常有用的。对一个启动来说，一个层次数据集就可以满足整个html页面上的所有的有价值的数据的需要。在mvc(model-view-controler)模型里，控制器的servlet可以提交一个层次数据集给jsp页面后，jsp页面就可以显示它而不需要任何的帮助。也可以说，通过控制器的servlet可直接将其转换为xml格式返回给请求者。从实用的角度来说，数据集可以转换成excel格式的文件。从新潮的角度来说，层次数据集可以转换为支持xml数据的报表或者图表。
本篇主要焦点是服务于java程序员的java编程的api怎么运用层次数据集，实际上非java程序员也可以通过有效地结合层次数据集和一个j2ee的服务（比如tomcat）从关系型数据库或者别的数据库中得到xml、html、或者excel格式文档。不要过于急躁，我们先来研究研究层次数据集的结构和这些数据集是如何被提取的（现在可以稍微放松一下啦^_^）。
二. 层次数据集的结构
层次数据集可以表示为一个javaapi ,xml或者别的格式,而用xml来表示将会更加形象:
<aspiredataset>
<!-- a set of key value pairs at the root level -->
<key1>val1</key1>
<key2>val2</key2>
<!-- a set of named loops -->
<loop name="loop">
</loop>
<loop name="loop2">
</loop>
</aspiredataset>
<loop name="loopname">
<row>
<!-- a set of key value pairs -->
<key1>val1</key1>
<key2>val2</key2>
<!-- a set of named loops -->
<loop name="loopname1">
</loop>
<!-- a set of named loops -->
<loop name="loopname2">
</loop>
</row>
<row>
</row>
</loop>
package com.ai.htmlgen;
import com.ai.data.*;
/**
* represents a hierarchical data set.
* an hds is a collection of rows.
* you can step through the rows using iloopforwarditerator
* you can find out about the columns via imetadata.
* an hds is also a collection loops originated using the current row.
*/
public interface ihds extends iloopforwarditerator
{
/**
* returns the parent if available
* returns null if there is no parent
*/
public ihds getparent() throws dataexception;
/**
* for the current row return a set of
* child loop names. iloopforwarditeraor determines
* what the current row is. *
* @see iloopforwarditerator
*/
public iiterator getchildnames() throws dataexception;
/**
* given a child name return the child java object
* represented by ihds again
*/
public ihds getchild(string childname) throws dataexception;
/**
* returns a column that is similar to sum, avg etc of a
* set of rows that are children to this row.
*/
public string getaggregatevalue(string keyname) throws dataexception;
/**
* returns the column names of this loop or table.
* @see imetadata
*/
public imetadata getmetadata() throws dataexception;
/**
* releases any resources that may be held by this loop of data
* or table.
*/
public void close() throws dataexception;
}
package com.ai.htmlgen;
import com.ai.data.*;
public interface iloopforwarditerator
{
/**
* getvalue from the current row matching the key
*/
public string getvalue(final string key);
public void movetofirst() throws dataexception;
public void movetonext() throws dataexception;
public boolean isattheend() throws dataexception;
}
package com.ai.data;
public interface imetadata
{
public iiterator getiterator();
public int getcolumncount();
public int getindex(final string attributename)
throws fieldnamenotfoundexception;
}
###################################
# ihdstest data definition: section1
###################################
request.ihdstest.classname=com.ai.htmlgen.dbhashtableformhandler1
request.ihdstest.loopnames=works
#section2
request.ihdstest.works.class_request.classname=com.ai.htmlgen.generictablehandler6
request.ihdstest.works.loopnames=childloop1
request.ihdstest.works.query_request.classname=com.ai.data.rowfilereader
request.ihdstest.works.query_request.filename=aspire:\\samples
\\pop-table-tags\\properties\\pop-table.data
#section3
request.childloop1.class_request.classname=com.ai.htmlgen.generictablehandler6
request.childloop1.query_request.classname=com.ai.data.rowfilereader
request.childloop1.query_request.filename=aspire:\\samples\\pop-table-tags
\\properties\\pop-table.data
application.includefiles=aspire:\\samples\\hello-world
\\properties\\hello-world.properties,\
aspire:\\samples\\ihds-test\\ihds-test.properties,\
aspire:\\samples\\xml-reader\\xml-reader.properties
hashtable args = new hashtable();
args.put("key1".tolowercase(), "value1");
ifactory factory = appobjects.getfactory();
ihds hds = (ihds)factory.getobject("ihdstest",args);
// use ihds
import com.ai.htmlgen.*;
import com.ai.common.transformexception;
import java.io.*;
import com.ai.data.*;
// above code removed for clarity
public static void statictransform(ihds data, printwriter out)
throws transformexception
{
try
{
writealoop("maindata",data,out,"");
}
catch(dataexception x)
{
throw new transformexception(
"error: debugtexttransform: data exception",x);
}
}
/**********************************************************
* a recursive function to write out a loop worth of ihds
**********************************************************/
private static void writealoop(
string loopname, ihds data, printwriter out, string is)
throws dataexception
{
println(out,is, ">> writing data for loop:" + loopname);
// write metadata
imetadata m = data.getmetadata();
iiterator columns = m.getiterator();
stringbuffer colbuffer = new stringbuffer();
for(columns.movetofirst();!columns.isattheend();columns.movetonext())
{
string columnname = (string)columns.getcurrentelement();
colbuffer.append(columnname).append("");
}
println(out,is,colbuffer.tostring());
//write individual rows
for(data.movetofirst();!data.isattheend();data.movetonext())
{
stringbuffer rowbuffer = new stringbuffer(); for(columns.movetofirst();!columns.isattheend();columns.movetonext())
{
string columnname = (string)columns.getcurrentelement();
rowbuffer.append(data.getvalue(columnname));
rowbuffer.append("");
}
println(out,is,rowbuffer.tostring());
// recursive call to print children
iiterator children = data.getchildnames(); for(children.movetofirst();!children.isattheend();children.movetonext())
{
// for each child
string childname = (string)children.getcurrentelement();
ihds child = data.getchild(childname);
writealoop(childname,child,out,is + "\t");
}
}
println(out,is,">> writing data for loop:" + loopname + " is complete");
}
private static void println(printwriter out, string indentationstring,
string line)
{
out.print(indentationstring);
out.print(line);
out.print("\n");
}
// code removed for clarity
###################################
# ihdstesturl: linking to a url
###################################
ihdstesturl=aspire:\\samples\\ihds-test\\ihds-default-html-template.html
ihdstesturl.formhandlername=ihdstest
request.ihdstest.form_handler.class_request.classname=
com.ai.htmlgen.dbhashtableformhandler1
# generic transform support
# xml output
generictransform.classic-xml.classname=
com.ai.xml.formhandlertoxmltransform
generictransform.object-xml.classname=
com.ai.generictransforms.objectxmlgenerictransform
# excel output
generictransform.excel.classname=
com.ai.generictransforms.excelgenerictransform
# text
generictransform.text.classname=
com.ai.generictransforms.debugtexttransform
package com.ai.generictransforms;
import com.ai.htmlgen.*;
import com.ai.common.transformexception;
import java.io.*;
import com.ai.data.*;
import javax.servlet.http.*;
public class excelgenerictransform
extends ahttpgenerictransform
implements iformhandlertransform
{
private static string s_separator = "\t";
protected string getderivedheaders(httpservletrequest request)
{
return "content-type=application/vnd.ms-excelcontent-disposition=
filename=aspire-hierarchical-dataset.xls";
}
public void transform(ihds data, printwriter out)
throws transformexception
{
statictransform(data,out);
}
public void transform(iformhandler data, printwriter out)
throws transformexception
{
statictransform((ihds)data,out);
}
public static void statictransform(ihds data, printwriter out)
throws transformexception
{
try
{
writealoop("maindata",data,out,"");
}
catch(dataexception x)
{
throw new transformexception("error: excelgenerictransform:
data exception",x);
}
}
private static void writealoop(string loopname,
ihds data,
printwriter out,
string is)
throws dataexception
{
println(out,is, ">> writing data for loop:" + loopname);
// write metadata
imetadata m = data.getmetadata();
iiterator columns = m.getiterator();
stringbuffer colbuffer = new stringbuffer();
for(columns.movetofirst();!columns.isattheend();columns.movetonext())
{
string columnname = (string)columns.getcurrentelement();
colbuffer.append(columnname).append(s_separator);
}
println(out,is,colbuffer.tostring());
//write individual rows
for(data.movetofirst();!data.isattheend();data.movetonext())
{
stringbuffer rowbuffer = new stringbuffer();
for(columns.movetofirst();!columns.isattheend();columns.movetonext())
{
string columnname = (string)columns.getcurrentelement();
rowbuffer.append(data.getvalue(columnname));
rowbuffer.append(s_separator);
}
println(out,is,rowbuffer.tostring());
// recursive call to print children
iiterator children = data.getchildnames();
for(children.movetofirst();!children.isattheend();children.movetonext())
{
//for each child
string childname = (string)children.getcurrentelement();
ihds child = data.getchild(childname);
writealoop(childname,child,out,is + "\t");
}
}
println(out,is,">> writing data for loop:" + loopname + " is complete");
}
private static void println(printwriter out, string
indentationstring, string line)
{
out.print(indentationstring);
out.print(line);
out.print("\n");
}
}
Java Asp PHP .Net XML C/C++ CGI VB Jsp J2ee J2se J2me EJB Servlet Tomcat Resin Struts Weblogic Eclipse ANT GUI JMS Web servise IDEA Webphere Hibernate Spring Jboss Applet Swing Socket Javamail Perl Ajax P2P 安全 模式 框架 测试 开源 游戏
Windows XP Windows 2000 Windows 2003 Windows Me Windows 9.x Linux UNIX 注册表 操作系统 服务器 应用服务器
