取得查询SQL里面的字段名和类型

 一直想做一个报表系统，只要把SQL写入就可以自动生成报表，先做一点简单的实现：

 

package com.ur.util;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSetMetaData;import java.sql.SQLException;/** * Jan 13, 2011 GetColumnName.java author:linbler */public class GetColumnName {public static void main(String avgs[]) throws SQLException {DB db = new DB();db.Init();Connection conn = db.getConnection();PreparedStatement pstmt = (PreparedStatement) conn.prepareStatement("select a.site_id from dmm_site_info a");pstmt.execute();ResultSetMetaData rsmd = (ResultSetMetaData) pstmt.getMetaData();for (int i = 1; i < rsmd.getColumnCount() + 1; i++) {System.out.println(rsmd.getColumnName(i));System.out.println(rsmd.getColumnClassName(i));}db.setClose();}}