Mira este código esta bastante bien explicadete saludos
import java.sql.*;

class DB2Appl {

static {
try {
// register the driver with DriverManager
// The newInstance() call is needed for the sample to work with
// JDK 1.1.1 on OS/2, where the Class.forName() method does not
// run the static initializer. For other JDKs, the newInstance
// call can be omitted.
Class.forName("COM.ibm.db2.jdbc.app.DB2Driver").newInstance();
} catch (Exception e) {
e.printStackTrace();
}
}

public static void main(String argv[]) {
Connection con = null;

// URL is jdbc:db2:dbname
String url = "jdbc:db2:sample";

try {
if (argv.length == 0) {
// connect with default id/password
con = DriverManager.getConnection(url);
}
else if (argv.length == 2) {
String userid = argv[0];
String passwd = argv[1];

// connect with user-provided username and password
con = DriverManager.getConnection(url, userid, passwd);
}
else {
System.out.println("\nUsage: java DB2Appl [username password]\n");
System.exit(0);
}

// retrieve data from the database
System.out.println("Retrieve some data from the database...");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * from employee");

System.out.println("Received results:");

// display the result set
// rs.next() returns false when there are no more rows
while (rs.next()) {
String a = rs.getString(1);
String str = rs.getString(2);

System.out.print(" empno= " + a);
System.out.print(" firstname= " + str);
System.out.print("\n");
}

rs.close();
stmt.close();

// update the database
System.out.println("\n\nUpdate the database... ");
stmt = con.createStatement();
int rowsUpdated = stmt.executeUpdate("UPDATE employee set firstnme = 'SHILI' where empno = '000010'");

System.out.print("Changed "+rowsUpdated);

if (1 == rowsUpdated)
System.out.println(" row.");
else
System.out.println(" rows.");

stmt.close();
con.close();
} catch( Exception e ) {
e.printStackTrace();
}
}
}

Responder