stmt.close();
conn.close();
}
private void saveXpathConfigData(XPathConfigData xpathConfig) throws SQLException {
XPathConfigData data = getXpathConfigData(xpathConfig.getKey(), serverId);
if (data != null && xpathConfig.equals(data)) {
return;
}
Connection conn = dataSource.getConnection();
Statement stmt = conn.createStatement();
if (data == null) {
String insertXpath = "INSERT INTO BAM_XPATH(BAM_ALIAS,BAM_NAME,BAM_XPATH,BAM_SERVER_ID) VALUES ('" +
xpathConfig.getAlias() + "','" + xpathConfig.getKey() + "','" +
xpathConfig.getXpath() + "','" + serverId + "')";
stmt.executeUpdate(insertXpath, Statement.RETURN_GENERATED_KEYS);
int id = -1;
ResultSet insertResults = stmt.getGeneratedKeys();
if (insertResults.next()) {
id = insertResults.getInt(1);
}
insertResults.close();
saveNamespaceData(xpathConfig, id);
} else if (!xpathConfig.equals(data)) {
String updateXpath = "UPDATE BAM_XPATH SET BAM_ALIAS = '" + xpathConfig.getAlias() +
"', BAM_NAME = '" + xpathConfig.getKey() + "', " + "BAM_XPATH = '" +
xpathConfig.getXpath() + "'," + " BAM_SERVER_ID = '" + serverId +
"' WHERE BAM_ID = '" + data.getId() + "'";
stmt.executeUpdate(updateXpath, Statement.RETURN_GENERATED_KEYS);
int id = -1;
ResultSet updateResults = stmt.getGeneratedKeys();