com.adventnet.snmp.mibs.agent
Class JDBCAdapter

java.lang.Object
  com.adventnet.snmp.mibs.agent.JDBCAdapter

public class JDBCAdapter
extends java.lang.Object

Field Summary

(package private) java.lang.String[]	columnNames
(package private) java.sql.Connection	connection
(package private) java.lang.String	driverName
(package private) java.util.Vector	listeners
(package private) java.sql.ResultSetMetaData	metaData
(package private) java.lang.String	password
(package private) java.sql.ResultSet	resultSet
(package private) java.util.Vector	rows
java.lang.String	sqlquery
(package private) java.sql.Statement	statement
(package private) java.lang.String	url
(package private) java.lang.String[]	urlList
(package private) java.lang.String	userName

Constructor Summary

JDBCAdapter()

JDBCAdapter(java.lang.String url, java.lang.String drivername, java.lang.String username, java.lang.String password)

Method Summary

void	close()
java.lang.String	dbRepresentation(int column, java.lang.Object value)
void	executeNonUiQuery(java.lang.String query)
void	executeQuery()
void	executeQuery(java.lang.String query)
void	executeQuery(java.util.Vector queries)
protected void	finalize()
int	getColumnCount()
java.lang.String	getColumnName(int column)
java.sql.Connection	getConnection()
java.lang.String	getDriverName() Get the driverName
java.lang.String	getPassword() Get the password
int	getRowCount()
java.util.Vector	getRows() Remove a listener for events from this target.
java.lang.String	getSQLString()
java.lang.String	getUrl() Get the url
java.lang.String[]	getUrlList()
java.lang.String	getUserName() Get the userName
java.lang.Object	getValueAt(int aRow, int aColumn)
boolean	isCellEditable(int row, int column)
void	setDriverName(java.lang.String driver) Set the driverName
void	setPassword(java.lang.String passwd) Set the password
void	setUrl(java.lang.String urlstr) Set the url
void	setUrlList(java.lang.String[] s)
void	setUserName(java.lang.String user) Set the userName
void	setValueAt(java.lang.Object value, int row, int column)

Methods inherited from class java.lang.Object

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

Field Detail

connection

java.sql.Connection connection

statement

java.sql.Statement statement

resultSet

java.sql.ResultSet resultSet

columnNames

java.lang.String[] columnNames

rows

java.util.Vector rows

metaData

java.sql.ResultSetMetaData metaData

url

java.lang.String url

driverName

java.lang.String driverName

userName

java.lang.String userName

password

java.lang.String password

sqlquery

public java.lang.String sqlquery

listeners

java.util.Vector listeners

urlList

java.lang.String[] urlList

Constructor Detail

JDBCAdapter

public JDBCAdapter()

JDBCAdapter

public JDBCAdapter(java.lang.String url,
                   java.lang.String drivername,
                   java.lang.String username,
                   java.lang.String password)

Method Detail

getConnection

public java.sql.Connection getConnection()

getDriverName

public java.lang.String getDriverName()

Get the driverName

setDriverName

public void setDriverName(java.lang.String driver)

Set the driverName

getUrl

public java.lang.String getUrl()

Get the url

setUrl

public void setUrl(java.lang.String urlstr)

Set the url

getUrlList

public java.lang.String[] getUrlList()

setUrlList

public void setUrlList(java.lang.String[] s)

getUserName

public java.lang.String getUserName()

Get the userName

setUserName

public void setUserName(java.lang.String user)

Set the userName

getPassword

public java.lang.String getPassword()

Get the password

setPassword

public void setPassword(java.lang.String passwd)

Set the password

executeQuery

public void executeQuery(java.lang.String query)

executeQuery

public void executeQuery()

executeQuery

public void executeQuery(java.util.Vector queries)

executeNonUiQuery

public void executeNonUiQuery(java.lang.String query)

close

public void close()
           throws java.sql.SQLException

Throws:

java.sql.SQLException

finalize

protected void finalize()
                 throws java.lang.Throwable

Overrides:

finalize in class java.lang.Object

Throws:

java.lang.Throwable

getColumnName

public java.lang.String getColumnName(int column)

isCellEditable

public boolean isCellEditable(int row,
                              int column)

getColumnCount

public int getColumnCount()

getRowCount

public int getRowCount()

getValueAt

public java.lang.Object getValueAt(int aRow,
                                   int aColumn)

dbRepresentation

public java.lang.String dbRepresentation(int column,
                                         java.lang.Object value)

setValueAt

public void setValueAt(java.lang.Object value,
                       int row,
                       int column)

getRows

public java.util.Vector getRows()

Remove a listener for events from this target.

getSQLString

public java.lang.String getSQLString()