Java

Java RSS

SQL Insert - which method to use

Please support our Java advertiser: Programming Forums - DaniWeb Sister Site

Thread Solved

•

Join Date: Mar 2008

Posts: 42

Reputation: marcosjp is an unknown quantity at this point

Solved Threads: 0

marcosjp

Offline

Light Poster

SQL Insert - which method to use

Jun 5th, 2008

Hi there!

I'm building a small application using Java and MySQL (college assignment).
Everything is ok when all I'm doing are queries using SELECT.
Now, when I try to INSERT anything in the table, I get this error message:

java.sql.SQLException: Can not issue data manipulation statements with executeQuery(). 0 S1009

Ok, so I should use something else other than executeQuery to manipulate data (and I suppose the same will happen if I try to UPDATE the table as well).

So, please, what should I use? I tried other methods from NetBeans but did not quite understand how to use them.

This is the code I'm using:

 Help with Code Tags 
 Java Syntax (Toggle Plain Text) 
            Statement statement=conn.createStatement();
            ResultSet resultSet=statement.executeQuery(sqlstring);
            Statement statement=conn.createStatement();
            ResultSet resultSet=statement.executeQuery(sqlstring);

Thanks!!

•

Join Date: Feb 2006

Posts: 2,391

Reputation: masijade has much to be proud of

Solved Threads: 254

masijade

Offline

Nearly a Posting Maven

Re: SQL Insert - which method to use

Jun 6th, 2008

executeUpdate not executeQuery (on non-select queries)

Java Programmer and Sun Systems Administrator

----------------------------------------------

Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it.
--Brian Kernighan