ResultSetMetaData 实例
package com.app.util;import java.sql.Connection;import java.sql.DatabaseMetaData;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.ResultSetMetaData;import java.sql.Statement;public class JdbcTest {private static ResultSet rs;private static ResultSetMetaData rsmd;private static DatabaseMetaData dma;private static Connection con;private static Statement stmt;public static void main(String[] args) throws Exception {String url = "jdbc:mysql://localhost:3306/test?characterEncoding=GBK";try {Class.forName("com.mysql.jdbc.Driver");con = DriverManager.getConnection(url, "root", "root");// 连接数据库//dma = con.getMetaData();// 获取数据库的元数据String sql="select * from quart";stmt = con.createStatement();rs = stmt.executeQuery(sql);rsmd = rs.getMetaData();int columns = rsmd.getColumnCount();//一个多少个字段列名String rows = "";while(rs.next()){for (int i = 1; i <= columns; i++) {rows= rsmd.getColumnName(i);//System.out.println(rows);//字段名System.out.println(rs.getString(rows));}}} catch (Exception e) {System.err.println("query exception");} finally {rs.close();}}}
?
