java.sql.SQLSyntaxErrorException in SQL database connectivity

Question

This is my code. When I run it, I get error:

java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Can someone please help me?

form_()
{
    setSize(265,500);
    setVisible(true);
    setLayout(new FlowLayout());
    add(l1);
    add(t1);
    add(l2);
    add(t2);
    add(l3);
    add(t3);
    add(l4);
    add(t5);
    add(l5);
    add(t4);
    add(b);
    b.addActionListener(this);

}

@Override
public void actionPerformed(ActionEvent e) {
    if(e.getSource()==b) {
        int x = 0;
        String s1 = t1.getText();
        String s2 = t2.getText();
        String s3 = t3.getText();
        char[] c = t5.getPassword();
        String s5 = new String(c);
        String s4 = t4.getText();


        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
            Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/db?useSSL=false", "******", "********");

            PreparedStatement ps = con.prepareStatement("INSERT INTO reg1 values(?,?,?,?,?");
            ps.setString(1, s1);
            ps.setString(2, s2);
            ps.setString(3, s3);
            ps.setString(4, s4);
            ps.setString(5, s5);
            int rs = ps.executeUpdate();
            x++;
            if(x>0)
            {
                JOptionPane.showMessageDialog(b,"Data saved Successfully");
            }
        } catch (Exception ex) {
            System.out.println(ex);
        }
    }
}
}

Yohan Malshika · Accepted Answer · 2018-07-02 09:00:21Z

1

con.prepareStatement("INSERT INTO reg1 values(?,?,?,?,?"); this is the mistake in your code. you should try it this way con.prepareStatement("INSERT INTO reg1 values(?,?,?,?,?)");

edited Jul 2, 2018 at 9:00

answered Jun 24, 2018 at 7:57

Yohan Malshika

7431 gold badge11 silver badges20 bronze badges

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

1 Comment

Osusara Kammalawatta Over a year ago

It should be ("INSERT INTO reg1 values(?,?,?,?,?)"); isn't it?

user8007559 · Accepted Answer · 2018-06-13 08:17:31Z

1

I think you forget a parenthesis in "INSERT INTO reg1 values(?,?,?,?,?" it should be like that : "INSERT INTO reg1 values(?,?,?,?,?)"

answered Jun 13, 2018 at 8:17

user8007559

Comments

Yati Sawhney - Yates · Accepted Answer · 2018-06-13 08:17:04Z

0

You have messed up with the parathesis(SQL syntax). Add 1 ')' after last ?. which resulted in SQLSyntaxErrorException

I have updated the snippet:

PreparedStatement ps = con.prepareStatement("INSERT INTO reg1 values(?,?,?,?,?)");
            ps.setString(1, s1);
            ps.setString(2, s2);
            ps.setString(3, s3);
            ps.setString(4, s4);
            ps.setString(5, s5);

answered Jun 13, 2018 at 8:17

Yati Sawhney - Yates

1,4021 gold badge13 silver badges20 bronze badges

Collectives™ on Stack Overflow

java.sql.SQLSyntaxErrorException in SQL database connectivity

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related