public int update(LinkModel model) throws SQLException {
String sql = null;
String updateString = "";
ArrayList strList = new ArrayList();
ArrayList valList = new ArrayList();
if (model.getNameModifyFlag()) {
StringUtil.makeDynaParam("NAME = ", convertSQL(model.getName()), strList, valList);
}
if (model.getDescriptionModifyFlag()) {
StringUtil.makeDynaParam(
"DESCRIPTION = ", convertSQL(model.getDescription()), strList, valList);
}
if (model.getLinkTypeModifyFlag()) {
StringUtil.makeDynaParam("LINK_TYPE = ", convertSQL(model.getLinkType()), strList, valList);
}
if (model.getTemplateIdModifyFlag()) {
StringUtil.makeDynaParam("TEMPLATE_ID = ", model.getTemplateId(), strList, valList);
}
if (model.getCurrentNodeIdModifyFlag()) {
StringUtil.makeDynaParam("CURRENT_NODE_ID = ", model.getCurrentNodeId(), strList, valList);
}
if (model.getNextNodeIdModifyFlag()) {
StringUtil.makeDynaParam("NEXT_NODE_ID = ", model.getNextNodeId(), strList, valList);
}
if (model.getExecutorRelationModifyFlag()) {
StringUtil.makeDynaParam(
"EXECUTOR_RELATION = ", convertSQL(model.getExecutorRelation()), strList, valList);
}
if (model.getExecutorsMethodModifyFlag()) {
StringUtil.makeDynaParam(
"EXECUTORS_METHOD = ", convertSQL(model.getExecutorsMethod()), strList, valList);
}
if (model.getNumberOrPercentModifyFlag()) {
StringUtil.makeDynaParam(
"NUMBER_OR_PERCENT = ", convertSQL(model.getNumberOrPercent()), strList, valList);
}
if (model.getPassValueModifyFlag()) {
StringUtil.makeDynaParam("PASS_VALUE = ", model.getPassValue(), strList, valList);
}
if (model.getExpressionModifyFlag()) {
StringUtil.makeDynaParam(
"EXPRESSION = ", convertSQL(model.getExpression()), strList, valList);
}
if (model.getDefaultPathModifyFlag()) {
StringUtil.makeDynaParam(
"DEFAULT_PATH = ", convertSQL(model.getDefaultPath()), strList, valList);
}
if (model.getActionNameModifyFlag()) {
StringUtil.makeDynaParam(
"ACTION_NAME = ", convertSQL(model.getActionName()), strList, valList);
}
if (strList.size() == 0) return 0;
valList.add(model.getNodeLinkId());
int length = strList.size();
if (length == 0) {
updateString = null;
} else {
for (int i = 0; i <= length - 1; i++) {
updateString += strList.get(i) + "?,";
}
updateString = updateString.substring(0, updateString.length() - 1);
}
sql = "update WF_LINK set " + updateString + " where NODE_LINK_ID= ?";
DBHelper.executeUpdate(sql, valList.toArray());
logger.info(sql);
return 1;
}
private LinkModel parseResultSet(ResultSet rs) throws SQLException {
LinkModel model = new LinkModel();
try {
model.setNodeLinkId(rs.getInt("NODE_LINK_ID"));
if (rs.wasNull()) model.setNodeLinkId(null);
} catch (Exception e) {
model.setNodeLinkId(null);
}
try {
model.setName(rs.getString("NAME"));
if (rs.wasNull()) model.setName(null);
} catch (Exception e) {
model.setName(null);
}
try {
model.setDescription(rs.getString("DESCRIPTION"));
if (rs.wasNull()) model.setDescription(null);
} catch (Exception e) {
model.setDescription(null);
}
try {
model.setLinkType(rs.getString("LINK_TYPE"));
if (rs.wasNull()) model.setLinkType(null);
} catch (Exception e) {
model.setLinkType(null);
}
try {
model.setTemplateId(rs.getInt("TEMPLATE_ID"));
if (rs.wasNull()) model.setTemplateId(null);
} catch (Exception e) {
model.setTemplateId(null);
}
try {
model.setCurrentNodeId(rs.getInt("CURRENT_NODE_ID"));
if (rs.wasNull()) model.setCurrentNodeId(null);
} catch (Exception e) {
model.setCurrentNodeId(null);
}
try {
model.setNextNodeId(rs.getInt("NEXT_NODE_ID"));
if (rs.wasNull()) model.setNextNodeId(null);
} catch (Exception e) {
model.setNextNodeId(null);
}
try {
model.setExecutorRelation(rs.getString("EXECUTOR_RELATION"));
if (rs.wasNull()) model.setExecutorRelation(null);
} catch (Exception e) {
model.setExecutorRelation(null);
}
try {
model.setExecutorsMethod(rs.getString("EXECUTORS_METHOD"));
if (rs.wasNull()) model.setExecutorsMethod(null);
} catch (Exception e) {
model.setExecutorsMethod(null);
}
try {
model.setNumberOrPercent(rs.getString("NUMBER_OR_PERCENT"));
if (rs.wasNull()) model.setNumberOrPercent(null);
} catch (Exception e) {
model.setNumberOrPercent(null);
}
try {
model.setPassValue(rs.getDouble("PASS_VALUE"));
if (rs.wasNull()) model.setPassValue(null);
} catch (Exception e) {
model.setPassValue(null);
}
try {
model.setExpression(rs.getString("EXPRESSION"));
if (rs.wasNull()) model.setExpression(null);
} catch (Exception e) {
model.setExpression(null);
}
try {
model.setDefaultPath(rs.getString("DEFAULT_PATH"));
if (rs.wasNull()) model.setDefaultPath(null);
} catch (Exception e) {
model.setDefaultPath(null);
}
try {
model.setActionName(rs.getString("ACTION_NAME"));
if (rs.wasNull()) model.setActionName(null);
} catch (Exception e) {
model.setActionName(null);
}
return model;
}
public int insert(LinkModel model) throws SQLException {
String sql = null;
ArrayList strList = new ArrayList();
ArrayList valList = new ArrayList();
if (model.getNodeLinkIdModifyFlag()) {
StringUtil.makeDynaParam("NODE_LINK_ID", model.getNodeLinkId(), strList, valList);
}
if (model.getNameModifyFlag()) {
StringUtil.makeDynaParam("NAME", convertSQL(model.getName()), strList, valList);
}
if (model.getDescriptionModifyFlag()) {
StringUtil.makeDynaParam("DESCRIPTION", convertSQL(model.getDescription()), strList, valList);
}
if (model.getLinkTypeModifyFlag()) {
StringUtil.makeDynaParam("LINK_TYPE", convertSQL(model.getLinkType()), strList, valList);
}
if (model.getTemplateIdModifyFlag()) {
StringUtil.makeDynaParam("TEMPLATE_ID", model.getTemplateId(), strList, valList);
}
if (model.getCurrentNodeIdModifyFlag()) {
StringUtil.makeDynaParam("CURRENT_NODE_ID", model.getCurrentNodeId(), strList, valList);
}
if (model.getNextNodeIdModifyFlag()) {
StringUtil.makeDynaParam("NEXT_NODE_ID", model.getNextNodeId(), strList, valList);
}
if (model.getExecutorRelationModifyFlag()) {
StringUtil.makeDynaParam(
"EXECUTOR_RELATION", convertSQL(model.getExecutorRelation()), strList, valList);
}
if (model.getExecutorsMethodModifyFlag()) {
StringUtil.makeDynaParam(
"EXECUTORS_METHOD", convertSQL(model.getExecutorsMethod()), strList, valList);
}
if (model.getNumberOrPercentModifyFlag()) {
StringUtil.makeDynaParam(
"NUMBER_OR_PERCENT", convertSQL(model.getNumberOrPercent()), strList, valList);
}
if (model.getPassValueModifyFlag()) {
StringUtil.makeDynaParam("PASS_VALUE", model.getPassValue(), strList, valList);
}
if (model.getExpressionModifyFlag()) {
StringUtil.makeDynaParam("EXPRESSION", convertSQL(model.getExpression()), strList, valList);
}
if (model.getDefaultPathModifyFlag()) {
StringUtil.makeDynaParam(
"DEFAULT_PATH", convertSQL(model.getDefaultPath()), strList, valList);
}
if (model.getActionNameModifyFlag()) {
StringUtil.makeDynaParam("ACTION_NAME", convertSQL(model.getActionName()), strList, valList);
}
String insertString = "";
String valsString = "";
int length = strList.size();
if (length == 0) {
insertString = null;
valsString = null;
} else {
for (int i = 0; i <= length - 1; i++) {
insertString += strList.get(i) + ",";
valsString += "?,";
}
insertString = insertString.substring(0, insertString.length() - 1);
valsString = valsString.substring(0, valsString.length() - 1);
}
sql = "insert into WF_LINK(" + insertString + ") values(" + valsString + ")";
DBHelper.executeUpdate(sql, valList.toArray());
logger.info(sql);
return 1;
}