blocks|key|1378712|text|您可以从ResultSet元数据中获取此信息。请参阅ResultSetMetaData|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1378713|例如：|1378714|+ResultSet+rs+=+stmt.executeQuery("SELECT+a,+b,+c+FROM+TABLE2");
+ResultSetMetaData+rsmd+=+rs.getMetaData();
+String+name+=+rsmd.getColumnName(1);|code-block|syntax|javascript|1378715|您可以从那里获得列名。如果你这样做了|1378716|select+x+as+y+from+table|1378717|然后，rsmd.getColumnLabel()也会为您获取检索到的标签名称。|1378718|entityMap|0|LINK|mutability|MUTABLE|url|https://docs.oracle.com/javase/8/docs/api/java/sql/ResultSetMetaData.html^0|4|9|Q|H|0|0|0|0|0|0|3|L|0^^$0|@$1|2|3|4|5|6|7|10|8|@$9|11|A|12|B|C]]|D|@$9|13|A|14|1|15]]|E|$]]|$1|F|3|G|5|6|7|16|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|17|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|18|8|@]|D|@]|E|$]]|$1|O|3|P|5|J|7|19|8|@]|D|@]|E|$K|L]]|$1|Q|3|R|5|6|7|1A|8|@$9|1B|A|1C|B|C]]|D|@]|E|$]]|$1|S|3|-4|5|6|7|1D|8|@]|D|@]|E|$]]]|T|$U|$5|V|W|X|E|$Y|Z]]]]

You can get this info from the <code>ResultSet</code> metadata. See <a href="https://docs.oracle.com/javase/8/docs/api/java/sql/ResultSetMetaData.html" rel="noreferrer">ResultSetMetaData</a>

e.g.

<pre><code> ResultSet rs = stmt.executeQuery("SELECT a, b, c FROM TABLE2");
 ResultSetMetaData rsmd = rs.getMetaData();
 String name = rsmd.getColumnName(1);
</code></pre>

and you can get the column name from there. If you do

<pre><code>select x as y from table
</code></pre>

then <code>rsmd.getColumnLabel()</code> will get you the retrieved label name too.

blocks|key|1378864|text|除了上面的答案之外，如果您正在处理一个动态查询，并且您想要列名，但是不知道有多少列，那么可以使用ResultSetMetaData对象首先获取列数，然后循环它们。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1378865|修改Brian的代码：|1378866|ResultSet+rs+=+stmt.executeQuery("SELECT+a,+b,+c+FROM+TABLE2");
ResultSetMetaData+rsmd+=+rs.getMetaData();
int+columnCount+=+rsmd.getColumnCount();

//+The+column+count+starts+from+1
for+(int+i+=+1;+i+<=+columnCount;+i%2B%2B+)+{
++String+name+=+rsmd.getColumnName(i);
++//+Do+stuff+with+name
}|code-block|syntax|javascript|1378867|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

In addition to the above answers, if you're working with a dynamic query and you want the column names but do not know how many columns there are, you can use the ResultSetMetaData object to get the number of columns first and then cycle through them.

Amending Brian's code:

<pre><code>ResultSet rs = stmt.executeQuery("SELECT a, b, c FROM TABLE2");
ResultSetMetaData rsmd = rs.getMetaData();
int columnCount = rsmd.getColumnCount();

// The column count starts from 1
for (int i = 1; i &lt;= columnCount; i++ ) {
 String name = rsmd.getColumnName(i);
 // Do stuff with name
}
</code></pre>

blocks|key|1593992|text|为此，可以使用ResultSetMetaData+(http://java.sun.com/javase/6/docs/api/java/sql/ResultSetMetaData.html)对象，如下所示：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1593993|ResultSet+rs+=+stmt.executeQuery("SELECT+*+FROM+table");
ResultSetMetaData+rsmd+=+rs.getMetaData();
String+firstColumnName+=+rsmd.getColumnName(1);|code-block|syntax|javascript|1593994|entityMap|0|LINK|mutability|MUTABLE|url|http://java.sun.com/javase/6/docs/api/java/sql/ResultSetMetaData.html^0|Q|1X|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@$A|R|B|S|1|T]]|C|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|C|$G|H]]|$1|I|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|J|$K|$5|L|M|N|C|$O|P]]]]

You can use the the ResultSetMetaData (<a href="http://java.sun.com/javase/6/docs/api/java/sql/ResultSetMetaData.html" rel="noreferrer">http://java.sun.com/javase/6/docs/api/java/sql/ResultSetMetaData.html</a>) object for that, like this:

<pre><code>ResultSet rs = stmt.executeQuery("SELECT * FROM table");
ResultSetMetaData rsmd = rs.getMetaData();
String firstColumnName = rsmd.getColumnName(1);
</code></pre>

blocks|key|1594148|text|这个问题已经过时了，之前的正确答案也是如此。但当我发现这个主题时，我正在寻找的是类似于这个解决方案的东西。希望这能帮助到某个人。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1594149|//+Loading+required+libraries++++
import+java.util.*;
import+java.sql.*;

public+class+MySQLExample+{
++public+void+run(String+sql)+{
++++//+JDBC+driver+name+and+database+URL
++++String+JDBC_DRIVER+=+"com.mysql.jdbc.Driver";
++++String+DB_URL+=+"jdbc:mysql://localhost/demo";

++++//+Database+credentials
++++String+USER+=+"someuser";+//+Fake+of+course.
++++String+PASS+=+"somepass";+//+This+too!

++++Statement+stmt+=+null;
++++ResultSet+rs+=+null;
++++Connection+conn+=+null;
++++Vector<String>+columnNames+=+new+Vector<String>();

++++try+{
++++++//+Register+JDBC+driver
++++++Class.forName(JDBC_DRIVER);

++++++//+Open+a+connection
++++++conn+=+DriverManager.getConnection(DB_URL,+USER,+PASS);

++++++//+Execute+SQL+query
++++++stmt+=+conn.createStatement();
++++++rs+=+stmt.executeQuery(sql);
++++++if+(rs+!=+null)+{
++++++++ResultSetMetaData+columns+=+rs.getMetaData();
++++++++int+i+=+0;
++++++++while+(i+<+columns.getColumnCount())+{
++++++++++i%2B%2B;
++++++++++System.out.print(columns.getColumnName(i)+%2B+"\t");
++++++++++columnNames.add(columns.getColumnName(i));
++++++++}
++++++++System.out.print("\n");

++++++++while+(rs.next())+{
++++++++++for+(i+=+0;+i+<+columnNames.size();+i%2B%2B)+{
++++++++++++System.out.print(rs.getString(columnNames.get(i))
++++++++++++++++%2B+"\t");

++++++++++}
++++++++++System.out.print("\n");
++++++++}

++++++}
++++}+catch+(Exception+e)+{
++++++System.out.println("Exception:+"+%2B+e.toString());
++++}

++++finally+{
++++++try+{
++++++++if+(rs+!=+null)+{
++++++++++rs.close();
++++++++}
++++++++if+(stmt+!=+null)+{
++++++++++stmt.close();
++++++++}
++++++++if+(conn+!=+null)+{
++++++++++conn.close();
++++++++}
++++++}+catch+(Exception+mysqlEx)+{
++++++++System.out.println(mysqlEx.toString());
++++++}

++++}
++}
}|code-block|syntax|javascript|1594150|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

This question is old and so are the correct previous answers. But what I was looking for when I found this topic was something like this solution. Hopefully it helps someone.

<pre><code>// Loading required libraries 
import java.util.*;
import java.sql.*;

public class MySQLExample {
 public void run(String sql) {
 // JDBC driver name and database URL
 String JDBC_DRIVER = "com.mysql.jdbc.Driver";
 String DB_URL = "jdbc:mysql://localhost/demo";

 // Database credentials
 String USER = "someuser"; // Fake of course.
 String PASS = "somepass"; // This too!

 Statement stmt = null;
 ResultSet rs = null;
 Connection conn = null;
 Vector&lt;String&gt; columnNames = new Vector&lt;String&gt;();

 try {
 // Register JDBC driver
 Class.forName(JDBC_DRIVER);

 // Open a connection
 conn = DriverManager.getConnection(DB_URL, USER, PASS);

 // Execute SQL query
 stmt = conn.createStatement();
 rs = stmt.executeQuery(sql);
 if (rs != null) {
 ResultSetMetaData columns = rs.getMetaData();
 int i = 0;
 while (i &lt; columns.getColumnCount()) {
 i++;
 System.out.print(columns.getColumnName(i) + "\t");
 columnNames.add(columns.getColumnName(i));
 }
 System.out.print("\n");

 while (rs.next()) {
 for (i = 0; i &lt; columnNames.size(); i++) {
 System.out.print(rs.getString(columnNames.get(i))
 + "\t");

 }
 System.out.print("\n");
 }

 }
 } catch (Exception e) {
 System.out.println("Exception: " + e.toString());
 }

 finally {
 try {
 if (rs != null) {
 rs.close();
 }
 if (stmt != null) {
 stmt.close();
 }
 if (conn != null) {
 conn.close();
 }
 } catch (Exception mysqlEx) {
 System.out.println(mysqlEx.toString());
 }

 }
 }
}
</code></pre>

blocks|key|1594371|text|import+java.sql.*;

public+class+JdbcGetColumnNames+{

++++public+static+void+main(String+args[])+{
++++++++Connection+con+=+null;
++++++++Statement+st+=+null;
++++++++ResultSet+rs+=+null;

++++++++try+{
++++++++++++Class.forName("com.mysql.jdbc.Driver");
++++++++++++con+=+DriverManager.getConnection(
++++++++++++++++++++"jdbc:mysql://localhost:3306/komal",+"root",+"root");

++++++++++++st+=+con.createStatement();

++++++++++++String+sql+=+"select+*+from+person";
++++++++++++rs+=+st.executeQuery(sql);
++++++++++++ResultSetMetaData+metaData+=+rs.getMetaData();

++++++++++++int+rowCount+=+metaData.getColumnCount();

++++++++++++System.out.println("Table+Name+:+"+%2B+metaData.getTableName(2));
++++++++++++System.out.println("Field++\tDataType");

++++++++++++for+(int+i+=+0;+i+<+rowCount;+i%2B%2B)+{
++++++++++++++++System.out.print(metaData.getColumnName(i+%2B+1)+%2B+"++\t");
++++++++++++++++System.out.println(metaData.getColumnTypeName(i+%2B+1));
++++++++++++}
++++++++}+catch+(Exception+e)+{
++++++++++++System.out.println(e);
++++++++}
++++}
}|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1594372|表名:人员字段DataType+id+VARCHAR+cname+VARCHAR道布日期|unstyled|1594373|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|J|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|K|8|@]|9|@]|A|$]]]|H|$]]

<pre><code>import java.sql.*;

public class JdbcGetColumnNames {

 public static void main(String args[]) {
 Connection con = null;
 Statement st = null;
 ResultSet rs = null;

 try {
 Class.forName("com.mysql.jdbc.Driver");
 con = DriverManager.getConnection(
 "jdbc:mysql://localhost:3306/komal", "root", "root");

 st = con.createStatement();

 String sql = "select * from person";
 rs = st.executeQuery(sql);
 ResultSetMetaData metaData = rs.getMetaData();

 int rowCount = metaData.getColumnCount();

 System.out.println("Table Name : " + metaData.getTableName(2));
 System.out.println("Field \tDataType");

 for (int i = 0; i &lt; rowCount; i++) {
 System.out.print(metaData.getColumnName(i + 1) + " \t");
 System.out.println(metaData.getColumnTypeName(i + 1));
 }
 } catch (Exception e) {
 System.out.println(e);
 }
 }
}
</code></pre>

Table Name : person
Field DataType
id VARCHAR
cname VARCHAR
dob DATE

blocks|key|1594444|text|while+(rs.next())+{
+++for+(int+j+=+1;+j+<+columncount;+j%2B%2B)+{
+++++++System.out.println(+rsd.getColumnName(j)+%2B+"::"+%2B+rs.getString(j));++++++
+++}
}|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1594445|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>while (rs.next()) {
 for (int j = 1; j &lt; columncount; j++) {
 System.out.println( rsd.getColumnName(j) + "::" + rs.getString(j)); 
 }
}
</code></pre>

blocks|key|1594183|text|@Cyntech是对的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1594184|如果您的表是空的，并且您仍然需要获取表列名称，您可以获取类型为Vector的列，请参见以下内容：|1594185|ResultSet+rs+=+stmt.executeQuery("SELECT+a,+b,+c+FROM+TABLE2");
ResultSetMetaData+rsmd+=+rs.getMetaData();
int+columnCount+=+rsmd.getColumnCount();

Vector<Vector<String>>tableVector+=+new+Vector<Vector<String>>();+
boolean+isTableEmpty+=+true;
int+col+=+0;

+while(rs.next())
++++{
++++++isTableEmpty+=+false;++//set+to+false+since+rs.next+has+data:+this+means+the+table+is+not+empty
+++++++if(col+!=+columnCount)
++++++++++{
++++++++++++for(int+x+=+1;x+<=+columnCount;x%2B%2B){
+++++++++++++++++Vector<String>+tFields+=+new+Vector<String>();+
+++++++++++++++++tFields.add(rsmd.getColumnName(x).toString());
+++++++++++++++++tableVector.add(tFields);
+++++++++++++}
++++++++++++col+=+columnCount;
++++++++++}
+++++}+


++++++//if+table+is+empty+then+get+column+names+only
++if(isTableEmpty){++
++++++for(int+x=1;x<=colCount;x%2B%2B){
+++++++++++Vector<String>+tFields+=+new+Vector<String>();+
+++++++++++tFields.add(rsmd.getColumnName(x).toString());
+++++++++++tableVector.add(tFields);
++++++++}
++++++}

+rs.close();
+stmt.close();

+return+tableVector;+|code-block|syntax|javascript|1594186|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

@Cyntech is right.

Incase your table is empty and you still need to get table column names you can get your column as type Vector,see the following:

<pre><code>ResultSet rs = stmt.executeQuery("SELECT a, b, c FROM TABLE2");
ResultSetMetaData rsmd = rs.getMetaData();
int columnCount = rsmd.getColumnCount();

Vector&lt;Vector&lt;String&gt;&gt;tableVector = new Vector&lt;Vector&lt;String&gt;&gt;(); 
boolean isTableEmpty = true;
int col = 0;

 while(rs.next())
 {
 isTableEmpty = false; //set to false since rs.next has data: this means the table is not empty
 if(col != columnCount)
 {
 for(int x = 1;x &lt;= columnCount;x++){
 Vector&lt;String&gt; tFields = new Vector&lt;String&gt;(); 
 tFields.add(rsmd.getColumnName(x).toString());
 tableVector.add(tFields);
 }
 col = columnCount;
 }
 } 


 //if table is empty then get column names only
 if(isTableEmpty){ 
 for(int x=1;x&lt;=colCount;x++){
 Vector&lt;String&gt; tFields = new Vector&lt;String&gt;(); 
 tFields.add(rsmd.getColumnName(x).toString());
 tableVector.add(tFields);
 }
 }

 rs.close();
 stmt.close();

 return tableVector; 
</code></pre>

blocks|key|1379032|text|ResultSet+rsTst+=+hiSession.connection().prepareStatement(queryStr).executeQuery();+
ResultSetMetaData+meta+=+rsTst.getMetaData();
int+columnCount+=+meta.getColumnCount();
//+The+column+count+starts+from+1

String+nameValuePair+=+"";
while+(rsTst.next())+{
++++for+(int+i+=+1;+i+<+columnCount+%2B+1;+i%2B%2B+)+{
++++++++String+name+=+meta.getColumnName(i);
++++++++//+Do+stuff+with+name

++++++++String+value+=+rsTst.getString(i);+//.getObject(1);
++++++++nameValuePair+=+nameValuePair+%2B+name+%2B+"="+%2Bvalue+%2B+",";
++++++++//nameValuePair+=+nameValuePair+%2B+",+";
++++}
++++nameValuePair+=+nameValuePair%2B"%7C%7C"+%2B+"\t";
}|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1379033|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>ResultSet rsTst = hiSession.connection().prepareStatement(queryStr).executeQuery(); 
ResultSetMetaData meta = rsTst.getMetaData();
int columnCount = meta.getColumnCount();
// The column count starts from 1

String nameValuePair = "";
while (rsTst.next()) {
 for (int i = 1; i &lt; columnCount + 1; i++ ) {
 String name = meta.getColumnName(i);
 // Do stuff with name

 String value = rsTst.getString(i); //.getObject(1);
 nameValuePair = nameValuePair + name + "=" +value + ",";
 //nameValuePair = nameValuePair + ", ";
 }
 nameValuePair = nameValuePair+"||" + "\t";
}
</code></pre>

blocks|key|1379387|text|如果您想使用spring+jdbctemplate，但又不想与连接人员打交道，您可以使用以下方法：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1379388|jdbcTemplate.query("select+*+from+books",+new+RowCallbackHandler()+{
++++++++public+void+processRow(ResultSet+resultSet)+throws+SQLException+{
++++++++++++ResultSetMetaData+rsmd+=+resultSet.getMetaData();
++++++++++++for+(int+i+=+1;+i+<=+rsmd.getColumnCount();+i%2B%2B+)+{
++++++++++++++++String+name+=+rsmd.getColumnName(i);
++++++++++++++++//+Do+stuff+with+name
++++++++++++}
++++++++}
++++});|code-block|syntax|javascript|1379389|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

If you want to use spring jdbctemplate and don't want to deal with connection staff, you can use following:

<pre><code>jdbcTemplate.query("select * from books", new RowCallbackHandler() {
 public void processRow(ResultSet resultSet) throws SQLException {
 ResultSetMetaData rsmd = resultSet.getMetaData();
 for (int i = 1; i &lt;= rsmd.getColumnCount(); i++ ) {
 String name = rsmd.getColumnName(i);
 // Do stuff with name
 }
 }
 });
</code></pre>

blocks|key|1594580|text|您可以从resultSet.getMetaData()获取列名和值；下面的代码适用于我：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1594581|Connection+conn+=+null;
PreparedStatement+preparedStatement+=+null;
++++try+{
++++++++Class.forName("com.mysql.cj.jdbc.Driver");
++++++++conn+=+MySQLJDBCUtil.getConnection();
++++++++preparedStatement+=+conn.prepareStatement(sql);
++++++++if+(params+!=+null)+{
++++++++++++for+(int+i+=+0;+i+<+params.size();+i%2B%2B)+{
++++++++++++++++preparedStatement.setObject(i+%2B+1,+params.get(i).getSqlValue());
++++++++++++}
++++++++++++ResultSet+resultSet+=+preparedStatement.executeQuery();
++++++++++++ResultSetMetaData+md+=+resultSet.getMetaData();
++++++++++++while+(resultSet.next())+{
++++++++++++++++int+counter+=+md.getColumnCount();
++++++++++++++++String+colName[]+=+new+String[counter];
++++++++++++++++Map<String,+Object>+field+=+new+HashMap<>();
++++++++++++++++for+(int+loop+=+1;+loop+<=+counter;+loop%2B%2B)+{
++++++++++++++++++++int+index+=+loop+-+1;
++++++++++++++++++++colName[index]+=+md.getColumnLabel(loop);
++++++++++++++++++++field.put(colName[index],+resultSet.getObject(colName[index]));
++++++++++++++++}
++++++++++++++++rows.add(field);
++++++++++++}
++++++++}
++++}+catch+(SQLException+e)+{
++++++++e.printStackTrace();
++++}+finally+{
++++++++if+(preparedStatement+!=+null)+{
++++++++++++try+{
++++++++++++++++preparedStatement.close();
++++++++++++}catch+(Exception+e1)+{
++++++++++++++++e1.printStackTrace();
++++++++++++}
++++++++}
++++++++if+(conn+!=+null)+{
++++++++++++try+{
++++++++++++++++conn.close();
++++++++++++}+catch+(SQLException+e)+{
++++++++++++++++e.printStackTrace();
++++++++++++}
++++++++}
++++}
++++return+rows;|code-block|syntax|javascript|1594582|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

U can get column name and value from resultSet.getMetaData();
This code work for me:

<pre><code>Connection conn = null;
PreparedStatement preparedStatement = null;
 try {
 Class.forName("com.mysql.cj.jdbc.Driver");
 conn = MySQLJDBCUtil.getConnection();
 preparedStatement = conn.prepareStatement(sql);
 if (params != null) {
 for (int i = 0; i &lt; params.size(); i++) {
 preparedStatement.setObject(i + 1, params.get(i).getSqlValue());
 }
 ResultSet resultSet = preparedStatement.executeQuery();
 ResultSetMetaData md = resultSet.getMetaData();
 while (resultSet.next()) {
 int counter = md.getColumnCount();
 String colName[] = new String[counter];
 Map&lt;String, Object&gt; field = new HashMap&lt;&gt;();
 for (int loop = 1; loop &lt;= counter; loop++) {
 int index = loop - 1;
 colName[index] = md.getColumnLabel(loop);
 field.put(colName[index], resultSet.getObject(colName[index]));
 }
 rows.add(field);
 }
 }
 } catch (SQLException e) {
 e.printStackTrace();
 } finally {
 if (preparedStatement != null) {
 try {
 preparedStatement.close();
 }catch (Exception e1) {
 e1.printStackTrace();
 }
 }
 if (conn != null) {
 try {
 conn.close();
 } catch (SQLException e) {
 e.printStackTrace();
 }
 }
 }
 return rows;
</code></pre>

blocks|key|1594681|text|我知道，这个问题已经回答了，但像我这样的人可能需要通过标签而不是索引来访问DatabaseMetaData中的列名：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1594682|ResultSet+resultSet+=+null;
DatabaseMetaData+metaData+=+null;

++++try+{
++++++++metaData++=+connection.getMetaData();
++++++++resultSet+=+metaData.getColumns(null,+null,+tableName,+null);

++++++++while+(resultSet.next()){
++++++++++++String+name+=+resultSet.getString("COLUMN_NAME");
++++++++}
++++}|code-block|syntax|javascript|1594683|entityMap^0|11|G|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

I know, this question is already answered but probably somebody like me needs to access a column name from <code>DatabaseMetaData</code> by label instead of index:

<pre><code>ResultSet resultSet = null;
DatabaseMetaData metaData = null;

 try {
 metaData = connection.getMetaData();
 resultSet = metaData.getColumns(null, null, tableName, null);

 while (resultSet.next()){
 String name = resultSet.getString("COLUMN_NAME");
 }
 }
</code></pre>

With <code>java.sql.ResultSet</code> is there a way to get a column's name as a <code>String</code> by using the column's index? I had a look through the API doc but I can't find anything.

Retrieve column names from java.sql.ResultSet

对于java.sql.ResultSet，有没有一种方法可以通过使用列的索引来获取列名作为String？我看了一下API文档，但什么也找不到。

问从java.sql.ResultSet检索列名
EN

回答 11

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问从java.sql.ResultSet检索列名EN

回答 11

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问从java.sql.ResultSet检索列名
EN