public void close()
    {
            if (rs != null) {
                    try {
                            rs.close();
                    } catch (SQLException ex) { /* ignore */
                    }
                    rs = null;
            }
            if (stmt != null) {
                    try {
                            stmt.close();
                    } catch (SQLException ex) { /* ignore */
                    }
                    stmt = null;
            }
            if (conn != null) {
                    try {
                            conn.close();
                    } catch (SQLException ex) { /* ignore */
                    }
                    conn = null;
            }
    }