dev.ursinn.java.databaselib.sql

Interface ISql

All Known Implementing Classes:

MySql, PostgreSql, Sql, SqLite

public interface ISql

SQL Database Interface

Since:

1.0

Version:

1.0

Author:

Ursin Filli

Method Summary

Modifier and Type	Method and Description
void	close() Close Connection to Database
void	connect() Connect to Database
java.sql.ResultSet	get(java.lang.String sql) Return Data from Database
boolean	isConnected() Check if a Database Connection Exists
int	update(java.lang.String sql) Execute SQL on Database
long	updateId(java.lang.String sql) Execute SQL on Database and Return Id of new Row

Method Detail

connect

void connect()
      throws java.sql.SQLException

Connect to Database

Throws:

java.sql.SQLException - in Case of Error

Since:

1.0

close

void close()
    throws java.sql.SQLException

Close Connection to Database

Throws:

java.sql.SQLException - in Case of Error

Since:

1.0

isConnected

boolean isConnected()
             throws java.sql.SQLException

Check if a Database Connection Exists

Returns:

Status of Connection

Throws:

java.sql.SQLException - in Case of Error

Since:

1.0

update

int update(java.lang.String sql)
    throws java.sql.SQLException

Execute SQL on Database

Parameters:

sql - SQL to Execute

Returns:

Amount of Changed Data

Throws:

java.sql.SQLException - in Case of Error

Since:

1.0

updateId

long updateId(java.lang.String sql)
       throws java.sql.SQLException

Execute SQL on Database and Return Id of new Row

Parameters:

sql - SQL to Execute

Returns:

PrimaryKey ID of new Row

Throws:

java.sql.SQLException - in Case of Error

Since:

1.0

get

java.sql.ResultSet get(java.lang.String sql)
                throws java.sql.SQLException

Return Data from Database

Parameters:

sql - SQL to Execute

Returns:

ResultSet with Data

Throws:

java.sql.SQLException - in Case of Error

Since:

1.0