How to get the file name and its data type?

[Zhixiong Pan]

Hi ranchers,

I am planning to write a method which a parameter of tableName(String type) will be passed in and will return a vector. That vector's element is a record which is a String array. To realize that function, I need: 1.to get the table's fileds count which is the length to initial array; 2. the first, second ... the n th filed name; 3. the type of the first, seconde...the n the filed.
Could you help me please?

[Vallidevi Appana]

You can use the following code to get number of fields, each field name and each field type in the table.

String query = "select * from"+tblName
ResultSet rs = stmt.execute(query);
ResultSetMetaData rsMetaData = rs.getMetaData();
int noOfColumns = rsMetaData.getColumnCount(); //No of fields in table
for (int i =1; i<=noOfColumns ; i++)
{
  String columnName = rsMetaData.getColumnName(i); //Field Name
  String columnType = rsMetaData.getColumnTypeName(i); //Field Type
}