import java.sql.Connection; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.sql.Statement; public class TestResultSetMetaData { public static void main(String[] args) { String sql = "select * from login order by id"; try{ Connection conn = DBUtil.getConn(); //获得可以前后滚动的类型 Statement stmt = conn.createStatement( ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE ); //通过Statement获得结果集 ResultSet rs = stmt.executeQuery(sql); System.out.println("===========开始测试MetaDate==========="); ResultSetMetaData rsm = rs.getMetaData(); System.out.println("共获得"+rsm.getColumnCount()+"列信息"); for(int i=1;i<=rsm.getColumnCount();i++){ System.out.println("第"+i+"列的名字为:"+rsm.getColumnName(i)+",类型为:"+rsm.getColumnType(i)); } }catch(Exception e){ e.printStackTrace(); } } }