public static void destroy() { for (HulkInterceptor interceptor : interceptors) { interceptor.destroy(); } datasource.destroy(); bam.destroy(); }
@Override public int updateBusinessActivityState(String businessActivityIds, BusinessActivityStatus businessActivityStatus) throws SQLException { String sql = "UPDATE tm_business_activity_log SET businessActivityStatus = ? " + "WHERE isDeleted = 0 and businessActivityId = ?"; try (PreparedStatement ptmt = dataSource.prepareStatement(sql)) { ptmt.setInt(1, businessActivityStatus.getCode()); ptmt.setString(2, businessActivityIds); int rsCount = ptmt.executeUpdate(); if (rsCount > 0) { return rsCount; } return 0; } catch (Exception e) { throw e; } }
@Override public int remove(List<String> businessActivityIds) throws SQLException { String sql = "UPDATE tm_business_activity_log SET isDeleted = 1 " + "WHERE isDeleted = 0 and businessActivityId in (" + transListString(businessActivityIds) + ") "; try (PreparedStatement ptmt = dataSource.prepareStatement(sql)) { int index = 1; for (String businessActivityId : businessActivityIds) { ptmt.setString(index++, businessActivityId); } int rsCount = ptmt.executeUpdate(); if (rsCount > 0) { return rsCount; } return 0; } catch (Exception e) { throw e; } }
@Override public boolean writeEx(BusinessActivityException ex) throws SQLException { if (null == ex) { return false; } String sql = "REPLACE INTO tm_business_activity_exception_log(businessActivityId,exceptionContent) " + "VALUES (?, ?)"; try (PreparedStatement ptmt = dataSource.prepareStatement(sql)) { ptmt.setString(1, getBusinessActivityIdStr(ex.getId())); ptmt.setString(2, ex.getException()); if (ptmt.executeUpdate() > 0) { return true; } return false; } catch (Exception e) { throw e; } }
"FROM tm_business_activity_log " + "WHERE isDeleted = 0 and businessActivityStatus in ('8', '9') limit ?"; try (PreparedStatement ptmt = dataSource.prepareStatement(sql)) { ptmt.setInt(1, size); ResultSet resultSet = ptmt.executeQuery();
PreparedStatement ptmt = null; try { ptmt = dataSource.prepareStatement(sql); for (HulkContext ctx : ctxs) { if (ctx == null) {
"FROM tm_business_activity_log " + "WHERE isDeleted = 0 and businessActivityStatus in ('8', '9') and businessActivityId in (?)"; try (PreparedStatement ptmt = dataSource.prepareStatement(sql)) { String businessActivityIdStr = getBusinessActivityIdStr(businessActivityId); ptmt.setString(1, businessActivityIdStr);