print ResultSet - Java java.sql

Java examples for java.sql:ResultSet

  1. HOME
  2. Java
  3. java.sql
  4. ResultSet

Description

print ResultSet

Demo Code


//package com.java2s;

import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;

public class Main {
    public static void printResultSet(ResultSet rs) throws SQLException {
        ResultSetMetaData metaData = rs.getMetaData();
        int numColumns = printResultSetHeader(metaData);

        while (rs.next()) {
            printResultSetRow(rs, numColumns);
        }//www.j  a  va  2  s  . co m
    }

    public static int printResultSetHeader(ResultSet rs)
            throws SQLException {
        return printResultSetHeader(rs.getMetaData());
    }

    public static int printResultSetHeader(ResultSetMetaData metaData)
            throws SQLException {
        int numColumns = metaData.getColumnCount();
        for (int i = 1; i <= numColumns; i++)
            System.out.print(metaData.getColumnLabel(i) + "\t");
        System.out.println("");
        return numColumns;
    }

    public static void printResultSetRow(ResultSet rs) throws SQLException {
        ResultSetMetaData metaData = rs.getMetaData();
        int numColumns = printResultSetHeader(metaData);

        printResultSetRow(rs, numColumns);
    }

    public static void printResultSetRow(ResultSet rs, int numColumns)
            throws SQLException {
        Object obj = null;
        for (int i = 1; i <= numColumns; i++) {
            obj = rs.getObject(i);
            if (obj != null) {
                System.out.print(rs.getObject(i).toString() + "\t");
            } else {
                System.out.print("\t\t");
            }
        }
        System.out.println("");
    }
}

Related Tutorials