要获得结果集中的列名,您需要使用getmetadata()方法。getmetadata()的原型如下 −
ResultSetMetaData getMetaData throws SQLException;
Create a MySQL table with 5 column names. The query to create a table is as follows −
mysql> create table javagetallcolumnnames -> ( -> Id int NOT NULL AUTO_INCREMENT, -> Name varchar(20), -> Age int, -> Salary float, -> Address varchar(100), -> PRIMARY KEY(Id) -> ); Query OK, 0 rows affected (1.34 sec)
以下是获取ResultSet中列名的Java代码。代码如下 −
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import com.mysql.jdbc.ResultSetMetaData;
public class GetAllColumnNames {
public static void main(String[] args) {
String JdbcURL="jdbc:mysql://localhost:3306/test?useSSL=false";
String Username="root";
String password="123456";
Connection con=null;
Statement stmt=null;
ResultSet rs;
try {
con = DriverManager.getConnection(JdbcURL, Username, password);
stmt=con.createStatement();
rs = stmt.executeQuery("SELECT *FROM javagetallcolumnnames");
ResultSetMetaData md = (ResultSetMetaData) rs.getMetaData();
int counter = md.getColumnCount();
String colName[] = new String[counter];
System.out.println("The column names are as follows:");
for (int loop = 1; loop <= counter; loop++) {
colName[loop-1] = md.getColumnLabel(loop);
System.out.println(colName[loop-1]);
}
} catch(Exception e) {
e.printStackTrace();
}
}
}Here is the snapshot of the code −

立即学习“Java免费学习笔记(深入)”;
The following is the output −
The column names are as follows: Id Name Age Salary Address
这是示例输出的快照 −

以上就是如何使用 MySQL 在 Java 中获取 ResultSet 上的列名称?的详细内容,更多请关注php中文网其它相关文章!
java怎么学习?java怎么入门?java在哪学?java怎么学才快?不用担心,这里为大家提供了java速学教程(入门到精通),有需要的小伙伴保存下载就能学习啦!
Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号