database

Class ExecuteCommand

java.lang.Object

database.ExecuteCommand

public class ExecuteCommand
extends java.lang.Object

Method Summary

Methods

Modifier and Type	Method and Description
void	closeConnection()
int	executeInsert(java.lang.String query, java.util.List<SqlParameter> parameters)
boolean	executeNonQuery(java.lang.String query, java.util.List<SqlParameter> parameters)
java.sql.ResultSet	executeSelect(java.lang.String query)
java.sql.ResultSet	executeSelect(java.lang.String query, boolean scrollable)
java.sql.ResultSet	executeSelect(java.lang.String query, java.util.List<SqlParameter> parameters)
java.sql.ResultSet	executeSelect(java.lang.String query, SqlParameter parameter)
java.sql.ResultSet	executeSelect(java.lang.String query, SqlParameter parameter, boolean scrollable)
static ExecuteCommand	getInstance()
void	openConnection()
void	testConnection()

Methods inherited from class java.lang.Object

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

Method Detail

getInstance

public static ExecuteCommand getInstance()

testConnection

public void testConnection()
                    throws java.sql.SQLException

Throws:

java.sql.SQLException

openConnection

public void openConnection()

closeConnection

public void closeConnection()

executeNonQuery

public boolean executeNonQuery(java.lang.String query,
                      java.util.List<SqlParameter> parameters)
                        throws java.sql.SQLException

Throws:

java.sql.SQLException

executeInsert

public int executeInsert(java.lang.String query,
                java.util.List<SqlParameter> parameters)
                  throws java.sql.SQLException

Throws:

java.sql.SQLException

executeSelect

public java.sql.ResultSet executeSelect(java.lang.String query,
                               java.util.List<SqlParameter> parameters)
                                 throws java.sql.SQLException

Throws:

java.sql.SQLException

executeSelect

public java.sql.ResultSet executeSelect(java.lang.String query,
                               SqlParameter parameter)
                                 throws java.sql.SQLException

Throws:

java.sql.SQLException

executeSelect

public java.sql.ResultSet executeSelect(java.lang.String query,
                               SqlParameter parameter,
                               boolean scrollable)
                                 throws java.sql.SQLException

Throws:

java.sql.SQLException

executeSelect

public java.sql.ResultSet executeSelect(java.lang.String query)
                                 throws java.sql.SQLException

Throws:

java.sql.SQLException

executeSelect

public java.sql.ResultSet executeSelect(java.lang.String query,
                               boolean scrollable)
                                 throws java.sql.SQLException

Throws:

java.sql.SQLException