Error in updating records using JDBC

Question

I am having a problem with an MySQL Update query. Here is the code:

String s2="foo";
String s6="bar";

try{
Class.forName("com.mysql.jdbc.Driver");
Connection       con=DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb","root","root");
String query="update mydb set Status='"+s6+"' where IC_Number='"+s2+"'";
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery(query);
con.close();
}
catch(Exception e)
{
System.out.println("Error in login:"+e);
}
}
}

I get the error

can not issue data manipulation statements with executeQuery().

Can anyone point out where the problem is ?

What is error you are getting? – usmanali Jun 09 '15 at 12:20 — usmanali, Jun 09 '15 at 12:20
my record was not updated... But now problem solved :) – stephen leow Jun 09 '15 at 13:44 — stephen leow, Jun 09 '15 at 13:44

score 0 · Accepted Answer · answered Jun 09 '15 at 12:22

0

For update operation you have to use executeUpdate which returns an integer but not a ResultSet

Change:

ResultSet rs=stmt.executeQuery(query);

To:

int updateResult = stmt.executeUpdate( query );

Documentation:

java.sql.Statement.executeUpdate(java.lang.String)
- Executes the given SQL statement, which may be an INSERT, UPDATE, or DELETE statement or an SQL statement that returns nothing, such as an SQL DDL statement.

answered Jun 09 '15 at 12:22

Ravinder Reddy

23,692
6
52
82

Thanks !!!! Both of you save my day !!! – stephen leow Jun 09 '15 at 13:11

score 0 · Answer 2 · answered Jun 09 '15 at 12:23

0

You should use executeUpdate() instead of executeQuery();

answered Jun 09 '15 at 12:23

Shailesh Yadav

1,061
1
15
30

Thanks !!!! Both of you save my day !!! – stephen leow Jun 09 '15 at 13:10

Error in updating records using JDBC

2 Answers2