net.sourceforge.squirrel_sql.fw.sql.TableInfoDataSet Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of fw Show documentation

The framework library contains utility classes that are generic and useful for building applications that introspect a database via JDBC. These are not intended to be SQuirreLSQL-specific and could be used by other projects JDBC front-end applications. This project is guaranteed to have no code dependencies on other SQuirreLSQL projects and could therefore be used when building a different JDBC front-end application.

There is a newer version: 3.5.0

Show newest version

package net.sourceforge.squirrel_sql.fw.sql;
/*
 * Copyright (C) 2001-2004 Colin Bell
 * [email protected]
 *
 * This library is free software; you can redistribute it and/or
 * modify it under the terms of the GNU Lesser General Public
 * License as published by the Free Software Foundation; either
 * version 2.1 of the License, or (at your option) any later version.
 *
 * This library is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
 * Lesser General Public License for more details.
 *
 * You should have received a copy of the GNU Lesser General Public
 * License along with this library; if not, write to the Free Software
 * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
 */
import net.sourceforge.squirrel_sql.fw.datasetviewer.ColumnDisplayDefinition;
import net.sourceforge.squirrel_sql.fw.datasetviewer.DataSetDefinition;
import net.sourceforge.squirrel_sql.fw.datasetviewer.IDataSet;
import net.sourceforge.squirrel_sql.fw.util.IMessageHandler;
import net.sourceforge.squirrel_sql.fw.util.StringManager;
import net.sourceforge.squirrel_sql.fw.util.StringManagerFactory;
/**
 * This implementation of IDataSet is used to display
 * a ITableInfo object.
 *
 * @author Colin Bell
 */
public class TableInfoDataSet implements IDataSet
{
	/** Internationalized strings for this class. */
	private static final StringManager s_stringMgr =
		StringManagerFactory.getStringManager(TableInfoDataSet.class);

	private final static String[] s_hdgs =
		new String[]
		{
			s_stringMgr.getString("TableInfoDataSet.property"),
			s_stringMgr.getString("TableInfoDataSet.value"),
		};

	private DataSetDefinition _dsDef;

	private int _curRow = -1;

	private String[][] _data = new String[][]
	{
		{
			s_stringMgr.getString("TableInfoDataSet.rowheading.name"), null
		},
		{
			s_stringMgr.getString("TableInfoDataSet.rowheading.qualname"), null
		},
		{
			s_stringMgr.getString("TableInfoDataSet.rowheading.catalog"), null
		},
		{
			s_stringMgr.getString("TableInfoDataSet.rowheading.schema"), null
		},
		{
			s_stringMgr.getString("TableInfoDataSet.rowheading.type"), null
		},
		{
			s_stringMgr.getString("TableInfoDataSet.rowheading.remarks"), null
		},
	};

	/**
	 * Default ctor.
	 */
	public TableInfoDataSet()
	{
		this(null);
	}

	/**
	 * Ctor specifying the ITableInfo to be displayed.
	 *
	 * @param	ti	The ITableInfo to be displayed.
	 */
	public TableInfoDataSet(ITableInfo ti)
	{
		super();
		_dsDef = new DataSetDefinition(createColumnDefinitions());
		setTableInfo(ti);
	}

	public final int getColumnCount()
	{
		return s_hdgs.length;
	}

	public DataSetDefinition getDataSetDefinition()
	{
		return _dsDef;
	}

	public synchronized void setTableInfo(ITableInfo ti)
	{
		if (ti != null)
		{
			load(ti);
		}
		else
		{
			for (int i = 0; i < _data.length; ++i)
			{
				_data[i][1] = "";
			}
		}
	}

	public synchronized boolean next(IMessageHandler msgHandler)
	{
		if (_curRow >= _data.length - 1)
		{
			return false;
		}
		++_curRow;
		return true;
	}

	public synchronized Object get(int columnIndex)
	{
		return _data[_curRow][columnIndex];
	}

	private ColumnDisplayDefinition[] createColumnDefinitions()
	{
		final int columnCount = getColumnCount();
		ColumnDisplayDefinition[] columnDefs =
			new ColumnDisplayDefinition[columnCount];
		for (int i = 0; i < columnCount; ++i)
		{
			columnDefs[i] = new ColumnDisplayDefinition(100, s_hdgs[i]);
		}
		return columnDefs;
	}

	private void load(ITableInfo ti)
	{
		_data[0][1] = ti.getSimpleName();
		_data[1][1] = ti.getQualifiedName();
		_data[2][1] = ti.getCatalogName();
		_data[3][1] = ti.getSchemaName();
		_data[4][1] = ti.getType();
		_data[5][1] = ti.getRemarks();

		_curRow = -1;
	}
}