public LinkModel findByActivityKey(int nodeId, int nextNodeId) throws SQLException {
LinkModel model = new LinkModel();
String sql =
"select NODE_LINK_ID, NAME, DESCRIPTION, LINK_TYPE, "
+ "TEMPLATE_ID, CURRENT_NODE_ID, NEXT_NODE_ID, EXECUTOR_RELATION, "
+ "EXECUTORS_METHOD, NUMBER_OR_PERCENT, PASS_VALUE, EXPRESSION, "
+ "DEFAULT_PATH, ACTION_NAME from WF_LINK where CURRENT_NODE_ID=? AND NEXT_NODE_ID=?";
PreparedStatement st = null;
ResultSet rs = null;
Connection conn = null;
try {
conn = ConnectionFactory.getConnection();
st = conn.prepareStatement(sql);
st.setInt(1, nodeId);
st.setInt(1, nextNodeId);
rs = st.executeQuery();
if (rs.next()) {
model = parseResultSet(rs);
}
} catch (SQLException e) {
e.printStackTrace();
throw new SQLException(e.getMessage());
} finally {
DBHelper.closeConnection(conn, st, rs);
}
return model;
}
public ArrayList getFollowedLinkList(int theBegin, int theEnd, int templateId, int currentNodeId)
throws SQLException {
ArrayList list = new ArrayList();
String sql = "select * from wf_link where template_id = ? and current_node_id = ?";
PreparedStatement st = null;
ResultSet rs = null;
Connection conn = null;
try {
conn = ConnectionFactory.getConnection();
st = conn.prepareStatement(sql);
if (theEnd > 0) st.setFetchSize(theEnd);
st.setInt(1, templateId);
st.setInt(2, currentNodeId);
rs = st.executeQuery();
if (theBegin > 1) rs.absolute(theBegin - 1);
while (rs.next()) {
list.add(parseResultSet(rs));
if (rs.getRow() == theEnd) break;
}
} catch (SQLException e) {
e.printStackTrace();
throw new SQLException(e.getMessage());
} finally {
DBHelper.closeConnection(conn, st, rs);
}
return list;
}
public ArrayList find(int theBegin, int theEnd) throws SQLException {
ArrayList list = new ArrayList();
String sql =
"select NODE_LINK_ID, NAME, DESCRIPTION, LINK_TYPE, TEMPLATE_ID, CURRENT_NODE_ID, NEXT_NODE_ID, EXECUTOR_RELATION, EXECUTORS_METHOD, NUMBER_OR_PERCENT, PASS_VALUE, EXPRESSION, DEFAULT_PATH, ACTION_NAME from WF_LINK";
PreparedStatement st = null;
ResultSet rs = null;
Connection conn = null;
try {
conn = ConnectionFactory.getConnection();
st = conn.prepareStatement(sql);
if (theEnd > 0) st.setFetchSize(theEnd);
rs = st.executeQuery();
if (theBegin > 1) rs.absolute(theBegin - 1);
while (rs.next()) {
list.add(parseResultSet(rs));
if (rs.getRow() == theEnd) break;
}
} catch (SQLException e) {
e.printStackTrace();
throw new SQLException(e.getMessage());
} finally {
DBHelper.closeConnection(conn, st, rs);
}
return list;
}
public void removeByTemplate(int templateId) throws SQLException {
String sql = "delete from wf_link where template_id = ?";
PreparedStatement st = null;
Connection conn = null;
try {
conn = ConnectionFactory.getConnection();
st = conn.prepareStatement(sql);
st.setInt(1, templateId);
st.executeUpdate();
logger.info(sql);
} catch (SQLException e) {
e.printStackTrace();
throw new SQLException(e.getMessage());
} finally {
DBHelper.closeConnection(conn, st, null);
}
}
public void delete(int nodeLinkId) throws SQLException {
String sql = "delete from WF_LINK where NODE_LINK_ID=?";
PreparedStatement st = null;
Connection conn = null;
try {
conn = ConnectionFactory.getConnection();
st = conn.prepareStatement(sql);
st.setInt(1, nodeLinkId);
st.executeUpdate();
logger.info(sql);
} catch (SQLException e) {
e.printStackTrace();
throw new SQLException(e.getMessage());
} finally {
DBHelper.closeConnection(conn, st, null);
}
}
public void removeDefaultPath(int currentNodeId) throws SQLException {
String sql =
"update wf_link set default_path='0' where current_node_id = ? and default_path='1'";
PreparedStatement st = null;
Connection conn = null;
try {
conn = ConnectionFactory.getConnection();
st = conn.prepareStatement(sql);
st.setInt(1, currentNodeId);
st.executeUpdate();
logger.info(sql);
} catch (SQLException e) {
e.printStackTrace();
throw new SQLException(e.getMessage());
} finally {
DBHelper.closeConnection(conn, st, null);
}
}