How do I access my field data?

[Amy Phillips]

Hi,
This is almost a JDBC problem but think it is more to do with my GUI as I have tested my database connection and everything is working fine. Anyway I am trying to insert data from my form into the database but don't know how to fetch the data from the form into the query. Can anyone help?
the class with the form is

 import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import javax.swing.*;
import javax.swing.event.*;
public class RequirementTab extends JPanel
{
    private Connection connect;
    public RequirementTab(Connection c)  
    { 
        CreateOverview1 t1 = new CreateOverview1();
setLayout(new BoxLayout(this, BoxLayout.Y_AXIS));
connect = c;

        ActionListener addListener = new ActionListener()
        {
            public void actionPerformed(ActionEvent event)
            {
  Requirement t = new Requirement();
t.createRequirement(connect);
        t.show(); 
            }
        };

JPanel buttonPanel = new JPanel();
buttonPanel.setLayout(new BoxLayout(buttonPanel, BoxLayout.X_AXIS));
        JButton addButton = new JButton("Add");    
        JButton editButton = new JButton("Edit"); 
JButton deleteButton = new JButton("Delete"); 
JButton searchButton = new JButton("Search"); 
addButton.addActionListener(addListener);
editButton.addActionListener(editListener);
deleteButton.addActionListener(deleteListener);
searchButton.addActionListener(addListener);
buttonPanel.add(addButton);
buttonPanel.add(editButton);
buttonPanel.add(deleteButton);
buttonPanel.add(searchButton);

add(buttonPanel);
add(t1);
    }
} 

and the actual insert page is

 
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import java.util.*;
import javax.swing.*;
import javax.swing.event.*;
public class InsertReq implements ActionListener
{
    private Connection connection;
    private Requirement fields;
    
    public InsertReq(Connection c) 
    {
        connection = c;
fields = new Requirement();
    }
    
    public void actionPerformed( ActionEvent e )
    {
try {
    Statement statement = connection.createStatement();    
    String query = "INSERT INTO Requirement (" +
        "Name, Type, Module, Description" + 
") VALUES ('" +
fields.nameField.getText() + "', '" +
fields.typeField.getText() + "', '" +
fields.moduleField.getText() + "', '" +
fields.descripField.getText() + "')";

        //statement.execute("CREATE TABLE Greetings( Name CHAR(20))");
statement.close();
}
catch (SQLException sqlex)
{
System.out.print ("error");
}
    }
} 

I am guessing the problem is that I haven't really specified where the fields are but all the examples I can find create their forms in a panel and then use that but since I have created mine straight into a frame I am a little lost on how to do this.
Thanks

[Joe Ess]

So what you are really asking is how to add your TextFields (AWT) or JTextFields (Swing) to a Frame or JFrame?
aFrame.add(aField)
OR
jFrame.getContentPane().add(jField)
There's a little more to it, since the default layout manager for a Frame or JFrame is java.awt.BorderLayout. Just adding fields to it will put all your fields on top of each other in the center. Try a GridLayout with two rows and alternate adding a Label (or JLabel) and a field.
For more information, consult the Java Tutorial: Creating a GUI with Swing. The "Laying Out Components Within a Container" chapter will be particularly helpful.

[Amy Phillips]

No I am ok with the form creation, what I am really asking is how do i fetch the data the user types in?

[Eddie Vanda]

Does your code compile ok? Are there any exceptions thrown when you run this code?

[Amy Phillips]

It compiles and runs but when I click the button to insert the data I get a load of exception messages. I have tested the database connection and that is working fine the problem seems to be than the insert query doesn't know which form fields I am trying to insert from.

[Amy Phillips]

I have manged to fix the problems