Java Utililty Methods SQL ResultSet Close

List of utility methods to do SQL ResultSet Close

HOME
Java
S
SQL ResultSet Close

Description

The list of methods to do SQL ResultSet Close are organized into topic(s).

Method

void close(Connection c, Statement s, ResultSet r)
close

try {
 if (r != null)
 r.close();
} catch (Exception e) {
 e.printStackTrace();
try {
 if (s != null)
...

void close(Connection con, Statement stmt, ResultSet rs)
close

if (rs != null) {
 try {
 rs.close();
 } catch (SQLException e) {
 System.out.println("5--SQLException");
 e.printStackTrace();
if (stmt != null) {
 try {
 stmt.close();
 } catch (SQLException e) {
 System.out.println("6-SQLException");
 e.printStackTrace();
if (con != null) {
 try {
 con.close();
 } catch (SQLException e) {
 System.out.println("7-closeSQLException");
 e.printStackTrace();

void close(Connection conn, PreparedStatement ps, ResultSet rs)
close

if (rs != null) {
 try {
 rs.close();
 } catch (SQLException e) {
 e.printStackTrace();
if (ps != null) {
...

void close(Connection conn, Statement st, ResultSet rs)
close

try {
 if (rs != null)
 rs.close();
 else if (st != null)
 st.close();
 else if (conn != null)
 conn.close();
} catch (SQLException e) {
...

void close(Connection conn, Statement st, ResultSet rs)
close

try {
 if (rs != null) {
 rs.close();
 if (st != null) {
 st.close();
 if (conn != null) {
...

void close(Connection connection, PreparedStatement statement, ResultSet resultSet)
close dataSource

if (null != resultSet) {
 try {
 resultSet.close();
 } catch (SQLException e) {
 System.err.println("close resultset error!");
if (null != statement) {
...

void close(Connection connection, Statement statement, ResultSet resultSet)
close

if (resultSet != null) {
 resultSet.close();
if (statement != null) {
 statement.close();
if (connection != null) {
 connection.close();
...

void close(final PreparedStatement ps, final ResultSet rs)
close

closePS(ps);
closeRS(rs);

void close(final ResultSet rs, final Statement st)
close

if (rs != null) {
 try {
 rs.close();
 } catch (Throwable e) {
 e.printStackTrace();
if (st != null) {
...

void close(ResultSet _rsData, Logger _logger)
Closes a result set

if (_rsData == null)
 return;
try {
 _rsData.close();
} catch (Exception ex) {
 if (_logger == null) {
 ex.printStackTrace(System.err);
 } else {
...