<%@ page info="Result of simple hotel search engine" language="java"
import="IJCAI.*,javax.servlet.jsp.JspWriter,java.io.PrintWriter"
import="observer.observer.*,observer.ontServer.wrappers.*" %>
Wrapper designed for HOTELS Database
OBSERVER 
Ontology Based System Enhanced with Relationships for Vocabulary hEterogeneity
Resolution
Wrapper designed for Hotel Database
Last update: May 28, 2003
These are the tables and columns of the database that you are going to
query.
|
Table names
|
Metadata of the solumns
<%
Table tables=bean.queryDB("show tables from HOTELS_DB;");
for (int i=0; i< tables.getNumTuplas(); i++){
Object name = tables.getTuple(i).elementAt(0);
%>
|
|
<%=name.toString()%>
|
<%
Table columns=bean.queryDB("show columns from " +
"HOTELS_DB."+name.toString().trim()+";");
for (int j=0; j< columns.getNumCols(); j++){
%>
|
<%
Header header = columns.getHeader(j);
%>
<%=header.colName%>
<%
}
for (int j=0; j< columns.getNumTuplas(); j++){
%>
|
<%
for (int k=0; k< columns.getNumCols(); k++){
Object colinfo = columns.getTuple(j).elementAt(k);
%>
|
<%=(colinfo==null || colinfo.toString().length()==0) ? " " : colinfo.toString()%>
<%
}
}
%>
|
<%
}
%>
|
joalroyo@unizar.es
May 28, 2003
OBSERVER