try {
PreparedStatement check = conn.prepareStatement("select * from 'whitelist' where ip=?");
check.setString(1, ip.getHostAddress());
- ResultSet rs = check.executeQuery();
- return !rs.isAfterLast();
+ ResultSet rs = null;
+ boolean ret;
+ try {
+ rs = check.executeQuery();
+ ret = !rs.isAfterLast();
+ } finally { close(rs); }
+ return ret;
} catch (SQLException e) { throw new RuntimeException(e); }
}
check.setString(1, graylistAddress(ip));
check.setString(2, from);
check.setString(3, to);
- ResultSet rs = check.executeQuery();
- if (rs.isAfterLast()) return 0;
- return rs.getTimestamp(1).getTime();
+ ResultSet rs = null;
+ try {
+ rs = check.executeQuery();
+ if (rs.isAfterLast()) return 0;
+ return rs.getTimestamp(1).getTime();
+ } finally { close(rs); }
} catch (SQLException e) { throw new RuntimeException(e); }
}