How to print column names returned by sql:query?

Question

<sql:query var="TableRow" dataSource="jdbc/db">
   SELECT * from table1;
</sql:query>

How to display the names of columns in table1 table? I know how to access the individual rows using Tablerow.rowsByIndex, but don't know how to display the column names themselves.

Possible duplicate of [How to access duplicate column names with JSTL sql:query?](https://stackoverflow.com/questions/14431907/how-to-access-duplicate-column-names-with-jstl-sqlquery) — yash, Oct 02 '18 at 15:42

Yang Daniel · Answer 1 · 2018-10-03T02:09:03.187

1

<sql:query sql="SELECT * from table1" var="TableRow" dataSource="jdbc/db">
 <c:forEach var="colName" items=${TableRow.columnsNames}>
    ${colName}
 </c:forEach>
</sql:query>

Move sql query into attribute, and have a loop for columnsName on query result

edited Oct 03 '18 at 02:09

answered Oct 02 '18 at 06:04

Yang Daniel

125
5

Thanks, I will try this later in the evening. – xxx374562 Oct 02 '18 at 07:39
@YangDaniel, you have already closed `` with `/>`. so you don't need to add last line. – yash Oct 02 '18 at 15:42

How to print column names returned by sql:query?

1 Answers1