SQLConnection

java.lang.Object
- com.ibm.as400.vaccess.SQLConnection

All Implemented Interfaces:

java.io.Serializable

Deprecated.
Use Java Swing instead, along with the classes in package com.ibm.as400.access
```
public class SQLConnection
extends java.lang.Object
implements java.io.Serializable
```
SQLConnection objects represent a SQL Connection. A SQLConnection object encapsulates the properties needed to make a JDBC Connection into a Java Bean. A connection can only be made once. Once a connection is closed, it cannot be opened again.
The actual connection is made when getConnection() is called.
Users should call close() when the connection is no longer needed.
Properties cannot be changed once a connection is made.
Note that the password is not serialized if it is provided by the password parameter on the constructor or setPassword(), or if it is provided using the 'password' property in the constructor 'properties' parameter or using setProperties(). If the password is supplied via the URL or other property, it will be serialized.
SQLConnection objects generate the following events:
- PropertyChangeEvent
- WorkingEvent
See Also:
Serialized Form

Constructor Summary

Constructors
Constructor and Description
`SQLConnection()` Deprecated. Creates a SQLConnection object.
`SQLConnection(java.lang.String URL)` Deprecated. Creates a SQLConnection object.
`SQLConnection(java.lang.String URL, java.util.Properties properties)` Deprecated. Creates a SQLConnection object.
`SQLConnection(java.lang.String URL, java.lang.String userName)` Deprecated. Creates a SQLConnection object.
`SQLConnection(java.lang.String URL, java.lang.String userName, java.lang.String password)` Deprecated. Creates a SQLConnection object.

Method Summary

Methods
Modifier and Type	Method and Description
`void`	`addPropertyChangeListener(java.beans.PropertyChangeListener listener)` Deprecated. Adds a listener to be notified when the value of any bound property is changed.
`void`	`addVetoableChangeListener(java.beans.VetoableChangeListener listener)` Deprecated. Adds a listener to be notified when the value of any constrained property is changed.
`void`	`addWorkingListener(WorkingListener listener)` Deprecated. Adds a listener to be notified when work starts and stops on potentially long-running operations.
`void`	`close()` Deprecated. Closes the SQL connection, if it is open.
`java.sql.Connection`	`getConnection()` Deprecated. Returns a JDBC connection.
`java.util.Properties`	`getProperties()` Deprecated. Returns the properties for this connection.
`java.lang.String`	`getURL()` Deprecated. Returns the URL for this connection.
`java.lang.String`	`getUserName()` Deprecated. Returns the user name for this connection.
`void`	`removePropertyChangeListener(java.beans.PropertyChangeListener listener)` Deprecated. Removes a listener from being notified when the value of any bound property is changed.
`void`	`removeVetoableChangeListener(java.beans.VetoableChangeListener listener)` Deprecated. Removes a listener from being notified when the value of any constrained property is changed.
`void`	`removeWorkingListener(WorkingListener listener)` Deprecated. Removes a listener from being notified when work starts and stops on potentially long-running operations.
`void`	`setPassword(java.lang.String password)` Deprecated. Sets the password used to connect to the database.
`void`	`setProperties(java.util.Properties properties)` Deprecated. Sets the properties used to connect to the database.
`void`	`setURL(java.lang.String URL)` Deprecated. Sets the URL used to connect to the database.
`void`	`setUserName(java.lang.String userName)` Deprecated. Sets the user name used to connect to the database.

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Constructor Detail
  - SQLConnection
```
public SQLConnection()
```
    Deprecated.
    
    Creates a SQLConnection object.
  - SQLConnection
```
public SQLConnection(java.lang.String URL)
```
    Deprecated.
    
    Creates a SQLConnection object.
    
    Parameters:
    URL - The URL used to connect to the database.
  - SQLConnection
```
public SQLConnection(java.lang.String URL,
             java.lang.String userName)
```
    Deprecated.
    
    Creates a SQLConnection object.
    
    Parameters:
    URL - The URL used to connect to the database.
    userName - The user name used to connect to the database.
  - SQLConnection
```
public SQLConnection(java.lang.String URL,
             java.lang.String userName,
             java.lang.String password)
```
    Deprecated.
    
    Creates a SQLConnection object.
    
    Parameters:
    URL - The URL used to connect to the database.
    userName - The user name used to connect to the database.
    password - The password used to connect to the database.
  - SQLConnection
```
public SQLConnection(java.lang.String URL,
             java.util.Properties properties)
```
    Deprecated.
    
    Creates a SQLConnection object.
    
    Parameters:
    URL - The URL used to connect to the database.
    properties - The properties used to connect to the database.
- Method Detail
  - addPropertyChangeListener
```
public void addPropertyChangeListener(java.beans.PropertyChangeListener listener)
```
    Deprecated.
    
    Adds a listener to be notified when the value of any bound property is changed. The listener's propertyChange() method will be called.
    
    Parameters:
    listener - The listener.
  - addVetoableChangeListener
```
public void addVetoableChangeListener(java.beans.VetoableChangeListener listener)
```
    Deprecated.
    
    Adds a listener to be notified when the value of any constrained property is changed. The listener's vetoableChange() method will be called.
    
    Parameters:
    listener - The listener.
  - addWorkingListener
```
public void addWorkingListener(WorkingListener listener)
```
    Deprecated.
    
    Adds a listener to be notified when work starts and stops on potentially long-running operations.
    
    Parameters:
    listener - The listener.
  - close
```
public void close()
           throws java.sql.SQLException
```
    Deprecated.
    
    Closes the SQL connection, if it is open. Once a connection is closed, it cannot be opened again.
    
    Throws:
    
    java.sql.SQLException - If there is an error closing the connection.
  - getConnection
```
public java.sql.Connection getConnection()
                                  throws java.sql.SQLException
```
    Deprecated.
    
    Returns a JDBC connection. If a successful connection has not yet been made, a new connection will be made. Subsequent invocations will reuse the connection. It is up to the user to close the connection, or allow garbage collection to do so.
    
    Returns:
    The connection.
    
    Throws:
    
    java.sql.SQLException - If there is an error connecting to the database.
  - getProperties
```
public java.util.Properties getProperties()
```
    Deprecated.
    
    Returns the properties for this connection. This method will return the properties as set by the constructor or the last setProperties() call, minus the 'password' property, if included.
    
    Returns:
    The properties for this connection.
  - getURL
```
public java.lang.String getURL()
```
    Deprecated.
    
    Returns the URL for this connection. If a connection has not yet been made, this method will return the URL supplied on the constructor or the last setURL() call. If a connection has been made, the URL will be the URL for the connection.
    
    Returns:
    The URL for this connection.
  - getUserName
```
public java.lang.String getUserName()
```
    Deprecated.
    
    Returns the user name for this connection. If a connection has not yet been made, this method will return the user name supplied on the constructor or the last setUserName() call. If a connection has been made, the user name will be the user name being used for the connection.
    
    Returns:
    The user name for this connection.
  - removePropertyChangeListener
```
public void removePropertyChangeListener(java.beans.PropertyChangeListener listener)
```
    Deprecated.
    
    Removes a listener from being notified when the value of any bound property is changed.
    
    Parameters:
    listener - The listener.
  - removeVetoableChangeListener
```
public void removeVetoableChangeListener(java.beans.VetoableChangeListener listener)
```
    Deprecated.
    
    Removes a listener from being notified when the value of any constrained property is changed.
    
    Parameters:
    listener - The listener.
  - removeWorkingListener
```
public void removeWorkingListener(WorkingListener listener)
```
    Deprecated.
    
    Removes a listener from being notified when work starts and stops on potentially long-running operations.
    
    Parameters:
    listener - The listener.
  - setPassword
```
public void setPassword(java.lang.String password)
                 throws java.beans.PropertyVetoException
```
    Deprecated.
    
    Sets the password used to connect to the database. This property cannot be changed after a connection is made by calling getConnection(). This property is bound and constrained. The events will always have null and an empty string for the old and new value, respectively.
    
    Parameters:
    password - The password used to connect to the database.
    
    Throws:
    
    java.beans.PropertyVetoException - If the change is vetoed.
  - setProperties
```
public void setProperties(java.util.Properties properties)
                   throws java.beans.PropertyVetoException
```
    Deprecated.
    
    Sets the properties used to connect to the database. This property cannot be changed after a connection is made by calling getConnection(). This property is bound and constrained.
    
    Parameters:
    properties - The properties used to connect to the database.
    
    Throws:
    
    java.beans.PropertyVetoException - If the change is vetoed.
  - setURL
```
public void setURL(java.lang.String URL)
            throws java.beans.PropertyVetoException
```
    Deprecated.
    
    Sets the URL used to connect to the database. This property cannot be changed after a connection is made by calling getConnection(). This property is bound and constrained.
    
    Parameters:
    URL - The URL used to connect to the database.
    
    Throws:
    
    java.beans.PropertyVetoException - If the change is vetoed.
  - setUserName
```
public void setUserName(java.lang.String userName)
                 throws java.beans.PropertyVetoException
```
    Deprecated.
    
    Sets the user name used to connect to the database. This property cannot be changed after a connection is made by calling getConnection(). This property is bound and constrained.
    
    Parameters:
    userName - The user name used to connect to the database.
    
    Throws:
    
    java.beans.PropertyVetoException - If the change is vetoed.

Methods inherited from class java.lang.Object

SQLConnection

SQLConnection

SQLConnection

SQLConnection

SQLConnection

addPropertyChangeListener

addVetoableChangeListener

addWorkingListener

close

getConnection

getProperties

getURL

getUserName

removePropertyChangeListener

removeVetoableChangeListener

removeWorkingListener

setPassword

setProperties

setURL

setUserName