Re: Getting values from different tables

[lonp]

Look at the ResultSetMetaData class.  That should help you.
http://java.sun.com/j2se/1.4/docs/api/java/sql/class-use/ResultSetMetaData.h
tml
Lon

- Original Message -
From: Uma Maheswar [EMAIL PROTECTED]
To: Tomcat Users List [EMAIL PROTECTED]
Sent: Tuesday, February 12, 2002 1:38 AM
Subject: Getting values from different tables


Hi,
I wanted to know if there is any possiblility of getting all the values from
a Database in a single command.

Example:
I am using it in this way in a browser select * from and here is a drop
down box which contains table names as register,pc,signup . I select the
table I need from the drop down box and hit the submit button. and I should
get all the values from the database in a table. The problem is I do not
have all the fields in all the databases same. Then how are we going to get
the result.


String tables = req.getParameter(tables);
rs = st.executeQuery(select * from '+tables+' );
while(rs.next()
{
??
}


Help me.

Uma




--
To unsubscribe:   mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]

Getting values from different tables

[Uma Maheswar]

Hi,
I wanted to know if there is any possiblility of getting all the values from a 
Database in a single command. 

Example:
I am using it in this way in a browser select * from and here is a drop down box 
which contains table names as register,pc,signup . I select the table I need from 
the drop down box and hit the submit button. and I should get all the values from the 
database in a table. The problem is I do not have all the fields in all the databases 
same. Then how are we going to get the result.


String tables = req.getParameter(tables);
rs = st.executeQuery(select * from '+tables+' );
while(rs.next()
{ 
??
}


Help me.

Uma