JAVA jdbc Eclipse SQLException

Question

I was trying to add details to table but it showing some SQL error

Query is:

t=st1.executeUpdate("insert into stdetails(regno,nam,cid,gender,HouseName,place,guardian,phone,photo,did,Emailid,sem) values("+  reg+",'"+ n +"',"+ c +",'"+g+"','"+ h+"','"+p+"','"+ guar +"','"+ph+"','"+pic+"',"+d+",'"+e+"',"+s+"");

Error is

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

Looks like one of your values is blank and you miss the single qoutes. BTW: learn about prepared Statements, to prevent SQL injection — Jens
– Jens, Commented Mar 8, 2017 at 7:55
But it is Also showing same error, when i use prepared stmnts — Vaisakh MA
– Vaisakh MA, Commented Mar 8, 2017 at 8:03
Please add the prepare stement to your question not as a comment — Jens
– Jens, Commented Mar 8, 2017 at 9:29

Youcef LAIDANI · Accepted Answer · 2017-09-14 19:09:51Z

1

Your are missing the parentheses ) in the end of your query so it should look like :

t = st1.executeUpdate("...." + s + ")");
//----------------------------------^---

BUT

Instead of using this way, this can cause a syntax error like your case, and can cause an Sql Injection you have to use PreparedStatement.

edited Sep 14, 2017 at 19:09

answered Mar 8, 2017 at 8:03

Youcef LAIDANI

60.3k21 gold badges111 silver badges178 bronze badges

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

1 Comment

Youcef LAIDANI Over a year ago

you are welcome, instead, i suggest to use PrepapredStatement ok to avoid all this problems of syntax ok @VaisakhMA

score 1 · Accepted Answer · 2017-03-08 12:46:08Z

1

there is error in your mysql syntax

 String query="insert into stdetails (regno,nam,gender) values(?,?,?)";
 PreparedStatement preparedStmt2 = con.prepareStatement(query);
 preparedStmt2.setInt (1," ");
 preparedStmt2.setString (2," ");
 preparedStmt2.setString(3, " ");
 preparedStmt2.execute();

like this you can add more columns also

edited Mar 8, 2017 at 12:46

answered Mar 8, 2017 at 7:58

user6409042

2 Comments

Jens Over a year ago

Why setString if the first columns are int values

Jens Over a year ago

Can you really use a string in setInt?

Collectives™ on Stack Overflow

JAVA jdbc Eclipse SQLException

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related