Win a copy of Learn Spring Security (video course) this week in the Spring forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

problem in inserting data

 
rammie singh
Ranch Hand
Posts: 118
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
</b>
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic