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

a2s1d2f1

SQL="select"+name+"from aa";
The name is used to store the passed column name, if there are id, name, city, country... these columns in the aa table, but the two stored in the name may be city, country.
How to use re.getString("") to display it.

悲雪狂沙

re.getString(1),
re.getString(2),

a2s1d2f1

But it doesn’t have to be a few. It could be three or four

evalhr

Take it all out and judge according to the conditions

悲雪狂沙

kind of hard! ! ! If it is an ID, then using re.getString will still make an error
It’s better to judge the string NAME before querying the database. If the value of NAME is city, country, then use String[] to separate, name[0]="city",name[1]="country", then take it out to the database Then you can judge based on this
if(name[0].equals("city"))
{
String pstrcity=re.getString(1);
}
if(name[0].equals("country"))
{
String pstrcountry=re.getString(1);
}

a2s1d2f1

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.

thiefgroup

If you know the select statement, you still don't know the column name? Reverse analysis of name.

In addition, your implementation is too bad. How can you directly link up the naked names like "city, country"?
You can pass a structure like String[] directly instead of name.

rrrrrroooo

Get the column name through the result set

hebe5467

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

qiqituo

To give you an idea, write the NAME in an array, and then use a loop to fetch it when fetching it. That’s how I did it.