alvinalexander.com | career | drupal | java | mac | mysql | perl | scala | uml | unix  

What this is

This file is included in the DevDaily.com "Java Source Code Warehouse" project. The intent of this project is to help you "Learn Java by Example" TM.

Other links

The source code

/*
** Copyright (c) 1998 by Timothy Gerard Endres
** <mailto:time@ice.com>  
** 
** This program is free software.
** 
** You may redistribute it and/or modify it under the terms of the GNU
** General Public License as published by the Free Software Foundation.
** Version 2 of the license should be included with this distribution in
** the file LICENSE, as well as License.html. If the license is not
** included	with this distribution, you may find a copy at the FSF web
** site at 'www.gnu.org' or 'www.fsf.org', or you may write to the
** Free Software Foundation, 675 Mass Ave, Cambridge, MA 02139 USA.
**
** THIS SOFTWARE IS PROVIDED AS-IS WITHOUT WARRANTY OF ANY KIND,
** NOT EVEN THE IMPLIED WARRANTY OF MERCHANTABILITY. THE AUTHOR
** OF THIS SOFTWARE, ASSUMES _NO_ RESPONSIBILITY FOR ANY
** CONSEQUENCE RESULTING FROM THE USE, MODIFICATION, OR
** REDISTRIBUTION OF THIS SOFTWARE. 
** 
*/

package com.ice.sqlclient;

import java.sql.*;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.event.*;
import javax.swing.table.*;

import com.ice.util.AWTUtilities;
import com.ice.util.UserProperties;


public class
TableDefsPanel extends JPanel
		implements ActionListener, ChangeListener, ItemListener
	{
	private JComboBox		tableList;
	private JButton			refreshButton;

	private JPanel			tablePanel;
	private JSplitPane		splitPane;

	private JTable			resultTable;
	private JDBCAdapter		sqlAdapter;
	private JScrollPane		scroller;

	private boolean			isListFresh;
	private boolean			isTableFresh; // unused

	private int				autoResizeMode;


	public
	TableDefsPanel()
		{
		super();
		this.isListFresh = false;
		this.setDoubleBuffered( true );
		this.establishContents();
		}

	public void
	actionPerformed( ActionEvent event )
		{
		String command = event.getActionCommand();

		if ( command.equals( "REFRESH" ) )
			{
			this.refresh();
			}
		else
			{
			ErrMsgAdapter msgTable =
				new ErrMsgAdapter
					( "INTERNAL ERROR: unknown command: " + command );
			this.setTableModel( msgTable );
			}
		}

	public void
	refresh()
		{
		SQLClientHandler handler = this.getMyHandler();
		if ( handler != null )
			{
			handler.flushTableCaches();
			this.isListFresh = false;
			this.refreshTableList();
			}
		}

	public void
	itemStateChanged( ItemEvent event )
		{
		if ( event.getStateChange() == ItemEvent.SELECTED )
			{
			String tableName = (String)
				this.tableList.getSelectedItem();

			this.refreshTableDef( tableName );
			}
		}

	public void
	stateChanged( ChangeEvent event )
		{
		JTabbedPane pane =
			(JTabbedPane) event.getSource();

		if ( pane.getSelectedComponent() == this )
			{
			if ( ! this.isListFresh )
				{
				this.refreshTableList();
				}
			}
		}

	public void
	refreshTableDef( String tableName )
		{
		SQLClientHandler handler = this.getMyHandler();
		if ( handler == null ) return;

		try {
			this.sqlAdapter =
				handler.getTableColumnInfo( tableName );

			this.setTableModel( this.sqlAdapter );
			}
		catch ( SQLException ex )
			{
			String msg =
				"SQLException: retrieving table definition:\n"
					+ ex.getMessage();
			ErrMsgAdapter msgTable = new ErrMsgAdapter( msg );
			this.setTableModel( msgTable );
			}
		}

	public void
	refreshTableList()
		{
		SQLClientHandler handler = this.getMyHandler();
		if ( handler == null ) return;

		try {
			String[] list =
				handler.getDatabaseTableList();

			if ( this.tableList.getItemCount() > 0 )
				{
				this.tableList.removeAllItems();
				}

			for ( int i = 0 ; i < list.length ; ++i )
				{
				this.tableList.addItem( list[i] );
				}

			this.isListFresh = true;
			}
		catch ( SQLException ex )
			{
			String msg =
				"SQLException: retrieving table information:\n"
					+ ex.getMessage();
			ErrMsgAdapter msgTable = new ErrMsgAdapter( msg );
			this.setTableModel( msgTable );
			}
		}

	private void
	setTableModel( TableModel model )
		{
		if ( model instanceof ErrMsgAdapter )
			{
			this.resultTable.setAutoResizeMode
				( JTable.AUTO_RESIZE_ALL_COLUMNS );
			}
		else
			{
			this.resultTable.setAutoResizeMode
				( this.autoResizeMode );
			}

		this.resultTable.setModel( model );
		
		this.resultTable.tableChanged
			( new TableModelEvent
				( model, TableModelEvent.HEADER_ROW ) );
		}

	private SQLClientHandler
	getMyHandler()
		{
		SQLClientHandler handler =
			SQLClientHandler.getCurrentHandler();

		if ( handler == null )
			{
			ErrMsgAdapter msgTable =
				new ErrMsgAdapter
					( "INTERNAL ERROR: current handler is null." );
			this.setTableModel( msgTable );
			}
		else if ( ! handler.isOpen() )
			{
			ErrMsgAdapter msgTable =
				new ErrMsgAdapter
					( "INTERNAL ERROR: connection is not open." );
			this.setTableModel( msgTable );
			handler = null;
			}

		return handler;
		}

	private void 
	establishContents()
		{
		JLabel	lbl;
		int		row = 0;

		this.setLayout( new GridBagLayout() );

		this.refreshButton = new JButton( "Refresh" );
		this.refreshButton.addActionListener( this );
		this.refreshButton.setActionCommand( "REFRESH" );
		AWTUtilities.constrain(
			this, this.refreshButton,
			GridBagConstraints.NONE,
			GridBagConstraints.CENTER,
			0, row, 1, 1, 0.0, 0.0 );

		this.tableList = new JComboBox();
		this.tableList.setEditable( false );
		this.tableList.addItemListener( this );
		AWTUtilities.constrain(
			this, this.tableList,
			GridBagConstraints.HORIZONTAL,
			GridBagConstraints.CENTER,
			1, row++, 1, 1, 1.0, 0.0 );
		
		this.tablePanel = new JPanel();
		this.tablePanel.setLayout( new GridBagLayout() );

		int subRow = 0;

		lbl = new JLabel( "Table Definition:" );
		AWTUtilities.constrain(
			this.tablePanel, lbl,
			GridBagConstraints.NONE,
			GridBagConstraints.WEST,
			0, subRow++, 1, 1, 0.0, 0.0 );

		this.sqlAdapter =
			new MySQLAdapter( null );

		this.resultTable =
			new JTable( this.sqlAdapter );

	//	this.autoResizeMode =
	//		UserProperties.getClassConstant
	//			( "tableDefsAutoResizeMode",
	//				JTable.AUTO_RESIZE_ALL_COLUMNS );
		this.autoResizeMode = JTable.AUTO_RESIZE_ALL_COLUMNS;

		this.resultTable.setAutoResizeMode
			( this.autoResizeMode );

        this.scroller = new JScrollPane( this.resultTable );
		this.scroller.setMinimumSize( new Dimension( 300, 50 ) );
		this.scroller.setVerticalScrollBarPolicy
			( ScrollPaneConstants.VERTICAL_SCROLLBAR_ALWAYS );
		this.scroller.setHorizontalScrollBarPolicy
			( ScrollPaneConstants.HORIZONTAL_SCROLLBAR_ALWAYS );

		AWTUtilities.constrain(
			this.tablePanel, scroller,
			GridBagConstraints.BOTH,
			GridBagConstraints.CENTER,
			0, subRow++, 1, 1, 1.0, 1.0 );

		AWTUtilities.constrain(
			this, this.tablePanel,
			GridBagConstraints.BOTH,
			GridBagConstraints.NORTH,
			0, row++, 2, 1, 1.0, 1.0 );
		}

	}


... this post is sponsored by my books ...

#1 New Release!

FP Best Seller

 

new blog posts

 

Copyright 1998-2021 Alvin Alexander, alvinalexander.com
All Rights Reserved.

A percentage of advertising revenue from
pages under the /java/jwarehouse URI on this website is
paid back to open source projects.