DbUtils.java

import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.util.Vector;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.TableModel;
public class DbUtils
{
	public static TableModel resultSetToTableModel(ResultSet rs)
	{
		try
		{
			ResultSetMetaData metData = rs.getMetaData();
			int numberOfColumns = metData.getColumnCount();
			Vector columnNames = new Vector();
			
			for(int column = 0; column<numberOfColumns; column++)
			{
				columnNames.addElement(metData.getColumnLabel(column + 1));
			}
			
			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;
		}
	}
}