Insertion Query Not Working

Question

I have a problem in which I think the INSERT statement is wrong as I keep getting the "SQL ERROR". Every time I do the UPDATE statement, it works just fine. I can't seem to find what's wrong with the query.

My database table: emenu_user HAS variables id,username,password,email,contact and food. ALL in which are VARCHAR (for now).

 public void Connection(){

        try{
        Connection connection=DriverManager.getConnection("jdbc:mysql://localhost:3306/emenu?zeroDateTimeBehavior=convertToNull","root","");
        if(connection!=null){
        System.out.println("Database connected");
        }else {System.out.println("Database NOT connected");}


        String name=username_field.getText();
        String pass=password_field.getText();
        String email=email_field.getText();
        String contact=contact_field.getText();

        String query="INSERT INTO emenu_user (username,password,email,contact) VALUES (?,?,?,?)";
        PreparedStatement statement = connection.prepareStatement(query);
        statement.setString(1,name);
        statement.setString(2,pass);
        statement.setString(3,email);
        statement.setString(4,contact);


        int set=statement.executeUpdate();

        if(set>0)
        {
            JOptionPane.showMessageDialog(null,"Data Saved");
            homepageMenu homepageMenu= new homepageMenu();
            homepageMenu.setVisible(true);
            dispose();
        }
        else
        {
            JOptionPane.showMessageDialog(null,"ERROR");
        }


    } catch(SQLException e){
            JOptionPane.showMessageDialog(null,"SQL FAILED");
    }

}

unfortunately no, the only output i get is build successfull and the SQL ERROR message. id field is auto increment @Thilo — Grey
– Grey, Commented May 4, 2018 at 8:29
java.sql.SQLException: Field 'food' doesn't have a default value @Berger — Grey
– Grey, Commented May 4, 2018 at 8:32

Harshit · Accepted Answer · 2018-05-04 08:35:11Z

1

You need to either set field food to null

ALTER TABLE `emenu_user` ALTER `food` SET DEFAULT NULL

or supply some value while insertion

String query="INSERT INTO emenu_user (username,password,email,contact, food) VALUES (?,?,?,?,?)";
    PreparedStatement statement = connection.prepareStatement(query);
    statement.setString(1,name);
    statement.setString(2,pass);
    statement.setString(3,email);
    statement.setString(4,contact);
    statement.setString(5,[SOME_VALUE]);

answered May 4, 2018 at 8:35

Harshit

5,18711 gold badges51 silver badges96 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Grey Over a year ago

yeah, i just realised that. Thanks so much

Collectives™ on Stack Overflow

Insertion Query Not Working

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related