dev.ursinn.java.databaselib.sql

Class Sql

java.lang.Object

dev.ursinn.java.databaselib.sql.Sql

All Implemented Interfaces:

ISql

Direct Known Subclasses:

MySql, PostgreSql, SqLite

public class Sql
extends java.lang.Object
implements ISql

SQL Database Template

Since:

1.0

Version:

1.0

Author:

Ursin Filli

Field Summary

Fields

Modifier and Type	Field and Description
protected java.sql.Connection	connection

Constructor Summary

Constructors

Constructor and Description
Sql() Constructor.

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

Methods inherited from class java.lang.Object

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

Field Detail

connection

protected java.sql.Connection connection

Constructor Detail

Sql

public Sql()

Constructor.

Method Detail

connect

public void connect()
             throws java.sql.SQLException

Description copied from interface: ISql

Connect to Database

Specified by:

connect in interface ISql

Throws:

java.sql.SQLException - in Case of Error

close

public final void close()
                 throws java.sql.SQLException

Description copied from interface: ISql

Close Connection to Database

Specified by:

close in interface ISql

Throws:

java.sql.SQLException - in Case of Error

isConnected

public final boolean isConnected()
                          throws java.sql.SQLException

Description copied from interface: ISql

Check if a Database Connection Exists

Specified by:

isConnected in interface ISql

Returns:

Status of Connection

Throws:

java.sql.SQLException - in Case of Error

update

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

Description copied from interface: ISql

Execute SQL on Database

Specified by:

update in interface ISql

Parameters:

sql - SQL to Execute

Returns:

Amount of Changed Data

Throws:

java.sql.SQLException - in Case of Error

updateId

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

Description copied from interface: ISql

Execute SQL on Database and Return Id of new Row

Specified by:

updateId in interface ISql

Parameters:

sql - SQL to Execute

Returns:

PrimaryKey ID of new Row

Throws:

java.sql.SQLException - in Case of Error

get

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

Description copied from interface: ISql

Return Data from Database

Specified by:

get in interface ISql

Parameters:

sql - SQL to Execute

Returns:

ResultSet with Data

Throws:

java.sql.SQLException - in Case of Error