info.bioinfweb.commons.servlet

Class SQLManipulator

java.lang.Object

info.bioinfweb.commons.servlet.SQLManipulator

public class SQLManipulator
extends java.lang.Object

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	MYSQL_DRIVER

Constructor Summary

Constructors

Constructor and Description
SQLManipulator(java.lang.String dbHost, java.lang.String dbName, java.lang.String dbUser, java.lang.String dbPassword)

Method Summary

Modifier and Type	Method and Description
int	deleteFromDB(java.lang.String table, java.lang.String column, java.lang.String value)
void	disconnect()
java.sql.Connection	getConnection()
java.sql.Statement	getStatement()
int	insertIntoDB(java.lang.String table, java.lang.Object[] values) Inserts a new entry in a databse table.
int	insertIntoDB(java.lang.String table, java.lang.String[] names, java.lang.Object[] values) Inserts a new entry in a database table
boolean	isConntected()
java.sql.ResultSet	readFromDB(java.lang.String table, int entryNo)
java.sql.ResultSet	readFromDB(java.lang.String returnColumn, java.lang.String table, int entryNo)
java.sql.ResultSet	readFromDB(java.lang.String table, java.lang.String selectionColumn, java.lang.String value)
java.sql.ResultSet	readFromDB(java.lang.String returnColumn, java.lang.String table, java.lang.String selectionColumn, java.lang.String value)
int	updateDBEntry(java.lang.String table, java.lang.String whereCond, java.lang.String[] names, java.lang.Object[] values) Updates several columns in the specified database entries.
int	updateDBEntry(java.lang.String table, java.lang.String whereCond, java.lang.String name, java.lang.String value) Updates one column in the specified database entries.
int	updateDBEntry(java.lang.String table, java.lang.String columnName, java.lang.String columnValue, java.lang.String[] names, java.lang.Object[] values) Updates several columns in the specified database entries.
int	updateDBEntry(java.lang.String table, java.lang.String columnName, java.lang.String columnValue, java.lang.String name, java.lang.String value) Updates one column in the specified database entries.

Methods inherited from class java.lang.Object

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

Field Detail

MYSQL_DRIVER

public static final java.lang.String MYSQL_DRIVER

See Also:

Constant Field Values

Constructor Detail

SQLManipulator

public SQLManipulator(java.lang.String dbHost,
                      java.lang.String dbName,
                      java.lang.String dbUser,
                      java.lang.String dbPassword)

Method Detail

isConntected

public boolean isConntected()

getStatement

public java.sql.Statement getStatement()
                                throws java.sql.SQLException

Throws:

java.sql.SQLException

getConnection

public java.sql.Connection getConnection()

disconnect

public void disconnect()
                throws java.sql.SQLException

Throws:

java.sql.SQLException

insertIntoDB

public int insertIntoDB(java.lang.String table,
                        java.lang.Object[] values)
                 throws java.sql.SQLException

Inserts a new entry in a databse table.

Parameters:

table - the table to insert the new entry

values - the values of the entry (the values have to have the same order as their columns have in the table)

Returns:

Throws:

java.sql.SQLException

insertIntoDB

public int insertIntoDB(java.lang.String table,
                        java.lang.String[] names,
                        java.lang.Object[] values)
                 throws java.sql.SQLException

Inserts a new entry in a database table

Parameters:

table - the table to insert the new entry

names - the column names

values - the values for the columns

Returns:

Throws:

java.sql.SQLException

updateDBEntry

public int updateDBEntry(java.lang.String table,
                         java.lang.String columnName,
                         java.lang.String columnValue,
                         java.lang.String name,
                         java.lang.String value)
                  throws java.sql.SQLException

Updates one column in the specified database entries.

Parameters:

table - the table which contains the entry

columnName - the name of the column by which the entry shall be identified

columnValue - the value of the column by which the entry shall be identified

name - the name of the column which shall be updated

value - the value which shall be placed in the specified column

Returns:

the count of columns updated

Throws:

java.sql.SQLException

updateDBEntry

public int updateDBEntry(java.lang.String table,
                         java.lang.String whereCond,
                         java.lang.String name,
                         java.lang.String value)
                  throws java.sql.SQLException

Updates one column in the specified database entries.

Parameters:

table - the table which contains the entry

whereCond - the condition placed after the WHERE-keyword in the SQL-query

name - the name of the column which shall be updated

value - the value which shall be placed in the specified column

Returns:

the count of columns updated

Throws:

java.sql.SQLException

updateDBEntry

public int updateDBEntry(java.lang.String table,
                         java.lang.String columnName,
                         java.lang.String columnValue,
                         java.lang.String[] names,
                         java.lang.Object[] values)
                  throws java.sql.SQLException

Updates several columns in the specified database entries.

Parameters:

table - the table which contains the entry

columnName - the name of the column by which the entry shall be identified

columnValue - the value of the column by which the entry shall be identified

names - a list of the names of the columns which shall be updated

values - a list of the values which shall be placed in the specified columns

Returns:

the count of columns updated

Throws:

java.sql.SQLException

updateDBEntry

public int updateDBEntry(java.lang.String table,
                         java.lang.String whereCond,
                         java.lang.String[] names,
                         java.lang.Object[] values)
                  throws java.sql.SQLException

Updates several columns in the specified database entries.

Parameters:

table - the table which contains the entry

whereCond - the condition placed after the WHERE-keyword in the SQL-query

names - a list of the names of the columns which shall be updated

values - a list of the values which shall be placed in the specified columns

Returns:

the count of columns updated

Throws:

java.sql.SQLException

deleteFromDB

public int deleteFromDB(java.lang.String table,
                        java.lang.String column,
                        java.lang.String value)
                 throws java.sql.SQLException

Throws:

java.sql.SQLException

readFromDB

public java.sql.ResultSet readFromDB(java.lang.String table,
                                     java.lang.String selectionColumn,
                                     java.lang.String value)
                              throws java.sql.SQLException

Throws:

java.sql.SQLException

readFromDB

public java.sql.ResultSet readFromDB(java.lang.String returnColumn,
                                     java.lang.String table,
                                     java.lang.String selectionColumn,
                                     java.lang.String value)
                              throws java.sql.SQLException

Throws:

java.sql.SQLException

readFromDB

public java.sql.ResultSet readFromDB(java.lang.String table,
                                     int entryNo)
                              throws java.sql.SQLException

Throws:

java.sql.SQLException

readFromDB

public java.sql.ResultSet readFromDB(java.lang.String returnColumn,
                                     java.lang.String table,
                                     int entryNo)
                              throws java.sql.SQLException

Throws:

java.sql.SQLException