/**
* Insert new row into the BUSINESS_ENTITIES table.
*
* @param service object holding values to be inserted
* @param connection JDBC connection
* @throws java.sql.SQLException
*/
public static void insert(BusinessService service, Connection connection)
throws java.sql.SQLException {
PreparedStatement statement = null;
Timestamp timeStamp = new Timestamp(System.currentTimeMillis());
try {
statement = connection.prepareStatement(insertSQL);
statement.setString(1, service.getBusinessKey().toString());
statement.setString(2, service.getServiceKey().toString());
statement.setTimestamp(3, timeStamp);
log.info(
"insert into BUSINESS_SERVICE table:\n\n\t"
+ insertSQL
+ "\n\t BUSINESS_KEY="
+ service.getBusinessKey().toString()
+ "\n\t SERVICE_KEY="
+ service.getServiceKey().toString()
+ "\n\t LAST_UPDATE="
+ timeStamp.getTime()
+ "\n");
int returnCode = statement.executeUpdate();
log.info("insert into BUSINESS_SERVICE was successful, return code=" + returnCode);
} finally {
try {
statement.close();
} catch (Exception e) {
/* ignored */
}
}
}
/**
* Select all rows from the business_service table for a given BusinessKey.
*
* <p>
*
* @param businessKey BusinessKey
* @param connection JDBC connection
* @throws java.sql.SQLException
*/
public static Vector selectByBusinessKey(String businessKey, Connection connection)
throws java.sql.SQLException {
Vector serviceList = new Vector();
PreparedStatement statement = null;
ResultSet resultSet = null;
try {
// create a statement to query with
statement = connection.prepareStatement(selectByBusinessKeySQL);
statement.setString(1, businessKey.toString());
log.info(
"select from BUSINESS_SERVICE table:\n\n\t"
+ selectByBusinessKeySQL
+ "\n\t BUSINESS_KEY="
+ businessKey.toString()
+ "\n");
// execute the statement
resultSet = statement.executeQuery();
BusinessService service = null;
while (resultSet.next()) {
service = new BusinessService();
service.setBusinessKey(businessKey);
service.setServiceKey(resultSet.getString("SERVICE_KEY"));
serviceList.add(service);
service = null;
}
log.info("select was successful, rows selected=" + serviceList.size());
return serviceList;
} finally {
try {
resultSet.close();
} catch (Exception e) {
/* ignored */
}
try {
statement.close();
} catch (Exception e) {
/* ignored */
}
}
}
/**
* Select one row from the BUSINESS_SERVICE table.
*
* @param serviceKey primary key value
* @param connection JDBC connection
* @throws java.sql.SQLException
*/
public static BusinessService select(String serviceKey, Connection connection)
throws java.sql.SQLException {
BusinessService service = null;
PreparedStatement statement = null;
ResultSet resultSet = null;
try {
statement = connection.prepareStatement(selectSQL);
statement.setString(1, serviceKey.toString());
log.info(
"select from BUSINESS_SERVICE table:\n\n\t"
+ selectSQL
+ "\n\t SERVICE_KEY="
+ serviceKey.toString()
+ "\n");
resultSet = statement.executeQuery();
if (resultSet.next()) {
service = new BusinessService();
service.setBusinessKey(resultSet.getString("BUSINESS_KEY"));
service.setServiceKey(serviceKey);
}
if (service != null) log.info("select successful, at least one row was found");
else
log.info(
"select executed successfully but no rows were found with SERVICE_KEY="
+ serviceKey.toString());
return service;
} finally {
try {
resultSet.close();
} catch (Exception e) {
/* ignored */
}
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();
}
}
}
}