ResultSetMetaData

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();}}}