Package de.mctzock.javamysql

Class MySQL

java.lang.Object

de.mctzock.javamysql.MySQL

public class MySQL
extends Object

Constructor Summary

Constructors

Constructor	Description
MySQL(String sql, String host, String port, String username, String password, String database, String additionalConnectionParameters)

Method Summary

Modifier and Type	Method	Description
void	close()	Close connection and disconnect from database.
ResultSet	executeQuery()
void	executeUpdate()	Execute Update with the given sql string.
String	getAdditionalConnectionParameters()
String	getConnectionString()
String	getDatabase()
String	getHost()
String	getPassword()
String	getPort()
String	getSql()
String	getUsername()

Methods inherited from class java.lang.Object

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

Constructor Detail

MySQL

public MySQL(String sql,
             String host,
             String port,
             String username,
             String password,
             String database,
             String additionalConnectionParameters)

Parameters:

sql - Your SQL query

Method Detail

executeQuery

public ResultSet executeQuery()

Returns:

The result of the query or null.

executeUpdate

public void executeUpdate()

Execute Update with the given sql string.

close

public void close()

Close connection and disconnect from database. Attention! ResultSets can't be used after this method is called.

getConnectionString

public String getConnectionString()

Returns:

Connection URL to database.

getSql

public String getSql()

Returns:

The given sql string.

getHost

public String getHost()

Returns:

The given host string.

getPort

public String getPort()

Returns:

The given port string.

getDatabase

public String getDatabase()

Returns:

The given database string.

getUsername

public String getUsername()

Returns:

The given username string.

getPassword

public String getPassword()

Returns:

The given password string.

getAdditionalConnectionParameters

public String getAdditionalConnectionParameters()

Returns:

The given addition parameters string.