给你看看我的一个方法(1).txt

文档介绍：作者:diego lynn
email: @
日期:2001-6-29 15:32:06
/**
<p>获取表列表的 sql 语句
*/
private String getTableName( ms ms, String inTableResult ) throws HttpPresentationException
{
String _sql = I_EMPTY_STRING;
String _tempString = I_EMPTY_STRING;
String[] _relationship = ( "relationship" );
_sql = "select TABLENAME from (" + inTableResult + ") where SQLLEVEL = '0' ";
for ( int i=0; i<-1; i++ )
{
if ( _relationship[i].equals("and") )
_tempString = "intersect";
else if ( _relationship[i].equals("or") )
_tempString = "union";
_sql += _tempString + " select TABLENAME from (" + inTableResult + ") where SQLLEVEL = '" +
(i+1) + "' ";
}
return _sql;
}