[Criel]

Hello,

I am trying to create a form where the program will take the values from the fields on the form and input them into a database. I know how to do this in the Visual Studios environment but I am unsure of how to do this in Java.

Connection conn = getConnection();
         Statement stmt = conn.createStatement();

        stmt.executeUpdate("create table Customers (Customerid int, FirstName CHAR(15), LastName CHAR(15), MI CHAR(1), Address CHAR(15), Phone CHAR(15), City CHAR(15), State CHAR(15), Zip CHAR(10));");

I am unsure of how to get each separate text field to correspond with each value to input into the database. I've looked into the netbeans tutorials however they only walk you through how to do that on web forms. Would this be the same?

Any information on this would be great!

[macosxnerd101]

NetBeans is just a fancy editor. Just make sure to stay away from the visual GUI Builder as it produces horrid, unmaintainable code.

Should be as simple as just getting the text from your JTextFields, and plugging them into your queries (after sanitizing your inputs first, of course).

String col1 = col1Field.getText();
col1 = sanitize(col1); //you define sanitize(String)

String query = "INSERT INTO table(col1) VALUES('" + col1 + "');";

[pbl]

Your GUI stuff and your database access should be as separated as possible.

This is quite difficult to achieve with VB because you start by designing the GUI and then plug the modified code in place.

Here you need a kind of controller that push and pull objects to your GUI that displays it. This program can also call a DB class that store/retrive objects built in the GUI to the DB.

[Criel]

Hello,

I am having a syntax error with my code, what is the problem here?

 sql =   ("INSERT INTO Customers (id, firstName, lastName, mi, address, phone, city, state, zip")
                    + "VALUES('"+id+"','"+firstName+"','"+lastName+"','"+mi+"','"+address+"','"+phone+"','"+city+"','"+state+"','"+zip+"')";
                
            Statement st = con.createStatement();
            rows = st.executeUpdate(sql);
            st.close();

Is it because my id and zip fields are number instead of text? If so, can I just convert them to text or is there a special syntax for those inputs.

Thanks for your replies.

[macosxnerd101]

Please post your specific error message from your compiler.

[Criel]

macosxnerd101, on 13 March 2011 - 06:03 PM, said:

Please post your specific error message from your compiler.

Error: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.

[pbl]

I guess we'll have to match/compare your database columns type and your datatype in the Java program itself

[Criel]

Is the syntax looking OK? I made all text data types in my database text just to see if that was a problem and I'm still getting the issue.

[pbl]

Criel, on 13 March 2011 - 10:12 PM, said:

Is the syntax looking OK?

Depends of the datatype of your variables (inside the Java program)

[Criel]

This is how I declared my variables:

String id = idTextField.getText();
        String firstName = firstNameTextField.getText();
        String lastName = lastNameTextField.getText();
        String mi = miTextField.getText();
        String address = adressTextField.getText();
        String phone = phoneTextField.getText();
        String city = phoneTextField.getText();
        String state = stateTextField.getText();
        String zip = zipTextField.getText();

Did I not declare them the right data type?

[pbl]

Criel, on 13 March 2011 - 10:39 PM, said:

This is how I declared my variables:

String id = idTextField.getText();
        String firstName = firstNameTextField.getText();
        String lastName = lastNameTextField.getText();
        String mi = miTextField.getText();
        String address = adressTextField.getText();
        String phone = phoneTextField.getText();
        String city = phoneTextField.getText();
        String state = stateTextField.getText();
        String zip = zipTextField.getText();

And the column definitions in your database table ?

I can't beleive how much we have to beg for information to fix your problem !!!
Did I not declare them the right data type?

Sorry I lost my temper
You posted you table definition
This one contains int
all you put in are Strings

[Criel]

Not trying to get you frustrated. Just trying to keep up. Still trying to learn this.

Could you clarify what you meant by what contains an int?

[macosxnerd101]

Look at your table definition. Customerid is an int. You cannot insert a String into an int field.

create table Customers (Customerid int

[Criel]

macosxnerd101, on 13 March 2011 - 09:16 PM, said:

Look at your table definition. Customerid is an int. You cannot insert a String into an int field.

create table Customers (Customerid int

I have changed the customerID data type from an int to a string and it's still giving me the same error. Any ideas?

Thanks for the help so far, guys.

This post has been edited by Criel: 13 March 2011 - 11:22 PM

[baavgai]

Ack, no:

String query = "INSERT INTO table(col1) VALUES('" + col1 + "');";

Prepare the statment, bind the vars, do it right the first time:

PreparedStatement prep = conn.prepareStatement("INSERT INTO table(col1) VALUES(?);");
prep.setString(1, col1Field.getText());
prep.execute();

For "int", what database? Some use integer. Often integer is just an alias for number.