ben riches

Ranch Hand

+ Follow

news 126 Posts 69 Threads

since Nov 08, 2002

Merit badge: grant badges

For More

Cows and Likes

Cows

Total received

In last 30 days

Forums and Threads

Recent posts by ben riches

Resultset

I did not patchwork my code as I used Visual Age for Java.

20 years ago

Swing / AWT / SWT

Resultset

Sorry if I sound rude, but is there anyone who can help me with this please?
Thanks
Ben

20 years ago

Swing / AWT / SWT

Resultset

Hello all,
The code below pulls out the columnnames from a database and diplays them in a JList. How can I get the JList to display the data that is in a columnname called ben?
Thanks
Ben

import java.awt.Color;
import java.awt.Component;
import javax.swing.table.JTableHeader;
import javax.swing.table.TableModel;
import javax.swing.text.html.*;
import java.net.*;
import java.util.*;
import java.io.*;
import java.awt.*;
import javax.swing.table.*;
import java.util.List;
import javax.swing.*;
import javax.swing.filechooser.FileFilter;
import java.awt.event.ActionListener;
import java.awt.event.ActionEvent;
import java.awt.event.*;
import java.lang.*;
import java.util.StringTokenizer.*;
import java.sql.*;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.DefaultTableCellRenderer;
import java.awt.*;
import javax.swing.*;
public class Ar extends JFrame {
DefaultListModel model = new DefaultListModel();
JList list = new JList();
String item;
static Connection conn2;
static DatabaseMetaData DMD;
private JPanel ivjArPane = null;
private JPanel ivjJFrameContentPane = null;
private JScrollPane ivjJScrollPane1 = null;
private JList ivjJList1 = null;
public Ar() {
super();
initialize();
}
public Ar(String title) {
super(title);
}
private javax.swing.JPanel getArPane() {
if (ivjArPane == null) {
try {
ivjArPane = new javax.swing.JPanel();
ivjArPane.setName("ArPane");
ivjArPane.setLayout(null);
getArPane().add(getJScrollPane1(), getJScrollPane1().getName());
} catch (java.lang.Throwable ivjExc) {
handleException(ivjExc);
}
}
return ivjArPane;
}
private javax.swing.JPanel getJFrameContentPane() {
if (ivjJFrameContentPane == null) {
try {
ivjJFrameContentPane = new javax.swing.JPanel();
ivjJFrameContentPane.setName("JFrameContentPane");
ivjJFrameContentPane.setLayout(new java.awt.BorderLayout());
getJFrameContentPane().add(getArPane(), "Center");
} catch (java.lang.Throwable ivjExc) {
handleException(ivjExc);
}
}
return ivjJFrameContentPane;
}
private javax.swing.JList getJList1() {
if (ivjJList1 == null) {
try {
try {
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" ) ;
conn2 = DriverManager.getConnection( "jdbc :-o dbc:myProject") ;
Statement st=conn2.createStatement();
st.execute("SELECT * FROM ben ");
ResultSet rs=st.getResultSet();
ResultSetMetaData md=rs.getMetaData();
for (int i=1;i<=md.getColumnCount();i++) {
model.addElement(md.getColumnName(i));
}
st.close() ;
} catch (SQLException se1 ) {
System.out.println( "SQL Exception: " + se1 ) ;
} catch (Exception ex ) {
//System.out.println( ex ) ;
}
ivjJList1 = new javax.swing.JList(model);
ivjJList1.setName("JList1");
ivjJList1.setBounds(0, 0, 160, 120);
} catch (java.lang.Throwable ivjExc) {
handleException(ivjExc);
}
}
return ivjJList1;
}
private javax.swing.JScrollPane getJScrollPane1() {
if (ivjJScrollPane1 == null) {
try {
ivjJScrollPane1 = new javax.swing.JScrollPane();
ivjJScrollPane1.setName("JScrollPane1");
ivjJScrollPane1.setBounds(132, 126, 160, 120);
getJScrollPane1().setViewportView(getJList1());
} catch (java.lang.Throwable ivjExc) {
handleException(ivjExc);
}
}
return ivjJScrollPane1;
}
private void handleException(java.lang.Throwable exception) {
}
private void initialize() {
try {
setName("Ar");
setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
setSize(460, 300);
setTitle("Ar");
setContentPane(getJFrameContentPane());
} catch (java.lang.Throwable ivjExc) {
handleException(ivjExc);
}
}
public static void main(java.lang.String[] args) {
try {
UIManager.setLookAndFeel(UIManager.getSystemLookAndFeelClassName());
Ar aAr = new Ar();
aAr.addWindowListener(new java.awt.event.WindowAdapter() {
public void windowClosed(java.awt.event.WindowEvent e) {
System.exit(0);
};
});
aAr.setVisible(true);
} catch (Throwable exception) {
System.err.println("Exception occurred in main() of Ar");
exception.printStackTrace(System.out);
}
}
}

20 years ago

Swing / AWT / SWT

JComboBox Help!

Originally posted by Nigel Browne:
Try changing
tcm.getColumn(0).setCellEditor(editor2);
to this tcm.getColumn(0).setCellEditor(new DefaultCellEditor(editor2));
Regards
Nigel

Hi Nigel,
I have done what you said but I got this error
C:\j21work>javac ComboBoxTable.java
ComboBoxTable.java:98: cannot resolve symbol
symbol : constructor DefaultCellEditor (javax.swing.DefaultCellEditor)
location: class javax.swing.DefaultCellEditor
tcm.getColumn(0).setCellEditor(new DefaultCellEditor(editor2));
^
1 error
Thanks
Ben

20 years ago

Swing / AWT / SWT

JComboBox Help!

Hello All,
I have posted here in the past about JComboBox and you lot have helped me out greatly. I have one more problem then I can stop nagging you.
the code below puts values from a database into 2 combo boxes, and puts those combo boxes in to the JTabel. when the code is run the cells in the JTable are first of all cells untill I click into a cell it then changes to a Combo Box, I want the JTable to always display each cell as Combo Boxes.
I hope you understand what I mean?
Thanks
Ben

import javax.swing.*;
import javax.swing.table.*;
import java.awt.event.*;
import java.awt.*;
import java.lang.Object.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
import java.util.*;
public class ComboBoxTable {
static Connection conn2;
static DatabaseMetaData DMD;
static JComboBox group = new JComboBox();
static JComboBox groupList = new JComboBox();
static String[] item;
public static void main(String[] args) {
try {
// Load the database driver
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" ) ;
conn2 = DriverManager.getConnection( "jdbc :-o dbc :-P ro") ;
DMD=conn2 .getMetaData();
ResultSet rs=DMD.getTables(null,null,null,new String[]{"TABLE"});
while(rs.next()) {
group.addItem((String)rs.getString(3));
}
rs.close() ;
} catch (SQLException se ) {
System.out.println( "SQL Exception: " + se ) ;
} catch (Exception e ) {
System.out.println( e ) ;
}
group.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e ) {
String tbl = (String)group.getSelectedItem();
try {
Statement st=conn2.createStatement();
st.execute("SELECT * FROM "+tbl+" ");
ResultSet rs=st.getResultSet();
ResultSetMetaData md=rs.getMetaData();
groupList.removeAllItems();
for (int i=1;i<=md.getColumnCount();i++) {
groupList.addItem(md.getColumnName(i));
}
st.close() ;
} catch (SQLException se ) {
System.out.println( "SQL Exception: " + se ) ;
} catch (Exception ex ) {
System.out.println( ex ) ;
}
}
});
int j1=10;
String[][] data = new String[j1][2];
for (int k=0; k<j1; k++){
String[] row = {"",""};
data[k] = row;
}
String[] colNames = {"Column A", "Column B"};
DefaultTableModel model = new DefaultTableModel(data, colNames);
JTextField jtf = new JTextField();
JTable tbl = new JTable(model);
// Create the combo box editor
DefaultCellEditor editor = new DefaultCellEditor(groupList);
// ADDED IN MY ATTEMPT TO HAVE TO COLUMNS WITH COMBOBOXES
DefaultCellEditor editor2 = new DefaultCellEditor(group);
// Assign the editor to the second column
TableColumnModel tcm = tbl.getColumnModel();
tcm.getColumn(0).setCellEditor(editor2);
// ADDED
tcm.getColumn(1).setCellEditor(editor);
// Set column widths
tcm.getColumn(0).setPreferredWidth(200);
tcm.getColumn(1).setPreferredWidth(100);
// Set row heighht
tbl.setRowHeight(20);
tbl.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
tbl.setPreferredScrollableViewportSize(tbl.getPreferredSize());
JFrame f = new JFrame("ComboBoxDemo");
f.getContentPane().add(new JScrollPane(tbl), "Center");
f.pack();
f.addWindowListener(new WindowAdapter() {
public void windowClosing(WindowEvent evt) {
System.exit(0);
}
});
f.setVisible(true);
}
}

[ March 30, 2004: Message edited by: ben riches ]

20 years ago

Swing / AWT / SWT

why is my JTable not showing up?

Originally posted by Brian Pipa:
Has it EVER shown up? You should probably put in some dummy/test values to begin with to see if your table shows up - once you confirm that it does, THEN try getting the data from a DB.
Brian

Yes I have got it to show with the ComBoxes showing all that I need but when one of the Table Names is not accepted it thows 1 Exception when I choose that Table Name, then thows the same Exception again when I go back into the ComboBox to change the table name.
Why do you think this is?

import javax.swing.*;
import javax.swing.table.*;
import java.awt.event.*;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
public class ComboBoxTable {
static Connection conn2;
static DatabaseMetaData DMD;
static JComboBox group = new JComboBox();
static JComboBox groupList = new JComboBox();
public static void main(String[] args) {
try {
// Load the database driver
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" ) ;
conn2 = DriverManager.getConnection( "jdbc :-o dbc:myProject") ;
DMD=conn2 .getMetaData();
ResultSet rs=DMD.getTables(null,null,null,new String[]{"TABLE"});
while(rs.next()) {
group.addItem((String)rs.getString(3));
}
rs.close() ;
} catch (SQLException se ) {
System.out.println( "SQL Exception: " + se ) ;
} catch (Exception e ) {
System.out.println( e ) ;
}
group.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e ) {
String tbl = (String)group.getSelectedItem();
try {
Statement st=conn2.createStatement();
st.execute("SELECT * FROM "+tbl+"");
ResultSet rs=st.getResultSet();
ResultSetMetaData md=rs.getMetaData();
groupList.removeAllItems();
for (int i=1;i<=md.getColumnCount();i++) {
groupList.addItem(md.getColumnName(i));
}
st.close() ;
} catch (SQLException se ) {
System.out.println( "SQL Exception: " + se ) ;
} catch (Exception ex ) {
System.out.println( ex ) ;
}
}
});
int j1=10;
String[][] data = new String[j1][2];
for (int k=0; k<j1; k++){
String[] row = {"",""};
data[k] = row;
}
String[] colNames = {"Column A", "Column B"};
JTextField jtf = new JTextField();
JTable tbl = new JTable(data, colNames);
// Create the combo box editor
DefaultCellEditor editor = new DefaultCellEditor(groupList);
// ADDED IN MY ATTEMPT TO HAVE TO COLUMNS WITH COMBOBOXES
DefaultCellEditor editor2 = new DefaultCellEditor(group);
// Assign the editor to the second column
TableColumnModel tcm = tbl.getColumnModel();
tcm.getColumn(0).setCellEditor(editor2);
// ADDED
tcm.getColumn(1).setCellEditor(editor);
// Set column widths
tcm.getColumn(0).setPreferredWidth(200);
tcm.getColumn(1).setPreferredWidth(100);
// Set row heighht
tbl.setRowHeight(20);
tbl.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
tbl.setPreferredScrollableViewportSize(tbl.getPreferredSize());
JFrame f = new JFrame("ComboBoxDemo");
f.getContentPane().add(new JScrollPane(tbl), "Center");
f.pack();
f.addWindowListener(new WindowAdapter() {
public void windowClosing(WindowEvent evt) {
System.exit(0);
}
});
f.setVisible(true);
}
}

Thanks
Ben

20 years ago

Swing / AWT / SWT

why is my JTable not showing up?

Hello All,
Why is my Jtable not showing up?
Thanks
Ben

import java.awt.event.*;
import java.awt.*;
import javax.swing.*;
import java.sql.*;
import javax.swing.table.*;
public class ComboBoxDemo extends JPanel implements ActionListener {
static Connection conn;
DatabaseMetaData DMD;
JComboBox group = new JComboBox();
JComboBox groupList = new JComboBox();
static JTable tbl1;
public ComboBoxDemo() {
group.addActionListener(this);
try {
// Load the database driver
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" ) ;
String url = "jdbc :-o dbc:myproject" ;
conn = DriverManager.getConnection(url) ;
DMD=conn .getMetaData();
ResultSet rs=DMD.getTables(null,null,null,new String[]{"TABLE"});
while(rs.next()) {
group.addItem((String)rs.getString(3));
System.out.println(rs);
}
rs.close() ;
} catch (SQLException se ) {
System.out.println( "SQL Exception: " + se ) ;
} catch (Exception e ) {
System.out.println( e ) ;
}
}
public void actionPerformed(ActionEvent e) {
String tbl = (String)group.getSelectedItem();
try {
Statement st=conn.createStatement();
st.execute("SELECT * FROM "+tbl+"");
ResultSet rs=st.getResultSet();
ResultSetMetaData md=rs.getMetaData();
groupList.removeAllItems();
for (int i=1;i<=md.getColumnCount();i++) {
groupList.addItem(md.getColumnName(i));
System.out.println(groupList);
}
st.close() ;
} catch (SQLException se ) {
System.out.println( "SQL Exception: " + se ) ;
} catch (Exception ex ) {
System.out.println( ex ) ;
}
int j1=10;
String[][] data = new String[j1][2];
for (int k=0; k<j1; k++){
String[] row = {"",""};
data[k] = row;
}
String[] colNames = {"Column A", "Column B"};
tbl1 = new JTable(data, colNames);
DefaultCellEditor editor = new DefaultCellEditor(groupList);
DefaultCellEditor editor2 = new DefaultCellEditor(group);
TableColumnModel tcm = tbl1.getColumnModel();
tcm.getColumn(0).setCellEditor(editor2);
tcm.getColumn(1).setCellEditor(editor);
tcm.getColumn(0).setPreferredWidth(200);
tcm.getColumn(1).setPreferredWidth(100);
tbl1.setRowHeight(20);
tbl1.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
tbl1.setPreferredScrollableViewportSize(tbl1.getPreferredSize());
}
public static void main(String s[]) {
JFrame f = new JFrame("ComboBoxDemo");
f.getContentPane().add(new JScrollPane(tbl1), "Center");
f.addWindowListener(new WindowAdapter() {
public void windowClosing(WindowEvent evt) {
System.exit(0);
}
});
f.setContentPane(new ComboBoxDemo());
f.pack();
f.setVisible(true);
}
}

20 years ago

Swing / AWT / SWT

Jtable cells

Originally posted by Nathan Pruett:
You would just need to make a TableCellRenderer using the panel holding the two comboboxes ( and a TableCellEditor, too... since you obviously expect users to select values from the comboboxes and change the cell's value). However, why would one cell hold two values? Why not use separate columns to hold each set of data?

I have the TableCellRenderer class but how would I do the suggested above.
Also I do want to coulmns the first column would get the Table names from the DataBase the second column gets the colum names from that table the user selected in the column.
Coould you helo me construct my code for the table cell renderer?
what I have at the moment

import javax.swing.*;
import java.awt.event.*;
import java.awt.Color;
import java.awt.Component;
import java.awt.Font;
import javax.swing.BorderFactory;
import javax.swing.JTable;
import javax.swing.border.Border;
import javax.swing.table.DefaultTableCellRenderer;
class MyTableCellRenderer extends DefaultTableCellRenderer {
private final static Border FOCUS_BORDER = BorderFactory.createLineBorder(Color.black);
private final static Font SELECTED_FONT = new Font("Dialog", Font.BOLD, 12);
private final static Font UNSELECTED_FONT = new Font("Dialog", Font.BOLD, 12);
JComboBox comp = new JComboBox();
public MyTableCellRenderer(){
setOpaque(true);
}
public Component getTableCellRendererComponent(
JTable table,
Object value,
boolean isSelected,
boolean isFocused,
int row,
int column){
setText(value == null ? "" : value.toString());
if (column == 0)
setHorizontalAlignment(LEFT);
if (isSelected) {
setBackground(table.getSelectionBackground());
setForeground(table.getSelectionForeground());
setFont(SELECTED_FONT);
} else {
setBackground(table.getBackground());
setForeground(table.getForeground());
setFont(UNSELECTED_FONT);
}
setBorder( isFocused ? FOCUS_BORDER : DefaultTableCellRenderer.noFocusBorder );
return this;
}
}

20 years ago

Swing / AWT / SWT

Jtable cells

Hello All,
How can I get every cell within my JTable to have the two combo boxes that are in the code below to display what currently dispaly.
Thanks
Ben

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
public class ComboBoxDemo extends JPanel {
static Connection conn2;
DatabaseMetaData DMD;
JComboBox group = new JComboBox();
JComboBox groupList = new JComboBox();
public ComboBoxDemo() {
try {
// Load the database driver
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" ) ;
conn2 = DriverManager.getConnection( "jdbc :-o dbc :-P ro") ;
DMD=conn2 .getMetaData();
ResultSet rs=DMD.getTables(null,null,null,new String[]{"TABLE"});
while(rs.next()) {
group.addItem((String)rs.getString(3));
}
rs.close() ;
} catch (SQLException se ) {
System.out.println( "SQL Exception: " + se ) ;
} catch (Exception e ) {
System.out.println( e ) ;
}
group.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
String tbl = (String)group.getSelectedItem();
try {
Statement st=conn2.createStatement();
st.execute("SELECT * FROM "+tbl+" WHERE 1=0");
ResultSet rs=st.getResultSet();
ResultSetMetaData md=rs.getMetaData();
groupList.removeAllItems();
for (int i=1;i<=md.getColumnCount();i++) {
groupList.addItem(md.getColumnName(i));
}
st.close() ;
} catch (SQLException se ) {
System.out.println( "SQL Exception: " + se ) ;
} catch (Exception ex ) {
System.out.println( ex ) ;
}
}
});
// Layout the demo
setLayout(new BorderLayout());
add(group, BorderLayout.NORTH);
add(groupList, BorderLayout.SOUTH);
setBorder(BorderFactory.createEmptyBorder(200,20,20,20));
}
public static void main(String s[]) {
JFrame frame = new JFrame("ComboBoxDemo");
frame.addWindowListener(new WindowAdapter() {
public void windowClosing(WindowEvent e) {
try {
conn2.close() ;
} catch (Throwable t) {
}
System.exit(0);
}
});
frame.setContentPane(new ComboBoxDemo());
frame.pack(); frame.setVisible(true);
}
}

20 years ago

Swing / AWT / SWT

Stll having problems

Hello All,
I am still having problems with regrds to my code. When I select the first combo box and select a table Name that begins with 0 it thows an Exception but when I reselect the combo Box to change the table Name it thows the same Exceptiomn again before I can change the table Name.
How can I get my code so that it thows the Exception only once (the first Exception) ? I have posted on this topic before so I have been looking into it, but just can not find the answer.
Please could someone help me
Thankyou
Ben

import javax.swing.*;
import javax.swing.table.*;
import java.awt.event.*;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
public class ComboBoxTable{
static Connection conn2;
static DatabaseMetaData DMD;
static JComboBox group = new JComboBox();
static JComboBox groupList = new JComboBox();
public static void main(String[] args) {
try {
// Load the database driver
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" ) ;
conn2 = DriverManager.getConnection( "jdbc :-o dbc:myProject") ;
DMD=conn2 .getMetaData();
ResultSet rs=DMD.getTables(null,null,null,new String[]{"TABLE"});
while(rs.next()) {
group.addItem((String)rs.getString(3));
}
rs.close() ;
} catch (SQLException se ) {
System.out.println( "SQL Exception: " + se ) ;
} catch (Exception e ) {
System.out.println( e ) ;
}
group.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
String tbl = (String)group.getSelectedItem();
try {
Statement st=conn2.createStatement();
st.execute("SELECT * FROM "+tbl+" WHERE 1=0");
ResultSet rs=st.getResultSet();
ResultSetMetaData md=rs.getMetaData();
groupList.removeAllItems();
for (int i=1;i<=md.getColumnCount();i++) {
groupList.addItem(md.getColumnName(i));
}
st.close() ;
} catch (SQLException se ) {
System.out.println( "SQL Exception: " + se ) ;
} catch (Exception ex ) {
System.out.println( ex ) ;
}
}
});
int j=10;
String[][] data = new String[j][2];
for (int k=0; k<j; k++){
String[] row = {"",""};
data[k] = row;
}
String[] colNames = {"Column A", "Column B"};
JTextField jtf = new JTextField();
JTable tbl = new JTable(data, colNames);
// Create the combo box editor
DefaultCellEditor editor = new DefaultCellEditor(groupList);
// ADDED IN MY ATTEMPT TO HAVE TO COLUMNS WITH COMBOBOXES
DefaultCellEditor editor2 = new DefaultCellEditor(group);
// Assign the editor to the second column
TableColumnModel tcm = tbl.getColumnModel();
tcm.getColumn(0).setCellEditor(editor2);
// ADDED
tcm.getColumn(1).setCellEditor(editor);
// Set column widths
tcm.getColumn(0).setPreferredWidth(200);
tcm.getColumn(1).setPreferredWidth(100);
// Set row heighht
tbl.setRowHeight(20);
tbl.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
tbl.setPreferredScrollableViewportSize(tbl.getPreferredSize());
JFrame f = new JFrame("ComboBoxDemo");
f.getContentPane().add(new JScrollPane(tbl), "Center");
f.pack();
f.addWindowListener(new WindowAdapter() {
public void windowClosing(WindowEvent evt) {
System.exit(0);
}
});
f.setVisible(true);
}
}

20 years ago

Swing / AWT / SWT

why do I get this exception

So how can I pull all the tablenames out from the database without looking for 1?
Ben

20 years ago

JDBC and Relational Databases

Thowing to many errors

Hi All,
When I run this code and I select a table with an 0 at the beggining it thows a Exception which is fine but when I click into the comboBox where I selected the table it thows the exception again.
Why does it thow the Exception twice and is there a way where I can have it thown only once.
Also is there a way where you can have a diffrent JOption pane (error message) pop up for every diffrent Exception that is thown?

import javax.swing.*;
import javax.swing.table.*;
import java.awt.event.*;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
public class ComboBoxTable{
static Connection conn2;
static DatabaseMetaData DMD;
static JComboBox group = new JComboBox();
static JComboBox groupList = new JComboBox();
public static void main(String[] args) {
try {
// Load the database driver
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" ) ;
conn2 = DriverManager.getConnection( "jdbc :-o dbc:myProject") ;
DMD=conn2 .getMetaData();
ResultSet rs=DMD.getTables(null,null,null,new String[]{"TABLE"});
while(rs.next()) {
group.addItem((String)rs.getString(3));
}
rs.close() ;
} catch (SQLException se ) {
System.out.println( "SQL Exception: " + se ) ;
} catch (Exception e ) {
System.out.println( e ) ;
}
group.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
String tbl = (String)group.getSelectedItem();
try {
Statement st=conn2.createStatement();
st.execute("SELECT * FROM "+tbl+" WHERE 1=0");
ResultSet rs=st.getResultSet();
ResultSetMetaData md=rs.getMetaData();
groupList.removeAllItems();
for (int i=1;i<=md.getColumnCount();i++) {
groupList.addItem(md.getColumnName(i));
}
st.close() ;
} catch (SQLException se ) {
System.out.println( "SQL Exception: " + se ) ;
} catch (Exception ex ) {
System.out.println( ex ) ;
}
}
});
int j=10;
String[][] data = new String[j][2];
for (int k=0; k<j; k++){
String[] row = {"",""};
data[k] = row;
}
String[] colNames = {"Column A", "Column B"};
JTextField jtf = new JTextField();
JTable tbl = new JTable(data, colNames);
// Create the combo box editor
DefaultCellEditor editor = new DefaultCellEditor(groupList);
// ADDED IN MY ATTEMPT TO HAVE TO COLUMNS WITH COMBOBOXES
DefaultCellEditor editor2 = new DefaultCellEditor(group);
// Assign the editor to the second column
TableColumnModel tcm = tbl.getColumnModel();
tcm.getColumn(0).setCellEditor(editor2);
// ADDED
tcm.getColumn(1).setCellEditor(editor);
// Set column widths
tcm.getColumn(0).setPreferredWidth(200);
tcm.getColumn(1).setPreferredWidth(100);
// Set row heighht
tbl.setRowHeight(20);
tbl.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
tbl.setPreferredScrollableViewportSize(tbl.getPreferredSize());
JFrame f = new JFrame("ComboBoxDemo");
f.getContentPane().add(new JScrollPane(tbl), "Center");
f.pack();
f.addWindowListener(new WindowAdapter() {
public void windowClosing(WindowEvent evt) {
System.exit(0);
}
});
f.setVisible(true);
}
}

Thanks
ben

20 years ago

Java in General

why do I get this exception

Hello All,
When I click on a table name called 00_BPDCON I get the Exception:
SQL Exception: java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server] Line 1: Incorrent Syntax near '00' .
I don't know why this is happerning?

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
public class ComboBoxDemo extends JPanel {
static Connection conn;
DatabaseMetaData DMD;
JComboBox group = new JComboBox();
JComboBox groupList = new JComboBox();
public ComboBoxDemo() {
try {
// Load the database driver
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" ) ;
conn = DriverManager.getConnection( "jdbc :-o dbc:myProject" ) ;
DMD=conn .getMetaData();
ResultSet rs=DMD.getTables(null,null,null,new String[]{"TABLE"});
while(rs.next()) {
group.addItem((String)rs.getString(3));
}
rs.close() ;
} catch (SQLException se ) {
System.out.println( "SQL Exception: " + se ) ;
} catch (Exception e ) {
System.out.println( e ) ;
}
group.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
String tbl = (String)group.getSelectedItem();
System.out.println(tbl.toString());
try {
Statement st=conn.createStatement();
st.execute("SELECT * FROM "+tbl+" WHERE 1=0");
ResultSet rs=st.getResultSet();
ResultSetMetaData md=rs.getMetaData();
groupList.removeAllItems();
for (int i=1;i<=md.getColumnCount();i++) {
groupList.addItem(md.getColumnName(i));
}
st.close() ;
} catch (SQLException se ) {
System.out.println( "SQL Exception: " + se ) ;
} catch (Exception ex ) {
System.out.println( ex ) ;
}
}
});
// Layout the demo
setLayout(new BorderLayout());
add(group, BorderLayout.NORTH);
add(groupList, BorderLayout.SOUTH);
setBorder(BorderFactory.createEmptyBorder(200,20,20,20));
}
public static void main(String s[]) {
JFrame frame = new JFrame("ComboBoxDemo");
frame.addWindowListener(new WindowAdapter() {
public void windowClosing(WindowEvent e) {
try {
conn.close() ;
} catch (Throwable t) {
}
System.exit(0);
}
});
frame.setContentPane(new ComboBoxDemo());
frame.pack(); frame.setVisible(true);
}
}

Rgds
Ben

20 years ago

JDBC and Relational Databases

combining two classes

Hello All,
I have two classes and I want to use one class with the other class, The first class pulls out the table names from a database and puts the names into a comboBox then when the user selectes a table in the first comboBox the second comboBox list all the column names in that table.
The second class is a JTable with every cell holding a comboBox displaying in each comboBox 1,2,3 and 4,5,6.
How I can I get all the comboBoxes in the first row on the JTable to display all the TableNames that are in the comboxes in the 1st class?
Thanks Ben
1ST CLASS:

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
public class ComboBoxDemo extends JPanel {
static Connection conn;
DatabaseMetaData DMD;
JComboBox group = new JComboBox();
JComboBox groupList = new JComboBox();
public ComboBoxDemo() {
try {
// Load the database driver
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" ) ;
conn = DriverManager.getConnection( "jdbc :-o dbc:myProject" ) ;
DMD=conn .getMetaData();
ResultSet rs=DMD.getTables(null,null,null,new String[]{"TABLE"});
while(rs.next()) {
group.addItem((String)rs.getString(3));
}
rs.close() ;
} catch (SQLException se ) {
System.out.println( "SQL Exception: " + se ) ;
} catch (Exception e ) {
System.out.println( e ) ;
}
group.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
String tbl = (String)group.getSelectedItem();
try {
Statement st=conn.createStatement();
st.execute("SELECT * FROM "+tbl+" WHERE 1=0");
ResultSet rs=st.getResultSet();
ResultSetMetaData md=rs.getMetaData();
groupList.removeAllItems();
for (int i=1;i<=md.getColumnCount();i++) {
groupList.addItem(md.getColumnName(i));
}
st.close() ;
} catch (SQLException se ) {
System.out.println( "SQL Exception: " + se ) ;
} catch (Exception ex ) {
System.out.println( ex ) ;
}
}
});
// Layout the demo
setLayout(new BorderLayout());
add(group, BorderLayout.NORTH);
add(groupList, BorderLayout.SOUTH);
setBorder(BorderFactory.createEmptyBorder(200,20,20,20));
}
public static void main(String s[]) {
JFrame frame = new JFrame("ComboBoxDemo");
frame.addWindowListener(new WindowAdapter() {
public void windowClosing(WindowEvent e) {
try {
conn.close() ;
} catch (Throwable t) {
}
System.exit(0);
}
});
frame.setContentPane(new ComboBoxDemo());
frame.pack(); frame.setVisible(true);
}
}

2ND CLASS:

import javax.swing.*;
import javax.swing.table.*;
import java.awt.event.*;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
public class ComboBoxTable {
public static void main(String[] args) {
int j=10;
String[][] data = new String[j][2];
for (int k=0; k<j; k++){
String[] row = {"",""};
data[k] = row;
}
String[] colNames = {"Column A", "Column B"};
JTable tbl = new JTable(data, colNames);
String[] combo1Values = {"One","Two","Three"};
String[] combo2Values = {"Four","Five","Six"};
// Create the combo box editor
JComboBox comboBox = new JComboBox(combo1Values);
comboBox.setEditable(true);
DefaultCellEditor editor = new DefaultCellEditor(comboBox);
// ADDED IN MY ATTEMPT TO HAVE TO COLUMNS WITH COMBOBOXES
JComboBox comboBox2 = new JComboBox(combo2Values);
comboBox2.setEditable(true);
DefaultCellEditor editor2 = new DefaultCellEditor(comboBox2);
// Assign the editor to the second column
TableColumnModel tcm = tbl.getColumnModel();
tcm.getColumn(0).setCellEditor(editor2);
// ADDED
tcm.getColumn(1).setCellEditor(editor);
// Set column widths
tcm.getColumn(0).setPreferredWidth(200);
tcm.getColumn(1).setPreferredWidth(100);
// Set row heighht
tbl.setRowHeight(20);
tbl.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
tbl.setPreferredScrollableViewportSize(tbl.getPreferredSize());
JFrame f = new JFrame("ComboBoxDemo");
f.getContentPane().add(new JScrollPane(tbl), "Center");
f.pack();
f.addWindowListener(new WindowAdapter() {
public void windowClosing(WindowEvent evt) {
System.exit(0);
}
});
f.setVisible(true);
}
}

20 years ago

Java in General

pulling the table names from a Database

Originally posted by Tom Blough:
Have a look at DatabaseMetaData. The method getTables will return the information for your first listbox. The method getColumns will return the information for your second listbox based on the table selected in the first list.
Tom Blough

Hi Tom,
I have been able to get the table names fro the Database with this code

But when I am having trouble to get the Column names from the table the user has selected, could you help me with this part please.
Thanks
ben

20 years ago

JDBC and Relational Databases