com.partnersoft.io.sql

Class SQLConnection

java.lang.Object

com.partnersoft.io.sql.SQLConnection

public class SQLConnection
extends java.lang.Object

this class facilitates a connection with a data base via a jdbc driver. It will connect and disconect for you so you don't need to initialize, just start sending commands / querys

Author:

brad gray

Constructor Summary

Constructors

Constructor and Description
SQLConnection(java.lang.String driver, java.lang.String url, java.lang.String userName, java.lang.String password) note : on some systems, username and password may not be needed

Method Summary

Methods

Modifier and Type	Method and Description
java.sql.ResultSet	executeQuery(java.lang.String cmd) query, return a result set
boolean	executeStatement(java.lang.String cmd) a simple execute like drop or insert, no result set returned
java.lang.String	getDriver()
java.lang.String	getPassword()
java.lang.String	getURL()
java.lang.String	getUserName()
void	setDriver(java.lang.String newDriver)
void	setPassword(java.lang.String newPassword)
void	setURL(java.lang.String newURL)
void	setUserName(java.lang.String newName)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

SQLConnection

public SQLConnection(java.lang.String driver,
             java.lang.String url,
             java.lang.String userName,
             java.lang.String password)

note : on some systems, username and password may not be needed

Method Detail

executeStatement

public boolean executeStatement(java.lang.String cmd)
                         throws java.sql.SQLException

a simple execute like drop or insert, no result set returned

Throws:

java.sql.SQLException

executeQuery

public java.sql.ResultSet executeQuery(java.lang.String cmd)
                                throws java.sql.SQLException

query, return a result set

Throws:

java.sql.SQLException

getDriver

public java.lang.String getDriver()

setDriver

public void setDriver(java.lang.String newDriver)

getURL

public java.lang.String getURL()

setURL

public void setURL(java.lang.String newURL)

getUserName

public java.lang.String getUserName()

setUserName

public void setUserName(java.lang.String newName)

getPassword

public java.lang.String getPassword()

setPassword

public void setPassword(java.lang.String newPassword)