print ResultSet Row - Java java.sql

Java examples for java.sql:ResultSet

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

Description

print ResultSet Row

Demo Code


//package com.java2s;

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

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

        printResultSetRow(rs, numColumns);
    }/*from w ww  .  ja va2  s.  c om*/

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

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

Related Tutorials