JDBC Statement interface - executeUpdate query

Question

import java.sql.*;
class ConnectionTest {
    public static void main(String... args)throws Exception {
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        Connection con = DriverManager.getConnection("Jdbc:Odbc:myjdbc1", "sri", "tiger");
        System.out.println(con);
        Statement st = con.createStatement();
        System.out.println(st);
        String query = "delete logindetails";
        int count = st.executeUpdate(query);
        if(count == 0) 
        System.out.println("no records to delete");
        else 
        System.out.println("deleted successfullly");
        con.close();
    }
}

Hello World..!! My Question is.. What value is being assigned to integer variable count in int count = st.executeUpdate(query);
What does it assigns after it deleted all the rows..
and what does it assigns if there are already 0 rows in my table and no rows are deleted..?

Detailed explanation is much appreciated.
P.S. noob here

stackoverflow.com/questions/12400985/…

Maroun
– Maroun

2013-04-20 13:52:11 +00:00
Commented Apr 20, 2013 at 13:52 — Maroun
– Maroun, Commented Apr 20, 2013 at 13:52

Lokesh · Accepted Answer · 2013-04-20 14:25:33Z

1

executeUpdate(query) returns number of rows affected this implies if there are no rows in the table then 0 will be returned and if there are rows in table then total rowcount of table.

edited Apr 20, 2013 at 14:25

answered Apr 20, 2013 at 13:52

Lokesh

7,9487 gold badges50 silver badges86 bronze badges

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

1 Comment

Lokesh Over a year ago

Done. I dont think too much explanation is needed, its straight forward.

user123454321 · Accepted Answer · 2013-04-20 14:03:50Z

1

From official docs: Returns: either the row count for SQL Data Manipulation Language (such as INSERT, UPDATE or DELETE) statements or 0 for SQL statements that return nothing

@Update

It assigns the number of deleted rows.

edited Apr 20, 2013 at 14:03

answered Apr 20, 2013 at 13:49

user123454321

1,0589 silver badges29 bronze badges

Comments

Abhishekkumar · Accepted Answer · 2013-04-20 13:56:49Z

0

Returns: either

(1) the row count for SQL Data Manipulation Language (DML) statements or

(2) 0 for SQL statements that return nothing

answered Apr 20, 2013 at 13:56

Abhishekkumar

1,1029 silver badges24 bronze badges

Collectives™ on Stack Overflow

JDBC Statement interface - executeUpdate query

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related