Chase Becicka

I am attempting to Build an application using JScrollPane for the first time, However I am unable to acctually create a scroll pane in my GUI, every time I try all i get is a downward indent in the middle of my JPanel so if anyone knows of any components that would be easier to use for displaying account information in nice defined rows please tell me or if you canget my scroll pane working that would be awesome

/****************************************************************/ /* controlGUI */ /* */ /****************************************************************/ import java.awt.*; import java.awt.event.*; import javax.swing.*; /** * Summary description for controlGUI * */ public class controlGUI extends JFrame { // Label declaration private JLabel jLabel1; private JLabel jLabel2; private JLabel jLabel3; private JLabel jLabel4; private JLabel jLabel5; private JLabel jLabel6; // Button declaration private JButton custFirstB; private JButton custNextB; private JButton custPrevB; private JButton custLastB; private JButton accCreateB; private JButton accAddB; private JButton accCloseB; private JButton searchB; private JButton programExitB; // Textfield declaration private JTextField jTextField1; private JTextField jTextField2; private JTextField jTextField3; private JTextField jTextField4; private JTextField jTextField5; private JTextField jTextField6; private JPanel contentPane; // End of variables declaration public controlGUI() { super(); initializeComponent(); // // TODO: Add any constructor code after initializeComponent call // this.setVisible(true); } /** * This method is called from within the constructor to initialize the form. * WARNING: Do NOT modify this code. The content of this method is always regenerated * by the Windows Form Designer. Otherwise, retrieving design might not work properly. * Tip: If you must revise this method, please backup this GUI file for JFrameBuilder * to retrieve your design properly in future, before revising this method. */ private void initializeComponent() { jLabel1 = new JLabel(); jLabel2 = new JLabel(); jLabel3 = new JLabel(); jLabel4 = new JLabel(); jLabel5 = new JLabel(); jLabel6 = new JLabel(); // JButtons are being instantiated custFirstB = new JButton(); custNextB = new JButton(); custPrevB = new JButton(); custLastB = new JButton(); accCreateB = new JButton(); accCloseB = new JButton(); accAddB = new JButton(); searchB = new JButton(); programExitB = new JButton(); // JTextFields are being instantiated jTextField1 = new JTextField(); jTextField2 = new JTextField(); jTextField3 = new JTextField(); jTextField4 = new JTextField(); jTextField5 = new JTextField(); jTextField6 = new JTextField(); contentPane = (JPanel)this.getContentPane(); jLabel1.setText("Customer Number"); jLabel2.setText("First Name"); jLabel3.setText("Last Name"); jLabel4.setText("Address"); jLabel5.setText("Phone Number"); jLabel6.setText("Work Number"); jTextField1.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { jTextField1_actionPerformed(e); } }); jTextField2.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { jTextField2_actionPerformed(e); } }); jTextField3.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { jTextField3_actionPerformed(e); } }); jTextField4.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { jTextField4_actionPerformed(e); } }); jTextField5.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { jTextField5_actionPerformed(e); } }); // // jTextField6 // //jTextField6.setText("jTextField6"); jTextField6.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { jTextField6_actionPerformed(e); } }); // // contentPane // contentPane.setLayout(null); addComponent(contentPane, jLabel1, 25,15,90,22); addComponent(contentPane, jLabel2, 25,40,90,22); addComponent(contentPane, jLabel3, 25,65,90,22); addComponent(contentPane, jLabel4, 25,90,90,22); addComponent(contentPane, jLabel5, 25,115, 90, 22); addComponent(contentPane, jLabel6, 25,140, 90, 22); addComponent(contentPane, jTextField1, 130,15,100,22); addComponent(contentPane, jTextField2, 130,40,100,22); addComponent(contentPane, jTextField3, 130,65,100,22); addComponent(contentPane, jTextField4, 130,90,100,22); addComponent(contentPane, jTextField5, 130,115,100,22); addComponent(contentPane, jTextField6, 130,140,100,22); addComponent(contentPane, custFirstB, 25, 180, 100, 25); addComponent(contentPane, custLastB, 25, 210, 100, 25); addComponent(contentPane, custNextB, 130, 180, 100, 25); addComponent(contentPane, custPrevB, 130, 210, 100, 25); addComponent(contentPane, accCreateB, 280, 180, 100, 25); addComponent(contentPane, accAddB, 385, 180, 100, 25); addComponent(contentPane, accCloseB, 280, 210, 100 ,25); addComponent(contentPane, programExitB, 385, 210, 100, 25); // // controlGUI // this.setTitle("Welcome"); this.setLocation(new Point(0, 0)); this.setSize(new Dimension(510, 300)); } /** Add Component Without a Layout Manager (Absolute Positioning) */ private void addComponent(Container container,Component c,int x,int y,int width,int height) { c.setBounds(x,y,width,height); container.add(c); } // // TODO: Add any appropriate code in the following Event Handling Methods // private void jTextField1_actionPerformed(ActionEvent e) { System.out.println("\njTextField1_actionPerformed(ActionEvent e) called."); // TODO: Add any handling code here } private void jTextField2_actionPerformed(ActionEvent e) { System.out.println("\njTextField2_actionPerformed(ActionEvent e) called."); // TODO: Add any handling code here } private void jTextField3_actionPerformed(ActionEvent e) { System.out.println("\njTextField3_actionPerformed(ActionEvent e) called."); // TODO: Add any handling code here } private void jTextField4_actionPerformed(ActionEvent e) { System.out.println("\njTextField4_actionPerformed(ActionEvent e) called."); // TODO: Add any handling code here } private void jTextField5_actionPerformed(ActionEvent e) { System.out.println("\njTextField5_actionPerformed(ActionEvent e) called."); // TODO: Add any handling code here } private void jTextField6_actionPerformed(ActionEvent e) { System.out.println("\njTextField6_actionPerformed(ActionEvent e) called."); // TODO: Add any handling code here } // // TODO: Add any method code to meet your needs in the following area // //============================= Testing ================================// //= =// //= The following main method is just for testing this class you built.=// //= After testing,you may simply delete it. =// //======================================================================// public static void main(String[] args) { JFrame.setDefaultLookAndFeelDecorated(true); JDialog.setDefaultLookAndFeelDecorated(true); try { UIManager.setLookAndFeel("com.sun.java.swing.plaf.windows.WindowsLookAndFeel"); } catch (Exception ex) { System.out.println("Failed loading L&F: "); System.out.println(ex); } new controlGUI(); } //= End of Testing = }

Does anyone know how I can make my java files an executable source file outta my java code I just want to be able to double click on the file and let it run

I'm not sure what you mean by having two object statments, but how would that work and if I were pulling info outta the database how would that work for the code below I just pasted below assuming that lets say 1/2 of the items I was trying to set were for a different table

Game previousGame = new Game(gamefields.getString(1), gamefields.getString(2), gamefields.getString(3), gamefields.getString(4), gamefields.getString(5), gamefields.getString(6), gamefields.getString(7), gamefields.getDouble(8));

I have a problem with setting up my result set and when I query the database, I have two tables and they are linked by a common column name so I have to designate which one I call to the but when I set my second query to the second table I get a query already open error, because I queryed the first tables so how do I combine the two queries into one but avoid the problem of the Column with the same name, (The columns needs to be the same so changing them isn't an option)

import java.sql.*; import javax.swing.JOptionPane; public class inventDB { private static Connection connection; private static Statement scrollStatement; private static ResultSet CustTable; private static ResultSet AccountTable; public static void connect() throws ClassNotFoundException, SQLException { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String url = "jdbc :-o dbc:JavaBank"; String user = "sa"; String password = ""; connection = DriverManager.getConnection(url, user, password); } public static void open() throws SQLException { scrollStatement = connection.createStatement (ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_UPDATABLE); String query = "SELECT CustNum, CustNameF, CustNameL" + "FROM CustTable ORDER BY CustNum ASC"; String query = "SELECT Cust, AccountNum, AccountBalance,AccountType" + "FROM AccountTable ORDER BY CustNum ASC"; CustTable = scrollStatement.executeQuery(query); AccountTable = scrollStatement.executeQuery(query); } }

I am having a problem being able to get my botton Jbuttons to allign properly, they are just lined up in a row at the bottom of my JFrame but I want it to appear more like

NextCust NextAcct Search
Add Update Delete Exit


import java.awt.*; import java.awt.event.*; import javax.swing.*; import java.text.*; public class inventFrame extends JFrame { public inventFrame() { setTitle("Teller Program"); Toolkit tk = Toolkit.getDefaultToolkit(); Dimension d = tk.getScreenSize(); int height = 500; int width = 550; setBounds((d.width-width)/2, (d.height-height)/2, width, height);// setResizable(false); addWindowListener(new WindowAdapter() { public void windowClosing(WindowEvent e) { System.exit(0); }}); Container contentPane = getContentPane(); JPanel panel = new BankingGUIPanel(); contentPane.add(panel); setVisible(true); } public static void main(String[] args) { new inventFrame(); } } class BankingGUIPanel extends JPanel implements ActionListener { private JTextField custNumTF, custNameFTF, custNameMITF, custNameLTF, phoneHomeTF; private JTextField AccountNumTF, AccountTypeTF, AccountBalanceTF, phoneWorkTF, searchTF; private JLabel custNumL, custNameFL, custNameMIL, custNameLL, phoneHomeL; private JLabel AccountNumL, AccountTypeL, AccountBalanceL, phoneWorkL, searchL; private JButton exitButton, nextCustButton, nextAccountButton, searchButton; private JButton updateButton, addButton, deleteButton; public BankingGUIPanel() { custNumL = new JLabel("Customer Number: "); custNameFL = new JLabel("First Name: "); custNameMIL = new JLabel("Middle Inital: "); custNameLL = new JLabel("Last Name: "); AccountNumL = new JLabel("Account Number: "); AccountTypeL = new JLabel("Account Type: "); AccountBalanceL = new JLabel("Account Balance: "); phoneHomeL = new JLabel("Home Phone #: "); phoneWorkL = new JLabel("Work Phone #: "); searchL = new JLabel("Search By Cust #"); custNumTF = new JTextField(10); custNameFTF = new JTextField(10); custNameMITF = new JTextField(10); custNameLTF = new JTextField(10); AccountNumTF = new JTextField(10); AccountTypeTF = new JTextField(10); AccountBalanceTF = new JTextField(10); phoneHomeTF = new JTextField(10); phoneWorkTF = new JTextField(10); searchTF = new JTextField(10); JPanel displayPanel = new JPanel(); displayPanel.setLayout(new GridBagLayout()); GridBagConstraints gbc = new GridBagConstraints(); gbc.insets = new Insets(5,2,5,2); // spacing around components gbc.weightx = 1.0; // allows horiz dispersion //an option to allow components to fill the vertical space gbc.weighty = 1.0; // allows vertical dispersion addComponents(custNumL, custNumTF, displayPanel, gbc); addComponents(custNameFL, custNameFTF, displayPanel, gbc); addComponents(custNameMIL, custNameMITF, displayPanel, gbc); addComponents(custNameLL, custNameLTF, displayPanel, gbc); addComponents(AccountNumL, AccountNumTF, displayPanel, gbc); addComponents(AccountTypeL, AccountTypeTF, displayPanel, gbc); addComponents(AccountBalanceL, AccountBalanceTF, displayPanel ,gbc); addComponents(phoneHomeL, phoneHomeTF, displayPanel, gbc); addComponents(phoneWorkL, phoneWorkTF, displayPanel, gbc); addComponents(searchL, searchTF, displayPanel, gbc); // or instead, let components remain clumped together and then // push everything up by setting weighty to non�zero // and adding an empty component, like this gbc.weighty = 1.0; displayPanel.add(new JLabel(), gbc); JPanel buttonPanel = new JPanel(); buttonPanel.setLayout(new FlowLayout(FlowLayout.LEFT)); exitButton = new JButton("Exit"); nextCustButton = new JButton("Next Customer"); nextAccountButton = new JButton("Next Account"); searchButton = new JButton("Search"); addButton = new JButton("Add"); updateButton = new JButton("Update"); deleteButton = new JButton("Delete"); buttonPanel.add(nextCustButton); buttonPanel.add(nextAccountButton); buttonPanel.add(searchButton); buttonPanel.add(addButton); buttonPanel.add(updateButton); buttonPanel.add(deleteButton); buttonPanel.add(exitButton); exitButton.addActionListener(this); nextCustButton.addActionListener(this); nextAccountButton.addActionListener(this); setLayout(new BorderLayout()); add(displayPanel, BorderLayout.WEST); add(buttonPanel, BorderLayout.SOUTH); //add(searchPanel, BorderLayout.SOUTH); } private void addComponents(JLabel label, JTextField tf, JPanel panel, GridBagConstraints gbc) { gbc.anchor = gbc.EAST; // align right gbc.gridwidth = gbc.RELATIVE; // next to last component in row panel.add(label, gbc); gbc.anchor = gbc.WEST; // align left gbc.gridwidth = gbc.REMAINDER; // last component in row panel.add(tf, gbc); } public void actionPerformed(ActionEvent e) { Object source = e.getSource(); if (source == exitButton) System.exit(0); /*else if (source == nextCustButton) currentCust = inventDB.moveNext(); performGameDisplay(); enableButtons(true); **/ } }

I can't seem to get my searchPanel to show up on my JFrame and I don't know why, its not conflicting with any other JFrames and also I wished to know that lets say I added a second Panel to the south region of the boarder layout how would I get that layout to display nicly with the other???
import java.awt.*; import java.awt.event.*; import javax.swing.*; import java.text.*; public class inventFrame extends JFrame { public inventFrame() { setTitle("Teller Program"); Toolkit tk = Toolkit.getDefaultToolkit(); Dimension d = tk.getScreenSize(); int height = 500; int width = 550; setBounds((d.width-width)/2, (d.height-height)/2, width, height);// setResizable(false); addWindowListener(new WindowAdapter() { public void windowClosing(WindowEvent e) { System.exit(0); }}); Container contentPane = getContentPane(); JPanel panel = new BankingGUIPanel(); contentPane.add(panel); setVisible(true); } public static void main(String[] args) { new inventFrame(); } } class BankingGUIPanel extends JPanel implements ActionListener { private JTextField custNumTF, custNameFTF, custNameMITF, custNameLTF, phoneHomeTF; private JTextField AccountNumTF, AccountTypeTF, AccountBalanceTF, phoneWorkTF, searchTF; private JLabel custNumL, custNameFL, custNameMIL, custNameLL, phoneHomeL; private JLabel AccountNumL, AccountTypeL, AccountBalanceL, phoneWorkL, searchL; private JButton exitButton, nextCustButton, nextAccountButton, searchButton; public BankingGUIPanel() { custNumL = new JLabel("Customer Number: "); custNameFL = new JLabel("First Name: "); custNameMIL = new JLabel("Middle Inital: "); custNameLL = new JLabel("Last Name: "); AccountNumL = new JLabel("Account Number: "); AccountTypeL = new JLabel("Account Type: "); AccountBalanceL = new JLabel("Account Balance: "); phoneHomeL = new JLabel("Home Phone #: "); phoneWorkL = new JLabel("Work Phone #: "); custNumTF = new JTextField(10); custNameFTF = new JTextField(10); custNameMITF = new JTextField(10); custNameLTF = new JTextField(10); AccountNumTF = new JTextField(10); AccountTypeTF = new JTextField(10); AccountBalanceTF = new JTextField(10); phoneHomeTF = new JTextField(10); phoneWorkTF = new JTextField(10); JPanel displayPanel = new JPanel(); displayPanel.setLayout(new GridBagLayout()); GridBagConstraints gbc = new GridBagConstraints(); gbc.insets = new Insets(5,2,5,2); // spacing around components gbc.weightx = 1.0; // allows horiz dispersion // an option to allow components to fill the vertical space gbc.weighty = 1.0; // allows vertical dispersion addComponents(custNumL, custNumTF, displayPanel, gbc); addComponents(custNameFL, custNameFTF, displayPanel, gbc); addComponents(custNameMIL, custNameMITF, displayPanel, gbc); addComponents(custNameLL, custNameLTF, displayPanel, gbc); addComponents(AccountNumL, AccountNumTF, displayPanel, gbc); addComponents(AccountTypeL, AccountTypeTF, displayPanel, gbc); addComponents(AccountBalanceL, AccountBalanceTF, displayPanel ,gbc); addComponents(phoneHomeL, phoneHomeTF, displayPanel, gbc); addComponents(phoneWorkL, phoneWorkTF, displayPanel, gbc); // or instead, let components remain clumped together and then // push everything up by setting weighty to non�zero // and adding an empty component, like this gbc.weighty = 1.0; displayPanel.add(new JLabel(), gbc); JPanel buttonPanel = new JPanel(); buttonPanel.setLayout(new FlowLayout(FlowLayout.LEFT)); exitButton = new JButton("Exit"); nextCustButton = new JButton("Next Customer"); nextAccountButton = new JButton("Next Account"); buttonPanel.add(nextCustButton); buttonPanel.add(nextAccountButton); buttonPanel.add(exitButton); exitButton.addActionListener(this); JPanel searchPanel = new JPanel(); searchPanel.setLayout(new FlowLayout(FlowLayout.LEFT)); searchL = new JLabel("Search By Cust #"); searchTF = new JTextField(10); setLayout(new BorderLayout()); add(displayPanel, BorderLayout.WEST); add(buttonPanel, BorderLayout.SOUTH); add(searchPanel, BorderLayout.EAST); } private void addComponents(JLabel label, JTextField tf, JPanel panel, GridBagConstraints gbc) { gbc.anchor = gbc.EAST; // align right gbc.gridwidth = gbc.RELATIVE; // next to last component in row panel.add(label, gbc); gbc.anchor = gbc.WEST; // align left gbc.gridwidth = gbc.REMAINDER; // last component in row panel.add(tf, gbc); } public void actionPerformed(ActionEvent e) { Object source = e.getSource(); if (source == exitButton) System.exit(0); } }
[ December 13, 2004: Message edited by: Chase Becicka ]

I am attempting to Transform an old Inventory Program into a banking Program as to save time writing a new program, its made up of three files a GUI, a controller (db and GUI middle man) and a db connection. I have almost everything working except a few errors in my GUI on my performGameDisplay method,I don't get why its giving me these errors because the variables that are producing the syntax problem are correctly declared in the other two files ive rewrote them a few times as to make sure I didnt have incompatable datatypes or something, so please if anyone knows why my variables arn't getting along with the compiler or if you know of any good refernces such as online tutorials I could refer to that would be a great help Heres my Code

import java.awt.*; //imports the Abstract Windows Toolkit Package import java.awt.event.*; //imports the Abstract Windows Toolkit Package Event Package import javax.swing.*; //imports the Swing GUI Package import javax.swing.event.*; //imports Swing event Package import java.text.*; //imports the text Package that assists in reading database information import java.sql.*; //Imports the SQL Package which provides database manipulation and interfaces public class inventFrame extends JFrame{ public inventFrame(){ setTitle("Teller Program"); //Set Title name in the top display bar of the code Toolkit tk = Toolkit.getDefaultToolkit();//Gets toolkit Dimension d = tk.getScreenSize();//Sets Boundiers for Frame size int width = 400, height = 375; setBounds((d.width - width)/2, (d.height - height)/2, width, height); setResizable(false); addWindowListener(new WindowAdapter(){ public void windowClosing(WindowEvent e) {//Windows event for our exit button //closes inventDB connection System.exit(0); //Command allowing the program to close } }); Container contentPane = getContentPane(); BankPanel panel = new BankPanel(); contentPane.add(panel); } public static void main(String[] args){ JFrame frame = new inventFrame(); frame.show(); } } class BankPanel extends JPanel implements ActionListener, DocumentListener, KeyListener { private JButton addButton, updateButton, deleteButton, exitButton, firstButton, prevButton, nextButton, lastButton, searchButton; private JLabel CustNumL, CustNameFL, CustMIL, CustNameLL, phoneHomeL, phoneWorkL, AccountNumL, AccountTypeL, AccountBalanceL, searchL; private JTextField CustNumTF, CustNameFTF, CustMITF, CustNameLTF, phoneHomeTF, phoneWorkTF, AccountNumTF, AccountTypeTF, AccountBalanceTF, searchTF; public static boolean addFlag = false; //public static NumberFormat currency = NumberFormat.getCurrencyInstance(); Game currentGame = null; public BankPanel() { CustNumL = new JLabel("Customer Number: "); CustNumTF = new JTextField("", 9); CustNameFL = new JLabel("Name, First: "); CustNameFTF = new JTextField("", 26); CustMIL = new JLabel("Middle Initial: "); CustMITF = new JTextField("", 26); CustNameLL = new JLabel("Name, Last: "); CustNameLTF = new JTextField("", 9); phoneHomeL = new JLabel("Home Phone Number: "); phoneHomeTF = new JTextField("", 11); phoneWorkL = new JLabel("Work Phone Number: "); phoneWorkTF = new JTextField("", 11); AccountNumL = new JLabel("Account Number: "); AccountNumTF = new JTextField("", 9); AccountTypeL = new JLabel("Account Type: "); AccountTypeTF = new JTextField("", 9); AccountBalanceL = new JLabel("Account Balance: "); AccountBalanceTF = new JTextField("", 15); //searchL = new JLabel("Search by Cust Num"); //searchTF = new JTextField("", 10); JPanel updatePanel = new JPanel(); addButton = new JButton("Add"); updateButton = new JButton("Update"); deleteButton = new JButton("Delete"); exitButton = new JButton("Exit"); updatePanel.add(addButton); updatePanel.add(updateButton); updatePanel.add(deleteButton); updatePanel.add(exitButton); JPanel navigationPanel = new JPanel(); firstButton = new JButton("First"); prevButton = new JButton("Prev"); nextButton = new JButton("Next"); lastButton = new JButton("Last"); navigationPanel.add(firstButton); navigationPanel.add(prevButton); navigationPanel.add(nextButton); navigationPanel.add(lastButton); JPanel searchPanel = new JPanel(); searchButton = new JButton("Search"); searchL = new JLabel("Search by SKU"); searchTF = new JTextField("", 8); searchPanel.add(searchL); searchPanel.add(searchTF); searchPanel.add(searchButton); addButton.addActionListener(this); updateButton.addActionListener(this); deleteButton.addActionListener(this); exitButton.addActionListener(this); firstButton.addActionListener(this); prevButton.addActionListener(this); nextButton.addActionListener(this); lastButton.addActionListener(this); searchButton.addActionListener(this); CustNumTF.addKeyListener(this); CustNameFTF.addKeyListener(this); CustMITF.addKeyListener(this); CustNameLTF.addKeyListener(this); phoneHomeTF.addKeyListener(this); phoneWorkTF.addKeyListener(this); AccountNumTF.addKeyListener(this); AccountTypeTF.addKeyListener(this); AccountBalanceTF.addKeyListener(this); searchTF.addKeyListener(this); CustNumTF.getDocument().addDocumentListener(this); CustNameFTF.getDocument().addDocumentListener(this); CustMITF.getDocument().addDocumentListener(this); CustNameLTF.getDocument().addDocumentListener(this); phoneHomeTF.getDocument().addDocumentListener(this); phoneWorkTF.getDocument().addDocumentListener(this); AccountNumTF.getDocument().addDocumentListener(this); AccountTypeTF.getDocument().addDocumentListener(this); AccountBalanceTF.getDocument().addDocumentListener(this); searchTF.getDocument().addDocumentListener(this); setLayout(new GridBagLayout()); GridBagConstraints c = new GridBagConstraints(); c.weightx = 100; c.weighty = 100; c.ipadx = 5; c.anchor = GridBagConstraints.EAST; c = getConstraints(c, 1, 1, 1, 1); add(CustNumL, c); c = getConstraints(c, 1, 2, 1, 1); add(CustNameFL, c); c = getConstraints(c, 1, 3, 1, 1); add(CustMIL, c); c = getConstraints(c, 1, 4, 1, 1); add(CustNameLL, c); c = getConstraints(c, 1, 5, 1, 1); add(phoneHomeL, c); c = getConstraints(c, 1, 8, 1, 1); add(phoneWorkL, c); c = getConstraints(c, 1, 9, 1, 1); add(AccountNumL, c); c = getConstraints(c, 1, 6, 1, 1); add(AccountTypeL, c); c = getConstraints(c, 1, 7, 1, 1); add(AccountBalanceL, c); c.anchor = GridBagConstraints.WEST;//Positions labels onto the gui created box //anchoring it to the left side c = getConstraints(c, 2, 1, 3, 1); //Positions named Field on the Panel then sets it add(CustNumTF, c); c = getConstraints(c, 2, 2, 3, 1); add(CustNameFTF, c); c = getConstraints(c, 2, 3, 3, 1); add(CustMITF, c); c = getConstraints(c, 2, 4, 3, 1); add(CustNameLTF, c); c = getConstraints(c, 2, 5, 3, 1); add(phoneHomeTF, c); c = getConstraints(c, 2, 8, 3, 1); add(phoneWorkTF, c); c = getConstraints(c, 2, 9, 3, 1); add(AccountNumTF, c); c = getConstraints(c, 2, 6, 3, 1); add(AccountTypeTF, c); c = getConstraints(c, 2, 7, 3, 1); add(AccountBalanceTF, c); c.anchor = GridBagConstraints.SOUTH; c = getConstraints(c, 1, 11, 4, 1); add(updatePanel, c); c = getConstraints(c, 1, 12, 4, 1); add(navigationPanel, c); c = getConstraints(c, 1, 13, 4, 1); add(searchPanel, c); try{ inventDB.connect(); //connects to inventDB inventDB.open(); //Opens connection currentGame = inventDB.moveFirst(); //Displays first Row of Result Set on database } catch (ClassNotFoundException e){ JOptionPane.showMessageDialog(null, e.getMessage()); System.exit(1); } catch (SQLException e){ JOptionPane.showMessageDialog(null, e.getMessage()); } performGameDisplay(); enableButtons(true); } public void paintComponent(Graphics g){ super.paintComponent(g); ImageIcon test = new ImageIcon("image.gif"); Image pic = test.getImage(); g.drawImage(pic, 225, 7, this); } private GridBagConstraints getConstraints(GridBagConstraints c, int x, int y, int width, int height){ c.gridx = x; c.gridy = y; c.gridwidth = width; c.gridheight = height; return c; } /* private void performGameDisplay(){ CustNumTF.setText(currentGame.getCustNum()); CustNameFTF.setText(currentGame.getCustNameF()); CustMITF.setText(currentGame.getCustMI()); CustNameLTF.setText(currentGame.getCustNameL()); phoneHomeTF.setText(currentGame.getphoneHome()); phoneWorkTF.setText(currentGame.getphoneWork()); AccountNumTF.setText(currentGame.getAccountNum()); PriceField.setText(currency.format(currentGame.getPrice())); **/ private void performGameDisplay() { CustNumTF.setText(currentGame.getCustNum()); CustNameFTF.setText(currentGame.getCustNameF()); CustMITF.setText(currentGame.getCustMI()); CustNameLTF.setText(currentGame.getCustNameL()); phoneHomeTF.setText(currentGame.getphoneHome()); phoneWorkTF.setText(currentGame.getphoneWork()); AccountNumTF.setText(currentGame.getAccountNum()); AccountTypeTF.setText(currentGame.getAccountType()); AccountBalanceTF.setText(currentGame.getAccountBalance()); } private void enableButtons(boolean flag1){ boolean flag2 = false; if (flag1 == false) flag2 = true; updateButton.setEnabled(flag2); addButton.setEnabled(flag1); deleteButton.setEnabled(flag1); firstButton.setEnabled(flag1); nextButton.setEnabled(flag1); prevButton.setEnabled(flag1); lastButton.setEnabled(flag1); searchButton.setEnabled(flag2); //Sets Flagging to Buttons using boolean to call in true //and false variables of when they are accessable } private double parsecurrency(String currencyString){ if (currencyString.charAt(0) == '$') currencyString = currencyString.substring(1); //Parses Currency into String Value so it can be read return Double.parseDouble(currencyString); //Returnes parsed value of string } public void actionPerformed(ActionEvent e){ try{ Object source = e.getSource(); if (source == exitButton){ inventDB.close(); System.exit(0); //If exit Button is accessed it closes system } else if (source == firstButton){ currentGame = inventDB.moveFirst(); performGameDisplay(); enableButtons(true); //if the enabled button is true it moves displayed result //set to first row of the database } else if (source == prevButton){ currentGame = inventDB.movePrevious(); performGameDisplay(); enableButtons(true); //if the enable button is true it moves displayed result //to the previous row of the database } else if (source == nextButton){ currentGame = inventDB.moveNext(); performGameDisplay(); enableButtons(true); //if the enable button is true it moves displayed result //to the next row of the database } else if (source == lastButton){ currentGame = inventDB.moveLast(); performGameDisplay(); enableButtons(true); //if the enable button is true it moves displayed result to the last row of the database } else if (source == searchButton){ currentGame = inventDB.searchRecord(searchTF.getText()); performGameDisplay(); enableButtons(true); } else if (source == addButton){ CustNumTF.requestFocus(); enableButtons(false); CustNumTF.setText(""); CustNameFTF.setText(""); CustMITF.setText(""); CustNameLTF.setText(""); phoneHomeTF.setText(""); phoneWorkTF.setText(""); AccountNumTF.setText(""); AccountTypeTF.setText(""); AccountBalanceTF.setText(""); addFlag = true; //Takes data in fields and sets Text into a new row of the database } else if (source == updateButton){ //double Price = parseCurrency(PriceField.getText()); Game game = new Game(CustNumTF.getText(), CustNameFTF.getText(), CustMITF.getText(), CustNameLTF.getText(), phoneHomeTF.getText(), phoneHomeTF.getText(), AccountNumTF.getText(), AccountTypeTF.getText(), AccountBalanceTF.getText()); //Takes data in listed fields and replaces selected row in the database with list text if (addFlag == false){ inventDB.updateRecord(game); currentGame = game; //Used to activate Buttons } if (addFlag == true){ inventDB.addRecord(game); currentGame = inventDB.moveFirst(); addFlag = false; } currentGame = game; performGameDisplay(); enableButtons(true); } else if(source == deleteButton){ inventDB.deleteRecord(currentGame.getCustNum()); firstButton.requestFocus(); firstButton.doClick(); performGameDisplay(); enableButtons(true); } } catch (NumberFormatException nfe){ JOptionPane.showMessageDialog(this, nfe.getMessage()); } catch (SQLException sqle){ JOptionPane.showMessageDialog(this, sqle.getMessage()); } } public void keyPressed(KeyEvent e){ int keyCode = e.getKeyCode(); if (keyCode == KeyEvent.VK_ESCAPE){ performGameDisplay(); enableButtons(true); CustNum.requestFocus(); //Accessing Key Listeners } } public void keyReleased(KeyEvent e){ } public void keyTyped(KeyEvent e){ } public void insertUpdate(DocumentEvent e){ enableButtons(false); } public void removeUpdate(DocumentEvent e){ enableButtons(false); } public void changedUpdate(DocumentEvent e){ } }

Okay I can see my JFrame now but I can't see my panels I created unless I resize my JFrame but I don't want my JFrame to be resizeable in the end. Should I just switch to a easier Layout Manager or is there an easy fix

what I am trying to get this to do is go gown vertically like this

Label TF
Label TF
Label TF

ect.


Heres the cod eupdated again
import java.awt.*; import java.awt.event.*; import javax.swing.*; import java.text.*; public class inventFrame extends JFrame { public void BankingGUIFrame() { setTitle("Teller Program"); Toolkit tk = Toolkit.getDefaultToolkit(); Dimension d = tk.getScreenSize(); int height = 500; int width = 450; setBounds((d.width-width)/2, (d.height-height)/2, width, height); setResizable(false); addWindowListener(new WindowAdapter(){ public void windowClosing(WindowEvent e){ System.exit(0); } }); Container contentPane = getContentPane(); JPanel panel = new BankingGUIPanel(); contentPane.add(panel); } public static void main(String[] args) { inventFrame frame = new inventFrame(); frame.show(); frame.BankingGUIFrame(); } } class BankingGUIPanel extends JPanel implements ActionListener { private JTextField custNumTF, custNameFTF, custNameMITF, custNameLTF; private JLabel custNumL, custNameFL, custNameMIL, custNameLL; private JButton exitButton; public BankingGUIPanel() { JPanel displayPanel = new JPanel(); displayPanel.setLayout(new FlowLayout(FlowLayout.LEFT)); custNumL = new JLabel("Customer Number: "); custNameFL = new JLabel("First Name: "); custNameMIL = new JLabel("Middle Inital: "); custNameLL = new JLabel("Last Name: "); custNumTF = new JTextField(10); custNameFTF = new JTextField(10); custNameMITF = new JTextField(10); custNameLTF = new JTextField(10); displayPanel.add(custNumL); displayPanel.add(custNumTF); displayPanel.add(custNameFL); displayPanel.add(custNameFTF); displayPanel.add(custNameMIL); displayPanel.add(custNameMITF); displayPanel.add(custNameLL); displayPanel.add(custNameLTF); JPanel buttonPanel = new JPanel(); buttonPanel.setLayout(new FlowLayout(FlowLayout.RIGHT)); exitButton = new JButton("Exit"); buttonPanel.add(exitButton); exitButton.addActionListener(this); setLayout(new BorderLayout()); add(displayPanel, BorderLayout.CENTER); add(buttonPanel, BorderLayout.SOUTH); } public void actionPerformed(ActionEvent e) { Object source = e.getSource(); if (source == exitButton) System.exit(0); } }

I have been trying to figure out why when I execute this code all I get is a little bar at the top of the screen without any of my Labels or Buttons please help with a debug



import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.text.*;

public class inventFrame extends JFrame
{
public void BankingGUIFrame()
{
setTitle("Teller Program");
Toolkit tk = Toolkit.getDefaultToolkit();
Dimension d = tk.getScreenSize();
int height = 200;
int width = 267;
setBounds((d.width-width)/2, (d.height-height)/2, width, height);
setResizable(true);
addWindowListener(new WindowAdapter(){
public void windowClosing(WindowEvent e){
System.exit(0);
}
});
Container contentPane = getContentPane();
JPanel panel = new BankingGUIPanel();
contentPane.add(panel);
}


public static void main(String[] args)
{
JFrame frame = new inventFrame();
frame.show();
}
}


class BankingGUIPanel extends JPanel implements ActionListener
{
private JTextField custNumTF, custNameFTF, custNameMITF, custNameLTF;
private JLabel custNumL, custNameFL, custNameMIL, custNameLL;
private JButton exitButton;


public BankingGUIPanel()
{
JPanel displayPanel = new JPanel();
displayPanel.setLayout(new FlowLayout(FlowLayout.RIGHT));

custNumL = new JLabel("Customer Number: ");
custNameFL = new JLabel("First Name: ");
custNameMIL = new JLabel("Middle Inital: ");
custNameLL = new JLabel("Last Name: ");

custNumTF = new JTextField(10);
custNameFTF = new JTextField(10);
custNameMITF = new JTextField(10);
custNameLTF = new JTextField(10);

displayPanel.add(custNumL);
displayPanel.add(custNumTF);
displayPanel.add(custNameFL);
displayPanel.add(custNameFTF);
displayPanel.add(custNameMIL);
displayPanel.add(custNameMITF);
displayPanel.add(custNameLL);
displayPanel.add(custNameLTF);

JPanel buttonPanel = new JPanel();
buttonPanel.setLayout(new FlowLayout(FlowLayout.RIGHT));
exitButton = new JButton("Exit");
buttonPanel.add(exitButton);

exitButton.addActionListener(this);

setLayout(new BorderLayout());
add(displayPanel, BorderLayout.CENTER);
add(buttonPanel, BorderLayout.SOUTH);
}
public void actionPerformed(ActionEvent e)
{
Object source = e.getSource();

if (source == exitButton)
System.exit(0);

}



}

I am using SQL Server and I have two tables that I joined with one common named column which is the primary key value on both tables

the code i am using to connect is

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc dbc:javaBank";
String user = "sa";
String password = "";
connection = DriverManager.getConnection(url, user, password);

I have three files going my GUI file my connectDB file which is where I got the code above and I am trying to write a file that gets the info from the connectDB file and gives it to the methods in my inventGUI file put as I said I don't know how to get data from the columns once I connect

I'm using a database for the first time and am trying to extract the columns I created I can make the connection but I can't figure out how to get the columns I have out and then get them assigned to appropriate variables any code examples or weblinks would be much appriciated

Well my data tables do have one common column, its set up like this,

my custNum is a column on both tables I have and the second table cannot exsist without a mathcing value in the first table so the CustNum links the two tables togeather and is the primary key for both tables

I just have a quick question with connecting to multiple tables, This is the first time I have attempted to code with a database cotaining multiple tables, is there anything special I need to do access the second table within my database or can I still just throw out the column name to connect to the resultset in that table

I'm trying to run a batch file from a method in java? so would the Runtime.exec().work???

I just have a question with know wheather or not you can get your java program to run a batch file that will hook up an Access or SQL server database in your program

For Example

run file setup.bat

So basically I want the ODBC connection to be established through the running of a method on the program so if a user is taking my app he can just click it open on for the first time on his comp, then the connection is just their assuming hes running Access or SQL Server

Any help would be greatly appriciated and if you need me to restate the problem please ask