File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes problem in inserting data Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "problem in inserting data" Watch "problem in inserting data" New topic

problem in inserting data

rammie singh
Ranch Hand

Joined: Mar 26, 2009
Posts: 116
Hi every body

i am having problem in executing an insert query through JDBC

my table is

my code of execution is

my error while executing is

:<b> Error is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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
Paul Sturrock

Joined: Apr 14, 2004
Posts: 10336

You don't close your SQL statement's values clause. Your SQL shouyld be like:

what you've got is:

Also, its much better practice to use a PreparedStatement rather than a Statement. It will make your life easier in the long run.

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
I agree. Here's the link:
subject: problem in inserting data
It's not a secret anymore!