java，

java，

 

public static void main(String[] args) {
		Connection connection = DBConnection.getConn();
		Statement statement = null;
		ResultSet  resultSet = null;
		ResultSetMetaData resultSetMetaData = null;
		int columnCount;
		try {
			statement  =  connection.createStatement();
			String sql = "select name,age,sex from person";
			resultSet = statement.executeQuery(sql);
			resultSetMetaData = resultSet.getMetaData();
			columnCount = resultSetMetaData.getColumnCount();
			System.out.println("结果集包含的列数为"+columnCount);
			for(int i=1;i<=columnCount;i++){
				System.out.println("第"+i+"列的列名为										"+resultSetMetaData.getColumnName(i)+","+"类型为								"+resultSetMetaData.getColumnTypeName(i));
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			DBConnection.close(connection, statement, resultSet);
		}
	}