/** Create the BUSINESS_SERVICE table. */ public static void create(Connection connection) { System.out.print("CREATE TABLE BUSINESS_SERVICE: "); Statement statement = null; try { statement = connection.createStatement(); int returnCode = statement.executeUpdate(createSQL); System.out.println("Successful (return code=" + returnCode + ")"); } catch (java.sql.SQLException sqlex) { System.out.println("Failed (error message=" + sqlex.getMessage() + ")\n"); System.out.println("SQL=" + createSQL); } finally { try { statement.close(); } catch (Exception e) { /* ignored */ } } }
// system test-driver public static void test(Connection connection) { Transaction txn = new Transaction(); if (connection != null) { try { String businessKey = UUID.nextID(); BusinessEntity business = new BusinessEntity(); business.setBusinessKey(businessKey); business.setAuthorizedName("sviens"); business.setOperator("WebServiceRegistry.com"); String serviceKey = UUID.nextID(); BusinessService service = new BusinessService(); service.setBusinessKey(businessKey); service.setServiceKey(serviceKey); // begin a new transaction txn.begin(connection); String authorizedUserID = "sviens"; // insert a new BusinessEntity BusinessEntityTable.insert(business, authorizedUserID, connection); // insert a new BusinessService BusinessServiceTable.insert(service, connection); // insert another new BusinessService service.setServiceKey(UUID.nextID()); BusinessServiceTable.insert(service, connection); // insert one more new BusinessService service.setServiceKey(UUID.nextID()); BusinessServiceTable.insert(service, connection); // select a BusinessService object service = BusinessServiceTable.select(serviceKey, connection); // delete a BusinessService object BusinessServiceTable.delete(serviceKey, connection); // select a BusinessService object service = BusinessServiceTable.select(serviceKey, connection); // select a Collection BusinessService objects by BusinessKey BusinessServiceTable.selectByBusinessKey(businessKey, connection); // delete a Collection BusinessService objects by BusinessKey BusinessServiceTable.deleteByBusinessKey(businessKey, connection); // select a Collection BusinessService objects by BusinessKey BusinessServiceTable.selectByBusinessKey(businessKey, connection); // commit the transaction txn.commit(); } catch (Exception ex) { ex.printStackTrace(); try { txn.rollback(); } catch (java.sql.SQLException sqlex) { sqlex.printStackTrace(); } } } }