{
// begin a new transaction
txn.begin(connection);
// insert a few new publishers
Publisher publisher = new Publisher();
publisher.setPublisherID("bcrosby");
publisher.setName("Bing Crosby");
publisher.setLastName("Crosby");
publisher.setFirstName("Bing");
publisher.setWorkPhone("978.123-4567");
publisher.setMobilePhone("617-765-9876");
publisher.setPager("800-123-4655 ID: 501");
publisher.setEmailAddress("bcrosby@juddi.org");
publisher.setAdmin(false);
publisher.setEnabled(false);
PublisherTable.insert(publisher,connection);
// select each inserted publisher
System.out.println(PublisherTable.select("bcrosby",connection));
publisher.setFirstName("Bart");
publisher.setName("Barthalomue Crosby");
publisher.setEnabled(true);
PublisherTable.update(publisher,connection);
// select each inserted publisher
System.out.println(PublisherTable.select("bcrosby",connection));