uk.co.moonsit.database

Class DatabaseAccess

java.lang.Object

uk.co.moonsit.database.DatabaseAccess

public final class DatabaseAccess
extends Object

Constructor Summary

Constructors

Constructor and Description
DatabaseAccess()
DatabaseAccess(String driver, String url, String uname, String pword)

Method Summary

Methods

Modifier and Type	Method and Description
void	close()
void	closeStatement()
boolean	connect()
void	executeQuery(String sql)
int	executeUpdate(String sql)
Connection	getConn()
String	getDriver()
String	getErrorMsg()
String	getPword()
ResultSet	getResultSet(String sql)
String	getUname()
String	getUrl()
static void	main(String[] args)
void	setConn(Connection c)
void	setDriver(String d)
void	setPword(String p)
void	setUname(String u)
void	setUrl(String u)

Methods inherited from class java.lang.Object

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

Constructor Detail

DatabaseAccess

public DatabaseAccess()
               throws IOException,
                      ClassNotFoundException,
                      Exception

Throws:

IOException

ClassNotFoundException

Exception

DatabaseAccess

public DatabaseAccess(String driver,
              String url,
              String uname,
              String pword)
               throws IOException,
                      ClassNotFoundException,
                      Exception

Throws:

IOException

ClassNotFoundException

Exception

Method Detail

executeQuery

public void executeQuery(String sql)

getResultSet

public ResultSet getResultSet(String sql)

closeStatement

public void closeStatement()

executeUpdate

public int executeUpdate(String sql)
                  throws SQLException

Throws:

SQLException

getErrorMsg

public String getErrorMsg()

close

public void close()
           throws Exception

Throws:

Exception

getDriver

public String getDriver()

setDriver

public void setDriver(String d)

getUrl

public String getUrl()

setUrl

public void setUrl(String u)

getUname

public String getUname()

setUname

public void setUname(String u)

getPword

public String getPword()

setPword

public void setPword(String p)

getConn

public Connection getConn()

setConn

public void setConn(Connection c)

connect

public boolean connect()
                throws ClassNotFoundException

Throws:

ClassNotFoundException

main

public static void main(String[] args)

Parameters:

args - the command line arguments