01: package net.sourceforge.squirrel_sql.client.gui.controls;
02:
03: /*
04: * Copyright (C) 2003 Colin Bell
05: * colbell@users.sourceforge.net
06: *
07: * This library is free software; you can redistribute it and/or
08: * modify it under the terms of the GNU Lesser General Public
09: * License as published by the Free Software Foundation; either
10: * version 2.1 of the License, or (at your option) any later version.
11: *
12: * This library is distributed in the hope that it will be useful,
13: * but WITHOUT ANY WARRANTY; without even the implied warranty of
14: * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
15: * Lesser General Public License for more details.
16: *
17: * You should have received a copy of the GNU Lesser General Public
18: * License along with this library; if not, write to the Free Software
19: * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
20: */
21: import java.awt.Component;
22: import java.sql.SQLException;
23:
24: import javax.swing.JComboBox;
25: import javax.swing.JList;
26: import javax.swing.plaf.basic.BasicComboBoxRenderer;
27:
28: import net.sourceforge.squirrel_sql.fw.sql.ISQLConnection;
29: import net.sourceforge.squirrel_sql.fw.sql.ITableInfo;
30: import net.sourceforge.squirrel_sql.fw.sql.TableColumnInfo;
31:
32: /**
33: * This combobox contains all the columns in an SQL table.
34: *
35: * @author <A HREF="mailto:colbell@users.sourceforge.net">Colin Bell</A>
36: */
37: public class ColumnsComboBox extends JComboBox {
38: /**
39: * Ctor.
40: *
41: * @param conn Connection to the database containing the table.
42: * @param ti Pointer to the table we want to display columns for.
43: *
44: * @throws IllegalArgumentException
45: * Thrown if a <TT>null</TT>SQLConnection</TT> or <TT>ITableInfo</TT>
46: * passed in.
47: *
48: * @throws SQLException Thrown if an SQL error occurs.
49: */
50: public ColumnsComboBox(ISQLConnection conn, ITableInfo ti)
51: throws SQLException {
52: super (getData(conn, ti));
53: setRenderer(new CellRenderer());
54: }
55:
56: public TableColumnInfo getSelectedColumn() {
57: return (TableColumnInfo) getSelectedItem();
58: }
59:
60: private static TableColumnInfo[] getData(ISQLConnection conn,
61: ITableInfo ti) throws SQLException {
62: if (conn == null) {
63: throw new IllegalArgumentException("SQLConnection == null");
64: }
65: if (ti == null) {
66: throw new IllegalArgumentException("ITableInfo == null");
67: }
68:
69: return conn.getSQLMetaData().getColumnInfo(ti);
70: }
71:
72: /**
73: * This renderer uses the unqualified column name as the text to display
74: * in the combo.
75: */
76: private static final class CellRenderer extends
77: BasicComboBoxRenderer {
78: public Component getListCellRendererComponent(JList list,
79: Object value, int index, boolean isSelected,
80: boolean cellHasFocus) {
81: setOpaque(true);
82: setText(((TableColumnInfo) value).getColumnName());
83: return this;
84: }
85: }
86: }
|