一直想做一个报表系统,只要把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(); } }