How to display it on the web page when the column name is unknown?

悲雪狂沙

select name,city,country from aa;
If this is the case, how to display it, the previous question is that I don’t know if it is name, city, country, these three items.
====================
Name, city, and country are in the name string
String[] name1=name.split(",");
such
name1[0] is name
name1[1] is city
name1[2] is country

thiefgroup

Upstairs, name is equivalent to a string of data (similar to the toString() of an object), and reverse analysis is often a tedious and bad anti-pattern (unless there is a precise textual protocol definition). For example, if you directly name.split(",") does not guarantee success-consider spaces and quotation marks. So structured attribute parameters are the best way to force customers to specify a sequence of column names, such as the simplest array.

elsaiii

?

getMetaData
ResultSetMetaData getMetaData()
throws SQLException Retrieves the number, type, and attributes of the columns of this ResultSet object.

return:
A description of the columns of this ResultSet object
Throws:
SQLException-if a database access error occurs
－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－


This is a positive solution

mrhan911

Can I rename it?
select "+name+" as mydate1 from aa";
rs.getstring("mydate1")

khristian

ResultSet rs = stmt.executeQuery(sql);
ResultSetMetaData rsm = rs.getMetaData();
String[] cols = new String[rsm.getColumnCount()];
for (int i = 0; i <cols.length; i++)
cols[i] = rsm.getColumnName(i + 1);

juneshen

A little wired, could you change your demandes?