Access mysql database in eclipse using java

Question

I created a simple mysql database table using following query:

CREATE TABLE customer(
name varchar(20),
C_ID int NOT NULL AUTO_INCREMENT,
address  varchar(20),
email varchar(20),
PRIMARY KEY(C_ID)
);

Now I want to insert values to this table. My client like this:

package com.orderdata.ws;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.PreparedStatement;

import com.mysql.jdbc.Statement;

public class OrderData {
public static void main(String[] args)throws Exception{
    Class.forName("com.mysql.jdbc.Driver");
    Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/orderdata","root","chathura");
    Statement stmt = (Statement) con.createStatement();
    String insert = "INSERT INTO customer(name,C_ID,address,email)      VALUES (a,5,b,c)";
    stmt.executeUpdate(insert);

}

}

But this gives an exception "Exception in thread "main" 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 '(a,5,b,c)' at line 1............"

How can I insert data using eclipse???

DankMemes · Accepted Answer · 2012-02-19 21:10:18Z

4

When inserting varchar text to MySQL tables, you need to surround it in single quotes like this:

String insert = "INSERT INTO customer(name,C_ID,address,email) VALUES ('a',5,'b','c');";

answered Feb 19, 2012 at 21:10

DankMemes

2,1372 gold badges21 silver badges30 bronze badges

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

Comments

Kamil · Accepted Answer · 2012-02-19 21:11:02Z

1

Access databases need ";" at the end of sql command.

String insert = "INSERT INTO customer(name,C_ID,address,email) VALUES ('a',5,'b','c');";

Edit: And you need to put text data into query like this

VALUES ('a',5,'b','c')

You may need to "escape" ' (quote) characters. I dont know how to do this in java, maybe like this:

VALUES (\'a\',5,\'b\',\'c\')

edited Feb 19, 2012 at 21:11

answered Feb 19, 2012 at 21:03

Kamil

14k25 gold badges101 silver badges202 bronze badges

1 Comment

Grant Over a year ago

Still have the same problem "Exception in thread "main" 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 '(a,5,b,c)' at line 1 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native M...

Collectives™ on Stack Overflow

Access mysql database in eclipse using java

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related