statement stmt = conn.createstatement();

// obtain the generated key that results from the query.

stmt.executeupdate("insert into authors " +

           "(first_name, last_name) " +

           "values (george, orwell)",

           statement.return_generated_keys);

resultset rs = stmt.getgeneratedkeys();

if ( rs.next() ) {

    // retrieve the auto generated key(s).

    int key = rs.getint();}

string proccall;

// set the value of proccall to call a stored procedure.

// ...callablestatement cstmt = connection.preparecall(proccall);

int retval = cstmt.execute();

if (retval == false) {

    // the statement returned an update count, so handle it.

    // ...

} 

else { 

    // resultset

    resultset rs1 = cstmt.getresultset();

    // ...

    retval = cstmt.getmoreresults(statement.keep_current_result);

    if (retval == true) {

        resultset rs2 = cstmt.getresultset();

        // both resultsets are open and ready for use.

        rs2.next();

        rs1.next();

        // ...

    }

}

string insert_book_query =

    "insert into booklist " + 

               "(author, title) " + 

               "values (?, ?) ";

connection conn = apooledconnection.getconnection();

preparedstatement ps = conn.preparestatement(insert_book_query);

ps.setstring(1, "orwell, george");

ps.setstring(2, "1984");

ps.executeupdate();

ps.close();

conn.close();

// ...

conn = apooledconnection.getconnection();

// since the connection is from a pooledconnection, the data layer has

// the option to retrieve this statement from its statement pool,

// saving the vm from re-compiling the statement again.

preparedstatement cachedstatement = conn.preparestatemet(insert_book_query);

// ...

conn.setautocommit(false);

// set a conservative transaction isolation level.

conn.settransactionisolation(connection.transaction_serializable);

statement stmt = conn.createstatement();

int rows = stmt.executeupdate(

    "insert into authors " +

                 "(first_name, last_name) values " + 

               "(lewis, carroll)");

// set a named savepoint.

savepoint svpt = conn.setsavepoint("newauthor");

// ...

rows = stmt.executeupdate(

    "update authors set type = fiction " +

                "where last_name = carroll");

// ...

conn.rollback(svpt);

// ...

// the author has been added, but not updated.

conn.commit();