how many fild updated

hi every body ... ihave this function to update the database

what i want to understand is how to know how many record updated

in my database

void updating(String a,String b)

{

try{

String driver ="sun.jdbc.odbc.JdbcOdbcDriver";

String url="jdbc:odbc:db1";

Class.forName( driver );

Connection con=DriverManager.getConnection(url);

String sql;

Statement stmt;

sql="update APPDATA set PAN='"+b+"' where PAN='"+a+"'";

stmt=con.createStatement();

stmt.executeUpdate(sql);

con.close();

stmt.close();

}

catch (Exception e)

{

System.out.println(e);

}

}

[1080 byte] By [mostafa_khattaba] at [2007-11-26 13:45:44]
# 1

int executeUpdate(String sql)

throws SQLException

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.

Parameters:

sql - an SQL INSERT, UPDATE or DELETE statement or an SQL statement that returns nothing

Returns:

either the row count for INSERT, UPDATE or DELETE statements, or 0 for SQL statements that return nothing

sabre150a at 2007-7-8 1:20:28 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 2
Thank you very match it worksi returned the executeUpdate value and it gives me the defined updated record
mostafa_khattaba at 2007-7-8 1:20:28 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...