My SQL insertion of values using java program

Question

I have written this code to insert values in mysql ,I have already made database connection I am getting this error: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException

public class JavaMysql {

     public static void main(String[] args) {
         String url = "jdbc:mysql://localhost:3306/bhuwan";
         String driver = "com.mysql.jdbc.Driver";
         String userName = "root";
         String password = "rpass"; 
         try {
             Class.forName(driver).newInstance();

             Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/bhuwan","root","rpass");
             PreparedStatement stmt=conn.prepareStatement("insert in to xmltable values(?,?)");
             stmt.setInt(1,101);
             stmt.setString(2,"Nitish Sharma");
             stmt.execute();
             int i=stmt.executeUpdate();
             System.out.println(i+"records inserted");
             conn.close();
         }catch(Exception e){System.out.println(e);}
         }
}

into and not in to

Maroun
– Maroun

2013-05-06 06:54:19 +00:00
Commented May 6, 2013 at 6:54 — Maroun
– Maroun, Commented May 6, 2013 at 6:54

John Woo · Accepted Answer · 2013-05-06 06:53:43Z

4

the problem is you have a space in INTO keyword,

insert in to xmltable values(?,?)  
         ^ causes the error

it should be

insert into xmltable values(?,?)

answered May 6, 2013 at 6:53

John Woo

265k70 gold badges509 silver badges500 bronze badges

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

2 Comments

Nitish Sharma Over a year ago

now i am getting a error:-com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '101' for key 'PRIMARY'

John Woo Over a year ago

it just means there is already a value for the primary key the exists. do you have any auto increment column?

Collectives™ on Stack Overflow

My SQL insertion of values using java program

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related