org.semanticweb.ruqar.db

Class DBAccess

java.lang.Object

org.semanticweb.ruqar.db.DBAccess

public class DBAccess
extends java.lang.Object

Constructor Summary

Constructors

Constructor and Description
DBAccess()

Method Summary

Methods

Modifier and Type	Method and Description
void	closeConnection() Function closes the database connection.
boolean	connInitialize(java.lang.String IP, java.lang.String Port, java.lang.String user, java.lang.String password) Function connects to the server of relational databases.
boolean	connInitialize(java.lang.String IP, java.lang.String Port, java.lang.String user, java.lang.String password, java.lang.String databaseName) Function connects to the concrete relational Database.
java.sql.Connection	dbConn(java.lang.String IP, java.lang.String Port, java.lang.String user, java.lang.String password) Function connects to the relational Database.
java.sql.Connection	dbConn(java.lang.String IP, java.lang.String Port, java.lang.String user, java.lang.String password, java.lang.String databaseName) Function connects to the relational Database.
void	examplePrint(java.lang.String[] tab)
java.sql.Connection	getConnection() This function returns the current connection to database.
static void	main(java.lang.String[] args)
void	printAnswers(java.util.List<javax.sql.rowset.CachedRowSet> sets) Prints results on a standard output (console).
void	printAnswers(java.sql.ResultSet set) This function prints SQL query results on console.
java.util.List<java.lang.String[]>	readColumnsFromTable(java.lang.String databaseName, java.lang.String tableName) Function reads columns and their types from relational database.
java.util.List<java.lang.String[]>	readDBTables(java.lang.String databaseName) Function reads Tables in relational Database.
java.util.List<java.lang.String>	readServerDatabases() Function reads Database Schema relational Database.
java.util.List<javax.sql.rowset.CachedRowSet>	runSQLCommand(java.sql.Connection conn, java.util.List<java.lang.String> queries) This function runs SQL query on database.
java.util.List<javax.sql.rowset.CachedRowSet>	runSQLCommand(java.sql.Connection conn, java.lang.String query) This function runs SQL query on database.
java.util.List<javax.sql.rowset.CachedRowSet>	runSQLCommand(java.util.List<java.lang.String> queries) This function runs SQL query or queries on database.
java.util.List<javax.sql.rowset.CachedRowSet>	runSQLCommand(java.lang.String query) This function runs SQL query or queries on database.
java.util.List<java.lang.String>	runSQLProcedure(java.lang.String procName, java.util.List<java.lang.String> parametersIn, java.util.List<java.lang.Integer> parametersOutType) This function runs SQL procedure on SQL Server.
void	setConnection(java.sql.Connection conn) This function sets the connection to the database.

Methods inherited from class java.lang.Object

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

Constructor Detail

DBAccess

public DBAccess()

Method Detail

closeConnection

public void closeConnection()

Function closes the database connection.

connInitialize

public boolean connInitialize(java.lang.String IP,
                     java.lang.String Port,
                     java.lang.String user,
                     java.lang.String password)

Function connects to the server of relational databases. Currently only MSSQL Server is available. Connection at IPPort variable, example: localhost:1433

Parameters:

IPPort - the iP port

user - the user

password - the password

Returns:

true, if successful

connInitialize

public boolean connInitialize(java.lang.String IP,
                     java.lang.String Port,
                     java.lang.String user,
                     java.lang.String password,
                     java.lang.String databaseName)

Function connects to the concrete relational Database. Currently only MSSQL Server is available. Connection at IPPort variable, example: localhost:1433 This function must be used when you want to execute the query.

Parameters:

IP - the IP of the server

Port - port of the server

user - the user

password - the password

databaseName - the database name

Returns:

true, if successful

dbConn

public java.sql.Connection dbConn(java.lang.String IP,
                         java.lang.String Port,
                         java.lang.String user,
                         java.lang.String password)

Function connects to the relational Database. Currently only MSSQL Server is available. Connection at IPPort variable. For example: localhost:1433, sa, sa

Parameters:

IPPort - the iP port

user - the user

password - the password

Returns:

the connection

dbConn

public java.sql.Connection dbConn(java.lang.String IP,
                         java.lang.String Port,
                         java.lang.String user,
                         java.lang.String password,
                         java.lang.String databaseName)

Function connects to the relational Database. Currently only MSSQL Server is available. Connection at IPPort variable. For example: localhost:1433, sa, sa

Parameters:

IPPort - the iP port

user - the user

password - the password

databaseName - the database name

Returns:

the connection

examplePrint

public void examplePrint(java.lang.String[] tab)

getConnection

public java.sql.Connection getConnection()

This function returns the current connection to database.

Returns:

the connection

main

public static void main(java.lang.String[] args)

printAnswers

public void printAnswers(java.util.List<javax.sql.rowset.CachedRowSet> sets)

Prints results on a standard output (console).

Parameters:

sets -

printAnswers

public void printAnswers(java.sql.ResultSet set)

This function prints SQL query results on console.

Parameters:

set - the set

readColumnsFromTable

public java.util.List<java.lang.String[]> readColumnsFromTable(java.lang.String databaseName,
                                                      java.lang.String tableName)

Function reads columns and their types from relational database. Name of the DB and table name is required. Currently only MSSQL Server is available.

Parameters:

databaseName - the database name

tableName - the table name

Returns:

the list

readDBTables

public java.util.List<java.lang.String[]> readDBTables(java.lang.String databaseName)

Function reads Tables in relational Database. Name of the DB is required. Currently only MSSQL Server is available.

Parameters:

databaseName - the database name

Returns:

the list

readServerDatabases

public java.util.List<java.lang.String> readServerDatabases()

Function reads Database Schema relational Database. Currently only MSSQL Server is available.

Returns:

the list

runSQLCommand

public java.util.List<javax.sql.rowset.CachedRowSet> runSQLCommand(java.sql.Connection conn,
                                                          java.util.List<java.lang.String> queries)

This function runs SQL query on database. Currently only MSSQL Server is available.

Parameters:

conn - the conn

query - the query

Returns:

the result set

runSQLCommand

public java.util.List<javax.sql.rowset.CachedRowSet> runSQLCommand(java.sql.Connection conn,
                                                          java.lang.String query)

This function runs SQL query on database. Currently only MSSQL Server is available.

Parameters:

conn - the conn

query - the query

Returns:

the result set

runSQLCommand

public java.util.List<javax.sql.rowset.CachedRowSet> runSQLCommand(java.util.List<java.lang.String> queries)

This function runs SQL query or queries on database. Currently only MSSQL Server is available.

Parameters:

query - the query

Returns:

the result set

runSQLCommand

public java.util.List<javax.sql.rowset.CachedRowSet> runSQLCommand(java.lang.String query)

This function runs SQL query or queries on database. Currently only MSSQL Server is available.

Parameters:

query - the query

Returns:

the result set

runSQLProcedure

public java.util.List<java.lang.String> runSQLProcedure(java.lang.String procName,
                                               java.util.List<java.lang.String> parametersIn,
                                               java.util.List<java.lang.Integer> parametersOutType)

This function runs SQL procedure on SQL Server.

Parameters:

procName - the proc name

parametersIn - the parameters in

parametersOutType - the parameters out type

Returns:

the list

setConnection

public void setConnection(java.sql.Connection conn)

This function sets the connection to the database.

Parameters:

conn - the new connection