Java ResultSet to TableModel resultSetToTableModel(ResultSet rs)

Description

result Set To Table Model

License

Apache License

Parameter

Parameter	Description
rs	a parameter

Declaration

public static TableModel resultSetToTableModel(ResultSet rs) 

Method Source Code

//package com.java2s;
//License from project: Apache License 

import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.util.Vector;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.TableModel;

public class Main {
    /**/*from www.j a v a  2 s  .c o m*/
     *
     * @param rs
     * @return
     */
    public static TableModel resultSetToTableModel(ResultSet rs) {
        try {
            ResultSetMetaData metaData = rs.getMetaData();
            int numberOfColumns = metaData.getColumnCount();
            Vector columnNames = new Vector();

            // Get the column names
            for (int column = 0; column < numberOfColumns; column++) {
                columnNames.addElement(metaData.getColumnLabel(column + 1));
            }

            // Get all rows.
            Vector rows = new Vector();

            while (rs.next()) {
                Vector newRow = new Vector();

                for (int i = 1; i <= numberOfColumns; i++) {
                    newRow.addElement(rs.getObject(i));
                }

                rows.addElement(newRow);
            }

            return new DefaultTableModel(rows, columnNames);
        } catch (Exception e) {
            e.printStackTrace();

            return null;
        }
    }
}

Related

1. resultSetToTableModel(ResultSet paramResultSet)
2. resultSetToTableModel(ResultSet rs)